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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a081dc-2540-7383-827d-6c2ea3a2196a | KRE | 2026-09-08 12:31 | other | 2 | 1 | 2500 | 687500.00 | unknown | — | 74.8550 | 0.3700 | ["73"] | ["0.2514"] | [] | ["AMXO"] | 73.0000 | 73.0000 | 10 | 73 | false | true | true | false | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:31:24Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0828c-23f0-77d0-93b5-cee18723be16 | KRE | 2026-09-08 15:43 | other | 2 | 1 | 2500 | 712500.00 | unknown | — | 74.5950 | 0.2500 | ["73"] | ["0.2472"] | [] | ["AMXO"] | 73.0000 | 73.0000 | 10 | 73 | false | true | true | false | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:43:36Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a090f0-11e0-73c0-9aaa-451fb709dfee | KRE | 2026-09-11 10:47 | other | 2 | 1 | 1000 | 357000.00 | unknown | — | 73.4950 | 0.6800 | ["74","74.5"] | ["0.2680","0.2564"] | [] | ["AMXO"] | 74.0000 | 74.5000 | 7 | 19 | false | false | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:47:41Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a581-8236-7e33-adba-19b39c49fd2e | KRE | 2026-09-15 10:38 | put_vertical_spread | 2 | 1 | 20000 | 540000.00 | unknown | — | 74.4750 | 0.2000 | ["71","72"] | ["0.3874","0.3518"] | [] | ["ARCO"] | 71.0000 | 72.0000 | 3 | 3 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:38:42Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0aab6-88f3-76e0-991e-336243408a2d | KRE | 2026-09-16 10:54 | strangle | 2 | 1 | 3500 | 168000.00 | unknown | — | 73.8450 | 0.0800 | ["71.5","75"] | ["0.4179","0.3390"] | [] | ["ARCO"] | 71.5000 | 75.0000 | 2 | 2 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:55:21Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abd9-a84a-7713-8db3-3036d1b7e1d1 | KRE | 2026-09-16 16:12 | other | 3 | 1 | 12014 | 6690916.00 | unknown | — | 72.7400 | 6.3400 | ["70","80","82"] | ["0.2469","0.2020","0.2047"] | [] | ["ARCO"] | 70.0000 | 82.0000 | 121 | 184 | false | true | true | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T20:12:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |