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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b614-04d0-7b61-bdcc-db8b0b83d0fd | DE | 2026-09-18 15:52 | call_diagonal_spread | 2 | 1 | 10 | 27940.00 | long | ask | 683.0100 | 5.1000 | ["680","760"] | ["2.6843","0.3167"] | [] | ["XMIO"] | 680.0000 | 760.0000 | 0 | 119 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:52:51Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b583-4a07-7423-8e9f-484d94bc928f | DE | 2026-09-18 13:14 | call_diagonal_spread | 2 | 1 | 2 | 38068.00 | short | bid | 680.0050 | 9.4000 | ["590","600"] | ["4.6893","0.3414"] | [] | ["XCBO"] | 590.0000 | 600.0000 | 0 | 91 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:14:48Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b515-70ef-75e3-8b62-68e67504e0b3 | DE | 2026-09-18 11:14 | call_diagonal_spread | 2 | 1 | 4 | 40884.00 | long | bid | 682.8850 | 4.8000 | ["600","760"] | ["3.5298","0.3266"] | [] | ["AMXO"] | 600.0000 | 760.0000 | 0 | 91 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:14:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b511-0807-7712-8468-f83a84dfe3b1 | DE | 2026-09-18 11:09 | call_diagonal_spread | 2 | 1 | 3 | 25860.00 | long | ask | 682.9300 | 6.4000 | ["640","690"] | ["2.0692","0.3206"] | [] | ["XMIO"] | 640.0000 | 690.0000 | 0 | 91 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:09:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f3-2b80-7150-a799-d67811442d1f | DE | 2026-09-18 10:37 | call_diagonal_spread | 2 | 1 | 2 | 28560.00 | short | ask | 684.5100 | 10.0000 | ["610","620"] | ["3.4913","0.2724"] | [] | ["XMIO"] | 610.0000 | 620.0000 | 0 | 28 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:37:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d5-4340-7b03-8d53-25a17a8f34e1 | DE | 2026-09-18 10:04 | call_diagonal_spread | 2 | 1 | 11 | 188210.00 | long | ask | 682.6450 | 8.2000 | ["600","620"] | ["2.9197","0.3472"] | [] | ["XMIO"] | 600.0000 | 620.0000 | 0 | 91 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:04:31Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ce-e26f-7b41-9661-0d69b58ab4e8 | DE | 2026-09-18 09:57 | call_diagonal_spread | 2 | 1 | 6 | 539400.00 | long | bid | 683.4650 | 13.2000 | ["230","240"] | ["16.5276","0.9356"] | [] | ["XMIO"] | 230.0000 | 240.0000 | 0 | 119 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:57:33Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b04e-5bd3-7680-b0a6-2070fa2f079a | DE | 2026-09-17 12:58 | call_diagonal_spread | 2 | 1 | 9 | 323163.00 | short | ask | 680.6850 | 9.9000 | ["500","510"] | ["2.4668","0.3555"] | [] | ["XCBO"] | 500.0000 | 510.0000 | 1 | 92 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:59:04Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a58d-9fc6-7003-b94a-c3a6d8163e06 | DE | 2026-09-15 10:51 | call_diagonal_spread | 2 | 1 | 9 | 423180.00 | unknown | — | 683.5475 | 14.4000 | ["510","550"] | ["0.3861","0.3706"] | [] | ["XPHO"] | 510.0000 | 550.0000 | 493 | 857 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:51:57Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a55b-490e-7ab2-9aaf-28ad7e50a147 | DE | 2026-09-15 09:56 | call_diagonal_spread | 2 | 1 | 3 | 43527.00 | long | bid | 685.2400 | 11.8000 | ["610","660"] | ["1.0305","0.3355"] | [] | ["XCBO"] | 610.0000 | 660.0000 | 3 | 122 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:57:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a064-1fe1-79b0-a827-31b220d2881a | DE | 2026-09-14 10:48 | call_diagonal_spread | 2 | 1 | 2 | 59522.00 | short | ask | 683.6625 | 12.2000 | ["530","550"] | ["1.5204","0.3442"] | [] | ["XMIO"] | 530.0000 | 550.0000 | 4 | 95 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:49:02Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a05d-ceb0-7750-b8a8-bfb38b51cfda | DE | 2026-09-14 10:41 | call_diagonal_spread | 2 | 1 | 2 | 58912.00 | short | ask | 682.7100 | 12.1000 | ["530","550"] | ["1.3760","0.3312"] | [] | ["XCBO"] | 530.0000 | 550.0000 | 4 | 95 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:41:56Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a047-1a30-7700-b9d4-0a07463cd8ab | DE | 2026-09-14 10:16 | call_diagonal_spread | 2 | 1 | 3 | 32619.00 | short | bid | 681.1500 | 8.6000 | ["630","680"] | ["0.3923","0.3301"] | [] | ["XCBO"] | 630.0000 | 680.0000 | 4 | 123 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:17:06Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c8e-bf48-78a0-a1c2-9b46aa7f830a | DE | 2026-09-10 14:22 | call_diagonal_spread | 2 | 1 | 10 | 263710.00 | short | bid | 675.5750 | 12.2000 | ["580","600"] | ["0.3494","0.3521"] | [] | ["XMIO"] | 580.0000 | 600.0000 | 190 | 280 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:23:24Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |