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 architecture csv data structures dictionaries disk feedhandler finance functions ingestion ipc iterators math multithreading optimizations realtime sql streaming strings tables temporal websockets

Email sent!

Email not sent