Simplify AnalyticsMulti-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b601-7ab7-7d71-8bf8-42943fcb2e27 | IREN | 2026-09-18 15:32 | call_diagonal_spread | 2 | 1 | 460 | 393300.00 | short | ask | 45.8600 | 0.2000 | ["41","47"] | ["10.1766","0.7980"] | [] | ["XISX"] | 41.0000 | 47.0000 | 0 | 28 | false | false | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:32:39Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b525-6eaf-7f73-a42a-e53f6c16b4f8 | IREN | 2026-09-18 11:32 | call_diagonal_spread | 2 | 1 | 700 | 375900.00 | short | bid | 44.4100 | 0.2000 | ["42","44"] | ["1.4881","0.7787"] | [] | ["AMXO"] | 42.0000 | 44.0000 | 0 | 14 | false | false | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:32:11Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a145-4498-7320-af9d-19682ed2dcca | IREN | 2026-09-14 14:54 | call_vertical_spread | 2 | 1 | 10000 | 18770000.00 | unknown | — | 43.6900 | 0.7500 | ["40","65"] | ["0.9023","0.9146"] | [] | ["ARCO"] | 40.0000 | 65.0000 | 186 | 186 | false | false | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:55:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08cc9-ff40-7cc0-b0d0-909210fd29aa | IREN | 2026-09-10 15:27 | call_vertical_spread | 2 | 1 | 5500 | 8404000.00 | unknown | — | 44.0350 | 0.8500 | ["65","80"] | ["0.9189","0.9260"] | [] | ["ARCO"] | 65.0000 | 80.0000 | 280 | 280 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:27:21Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a06db0-e4ae-7881-89c1-c97b79976491 | IREN | 2026-09-04 14:31 | other | 2 | 1 | 2500 | 2837500.00 | unknown | — | 43.8450 | 0.6000 | ["65","70"] | ["0.9403","0.9191"] | [] | ["ARCO"] | 65.0000 | 70.0000 | 105 | 286 | false | true | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:32:06Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |