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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b532-b907-7fe3-ab61-331a609e42a0 | SPX | 2026-09-18 11:46 | call_frontspread | 2 | 1 | 6 | 40110.00 | long | bid | 7622.9300 | 1.5000 | ["7570","7635"] | ["0.0765","0.0703"] | ["7621.88"] | ["XCBO"] | 7570.0000 | 7635.0000 | 3 | 3 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:46:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b52d-2357-7ac0-8e6e-99802201a785 | SPX | 2026-09-18 11:40 | call_frontspread | 2 | 1 | 4 | 34750.00 | long | bid | 7622.3700 | 0.5000 | ["7570","7625"] | ["0.0990","0.0907"] | ["7623.82"] | ["XCBO"] | 7570.0000 | 7625.0000 | 5 | 5 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:40:56Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b068-9a93-7c42-9426-de1ec351c34e | SPX | 2026-09-17 13:27 | call_frontspread | 2 | 1 | 45 | 111755.00 | long | bid | 7630.6600 | 1.0000 | ["8550","8600"] | ["0.1158","0.1160"] | ["8778.18"] | ["XCBO"] | 8550.0000 | 8600.0000 | 120 | 120 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:27:48Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aa9d-b57a-77a2-a365-ac8ff4890b5d | SPX | 2026-09-16 10:27 | call_frontspread | 2 | 1 | 10 | 25819.00 | long | bid | 7600.0900 | 0.2000 | ["7610","7615"] | ["0.2945","0.2928"] | ["7625.13"] | ["XCBO"] | 7610.0000 | 7615.0000 | 0 | 0 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:28:05Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a67f-664e-7833-815d-169a51d6168f | SPX | 2026-09-15 15:15 | call_frontspread | 2 | 1 | 33 | 57708.00 | long | bid | 7582.6400 | 0.4000 | ["7635","7640"] | ["0.1804","0.1794"] | ["7635.03","7676.02"] | ["XCBO"] | 7635.0000 | 7640.0000 | 1 | 1 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:16:20Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a57b-3cbe-7ff0-beb8-5f8f355b5b52 | SPX | 2026-09-15 10:31 | call_frontspread | 2 | 1 | 41 | 120622.00 | long | bid | 7586.8400 | 0.6000 | ["7750","7785"] | ["0.1118","0.1077"] | ["7756.87","8910.30"] | ["XCBO"] | 7750.0000 | 7785.0000 | 15 | 15 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:32:18Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a08d-04a0-76e2-97cd-8ebfa17cf68b | SPX | 2026-09-14 11:33 | call_frontspread | 2 | 1 | 1421 | 4750200.00 | long | bid | 7614.3300 | 1.0000 | ["7650","7700"] | ["0.1382","0.1277"] | ["7662.64","7793.40"] | ["XCBO"] | 7650.0000 | 7700.0000 | 4 | 4 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:33:38Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a08d-04a0-76e2-97cd-8eadc2d54f36 | SPX | 2026-09-14 11:33 | call_frontspread | 2 | 1 | 175 | 583950.00 | long | bid | 7614.3300 | 1.0000 | ["7650","7700"] | ["0.1380","0.1276"] | ["7662.64","7793.40"] | ["XCBO"] | 7650.0000 | 7700.0000 | 4 | 4 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:33:38Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a08d-04a0-76e2-97cd-8e9850552aa5 | SPX | 2026-09-14 11:33 | call_frontspread | 2 | 1 | 28 | 93432.00 | long | bid | 7614.3300 | 1.0000 | ["7650","7700"] | ["0.1380","0.1276"] | ["7662.64","7793.40"] | ["XCBO"] | 7650.0000 | 7700.0000 | 4 | 4 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:33:38Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a08d-04a0-76e2-97cd-8e85bf5aad51 | SPX | 2026-09-14 11:33 | call_frontspread | 2 | 1 | 462 | 1533312.00 | long | bid | 7614.3300 | 1.0000 | ["7650","7700"] | ["0.1376","0.1272"] | ["7662.64","7793.40"] | ["XCBO"] | 7650.0000 | 7700.0000 | 4 | 4 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:33:38Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a08c-fcd0-7f21-824d-287699837a03 | SPX | 2026-09-14 11:33 | call_frontspread | 2 | 1 | 14 | 46632.00 | long | bid | 7614.9000 | 1.1000 | ["7650","7700"] | ["0.1372","0.1269"] | ["7662.64","7793.40"] | ["XCBO"] | 7650.0000 | 7700.0000 | 4 | 4 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:33:38Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a08b-c838-7803-8205-1d5d966c1e6c | SPX | 2026-09-14 11:31 | call_frontspread | 2 | 1 | 560 | 1715360.00 | long | bid | 7607.3600 | 0.5000 | ["7650","7700"] | ["0.1393","0.1288"] | ["7662","7795.00"] | ["XCBO"] | 7650.0000 | 7700.0000 | 4 | 4 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:32:18Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09139-b958-7470-b059-9b9d1a9d2d5a | SPX | 2026-09-11 12:07 | call_frontspread | 2 | 1 | 2 | 67618.00 | long | bid | 7673.1200 | 18.7000 | ["7500","7675"] | ["0.1439","0.1251"] | ["7719.10"] | ["XCBO"] | 7500.0000 | 7675.0000 | 39 | 39 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:08:20Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090b8-4c89-71d3-b508-6967fd48add0 | SPX | 2026-09-11 09:46 | call_frontspread | 2 | 1 | 4 | 543288.00 | long | bid | 7671.7100 | 5.3000 | ["6950","7925"] | ["0.1946","0.1544"] | ["7861.10"] | ["XCBO"] | 6950.0000 | 7925.0000 | 308 | 308 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:46:42Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c35-8b58-7c70-83c5-32f6ef3ec218 | SPX | 2026-09-10 12:45 | call_frontspread | 2 | 1 | 52 | 43498.00 | long | bid | 7601.8900 | 0.1500 | ["7605","7620"] | ["0.1479","0.1436"] | ["7611.08"] | ["XCBO"] | 7605.0000 | 7620.0000 | 0 | 0 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:45:31Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c00-def8-7992-bb13-1ca31fb8ff06 | SPX | 2026-09-10 11:47 | call_frontspread | 2 | 1 | 28 | 51470.00 | unknown | — | 7601.5200 | 0.4000 | ["7655","7660"] | ["0.1856","0.1842"] | [] | ["XCBO"] | 7655.0000 | 7660.0000 | 1 | 1 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:47:51Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0879c-63c8-7781-8fd0-16bca71c91d8 | SPX | 2026-09-09 15:19 | call_frontspread | 2 | 1 | 9 | 218990.00 | unknown | — | 7647.6500 | 0.7000 | ["7550","7625"] | ["0.1366","0.1271"] | [] | ["XCBO"] | 7550.0000 | 7625.0000 | 21 | 21 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:19:48Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0870d-2bb8-7033-84de-92bb4e3d29e3 | SPX | 2026-09-09 12:43 | call_frontspread | 2 | 1 | 6 | 366408.00 | long | bid | 7636.4300 | 6.3000 | ["7325","7950"] | ["0.1677","0.1298"] | ["7760.04"] | ["XCBO"] | 7325.0000 | 7950.0000 | 113 | 113 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:43:08Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06df5-022d-7db2-8fe5-16ffb0ce7b7d | SPX | 2026-09-04 15:46 | call_frontspread | 2 | 1 | 6 | 84046.00 | long | bid | 7715.2100 | 1.4000 | ["7825","7850"] | ["0.1104","0.1089"] | ["7992.78"] | ["XCBO"] | 7825.0000 | 7850.0000 | 42 | 42 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:46:27Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd4-7df5-7ab1-b9ff-d9f42a407e41 | SPX | 2026-09-04 15:10 | call_frontspread | 2 | 1 | 30 | 33750.00 | long | bid | 7712.5900 | 0.2000 | ["7740","7745"] | ["0.0500","0.0499"] | ["7740.18","7769.10"] | ["XCBO"] | 7740.0000 | 7745.0000 | 4 | 4 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:11:00Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |