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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b611-6108-79f2-92f4-38175c781dc3 | SOXL | 2026-09-18 15:49 | call_diagonal_spread | 2 | 1 | 200 | 206800.00 | long | ask | 119.7250 | 0.7500 | ["115","120"] | ["5.8056","0.8512"] | [] | ["XCBO"] | 115.0000 | 120.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:50:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b60f-da68-72a2-a32d-adb0126857ae | SOXL | 2026-09-18 15:48 | call_diagonal_spread | 2 | 1 | 200 | 192296.00 | long | ask | 119.8200 | 1.2000 | ["115","121"] | ["6.7476","0.8159"] | [] | ["XCBO"] | 115.0000 | 121.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:48:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c2-0888-7a43-8b88-2bb45410db80 | SOXL | 2026-09-18 14:23 | call_diagonal_spread | 2 | 1 | 10 | 168250.00 | unknown | — | 118.4400 | 6.5000 | ["40","60"] | ["0.9183","0.9309"] | [] | ["XCBO"] | 40.0000 | 60.0000 | 490 | 854 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:23:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0bf-710b-70d0-a607-c4bb2e8938b7 | SOXL | 2026-09-17 15:02 | call_diagonal_spread | 2 | 1 | 11 | 100380.00 | short | ask | 114.9200 | 5.2000 | ["80","85"] | ["1.0869","1.0755"] | [] | ["XPHO"] | 80.0000 | 85.0000 | 120 | 155 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:02:29Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a024-3c69-7590-b213-fd3f26dedcf9 | SOXL | 2026-09-14 09:38 | call_diagonal_spread | 2 | 1 | 27 | 348435.00 | long | bid | 100.3550 | 8.6000 | ["27","50"] | ["1.7719","1.1121"] | [] | ["XPHO"] | 27.0000 | 50.0000 | 123 | 158 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:38:53Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a086d5-d3c0-71c0-908b-39be81ba1987 | SOXL | 2026-09-09 11:42 | call_diagonal_spread | 2 | 1 | 84 | 300804.00 | short | ask | 125.1599 | 2.1500 | ["105","115"] | ["4.1835","1.2702"] | [] | ["XCBO"] | 105.0000 | 115.0000 | 0 | 9 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:43:08Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08233-9fc8-7831-b693-a60804cb1d56 | SOXL | 2026-09-08 14:06 | call_diagonal_spread | 2 | 1 | 16 | 117168.00 | short | ask | 125.1335 | 3.7500 | ["88","90"] | ["2.0689","1.4626"] | [] | ["XCBO"] | 88.0000 | 90.0000 | 3 | 8 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:07:09Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |