core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg600,173 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0ee1e-5627-7fb1-a1e0-34e702c4616e | BX | 2026-09-29 13:02 | call_vertical_spread | 2 | 1 | 40 | 177640.00 | short | bid | 113.7900 | 3.0000 | ["95","105"] | ["0.3218","0.3338"] | ["101.15"] | ["XPHO"] | 95.0000 | 105.0000 | 261 | 261 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-29T17:02:55Z"} | 2026-09-29 | 2026-09-29 17:15 | 2026-09-29 17:15 |
| 01a0ede9-e077-71c0-b9a3-031012ea8188 | BX | 2026-09-29 12:05 | call_vertical_spread | 2 | 1 | 40 | 177640.00 | short | bid | 113.7200 | 3.0000 | ["95","105"] | ["0.3240","0.3353"] | ["101.15"] | ["XISX"] | 95.0000 | 105.0000 | 261 | 261 | false | false | |||||||||||
| 01a0edc4-2c1f-7d03-927a-584b320522c4 | BX | 2026-09-29 11:24 | call_vertical_spread | 2 | 1 | 40 | 177800.00 | short | bid | 113.7300 | 2.9000 | ["95","105"] | ["0.3245","0.3357"] | ["101.15"] | ["XISX"] | 95.0000 | 105.0000 | 261 | 261 | false | false | |||||||||||
| 01a0edc4-2c1f-7d03-927a-58398980cebb | BX | 2026-09-29 11:24 | call_vertical_spread | 2 | 2 | 80 | 355600.00 | short | bid | 113.7300 | 2.9000 | ["95","105"] | ["0.3245","0.3357"] | ["101.15"] | ["XISX"] | 95.0000 | 105.0000 | 261 | 261 | false | false | |||||||||||
| 01a0eda5-038f-72c2-9d05-29e14f18f72b | BX | 2026-09-29 10:50 | call_vertical_spread | 2 | 2 | 80 | 359920.00 | unknown | bid | 114.3900 | 1.9000 | ["95","105"] | ["0.3155","0.3282"] | ["122.50"] | ["C2OX"] | 95.0000 | 105.0000 | 261 | 261 | false | false | |||||||||||
| 01a0eda5-038f-72c2-9d05-29db87ad3774 | BX | 2026-09-29 10:50 | call_vertical_spread | 2 | 3 | 120 | 540040.00 | short | bid | 114.3900 | 2.1000 | ["95","105"] | ["0.3158","0.3284"] | ["101.25"] | ["XCBO","XISX"] | 95.0000 | 105.0000 | 261 | 261 | false | false | |||||||||||
| 01a0ed92-005f-77b3-90cd-9c649b882f67 | BX | 2026-09-29 10:29 | call_vertical_spread | 2 | 2 | 80 | 365280.00 | short | bid | 114.8700 | 3.3500 | ["95","105"] | ["0.3139","0.3271"] | ["101.30"] | ["C2OX"] | 95.0000 | 105.0000 | 261 | 261 | false | false | |||||||||||
| 01a0ed92-005f-77b3-90cd-9c5031cdff00 | BX | 2026-09-29 10:29 | call_vertical_spread | 2 | 2 | 80 | 365280.00 | short | bid | 114.8700 | 3.3500 | ["95","105"] | ["0.3139","0.3271"] | ["101.30"] | ["C2OX","XISX"] | 95.0000 | 105.0000 | 261 | 261 | false | false | |||||||||||
| 01a0ed90-db67-7aa2-88eb-dd3ac327e7dc | BX | 2026-09-29 10:28 | call_vertical_spread | 2 | 1 | 40 | 182640.00 | short | bid | 114.8400 | 3.3500 | ["95","105"] | ["0.3149","0.3278"] | ["101.30"] | ["XISX"] | 95.0000 | 105.0000 | 261 | 261 | false | false | |||||||||||
| 01a0ed8f-684f-7661-8372-0b0f3d8370b4 | BX | 2026-09-29 10:26 | call_vertical_spread | 2 | 2 | 80 | 365280.00 | short | bid | 114.8350 | 3.3500 | ["95","105"] | ["0.3151","0.3279"] | ["101.30"] | ["XISX"] | 95.0000 | 105.0000 | 261 | 261 | false | false | |||||||||||
| 01a0ed8f-684f-7661-8372-0af024c0aac1 | BX | 2026-09-29 10:26 | call_vertical_spread | 2 | 2 | 80 | 365280.00 | short | bid | 114.8350 | 3.3500 | ["95","105"] | ["0.3151","0.3279"] | ["101.30"] | ["XISX","XPHO"] | 95.0000 | 105.0000 | 261 | 261 | false | false | |||||||||||
| 01a0d47f-9afe-7da0-a5cd-9666ecb283f1 | BX | 2026-09-24 13:38 | put_calendar | 2 | 1 | 100 | 549000.00 | short | bid | 116.9050 | 4.7500 | ["140"] | ["0.4334"] | [] | ["EDGO"] | 140.0000 | 140.0000 | 113 | 266 | false | false | true | ||||||||||
| 01a0d47a-8a1f-73c1-b4c5-4a27397ff7c2 | BX | 2026-09-24 13:33 | put_diagonal_spread | 2 | 1 | 160 | 489760.00 | short | bid | 117.1000 | 0.5000 | ["120","125"] | ["0.4224","0.4130"] | [] | ["XMIO"] | 120.0000 | 125.0000 | 113 | 266 | false | false | |||||||||||
| 01a0d408-9257-77d2-903e-9da07a54bbb6 | BX | 2026-09-24 11:28 | put_vertical_spread | 2 | 1 | 30 | 151170.00 | short | bid | 115.7500 | 6.2000 | ["115","125"] | ["0.4364","0.4418"] | ["119.41"] | ["XISX"] | 115.0000 | 125.0000 | 848 | 848 | false | false | |||||||||||
| 01a0d3fe-e1de-7642-9d4d-35965afdb153 | BX | 2026-09-24 11:18 | call_ratio_spread | 2 | 2 | 80 | 305960.00 | unknown | bid | 115.9000 | 4.9500 | ["95","105"] | ["0.3431","0.3486"] | ["123.83"] | ["AMXO"] | 95.0000 | 105.0000 | 266 | 266 | false | false | |||||||||||
| 01a0d3fe-e1de-7642-9d4d-358bf4a7b4b1 | BX | 2026-09-24 11:18 | call_ratio_spread | 2 | 2 | 120 | 476640.00 | unknown | bid | 115.9000 | 5.0000 | ["95","105"] | ["0.3452","0.3497"] | ["124.83"] | ["AMXO","XISX"] | 95.0000 | 105.0000 | 266 | 266 | false | false | |||||||||||
| 01a0cfbc-fa3f-7f43-8b0b-41e19b1cfb62 | BX | 2026-09-23 15:27 | risk_reversal | 2 | 1 | 300 | 652500.00 | short | bid | 119.6300 | 1.1500 | ["100","145"] | ["0.4238","0.3203"] | ["146.41"] | ["XPHO"] | 100.0000 | 145.0000 | 485 | 485 | false | true | |||||||||||
| 01a0cecb-04d7-7353-9fa3-97aa5a7bf74c | BX | 2026-09-23 11:03 | call_vertical_spread | 2 | 1 | 40 | 213040.00 | short | bid | 119.1250 | 4.9500 | ["95","105"] | ["0.3285","0.3384"] | ["101.70"] | ["XISX"] | 95.0000 | 105.0000 | 267 | 267 | false | false | |||||||||||
| 01a0cecb-04d7-7353-9fa3-9796c2906f01 | BX | 2026-09-23 11:03 | call_vertical_spread | 2 | 2 | 80 | 426080.00 | short | bid | 119.1250 | 4.9500 | ["95","105"] | ["0.3285","0.3384"] | ["101.70"] | ["XISX"] | 95.0000 | 105.0000 | 267 | 267 | false | false | |||||||||||
| 01a0cecb-04d7-7353-9fa3-978d4f7d07a8 | BX | 2026-09-23 11:03 | call_vertical_spread | 2 | 2 | 80 | 426080.00 | short | bid | 119.1250 | 4.9500 | ["95","105"] | ["0.3285","0.3384"] | ["101.70"] | ["XISX"] | 95.0000 | 105.0000 | 267 | 267 | false | false | |||||||||||
| 01a0cea2-3f57-7b21-8914-d983e9e26e39 | BX | 2026-09-23 10:18 | call_vertical_spread | 2 | 1 | 40 | 221760.00 | unknown | bid | 120.3200 | 4.9000 | ["95","105"] | ["0.3357","0.3409"] | ["127.72"] | ["XPHO"] | 95.0000 | 105.0000 | 267 | 267 | false | false | |||||||||||
| 01a0cea2-3f57-7b21-8914-d97a7c79a167 | BX | 2026-09-23 10:18 | call_vertical_spread | 2 | 2 | 80 | 443520.00 | unknown | bid | 120.3200 | 4.9000 | ["95","105"] | ["0.3357","0.3409"] | ["127.72"] | ["XPHO"] | 95.0000 | 105.0000 | 267 | 267 | false | false | |||||||||||
| 01a0cea2-3f57-7b21-8914-d96e64c9bd23 | BX | 2026-09-23 10:18 | call_vertical_spread | 2 | 2 | 80 | 443520.00 | unknown | bid | 120.3200 | 4.9000 | ["95","105"] | ["0.3357","0.3409"] | ["127.72"] | ["XPHO"] | 95.0000 | 105.0000 | 267 | 267 | false | false | |||||||||||
| 01a0ce9c-b177-7142-828c-8b14b03db806 | BX | 2026-09-23 10:12 | call_vertical_spread | 2 | 2 | 80 | 446880.00 | short | bid | 120.7000 | 4.3500 | ["95","105"] | ["0.3305","0.3383"] | ["101.90"] | ["XISX"] | 95.0000 | 105.0000 | 267 | 267 | false | false | |||||||||||
| 01a0ce9c-b177-7142-828c-8b0607b42dd2 | BX | 2026-09-23 10:12 | call_vertical_spread | 2 | 2 | 80 | 446880.00 | short | bid | 120.7000 | 4.3500 | ["95","105"] | ["0.3305","0.3383"] | ["101.90"] | ["XISX"] | 95.0000 | 105.0000 | 267 | 267 | false | false | |||||||||||
| 01a0ce9c-b177-7142-828c-8af36af293b7 | BX | 2026-09-23 10:12 | call_vertical_spread | 2 | 1 | 40 | 223440.00 | short | bid | 120.7000 | 4.3500 | ["95","105"] | ["0.3305","0.3383"] | ["101.90"] | ["XISX"] | 95.0000 | 105.0000 | 267 | 267 | false | false | |||||||||||
| 01a0ca85-fc6f-7cc2-971e-c82be3635851 | BX | 2026-09-22 15:09 | put_diagonal_spread | 2 | 1 | 30 | 144180.00 | short | bid | 124.7800 | 3.0000 | ["125","130"] | ["0.4433","0.4293"] | [] | ["XISX"] | 125.0000 | 130.0000 | 486 | 850 | false | false | |||||||||||
| 01a0c969-d256-7e41-a245-0156dc9fbb2f | BX | 2026-09-22 09:59 | put_calendar | 2 | 1 | 55 | 152735.00 | short | bid | 125.3900 | 3.9500 | ["139"] | ["0.4384"] | [] | ["XCBO"] | 139.0000 | 139.0000 | 10 | 38 | false | false | true | ||||||||||
| 01a0a0bf-5f40-7d32-b9c8-d45aad267570 | BX | 2026-09-14 12:28 | put_calendar | 2 | 1 | 105 | 225120.00 | long | bid | 128.7200 | 1.6000 | ["139"] | ["0.4227"] | [] | ["BATO"] | 139.0000 | 139.0000 | 4 | 18 | false | false | true | ||||||||||
| 01a0a084-cf11-72f2-a4c7-d875ae79fee4 | BX | 2026-09-14 11:24 | call_calendar | 2 | 1 | 448 | 137984.00 | long | bid | 128.3800 | 0.3350 | ["150"] | ["0.5083"] | [] | ["XBOX"] | 150.0000 | 150.0000 | 4 | 95 | false | true | true | ||||||||||
| 01a08bf4-5fc0-7b51-a382-ba47107e1baf | BX | 2026-09-10 11:34 | call_calendar | 2 | 1 | 95 | 166535.00 | short | bid | 127.2700 | 1.9000 | ["150"] | ["0.3514"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 127 | 463 | false | true | true | ||||||||||
| 01a08ba4-e800-7913-b305-631cbc57dc4f | BX | 2026-09-10 10:07 | put_calendar | 2 | 1 | 146 | 460922.00 | short | bid | 125.5000 | 4.3500 | ["141"] | ["0.8362"] | [] | ["ARCO"] | 141.0000 | 141.0000 | 1 | 29 | false | false | true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T16:05:42Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T15:24:24Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T15:24:24Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:50:13Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:50:13Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:29:40Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:29:40Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:28:13Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:26:38Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:26:38Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:38:50Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:33:32Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:29:16Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:18:20Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:18:20Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:27:53Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:03:36Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:03:36Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:03:36Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:19:02Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:19:02Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:19:02Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:13:00Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:13:00Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:13:00Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:09:53Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:59:10Z"} |
| 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-14T16:28:54Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:24:31Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:34:26Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:07:28Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |