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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b616-98f7-7b10-870d-90adab7517f3 | NVDA | 2026-09-18 15:55 | call_ratio_spread | 2 | 1 | 50 | 47520.00 | unknown | bid | 222.1350 | 0.2500 | ["220","230"] | ["0.3100","0.3002"] | ["232.50"] | ["XISX"] | 220.0000 | 230.0000 | 28 | 28 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:55:33Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-4780-7b61-a54a-096dd438fd90 | MU | 2026-09-18 15:50 | call_ratio_spread | 2 | 1 | 3 | 37254.00 | unknown | bid | 1011.7700 | 15.0000 | ["925","945"] | ["17.5564","13.6114"] | ["1011.51"] | ["ARCO"] | 925.0000 | 945.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:50:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5de-4ed0-74d1-92ca-aa326cb87c74 | AAPL | 2026-09-18 14:53 | call_ratio_spread | 2 | 1 | 20 | 46900.00 | unknown | bid | 336.1200 | 0.8000 | ["330","360"] | ["0.2581","0.2418"] | ["365.63"] | ["XBOX"] | 330.0000 | 360.0000 | 119 | 119 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:54:08Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5cc-1aa8-7260-bb9a-cec6cf79f567 | NVDA | 2026-09-18 14:34 | call_ratio_spread | 2 | 1 | 115 | 47390.00 | unknown | bid | 219.4150 | 0.3400 | ["215","290"] | ["0.3639","0.3535"] | ["262.39"] | ["XMIO"] | 215.0000 | 290.0000 | 119 | 119 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:34:26Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5b9-ee4f-75e0-8384-ac542d69942e | PURR | 2026-09-18 14:14 | call_ratio_spread | 2 | 2 | 150 | 104400.00 | unknown | bid | 13.8420 | 0.6000 | ["12","14"] | ["0.9516","0.9445"] | ["16.98"] | ["MCRY","XBOX"] | 12.0000 | 14.0000 | 182 | 182 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:14:36Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b57b-e380-71f2-8ab2-0c19d7bda391 | GLD | 2026-09-18 13:06 | call_ratio_spread | 2 | 1 | 540 | 297000.00 | unknown | bid | 402.1100 | 0.2900 | ["480","500"] | ["0.2544","0.2646"] | ["488.25"] | ["EDGO"] | 480.0000 | 500.0000 | 119 | 119 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:06:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b563-db28-7ab0-a0d3-092a04da6daf | GLD | 2026-09-18 12:40 | call_ratio_spread | 2 | 4 | 84 | 100572.00 | unknown | bid | 401.5900 | 0.2500 | ["450","470"] | ["0.2444","0.2515"] | ["464.37"] | ["EDGO","XBOX","XCBO","XISX"] | 450.0000 | 470.0000 | 119 | 119 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:40:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b52b-4aaf-7370-9b41-160de7ca8a53 | SNDK | 2026-09-18 11:38 | call_ratio_spread | 2 | 3 | 12 | 210972.00 | unknown | bid | 1725.0379 | 1.4500 | ["1600","1900"] | ["0.7067","0.7139"] | ["1917.21"] | ["EMLD","SPHR"] | 1600.0000 | 1900.0000 | 28 | 28 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:38:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b52a-8f2f-7333-b1cb-296635bbee7c | SNDK | 2026-09-18 11:37 | call_ratio_spread | 2 | 1 | 2 | 35098.00 | unknown | bid | 1725.6100 | 1.5000 | ["1600","1900"] | ["0.7025","0.7119"] | ["1916.99"] | ["C2OX"] | 1600.0000 | 1900.0000 | 28 | 28 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:38:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b524-268f-75c3-8a32-2475f7fca9ac | NVDA | 2026-09-18 11:30 | call_ratio_spread | 2 | 1 | 402 | 120600.00 | unknown | bid | 219.8300 | 0.1100 | ["215","220"] | ["0.4106","0.3320"] | ["220.33"] | ["EDGO"] | 215.0000 | 220.0000 | 0 | 0 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:30:40Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b515-132f-7d80-b164-7882070d7fa2 | SNDK | 2026-09-18 11:14 | call_ratio_spread | 2 | 1 | 4 | 55120.00 | unknown | bid | 1714.5950 | 1.7000 | ["1640","1715"] | ["0.6604","0.6586"] | ["1756.87"] | ["XISX"] | 1640.0000 | 1715.0000 | 7 | 7 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:14:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b512-3c9f-71f1-b5a5-37acf7a63d76 | AAPL | 2026-09-18 11:11 | call_ratio_spread | 2 | 1 | 744 | 97092.00 | unknown | bid | 334.9700 | 0.1400 | ["340","345"] | ["0.2158","0.2175"] | ["342.61"] | ["ARCO"] | 340.0000 | 345.0000 | 5 | 5 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:11:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b50e-a6a8-78d2-b793-30d11a779830 | AMZN | 2026-09-18 11:07 | call_ratio_spread | 2 | 1 | 20 | 34230.00 | unknown | bid | 255.2950 | 0.5500 | ["280","320"] | ["0.3547","0.3513"] | ["314.23"] | ["XISX"] | 280.0000 | 320.0000 | 182 | 182 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:07:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b504-3e97-7d43-9af4-4ff649d9deba | WDC | 2026-09-18 10:55 | call_ratio_spread | 2 | 1 | 9 | 48984.00 | unknown | bid | 436.2200 | 11.6000 | ["620","690"] | ["0.6911","0.6856"] | ["689.98"] | ["XISX"] | 620.0000 | 690.0000 | 182 | 182 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:56:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fe-c827-7692-af74-4bd1b1a6dbe7 | DELL | 2026-09-18 10:49 | call_ratio_spread | 2 | 1 | 2 | 40594.00 | unknown | bid | 583.4400 | 4.0500 | ["360","570"] | ["0.6979","0.6724"] | ["635.31"] | ["XISX"] | 360.0000 | 570.0000 | 91 | 91 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:50:09Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fc-1c8f-7981-97c3-815cf11af5a7 | SNDK | 2026-09-18 10:46 | call_ratio_spread | 2 | 1 | 4 | 58576.00 | unknown | bid | 1708.8900 | 5.0000 | ["1620","1720"] | ["0.6732","0.6711"] | ["1750.96"] | ["XMIO"] | 1620.0000 | 1720.0000 | 7 | 7 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:47:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e3-ba5f-7312-bb21-2b360437d8f0 | INTC | 2026-09-18 10:20 | call_ratio_spread | 2 | 2 | 276 | 115628.00 | unknown | bid | 108.2000 | 0.1200 | ["110","140"] | ["0.6079","0.6706"] | ["118.38"] | ["AMXO","ARCO"] | 110.0000 | 140.0000 | 28 | 28 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:20:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e2-4b2f-7a73-929b-441231a00952 | QQQ | 2026-09-18 10:18 | call_ratio_spread | 2 | 3 | 91 | 193668.00 | unknown | bid | 716.5400 | 0.0600 | ["720","725"] | ["0.1631","0.1586"] | ["733.47"] | ["EDGO","XCBO","XISX"] | 720.0000 | 725.0000 | 28 | 28 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:19:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e2-4b2f-7a73-929b-43fa201901ff | QQQ | 2026-09-18 10:18 | call_ratio_spread | 2 | 3 | 39 | 82999.00 | unknown | bid | 716.5400 | 0.0900 | ["720","725"] | ["0.1631","0.1586"] | ["733.47"] | ["EDGO","XCBO","XISX"] | 720.0000 | 725.0000 | 28 | 28 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:19:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e2-3f78-7d53-96e0-a33f7db970bd | QQQ | 2026-09-18 10:18 | call_ratio_spread | 2 | 1 | 13 | 27642.00 | unknown | bid | 716.4800 | 0.0800 | ["720","725"] | ["0.1634","0.1588"] | ["733.46"] | ["XMIO"] | 720.0000 | 725.0000 | 28 | 28 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:19:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e2-3b8f-7dc2-87c8-287c0e862a2e | QQQ | 2026-09-18 10:18 | call_ratio_spread | 2 | 3 | 156 | 331814.00 | unknown | bid | 716.4800 | 0.0600 | ["720","725"] | ["0.1634","0.1589"] | ["733.46"] | ["EDGO","XCBO","XISX"] | 720.0000 | 725.0000 | 28 | 28 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:19:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e1-4190-7fe0-9cb1-6f4d377e6d0f | SNDK | 2026-09-18 10:17 | call_ratio_spread | 2 | 2 | 4 | 31402.00 | unknown | bid | 1694.9500 | 1.6500 | ["1660","1770"] | ["0.6902","0.7027"] | ["1785.67"] | ["EDGO","XISX"] | 1660.0000 | 1770.0000 | 7 | 7 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:17:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4de-c0ef-7df1-9630-1d51bdb120f0 | INTC | 2026-09-18 10:14 | call_ratio_spread | 2 | 2 | 40 | 296700.00 | unknown | bid | 108.2450 | 0.3000 | ["60","75"] | ["9.5911","6.2337"] | ["108.20"] | ["XISX"] | 60.0000 | 75.0000 | 0 | 0 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:14:56Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d2-5927-7091-a9e1-a95870ab86fa | SNDK | 2026-09-18 10:01 | call_ratio_spread | 2 | 2 | 90 | 89325.00 | unknown | bid | 1700.2155 | 1.6000 | ["1700","1760"] | ["1.0692","1.1853"] | ["1729.78"] | ["AMXO","XPHO"] | 1700.0000 | 1760.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:01:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4cf-c8e8-7bc3-a98d-4db25ee284c8 | SNDK | 2026-09-18 09:58 | call_ratio_spread | 2 | 1 | 2 | 38112.00 | unknown | bid | 1692.3300 | 13.7000 | ["1630","1635"] | ["0.7122","0.7055"] | ["1758.71"] | ["XISX"] | 1630.0000 | 1635.0000 | 14 | 14 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:58:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4be-40a0-78b0-987a-983dbf7b070e | QQQ | 2026-09-18 09:39 | call_ratio_spread | 2 | 1 | 42 | 66423.00 | unknown | bid | 719.2500 | 0.4100 | ["704","711"] | ["0.4548","0.2531"] | ["719.21"] | ["AMXO"] | 704.0000 | 711.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:39:39Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4b8-2237-7762-a6d6-39cf2fb438ad | GOOG | 2026-09-18 09:32 | call_ratio_spread | 2 | 1 | 19 | 45235.00 | unknown | bid | 353.1207 | 0.8000 | ["350","355"] | ["0.2980","0.2974"] | ["364.93"] | ["XPHO"] | 350.0000 | 355.0000 | 28 | 28 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:32:48Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |