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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5f1-a020-7fd2-921c-9e7986e0419a | QQQ | 2026-09-18 15:15 | strangle | 2 | 2 | 150 | 209400.00 | long | ask | 719.2200 | 0.0400 | ["710","740"] | ["0.1812","0.1447"] | ["696.04","753.96"] | ["AMXO"] | 710.0000 | 740.0000 | 28 | 28 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:15:21Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b53b-2547-7f30-bec8-e0bcbf4aaa65 | QQQ | 2026-09-18 11:55 | strangle | 2 | 2 | 600 | 4818000.00 | short | bid | 716.4050 | 0.5600 | ["730","740"] | ["0.2183","0.2029"] | ["649.70","820.30"] | ["AMXO"] | 730.0000 | 740.0000 | 182 | 182 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:55:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a640-905e-7740-a3cd-7b49a6b74e44 | QQQ | 2026-09-15 14:07 | strangle | 2 | 2 | 100 | 380900.00 | unknown | — | 705.3300 | 0.5900 | ["640","850"] | ["0.2554","0.1961"] | [] | ["ARCO"] | 640.0000 | 850.0000 | 275 | 275 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:07:24Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a100-38d1-76e3-ad29-d9c4043473ff | QQQ | 2026-09-14 13:38 | strangle | 2 | 1 | 50 | 94350.00 | long | ask | 712.3500 | 0.2100 | ["705","715"] | ["0.1976","0.1737"] | ["686.13","733.87"] | ["AMXO"] | 705.0000 | 715.0000 | 18 | 18 | false | true | false | true | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:38:59Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0fe-cd88-7041-8268-aadb34ad8b89 | QQQ | 2026-09-14 13:37 | strangle | 2 | 2 | 250 | 471750.00 | long | ask | 712.1500 | 0.2100 | ["705","715"] | ["0.1975","0.1741"] | ["686.13","733.87"] | ["AMXO"] | 705.0000 | 715.0000 | 18 | 18 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:37:27Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08cd2-2918-7981-a205-61cb59cf50fc | QQQ | 2026-09-10 15:36 | strangle | 2 | 1 | 50 | 513500.00 | long | ask | 709.1200 | 9.0000 | ["575","800"] | ["0.2847","0.2288"] | ["472.30","902.70"] | ["AMXO"] | 575.0000 | 800.0000 | 645 | 645 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:36:43Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cb0-31c8-7381-aa43-00169605c3a6 | QQQ | 2026-09-10 14:59 | strangle | 2 | 2 | 375 | 1623750.00 | short | bid | 709.5600 | 0.6500 | ["640","840"] | ["0.2602","0.2055"] | ["596.70","883.30"] | ["AMXO"] | 640.0000 | 840.0000 | 280 | 280 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:59:46Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0873e-4608-7491-a008-dd6bdae7bcda | QQQ | 2026-09-09 13:36 | strangle | 2 | 2 | 250 | 1062500.00 | short | bid | 716.2900 | 0.5300 | ["695","765"] | ["0.2264","0.1949"] | ["652.50","807.50"] | ["AMXO"] | 695.0000 | 765.0000 | 128 | 128 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:36:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081a3-fe40-7ef0-9278-74ed55749dce | QQQ | 2026-09-08 11:30 | strangle | 2 | 1 | 350 | 4235000.00 | short | bid | 720.1249 | 4.6200 | ["730","800"] | ["0.2507","0.2184"] | ["609","921.00"] | ["XPHO"] | 730.0000 | 800.0000 | 465 | 465 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:30:32Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d73-3f6d-70b0-9ec6-a41f1e9adb91 | QQQ | 2026-09-04 13:24 | strangle | 2 | 1 | 270 | 1480950.00 | long | ask | 717.7700 | 0.4000 | ["710","725"] | ["0.2084","0.1976"] | ["655.15","779.85"] | ["XPHO"] | 710.0000 | 725.0000 | 105 | 105 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:24:30Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |