Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b51b-8788-79f2-8a47-1ef159ba74ee | DE | 2026-09-18 11:21 | other | 4 | 1 | 21 | 109788.00 | unknown | — | 682.7350 | 13.7000 | ["650","680","710","740"] | ["2.2456","0.4114","0.2787","0.2944"] | [] | ["XPHO"] | 650.0000 | 740.0000 | 0 | 28 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:21:36Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b511-ee7f-7c40-a0cd-2ce045313937 | DE | 2026-09-18 11:10 | other | 4 | 1 | 5 | 30440.00 | unknown | bid | 682.7800 | 16.1000 | ["700","710"] | ["0.2969","0.2926"] | [] | ["XCBO"] | 700.0000 | 710.0000 | 21 | 42 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:10:52Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b064-e173-7820-bf8f-de4cd1357b5e | DE | 2026-09-17 13:23 | strangle_swap | 4 | 1 | 2 | 37392.00 | unknown | — | 682.5240 | 19.7000 | ["500","660","700"] | ["0.3855","0.3347","0.3334"] | [] | ["AMXO"] | 500.0000 | 700.0000 | 183 | 273 | false | false | true | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:23:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aafe-82bb-7771-b8af-18d4f157929c | DE | 2026-09-16 12:13 | put_calendar | 2 | 1 | 4 | 69484.00 | unknown | — | 673.2850 | 10.4000 | ["640"] | ["0.3749"] | [] | ["XMIO"] | 640.0000 | 640.0000 | 492 | 856 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:13:23Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a6a2-4be6-76f3-8b14-01dbc90ecb8d | DE | 2026-09-15 15:54 | other | 4 | 1 | 5 | 286160.00 | unknown | — | 681.6500 | 24.4000 | ["540","550"] | ["0.8369","0.8257"] | [] | ["XCBO"] | 540.0000 | 550.0000 | 3 | 94 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:54:29Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a613-004e-7043-966f-70353f51f6d8 | DE | 2026-09-15 13:17 | call_vertical_spread | 2 | 1 | 9 | 45675.00 | unknown | — | 686.8450 | 12.5000 | ["662.5","665"] | ["0.3910","0.3863"] | [] | ["XCBO"] | 662.5000 | 665.0000 | 3 | 3 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:18:02Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a604-b80e-70c2-b683-9edeb9d3d6a1 | DE | 2026-09-15 13:01 | put_ratio_spread | 2 | 1 | 16 | 33226.00 | unknown | — | 688.6950 | 4.7000 | ["650","680"] | ["0.3314","0.3290"] | [] | ["XCBO"] | 650.0000 | 680.0000 | 31 | 31 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:02:11Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 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 |
| 01a0a085-f408-7e81-9233-92ae17ad1dbe | DE | 2026-09-14 11:25 | call_vertical_spread | 2 | 1 | 4 | 58400.00 | unknown | — | 687.5500 | 11.8000 | ["612.5","615"] | ["0.7832","0.7619"] | [] | ["XCBO"] | 612.5000 | 615.0000 | 4 | 4 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:25:35Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091b6-3871-7441-822b-640356d77b9e | DE | 2026-09-11 14:23 | other | 4 | 1 | 5 | 50560.00 | unknown | — | 679.5200 | 13.0000 | ["690","700","730","740"] | ["0.3014","0.3018","0.3324","0.3339"] | [] | ["XCBO"] | 690.0000 | 740.0000 | 42 | 98 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:24:15Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09170-3e60-77f0-9821-a83574d89e4e | DE | 2026-09-11 13:07 | other | 4 | 1 | 3 | 31068.00 | unknown | — | 683.0194 | 9.3000 | ["690","700","730","740"] | ["0.2876","0.2887","0.3288","0.3300"] | [] | ["XCBO"] | 690.0000 | 740.0000 | 42 | 98 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:07:41Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a06db3-a3cd-7110-a4b4-9150a77c6edf | DE | 2026-09-04 14:34 | call_vertical_spread | 2 | 1 | 15 | 41640.00 | unknown | — | 695.4250 | 10.9000 | ["680","682.5"] | ["2.2219","2.0425"] | [] | ["XCBO"] | 680.0000 | 682.5000 | 0 | 0 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:35:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d35-4ff5-7d12-b04c-b782bf93624f | DE | 2026-09-04 12:16 | other | 2 | 1 | 2 | 49880.00 | unknown | — | 699.2100 | 14.8000 | ["700","720"] | ["0.3510","0.3482"] | [] | ["XCBO"] | 700.0000 | 720.0000 | 469 | 504 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:17:14Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |