Data Retrieval - Book Depth#

This section contains examples for Data Retrieval - Book Depth 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__'

Book Depth at Quantity#

Calculate Book Depth Metrics such as Bid and Ask VWAP to trade 1000 shares every 60 seconds.

import onetick.py as otp

data = otp.DataSource(db='LSE_SAMPLE', tick_type='PRL_FULL')
data = data.ob_summary(bucket_interval=60, max_depth_shares=1000)
result = otp.run(data,
                 start=otp.dt(2024, 1, 3, 8),
                 end=otp.dt(2024, 1, 3, 16),
                 timezone='Europe/London',
                 symbols='VOD')
result
Time BID_SIZE BID_VWAP BEST_BID_PRICE WORST_BID_PRICE NUM_BID_LEVELS ASK_SIZE ASK_VWAP BEST_ASK_PRICE WORST_ASK_PRICE NUM_ASK_LEVELS
0 2024-01-03 08:01:00 1000 70.34594 70.36 70.34 3 1000 70.45 70.45 70.45 1
1 2024-01-03 08:02:00 1000 70.50100 70.51 70.50 2 1000 70.60 70.60 70.60 1
2 2024-01-03 08:03:00 1000 70.41000 70.41 70.41 1 1000 70.51 70.51 70.51 1
3 2024-01-03 08:04:00 1000 70.39000 70.39 70.39 1 1000 70.49 70.49 70.49 1
4 2024-01-03 08:05:00 1000 70.43000 70.43 70.43 1 1000 70.50 70.50 70.50 1
... ... ... ... ... ... ... ... ... ... ... ...
475 2024-01-03 15:56:00 1000 69.70000 69.70 69.70 1 1000 69.72 69.72 69.72 1
476 2024-01-03 15:57:00 1000 69.66000 69.66 69.66 1 1000 69.68 69.68 69.68 1
477 2024-01-03 15:58:00 1000 69.65000 69.65 69.65 1 1000 69.67 69.67 69.67 1
478 2024-01-03 15:59:00 1000 69.65000 69.65 69.65 1 1000 69.67 69.67 69.67 1
479 2024-01-03 16:00:00 1000 69.65000 69.65 69.65 1 1000 69.68 69.68 69.68 1

480 rows × 11 columns

Book Depth at Time#

Retrieving the Book to MBL (Market by Level) at a specified time.
PRL_FULL indicates that the table is actually a MBO (Market by Order) data set.

import onetick.py as otp

data = otp.DataSource(db='LSE_SAMPLE', tick_type='PRL_FULL')
data = data.ob_snapshot()
result = otp.run(data,
                 start=otp.dt(2024, 1, 3, 12),
                 end=otp.dt(2024, 1, 3, 12),
                 timezone='Europe/London',
                 symbols='VOD')
result
Time PRICE SIZE LEVEL UPDATE_TIME BUY_SELL_FLAG
0 2024-01-03 12:00:00 70.19 1974 1 2024-01-03 11:59:59.366 1
1 2024-01-03 12:00:00 70.20 9912 2 2024-01-03 11:59:59.427 1
2 2024-01-03 12:00:00 70.21 27733 3 2024-01-03 11:59:59.629 1
3 2024-01-03 12:00:00 70.22 24690 4 2024-01-03 11:59:54.521 1
4 2024-01-03 12:00:00 70.23 36108 5 2024-01-03 11:59:59.415 1
... ... ... ... ... ... ...
309 2024-01-03 12:00:00 58.85 100 138 2024-01-03 07:50:00.074 0
310 2024-01-03 12:00:00 57.50 8638 139 2024-01-03 07:50:02.453 0
311 2024-01-03 12:00:00 55.00 7500 140 2024-01-03 07:50:03.117 0
312 2024-01-03 12:00:00 50.00 1007 141 2024-01-03 07:50:02.007 0
313 2024-01-03 12:00:00 40.00 25000 142 2024-01-03 05:00:07.876 0

314 rows × 6 columns

Book Depth at Time to Max Levels#

Retrieving the Book to MBO (Market by Order) at a specified time.
The returned book is limited to a maximum number of price levels.

import onetick.py as otp

data = otp.DataSource(db='LSE_SAMPLE', tick_type='PRL_FULL')
data = data.ob_snapshot(max_levels=5)
result = otp.run(data,
                 start=otp.dt(2024, 1, 3, 12),
                 end=otp.dt(2024, 1, 3, 12),
                 timezone='Europe/London',
                 symbols='VOD')
result
Time PRICE SIZE LEVEL UPDATE_TIME BUY_SELL_FLAG
0 2024-01-03 12:00:00 70.19 1974 1 2024-01-03 11:59:59.366 1
1 2024-01-03 12:00:00 70.20 9912 2 2024-01-03 11:59:59.427 1
2 2024-01-03 12:00:00 70.21 27733 3 2024-01-03 11:59:59.629 1
3 2024-01-03 12:00:00 70.22 24690 4 2024-01-03 11:59:54.521 1
4 2024-01-03 12:00:00 70.23 36108 5 2024-01-03 11:59:59.415 1
5 2024-01-03 12:00:00 70.16 10967 1 2024-01-03 11:59:59.696 0
6 2024-01-03 12:00:00 70.15 24145 2 2024-01-03 11:59:59.367 0
7 2024-01-03 12:00:00 70.14 17779 3 2024-01-03 11:59:53.976 0
8 2024-01-03 12:00:00 70.13 27285 4 2024-01-03 11:59:59.461 0
9 2024-01-03 12:00:00 70.12 28100 5 2024-01-03 11:59:59.603 0

Book Depth at Time to Max Price Skew#

Retrieving the Book to MBO (Market by Order) at a specified time.
The returned book is limited to a maximum price skew 0.005 = 0.5%.

import onetick.py as otp

data = otp.DataSource(db='LSE_SAMPLE', tick_type='PRL_FULL')
data = data.ob_snapshot(max_depth_for_price=0.005)
result = otp.run(data,
                 start=otp.dt(2024, 1, 3, 12),
                 end=otp.dt(2024, 1, 3, 12),
                 timezone='Europe/London',
                 symbols='VOD')
result
Time PRICE SIZE LEVEL UPDATE_TIME BUY_SELL_FLAG
0 2024-01-03 12:00:00 70.19 1974 1 2024-01-03 11:59:59.366 1
1 2024-01-03 12:00:00 70.20 9912 2 2024-01-03 11:59:59.427 1
2 2024-01-03 12:00:00 70.21 27733 3 2024-01-03 11:59:59.629 1
3 2024-01-03 12:00:00 70.22 24690 4 2024-01-03 11:59:54.521 1
4 2024-01-03 12:00:00 70.23 36108 5 2024-01-03 11:59:59.415 1
... ... ... ... ... ... ...
67 2024-01-03 12:00:00 69.85 8089 32 2024-01-03 11:25:07.933 0
68 2024-01-03 12:00:00 69.84 4348 33 2024-01-03 11:59:14.405 0
69 2024-01-03 12:00:00 69.83 4120 34 2024-01-03 11:26:59.933 0
70 2024-01-03 12:00:00 69.82 9189 35 2024-01-03 11:32:05.842 0
71 2024-01-03 12:00:00 69.81 4245 36 2024-01-03 11:36:00.933 0

72 rows × 6 columns

Book Depth at Time to Max Shares#

Retrieving the Book to MBO (Market by Order) at a specified time.
The returned book is limited to a maximum amount of accumulated size.

import onetick.py as otp

data = otp.DataSource(db='LSE_SAMPLE', tick_type='PRL_FULL')
data = data.ob_snapshot(max_depth_shares=10000)
result = otp.run(data,
                 start=otp.dt(2024, 1, 3, 12),
                 end=otp.dt(2024, 1, 3, 12),
                 timezone='Europe/London',
                 symbols='VOD')
result
Time PRICE SIZE LEVEL UPDATE_TIME BUY_SELL_FLAG
0 2024-01-03 12:00:00 70.19 1974 1 2024-01-03 11:59:59.366 1
1 2024-01-03 12:00:00 70.20 9912 2 2024-01-03 11:59:59.427 1
2 2024-01-03 12:00:00 70.16 10967 1 2024-01-03 11:59:59.696 0

Book Depth at Time to Max Spread#

Retrieving the Book to MBO (Market by Order) at a specified time.
The returned book is limited to a maximum absolute spread.

import onetick.py as otp

data = otp.DataSource(db='LSE_SAMPLE', tick_type='PRL_FULL')
data = data.ob_snapshot(max_spread=1)
result = otp.run(data,
                 start=otp.dt(2024, 1, 3, 12),
                 end=otp.dt(2024, 1, 3, 12),
                 timezone='Europe/London',
                 symbols='VOD')
result
Time PRICE SIZE LEVEL UPDATE_TIME BUY_SELL_FLAG
0 2024-01-03 12:00:00 70.19 1974 1 2024-01-03 11:59:59.366 1
1 2024-01-03 12:00:00 70.20 9912 2 2024-01-03 11:59:59.427 1
2 2024-01-03 12:00:00 70.21 27733 3 2024-01-03 11:59:59.629 1
3 2024-01-03 12:00:00 70.22 24690 4 2024-01-03 11:59:54.521 1
4 2024-01-03 12:00:00 70.23 36108 5 2024-01-03 11:59:59.415 1
... ... ... ... ... ... ...
83 2024-01-03 12:00:00 69.82 9189 35 2024-01-03 11:32:05.842 0
84 2024-01-03 12:00:00 69.81 4245 36 2024-01-03 11:36:00.933 0
85 2024-01-03 12:00:00 69.80 4244 37 2024-01-03 11:55:31.933 0
86 2024-01-03 12:00:00 69.76 915 38 2024-01-03 07:50:02.578 0
87 2024-01-03 12:00:00 69.68 1000 39 2024-01-03 08:12:55.650 0

88 rows × 6 columns

Book Depth to MBO at Time#

Retrieving the Book to MBO (Market by Order) at a specified time.
Using parameter show_full_detail=True.

import onetick.py as otp

data = otp.DataSource(db='LSE_SAMPLE', tick_type='PRL_FULL')
data = data.ob_snapshot(show_full_detail=True)
result = otp.run(data,
                 start=otp.dt(2024, 1, 3, 12),
                 end=otp.dt(2024, 1, 3, 12),
                 timezone='Europe/London',
                 symbols='VOD')
result
Time BUY_SELL_FLAG DELETED_TIME OMDSEQ ORDER_ID ORDER_TYPE PART_ID PRICE RECORD_TYPE SIZE TICK_STATUS UPDATE_TYPE LEVEL UPDATE_TIME SOURCE
0 2024-01-03 12:00:00 1 1970-01-01 01:00:00.000 13 233402424600626977 L 70.19 R 1974 0 A 1 2024-01-03 11:59:53.991 VOD
1 2024-01-03 12:00:00 1 1970-01-01 01:00:00.000 2 233402424600623482 L 70.20 R 1052 0 M 2 2024-01-03 11:59:54.328 VOD
2 2024-01-03 12:00:00 1 1970-01-01 01:00:00.000 49 233402424600626943 L 70.20 R 4716 0 A 2 2024-01-03 11:59:53.921 VOD
3 2024-01-03 12:00:00 1 1970-01-01 01:00:00.000 98 233402424600627607 L 70.20 R 4144 0 A 2 2024-01-03 11:59:59.427 VOD
4 2024-01-03 12:00:00 1 1970-01-01 01:00:00.000 10 233402424600625943 L 70.21 R 11824 0 M 3 2024-01-03 11:59:54.522 VOD
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
664 2024-01-03 12:00:00 0 2024-01-03 07:50:02.453 6 233402424600036160 L 57.50 R 8638 16 A 139 2024-01-03 07:50:02.453 VOD
665 2024-01-03 12:00:00 0 2024-01-03 07:50:03.117 6 233402424600036385 L 55.00 R 3500 16 A 140 2024-01-03 07:50:03.117 VOD
666 2024-01-03 12:00:00 0 2024-01-03 07:50:00.073 6 233402424600035618 L 55.00 R 4000 16 A 140 2024-01-03 07:50:00.073 VOD
667 2024-01-03 12:00:00 0 2024-01-03 07:50:02.007 6 233402424600035890 L 50.00 R 1007 16 A 141 2024-01-03 07:50:02.007 VOD
668 2024-01-03 12:00:00 0 2024-01-03 05:00:07.876 6 233244094925636438 L 40.00 R 25000 16 A 142 2024-01-03 05:00:07.876 VOD

669 rows × 15 columns

Consolidated Book at Time by Database List#

Returning a Consolidated Book at a Point in Time, specifying 1 symbol and 3 different databases.
The same instrument trades on several venues, each held in its own database.
Passing the list of databases to otp.ObSnapshot builds a single order book across all of them for the one symbol.
The schema is forced for the venue specific fields such as ORDER_ID and ORIGINAL_ORDER_ID.

import onetick.py as otp

ob_snap = otp.ObSnapshot(
    db=['NYSE', 'NASDAQ', 'ARCA'],
    tick_type='PRL_FULL',
    symbol='CSCO',
    show_full_detail=True,
    max_levels=5,
    # Force schema for venue specific fields such as ORDER_ID and ORIGINAL_ORDER_ID
    schema={'ORDER_ID': str, 'ORIGINAL_ORDER_ID': str},
)
ob_snap = ob_snap[['PRICE', 'SIZE', 'LEVEL', 'UPDATE_TIME', 'BUY_SELL_FLAG', 'SOURCE',
                   'ORDER_ID', 'ORIGINAL_ORDER_ID']]

result = otp.run(ob_snap,
                 start=otp.dt(2026, 9, 1, 12),
                 end=otp.dt(2026, 9, 1, 12),
                 timezone='America/New_York')
result

Time

PRICE

SIZE

LEVEL

UPDATE_TIME

BUY_SELL_FLAG

SOURCE

ORDER_ID

ORIGINAL_ORDER_ID

0

2026-09-01 12:00:00

109.14

20

1

2026-09-01 11:59:52.720710173

1

ARCA::CSCO

3099523321641018

3099523321641018

1

2026-09-01 12:00:00

109.14

4

1

2026-09-01 11:59:59.472127565

1

ARCA::CSCO

3099523321657713

3099523321657713

2

2026-09-01 12:00:00

109.14

600

1

2026-09-01 11:59:49.151792734

1

NASDAQ::CSCO

677932018

677932018

3

2026-09-01 12:00:00

109.14

100

1

2026-09-01 11:59:51.094427442

1

NASDAQ::CSCO

678038646

678038646

4

2026-09-01 12:00:00

109.15

100

2

2026-09-01 11:59:41.717908510

1

ARCA::CSCO

3099523321609734

3099523321609734

..

…

…

…

…

…

…

…

…

…

92

2026-09-01 12:00:00

109.09

11

5

2026-09-01 11:59:19.063619465

0

NYSE::CSCO

3941749208074032

3941749208074032

93

2026-09-01 12:00:00

109.09

10

5

2026-09-01 11:59:19.063606052

0

ARCA::CSCO

3099523321534917

3099523321534917

94

2026-09-01 12:00:00

109.09

100

5

2026-09-01 11:58:53.451079951

0

ARCA::CSCO

3099523321475913

3099523321475913

95

2026-09-01 12:00:00

109.09

4

5

2026-09-01 11:58:50.007440425

0

ARCA::CSCO

3099523321467831

3099523321467831

96

2026-09-01 12:00:00

109.09

25

5

2026-09-01 11:58:45.632718122

0

ARCA::CSCO

3099523321455429

3099523321455429

Consolidated Book at Time by Symbol List#

Returning a Consolidated Book at a Point in Time, specifying 3 different symbols (the same company across 3 different databases).
Each venue holds the instrument in its own database, so the symbol is qualified with the database name using the DB::SYMBOL form.
otp.ObSnapshot builds a single order book across all of them.
As no single db is given, the schema cannot be inferred and is specified explicitly.
SOURCE must be present in the tick descriptor whenever show_full_detail is set and the order book has multiple inputs.

import onetick.py as otp

ob_snap = otp.ObSnapshot(
    tick_type='PRL_FULL',
    symbol=['NYSE::CSCO', 'NASDAQ::CSCO', 'ARCA::CSCO'],
    show_full_detail=True,
    max_levels=5,
    schema={'PRICE': float,
            'SIZE': int,
            'BUY_SELL_FLAG': int,
            'DELETED_TIME': otp.nsectime,
            'ORDER_ID': str,
            'ORIGINAL_ORDER_ID': str,
            'SOURCE': otp.string[32]},
)

result = otp.run(ob_snap,
                 start=otp.dt(2026, 9, 1, 12),
                 end=otp.dt(2026, 9, 1, 12),
                 timezone='America/New_York')
result

Time

PRICE

SIZE

BUY_SELL_FLAG

ORDER_ID

ORIGINAL_ORDER_ID

…

OLD_PRICE_LEVEL

ORDER_POSITION

OLD_ORDER_POSITION

SIZE_AHEAD

RECORD_TYPE

0

2026-09-01 12:00:00

109.14

20

1

3099523321641018

3099523321641018

…

0

3

0

29

R

1

2026-09-01 12:00:00

109.14

4

1

3099523321657713

3099523321657713

…

0

2

0

20

R

2

2026-09-01 12:00:00

109.14

600

1

677932018

677932018

…

0

5

0

108

R

3

2026-09-01 12:00:00

109.14

100

1

678038646

678038646

…

0

2

0

600

R

4

2026-09-01 12:00:00

109.15

100

1

3099523321609734

3099523321609734

…

0

8

0

82

R

..

…

…

…

…

…

…

…

…

…

…

…

…

92

2026-09-01 12:00:00

109.09

11

0

3941749208074032

3941749208074032

…

0

1

0

0

R

93

2026-09-01 12:00:00

109.09

10

0

3099523321534917

3099523321534917

…

0

17

0

920

R

94

2026-09-01 12:00:00

109.09

100

0

3099523321475913

3099523321475913

…

0

8

0

354

R

95

2026-09-01 12:00:00

109.09

4

0

3099523321467831

3099523321467831

…

0

2

0

25

R

96

2026-09-01 12:00:00

109.09

25

0

3099523321455429

3099523321455429

…

0

2

0

4

R

Order Book Bars#

Calculate 1 minute bars for book depth down to 5 levels from the LSE_SAMPLE database, and PRL_FULL table.
Each output row showing a Book Level, Side and Time (Bid and Ask on different rows).

import onetick.py as otp

data = otp.DataSource(db='LSE_SAMPLE', tick_type='PRL_FULL')
data = data.ob_snapshot(bucket_interval=60, max_levels=5)
# Return first 100 Rows
data = data.limit(100)
result = otp.run(data,
                 start=otp.dt(2024, 1, 3, 8),
                 end=otp.dt(2024, 1, 3, 16),
                 timezone='Europe/London',
                 symbols='VOD')
result
Time PRICE SIZE LEVEL UPDATE_TIME BUY_SELL_FLAG
0 2024-01-03 08:01:00 70.45 5657 1 2024-01-03 08:00:59.243 1
1 2024-01-03 08:01:00 70.47 12161 2 2024-01-03 08:00:59.792 1
2 2024-01-03 08:01:00 70.48 108029 3 2024-01-03 08:00:58.503 1
3 2024-01-03 08:01:00 70.49 27858 4 2024-01-03 08:00:59.262 1
4 2024-01-03 08:01:00 70.50 20344 5 2024-01-03 08:00:59.056 1
... ... ... ... ... ... ...
95 2024-01-03 08:10:00 70.48 4251 1 2024-01-03 08:09:55.303 0
96 2024-01-03 08:10:00 70.47 100 2 2024-01-03 08:09:59.798 0
97 2024-01-03 08:10:00 70.46 16130 3 2024-01-03 08:09:59.041 0
98 2024-01-03 08:10:00 70.45 24564 4 2024-01-03 08:09:59.801 0
99 2024-01-03 08:10:00 70.44 20566 5 2024-01-03 08:09:30.629 0

100 rows × 6 columns

Order Book Flat Bars#

Calculate 1 minute bars for book depth down to 5 levels from the LSE_SAMPLE database, and PRL_FULL table.
Each output row showing the book at a specific time (many output columns for bids and asks at selected levels).

import onetick.py as otp

data = otp.DataSource(db='LSE_SAMPLE', tick_type='PRL_FULL')
data = data.ob_snapshot_flat(bucket_interval=60, max_levels=5)
result = otp.run(data,
                 start=otp.dt(2024, 1, 3, 8),
                 end=otp.dt(2024, 1, 3, 16),
                 timezone='Europe/London',
                 symbols='VOD')
result
Time BID_PRICE1 BID_SIZE1 BID_UPDATE_TIME1 ASK_PRICE1 ASK_SIZE1 ASK_UPDATE_TIME1 BID_PRICE2 BID_SIZE2 BID_UPDATE_TIME2 ... BID_UPDATE_TIME4 ASK_PRICE4 ASK_SIZE4 ASK_UPDATE_TIME4 BID_PRICE5 BID_SIZE5 BID_UPDATE_TIME5 ASK_PRICE5 ASK_SIZE5 ASK_UPDATE_TIME5
0 2024-01-03 08:01:00 70.36 247 2024-01-03 08:00:59.796 70.45 5657 2024-01-03 08:00:59.243 70.35 100 2024-01-03 08:00:59.243 ... 2024-01-03 08:00:59.796 70.49 27858 2024-01-03 08:00:59.262 70.32 6398 2024-01-03 08:00:58.187 70.50 20344 2024-01-03 08:00:59.056
1 2024-01-03 08:02:00 70.51 100 2024-01-03 08:01:59.461 70.60 2236 2024-01-03 08:01:58.413 70.50 1528 2024-01-03 08:01:59.461 ... 2024-01-03 08:01:57.911 70.63 27494 2024-01-03 08:01:58.613 70.47 9783 2024-01-03 08:01:57.702 70.64 26717 2024-01-03 08:01:59.013
2 2024-01-03 08:03:00 70.41 6814 2024-01-03 08:02:47.187 70.51 5093 2024-01-03 08:02:47.190 70.40 12411 2024-01-03 08:02:58.047 ... 2024-01-03 08:02:53.664 70.55 24048 2024-01-03 08:02:46.535 70.37 33771 2024-01-03 08:02:53.228 70.56 29900 2024-01-03 08:02:50.395
3 2024-01-03 08:04:00 70.39 1381 2024-01-03 08:03:57.934 70.49 7154 2024-01-03 08:03:57.933 70.38 7012 2024-01-03 08:03:57.945 ... 2024-01-03 08:03:59.065 70.52 41389 2024-01-03 08:03:58.233 70.35 8462 2024-01-03 08:03:55.984 70.53 16198 2024-01-03 08:03:57.934
4 2024-01-03 08:05:00 70.43 2682 2024-01-03 08:04:59.431 70.50 4716 2024-01-03 08:04:54.898 70.42 7867 2024-01-03 08:04:54.544 ... 2024-01-03 08:04:54.638 70.53 28692 2024-01-03 08:04:57.025 70.39 23024 2024-01-03 08:04:55.976 70.54 19374 2024-01-03 08:04:54.870
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
475 2024-01-03 15:56:00 69.70 12253 2024-01-03 15:55:57.273 69.72 41965 2024-01-03 15:55:57.311 69.69 34671 2024-01-03 15:55:57.873 ... 2024-01-03 15:55:58.067 69.75 41210 2024-01-03 15:55:57.559 69.66 39432 2024-01-03 15:55:57.873 69.76 35930 2024-01-03 15:55:57.272
476 2024-01-03 15:57:00 69.66 9432 2024-01-03 15:56:55.839 69.68 1355 2024-01-03 15:56:58.513 69.65 55792 2024-01-03 15:56:58.513 ... 2024-01-03 15:56:55.937 69.71 27985 2024-01-03 15:56:37.844 69.62 48358 2024-01-03 15:56:52.680 69.72 54166 2024-01-03 15:56:58.513
477 2024-01-03 15:58:00 69.65 4716 2024-01-03 15:57:59.779 69.67 6000 2024-01-03 15:57:59.832 69.64 24235 2024-01-03 15:57:59.780 ... 2024-01-03 15:57:59.779 69.70 29837 2024-01-03 15:57:59.819 69.61 47887 2024-01-03 15:57:59.781 69.71 48349 2024-01-03 15:57:58.759
478 2024-01-03 15:59:00 69.65 21004 2024-01-03 15:58:56.984 69.67 4716 2024-01-03 15:58:59.940 69.64 45649 2024-01-03 15:58:52.189 ... 2024-01-03 15:58:57.085 69.70 59837 2024-01-03 15:58:48.805 69.61 37037 2024-01-03 15:58:56.984 69.71 30449 2024-01-03 15:58:59.998
479 2024-01-03 16:00:00 69.65 17723 2024-01-03 15:59:59.915 69.68 10616 2024-01-03 15:59:59.918 69.64 42898 2024-01-03 15:59:53.614 ... 2024-01-03 15:59:58.397 69.71 65337 2024-01-03 15:59:59.915 69.61 25517 2024-01-03 15:59:59.915 69.72 34346 2024-01-03 15:59:41.322

480 rows × 31 columns

Order Book Updates#

Retrieve the changes in the Book across time.

import onetick.py as otp

data = otp.DataSource(db='LSE_SAMPLE', tick_type='PRL_FULL')
data = data.ob_snapshot(running=True, show_only_changes=True)
# Return first 100 Rows
data = data.limit(100)
result = otp.run(data,
                 start=otp.dt(2024, 1, 3, 8),
                 end=otp.dt(2024, 1, 3, 9),
                 timezone='Europe/London',
                 symbols='VOD')
result
Time PRICE SIZE LEVEL UPDATE_TIME BUY_SELL_FLAG
0 2024-01-03 08:00:00 59.30 17048 1 2024-01-03 07:58:05.142 1
1 2024-01-03 08:00:00 66.49 24478 2 2024-01-03 07:50:48.472 1
2 2024-01-03 08:00:00 68.00 6000 3 2024-01-03 07:50:00.075 1
3 2024-01-03 08:00:00 68.45 2642 4 2024-01-03 07:59:58.750 1
4 2024-01-03 08:00:00 68.57 2642 5 2024-01-03 07:59:59.968 1
... ... ... ... ... ... ...
95 2024-01-03 08:00:00 82.00 29602 96 2024-01-03 07:50:03.129 1
96 2024-01-03 08:00:00 82.50 1544 97 2024-01-03 07:50:00.073 1
97 2024-01-03 08:00:00 82.53 570 98 2024-01-03 07:51:00.488 1
98 2024-01-03 08:00:00 82.75 1200 99 2024-01-03 07:50:00.075 1
99 2024-01-03 08:00:00 83.00 3234 100 2024-01-03 07:50:02.404 1

100 rows × 6 columns

Order Book Wide Bars#

Calculate 1 minute bars for book depth down to 5 levels from the LSE_SAMPLE database, and PRL_FULL table.
Each output row showing a Book Level and Time (Bid and Ask on same row).

import onetick.py as otp

data = otp.DataSource(db='LSE_SAMPLE', tick_type='PRL_FULL')
data = data.ob_snapshot_wide(bucket_interval=60, max_levels=5)
# Return first 100 Rows
data = data.limit(100)
result = otp.run(data,
                 start=otp.dt(2024, 1, 3, 8),
                 end=otp.dt(2024, 1, 3, 16),
                 timezone='Europe/London',
                 symbols='VOD')
result
Time BID_PRICE BID_SIZE BID_UPDATE_TIME ASK_PRICE ASK_SIZE ASK_UPDATE_TIME LEVEL
0 2024-01-03 08:01:00 70.36 247 2024-01-03 08:00:59.796 70.45 5657 2024-01-03 08:00:59.243 1
1 2024-01-03 08:01:00 70.35 100 2024-01-03 08:00:59.243 70.47 12161 2024-01-03 08:00:59.792 2
2 2024-01-03 08:01:00 70.34 6657 2024-01-03 08:00:59.792 70.48 108029 2024-01-03 08:00:58.503 3
3 2024-01-03 08:01:00 70.33 6377 2024-01-03 08:00:59.796 70.49 27858 2024-01-03 08:00:59.262 4
4 2024-01-03 08:01:00 70.32 6398 2024-01-03 08:00:58.187 70.50 20344 2024-01-03 08:00:59.056 5
... ... ... ... ... ... ... ... ...
95 2024-01-03 08:20:00 70.33 450 2024-01-03 08:19:53.329 70.37 10316 2024-01-03 08:19:53.330 1
96 2024-01-03 08:20:00 70.32 9074 2024-01-03 08:19:55.363 70.38 4716 2024-01-03 08:19:46.498 2
97 2024-01-03 08:20:00 70.31 8815 2024-01-03 08:19:53.330 70.39 25851 2024-01-03 08:19:46.504 3
98 2024-01-03 08:20:00 70.30 19903 2024-01-03 08:19:46.504 70.40 25838 2024-01-03 08:19:27.607 4
99 2024-01-03 08:20:00 70.29 22943 2024-01-03 08:19:53.329 70.41 37204 2024-01-03 08:19:53.329 5

100 rows × 8 columns