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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b4fd-4d3f-71f1-89b5-4fbcb6599314 | SPX | 2026-09-18 10:48 | call_ratio_spread | 2 | 1 | 171 | 1072502.00 | unknown | ask | 7622.1400 | 0.6000 | ["7725","7825"] | ["0.1116","0.1044"] | ["7787.72"] | ["XCBO"] | 7725.0000 | 7825.0000 | 28 | 28 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:48:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4da-b5c8-7093-9639-719cbc770481 | SPX | 2026-09-18 10:10 | call_ratio_spread | 2 | 4 | 3000 | 2640000.00 | unknown | bid | 7626.9200 | 0.6000 | ["7875","8050"] | ["0.1009","0.1024"] | ["7901.40"] | ["XCBO"] | 7875.0000 | 8050.0000 | 28 | 28 | true | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:10:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0be-7edb-7563-a607-aa7f65c79a51 | SPX | 2026-09-17 15:01 | call_ratio_spread | 2 | 1 | 750 | 211600.00 | unknown | — | 7638.3400 | 0.1000 | ["7750","7775"] | ["0.0830","0.0827"] | [] | ["XCBO"] | 7750.0000 | 7775.0000 | 5 | 5 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:01:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aff8-7f5b-7e63-9d80-5a6fc08449f3 | SPX | 2026-09-17 11:24 | call_ratio_spread | 2 | 1 | 100 | 2452200.00 | unknown | — | 7624.3800 | 1.3000 | ["7650","7690"] | ["0.1365","0.1343"] | [] | ["XCBO"] | 7650.0000 | 7690.0000 | 92 | 92 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:24:56Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe0-ffbb-77c0-b775-323906724d6a | SPX | 2026-09-17 10:59 | call_ratio_spread | 2 | 1 | 800 | 6831200.00 | unknown | — | 7619.5400 | 1.4000 | ["7695","8050"] | ["0.1363","0.1192"] | [] | ["XCBO"] | 7695.0000 | 8050.0000 | 92 | 92 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:59:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afda-e923-78b0-9229-1b410f202ed6 | SPX | 2026-09-17 10:52 | call_ratio_spread | 2 | 1 | 1800 | 2880000.00 | unknown | — | 7621.8700 | 0.5500 | ["7790","8150"] | ["0.1122","0.1130"] | [] | ["XCBO"] | 7790.0000 | 8150.0000 | 29 | 29 | true | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:52:50Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab9c-2633-7f73-827c-99465507313f | SPX | 2026-09-16 15:05 | call_ratio_spread | 2 | 2 | 250 | 493700.00 | unknown | — | 7551.6300 | 0.8000 | ["7625","7775"] | ["0.1308","0.1095"] | [] | ["XCBO"] | 7625.0000 | 7775.0000 | 14 | 14 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:05:32Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaf0-230b-7fe2-b93f-bb4d21619649 | SPX | 2026-09-16 11:57 | call_ratio_spread | 2 | 1 | 80 | 499500.00 | unknown | — | 7619.2700 | 1.3000 | ["7690","8200"] | ["0.1396","0.1178"] | [] | ["XCBO"] | 7690.0000 | 8200.0000 | 93 | 93 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:58:42Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaf0-230b-7fe2-b93f-bb361531ac74 | SPX | 2026-09-16 11:57 | call_ratio_spread | 2 | 1 | 80 | 499500.00 | unknown | — | 7619.2700 | 1.3000 | ["7690","8200"] | ["0.1396","0.1178"] | [] | ["XCBO"] | 7690.0000 | 8200.0000 | 93 | 93 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:58:42Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aae1-a803-7090-b36f-43b2319893de | SPX | 2026-09-16 11:41 | call_ratio_spread | 2 | 1 | 142 | 1360845.00 | unknown | — | 7615.5200 | 0.8000 | ["7675","7800"] | ["0.1271","0.1148"] | [] | ["XCBO"] | 7675.0000 | 7800.0000 | 29 | 29 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:42:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5ff-0ed5-7993-a87f-1e54a0c10810 | SPX | 2026-09-15 12:55 | call_ratio_spread | 2 | 2 | 180 | 503000.00 | unknown | — | 7591.3300 | 0.4000 | ["7640","7715"] | ["0.1317","0.1184"] | [] | ["XCBO"] | 7640.0000 | 7715.0000 | 7 | 7 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:56:14Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5c0-3116-7ff1-925b-1ddddcead12f | SPX | 2026-09-15 11:47 | call_ratio_spread | 2 | 1 | 100 | 1067000.00 | unknown | — | 7585.9400 | 1.1000 | ["7655","8400"] | ["0.1424","0.1159"] | [] | ["XCBO"] | 7655.0000 | 8400.0000 | 94 | 94 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:47:29Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a55f-4496-7e00-9f84-9da32145afc6 | SPX | 2026-09-15 10:01 | call_ratio_spread | 2 | 2 | 300 | 2752950.00 | unknown | — | 7604.1500 | 0.8000 | ["7650","7850"] | ["0.1314","0.1098"] | [] | ["XCBO"] | 7650.0000 | 7850.0000 | 24 | 24 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:01:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a14b-2098-7642-9e41-4be0b1a1ed87 | SPX | 2026-09-14 15:00 | call_ratio_spread | 2 | 1 | 100 | 28950.00 | long | ask | 7632.6500 | 0.4000 | ["7900","8000"] | ["0.0978","0.1023"] | ["7901.63","8098.37"] | ["XCBO"] | 7900.0000 | 8000.0000 | 16 | 16 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:01:06Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c82-0960-7213-86ae-199bfbbd562e | SPX | 2026-09-10 14:08 | call_ratio_spread | 2 | 1 | 500 | 45000.00 | long | ask | 7593.9800 | 0.1000 | ["7775","7825"] | ["0.1031","0.1068"] | ["7775.50","7899.25"] | ["XCBO"] | 7775.0000 | 7825.0000 | 5 | 5 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:08:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |