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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b54b-1368-72e3-a607-dcb47b6c5cef | SPX | 2026-09-18 12:13 | put_diagonal_spread | 2 | 1 | 60 | 1214700.00 | unknown | bid | 7621.4000 | 1.5000 | ["7475","7685"] | ["0.1606","0.1441"] | [] | ["XCBO"] | 7475.0000 | 7685.0000 | 91 | 119 | false | false | true | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:13:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b502-e6d7-7b41-89ab-3f9fef1c2809 | SPX | 2026-09-18 10:54 | put_diagonal_spread | 2 | 1 | 65 | 404545.00 | unknown | bid | 7628.4400 | 42.3000 | ["3000","7685"] | ["0.3254","0.1436"] | [] | ["XCBO"] | 3000.0000 | 7685.0000 | 91 | 1554 | false | false | true | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:54:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f7-2ed7-7071-9cc0-88c63677ea8a | SPX | 2026-09-18 10:41 | put_diagonal_spread | 2 | 1 | 40 | 365150.00 | unknown | bid | 7623.3000 | 1.3000 | ["6300","7690"] | ["0.2477","0.1432"] | [] | ["XCBO"] | 6300.0000 | 7690.0000 | 91 | 182 | false | false | true | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:41:48Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e6-db27-7821-8947-beebda12b17f | SPX | 2026-09-18 10:23 | put_diagonal_spread | 2 | 1 | 250 | 3011600.00 | unknown | bid | 7624.3300 | 1.5000 | ["6850","7690"] | ["0.2098","0.1444"] | [] | ["XCBO"] | 6850.0000 | 7690.0000 | 91 | 182 | false | false | true | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:23:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ca-d748-79a3-9271-a18011255f80 | SPX | 2026-09-18 09:53 | put_diagonal_spread | 2 | 1 | 60 | 293000.00 | unknown | bid | 7635.9000 | 1.5000 | ["7200","7705"] | ["0.1837","0.1437"] | [] | ["XCBO"] | 7200.0000 | 7705.0000 | 28 | 91 | false | false | true | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:53:08Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |