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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c512-62fe-70e2-9ad1-9f3c73ba2e2f | NVDA | 2026-09-21 13:45 | put_ladder | 3 | 1 | 30 | 71700.00 | short | ask | 227.2600 | 0.3000 | ["205","215","225"] | ["0.3861","0.3752","0.3652"] | ["212.84"] | ["MCRY"] | 205.0000 | 225.0000 | 60 | 60 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:45:12Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c439-028e-74b0-bc19-c9f1e7f65eff | NVDA | 2026-09-21 09:47 | put_ladder | 3 | 1 | 45 | 94320.00 | short | ask | 224.6900 | 0.3000 | ["200","210","220"] | ["0.3876","0.3746","0.3662"] | ["208.62"] | ["XCBO"] | 200.0000 | 220.0000 | 60 | 60 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:47:52Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5ad-9a0f-7010-abcc-3419e1ca8711 | QQQ | 2026-09-18 14:00 | put_ladder | 3 | 1 | 5 | 28635.00 | unknown | ask | 717.4900 | 0.6400 | ["605","700","705"] | ["0.2736","0.2203","0.2182"] | ["579.85"] | ["XCBO"] | 605.0000 | 705.0000 | 154 | 154 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:00:52Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ee-7090-7970-9f6b-0a573af04872 | NVDA | 2026-09-18 10:31 | put_ladder | 3 | 1 | 60 | 74760.00 | unknown | ask | 219.2100 | 0.2000 | ["190","195","200"] | ["0.3916","0.3825","0.3766"] | ["195.66"] | ["XCBO"] | 190.0000 | 200.0000 | 63 | 63 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:32:03Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d1-d457-7072-bbd6-db43bd444976 | SPX | 2026-09-18 10:00 | put_ladder | 3 | 1 | 2 | 40675.00 | unknown | ask | 7627.9900 | 2.0000 | ["4800","6950","7350"] | ["0.3829","0.2016","0.1729"] | ["3061.05","6538.95"] | ["XCBO"] | 4800.0000 | 7350.0000 | 154 | 154 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:00:48Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aabe-b6b3-73f2-9117-2aa1fb2f71a1 | VRT | 2026-09-16 11:03 | put_ladder | 3 | 1 | 100 | 225200.00 | short | ask | 241.8200 | 2.2100 | ["215","240","250"] | ["0.6273","0.5881","0.5757"] | ["234.99"] | ["XPHO"] | 215.0000 | 250.0000 | 9 | 9 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:04:00Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |