Simplify AnalyticsMulti-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
403,968 rowsCSV — whole table, not this view
Sources in this table
uw_multileg403,968 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c9f4-d82f-7e00-ba75-326ad62428b4 | ON | 2026-09-22 12:30 | call_diagonal_spread | 2 | 2 | 419 | 147069.00 | unknown | bid | 72.7800 | 0.2900 | ["75","80"] | ["0.5616","0.5577"] | [] | ["ARCO","EDGO"] | 75.0000 | 80.0000 | 10 | 24 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T16:31:48Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9f1-3a67-75b1-bcad-88c148cc6bfb | ON | 2026-09-22 12:27 | call_diagonal_spread | 2 | 1 | 608 | 213408.00 | unknown | bid | 72.6800 | 0.3500 | ["75","80"] | ["0.5701","0.5622"] | [] | ["ARCO"] | 75.0000 | 80.0000 | 10 | 24 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T16:27:34Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9f1-367e-7f90-8e72-9877aa5b3474 | ON | 2026-09-22 12:27 | call_diagonal_spread | 2 | 3 | 515 | 181364.00 | unknown | bid | 72.6800 | 0.3700 | ["75","80"] | ["0.5703","0.5639"] | [] | ["ARCO","C2OX","XCBO"] | 75.0000 | 80.0000 | 10 | 24 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T16:27:34Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0b582-d8bf-7d81-9513-53b3672c0cea | ON | 2026-09-18 13:14 | put_diagonal_spread | 2 | 1 | 130 | 162630.00 | short | bid | 69.2400 | 0.3500 | ["70","75"] | ["0.5751","2.1951"] | [] | ["C2OX"] | 70.0000 | 75.0000 | 0 | 63 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:14:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b560-83af-7e60-9422-934cd80343fd | ON | 2026-09-18 12:36 | other | 4 | 1 | 2535 | 621075.00 | unknown | bid | 69.1200 | 0.3200 | ["70","72","75"] | ["0.4907","0.8590","2.3348"] | [] | ["AMXO"] | 70.0000 | 75.0000 | 0 | 7 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:37:09Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aa81-b583-7142-bee0-d936f8270d2b | ON | 2026-09-16 09:56 | call_diagonal_spread | 2 | 4 | 1066 | 430666.00 | short | bid | 72.8300 | 0.6588 | ["75","80"] | ["1.1316","0.6026"] | [] | ["AMXO","ARCO","EMLD","XBOX"] | 75.0000 | 80.0000 | 2 | 30 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:57:17Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |