core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 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 | true | 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 |
| 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 | false | ||||||||||
| 01a0d3fe-e1de-7642-9d4d-35a5786b07d6 | BX | 2026-09-24 11:18 | call_vertical_spread | 2 | 1 | 40 | 195200.00 | long | ask | 115.9000 | 5.1500 | ["95","105"] | ["0.3419","0.3477"] | ["101.40"] | ["AMXO"] | 95.0000 | 105.0000 | 266 | 266 | false | 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 | 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 | false | ||||||||||
| 01a0d3fa-5d9f-7c21-8c1c-69e51d97891d | BX | 2026-09-24 11:13 | call_vertical_spread | 2 | 2 | 80 | 392240.00 | long | ask | 116.2500 | 5.0500 | ["95","105"] | ["0.3356","0.3431"] | ["101.43"] | ["XISX","XPHO"] | 95.0000 | 105.0000 | 266 | 266 | false | false | false | ||||||||||
| 01a0d3f5-1ddf-71f2-846c-1b57328ba34d | BX | 2026-09-24 11:07 | call_vertical_spread | 2 | 3 | 120 | 588360.00 | long | ask | 116.3600 | 5.0500 | ["95","105"] | ["0.3319","0.3406"] | ["101.43"] | ["XISX"] | 95.0000 | 105.0000 | 266 | 266 | false | false | false | ||||||||||
| 01a0d3f1-ddd7-7c42-8866-25dd03316eff | BX | 2026-09-24 11:03 | call_vertical_spread | 2 | 1 | 40 | 196120.00 | long | ask | 116.7000 | 5.0500 | ["95","105"] | ["0.3201","0.3330"] | ["101.43"] | ["XPHO"] | 95.0000 | 105.0000 | 266 | 266 | false | false | false | ||||||||||
| 01a0d3f1-ddd7-7c42-8866-25c4f5bbd132 | BX | 2026-09-24 11:03 | call_vertical_spread | 2 | 1 | 40 | 196120.00 | long | ask | 116.7311 | 5.0500 | ["95","105"] | ["0.3190","0.3323"] | ["101.43"] | ["XPHO"] | 95.0000 | 105.0000 | 266 | 266 | false | false | false | ||||||||||
| 01a0d3e4-2a07-7e10-bee7-8c3c1b06103c | BX | 2026-09-24 10:48 | call_vertical_spread | 2 | 1 | 39 | 191217.00 | long | ask | 116.2450 | 5.0500 | ["95","105"] | ["0.3357","0.3432"] | ["101.43"] | ["C2OX"] | 95.0000 | 105.0000 | 266 | 266 | false | false | false | ||||||||||
| 01a0d3e4-2a07-7e10-bee7-8c2e75e8ceb9 | BX | 2026-09-24 10:48 | call_vertical_spread | 2 | 2 | 80 | 392240.00 | long | ask | 116.2450 | 5.0500 | ["95","105"] | ["0.3357","0.3432"] | ["101.43"] | ["C2OX","XISX"] | 95.0000 | 105.0000 | 266 | 266 | false | false | false | ||||||||||
| 01a0d3e4-2a07-7e10-bee7-8c19db9d0252 | BX | 2026-09-24 10:48 | call_vertical_spread | 2 | 2 | 80 | 392240.00 | long | ask | 116.2450 | 5.0500 | ["95","105"] | ["0.3357","0.3432"] | ["101.43"] | ["XISX"] | 95.0000 | 105.0000 | 266 | 266 | false | false | false | ||||||||||
| 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 | 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 | 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 | false | ||||||||||
| 01a0cec1-2197-7700-a509-4e553fb5aacf | BX | 2026-09-23 10:52 | call_calendar | 2 | 1 | 51 | 171207.00 | short | ask | 120.3600 | 3.6500 | ["150"] | ["0.3060"] | [] | ["XISX"] | 150.0000 | 150.0000 | 814 | 849 | false | true | true | 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 | 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 | 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 | 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 | 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 | 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 | false | ||||||||||
| 01a0ca96-772e-7d83-9b70-1711ce9106e7 | BX | 2026-09-22 15:27 | put_diagonal_spread | 2 | 1 | 40 | 221440.00 | long | ask | 124.5600 | 2.7125 | ["145","150"] | ["0.4226","0.4447"] | [] | ["XISX"] | 145.0000 | 150.0000 | 87 | 268 | false | false | true | ||||||||||
| 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 | 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 | false | |||||||||
| 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 | false | |||||||||
| 01a0869d-6670-7fd0-8e19-e3addcfc643f | BX | 2026-09-09 10:40 | put_vertical_spread | 2 | 2 | 55 | 157593.00 | unknown | — | 129.7400 | 1.0500 | ["115","145"] | ["0.4127","0.4124"] | [] | ["ARCO","EDGO"] | 115.0000 | 145.0000 | 163 | 163 | false | false | false | true | false |
| 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 |
| 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 |
| 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 |
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:13:21Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:07:49Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:04:13Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:04:13Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:49:32Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:49:32Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:49:32Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| 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 |
| 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 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:53:04Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:28:04Z"} |
| 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-22T19:09:53Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| 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 |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:41:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |