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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b604-41a8-7a62-9bce-2775a3c93a32 | SPX | 2026-09-18 15:35 | put_frontspread | 2 | 1 | 140 | 119650.00 | long | ask | 7637.4000 | 0.3000 | ["7400","7500"] | ["0.1553","0.1320"] | ["7343.12"] | ["XCBO"] | 7400.0000 | 7500.0000 | 7 | 7 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:35:42Z"} | 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 |
| 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 |
| 01a0aaf3-99c3-7570-a3bd-230725ede9e8 | SPX | 2026-09-16 12:01 | put_frontspread | 2 | 3 | 300 | 6122100.00 | long | ask | 7618.1900 | 1.2000 | ["6900","7600"] | ["0.2122","0.1531"] | ["5678.47","7510.76"] | ["XCBO"] | 6900.0000 | 7600.0000 | 106 | 106 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:01:39Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a08cd0-7398-7733-ae43-0cdf4f087e65 | SPX | 2026-09-10 15:34 | put_frontspread | 2 | 2 | 1000 | 2288000.00 | long | ask | 7591.3900 | 0.5000 | ["5400","6900"] | ["0.4260","0.2305"] | ["3925.80","6874.20"] | ["XCBO"] | 5400.0000 | 6900.0000 | 50 | 50 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:34:31Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a082a3-c2d0-75b1-80ad-6d6d547881bc | SPX | 2026-09-08 16:09 | put_frontspread | 2 | 2 | 500 | 275000.00 | long | ask | 7673.5200 | 0.2500 | ["7500","7650"] | ["0.2004","0.1254"] | ["7359.40","7640.60"] | ["XCBO"] | 7500.0000 | 7650.0000 | 1 | 1 | false | true | false | true | false | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T20:11:26Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 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 |