Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c51e-1aff-7ef2-97f2-4bc9ed5073b9 | SPX | 2026-09-21 13:57 | put_frontspread | 2 | 1 | 44 | 89054.00 | long | ask | 7758.9600 | 1.1000 | ["5000","7825"] | ["0.4160","0.1398"] | ["4801.79","7708.85"] | ["XCBO"] | 5000.0000 | 7825.0000 | 88 | 88 | false | false | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:58:06Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c50c-c57f-7b41-aba3-8dfc16cb1414 | SPX | 2026-09-21 13:39 | put_frontspread | 2 | 1 | 100 | 94600.00 | long | ask | 7754.3200 | 0.3000 | ["7300","7700"] | ["0.2635","0.1215"] | ["6914.92","7685.08"] | ["XCBO"] | 7300.0000 | 7700.0000 | 4 | 4 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:39:25Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b60f-0f47-7732-9b4b-e9b9dd96fd2c | SPX | 2026-09-18 15:47 | put_vertical_spread | 2 | 1 | 15 | 37050.00 | unknown | ask | 7645.9700 | 0.4000 | ["7275","7500"] | ["0.1758","0.1310"] | ["7475.30"] | ["XCBO"] | 7275.0000 | 7500.0000 | 12 | 12 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:47:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b60c-6f67-7242-8f61-62a9afcbefff | SPX | 2026-09-18 15:44 | put_ratio_spread | 2 | 1 | 25 | 37050.00 | unknown | ask | 7643.7100 | 0.4000 | ["7200","7325"] | ["0.1915","0.1671"] | ["7310.18"] | ["XCBO"] | 7200.0000 | 7325.0000 | 14 | 14 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:44:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b59e-7710-75a2-bbbd-783dd2522879 | SPX | 2026-09-18 13:44 | put_frontspread | 2 | 1 | 136 | 96560.00 | long | ask | 7627.4100 | 1.0000 | ["3900","7695"] | ["0.5347","0.1432"] | ["3816.65","7595.27"] | ["XCBO"] | 3900.0000 | 7695.0000 | 91 | 91 | false | false | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:44:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b580-5c07-7d81-a75b-597566decb06 | SPX | 2026-09-18 13:11 | synthetic | 2 | 1 | 2 | 63280.00 | long | ask | 7622.8200 | 1.7000 | ["7690"] | ["0.1405"] | ["7585.20"] | ["XCBO"] | 7690.0000 | 7690.0000 | 91 | 91 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:11:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0fa-b4eb-7a93-9bc2-1c086137621c | SPX | 2026-09-17 16:06 | ratio_risk_reversal | 2 | 1 | 38 | 32249.00 | long | ask | 7637.7600 | 0.5000 | ["7070","7825"] | ["0.2241","0.0922"] | ["7828.47"] | ["XCBO"] | 7070.0000 | 7825.0000 | 13 | 13 | false | true | false | true | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T20:07:11Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab00-7e8b-74e2-b0e1-12f628275818 | SPX | 2026-09-16 12:15 | put_frontspread | 2 | 1 | 40 | 33400.00 | long | ask | 7614.7400 | 0.3000 | ["6300","7400"] | ["0.5030","0.1901"] | ["4668.58","7387.62"] | ["XCBO"] | 6300.0000 | 7400.0000 | 7 | 7 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:15:32Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab00-7e8b-74e2-b0e1-12ea23267b05 | SPX | 2026-09-16 12:15 | put_frontspread | 2 | 1 | 40 | 33400.00 | long | ask | 7614.7400 | 0.3000 | ["6300","7400"] | ["0.5030","0.1901"] | ["4668.58","7387.62"] | ["XCBO"] | 6300.0000 | 7400.0000 | 7 | 7 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:15:32Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 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 |
| 01a0a130-d620-7111-8b40-1060efc5d978 | SPX | 2026-09-14 14:32 | put_vertical_spread | 2 | 1 | 35 | 81130.00 | long | ask | 7632.9300 | 0.5000 | ["7300","7450"] | ["0.2069","0.1714"] | ["7440.70"] | ["XCBO"] | 7300.0000 | 7450.0000 | 8 | 8 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:32:40Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a12b-38a0-7c40-bfd2-c52e2fa4e2ef | SPX | 2026-09-14 14:25 | synthetic | 2 | 1 | 2 | 88840.00 | long | ask | 7634.3600 | 1.5000 | ["7705"] | ["0.1431"] | ["7707.00"] | ["XCBO"] | 7705.0000 | 7705.0000 | 95 | 95 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:26:10Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a045-d5f8-71b0-a8fd-58017f11919a | SPX | 2026-09-14 10:15 | straddle | 2 | 1 | 2 | 90110.00 | long | ask | 7619.3100 | 1.9000 | ["7685"] | ["0.1454"] | ["7234.45","8135.55"] | ["XCBO"] | 7685.0000 | 7685.0000 | 95 | 95 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:15:33Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091fc-2e98-71e0-8a30-13bf58a7be6e | SPX | 2026-09-11 15:40 | synthetic | 2 | 2 | 10 | 76400.00 | long | ask | 7662.7300 | 1.0000 | ["7665"] | ["0.1138"] | ["7647.40"] | ["XCBO"] | 7665.0000 | 7665.0000 | 7 | 7 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:40:21Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09162-d8b1-7653-9bd6-7f83c134d2d3 | SPX | 2026-09-11 12:52 | synthetic | 2 | 2 | 10 | 88400.00 | long | ask | 7666.5000 | 1.0000 | ["7670"] | ["0.1157"] | ["7681.60"] | ["XCBO"] | 7670.0000 | 7670.0000 | 7 | 7 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:53:25Z"} | 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 |
| 01a090d8-8a70-70c1-8739-26235eebaaa6 | SPX | 2026-09-11 10:21 | ratio_risk_reversal | 2 | 1 | 12 | 67056.00 | short | ask | 7671.0500 | 1.1000 | ["7665","7700"] | ["0.1239","0.1109"] | ["7716.88"] | ["XCBO"] | 7665.0000 | 7700.0000 | 7 | 7 | false | true | false | true | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:22:03Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cc6-07a0-79c1-b4e8-ff0e762edced | SPX | 2026-09-10 15:23 | straddle | 2 | 2 | 4 | 54400.00 | long | ask | 7588.2800 | 1.3000 | ["7595"] | ["0.1517"] | ["7459","7731.00"] | ["XCBO"] | 7595.0000 | 7595.0000 | 8 | 8 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:23:05Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca1-7c28-75b1-92bb-c63b8ee70193 | SPX | 2026-09-10 14:43 | synthetic | 2 | 2 | 4 | 39500.00 | long | ask | 7590.7200 | 1.5000 | ["7595"] | ["0.1476"] | ["7563.75"] | ["XCBO"] | 7595.0000 | 7595.0000 | 8 | 8 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:43:48Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c95-9931-7eb0-963c-be27ef9514f9 | SPX | 2026-09-10 14:30 | ratio_risk_reversal | 2 | 1 | 50 | 68940.00 | long | ask | 7589.1500 | 0.9000 | ["7300","7600"] | ["0.2106","0.1504"] | ["7291.43"] | ["XCBO"] | 7300.0000 | 7600.0000 | 8 | 8 | false | true | false | true | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:30:37Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 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 |
| 01a08c68-fb51-7ad1-8f2f-a1197c5db5a0 | SPX | 2026-09-10 13:41 | synthetic | 2 | 1 | 6 | 78000.00 | short | ask | 7594.6600 | 1.3000 | ["7605"] | ["0.1448"] | ["7600"] | ["XCBO"] | 7605.0000 | 7605.0000 | 8 | 8 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:41:35Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c60-5090-7cb2-a787-89fdbfc23132 | SPX | 2026-09-10 13:31 | synthetic | 2 | 1 | 2 | 26000.00 | short | ask | 7598.4500 | 1.2000 | ["7605"] | ["0.1448"] | ["7603"] | ["XCBO"] | 7605.0000 | 7605.0000 | 8 | 8 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:32:39Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c3a-a7f0-7540-9bed-5e0767874e0f | SPX | 2026-09-10 12:50 | synthetic | 2 | 2 | 11 | 94950.00 | long | ask | 7602.3300 | 0.8000 | ["7600"] | ["0.1454"] | ["7653.18"] | ["XCBO"] | 7600.0000 | 7600.0000 | 8 | 8 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:50:52Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bff-cd89-7a43-8b30-4e4e717d9c05 | SPX | 2026-09-10 11:46 | synthetic | 2 | 2 | 9 | 77661.00 | long | ask | 7603.4900 | 1.0000 | ["7610"] | ["0.1442"] | ["7654.09"] | ["XCBO"] | 7610.0000 | 7610.0000 | 8 | 8 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:46:46Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bf5-7900-7651-be4c-19147a08dee6 | SPX | 2026-09-10 11:35 | strangle | 2 | 1 | 100 | 33700.00 | long | ask | 7607.4500 | 0.2000 | ["7000","8000"] | ["0.2904","0.1365"] | ["6996.63","8003.37"] | ["XCBO"] | 7000.0000 | 8000.0000 | 8 | 8 | false | true | false | true | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:35:13Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08be3-7f70-7d51-8d31-ba4975ad460b | SPX | 2026-09-10 11:15 | synthetic | 2 | 1 | 6 | 76920.00 | long | ask | 7602.3300 | 1.1000 | ["7610"] | ["0.1427"] | ["7611.00"] | ["XCBO"] | 7610.0000 | 7610.0000 | 8 | 8 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:15:53Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087b9-cf08-7181-a163-36df6f18d2ca | SPX | 2026-09-09 15:51 | synthetic | 2 | 1 | 10 | 94100.00 | long | ask | 7636.8400 | 1.2000 | ["7645"] | ["0.1315"] | ["7677.70"] | ["XCBO"] | 7645.0000 | 7645.0000 | 9 | 9 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:51:43Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086d9-6da0-7f51-8f2d-5b19e1a57350 | SPX | 2026-09-09 11:46 | ratio_risk_reversal | 2 | 1 | 40 | 86040.00 | long | ask | 7635.2800 | 0.9000 | ["7400","7640"] | ["0.1803","0.1312"] | ["7394.49"] | ["XCBO"] | 7400.0000 | 7640.0000 | 9 | 9 | false | true | false | true | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:47:00Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08242-2e58-7320-bdd5-5acdcc8fa497 | SPX | 2026-09-08 14:22 | synthetic | 2 | 1 | 5 | 59500.00 | long | ask | 7692.0200 | 1.0000 | ["7695"] | ["0.1171"] | ["7698.00"] | ["XCBO"] | 7695.0000 | 7695.0000 | 10 | 10 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:23:04Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08232-8a71-77e2-8792-63c030d9f928 | SPX | 2026-09-08 14:05 | put_vertical_spread | 2 | 1 | 55 | 27720.00 | long | ask | 7692.1400 | 0.1500 | ["7500","7600"] | ["0.1738","0.1361"] | ["7596.70"] | ["XCBO"] | 7500.0000 | 7600.0000 | 2 | 2 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:06:10Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dec-6af4-7f31-a8b4-6ae9fb4c46b7 | SPX | 2026-09-04 15:36 | synthetic | 2 | 1 | 5 | 62100.00 | short | ask | 7714.9900 | 1.1000 | ["7720"] | ["0.1030"] | ["7718"] | ["XCBO"] | 7720.0000 | 7720.0000 | 14 | 14 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:37:14Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06db1-03ed-7911-91ce-9b3bf1dc27ab | SPX | 2026-09-04 14:31 | synthetic | 2 | 1 | 10 | 39700.00 | long | ask | 7714.4600 | 0.4000 | ["7700"] | ["0.0575"] | ["7715.10"] | ["XCBO"] | 7700.0000 | 7700.0000 | 4 | 4 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:32:06Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d99-1305-7e42-8280-75ab203f7d9e | SPX | 2026-09-04 14:05 | straddle | 2 | 1 | 5 | 63300.00 | long | ask | 7708.5100 | 0.9000 | ["7715"] | ["0.1051"] | ["7588.40","7841.60"] | ["XCBO"] | 7715.0000 | 7715.0000 | 14 | 14 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:06:02Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d75-fe8d-7190-815d-5fd8c1cb94b1 | SPX | 2026-09-04 13:27 | put_frontspread | 2 | 2 | 66 | 78778.00 | long | ask | 7716.2600 | 0.4000 | ["7425","7500"] | ["0.1464","0.1340"] | ["7309.81","7499.87"] | ["XCBO"] | 7425.0000 | 7500.0000 | 12 | 12 | false | true | false | true | false | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:27:29Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d61-8845-7a33-8aad-468ac792a1ef | SPX | 2026-09-04 13:05 | synthetic | 2 | 1 | 2 | 25040.00 | short | ask | 7720.4500 | 1.0000 | ["7730"] | ["0.1038"] | ["7726"] | ["XCBO"] | 7730.0000 | 7730.0000 | 14 | 14 | false | false | false | false | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:05:14Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |