Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b4ef-81ff-78e1-8b26-36974ab8baff | SPCX | 2026-09-18 10:33 | risk_reversal | 2 | 1 | 15000 | 38490000.00 | short | bid | 151.9650 | 0.4500 | ["110","160"] | ["0.5590","0.5235"] | ["175.16"] | ["ARCO"] | 110.0000 | 160.0000 | 182 | 182 | true | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:33:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5b3-eb3f-74b1-81d5-530461bf60c9 | GFL | 2026-09-18 14:07 | risk_reversal | 3 | 1 | 2000 | 826000.00 | long | ask | 42.6550 | 8.1000 | ["35","47.5","55"] | ["0.5464","0.5757","0.5695"] | ["48.15"] | ["XISX"] | 35.0000 | 55.0000 | 63 | 63 | true | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:08:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5b8-9e60-7073-b234-86597c5baaa6 | GFL | 2026-09-18 14:12 | risk_reversal | 3 | 1 | 500 | 202500.00 | long | ask | 42.5350 | 8.1000 | ["35","47.5","55"] | ["0.5372","0.5765","0.5698"] | ["48.15"] | ["XISX"] | 35.0000 | 55.0000 | 63 | 63 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:13:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5f1-4647-7d12-96fd-6f928cec39ee | QQQ | 2026-09-18 15:14 | risk_reversal | 2 | 1 | 1350 | 1250100.00 | short | bid | 719.1300 | 0.0600 | ["674","735"] | ["0.2258","0.1468"] | ["738.12"] | ["AMXO"] | 674.0000 | 735.0000 | 28 | 28 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:14:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c4ce-8bcf-7743-bc24-dc6dfdd6f71c | EEM | 2026-09-21 12:31 | risk_reversal | 2 | 1 | 3500 | 878500.00 | long | bid | 68.6700 | 0.3400 | ["63","74"] | ["0.2825","0.2120"] | ["62.89"] | ["AMXO"] | 63.0000 | 74.0000 | 88 | 88 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:31:06Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4cf-1c57-7e00-b7f7-0bc9c7f2dc36 | EEM | 2026-09-21 12:31 | risk_reversal | 2 | 1 | 1500 | 376500.00 | long | bid | 68.6900 | 0.3400 | ["63","74"] | ["0.2829","0.2115"] | ["62.89"] | ["AMXO"] | 63.0000 | 74.0000 | 88 | 88 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:31:51Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4f2-c53f-7f10-8af0-30ecc7cf627c | GDX | 2026-09-21 13:10 | risk_reversal | 2 | 1 | 2000 | 2906000.00 | long | bid | 94.0100 | 0.5000 | ["90","110"] | ["0.4290","0.4271"] | ["88.15"] | ["ARCO"] | 90.0000 | 110.0000 | 179 | 179 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:11:09Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4fc-eae7-7dc0-91f6-c68a6f69b29c | FWONK | 2026-09-21 13:21 | risk_reversal | 2 | 1 | 1000 | 212000.00 | long | ask | 95.8950 | 2.4500 | ["90","100"] | ["0.2610","0.3044"] | ["101.00"] | ["SPHR"] | 90.0000 | 100.0000 | 25 | 25 | true | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:21:54Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c51a-e2c6-7e03-b95c-67a3955a5345 | QQQ | 2026-09-21 13:54 | risk_reversal | 2 | 1 | 2000 | 1202000.00 | short | ask | 739.7794 | 0.0300 | ["700","775"] | ["0.2191","0.1650"] | ["699.29"] | ["AMXO"] | 700.0000 | 775.0000 | 25 | 25 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:54:34Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c564-e7fe-7d12-be5e-a2b8e64c46b3 | HYG | 2026-09-21 15:15 | risk_reversal | 2 | 1 | 25000 | 100000.00 | long | bid | 78.7050 | 0.0700 | ["65","81"] | ["0.2093","0.0323"] | ["65","81"] | ["ARCO"] | 65.0000 | 81.0000 | 60 | 60 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:15:28Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c575-149f-7c03-a6fc-864abbf5b821 | XLP | 2026-09-21 15:32 | risk_reversal | 2 | 1 | 1500 | 1167000.00 | long | ask | 82.0500 | 0.6200 | ["75","85"] | ["0.1826","0.1172"] | ["88.42"] | ["XBOX"] | 75.0000 | 85.0000 | 487 | 487 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:33:26Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |