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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b623-6e1f-7c21-a784-dbf8f5bb2908 | TLT | 2026-09-18 16:09 | other | 3 | 1 | 180 | 104940.00 | unknown | ask | 81.2100 | 0.3200 | ["83.5","84","85"] | ["0.1425","0.1437","0.1808"] | [] | ["XPHO"] | 83.5000 | 85.0000 | 7 | 12 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T20:10:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b61a-80f8-73c0-989d-ae1c3be8c8e0 | EWZ | 2026-09-18 15:59 | other | 3 | 1 | 6000 | 1855200.00 | unknown | ask | 37.5200 | 0.2100 | ["40","41","45"] | ["0.4006","0.4497","0.4373"] | [] | ["SPHR"] | 40.0000 | 45.0000 | 63 | 91 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b60e-5b97-7362-8c19-434ec56277cd | PYPL | 2026-09-18 15:46 | other | 4 | 1 | 540 | 3576960.00 | unknown | ask | 52.4250 | 10.0500 | ["60","75","80"] | ["0.7868","0.4495","0.5562"] | [] | ["XPHO"] | 60.0000 | 80.0000 | 7 | 455 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:46:28Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b60d-c33f-7543-9cc7-a94a6b0ebf25 | ALMS | 2026-09-18 15:45 | other | 3 | 1 | 500 | 225000.00 | unknown | ask | 7.6100 | 5.1000 | ["9"] | ["12.6672"] | [] | ["XBOX"] | 9.0000 | 9.0000 | 0 | 91 | false | false | true | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:46:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b603-cc77-7a12-b262-20ef03280a16 | IWM | 2026-09-18 15:34 | other | 5 | 1 | 150 | 677100.00 | unknown | ask | 283.5600 | 2.8400 | ["284","286","290","297","305"] | ["0.1564","0.1380","0.1967","0.1327","0.1926"] | [] | ["XBOX"] | 284.0000 | 305.0000 | 7 | 154 | false | false | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:34:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5d6-ccf0-7192-8a81-ff4720fe4214 | BKNG | 2026-09-18 14:45 | other | 3 | 1 | 140 | 1044320.00 | unknown | ask | 168.1600 | 10.7000 | ["200","205","215"] | ["0.6933","0.6013","1.2395"] | [] | ["XPHO"] | 200.0000 | 215.0000 | 7 | 21 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:46:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5d3-8ce8-73d2-89a6-aecec467e3ab | XLF | 2026-09-18 14:42 | other | 4 | 4 | 12500 | 14887500.00 | unknown | ask | 55.8850 | 0.3300 | ["50"] | ["2.4658"] | [] | ["AMXO"] | 50.0000 | 50.0000 | 0 | 28 | false | false | true | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:42:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b58f-c557-7990-9926-380ea4095ff4 | GFL | 2026-09-18 13:28 | other | 3 | 1 | 976 | 478240.00 | unknown | ask | 42.3750 | 0.4500 | ["40","45","50"] | ["0.5275","0.4197","0.3626"] | [] | ["AMXO"] | 40.0000 | 50.0000 | 28 | 91 | false | true | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:28:40Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b579-e3c7-7b62-b526-f09488d6829d | EFA | 2026-09-18 13:04 | other | 6 | 3 | 2999 | 4186604.00 | unknown | ask | 104.8150 | 2.1100 | ["85","90","95","100","102","114"] | ["4.3580","0.2305","2.4160","2.0251","0.1989","0.1433"] | [] | ["AMXO"] | 85.0000 | 114.0000 | 0 | 272 | false | false | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:04:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b56b-ddef-7793-9f4b-2822cc1d15c0 | TXG | 2026-09-18 12:48 | other | 3 | 1 | 250 | 530000.00 | unknown | ask | 76.2900 | 5.2000 | ["70"] | ["2.3086"] | [] | ["XBOX"] | 70.0000 | 70.0000 | 0 | 28 | false | false | true | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:49:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b56a-3427-7d11-8169-eda5d8db0f4e | GLD | 2026-09-18 12:47 | other | 4 | 2 | 1000 | 2183000.00 | unknown | ask | 401.3000 | 1.1000 | ["390","395","410","420"] | ["0.2317","0.2130","0.2185","0.2363"] | [] | ["AMXO"] | 390.0000 | 420.0000 | 28 | 63 | false | true | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:47:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55e-87e0-75d1-ab83-d8d79cf06c34 | TLT | 2026-09-18 12:34 | other | 3 | 1 | 1400 | 236600.00 | unknown | ask | 81.2299 | 0.0500 | ["81","83"] | ["0.1277","0.0933"] | [] | ["XPHO"] | 81.0000 | 83.0000 | 28 | 91 | false | true | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:34:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b554-fa8f-7562-b018-b3317cf1129f | MSFT | 2026-09-18 12:23 | other | 4 | 2 | 1900 | 7785250.00 | unknown | ask | 493.1400 | 1.7500 | ["455","470","495","500"] | ["0.3142","0.2531","0.2394","0.3007"] | [] | ["AMXO"] | 455.0000 | 500.0000 | 28 | 63 | false | true | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:24:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b550-eb80-7cb0-bf5f-37b0fe3d2611 | NDX | 2026-09-18 12:19 | other | 5 | 1 | 100 | 5866800.00 | unknown | ask | 0.0000 | 51.0000 | ["24000","26000","31000","34000","41000"] | ["0.3646","0.2852","0.1716","0.1737","0.2017"] | [] | ["XPHO"] | 24000.0000 | 41000.0000 | 28 | 272 | false | false | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:19:56Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b543-9570-7dc2-8949-c3a96890268a | PLTR | 2026-09-18 12:04 | other | 4 | 2 | 1000 | 1055000.00 | unknown | ask | 176.0800 | 0.3600 | ["170","180","185"] | ["1.2014","0.5656","0.4544"] | [] | ["ARCO"] | 170.0000 | 185.0000 | 0 | 7 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:05:21Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b51e-d348-7372-a873-69b00b437a2d | QQQ | 2026-09-18 11:24 | other | 4 | 2 | 1000 | 6115000.00 | unknown | ask | 717.0100 | 0.4100 | ["715"] | ["0.1887"] | [] | ["AMXO"] | 715.0000 | 715.0000 | 0 | 91 | false | false | true | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:25:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b507-4407-7360-becd-84410a52ecf9 | USO | 2026-09-18 10:59 | other | 4 | 3 | 20 | 408100.00 | unknown | ask | 155.9700 | 16.6500 | ["133","137"] | ["0.3693","0.3750"] | [] | ["AMXO"] | 133.0000 | 137.0000 | 819 | 854 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:59:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b505-a5f7-7050-83dc-5a536e5605d1 | FCX | 2026-09-18 10:57 | other | 3 | 1 | 683 | 698770.00 | unknown | ask | 70.6000 | 0.5700 | ["70","72.5","75"] | ["0.4498","0.4540","0.9275"] | [] | ["XBOX"] | 70.0000 | 75.0000 | 0 | 28 | false | false | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:57:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fd-2a18-70d2-97f0-be7e44ad149e | AAPL | 2026-09-18 10:48 | other | 4 | 1 | 1000 | 575000.00 | unknown | ask | 333.2128 | 0.2300 | ["335","340"] | ["0.2863","0.3221"] | [] | ["XBOX"] | 335.0000 | 340.0000 | 0 | 7 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:48:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fa-b52f-7df0-b87f-4dd1ce2f5282 | IOT | 2026-09-18 10:45 | other | 4 | 1 | 1671 | 518010.00 | unknown | ask | 39.0250 | 2.3500 | ["23","27","28","34"] | ["8.4197","6.0534","0.6439","0.6251"] | [] | ["XBOX"] | 23.0000 | 34.0000 | 0 | 91 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:45:26Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ed-8dff-7812-89a1-1898c265fac4 | COP | 2026-09-18 10:31 | other | 2 | 1 | 572 | 1492920.00 | unknown | ask | 132.9973 | 1.6500 | ["115","130"] | ["0.2960","0.3398"] | [] | ["AMXO"] | 115.0000 | 130.0000 | 63 | 91 | false | false | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:31:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e1-f928-7a93-8734-a5b1a6856b34 | SMH | 2026-09-18 10:18 | other | 3 | 1 | 750 | 1692500.00 | unknown | ask | 566.1450 | 3.2000 | ["400","625","750"] | ["0.4428","0.3278","0.3294"] | ["637.95","974.10"] | ["SPHR"] | 400.0000 | 750.0000 | 119 | 119 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:18:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d0-596f-7a50-997f-a013bb52ec86 | RDDT | 2026-09-18 09:59 | other | 4 | 1 | 300 | 133500.00 | unknown | ask | 151.7210 | 1.0000 | ["155","162.5","165","172.5"] | ["0.5370","0.5552","1.3819","2.1834"] | [] | ["SPHR"] | 155.0000 | 172.5000 | 0 | 7 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:59:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4be-bda0-7483-9330-89282fc30d61 | HYG | 2026-09-18 09:39 | other | 5 | 1 | 3000 | 417000.00 | unknown | ask | 78.5950 | 0.4500 | ["75","79","80"] | ["0.5778","0.1270","0.4716"] | [] | ["XPHO"] | 75.0000 | 80.0000 | 0 | 63 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:39:56Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4b9-6a58-7fa3-830f-c2c7fb569614 | MCD | 2026-09-18 09:34 | other | 3 | 1 | 190 | 366700.00 | unknown | ask | 248.8950 | 2.1000 | ["240","255","285"] | ["0.2511","0.2292","0.2325"] | ["220.70","274.30"] | ["XBOX"] | 240.0000 | 285.0000 | 91 | 91 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:34:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |