Multi-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b531-c6d7-7ab2-aabc-35a3d904a066 | MRNA | 2026-09-18 11:45 | call_diagonal_spread | 2 | 1 | 50 | 710500.00 | short | ask | 155.0450 | 4.8000 | ["85","150"] | ["0.9000","0.7242"] | [] | ["XISX"] | 85.0000 | 150.0000 | 91 | 819 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:45:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b50e-3560-7113-85eb-574bfd8c6e23 | MRNA | 2026-09-18 11:06 | call_diagonal_spread | 2 | 1 | 40 | 602800.00 | short | ask | 155.7200 | 3.4500 | ["130","140"] | ["0.7297","0.7244"] | [] | ["XISX"] | 130.0000 | 140.0000 | 819 | 854 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:07:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a605-d14d-7611-8790-8274fd96cf7b | MRNA | 2026-09-15 13:03 | call_diagonal_spread | 2 | 1 | 40 | 928800.00 | short | ask | 144.4100 | 2.1000 | ["27","30"] | ["7.4120","1.4585"] | [] | ["C2OX"] | 27.0000 | 30.0000 | 3 | 66 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:03:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0817a-9c80-7513-a30b-f3f36997ccb0 | MRNA | 2026-09-08 10:44 | call_diagonal_spread | 2 | 1 | 50 | 663500.00 | short | ask | 144.0287 | 2.9500 | ["75","145"] | ["1.1243","0.7235"] | [] | ["XISX"] | 75.0000 | 145.0000 | 38 | 829 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:45:03Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08167-2038-72b2-8e92-779c7477bcb7 | MRNA | 2026-09-08 10:23 | call_diagonal_spread | 2 | 1 | 50 | 664000.00 | short | ask | 144.4200 | 3.6500 | ["80","140"] | ["0.8472","0.7202"] | [] | ["XISX"] | 80.0000 | 140.0000 | 129 | 829 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:23:51Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |