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 | directiontext | net_side |
|---|
| 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 |
|---|
| 01a086e5-bdf9-7ec0-abbc-792cbc259ba7 | SPOT | 2026-09-09 11:59 | straddle | 2 | 1 | 12 | 201600.00 | long | ask | 529.5500 | 4.0500 | ["560"] | ["0.4498"] | ["392","728.00"] | ["C2OX"] | 560.0000 | 560.0000 | 281 | 281 | false | false | false | false | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:00:05Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08695-34c8-7753-92b4-489fea09f526 | SPOT | 2026-09-09 10:31 | straddle | 2 | 2 | 19 | 318798.00 | short | bid | 531.5200 | 8.3000 | ["560"] | ["0.4486"] | ["392.21","727.79"] | ["C2OX"] | 560.0000 | 560.0000 | 281 | 281 | false | false | false | false | true | mlet | |||||||
| 01a08275-8eb0-76a3-baec-a94a86588df9 | SPOT | 2026-09-08 15:18 | put_vertical_spread | 2 | 1 | 39 | 1343160.00 | unknown | — | 529.2000 | 12.0500 | ["690","720"] | ["1.0950","1.1592"] | [] | ["XBOX"] | 690.0000 | 720.0000 | 10 | 10 | false | false | false | true | false | mlft | |||||||
| 01a0826c-7690-78b2-a412-96f471a39174 | SPOT | 2026-09-08 15:08 | put_vertical_spread | 2 | 1 | 36 | 1239840.00 | unknown | — | 529.3050 | 12.5000 | ["690","720"] | ["1.1019","1.1678"] | [] | ["XBOX"] | 690.0000 | 720.0000 | 10 | 10 | false | false | false | true | false | mlft | |||||||
| 01a081e9-40b8-72a1-b7e2-0ac2b0f31d0b | SPOT | 2026-09-08 12:45 | call_diagonal_spread | 2 | 1 | 5 | 187615.00 | short | ask | 529.3675 | 14.2000 | ["340","350"] | ["1.0453","0.4854"] | [] | ["ARCO"] | 340.0000 | 350.0000 | 10 | 101 | false | false | true | true | false | ||||||||
| 01a081e8-5a40-7331-830a-e586fbe73b5a | SPOT | 2026-09-08 12:44 | call_calendar | 2 | 1 | 3 | 110379.00 | long | bid | 529.4150 | 13.5500 | ["350"] | ["0.8018"] | [] | ["XMIO"] | 350.0000 | 350.0000 | 10 | 129 | false | false | true | false | false | mlet | |||||||
| 01a081e8-5a40-7331-830a-e570e39310ff | SPOT | 2026-09-08 12:44 | call_calendar | 2 | 2 | 5 | 192315.00 | long | bid | 529.4150 | 14.1000 | ["340"] | ["1.1632"] | [] | ["ARCO"] | 340.0000 | 340.0000 | 10 | 101 | false | false | true | false | false | mlet | |||||||
| 01a06dfc-d616-7363-9aa8-48f42a696fbb | SPOT | 2026-09-04 15:54 | put_vertical_spread | 2 | 1 | 39 | 1260246.00 | long | ask | 542.6900 | 12.9000 | ["690","720"] | ["0.5413","0.6348"] | ["0","690"] | ["XPHO"] | 690.0000 | 720.0000 | 14 | 14 | false | false | false | true | false | ||||||||
| 01a06df0-e37d-76a0-acf2-d7c7562770f2 | SPOT | 2026-09-04 15:41 | put_vertical_spread | 2 | 1 | 5 | 225440.00 | unknown | — | 543.9700 | 11.1500 | ["760","780"] | ["0.7818","0.8433"] | [] | ["ARCO"] | 760.0000 | 780.0000 | 14 | 14 | false | false | false | true | false | mlet | |||||||
| 01a06df0-e37d-76a0-acf2-d7b3d6aac0b4 | SPOT | 2026-09-04 15:41 | put_vertical_spread | 2 | 3 | 3 | 134698.00 | unknown | — | 543.9700 | 11.1833 | ["760","780"] | ["0.8742","0.9379"] | [] | ["ARCO","XBOX"] | 760.0000 | 780.0000 | 14 | 14 | false | false | false | true | false | mlet | |||||||
| 01a06dd6-857d-7760-beb3-4acdf50a94f2 | SPOT | 2026-09-04 15:12 | put_vertical_spread | 2 | 1 | 39 | 1214460.00 | long | ask | 545.6800 | 15.0000 | ["690","720"] | ["0.8934","1.0100"] | ["0","690"] | ["XBOX"] | 690.0000 | 720.0000 | 14 | 14 | false | false | false | true | false | ||||||||
| 01a06dd3-030d-7f00-9725-5edfd2121ea0 | SPOT | 2026-09-04 15:08 | put_vertical_spread | 2 | 1 | 74 | 206460.00 | unknown | — | 546.3800 | 1.6000 | ["440","450"] | ["0.4298","0.4282"] | [] | ["XISX"] | 440.0000 | 450.0000 | 133 | 133 | false | true | false | true | false | mesl | |||||||
| 01a06dd1-97c6-7211-b40e-57fa1fcbd42f | SPOT | 2026-09-04 15:07 | call_diagonal_spread_bearish | 2 | 1 | 26 | 189660.00 | long | ask | 545.6400 | 8.9000 | ["510","515"] | ["5.6685","0.3501"] | [] | ["XMIO"] | 510.0000 | 515.0000 | 0 | 21 | false | false | true | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:32:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:19:15Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:09:34Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:46:34Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:44:55Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:44:55Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:54:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:41:37Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:41:37Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:12:56Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:09:09Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:07:50Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |