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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c58b-cd07-7c71-99b1-8bd67bbff644 | SPX | 2026-09-21 15:57 | put_ratio_spread | 2 | 1 | 10 | 67680.00 | long | bid | 7768.0500 | 1.0000 | ["7300","7700"] | ["0.1798","0.1229"] | ["7645.92"] | ["XCBO"] | 7300.0000 | 7700.0000 | 25 | 25 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:57:56Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c47b-919f-7961-8601-2fd7b6faaa32 | SPX | 2026-09-21 11:00 | put_ratio_spread | 2 | 1 | 14 | 57400.00 | long | bid | 7722.9000 | 0.8000 | ["7360","7505"] | ["0.1637","0.1425"] | ["7482.60"] | ["XCBO"] | 7360.0000 | 7505.0000 | 25 | 25 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:00:29Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c458-ea87-77c2-80c6-488b3b2077d8 | PFE | 2026-09-21 10:22 | put_ratio_spread | 2 | 1 | 60 | 114150.00 | long | bid | 27.6702 | 0.7100 | ["30","45"] | ["0.3276","0.7625"] | ["28.01"] | ["SPHR"] | 30.0000 | 45.0000 | 88 | 88 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:22:44Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c442-d247-77a3-84bf-a293a1d86be8 | SNDK | 2026-09-21 09:58 | put_ratio_spread | 2 | 1 | 2 | 32300.00 | long | bid | 1789.1310 | 7.6000 | ["1810","1895"] | ["0.7682","0.7931"] | ["1793.60"] | ["XISX"] | 1810.0000 | 1895.0000 | 4 | 4 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:58:27Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b616-6247-7fe0-859a-8733decc9989 | SPX | 2026-09-18 15:55 | put_ratio_spread | 2 | 1 | 8 | 89312.00 | long | bid | 7650.9600 | 1.2000 | ["7450","7660"] | ["0.1457","0.1187"] | ["7587.80"] | ["XCBO"] | 7450.0000 | 7660.0000 | 27 | 27 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:55:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ec-48ef-7072-b173-263846496e32 | SPX | 2026-09-18 15:09 | put_ratio_spread | 2 | 1 | 3 | 32476.00 | long | bid | 7641.0200 | 1.0000 | ["7200","7300"] | ["0.1811","0.1708"] | ["7268.29"] | ["XCBO"] | 7200.0000 | 7300.0000 | 63 | 63 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:09:26Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e9-37c7-7942-a9c3-32a9076f4d04 | SPX | 2026-09-18 15:05 | put_ratio_spread | 2 | 1 | 18 | 80388.00 | long | bid | 7643.1400 | 1.0000 | ["7200","7400"] | ["0.1809","0.1519"] | ["7374"] | ["XCBO"] | 7200.0000 | 7400.0000 | 28 | 28 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:06:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e9-149f-7730-b64b-a190630a627e | SPX | 2026-09-18 15:05 | put_ratio_spread | 2 | 1 | 56 | 250096.00 | long | bid | 7642.8800 | 1.0000 | ["7200","7400"] | ["0.1808","0.1518"] | ["7374"] | ["XCBO"] | 7200.0000 | 7400.0000 | 28 | 28 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:05:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e8-e9a8-7c12-8e88-5b4ee53342f4 | SPX | 2026-09-18 15:05 | put_ratio_spread | 2 | 1 | 26 | 116116.00 | long | bid | 7642.6800 | 1.0000 | ["7200","7400"] | ["0.1808","0.1518"] | ["7374"] | ["XCBO"] | 7200.0000 | 7400.0000 | 28 | 28 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:05:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b540-2687-7213-9575-252f97ec531e | SPX | 2026-09-18 12:01 | put_ratio_spread | 2 | 1 | 6 | 28272.00 | long | bid | 7619.1500 | 1.8000 | ["7620","7645"] | ["0.0832","0.0814"] | ["7620"] | ["XCBO"] | 7620.0000 | 7645.0000 | 3 | 3 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:01:32Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b540-2687-7213-9575-25148deff8eb | SPX | 2026-09-18 12:01 | put_ratio_spread | 2 | 1 | 6 | 28272.00 | long | bid | 7619.1500 | 1.8000 | ["7620","7645"] | ["0.0832","0.0814"] | ["7620"] | ["XCBO"] | 7620.0000 | 7645.0000 | 3 | 3 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:01:32Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b525-091f-7251-acf4-3a07550ca892 | SNDK | 2026-09-18 11:31 | put_ratio_spread | 2 | 1 | 4 | 57236.00 | long | bid | 1720.4200 | 1.7000 | ["1715","1800"] | ["0.6712","0.6859"] | ["1717.25"] | ["XMIO"] | 1715.0000 | 1800.0000 | 7 | 7 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:31:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ca-1bc7-7370-9af3-26b8164baf15 | AVGO | 2026-09-18 09:52 | put_ratio_spread | 2 | 1 | 33 | 960806.00 | long | bid | 362.3475 | 6.8000 | ["520","600"] | ["0.6307","0.8149"] | ["361.83"] | ["SPHR"] | 520.0000 | 600.0000 | 63 | 63 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:52:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c8-5e77-7d82-8c80-da303d87a011 | CAT | 2026-09-18 09:50 | put_ratio_spread | 2 | 1 | 2 | 40440.00 | long | bid | 807.3900 | 9.8000 | ["820","830"] | ["0.4257","0.4216"] | ["700"] | ["XISX"] | 820.0000 | 830.0000 | 455 | 455 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:50:29Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b037-af23-72e0-8481-5b7034a6199f | SPX | 2026-09-17 12:33 | put_ratio_spread | 2 | 3 | 44 | 25186.00 | long | bid | 7632.1400 | 0.1545 | ["7610","7625"] | ["0.1527","0.1294"] | ["7621.32"] | ["XCBO"] | 7610.0000 | 7625.0000 | 0 | 0 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:34:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abc8-626b-74b2-9fa1-e1e677c76bbd | AMD | 2026-09-16 15:53 | put_ratio_spread | 2 | 1 | 2 | 34397.00 | long | bid | 512.4600 | 10.0500 | ["550","630"] | ["0.5515","0.5636"] | ["517.39"] | ["AMXO"] | 550.0000 | 630.0000 | 93 | 93 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:53:51Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aadc-ae93-7c93-8b6b-62ca2221472c | SPX | 2026-09-16 11:36 | put_ratio_spread | 2 | 1 | 20 | 26020.00 | long | bid | 7613.3900 | 0.2000 | ["7525","7580"] | ["0.4038","0.3633"] | ["7570.15"] | ["XCBO"] | 7525.0000 | 7580.0000 | 0 | 0 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:36:24Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aad5-a5cb-7840-8055-ebe69b0a1873 | QQQ | 2026-09-16 11:28 | put_ratio_spread | 2 | 2 | 146 | 229299.00 | long | bid | 711.0150 | 0.1400 | ["690","705"] | ["0.2123","0.1928"] | ["697.12"] | ["ARCO"] | 690.0000 | 705.0000 | 30 | 30 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:28:53Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aac9-0f23-7fd0-85a1-deb96eed8007 | QQQ | 2026-09-16 11:14 | put_ratio_spread | 2 | 1 | 20 | 31420.00 | long | bid | 711.2500 | 0.1200 | ["690","705"] | ["0.2130","0.1942"] | ["697.10"] | ["XMIO"] | 690.0000 | 705.0000 | 30 | 30 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:15:26Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aac9-0f23-7fd0-85a1-dea5ddd1ae19 | QQQ | 2026-09-16 11:14 | put_ratio_spread | 2 | 1 | 50 | 78550.00 | long | bid | 711.2500 | 0.1200 | ["690","705"] | ["0.2130","0.1942"] | ["697.10"] | ["XMIO"] | 690.0000 | 705.0000 | 30 | 30 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:15:26Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aac9-0f22-7e90-9758-db0fa7ff9e07 | QQQ | 2026-09-16 11:14 | put_ratio_spread | 2 | 2 | 16 | 25120.00 | long | bid | 711.2500 | 0.1100 | ["690","705"] | ["0.2128","0.1941"] | ["697.10"] | ["XMIO"] | 690.0000 | 705.0000 | 30 | 30 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:15:26Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa8d-e69b-7e60-a21b-c970a5e14810 | AMD | 2026-09-16 10:10 | put_ratio_spread | 2 | 1 | 2 | 32440.00 | long | bid | 524.5350 | 7.8000 | ["550","630"] | ["0.5613","0.5759"] | ["526.62"] | ["XMIO"] | 550.0000 | 630.0000 | 93 | 93 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:10:36Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a6a7-b2b6-7172-9002-f7a703757ac8 | SPX | 2026-09-15 16:00 | put_ratio_spread | 2 | 1 | 4 | 25984.00 | long | bid | 7586.1400 | 4.3000 | ["7580","7625"] | ["0.1946","0.1778"] | ["7587.50"] | ["XCBO"] | 7580.0000 | 7625.0000 | 1 | 1 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T20:00:37Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a598-c73e-7bb0-b0bb-d4a7a421772f | NDX | 2026-09-15 11:04 | put_ratio_spread | 2 | 1 | 2 | 31469.00 | long | bid | 0.0000 | 21.9000 | ["29000","29080"] | ["0.1876","0.1894"] | ["28979.65"] | ["XISX"] | 29000.0000 | 29080.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:04:21Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a041-3a48-7621-b212-e9b0eacc4842 | MU | 2026-09-14 10:10 | put_ratio_spread | 2 | 1 | 2 | 32210.00 | long | bid | 918.7000 | 12.9500 | ["930","1030"] | ["0.6922","0.7046"] | ["930.40"] | ["XBOX"] | 930.0000 | 1030.0000 | 18 | 18 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:10:43Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091a6-ee61-7020-ae5c-48d7c9ef0801 | SPX | 2026-09-11 14:07 | put_ratio_spread | 2 | 2 | 14 | 36360.00 | long | bid | 7671.4700 | 0.3286 | ["7685","7690"] | ["0.1031","0.1133"] | ["7671.4"] | ["XCBO"] | 7685.0000 | 7690.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:07:19Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0918f-dc20-73d0-9d7d-41c7a2ded5b5 | SPX | 2026-09-11 13:41 | put_ratio_spread | 2 | 1 | 10 | 25001.00 | long | bid | 7671.8600 | 0.3000 | ["7685","7690"] | ["0.0872","0.0766"] | ["7672.33"] | ["XCBO"] | 7685.0000 | 7690.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:42:23Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09117-2d98-7e40-b075-a2972e885197 | QQQ | 2026-09-11 11:30 | put_ratio_spread | 2 | 1 | 25 | 48675.00 | long | bid | 717.2100 | 0.1400 | ["695","715"] | ["0.2105","0.1894"] | ["705.74"] | ["XISX"] | 695.0000 | 715.0000 | 35 | 35 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:30:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cbf-ba58-7cb1-8a11-9a7a0dfa4153 | SNDK | 2026-09-10 15:16 | put_ratio_spread | 2 | 3 | 46 | 159466.00 | long | bid | 1702.7031 | 0.9000 | ["1680","1700"] | ["0.7505","0.7513"] | ["1684.12"] | ["XISX"] | 1680.0000 | 1700.0000 | 1 | 1 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:16:43Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c33-f519-7653-979c-fb6a29d2847a | SPX | 2026-09-10 12:43 | put_ratio_spread | 2 | 1 | 20 | 281170.00 | long | bid | 7597.7800 | 2.5000 | ["7620","7630"] | ["0.1393","0.1375"] | ["7540.65"] | ["XCBO"] | 7620.0000 | 7630.0000 | 15 | 15 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:43:51Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bab-25a8-72e2-8400-7e720c38102c | STRL | 2026-09-10 10:14 | put_ratio_spread | 2 | 2 | 8 | 111154.00 | long | bid | 480.0000 | 18.3000 | ["480","540"] | ["0.7174","0.7089"] | ["458.96"] | ["AMXO","XMIO"] | 480.0000 | 540.0000 | 99 | 99 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:14:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0877f-2f39-7223-a0ca-2c2c7e403c70 | SPX | 2026-09-09 14:47 | put_ratio_spread | 2 | 1 | 8 | 409788.00 | long | bid | 7645.6200 | 6.1000 | ["7975","8060"] | ["0.1352","0.1328"] | ["7649.47"] | ["XCBO"] | 7975.0000 | 8060.0000 | 113 | 113 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:48:00Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0827b-fb38-79e1-a621-8ab750696651 | NDX | 2026-09-08 15:25 | put_ratio_spread | 2 | 1 | 4 | 70684.00 | long | bid | 0.0000 | 34.6000 | ["29610","29650"] | ["0.1662","0.2045"] | ["29519.70"] | ["XISX"] | 29610.0000 | 29650.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:26:27Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08146-cae0-7731-b1a4-a032c10c4b3b | MU | 2026-09-08 09:48 | put_ratio_spread | 2 | 2 | 8 | 259852.00 | long | bid | 1019.5200 | 11.6500 | ["910","1210"] | ["0.6575","0.6809"] | ["980.32"] | ["ARCO","XMIO"] | 910.0000 | 1210.0000 | 129 | 129 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:48:15Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06de2-83cd-7b61-8774-bd6d49ca0b99 | NVDA | 2026-09-04 15:25 | put_ratio_spread | 2 | 1 | 150 | 79295.00 | long | bid | 229.9194 | 0.0600 | ["225","230"] | ["0.3210","0.3153"] | ["227.37"] | ["XCBO"] | 225.0000 | 230.0000 | 7 | 7 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:25:58Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |