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