core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 |
|---|
| 01a0d4da-e22f-7ec1-8931-850248b554fe | NDX | 2026-09-24 15:18 | straddle | 2 | 2 | 5 | 27000.00 | short | bid | 0.0000 | 7.9000 | ["30450"] | ["0.2026"] | ["30396","30504.00"] | ["XISX"] | 30450.0000 | 30450.0000 | 0 | 0 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T19:18:40Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d4da-e22f-7ec1-8931-84f2b44d97c5 | NDX | 2026-09-24 15:18 | straddle | 2 | 2 | 5 | 27000.00 | short | bid | 0.0000 | 7.9000 | ["30450"] | ["0.2026"] | ["30396","30504.00"] | ["XISX"] | 30450.0000 | 30450.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0d4ad-fdff-7df1-8c1b-2b2092224cb0 | NDX | 2026-09-24 14:29 | straddle | 2 | 1 | 4 | 29600.00 | short | bid | 0.0000 | 4.9000 | ["30450"] | ["0.2181"] | ["30376","30524.00"] | ["XISX"] | 30450.0000 | 30450.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0d4aa-c9af-74c3-9134-5ac5c4bea78d | NDX | 2026-09-24 14:25 | straddle | 2 | 1 | 10 | 76010.00 | short | bid | 0.0000 | 0.2000 | ["30410"] | [null] | ["30333.99","30486.01"] | ["XPHO"] | 30410.0000 | 30410.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0d471-4aee-7112-af25-d90e6aa7451d | NDX | 2026-09-24 13:23 | straddle | 2 | 1 | 12 | 2843880.00 | short | bid | 0.0000 | 36.5000 | ["30800"] | ["0.2035"] | ["28430.10","33169.90"] | ["XPHO"] | 30800.0000 | 30800.0000 | 85 | 85 | false | false | false | false | |||||||||
| 01a0d3dc-9c6f-7843-ada8-c7ff76cb5bc0 | NDX | 2026-09-24 10:40 | straddle | 2 | 1 | 2 | 495760.00 | short | bid | 0.0000 | 60.0000 | ["30000"] | ["0.2112"] | ["27521.20","32478.80"] | ["XPHO"] | 30000.0000 | 30000.0000 | 85 | 85 | false | false | false | false | |||||||||
| 01a0cfdf-91b7-72d0-8ac4-ca82cab28915 | NDX | 2026-09-23 16:05 | straddle | 2 | 1 | 3 | 159300.00 | short | bid | 0.0000 | 19.4000 | ["30500"] | ["0.1583"] | ["29969","31031.00"] | ["XISX"] | 30500.0000 | 30500.0000 | 7 | 7 | false | false | false | false | |||||||||
| 01a0cfdf-8dce-71c2-96c9-01fd4240f9cf | NDX | 2026-09-23 16:05 | straddle | 2 | 1 | 2 | 106300.00 | short | bid | 0.0000 | 19.4000 | ["30500"] | ["0.1583"] | ["29968.50","31031.50"] | ["XPHO"] | 30500.0000 | 30500.0000 | 7 | 7 | false | false | false | false | |||||||||
| 01a0cfde-ca7e-7bd3-8704-2ee87e3577f5 | NDX | 2026-09-23 16:04 | straddle | 2 | 2 | 2 | 106300.00 | short | bid | 0.0000 | 20.5000 | ["30500"] | ["0.1583"] | ["29968.50","31031.50"] | ["XISX","XPHO"] | 30500.0000 | 30500.0000 | 7 | 7 | false | false | false | false | |||||||||
| 01a0cf21-3b27-7fb1-a5a9-6966fa2552a1 | NDX | 2026-09-23 12:37 | straddle | 2 | 1 | 200 | 46717400.00 | short | bid | 0.0000 | 47.6000 | ["30700"] | ["0.2001"] | ["28364.13","33035.87"] | ["XPHO"] | 30700.0000 | 30700.0000 | 86 | 86 | true | false | false | false | |||||||||
| 01a0cf21-3b27-7fb1-a5a9-6863040adc7d | NDX | 2026-09-23 12:37 | straddle | 2 | 1 | 200 | 5061800.00 | short | bid | 0.0000 | 31.9500 | ["30700"] | ["0.2137"] | ["30446.91","30953.09"] | ["XPHO"] | 30700.0000 | 30700.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0ceab-344e-7163-a965-5acb7c201cd4 | NDX | 2026-09-23 10:28 | straddle | 2 | 1 | 8 | 1878240.00 | short | bid | 0.0000 | 84.9000 | ["30675"] | ["0.2003"] | ["28327.20","33022.80"] | ["XPHO"] | 30675.0000 | 30675.0000 | 86 | 86 | true | false | false | false | |||||||||
| 01a0c994-b2e7-7b92-bdfd-4c1f8ab18389 | NDX | 2026-09-22 10:45 | straddle | 2 | 2 | 2 | 802200.00 | short | bid | 0.0000 | 386.5500 | ["27500"] | ["0.2494"] | ["23489","31511.00"] | ["XISX","XPHO"] | 27500.0000 | 27500.0000 | 87 | 87 | false | false | false | false | |||||||||
| 01a0c574-0717-7403-a9e1-476c925e62c4 | NDX | 2026-09-21 15:31 | straddle | 2 | 2 | 7 | 146440.00 | short | bid | 0.0000 | 12.1000 | ["30500"] | ["0.1609"] | ["30290.80","30709.20"] | ["XISX","XPHO"] | 30500.0000 | 30500.0000 | 1 | 1 | false | false | false | false | |||||||||
| 01a0c4b8-bdc8-7430-afe4-d17c5acea569 | NDX | 2026-09-21 12:07 | straddle | 2 | 1 | 2 | 26000.00 | short | bid | 0.0000 | 17.4000 | ["30225"] | ["0.1606"] | ["30095","30355.00"] | ["XISX"] | 30225.0000 | 30225.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0abd1-dc33-7880-a10d-603ac0b7bdba | NDX | 2026-09-16 16:04 | straddle | 2 | 2 | 3 | 102600.00 | short | bid | 0.0000 | 15.6667 | ["28900"] | ["0.2145"] | ["28558","29242.00"] | ["XPHO"] | 28900.0000 | 28900.0000 | 2 | 2 | false | false | false | false | |||||||||
| 01a0ab3e-eeeb-7db0-9e76-2ed29878e365 | NDX | 2026-09-16 13:23 | straddle | 2 | 1 | 6 | 1414536.00 | short | bid | 0.0000 | 35.1000 | ["29450"] | ["0.2018"] | ["27092.44","31807.56"] | ["XPHO"] | 29450.0000 | 29450.0000 | 93 | 93 | false | false | false | false | |||||||||
| 01a0a593-5c86-7fa3-9a27-2329b21bec36 | NDX | 2026-09-15 10:58 | straddle | 2 | 1 | 13 | 3139552.00 | short | bid | 0.0000 | 41.3000 | ["29275"] | ["0.2071"] | ["26859.96","31690.04"] | ["XPHO"] | 29275.0000 | 29275.0000 | 94 | 94 | true | false | false | false | |||||||||
| 01a0a097-d240-7a61-9fe0-3c83ff935320 | NDX | 2026-09-14 11:44 | straddle | 2 | 1 | 155 | 10108635.00 | short | bid | 0.0000 | 64.2000 | ["29000"] | ["0.1846"] | ["28347.83","29652.17"] | ["XPHO"] | 29000.0000 | 29000.0000 | 8 | 8 | true | false | false | false | |||||||||
| 01a0a097-93c1-7f01-9644-0dc824acdb3a | NDX | 2026-09-14 11:44 | straddle | 2 | 1 | 147 | 7671489.00 | short | bid | 0.0000 | 47.6000 | ["29000"] | ["0.2116"] | ["28478.13","29521.87"] | ["XPHO"] | 29000.0000 | 29000.0000 | 4 | 4 | false | false | false | false | |||||||||
| 01a0a087-0190-7062-b12d-719b0dc254f7 | NDX | 2026-09-14 11:26 | straddle | 2 | 1 | 15 | 3630000.00 | short | bid | 0.0000 | 144.8000 | ["29350"] | ["0.2063"] | ["26930","31770.00"] | ["XPHO"] | 29350.0000 | 29350.0000 | 95 | 95 | true | false | false | false | |||||||||
| 01a08c56-51f8-7371-8458-41fd57a35a4e | NDX | 2026-09-10 13:20 | straddle | 2 | 1 | 10 | 662260.00 | short | bid | 0.0000 | 56.4000 | ["29225"] | ["0.1969"] | ["28562.74","29887.26"] | ["XPHO"] | 29225.0000 | 29225.0000 | 8 | 8 | false | false | false | false | |||||||||
| 01a06dfc-35ed-7101-a10f-22b1a8c4a65f | NDX | 2026-09-04 15:53 | straddle | 2 | 3 | 4 | 176000.00 | short | bid | 0.0000 | 20.0250 | ["29500"] | ["0.1360"] | ["29060","29940.00"] | ["XISX","XPHO"] | 29500.0000 | 29500.0000 | 7 | 7 | false | false | false | false | |||||||||
| 01a06dfc-1e7d-7030-9f2c-eca8a710af43 | NDX | 2026-09-04 15:53 | straddle | 2 | 3 | 3 | 132000.00 | short | bid | 0.0000 | 20.2667 | ["29500"] | ["0.1360"] | ["29060","29940.00"] | ["XISX","XPHO"] | 29500.0000 | 29500.0000 | 7 | 7 | false | false | false | false | |||||||||
| 01a06df7-4835-79c3-b580-0c43c79b99c3 | NDX | 2026-09-04 15:48 | straddle | 2 | 2 | 2 | 143500.00 | short | bid | 0.0000 | 79.5500 | ["29500"] | ["0.1561"] | ["28782.50","30217.50"] | ["XISX"] | 29500.0000 | 29500.0000 | 14 | 14 | false | false | false | false | |||||||||
| 01a06df6-792d-7e02-947a-3727970121ad | NDX | 2026-09-04 15:47 | straddle | 2 | 1 | 2 | 143500.00 | short | bid | 0.0000 | 82.3000 | ["29500"] | ["0.1562"] | ["28782.50","30217.50"] | ["XISX"] | 29500.0000 | 29500.0000 | 14 | 14 | false | false | false | false | |||||||||
| 01a06df4-4a95-70b0-bdab-55ea755ad35d | NDX | 2026-09-04 15:45 | straddle | 2 | 1 | 2 | 143500.00 | short | bid | 0.0000 | 81.0000 | ["29500"] | ["0.1560"] | ["28782.50","30217.50"] | ["XISX"] | 29500.0000 | 29500.0000 | 14 | 14 | false | false | false | false | |||||||||
| 01a06df3-9eb5-7d72-ba0b-eb9d8c7e32d6 | NDX | 2026-09-04 15:44 | straddle | 2 | 2 | 2 | 143600.00 | short | bid | 0.0000 | 80.8500 | ["29500"] | ["0.1568"] | ["28782","30218.00"] | ["XPHO"] | 29500.0000 | 29500.0000 | 14 | 14 | false | false | false | false | |||||||||
| 01a06d43-174d-7990-a50e-14cb76d640fa | NDX | 2026-09-04 12:31 | straddle | 2 | 1 | 11 | 754820.00 | short | bid | 0.0000 | 51.0000 | ["29550"] | ["0.1509"] | ["28863.80","30236.20"] | ["XPHO"] | 29550.0000 | 29550.0000 | 14 | 14 | false | false | false | false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:18:40Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:30:09Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:26:20Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:23:45Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:41:04Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T20:06:08Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T20:06:08Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T20:06:08Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:38:10Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:38:10Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:29:05Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:46:23Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:32:05Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:07:20Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T20:04:41Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:24:04Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:58:22Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:45:15Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:44:52Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:26:48Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:21:33Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:54:07Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:54:07Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:48:38Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:47:46Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:45:19Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:44:39Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:32:18Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |