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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0aba1-ac43-71d1-b4af-657b912289bf | DRAM | 2026-09-16 15:11 | call_ratio_spread | 2 | 1 | 4222 | 261766.00 | long | ask | 54.9800 | 0.1300 | ["56","57.5"] | ["0.6788","0.6697"] | ["56.12","58.88"] | ["EDGO"] | 56.0000 | 57.5000 | 2 | 2 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:11:47Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a0be-de58-7a01-91c1-e3529396114d | DRAM | 2026-09-14 12:27 | call_ratio_spread | 2 | 2 | 2540 | 152400.00 | long | ask | 55.1200 | 0.0600 | ["57.5","60"] | ["0.6905","0.6872"] | ["57.72","62.28"] | ["AMXO","EDGO"] | 57.5000 | 60.0000 | 4 | 4 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:28:06Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08673-4930-7af3-a850-145ce37d6912 | DRAM | 2026-09-09 09:54 | call_ratio_spread | 2 | 1 | 2000 | 270000.00 | long | ask | 61.8900 | 0.1600 | ["75","90"] | ["0.7136","0.7533"] | ["75.82","104.18"] | ["MCRY"] | 75.0000 | 90.0000 | 37 | 37 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:55:07Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06dbc-759d-73d3-863c-03cbc0ad1b1d | DRAM | 2026-09-04 14:44 | call_ratio_spread | 2 | 2 | 1500 | 210472.00 | long | ask | 59.1650 | 1.0100 | ["88","115"] | ["0.6163","0.6632"] | ["128.52"] | ["EDGO","XBOX"] | 88.0000 | 115.0000 | 133 | 133 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:44:57Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d8c-e1ed-7822-a747-ebccf0ab4b30 | DRAM | 2026-09-04 13:52 | call_ratio_spread | 2 | 1 | 162 | 173502.00 | long | ask | 58.8700 | 1.4000 | ["90","122"] | ["0.6209","0.6280"] | ["155.70"] | ["XISX"] | 90.0000 | 122.0000 | 504 | 504 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:53:05Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |