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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c58b-e85e-76c0-b51f-ae769f26945e | GEV | 2026-09-21 15:57 | call_vertical_spread | 2 | 1 | 15 | 126390.00 | long | ask | 947.5100 | 3.5000 | ["950","970"] | ["0.4708","0.4698"] | ["958.92"] | ["XCBO"] | 950.0000 | 970.0000 | 25 | 25 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:57:56Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c432-b15f-75f1-8355-385b99fdcf52 | GEV | 2026-09-21 09:40 | call_vertical_spread | 2 | 1 | 30 | 112830.00 | unknown | ask | 951.0500 | 2.2000 | ["952.5","957.5"] | ["0.5158","0.5147"] | ["973.80"] | ["XCBO"] | 952.5000 | 957.5000 | 4 | 4 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:40:51Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c42b-f6b6-74c3-84fb-e8d83efb499b | GEV | 2026-09-21 09:33 | call_vertical_spread | 2 | 1 | 10 | 206260.00 | long | ask | 949.6150 | 15.0000 | ["880","1000"] | ["0.4923","0.4900"] | ["938.20"] | ["XCBO"] | 880.0000 | 1000.0000 | 88 | 88 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:33:34Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b594-5168-7371-90fd-6f5646a6731a | GEV | 2026-09-18 13:33 | call_vertical_spread | 2 | 1 | 10 | 169820.00 | long | ask | 930.8300 | 11.8000 | ["980","990"] | ["0.4813","0.4816"] | ["983.74"] | ["XCBO"] | 980.0000 | 990.0000 | 119 | 119 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:33:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aad2-041b-7fc3-9c90-341bb0f6c81b | GEV | 2026-09-16 11:24 | call_vertical_spread | 2 | 1 | 5 | 243450.00 | long | ask | 923.3400 | 17.8000 | ["880","900"] | ["0.5128","0.5116"] | ["888.98"] | ["XMIO"] | 880.0000 | 900.0000 | 457 | 457 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:25:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa9d-adab-7370-b6d3-b2874d74af14 | GEV | 2026-09-16 10:27 | put_vertical_spread | 2 | 1 | 50 | 133300.00 | long | ask | 892.6400 | 8.1000 | ["860","870"] | ["0.4533","0.4539"] | ["866.60"] | ["XCBO"] | 860.0000 | 870.0000 | 9 | 9 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:28:05Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a180-2ab8-7bb0-bf53-5f7d0b92f16b | GEV | 2026-09-14 15:58 | call_vertical_spread | 2 | 1 | 21 | 1572879.00 | long | ask | 873.9100 | 16.0000 | ["580","600"] | ["0.5484","0.5450"] | ["593.15"] | ["XMIO"] | 580.0000 | 600.0000 | 494 | 494 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:59:02Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a161-1d80-7cf3-958e-a22e6d3f95fb | GEV | 2026-09-14 15:24 | call_vertical_spread | 2 | 1 | 90 | 2381580.00 | long | ask | 875.0400 | 8.8000 | ["870","880"] | ["0.5065","0.5057"] | ["874.60"] | ["XCBO"] | 870.0000 | 880.0000 | 186 | 186 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:25:22Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a144-6208-7d22-82a5-cadd925cdbc7 | GEV | 2026-09-14 14:53 | put_diagonal_spread | 2 | 1 | 9 | 159219.00 | long | ask | 878.7500 | 12.3000 | ["860","900"] | ["0.4964","0.5049"] | [] | ["XCBO"] | 860.0000 | 900.0000 | 46 | 186 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:54:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a12b-f808-7b82-8c2d-585938dd1d97 | GEV | 2026-09-14 14:26 | call_calendar | 2 | 1 | 12 | 122014.00 | long | ask | 875.2425 | 11.1000 | ["920"] | ["0.4913"] | [] | ["XCBO"] | 920.0000 | 920.0000 | 46 | 67 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:27:00Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a12b-c540-7ab0-ba5a-9f1e2aa73b17 | GEV | 2026-09-14 14:26 | ratio_risk_reversal | 2 | 1 | 6 | 238638.00 | long | ask | 875.0500 | 16.4000 | ["850","900"] | ["0.5117","0.5352"] | ["837.95"] | ["XPHO"] | 850.0000 | 900.0000 | 823 | 823 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:27:00Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0f5-d0c0-75e0-b2c1-b58cf44adceb | GEV | 2026-09-14 13:27 | call_vertical_spread | 2 | 1 | 2 | 106234.00 | long | ask | 874.1400 | 18.3000 | ["950","980"] | ["0.5309","0.5311"] | ["959.25"] | ["XCBO"] | 950.0000 | 980.0000 | 823 | 823 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:28:18Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0c0-7881-7dd2-ba1a-812285acd700 | GEV | 2026-09-14 12:29 | call_vertical_spread | 2 | 1 | 2 | 140804.00 | long | ask | 871.6600 | 20.0000 | ["730","740"] | ["0.5407","0.5401"] | ["734.50"] | ["XCBO"] | 730.0000 | 740.0000 | 823 | 823 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:29:31Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0a9-3378-72e3-86f2-34f8d4e430a4 | GEV | 2026-09-14 12:03 | call_diagonal_spread | 2 | 1 | 3 | 394011.00 | short | ask | 874.0200 | 18.7000 | ["180","280"] | ["1.2320","0.6497"] | [] | ["XCBO"] | 180.0000 | 280.0000 | 123 | 494 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:04:17Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a044-f750-7bc0-9106-ad13dc7d85e6 | GEV | 2026-09-14 10:14 | call_diagonal_spread | 2 | 1 | 43 | 439976.00 | short | ask | 885.0001 | 13.4000 | ["1200","1340"] | ["0.4979","0.5142"] | [] | ["EDGO"] | 1200.0000 | 1340.0000 | 214 | 276 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:14:50Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a03e-7358-7162-b823-043ec87eccd5 | GEV | 2026-09-14 10:07 | put_diagonal_spread | 2 | 1 | 45 | 177975.00 | long | ask | 886.7850 | 10.7000 | ["870","875"] | ["0.5048","0.6118"] | [] | ["XMIO"] | 870.0000 | 875.0000 | 4 | 11 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:07:31Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091d3-0b58-7253-b735-fef71d0167a9 | GEV | 2026-09-11 14:55 | call_diagonal_spread | 2 | 1 | 2 | 167452.00 | short | ask | 952.9950 | 18.5000 | ["620","630"] | ["0.5326","0.5307"] | [] | ["XMIO"] | 620.0000 | 630.0000 | 462 | 497 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:55:36Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c12-6740-7641-b07a-7300063199c4 | GEV | 2026-09-10 12:06 | put_diagonal_spread | 2 | 1 | 5 | 103460.00 | long | ask | 927.4000 | 4.0000 | ["940","950"] | ["0.4838","0.4881"] | [] | ["XCBO"] | 940.0000 | 950.0000 | 99 | 127 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:06:52Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0821e-8d40-7fd3-8db8-644f2dd44d2b | GEV | 2026-09-08 13:43 | call_diagonal_spread | 2 | 1 | 15 | 129443.00 | long | ask | 970.3350 | 11.2000 | ["935","950"] | ["0.5842","0.5012"] | [] | ["XCBO"] | 935.0000 | 950.0000 | 3 | 10 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:44:03Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08211-cba0-7570-9c9d-c3571e67b7af | GEV | 2026-09-08 13:29 | call_diagonal_spread | 2 | 1 | 10 | 372710.00 | long | ask | 972.1400 | 12.8000 | ["800","820"] | ["0.4943","0.5030"] | [] | ["AMXO"] | 800.0000 | 820.0000 | 10 | 129 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:30:10Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08174-7a30-77b0-9060-936111e80c57 | GEV | 2026-09-08 10:38 | call_vertical_spread | 2 | 1 | 2 | 133432.00 | long | ask | 964.3000 | 16.3000 | ["950","980"] | ["0.5323","0.5316"] | ["961"] | ["XCBO"] | 950.0000 | 980.0000 | 829 | 829 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:38:15Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |