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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c50a-fc77-70f2-a666-3ed20b76fb85 | QQQ | 2026-09-21 13:37 | put_vertical_spread | 2 | 1 | 3000 | 663000.00 | long | ask | 738.7650 | 0.0500 | ["685","705"] | ["0.2678","0.2267"] | ["704.15"] | ["XPHO"] | 685.0000 | 705.0000 | 11 | 11 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:37:33Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c486-5387-7a62-9039-c516e6a33767 | QQQ | 2026-09-21 11:12 | put_vertical_spread | 2 | 2 | 370 | 3367000.00 | long | ask | 736.2000 | 1.7000 | ["675","775"] | ["0.2461","0.2273"] | ["736.10"] | ["AMXO"] | 675.0000 | 775.0000 | 269 | 269 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:12:26Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5b1-8dc7-7260-ad4a-406c053e3b42 | QQQ | 2026-09-18 14:05 | put_vertical_spread | 2 | 2 | 700 | 2647400.00 | unknown | ask | 717.5550 | 0.3800 | ["610","690"] | ["0.2700","0.2291"] | ["652.18"] | ["AMXO"] | 610.0000 | 690.0000 | 182 | 182 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:05:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b58b-5888-76f2-ae14-d4c07eebe983 | QQQ | 2026-09-18 13:23 | put_vertical_spread | 2 | 1 | 500 | 1544500.00 | unknown | ask | 717.1499 | 0.1300 | ["680","715"] | ["0.2288","0.2012"] | ["684.11"] | ["AMXO"] | 680.0000 | 715.0000 | 63 | 63 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:23:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b52c-ae27-76e3-981f-1880b2451f5a | QQQ | 2026-09-18 11:39 | put_vertical_spread | 2 | 1 | 5000 | 1400000.00 | unknown | ask | 716.6200 | 0.0400 | ["675","690"] | ["0.2319","0.2011"] | ["687.20"] | ["AMXO"] | 675.0000 | 690.0000 | 12 | 12 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:40:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b507-8e3f-73d2-820f-d76259b57363 | QQQ | 2026-09-18 10:59 | put_vertical_spread | 2 | 3 | 800 | 755600.00 | unknown | ask | 717.3400 | 0.1300 | ["660","665"] | ["0.2493","0.2435"] | ["657.78"] | ["AMXO"] | 660.0000 | 665.0000 | 42 | 42 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:59:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f6-b1d7-7ef2-8b32-eb7a23d4223d | QQQ | 2026-09-18 10:40 | put_vertical_spread | 2 | 2 | 200 | 382400.00 | long | ask | 716.8300 | 0.2200 | ["665","710"] | ["0.2418","0.1953"] | ["700.80"] | ["AMXO"] | 665.0000 | 710.0000 | 42 | 42 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:41:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0a0-0de3-7bc0-8066-334f17ce5e3b | QQQ | 2026-09-17 14:27 | put_vertical_spread | 2 | 2 | 200 | 519800.00 | long | ask | 716.3968 | 0.2500 | ["600","640"] | ["0.2772","0.2542"] | ["634.47"] | ["AMXO"] | 600.0000 | 640.0000 | 183 | 183 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:27:53Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b051-d28b-7661-966d-8565cce4cac1 | QQQ | 2026-09-17 13:02 | put_vertical_spread | 2 | 1 | 750 | 1848000.00 | unknown | — | 716.9200 | 5.2400 | ["430","525"] | ["0.3721","0.3177"] | [] | ["XBOX"] | 430.0000 | 525.0000 | 456 | 456 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:02:56Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb5-382b-7ca1-a58b-4bb26766623d | QQQ | 2026-09-16 15:32 | put_vertical_spread | 2 | 1 | 22000 | 10780000.00 | unknown | — | 702.7850 | 0.0200 | ["685","700"] | ["0.3028","0.2549"] | [] | ["AMXO"] | 685.0000 | 700.0000 | 2 | 2 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:32:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a69a-3d66-70a3-8905-5416a816b4cd | QQQ | 2026-09-15 15:45 | put_vertical_spread | 2 | 1 | 359 | 207502.00 | long | ask | 704.1500 | 0.1100 | ["705","709"] | ["0.2044","0.6931"] | ["705.02"] | ["SPHR"] | 705.0000 | 709.0000 | 0 | 0 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:45:52Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a68b-f90e-7e31-8ea0-8e3a5af2c108 | QQQ | 2026-09-15 15:29 | put_vertical_spread | 2 | 1 | 46 | 372048.00 | unknown | — | 704.3400 | 0.7900 | ["740","750"] | ["0.2078","0.2619"] | [] | ["XBOX"] | 740.0000 | 750.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:30:04Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5b7-2896-7f53-8564-3849a0df8578 | QQQ | 2026-09-15 11:37 | put_vertical_spread | 2 | 1 | 27680 | 5452960.00 | short | bid | 705.4200 | 0.0200 | ["675","685"] | ["0.3386","0.2965"] | ["684.43"] | ["AMXO"] | 675.0000 | 685.0000 | 3 | 3 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:37:41Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a144-e2f0-7cf0-9d58-34167c338b9f | QQQ | 2026-09-14 14:53 | put_vertical_spread | 2 | 2 | 400 | 447600.00 | unknown | — | 712.0900 | 0.1400 | ["650","700"] | ["0.2756","0.2028"] | [] | ["AMXO"] | 650.0000 | 700.0000 | 25 | 25 | false | true | false | true | false | mlft | 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 |
| 01a0a106-ef90-7041-bf7d-1e62e563dc13 | QQQ | 2026-09-14 13:46 | put_vertical_spread | 2 | 1 | 1500 | 1827000.00 | long | ask | 712.5000 | 0.1600 | ["680","710"] | ["0.2334","0.1858"] | ["703.60"] | ["AMXO"] | 680.0000 | 710.0000 | 16 | 16 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:46:45Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0e0-4138-7703-adc7-7eb7378fa94d | QQQ | 2026-09-14 13:04 | put_vertical_spread | 2 | 2 | 750 | 848250.00 | unknown | — | 711.6350 | 0.0400 | ["650","690"] | ["0.2668","0.2149"] | [] | ["ARCO"] | 650.0000 | 690.0000 | 32 | 32 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:04:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09161-e680-78e0-bcb4-d377d8ad47f1 | QQQ | 2026-09-11 12:51 | put_vertical_spread | 2 | 2 | 600 | 403800.00 | unknown | — | 715.7300 | 0.0300 | ["700","710"] | ["0.2030","0.1805"] | [] | ["AMXO"] | 700.0000 | 710.0000 | 7 | 7 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:51:50Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c32-c080-7953-ae70-17a8c9235e49 | QQQ | 2026-09-10 12:42 | put_vertical_spread | 2 | 1 | 200 | 124000.00 | long | ask | 709.9900 | 0.1000 | ["680","690"] | ["0.2499","0.2324"] | ["688.62"] | ["SPHR"] | 680.0000 | 690.0000 | 11 | 11 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:43:00Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08779-6aa9-7432-9f1a-c8e9975a9262 | QQQ | 2026-09-09 14:41 | put_vertical_spread | 2 | 1 | 5000 | 7090000.00 | unknown | — | 716.5700 | 0.1300 | ["695","705"] | ["0.2167","0.2044"] | [] | ["AMXO"] | 695.0000 | 705.0000 | 21 | 21 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:41:44Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08715-3650-78f0-af67-4c791f138a03 | QQQ | 2026-09-09 12:51 | put_vertical_spread | 2 | 1 | 5000 | 7100000.00 | long | ask | 716.7240 | 0.1200 | ["695","705"] | ["0.2177","0.2052"] | ["702.60"] | ["AMXO"] | 695.0000 | 705.0000 | 21 | 21 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:51:58Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086d0-9018-7231-8420-205066a01c0d | QQQ | 2026-09-09 11:36 | put_vertical_spread | 2 | 1 | 525 | 1102500.00 | unknown | — | 715.9900 | 0.4000 | ["600","650"] | ["0.2863","0.2524"] | [] | ["AMXO"] | 600.0000 | 650.0000 | 128 | 128 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:37:27Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086ce-ea38-79a0-8082-e82911f89f03 | QQQ | 2026-09-09 11:34 | put_vertical_spread | 2 | 1 | 525 | 1108275.00 | unknown | — | 715.8400 | 0.3600 | ["600","650"] | ["0.2866","0.2527"] | [] | ["AMXO"] | 600.0000 | 650.0000 | 128 | 128 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:35:05Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086cc-f250-7be2-8ced-1a2c968a11ba | QQQ | 2026-09-09 11:32 | put_vertical_spread | 2 | 2 | 525 | 1120875.00 | unknown | — | 715.2900 | 0.3800 | ["600","650"] | ["0.2871","0.2529"] | [] | ["AMXO"] | 600.0000 | 650.0000 | 128 | 128 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:33:23Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086cb-bdb8-7aa1-a9e9-e54fb063f9be | QQQ | 2026-09-09 11:31 | put_vertical_spread | 2 | 1 | 400 | 854000.00 | short | bid | 714.9750 | 0.3300 | ["600","650"] | ["0.2866","0.2523"] | ["643.55"] | ["AMXO"] | 600.0000 | 650.0000 | 128 | 128 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:32:05Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |