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 |
| 01a0b4ee-ed8f-7012-98d4-d7254fc54052 | VIX | 2026-09-18 10:32 | put_vertical_spread | 2 | 1 | 80 | 105840.00 | long | ask | 15.4300 | 0.2500 | ["23","25"] | ["1.0619","1.1670"] | ["23.15"] | ["XCBO"] | 23.0000 | 25.0000 | 33 | 33 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:32:55Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e8-b3cf-74c0-9dce-e186047f8199 | VIX | 2026-09-18 10:25 | put_vertical_spread | 2 | 1 | 100 | 114200.00 | long | ask | 15.5100 | 0.2000 | ["22","24"] | ["1.0160","1.1214"] | ["22.18"] | ["XCBO"] | 22.0000 | 24.0000 | 33 | 33 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:25:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 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 |
| 01a0ab9d-3b8b-74f3-84e4-8d1abf30c63b | VIX | 2026-09-16 15:06 | call_vertical_spread | 2 | 1 | 2000 | 664000.00 | long | ask | 17.5000 | 0.1300 | ["20","30"] | ["1.0783","1.3118"] | ["21.20"] | ["XCBO"] | 20.0000 | 30.0000 | 63 | 63 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:06:58Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 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 |
| 01a0aad1-6faa-7260-91d9-0aec704926bd | VIX | 2026-09-16 11:24 | risk_reversal | 2 | 1 | 964 | 145564.00 | long | ask | 16.7100 | 0.0800 | ["16.5","25"] | ["0.3661","1.4287"] | ["25.27"] | ["XCBO"] | 16.5000 | 25.0000 | 35 | 35 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:24:18Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a633-c306-7a51-bb48-e4076567d906 | VIX | 2026-09-15 13:53 | put_frontspread | 2 | 1 | 10000 | 4758366.00 | long | ask | 17.5900 | 0.1500 | ["19","22"] | ["0.5495","0.5876"] | ["15.99"] | ["XCBO"] | 19.0000 | 22.0000 | 64 | 64 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:54:13Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a090d4-f860-71a0-a6bd-c0b453fdfbd5 | VIX | 2026-09-11 10:17 | strangle | 2 | 1 | 2250 | 1053000.00 | long | ask | 15.9700 | 0.2100 | ["20","30"] | ["0.5649","1.0634"] | ["15.32","34.68"] | ["XCBO"] | 20.0000 | 30.0000 | 187 | 187 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:17:53Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090c3-d990-7371-bc62-b8c905633f7d | VIX | 2026-09-11 09:59 | call_vertical_spread | 2 | 1 | 2000 | 124000.00 | long | ask | 15.9200 | 0.0600 | ["18","20"] | ["1.4408","1.7176"] | ["18.16"] | ["XCBO"] | 18.0000 | 20.0000 | 5 | 5 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:59:17Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cb2-1df8-7072-805d-85322fa0047d | VIX | 2026-09-10 15:01 | straddle | 2 | 1 | 1000 | 245000.00 | long | ask | 17.9100 | 0.0900 | ["19"] | ["1.2143"] | ["16.55","21.45"] | ["XCBO"] | 19.0000 | 19.0000 | 6 | 6 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:01:41Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c97-2f70-7cf2-a5ee-7ad46d6c49e2 | VIX | 2026-09-10 14:31 | call_vertical_spread | 2 | 1 | 20000 | 779999.00 | long | ask | 17.8200 | 0.0600 | ["25","35"] | ["2.1151","2.7839"] | ["25.19"] | ["XCBO"] | 25.0000 | 35.0000 | 6 | 6 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:32:19Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c19-a2d0-7460-99be-3e24b07ef4ff | VIX | 2026-09-10 12:14 | call_vertical_spread | 2 | 1 | 31745 | 11083179.00 | long | ask | 17.6000 | 0.1300 | ["19","22"] | ["1.0978","1.1962"] | ["19.62"] | ["XCBO"] | 19.0000 | 22.0000 | 41 | 41 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:15:19Z"} | 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 |
| 01a086bb-e320-7da0-844e-d8fed34760a4 | VIX | 2026-09-09 11:14 | put_frontspread | 2 | 1 | 20000 | 3880000.00 | long | ask | 16.5900 | 0.1200 | ["17","19"] | ["0.5689","0.4245"] | ["15.88","18.12"] | ["XCBO"] | 17.0000 | 19.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:14:39Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08674-3b61-77a0-8783-99a4ef096b9a | VIX | 2026-09-09 09:55 | call_vertical_spread | 2 | 1 | 700 | 177800.00 | long | ask | 16.1300 | 0.1000 | ["20","25"] | ["1.2914","1.4252"] | ["20.62"] | ["XCBO"] | 20.0000 | 25.0000 | 42 | 42 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:56:16Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08163-0958-7773-b830-9827c39dd10f | VIX | 2026-09-08 10:19 | put_frontspread | 2 | 1 | 30000 | 4920000.00 | long | ask | 15.6600 | 0.0800 | ["16.5","19"] | ["0.7981","1.2010"] | ["15.58","18.34"] | ["XCBO"] | 16.5000 | 19.0000 | 8 | 8 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:19:24Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |