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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b538-8d37-7002-901f-48c382738a3f | WULF | 2026-09-18 11:52 | call_vertical_spread | 2 | 1 | 50000 | 30450000.00 | long | ask | 16.5950 | 0.3200 | ["16","18"] | ["0.8283","0.8221"] | ["16.81"] | ["AMXO"] | 16.0000 | 18.0000 | 119 | 119 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:53:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a63d-7f36-7c10-869e-daf86384913e | WULF | 2026-09-15 14:04 | call_vertical_spread | 2 | 2 | 1772 | 147086.00 | long | ask | 14.6650 | 0.0300 | ["17","21"] | ["0.8599","0.8413"] | ["17.55"] | ["XBOX"] | 17.0000 | 21.0000 | 31 | 31 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:04:46Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0a4-f588-7371-8b6f-fcf18262f9f5 | WULF | 2026-09-14 11:59 | call_ratio_spread | 2 | 1 | 1000 | 134500.00 | long | ask | 15.7150 | 0.1200 | ["18","23"] | ["0.8622","0.8701"] | ["18.37","27.63"] | ["XPHO"] | 18.0000 | 23.0000 | 67 | 67 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:59:20Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a081fe-a548-70c1-808e-7cac651bcc62 | WULF | 2026-09-08 13:09 | call_backspread | 2 | 1 | 8500 | 2806000.00 | long | bid | 17.7050 | 0.2100 | ["16","19"] | ["0.8389","0.8603"] | ["16.56","23.48"] | ["ARCO"] | 16.0000 | 19.0000 | 38 | 38 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:09:50Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |