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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5ca-de40-7a92-ae7a-7570bdfdb679 | QQQ | 2026-09-18 14:32 | strangle | 2 | 1 | 10 | 43530.00 | long | ask | 717.9000 | 0.2100 | ["700","750"] | ["0.2161","0.1844"] | ["656.47","793.53"] | ["XCBO"] | 700.0000 | 750.0000 | 119 | 119 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:33:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aa9d-1553-7473-b680-c1697a58fd41 | QQQ | 2026-09-16 10:26 | strangle | 2 | 1 | 5 | 150275.00 | long | ask | 709.7150 | 7.0200 | ["500","800"] | ["1.2271","0.4420"] | ["499.45","800.55"] | ["XCBO"] | 500.0000 | 800.0000 | 9 | 9 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:27:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a125-29d9-7a82-bf2d-5d06bb80af47 | QQQ | 2026-09-14 14:19 | strangle | 2 | 1 | 3 | 26853.00 | short | bid | 712.3050 | 6.9400 | ["660","748"] | ["0.2661","0.2024"] | ["658.49","749.51"] | ["MCRY"] | 660.0000 | 748.0000 | 11 | 11 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:20:09Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0c8-a640-7a40-ab2b-c308c5f63d85 | QQQ | 2026-09-14 12:38 | strangle | 2 | 1 | 200 | 33200.00 | short | bid | 710.4000 | 0.0200 | ["710","711"] | ["0.1933","0.1888"] | ["708.34","712.66"] | ["XCBO"] | 710.0000 | 711.0000 | 0 | 0 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:38:24Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0c3-6299-7052-a6e9-7ea9c0e0e046 | QQQ | 2026-09-14 12:32 | strangle | 2 | 1 | 200 | 34600.00 | long | ask | 710.4150 | 0.0200 | ["710","711"] | ["0.1972","0.1922"] | ["708.27","712.73"] | ["XCBO"] | 710.0000 | 711.0000 | 0 | 0 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:32:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a08e-aa80-7a62-b743-1606e0585d79 | QQQ | 2026-09-14 11:34 | strangle | 2 | 1 | 10 | 43590.00 | long | ask | 709.5600 | 0.9500 | ["700","720"] | ["0.2120","0.1938"] | ["656.41","763.59"] | ["XCBO"] | 700.0000 | 720.0000 | 77 | 77 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:35:04Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09116-3781-7db3-88cc-4b9bb4e69731 | QQQ | 2026-09-11 11:29 | strangle | 2 | 1 | 593 | 33208.00 | short | bid | 717.3000 | 0.0400 | ["672","759"] | ["0.2864","0.1423"] | ["671.44","759.56"] | ["XCBO"] | 672.0000 | 759.0000 | 7 | 7 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:29:14Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090ca-9c08-7ca0-b1e0-09c36701e99c | QQQ | 2026-09-11 10:06 | strangle | 2 | 1 | 10 | 36170.00 | long | ask | 714.9900 | 1.0400 | ["690","725"] | ["0.2012","0.1347"] | ["688.83","726.17"] | ["XCBO"] | 690.0000 | 725.0000 | 4 | 4 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:06:38Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090c7-f458-7ce2-9fa4-e0ad5ae4acaa | QQQ | 2026-09-11 10:03 | strangle | 2 | 1 | 200 | 169118.00 | long | ask | 715.6550 | 0.0900 | ["705","721"] | ["0.2062","0.1738"] | ["696.54","729.46"] | ["XCBO"] | 705.0000 | 721.0000 | 7 | 7 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:03:38Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c8b-f088-7033-9b36-6cb94de72d9f | QQQ | 2026-09-10 14:19 | strangle | 2 | 1 | 20 | 94260.00 | unknown | — | 709.1473 | 0.3000 | ["700","720"] | ["0.2214","0.2033"] | [] | ["XCBO"] | 700.0000 | 720.0000 | 81 | 81 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:20:09Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b8c-9570-7d71-96c5-193d30c178f8 | QQQ | 2026-09-10 09:40 | strangle | 2 | 1 | 20 | 35300.00 | long | ask | 709.9250 | 0.1900 | ["709","710"] | ["0.2170","0.2157"] | ["691.35","727.65"] | ["AMXO"] | 709.0000 | 710.0000 | 8 | 8 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:40:52Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08670-d830-7a12-b0db-d811f5167766 | QQQ | 2026-09-09 09:52 | strangle | 2 | 1 | 50 | 49750.00 | short | bid | 717.1900 | 0.1200 | ["709","727"] | ["0.2087","0.1806"] | ["699.05","736.95"] | ["XISX"] | 709.0000 | 727.0000 | 9 | 9 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:52:26Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06dfb-6acd-7370-b9c8-a45ba4b3a11d | QQQ | 2026-09-04 15:53 | strangle | 2 | 3 | 106 | 27878.00 | short | bid | 719.0300 | 0.0300 | ["685","745"] | ["0.2108","0.1402"] | ["682.37","747.63"] | ["XBOX","XCBO","XISX"] | 685.0000 | 745.0000 | 14 | 14 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:53:21Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |