core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| net_sidetext |
|---|
| underlying_pricenumeric |
|---|
| bid_ask_spreadnumeric |
|---|
| strikesjsonb |
|---|
| ivsjsonb |
|---|
| breakevensjsonb |
|---|
| uniq_exchangesjsonb |
|---|
| min_strikenumeric |
|---|
| max_strikenumeric |
|---|
| min_dteinteger |
|---|
| max_dteinteger |
|---|
| all_opening_legsboolean |
|---|
| all_otmboolean |
|---|
| diff_expirationsboolean |
|---|
| diff_strikesboolean |
|---|
| diff_typesboolean |
|---|
| codetext |
|---|
| kept_bytext |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| 01a0ca64-9d77-7fe3-b42e-3fd012f8a590 | IBIT | 2026-09-22 14:33 | call_diagonal_spread | 2 | 1 | 15 | 115650.00 | long | ask | 48.8700 | 2.0000 | ["10","15"] | ["0.7451","0.6802"] | [] | ["XCBO"] | 10.0000 | 15.0000 | 815 | 850 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:33:49Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca59-3397-7440-8a94-2b1b2e1cbe5b | IBIT | 2026-09-22 14:20 | call_diagonal_spread | 2 | 1 | 100 | 142200.00 | long | ask | 49.0350 | 0.2500 | ["43","44"] | ["0.4380","0.4277"] | [] | ["AMXO"] | 43.0000 | 44.0000 | 24 | 115 | false | false | true | ||||||||||
| 01a0ca59-200f-75c1-b784-cd30786ec22d | IBIT | 2026-09-22 14:20 | call_diagonal_spread | 2 | 1 | 98 | 139356.00 | long | ask | 49.0350 | 0.2500 | ["43","44"] | ["0.4380","0.4277"] | [] | ["AMXO"] | 43.0000 | 44.0000 | 24 | 115 | false | false | true | ||||||||||
| 01a0ca59-200f-75c1-b784-cd2bd0437a58 | IBIT | 2026-09-22 14:20 | call_diagonal_spread | 2 | 1 | 100 | 142200.00 | long | ask | 49.0350 | 0.2500 | ["43","44"] | ["0.4380","0.4277"] | [] | ["AMXO"] | 43.0000 | 44.0000 | 24 | 115 | false | false | true | ||||||||||
| 01a0ca59-200f-75c1-b784-cd193c037341 | IBIT | 2026-09-22 14:20 | call_diagonal_spread | 2 | 1 | 100 | 142200.00 | long | ask | 49.0350 | 0.2500 | ["43","44"] | ["0.4380","0.4277"] | [] | ["ARCO"] | 43.0000 | 44.0000 | 24 | 115 | false | false | true | ||||||||||
| 01a0c569-31a7-7991-aa0d-8a535debde5f | IBIT | 2026-09-21 15:19 | call_diagonal_spread | 2 | 1 | 100 | 130600.00 | long | ask | 48.8950 | 0.1700 | ["40","48"] | ["0.4463","0.4444"] | [] | ["XISX"] | 40.0000 | 48.0000 | 4 | 179 | false | false | true | ||||||||||
| 01a0c4e9-b107-7ce1-b7ce-b9f63ab48ed6 | IBIT | 2026-09-21 13:00 | call_diagonal_spread | 2 | 1 | 150 | 168900.00 | unknown | ask | 48.7150 | 0.1600 | ["50","57"] | ["0.4619","0.4519"] | [] | ["XMIO"] | 50.0000 | 57.0000 | 25 | 487 | false | true | true | ||||||||||
| 01a0c46b-a37f-7fd0-9640-756f6e0d11cc | IBIT | 2026-09-21 10:43 | call_diagonal_spread | 2 | 1 | 3600 | 1699200.00 | short | ask | 48.6200 | 0.0400 | ["46","48"] | ["0.5334","0.4478"] | [] | ["EDGO"] | 46.0000 | 48.0000 | 4 | 11 | false | false | true | ||||||||||
| 01a0c453-fccf-7dd0-9b99-10790d3005e7 | IBIT | 2026-09-21 10:17 | call_diagonal_spread | 2 | 1 | 341 | 370667.00 | short | ask | 48.3900 | 0.1300 | ["40","54"] | ["0.5087","0.4265"] | [] | ["XCBO"] | 40.0000 | 54.0000 | 25 | 88 | false | false | true | ||||||||||
| 01a0c450-ad27-7b90-84fc-389bdc76a244 | IBIT | 2026-09-21 10:13 | call_diagonal_spread | 2 | 1 | 93 | 140988.00 | short | ask | 48.2900 | 0.2000 | ["39","42.5"] | ["1.2175","0.6677"] | [] | ["XCBO"] | 39.0000 | 42.5000 | 2 | 4 | false | false | true | ||||||||||
| 01a0c44a-0dd7-7053-b7b3-ee36431ea774 | IBIT | 2026-09-21 10:06 | call_diagonal_spread | 2 | 2 | 271 | 176692.00 | unknown | ask | 48.1800 | 0.1380 | ["45","48.5"] | ["0.4095","0.3999"] | [] | ["XISX","XMIO"] | 45.0000 | 48.5000 | 25 | 39 | false | false | true | ||||||||||
| 01a0c448-92ef-77e0-9672-ac99e3b62530 | IBIT | 2026-09-21 10:04 | call_diagonal_spread | 2 | 2 | 92 | 112948.00 | short | ask | 48.2800 | 0.2500 | ["43","45"] | ["0.4379","0.4220"] | [] | ["AMXO","XISX"] | 43.0000 | 45.0000 | 60 | 70 | false | false | true | ||||||||||
| 01a0b60d-e27f-72b3-af01-bab1f1c7289a | IBIT | 2026-09-18 15:45 | call_diagonal_spread | 2 | 2 | 1703 | 127725.00 | unknown | ask | 45.9901 | 0.0300 | ["46","50"] | ["1.1039","0.3815"] | [] | ["AMXO"] | 46.0000 | 50.0000 | 0 | 28 | false | true | true | ||||||||||
| 01a0b547-fe57-7f83-81a7-8a6156b609cb | IBIT | 2026-09-18 12:09 | call_diagonal_spread | 2 | 1 | 3400 | 2352800.00 | short | ask | 45.7650 | 0.1700 | ["48","65"] | ["0.4100","0.4315"] | [] | ["ARCO"] | 48.0000 | 65.0000 | 182 | 272 | false | true | true | ||||||||||
| 01a0b53f-bd0f-77a3-bf45-feee01b16fc6 | IBIT | 2026-09-18 12:00 | call_diagonal_spread | 2 | 3 | 384 | 136704.00 | long | ask | 45.7500 | 0.0778 | ["44","46"] | ["1.1671","0.3686"] | [] | ["EMLD","SPHR","XPHO"] | 44.0000 | 46.0000 | 0 | 28 | false | false | true | ||||||||||
| 01a0b4fd-7450-7b11-87a6-24813df1ae5c | IBIT | 2026-09-18 10:48 | call_diagonal_spread | 2 | 1 | 1450 | 970050.00 | short | ask | 45.8215 | 0.1200 | ["41","46"] | ["2.3964","0.3732"] | [] | ["XCBO"] | 41.0000 | 46.0000 | 0 | 28 | false | false | true | ||||||||||
| 01a0b4dd-5990-7350-a6ea-37c47b887738 | IBIT | 2026-09-18 10:13 | call_diagonal_spread | 2 | 1 | 1515 | 1204423.00 | short | ask | 45.4600 | 0.1900 | ["40","50"] | ["0.4184","0.3941"] | [] | ["XCBO"] | 40.0000 | 50.0000 | 28 | 91 | false | false | true | ||||||||||
| 01a0a596-8906-7ab0-855c-774e7d18b1be | IBIT | 2026-09-15 11:01 | call_diagonal_spread | 2 | 1 | 40 | 121200.00 | short | ask | 42.9000 | 0.7000 | ["40","45"] | ["0.5331","0.5250"] | [] | ["XISX"] | 40.0000 | 45.0000 | 822 | 857 | false | false | true | ||||||||||
| 01a0a105-8448-7d02-a433-c86039f853d4 | IBIT | 2026-09-14 13:44 | call_diagonal_spread | 2 | 1 | 365 | 326310.00 | long | ask | 44.6401 | 0.2200 | ["42","43"] | ["0.4148","0.3863"] | [] | ["XMIO"] | 42.0000 | 43.0000 | 32 | 123 | false | false | true | ||||||||||
| 01a09116-6a48-7ff2-9e64-f650ea713bee | IBIT | 2026-09-11 11:29 | call_diagonal_spread | 2 | 1 | 80 | 105840.00 | short | ask | 44.5950 | 0.2500 | ["37.5","38.5"] | ["4.2159","0.5007"] | [] | ["XMIO"] | 37.5000 | 38.5000 | 0 | 7 | false | false | true | ||||||||||
| 01a090f7-f950-7122-b671-7aec3b3cdc36 | IBIT | 2026-09-11 10:56 | call_diagonal_spread | 2 | 2 | 180 | 187980.00 | short | ask | 44.6200 | 0.1400 | ["37","42"] | ["3.7391","0.4065"] | [] | ["XCBO","XISX"] | 37.0000 | 42.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a090f7-f950-7122-b671-7ad3d193da44 | IBIT | 2026-09-11 10:56 | call_diagonal_spread | 2 | 2 | 120 | 125220.00 | short | ask | 44.6200 | 0.1400 | ["37","42"] | ["3.4102","0.4029"] | [] | ["AMXO","XPHO"] | 37.0000 | 42.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a08bff-0268-73c2-907c-c36a41625d2c | IBIT | 2026-09-10 11:45 | call_diagonal_spread | 2 | 1 | 1000 | 258610.00 | long | ask | 43.7100 | 0.0400 | ["44","45"] | ["0.3970","0.3957"] | [] | ["XCBO"] | 44.0000 | 45.0000 | 8 | 36 | false | true | true | ||||||||||
| 01a086b1-c160-7b81-a993-79270e85088d | IBIT | 2026-09-09 11:03 | call_diagonal_spread | 2 | 1 | 75 | 102450.00 | short | ask | 44.5150 | 0.2000 | ["37.5","38"] | ["1.2021","0.5581"] | [] | ["XISX"] | 37.5000 | 38.0000 | 2 | 9 | false | false | true | ||||||||||
| 01a0819d-2458-7e91-96ea-be79622699c0 | IBIT | 2026-09-08 11:22 | call_diagonal_spread | 2 | 3 | 121 | 107690.00 | short | ask | 44.4300 | 0.2000 | ["40.5","41"] | ["0.4391","0.4234"] | [] | ["EMLD","SPHR","XMIO"] | 40.5000 | 41.0000 | 24 | 31 | false | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:20:39Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:20:39Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:20:39Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:20:39Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:20:16Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:00:58Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:43:20Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:17:24Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:13:51Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:06:29Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:05:02Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:46:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:10:23Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:01:05Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:48:50Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:13:25Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:01:58Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:45:16Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:29:47Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:56:11Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:56:11Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:46:14Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:03:26Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:22:36Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |