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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b60c-c557-77a3-82f5-fed75347e222 | QQQ | 2026-09-18 15:44 | call_vertical_spread | 2 | 1 | 100 | 109200.00 | short | bid | 719.5500 | 0.0500 | ["718","720"] | ["0.1235","0.1220"] | ["719.12"] | ["SPHR"] | 718.0000 | 720.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:44:55Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0af-f04b-78c0-9550-31c1c9ffc005 | QQQ | 2026-09-17 14:45 | call_vertical_spread | 2 | 2 | 5000 | 4840000.00 | unknown | — | 716.0800 | 0.0700 | ["720","727"] | ["0.1417","0.1344"] | [] | ["AMXO"] | 720.0000 | 727.0000 | 13 | 13 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:45:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a17c-a849-7bc1-88cd-d6be2defccaa | QQQ | 2026-09-14 15:54 | call_vertical_spread | 2 | 2 | 600 | 205800.00 | long | ask | 710.2900 | 0.2400 | ["725","745"] | ["0.1473","0.1305"] | ["727.91"] | ["ARCO"] | 725.0000 | 745.0000 | 14 | 14 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:55:00Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0d1-a6f0-7a42-9dd5-49c18ba0dc78 | QQQ | 2026-09-14 12:48 | call_vertical_spread | 2 | 1 | 120 | 70560.00 | long | ask | 711.4800 | 0.1300 | ["707","711"] | ["0.2328","0.1874"] | ["710.32"] | ["SPHR"] | 707.0000 | 711.0000 | 0 | 0 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:48:28Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0c6-44e1-7a31-951b-a579f1c3281c | QQQ | 2026-09-14 12:35 | call_vertical_spread | 2 | 1 | 5000 | 1690000.00 | long | ask | 710.1200 | 0.0800 | ["730","740"] | ["0.1476","0.1403"] | ["731.62"] | ["AMXO"] | 730.0000 | 740.0000 | 16 | 16 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:36:05Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091fa-1f40-7560-895d-1977f0ac1b72 | QQQ | 2026-09-11 15:38 | call_vertical_spread | 2 | 1 | 400 | 377200.00 | short | bid | 715.6800 | 0.1900 | ["710","712"] | ["0.5930","0.4889"] | ["711.97"] | ["SPHR"] | 710.0000 | 712.0000 | 0 | 0 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:38:09Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091a9-ff88-75e3-a5c3-1cc266301fc6 | QQQ | 2026-09-11 14:10 | call_vertical_spread | 2 | 1 | 50 | 517150.00 | short | bid | 716.3200 | 1.6800 | ["695","700"] | ["0.2185","0.2148"] | ["698.55"] | ["SPHR"] | 695.0000 | 700.0000 | 126 | 126 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:11:05Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09183-6c89-7070-bf35-004aca002b03 | QQQ | 2026-09-11 13:28 | call_vertical_spread | 2 | 1 | 1500 | 6559500.00 | short | bid | 716.8300 | 0.3300 | ["715","780"] | ["0.2051","0.1796"] | ["741.77"] | ["SPHR"] | 715.0000 | 780.0000 | 98 | 98 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:28:26Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090d7-55d9-7c10-ac08-6a1fdc06f04e | QQQ | 2026-09-11 10:20 | call_vertical_spread | 2 | 1 | 88 | 300080.00 | long | ask | 716.2000 | 0.8100 | ["700","705"] | ["0.2102","0.1964"] | ["704.20"] | ["SPHR"] | 700.0000 | 705.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:20:35Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090b6-5889-7133-8f51-488a3be93858 | QQQ | 2026-09-11 09:44 | call_vertical_spread | 2 | 1 | 201 | 208236.00 | long | ask | 715.3300 | 0.2400 | ["708","714"] | ["0.3183","0.2533"] | ["713"] | ["SPHR"] | 708.0000 | 714.0000 | 0 | 0 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:44:32Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c5f-cfa8-73a0-9b98-f23cf5bfa1da | QQQ | 2026-09-10 13:31 | call_vertical_spread | 2 | 1 | 50 | 46750.00 | short | bid | 710.3500 | 0.0800 | ["712","720"] | ["0.1918","0.1794"] | ["715.43"] | ["SPHR"] | 712.0000 | 720.0000 | 6 | 6 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:31:47Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08664-5511-7393-809e-2728f73725c3 | QQQ | 2026-09-09 09:38 | call_vertical_spread | 2 | 1 | 19289 | 1118762.00 | unknown | — | 717.0800 | 0.0200 | ["721","724"] | ["0.2285","0.2309"] | [] | ["AMXO"] | 721.0000 | 724.0000 | 0 | 0 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:38:36Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0825c-8488-7770-8ed2-374f1b4e7b6d | QQQ | 2026-09-08 14:51 | call_vertical_spread | 2 | 1 | 2027 | 3111445.00 | unknown | — | 719.0800 | 1.3500 | ["740","760"] | ["0.1760","0.1686"] | [] | ["XBOX"] | 740.0000 | 760.0000 | 45 | 45 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:51:45Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081b0-a0a0-7613-b8c0-75d1c6fffa40 | QQQ | 2026-09-08 11:43 | call_vertical_spread | 2 | 1 | 100 | 62600.00 | short | bid | 720.9299 | 0.1500 | ["717","719"] | ["0.1093","0.1686"] | ["718.64"] | ["SPHR"] | 717.0000 | 719.0000 | 0 | 0 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:44:15Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06e00-9ed5-70e0-a211-ad9fe8d09934 | QQQ | 2026-09-04 15:58 | call_vertical_spread | 2 | 2 | 200 | 214000.00 | unknown | — | 719.0900 | 0.1400 | ["720","740"] | ["0.1573","0.1428"] | [] | ["AMXO"] | 720.0000 | 740.0000 | 14 | 14 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:59:02Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |