Symbol Universe#
This section contains examples for Symbol_Universe using the onetick-py.
Each example is a self-contained script that can be run against the OneTick Cloud sample databases.
# onetick-py WebAPI configuration for OneTick Cloud
import os
os.environ['OTP_WEBAPI'] = '1'
os.environ['OTP_HTTP_ADDRESS'] = 'https://rest.cloud.onetick.com'
os.environ['OTP_ACCESS_TOKEN_URL'] = 'https://cloud-auth.parent.onetick.com/realms/OMD/protocol/openid-connect/token'
os.environ['OTP_CLIENT_ID'] = '__FILL_IN__'
os.environ['OTP_CLIENT_SECRET'] = '__FILL_IN__'
Symbol Universe with Mask#
Query trades for all symbols matching a pattern for today.
Retrieves trade data for symbols starting with AAA from the US equities composite database.
import onetick.py as otp
# Define the masked symbol list (e.g., all symbols starting with 'AAA')
symbols = otp.Symbols(db='US_COMP', pattern='AAA%', for_tick_type='TRD')
# Define the trades data source (do not specify symbols here)
trades = otp.DataSource(db='US_COMP', tick_type='TRD')
# merge all symbols
trades = otp.merge([trades], symbols=symbols, identify_input_ts=True)
# Run the query for the masked symbol list for today
result = otp.run(
trades,
date=otp.dt.now().date(),
timezone='America/New_York',
)
result
Time |
AGGRESSOR_SIDE |
BOOK_TYPE |
COND |
CORR |
EXCHANGE |
… |
TRADE_PERIOD |
TRADE_TYPE |
TRF |
TRF_TIME |
TTE |
SYMBOL_NAME |
TICK_TYPE |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 |
2026-08-06 04:00:00.031017295 |
0 |
FT |
0 |
P |
… |
E |
FT |
1969-12-31 19:00:00.000000000 |
1 |
AAAU |
TRD |
||
1 |
2026-08-06 04:00:02.621367162 |
9 |
T |
0 |
D |
… |
E |
T |
N |
2026-08-06 04:00:02.621345555 |
0 |
AAAU |
TRD |
|
2 |
2026-08-06 04:00:06.891092937 |
9 |
TI |
0 |
D |
… |
E |
TI |
T |
2026-08-06 04:00:06.890724538 |
0 |
AAAU |
TRD |
|
3 |
2026-08-06 04:00:07.001389565 |
9 |
TI |
0 |
D |
… |
E |
TI |
T |
2026-08-06 04:00:07.001029603 |
0 |
AAAU |
TRD |
|
4 |
2026-08-06 04:00:07.331599873 |
9 |
TI |
0 |
D |
… |
E |
TI |
T |
2026-08-06 04:00:07.331239278 |
0 |
AAAU |
TRD |
|
… |
… |
… |
… |
… |
… |
… |
… |
… |
… |
… |
… |
… |
… |
… |
431 |
2026-08-06 09:33:24.818020093 |
0 |
F |
0 |
K |
… |
- |
F |
1969-12-31 19:00:00.000000000 |
1 |
AAAU |
TRD |
||
432 |
2026-08-06 09:33:24.818022049 |
0 |
F |
0 |
Z |
… |
- |
F |
1969-12-31 19:00:00.000000000 |
0 |
AAAU |
TRD |
||
433 |
2026-08-06 09:33:24.818025613 |
0 |
F |
0 |
Z |
… |
- |
F |
1969-12-31 19:00:00.000000000 |
0 |
AAAU |
TRD |
||
434 |
2026-08-06 09:33:24.818259569 |
0 |
I |
0 |
T |
… |
- |
I |
1969-12-31 19:00:00.000000000 |
0 |
AAAU |
TRD |
||
435 |
2026-08-06 09:33:24.818265881 |
0 |
I |
0 |
T |
… |
- |
I |
1969-12-31 19:00:00.000000000 |
0 |
AAAU |
TRD |
436 rows x 26 columns
Symbol Universe for DB#
Returns static symbol information and security descriptors for all London Stock Exchange instruments.
The SYMBOL_UNIVERSE database’s STAT table is queried by symbol pattern,
matching every SYMBOL_NAME starting with 'LSE '.
import onetick.py as otp
data = otp.DataSource(db='SYMBOL_UNIVERSE', tick_type='STAT')
# Merge every SYMBOL_UNIVERSE entry starting with 'LSE ' into a single stream.
data = otp.merge([data],
symbols=otp.Symbols('SYMBOL_UNIVERSE', pattern='LSE %', for_tick_type='STAT'),
identify_input_ts=True)
data = data.limit(100)
result = otp.run(data,
start=otp.dt(2024, 1, 3),
end=otp.dt(2024, 1, 4),
timezone='UTC')
result
| Time | BSYM | CALL_PUT_IND | CFI_CODE | CONTRACT_SIZE | CURRENCY | CUS | DB_NAME | DB_SYMBOL | EXCH_SYMBOL | ... | SIP_SYMBOL | STRATEGY_TYPE | STRIKE_PRICE | TICK_SIZE | TICK_VALUE | TRADING_CODE | UNDERLYING_SEC_TYPE | UNDERLYING_SYMBOL | SYMBOL_NAME | TICK_TYPE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2024-01-03 04:00:00 | NaN | USD | LSE | AP30 | AP30 | ... | NaN | NaN | 168064 | LSE Corporate Bond | STAT | |||||||||
| 1 | 2024-01-03 04:00:00 | NaN | USD | LSE | KR03 | KR03 | ... | NaN | NaN | 168066 | LSE Corporate Bond | STAT | |||||||||
| 2 | 2024-01-03 04:00:00 | NaN | USD | LSE | DA30 | DA30 | ... | NaN | NaN | 168068 | LSE Corporate Bond | STAT | |||||||||
| 3 | 2024-01-03 04:00:00 | NaN | SGD | LSE | EW41 | EW41 | ... | NaN | NaN | 168065 | LSE Corporate Bond | STAT | |||||||||
| 4 | 2024-01-03 04:00:00 | NaN | USD | LSE | MT29 | MT29 | ... | NaN | NaN | 168067 | LSE Corporate Bond | STAT | |||||||||
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 95 | 2024-01-03 04:00:00 | NaN | GBP | LSE | 06LC | 06LC | ... | NaN | NaN | 9136 | LSE Warrant | STAT | |||||||||
| 96 | 2024-01-03 04:00:00 | NaN | GBP | LSE | 06NL | 06NL | ... | NaN | NaN | 3266 | LSE Corporate Bond | STAT | |||||||||
| 97 | 2024-01-03 04:00:00 | NaN | EUR | LSE | 06OP | 06OP | ... | NaN | NaN | 10304 | LSE Corporate Bond | STAT | |||||||||
| 98 | 2024-01-03 04:00:00 | NaN | CHF | LSE | 06OZ | 06OZ | ... | NaN | NaN | 10448 | LSE Bond | STAT | |||||||||
| 99 | 2024-01-03 04:00:00 | NaN | GBP | LSE | 07GH | 07GH | ... | NaN | NaN | 2969 | LSE Corporate Bond | STAT |
100 rows × 34 columns
Symbol Universe for DB and Sec Type#
Returns static symbol information and security descriptors for London Stock Exchange equity instruments,
filtered to the LSE Equity classification.
import onetick.py as otp
data = otp.DataSource(db='SYMBOL_UNIVERSE', tick_type='STAT')
data = data.limit(100)
result = otp.run(data,
start=otp.dt(2024, 1, 3),
end=otp.dt(2024, 1, 4),
timezone='UTC',
symbols='LSE Equity')
result
| Time | STRIKE_PRICE | CONTRACT_SIZE | TICK_VALUE | DB_NAME | NAME | EXCH_SYMBOL | DB_SYMBOL | OID | BSYM | ... | MKT_SEGMENT | CURRENCY | EXPIRATION_DATE | CALL_PUT_IND | PRODUCT_CODE | STRATEGY_TYPE | UNDERLYING_SYMBOL | SIP_SYMBOL | TICK_SIZE | OMDSEQ | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2024-01-03 04:00:00 | NaN | NaN | NaN | LSE | Groupe Parot | 0A04 | 0A04 | 1015725922 | 0A04 LN Equity | ... | SSX4 | EUR | 124 | |||||||
| 1 | 2024-01-03 04:00:00 | NaN | NaN | NaN | LSE | Medacta Group SA | 0A05 | 0A05 | 1015743877 | 0A05 LN Equity | ... | SSX4 | CHF | 125 | |||||||
| 2 | 2024-01-03 04:00:00 | NaN | NaN | NaN | LSE | Stadler Rail AG | 0A0C | 0A0C | 1015747442 | 0A0C LN Equity | ... | SSX4 | CHF | 132 | |||||||
| 3 | 2024-01-03 04:00:00 | NaN | NaN | NaN | LSE | Societa Editoriale Il Fatto Spa | 0A0G | 0A0G | 1015758539 | 0A0G LN Equity | ... | SSX4 | EUR | 133 | |||||||
| 4 | 2024-01-03 04:00:00 | NaN | NaN | NaN | LSE | Twenty First Century Fox A Inc | 0A0X | 0A0X | 1015762601 | 0A0X LN Equity | ... | SSX4 | EUR | 135 | |||||||
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 95 | 2024-01-03 04:00:00 | NaN | NaN | NaN | LSE | Carvana Co | 0A79 | 0A79 | 1017932850 | 0A79 LN Equity | ... | SSX4 | USD | 276 | |||||||
| 96 | 2024-01-03 04:00:00 | NaN | NaN | NaN | LSE | Chimera Investment Corp | 0A7B | 0A7B | 1017937342 | 0A7B LN Equity | ... | SSX4 | USD | 277 | |||||||
| 97 | 2024-01-03 04:00:00 | NaN | NaN | NaN | LSE | Dell Technologies Inc | 0A7D | 0A7D | 1017937344 | 0A7D LN Equity | ... | SSX4 | USD | 278 | |||||||
| 98 | 2024-01-03 04:00:00 | NaN | NaN | NaN | LSE | Dominos Pizza Inc | 0A7E | 0A7E | 1017937345 | 0A7E LN Equity | ... | SSX4 | USD | 279 | |||||||
| 99 | 2024-01-03 04:00:00 | NaN | NaN | NaN | LSE | Huuuge Inc | 0A7J | 0A7J | 1017973804 | 0A7J LN Equity | ... | SSX4 | EUR | 283 |
100 rows × 26 columns