Simplify AnalyticsMulti-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0afef-5b83-77d2-92e1-573049cae6b2 | NVDA | 2026-09-17 11:14 | straddle | 2 | 1 | 100 | 49500.00 | long | ask | 218.8600 | 0.0600 | ["215"] | ["0.4121"] | ["210.05","219.95"] | ["XPHO"] | 215.0000 | 215.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:14:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a5cc-eece-7701-952e-f59c5d2b0767 | NVDA | 2026-09-15 12:01 | straddle | 2 | 1 | 20 | 26080.00 | unknown | — | 212.2400 | 0.2100 | ["200"] | ["0.4861"] | [] | ["MCRY"] | 200.0000 | 200.0000 | 3 | 3 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:01:16Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a037-dbd8-7912-90d7-bfd353879122 | NVDA | 2026-09-14 10:00 | straddle | 2 | 1 | 10 | 72330.00 | long | ask | 210.7800 | 0.3700 | ["280"] | ["0.4027"] | ["207.67","352.33"] | ["AMXO"] | 280.0000 | 280.0000 | 123 | 123 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:00:10Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08b85-03f0-78b2-aee2-10cafdbc9a4c | NVDA | 2026-09-10 09:32 | straddle | 2 | 1 | 83 | 37184.00 | long | ask | 219.6246 | 0.1100 | ["220"] | ["0.4871"] | ["215.52","224.48"] | ["XCBO"] | 220.0000 | 220.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:32:34Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0828e-a878-7b33-a0bf-44d3ec6b20bf | NVDA | 2026-09-08 15:46 | straddle | 2 | 1 | 71 | 225212.00 | long | ask | 225.4300 | 0.1500 | ["230"] | ["0.3915"] | ["198.28","261.72"] | ["XISX"] | 230.0000 | 230.0000 | 73 | 73 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:46:27Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |