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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c469-ab97-7062-8eec-18c43c10573b | DE | 2026-09-21 10:40 | call_vertical_spread | 2 | 1 | 5 | 66645.00 | long | ask | 689.6900 | 6.4000 | ["690","700"] | ["0.3252","0.3241"] | ["694.89"] | ["XMIO"] | 690.0000 | 700.0000 | 179 | 179 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:41:09Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 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 |
| 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 |
| 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 |
| 01a0a60d-62cd-7840-b810-9b7051664a95 | DE | 2026-09-15 13:11 | call_butterfly_spread | 3 | 1 | 16 | 53712.00 | long | ask | 687.1570 | 5.4000 | ["680","710","740"] | ["0.3113","0.2993","0.2867"] | ["685.50","734.50"] | ["XMIO"] | 680.0000 | 740.0000 | 31 | 31 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:12:25Z"} | 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 |
| 01a08681-fed0-7863-b953-28878877bc45 | DE | 2026-09-09 10:10 | call_vertical_spread | 2 | 1 | 2 | 44082.00 | long | ask | 680.6950 | 9.2000 | ["570","572.5"] | ["1.2576","1.2409"] | ["572.47"] | ["XCBO"] | 570.0000 | 572.5000 | 2 | 2 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:11:15Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06d9d-0aa5-7712-a425-9c4b72a308e5 | DE | 2026-09-04 14:10 | call_diagonal_spread_bearish | 2 | 1 | 2 | 27394.00 | long | bid | 695.0900 | 13.6000 | ["625","630"] | ["6.5519","0.3168"] | [] | ["XCBO"] | 625.0000 | 630.0000 | 0 | 14 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:10:05Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d5e-e096-73d1-90f8-d0a3a432f43f | DE | 2026-09-04 13:02 | iron_condor | 4 | 1 | 10 | 83920.00 | long | ask | 698.5050 | 15.8500 | ["625","630","655","660"] | ["4.4178","2.1018","2.3713","2.7969"] | ["0","625","660"] | ["XCBO"] | 625.0000 | 660.0000 | 0 | 0 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:02:26Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d23-2f55-71f0-979b-046bc5fe9e81 | DE | 2026-09-04 11:56 | call_vertical_spread | 2 | 1 | 7 | 55188.00 | long | ask | 698.5000 | 6.5000 | ["650","680"] | ["0.3039","0.2908"] | ["674.26"] | ["XMIO"] | 650.0000 | 680.0000 | 14 | 14 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T15:57:07Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |