RIC Exchange Codes

Question: A Reuters instrument code, or RIC, is a ticker-like code used by Thomson Reuters to identify financial instruments and indices. For equities, the RIC is a combination of the ticker and exchange code, delimited by a period ('.'). Given the trade table below for a single day, write a query that returns the total volume of trades per exchange. The expected columns are ric, size.

More Information:

https://en.wikipedia.org/wiki/Reuters_Instrument_Code

Example

                                
                                q)trade:([]ric:`AAPL.DE`AAPLE.MI`AAPL.MX`IBM.DE`IBM.F`MSFT.DE`MSFT.MX;px:282.9 281.6 7355.5 106.1 107.8 163.84 4257.01;size:1500 2352 3688 3318 1029 57213 7274)
q)trade
ric      px      size
----------------------
AAPL.DE  282.9   1500
AAPLE.MI 281.6   2352
AAPL.MX  7355.5  3688
IBM.DE   106.1   3318
IBM.F    107.8   1029
MSFT.DE  163.84  57213
MSFT.MX  4257.01 7274

==== Expected ====
ric size
---------
DE  62031
F   1029
MI  2352
MX  10962
                                
                            

Solution

Tags:
finance sql
Searchable Tags
algorithms api csv dictionaries feedhandler finance functions ingestion ipc iterators math optimizations realtime sql streaming strings tables temporal websockets

Email sent!

Email not sent