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
active:ticker = OUST×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0bd-5213-7f70-b61a-213397abe775 | OUST | 2026-09-17 14:59 | put_ladder | 7 | 1 | 156 | 285460.00 | unknown | — | 35.3900 | 10.0000 | ["41","41.5","42","43","45","46","47"] | ["3.2529","4.1062","2.2385","4.5780","3.6919","3.6358","3.8490"] | [] | ["XBOX"] | 41.0000 | 47.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:00:08Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b0-80d3-7a30-b0a6-c03d0f2ee22c | OUST | 2026-09-17 14:45 | other | 4 | 1 | 66 | 154320.00 | unknown | — | 35.4700 | 3.1000 | ["44","45","46","47"] | ["2.7761","3.6009","3.5489","4.0635"] | [] | ["XBOX"] | 44.0000 | 47.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:46:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b059-a28b-7701-a5d2-0ff61499a8b4 | OUST | 2026-09-17 13:10 | call_vertical_spread | 2 | 1 | 200 | 108800.00 | long | ask | 35.7300 | 0.5000 | ["35","40"] | ["0.8160","0.8151"] | ["36.90"] | ["XMIO"] | 35.0000 | 40.0000 | 29 | 29 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:11:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aa92-efab-7912-8b6d-ecee437fef2a | OUST | 2026-09-16 10:15 | call_condor | 4 | 1 | 20 | 137420.00 | short | bid | 33.9750 | 8.4000 | ["30","35","50","55"] | ["0.9098","0.9305","0.9332","0.9598"] | ["30.65","54.35"] | ["ARCO"] | 30.0000 | 55.0000 | 856 | 856 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:15:56Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a694-5996-71e1-9a2a-3eaad8ebcb92 | OUST | 2026-09-15 15:38 | call_diagonal_spread | 2 | 1 | 70 | 266350.00 | unknown | — | 32.6500 | 1.1000 | ["23","25"] | ["0.9662","0.9580"] | [] | ["MCRY"] | 23.0000 | 25.0000 | 493 | 857 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:38:54Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08bdf-12a0-7143-b53d-95a46870bed9 | OUST | 2026-09-10 11:10 | put_diagonal_spread | 2 | 1 | 54 | 174960.00 | short | bid | 36.5000 | 1.8000 | ["48","50"] | ["0.9521","1.0105"] | [] | ["XMIO"] | 48.0000 | 50.0000 | 71 | 162 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:11:16Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |