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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4da-3047-7773-8026-dfee69ba592a | TLT | 2026-09-21 12:43 | put_condor | 4 | 1 | 225 | 483075.00 | long | ask | 81.7550 | 1.1300 | ["82","85","87","90"] | ["0.1518","0.1712","0.1893","0.2292"] | ["82.83","89.17"] | ["SPHR"] | 82.0000 | 90.0000 | 116 | 116 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:43:49Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b582-0d9f-7091-9733-175df4d51b90 | HYG | 2026-09-18 13:13 | put_condor | 4 | 2 | 1700 | 375700.00 | short | bid | 78.4900 | 0.4100 | ["75","76","78","79"] | ["0.1042","0.0982","0.0838","0.0873"] | ["75.37","78.63"] | ["AMXO"] | 75.0000 | 79.0000 | 63 | 63 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:13:28Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b502-a087-73e0-86c2-96fd5bb783b3 | MXEF | 2026-09-18 10:54 | put_condor | 4 | 3 | 170 | 6928350.00 | unknown | bid | 1708.8500 | 23.9000 | ["1450","1540","1600","1700"] | ["0.3010","0.2883","0.2852","0.2763"] | ["1641.55"] | ["ARCO"] | 1450.0000 | 1700.0000 | 364 | 364 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:54:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0ea-a3a3-7f71-b89f-0301507d89a8 | HOOD | 2026-09-17 15:49 | put_condor | 4 | 1 | 75 | 1629750.00 | unknown | — | 109.0350 | 1.5500 | ["130","170","175","180"] | ["2.0154","4.2364","4.3151","4.6762"] | [] | ["XPHO"] | 130.0000 | 180.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:49:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b6-129b-7fc2-b494-c1af086e3778 | ASML | 2026-09-17 14:51 | put_condor | 4 | 1 | 21 | 1595580.00 | unknown | — | 1626.3200 | 59.1000 | ["1755","1810","1830","1870"] | ["1.2619","1.6698","1.6517","2.0510"] | [] | ["XBOX"] | 1755.0000 | 1870.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:51:58Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb9-9173-7040-b945-0842c161d08e | IWM | 2026-09-16 15:37 | put_condor | 4 | 1 | 1786 | 2465931.00 | short | bid | 282.1138 | 0.1800 | ["255","265","275","285"] | ["0.2805","0.2515","0.2199","0.1899"] | ["257.53","282.47"] | ["XBOX"] | 255.0000 | 285.0000 | 30 | 30 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:37:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a559-4956-7e03-a275-244ba9c98d2d | IWM | 2026-09-15 09:54 | put_condor | 4 | 1 | 800 | 988000.00 | unknown | — | 285.6600 | 0.1700 | ["260","270","280","285"] | ["0.2619","0.2322","0.2041","0.1905"] | [] | ["XBOX"] | 260.0000 | 285.0000 | 31 | 31 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:55:16Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08bf3-2b28-7f53-8d20-ddb58c3e84f3 | QQQ | 2026-09-10 11:32 | put_condor | 4 | 2 | 275 | 716100.00 | unknown | — | 710.8050 | 0.2900 | ["675","680","705","710"] | ["0.2588","0.2502","0.2104","0.2024"] | [] | ["AMXO"] | 675.0000 | 710.0000 | 15 | 15 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:32:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bdd-8430-7221-b35c-6cc3cc83cb98 | GLD | 2026-09-10 11:09 | put_condor | 4 | 5 | 17500 | 11740000.00 | unknown | — | 399.5800 | 0.4500 | ["390","393","395","400"] | ["0.4050","0.4114","0.4088","0.4020"] | [] | ["AMXO"] | 390.0000 | 400.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:09:17Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bda-e839-7893-907d-7d00c8e79a49 | TLT | 2026-09-10 11:06 | put_condor | 4 | 1 | 65000 | 10887500.00 | unknown | — | 81.0600 | 0.0500 | ["77","78","79","80"] | ["0.1434","0.1361","0.1313","0.1292"] | [] | ["XPHO"] | 77.0000 | 80.0000 | 36 | 36 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:06:33Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0879f-f9c0-76c0-8be5-ca80824b662e | JETS | 2026-09-09 15:23 | put_condor | 4 | 1 | 3300 | 1537800.00 | unknown | — | 28.0450 | 0.6300 | ["23","25","27","29"] | ["0.3605","0.3495","0.3394","0.3322"] | [] | ["XPHO"] | 23.0000 | 29.0000 | 100 | 100 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:23:39Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0872a-2d81-7252-b685-824f7e8ca351 | USO | 2026-09-09 13:14 | put_condor | 4 | 1 | 250 | 152500.00 | long | ask | 147.8750 | 0.4200 | ["127","135","140","148"] | ["0.5552","0.4650","0.4427","0.4543"] | ["129.68","145.32"] | ["SPHR"] | 127.0000 | 148.0000 | 9 | 9 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:15:06Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0871f-b5d0-7c10-9f13-e228dca529c0 | USO | 2026-09-09 13:03 | put_condor | 4 | 1 | 250 | 151750.00 | long | ask | 148.0300 | 0.5100 | ["127","135","140","148"] | ["0.5582","0.4687","0.4429","0.4623"] | ["129.71","145.29"] | ["SPHR"] | 127.0000 | 148.0000 | 9 | 9 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:03:21Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |