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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b627-5a07-7980-884d-19d3899ddb4c | QQQ | 2026-09-18 16:13 | synthetic | 2 | 2 | 180 | 29520.00 | long | ask | 722.6300 | 0.1300 | ["721"] | ["0.2879"] | ["722.60"] | ["AMXO"] | 721.0000 | 721.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b61e-9fa7-7142-8d5a-63b57fad8fdf | QQQ | 2026-09-18 16:04 | straddle | 2 | 2 | 300 | 57300.00 | short | bid | 722.0300 | 0.1000 | ["720"] | ["0.3618"] | ["718.09","721.91"] | ["AMXO"] | 720.0000 | 720.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T20:04:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b617-8357-7480-9c87-37582d547ecd | QQQ | 2026-09-18 15:56 | call_diagonal_spread | 2 | 1 | 88 | 40832.00 | short | bid | 721.0000 | 0.1200 | ["719","720"] | ["0.7139","0.0737"] | [] | ["SPHR"] | 719.0000 | 720.0000 | 0 | 3 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:56:28Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b613-1a70-7953-8d32-da42ca77e27d | QQQ | 2026-09-18 15:51 | synthetic | 2 | 2 | 950 | 77900.00 | long | ask | 720.0200 | 0.0200 | ["720"] | ["0.3640"] | ["720.10"] | ["AMXO"] | 720.0000 | 720.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:55Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aac6-bd63-7373-86cf-fcaa52e9ac44 | QQQ | 2026-09-16 11:12 | put_ratio_spread | 2 | 2 | 1500 | 43500.00 | unknown | — | 711.1150 | 0.0200 | ["650","684"] | ["0.5375","0.3532"] | [] | ["AMXO"] | 650.0000 | 684.0000 | 2 | 2 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:12:25Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 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 |
| 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 |
| 01a0a096-43d0-76a2-81dd-db9fc7710737 | QQQ | 2026-09-14 11:43 | other | 4 | 1 | 100 | 51400.00 | unknown | — | 709.9900 | 0.0800 | ["708","719","720","739"] | ["0.2251","0.1913","0.2596","0.1888"] | [] | ["SPHR"] | 708.0000 | 739.0000 | 0 | 4 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:43:25Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091c9-04f0-71a0-9ab6-c9de79e79c64 | QQQ | 2026-09-11 14:44 | put_frontspread | 2 | 2 | 5000 | 62000.00 | long | ask | 716.1200 | 0.0200 | ["570","660"] | ["0.6084","0.3163"] | ["547.52","659.92"] | ["AMXO"] | 570.0000 | 660.0000 | 7 | 7 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:44:57Z"} | 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 |
| 01a08275-ec71-7c91-9537-f56f918bfb0b | QQQ | 2026-09-08 15:19 | other | 2 | 1 | 16 | 90912.00 | unknown | — | 718.9761 | 1.0100 | ["745","750"] | ["0.1967","0.2419"] | [] | ["XBOX"] | 745.0000 | 750.0000 | 2 | 3 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:19:58Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08272-e318-7cd2-aaaa-8b2f6bed6ef5 | QQQ | 2026-09-08 15:15 | call_backspread | 2 | 2 | 1600 | 87600.00 | unknown | — | 719.2600 | 0.0700 | ["790","830"] | ["0.1625","0.1775"] | [] | ["ARCO"] | 790.0000 | 830.0000 | 38 | 38 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:16:37Z"} | 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 |
| 01a06e08-b13d-7ef2-8d65-b38ba97fca5a | QQQ | 2026-09-04 16:07 | other | 2 | 2 | 800 | 26000.00 | unknown | — | 718.0374 | 0.0400 | ["701","707"] | ["0.1318","0.1131"] | [] | ["AMXO"] | 701.0000 | 707.0000 | 4 | 4 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T20:11:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfa-93f5-7f92-8c05-7b39d31cd529 | QQQ | 2026-09-04 15:52 | straddle | 2 | 1 | 450 | 26550.00 | long | ask | 719.0855 | 0.0200 | ["719"] | ["0.2646"] | ["718.41","719.59"] | ["AMXO"] | 719.0000 | 719.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:52:21Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |