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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0afea-90f3-7062-941a-ec0665797811 | SPCX | 2026-09-17 11:09 | call_diagonal_spread | 2 | 2 | 5 | 88325.00 | short | bid | 154.3700 | 4.2500 | ["80","85"] | ["0.5987","0.5759"] | [] | ["XCBO"] | 80.0000 | 85.0000 | 638 | 820 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:09:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afc8-95bb-7461-acaa-42ba152af23a | SPCX | 2026-09-17 10:32 | call_diagonal_spread | 2 | 1 | 7 | 45535.00 | short | ask | 155.0300 | 2.7000 | ["123","130"] | ["1.0958","0.5487"] | [] | ["XCBO"] | 123.0000 | 130.0000 | 8 | 92 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:32:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb6-a013-77e2-97c6-08a9bdc9350f | SPCX | 2026-09-17 10:12 | call_diagonal_spread | 2 | 1 | 106 | 61586.00 | long | bid | 156.3700 | 0.0900 | ["160","172.5"] | ["0.5692","0.5616"] | [] | ["ARCO"] | 160.0000 | 172.5000 | 8 | 15 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:13:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb0-bc43-7081-84a3-d2c46e89a422 | SPCX | 2026-09-17 10:06 | call_diagonal_spread | 2 | 1 | 86 | 45322.00 | short | bid | 154.7000 | 0.0700 | ["225","280"] | ["0.5658","0.5644"] | [] | ["XISX"] | 225.0000 | 280.0000 | 92 | 183 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:06:48Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a632-d0d6-7ce2-bada-4640cb7aa8f7 | SPCX | 2026-09-15 13:52 | call_diagonal_spread | 2 | 7 | 68 | 42568.00 | unknown | — | 143.1200 | 0.0700 | ["145","180"] | ["0.6053","0.5351"] | [] | ["AMXO","ARCO","C2OX","EDGO","EMLD","XISX"] | 145.0000 | 180.0000 | 3 | 94 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:53:18Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a09164-1518-7a82-81bf-1670e28090e9 | SPCX | 2026-09-11 12:54 | call_diagonal_spread | 2 | 2 | 18 | 34645.00 | short | ask | 148.5409 | 0.1000 | ["138","150"] | ["1.5377","0.4968"] | [] | ["BATO","C2OX"] | 138.0000 | 150.0000 | 0 | 35 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:54:13Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09105-f758-7a23-978b-b458a511e8b2 | SPCX | 2026-09-11 11:11 | call_diagonal_spread | 2 | 1 | 8 | 29880.00 | short | bid | 146.4710 | 1.0500 | ["129","130"] | ["3.1499","0.5120"] | [] | ["XISX"] | 129.0000 | 130.0000 | 0 | 35 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:11:58Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090f7-e1e0-7823-b610-123c26f8b84e | SPCX | 2026-09-11 10:55 | call_diagonal_spread | 2 | 1 | 10 | 31300.00 | short | bid | 147.3650 | 0.6500 | ["133","135"] | ["2.3087","0.5151"] | [] | ["MCRY"] | 133.0000 | 135.0000 | 0 | 35 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:56:11Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cd2-aa01-7b30-9ae0-884604df4230 | SPCX | 2026-09-10 15:36 | call_diagonal_spread | 2 | 2 | 4 | 28260.00 | short | bid | 148.3599 | 1.9500 | ["110","116"] | ["1.4106","1.8984"] | [] | ["XCBO"] | 110.0000 | 116.0000 | 1 | 8 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:37:17Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08677-7398-7193-8a26-ad5a3346f91e | SPCX | 2026-09-09 09:59 | call_diagonal_spread | 2 | 1 | 5 | 35875.00 | short | ask | 151.7800 | 2.2000 | ["105","130"] | ["1.1517","0.5498"] | [] | ["XCBO"] | 105.0000 | 130.0000 | 9 | 37 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:59:36Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08257-21a0-7e83-b7d7-a6437e25c474 | SPCX | 2026-09-08 14:45 | call_diagonal_spread | 2 | 1 | 40 | 104400.00 | short | bid | 153.8150 | 0.2000 | ["146","155"] | ["0.5768","0.5678"] | [] | ["XISX"] | 146.0000 | 155.0000 | 10 | 73 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:45:47Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081e5-02c8-7262-bf5a-f07562ce4336 | SPCX | 2026-09-08 12:41 | call_diagonal_spread | 2 | 1 | 10 | 31750.00 | short | ask | 154.6138 | 0.3000 | ["135","145"] | ["0.8681","0.5816"] | [] | ["XCBO"] | 135.0000 | 145.0000 | 3 | 10 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:41:46Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |