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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b619-7370-79d2-81b8-641a5e6732e5 | SPX | 2026-09-18 15:58 | risk_reversal | 2 | 1 | 150 | 244350.00 | short | ask | 7645.6000 | 0.7000 | ["7000","8000"] | ["0.2126","0.0964"] | ["6993.81"] | ["XCBO"] | 7000.0000 | 8000.0000 | 28 | 28 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:58:36Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b594-360f-7482-ac71-9f6196c1a92d | SPX | 2026-09-18 13:33 | risk_reversal | 2 | 1 | 1000 | 14055000.00 | long | ask | 7623.8600 | 0.9000 | ["7000","8000"] | ["0.2022","0.1187"] | ["8006.25"] | ["XCBO"] | 7000.0000 | 8000.0000 | 91 | 91 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:33:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b594-0eff-74a1-8648-c32e099f2aeb | SPX | 2026-09-18 13:32 | risk_reversal | 2 | 1 | 2300 | 32326500.00 | long | ask | 7624.0000 | 0.9000 | ["7000","8000"] | ["0.2023","0.1187"] | ["8006.25"] | ["XCBO"] | 7000.0000 | 8000.0000 | 91 | 91 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:32:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b555-44c8-7723-a2c9-c7cabed4b341 | SPX | 2026-09-18 12:24 | risk_reversal | 2 | 1 | 750 | 10425750.00 | long | ask | 7613.2000 | 1.1000 | ["7000","8000"] | ["0.2024","0.1183"] | ["8000.93"] | ["XCBO"] | 7000.0000 | 8000.0000 | 91 | 91 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:24:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b527-e77f-76d1-81af-abbfaeb0674b | SPX | 2026-09-18 11:34 | risk_reversal | 2 | 1 | 1000 | 19709000.00 | long | ask | 7626.5400 | 1.4000 | ["7000","8000"] | ["0.1984","0.1236"] | ["8025.63"] | ["XCBO"] | 7000.0000 | 8000.0000 | 119 | 119 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:35:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b527-dbc7-7651-85e8-77e855697d6f | SPX | 2026-09-18 11:34 | risk_reversal | 2 | 1 | 1500 | 29563500.00 | long | ask | 7626.7400 | 1.4000 | ["7000","8000"] | ["0.1984","0.1236"] | ["8025.63"] | ["XCBO"] | 7000.0000 | 8000.0000 | 119 | 119 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:35:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b50e-e90f-73f3-a317-bc290a2d2ddb | SPX | 2026-09-18 11:07 | risk_reversal | 2 | 1 | 2000 | 39502000.00 | long | ask | 7629.9600 | 1.4000 | ["7000","8000"] | ["0.1986","0.1234"] | ["8026.73"] | ["XCBO"] | 7000.0000 | 8000.0000 | 119 | 119 | false | true | false | true | true | cbmo | market_whale | 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 |
| 01a0b4f7-9467-75c1-9195-148337590f56 | SPX | 2026-09-18 10:41 | risk_reversal | 2 | 1 | 39 | 545610.00 | long | ask | 7624.1500 | 1.0000 | ["7000","8000"] | ["0.2022","0.1182"] | ["8005.80"] | ["XCBO"] | 7000.0000 | 8000.0000 | 91 | 91 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:42:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ce-32a8-72c0-984a-fc0ee290f66b | SPX | 2026-09-18 09:56 | risk_reversal | 2 | 1 | 500 | 9977000.00 | long | ask | 7631.7000 | 1.4000 | ["7000","8000"] | ["0.1990","0.1242"] | ["8028.50"] | ["XCBO"] | 7000.0000 | 8000.0000 | 119 | 119 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:57:02Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0d9-697b-7f61-8f4f-e3e5b8a26599 | SPX | 2026-09-17 15:30 | risk_reversal | 2 | 1 | 250 | 168250.00 | short | ask | 7638.2100 | 0.1500 | ["7550","7700"] | ["0.1880","0.1214"] | ["7548.19"] | ["XCBO"] | 7550.0000 | 7700.0000 | 1 | 1 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:30:58Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe7-fccb-79c1-85a0-406b1da0fc74 | SPX | 2026-09-17 11:06 | risk_reversal | 2 | 1 | 2000 | 17176000.00 | short | ask | 7616.9000 | 1.0000 | ["7000","8000"] | ["0.2051","0.1155"] | ["6994.62"] | ["XCBO"] | 7000.0000 | 8000.0000 | 64 | 64 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:07:01Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb1-6f6b-7643-9fbc-cb7e99252176 | SPX | 2026-09-16 15:28 | risk_reversal | 2 | 1 | 300 | 14822400.00 | long | ask | 7513.7300 | 3.0000 | ["7000","8000"] | ["0.2026","0.1454"] | ["8066.40"] | ["XCBO"] | 7000.0000 | 8000.0000 | 274 | 274 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:29:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aae3-a3d3-7ca3-bef6-1a84802c2862 | SPX | 2026-09-16 11:43 | risk_reversal | 2 | 1 | 300 | 757500.00 | short | ask | 7615.9700 | 0.6000 | ["7000","8000"] | ["0.2230","0.1069"] | ["6988.75"] | ["XCBO"] | 7000.0000 | 8000.0000 | 30 | 30 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:44:18Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aae3-a3d3-7ca3-bef6-1a7267e758e2 | SPX | 2026-09-16 11:43 | risk_reversal | 2 | 1 | 500 | 1262500.00 | short | ask | 7615.9700 | 0.6000 | ["7000","8000"] | ["0.2230","0.1069"] | ["6988.75"] | ["XCBO"] | 7000.0000 | 8000.0000 | 30 | 30 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:44:18Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a637-d216-7331-9948-6a3e0f6001c7 | SPX | 2026-09-15 13:57 | risk_reversal | 2 | 1 | 250 | 1025750.00 | short | ask | 7584.8600 | 0.4000 | ["7520","7715"] | ["0.1598","0.1171"] | ["7495.03"] | ["XCBO"] | 7520.0000 | 7715.0000 | 6 | 6 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:58:07Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5b0-a886-70d0-b0e2-aa39a9b0ae84 | SPX | 2026-09-15 11:30 | risk_reversal | 2 | 3 | 400 | 2741600.00 | short | ask | 7586.5100 | 0.4000 | ["7570","7800"] | ["0.1512","0.1109"] | ["7510.66"] | ["XCBO"] | 7570.0000 | 7800.0000 | 10 | 10 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:30:43Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a11c-1d71-70e0-aa47-60f219cbeb3b | SPX | 2026-09-14 14:09 | risk_reversal | 2 | 1 | 200 | 14045600.00 | long | ask | 7637.6500 | 2.9000 | ["7000","8000"] | ["0.2087","0.1521"] | ["8229.76"] | ["XCBO"] | 7000.0000 | 8000.0000 | 368 | 368 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:09:45Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a065-2981-79e3-a0ba-df20d0b94472 | SPX | 2026-09-14 10:49 | risk_reversal | 2 | 1 | 100 | 1119700.00 | short | ask | 7598.8600 | 0.8000 | ["7600","7900"] | ["0.1400","0.1080"] | ["7508.83"] | ["XCBO"] | 7600.0000 | 7900.0000 | 25 | 25 | false | false | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:49:40Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09133-4118-76a2-aaa6-f06029d366bb | SPX | 2026-09-11 12:00 | risk_reversal | 2 | 1 | 50 | 151750.00 | short | ask | 7671.7800 | 0.4000 | ["7550","7775"] | ["0.1527","0.1008"] | ["7541.15"] | ["XCBO"] | 7550.0000 | 7775.0000 | 7 | 7 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:01:10Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09111-f991-7013-94a1-f123d59aeef8 | SPX | 2026-09-11 11:24 | risk_reversal | 2 | 1 | 2 | 46100.00 | long | ask | 7669.4600 | 1.5000 | ["7000","8000"] | ["0.2028","0.1286"] | ["8051.50"] | ["XCBO"] | 7000.0000 | 8000.0000 | 126 | 126 | false | true | false | true | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:24:52Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090cd-f380-7051-a465-b2a3fe0153cc | SPX | 2026-09-11 10:10 | risk_reversal | 2 | 2 | 93 | 1075266.00 | short | ask | 7668.1900 | 1.1000 | ["7550","7800"] | ["0.1462","0.1116"] | ["7535.70"] | ["XCBO"] | 7550.0000 | 7800.0000 | 28 | 28 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:10:13Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08be4-0829-74b1-8ba0-4fbf8fee6469 | SPX | 2026-09-10 11:16 | risk_reversal | 2 | 1 | 200 | 14102000.00 | long | ask | 7603.1200 | 2.4000 | ["7000","8000"] | ["0.2091","0.1550"] | ["8203.10"] | ["XCBO"] | 7000.0000 | 8000.0000 | 372 | 372 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:16:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08be4-0829-74b1-8ba0-4fa8cabe253c | SPX | 2026-09-10 11:16 | risk_reversal | 2 | 1 | 100 | 7051000.00 | long | ask | 7603.1200 | 2.4000 | ["7000","8000"] | ["0.2091","0.1550"] | ["8203.10"] | ["XCBO"] | 7000.0000 | 8000.0000 | 372 | 372 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:16:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086fa-5b50-7e50-8015-6437bd8414ec | SPX | 2026-09-09 12:22 | risk_reversal | 2 | 1 | 60 | 384000.00 | long | ask | 7628.2600 | 0.4000 | ["7600","7650"] | ["0.1275","0.1157"] | ["7652.00"] | ["XCBO"] | 7600.0000 | 7650.0000 | 5 | 5 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:22:43Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086f8-ec20-73a3-80be-c2fd5817cf16 | SPX | 2026-09-09 12:20 | risk_reversal | 2 | 1 | 100 | 3618200.00 | long | ask | 7628.1800 | 1.6000 | ["7000","8000"] | ["0.2023","0.1388"] | ["8077.70"] | ["XCBO"] | 7000.0000 | 8000.0000 | 191 | 191 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:21:11Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086f8-ec20-73a3-80be-c2ee5814e818 | SPX | 2026-09-09 12:20 | risk_reversal | 2 | 1 | 250 | 9045500.00 | long | ask | 7628.1800 | 1.6000 | ["7000","8000"] | ["0.2023","0.1388"] | ["8077.70"] | ["XCBO"] | 7000.0000 | 8000.0000 | 191 | 191 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:21:11Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08227-dc11-7352-9b2f-5544085f1b35 | SPX | 2026-09-08 13:54 | risk_reversal | 2 | 3 | 810 | 1898640.00 | short | ask | 7693.7700 | 0.3000 | ["7645","7785"] | ["0.1398","0.1115"] | ["7631.56"] | ["XCBO"] | 7645.0000 | 7785.0000 | 3 | 3 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:54:59Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dc8-b655-7a82-ae85-53f30a242385 | SPX | 2026-09-04 14:57 | risk_reversal | 2 | 1 | 1000 | 850000.00 | long | ask | 7718.2100 | 0.3500 | ["7650","7750"] | ["0.0718","0.0491"] | ["7752.50"] | ["XCBO"] | 7650.0000 | 7750.0000 | 4 | 4 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:57:54Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06db5-323d-7361-bc34-3c39391ec63c | SPX | 2026-09-04 14:36 | risk_reversal | 2 | 1 | 825 | 272250.00 | short | ask | 7714.4000 | 0.2500 | ["7000","8000"] | ["0.2361","0.0907"] | ["6999.30"] | ["XCBO"] | 7000.0000 | 8000.0000 | 14 | 14 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:36:37Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d29-ab7d-72e3-877b-8d0325216c1a | SPX | 2026-09-04 12:04 | risk_reversal | 2 | 1 | 900 | 27758700.00 | short | ask | 7714.4800 | 1.2500 | ["8000","9000"] | ["0.1227","0.1271"] | ["7693.51"] | ["XCBO"] | 8000.0000 | 9000.0000 | 77 | 77 | false | false | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:04:35Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d22-587d-7980-9838-54821f65c348 | SPX | 2026-09-04 11:56 | risk_reversal | 2 | 1 | 100 | 282000.00 | short | ask | 7715.6000 | 0.4000 | ["7650","7800"] | ["0.1070","0.0849"] | ["7641.40"] | ["XCBO"] | 7650.0000 | 7800.0000 | 7 | 7 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T15:56:29Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |