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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b605-85df-75d1-b4f6-807063bb0dce | VIX | 2026-09-18 15:36 | call_vertical_spread | 2 | 1 | 40 | 27080.00 | long | ask | 14.9800 | 0.1700 | ["16","18"] | ["1.4246","1.3328"] | ["16.87"] | ["XCBO"] | 16.0000 | 18.0000 | 89 | 89 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:36:52Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0d6-9ea3-7d42-b5e1-42309ac616d7 | VIX | 2026-09-17 15:27 | call_butterfly_spread | 3 | 1 | 150 | 33825.00 | unknown | — | 15.4900 | 0.1000 | ["18","21","24"] | ["1.3102","1.3888","1.4956"] | [] | ["XCBO"] | 18.0000 | 24.0000 | 34 | 34 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:28:00Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b0-7133-73c0-bc3a-5cfcdfcde390 | VIX | 2026-09-17 14:45 | call_vertical_spread | 2 | 1 | 160 | 69760.00 | long | ask | 15.5700 | 0.1200 | ["18","20"] | ["1.2752","1.2861"] | ["18.50"] | ["XCBO"] | 18.0000 | 20.0000 | 62 | 62 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:46:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afba-41c2-7bb3-98cd-7ae8f71075e5 | VIX | 2026-09-17 10:16 | strangle | 2 | 1 | 1000 | 95000.00 | unknown | — | 15.8000 | 0.0500 | ["16","30"] | ["0.1842","1.6464"] | [] | ["XCBO"] | 16.0000 | 30.0000 | 34 | 34 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:17:06Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab35-de9a-7e31-8253-b3717d135acd | VIX | 2026-09-16 13:13 | call_vertical_spread | 2 | 1 | 400 | 25200.00 | long | ask | 16.8700 | 0.1100 | ["20","22"] | ["1.4233","1.5982"] | ["20.15"] | ["XCBO"] | 20.0000 | 22.0000 | 7 | 7 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:14:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a67b-1ca6-7031-8a84-ba8c286dcafd | VIX | 2026-09-15 15:11 | call_backspread | 2 | 1 | 2250 | 85000.00 | long | bid | 17.4300 | 0.1400 | ["20","24"] | ["1.1882","1.5938"] | ["27.22"] | ["XCBO"] | 20.0000 | 24.0000 | 8 | 8 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:11:20Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a662-d1e6-7f73-8c7a-e69b4db508a2 | VIX | 2026-09-15 14:44 | call_vertical_spread | 2 | 2 | 400 | 86400.00 | unknown | — | 17.4700 | 0.0800 | ["22.5","23.5"] | ["1.2067","1.2402"] | [] | ["XCBO"] | 22.5000 | 23.5000 | 36 | 36 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:45:11Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a57f-5f56-7d50-835f-d38e0bfd5262 | VIX | 2026-09-15 10:36 | call_vertical_spread | 2 | 1 | 1500 | 79500.00 | unknown | — | 17.4700 | 0.0700 | ["20","30"] | ["1.2126","1.9982"] | [] | ["XCBO"] | 20.0000 | 30.0000 | 8 | 8 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:36:43Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a096-3818-7cd2-9f84-04d1eb59a9f4 | VIX | 2026-09-14 11:43 | call_vertical_spread | 2 | 1 | 100 | 35900.00 | unknown | — | 16.8500 | 0.1200 | ["17","22"] | ["1.1400","1.2734"] | [] | ["XCBO"] | 17.0000 | 22.0000 | 37 | 37 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:43:25Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09198-9680-7241-8cab-482b3df0ba38 | VIX | 2026-09-11 13:51 | call_vertical_spread | 2 | 1 | 400 | 31600.00 | unknown | — | 15.6600 | 0.0800 | ["20","25"] | ["1.5407","1.8941"] | [] | ["XCBO"] | 20.0000 | 25.0000 | 12 | 12 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:52:12Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090da-3438-7962-9e67-b41974ecb82c | VIX | 2026-09-11 10:23 | call_vertical_spread | 2 | 1 | 100 | 35700.00 | unknown | — | 15.7900 | 0.1100 | ["17","22"] | ["1.3457","1.4105"] | [] | ["XCBO"] | 17.0000 | 22.0000 | 40 | 40 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:23:38Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cd4-a5d1-76e2-875a-bff45de03635 | VIX | 2026-09-10 15:38 | call_vertical_spread | 2 | 1 | 1000 | 47000.00 | unknown | — | 17.9300 | 0.0700 | ["25","30"] | ["2.1054","2.5014"] | [] | ["XCBO"] | 25.0000 | 30.0000 | 6 | 6 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:39:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bd8-2918-7953-ac48-5375e3d2d3cc | VIX | 2026-09-10 11:03 | call_calendar | 2 | 1 | 2000 | 70000.00 | short | ask | 17.4000 | 0.0600 | ["50"] | ["2.6070"] | [] | ["XCBO"] | 50.0000 | 50.0000 | 6 | 41 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:03:17Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b8a-5b20-7983-abe3-929fb52f3c36 | VIX | 2026-09-10 09:38 | other | 3 | 1 | 1500 | 61343.00 | unknown | — | 17.7600 | 0.0900 | ["16","25","37"] | ["0.8027","1.9081","2.8671"] | [] | ["XCBO"] | 16.0000 | 37.0000 | 6 | 6 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:38:21Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b8a-0d00-7d32-a5c0-cbef50c3e301 | VIX | 2026-09-10 09:37 | call_vertical_spread | 2 | 1 | 200 | 50600.00 | unknown | — | 17.7800 | 0.1200 | ["16.5","18"] | ["0.9482","1.0951"] | [] | ["XCBO"] | 16.5000 | 18.0000 | 6 | 6 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:38:05Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b88-8278-7662-97ac-22802ba722fc | VIX | 2026-09-10 09:36 | other | 2 | 1 | 3750 | 45000.00 | unknown | — | 17.7100 | 0.0500 | ["15","16"] | ["0.7843","0.7713"] | [] | ["XCBO"] | 15.0000 | 16.0000 | 6 | 6 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:36:21Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087c3-8368-7771-bb0c-5100f6da39a0 | VIX | 2026-09-09 16:02 | jade_lizard | 3 | 1 | 1500 | 69000.00 | short | bid | 16.4600 | 0.1200 | ["16","25","37"] | ["0.5108","1.9387","2.7787"] | ["15.66","25.34"] | ["XCBO"] | 16.0000 | 37.0000 | 7 | 7 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T20:04:35Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08677-b218-70a3-b46e-770dc75885c0 | VIX | 2026-09-09 09:59 | other | 3 | 1 | 200 | 84200.00 | unknown | — | 16.0700 | 0.2400 | ["15.5","18.5","21.5"] | ["0.2636","0.7675","0.9483"] | [] | ["XCBO"] | 15.5000 | 21.5000 | 42 | 42 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:00:00Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0826b-bb10-7a63-968f-d00b1ad76b65 | VIX | 2026-09-08 15:08 | other | 3 | 1 | 1500 | 84000.00 | unknown | — | 15.5300 | 0.1200 | ["16","25","37"] | ["0.6802","1.9585","2.6986"] | [] | ["XCBO"] | 16.0000 | 37.0000 | 8 | 8 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:08:52Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08190-2ff0-75e3-9092-21f1f9403031 | VIX | 2026-09-08 11:08 | other | 3 | 1 | 135 | 25020.00 | unknown | — | 15.3900 | 0.1500 | ["16.5","18","25"] | ["0.6355","1.3519","1.4991"] | [] | ["XCBO"] | 16.5000 | 25.0000 | 43 | 43 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:08:41Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |