Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 rowsexportable
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b624-c1f7-79f1-a578-6b4a849600b7 | QQQ | 2026-09-18 16:10 | straddle | 2 | 1 | 1000 | 462000.00 | long | ask | 722.6297 | 0.2000 | ["718"] | ["0.7500"] | ["713.38","722.62"] | ["AMXO"] | 718.0000 | 718.0000 | 0 | 0 | false | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T20:11:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b618-6db7-7612-99e8-172a6506cc0b | MDT | 2026-09-18 15:57 | straddle | 2 | 1 | 1000 | 4045000.00 | long | ask | 92.1950 | 6.1800 | ["130"] | ["0.9844"] | ["89.55","170.45"] | ["AMXO"] | 130.0000 | 130.0000 | 28 | 28 | false | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:57:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5fc-6dc0-7651-93ef-e48fb577d16d | MDT | 2026-09-18 15:26 | straddle | 2 | 1 | 2000 | 8066000.00 | long | ask | 92.4900 | 6.2300 | ["130"] | ["0.9899"] | ["89.67","170.33"] | ["AMXO"] | 130.0000 | 130.0000 | 28 | 28 | false | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:26:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5f8-1477-78f3-a94c-fa9622b945ef | QQQ | 2026-09-18 15:22 | straddle | 2 | 1 | 1400 | 149800.00 | long | ask | 719.3700 | 0.0300 | ["720"] | ["0.1927"] | ["718.93","721.07"] | ["AMXO"] | 720.0000 | 720.0000 | 0 | 0 | false | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:22:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ce-9f30-7e00-88c8-1b6c1267ff0f | TSM | 2026-09-18 14:36 | straddle | 2 | 1 | 1000 | 8750000.00 | long | ask | 429.5501 | 2.3500 | ["450"] | ["0.3564"] | ["362.50","537.50"] | ["AMXO"] | 450.0000 | 450.0000 | 182 | 182 | false | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:36:54Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5b0-5d17-7cf2-9266-c160163e6d1b | RGR | 2026-09-18 14:03 | straddle | 2 | 1 | 1000 | 1404000.00 | long | ask | 40.3900 | 4.4500 | ["50"] | ["1.1773"] | ["35.96","64.04"] | ["AMXO"] | 50.0000 | 50.0000 | 28 | 28 | true | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:03:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b592-2e88-7120-9d30-65a045087b6a | ABUS | 2026-09-18 13:30 | straddle | 2 | 1 | 10000 | 4270000.00 | long | ask | 5.0150 | 6.5000 | ["7"] | ["3.1123"] | ["2.73","11.27"] | ["AMXO"] | 7.0000 | 7.0000 | 28 | 28 | true | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:31:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b582-6b5f-76c0-821b-df09f700f30f | HYG | 2026-09-18 13:13 | straddle | 2 | 1 | 10000 | 1350000.00 | long | ask | 78.4900 | 0.1700 | ["78"] | ["0.0581"] | ["76.65","79.35"] | ["AMXO"] | 78.0000 | 78.0000 | 63 | 63 | false | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:14:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b534-8dc7-7d61-9ad2-78257cb9cb43 | LULU | 2026-09-18 11:48 | straddle | 2 | 1 | 1500 | 1485000.00 | long | ask | 100.1900 | 0.5300 | ["105"] | ["0.4072"] | ["95.10","114.90"] | ["AMXO"] | 105.0000 | 105.0000 | 28 | 28 | false | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:48:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a06df9-3c35-79d3-b36a-cdd73a6fe68a | QQQ | 2026-09-04 15:50 | straddle | 2 | 1 | 1000 | 98000.00 | long | ask | 718.8800 | 0.0400 | ["718"] | ["0.2564"] | ["717.02","718.98"] | ["AMXO"] | 718.0000 | 718.0000 | 0 | 0 | false | false | false | false | true | mlct | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:50:54Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06df8-0b85-7bd2-b42c-8c21f65d7ebd | QQQ | 2026-09-04 15:49 | straddle | 2 | 1 | 1000 | 82000.00 | long | ask | 718.4900 | 0.0300 | ["718"] | ["0.2780"] | ["717.18","718.82"] | ["AMXO"] | 718.0000 | 718.0000 | 0 | 0 | false | false | false | false | true | mlct | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:49:31Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |