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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c53d-3fa6-7523-a8fa-3f92eb156cf5 | SPX | 2026-09-21 14:31 | put_frontspread | 2 | 1 | 6 | 137499.00 | long | ask | 7767.5200 | 1.2000 | ["7300","7900"] | ["0.1804","0.1389"] | ["6754.85","7845.15"] | ["XCBO"] | 7300.0000 | 7900.0000 | 116 | 116 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:32:11Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c53c-f56e-7a50-b171-af446a549ae0 | SPX | 2026-09-21 14:31 | put_frontspread | 2 | 1 | 10 | 228635.00 | long | ask | 7767.9100 | 1.2000 | ["7300","7900"] | ["0.1802","0.1387"] | ["6754.75","7845.25"] | ["XCBO"] | 7300.0000 | 7900.0000 | 116 | 116 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:32:11Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c51f-1cce-7962-8f69-142cdc2269eb | SPX | 2026-09-21 13:59 | put_frontspread | 2 | 1 | 20 | 94360.00 | long | ask | 7760.1500 | 0.5000 | ["7740","7775"] | ["0.1145","0.1090"] | ["7693.40"] | ["XCBO"] | 7740.0000 | 7775.0000 | 4 | 4 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:59:34Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0afad-2a32-7032-8890-139bdb45b7ff | SPX | 2026-09-17 10:02 | put_frontspread | 2 | 1 | 10 | 36630.00 | long | ask | 7616.5300 | 0.6000 | ["6925","7400"] | ["0.2290","0.1596"] | ["6471.30","7378.70"] | ["XCBO"] | 6925.0000 | 7400.0000 | 29 | 29 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:02:41Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abbc-19e3-7450-be49-f5214ae521ef | SPX | 2026-09-16 15:40 | put_frontspread | 2 | 1 | 18 | 32913.00 | long | ask | 7534.4200 | 0.6000 | ["7000","7200"] | ["0.2464","0.2078"] | ["6800.45","7199.55"] | ["XCBO"] | 7000.0000 | 7200.0000 | 14 | 14 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:40:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abb3-4813-7982-a8ed-511b3ec40db7 | SPX | 2026-09-16 15:30 | put_frontspread | 2 | 1 | 15 | 44070.00 | long | ask | 7524.8900 | 0.5000 | ["7375","7500"] | ["0.2399","0.1966"] | ["7163.40","7480.80"] | ["XCBO"] | 7375.0000 | 7500.0000 | 2 | 2 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:30:50Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba6-e04b-7650-a9cf-144ad64a3c21 | SPX | 2026-09-16 15:17 | put_frontspread | 2 | 1 | 2 | 32021.00 | long | ask | 7523.5800 | 2.0000 | ["7200","7300"] | ["0.1859","0.1759"] | ["7018.25"] | ["XCBO"] | 7200.0000 | 7300.0000 | 75 | 75 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:17:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab1d-12f3-7fa0-b8e3-f1ac006206c2 | SPX | 2026-09-16 12:46 | put_frontspread | 2 | 1 | 3 | 38302.00 | long | ask | 7612.5200 | 1.3000 | ["7000","7460"] | ["0.2090","0.1610"] | ["6162.90","7418.55"] | ["XCBO"] | 7000.0000 | 7460.0000 | 65 | 65 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:46:51Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab1d-12f3-7fa0-b8e3-f1920f7fa0a7 | SPX | 2026-09-16 12:46 | put_frontspread | 2 | 1 | 6 | 76606.00 | long | ask | 7612.5200 | 1.3000 | ["7000","7460"] | ["0.2090","0.1609"] | ["6162.85","7418.58"] | ["XCBO"] | 7000.0000 | 7460.0000 | 65 | 65 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:46:51Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab1d-12f3-7fa0-b8e3-f1790225279b | SPX | 2026-09-16 12:46 | put_frontspread | 2 | 1 | 6 | 76640.00 | long | ask | 7612.5200 | 1.4000 | ["7000","7460"] | ["0.2090","0.1610"] | ["6162.90","7418.55"] | ["XCBO"] | 7000.0000 | 7460.0000 | 65 | 65 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:46:51Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab1d-0f0b-7f41-83da-ce15a07f7649 | SPX | 2026-09-16 12:46 | put_frontspread | 2 | 1 | 6 | 76640.00 | long | ask | 7612.5200 | 1.4000 | ["7000","7460"] | ["0.2090","0.1610"] | ["6162.90","7418.55"] | ["XCBO"] | 7000.0000 | 7460.0000 | 65 | 65 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:46:51Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5cd-dd16-73b3-8d68-d153ffb8417c | SPX | 2026-09-15 12:02 | put_frontspread | 2 | 1 | 15 | 90695.00 | long | ask | 7583.9000 | 0.4000 | ["7560","7585"] | ["0.1967","0.1892"] | ["7497.05"] | ["XCBO"] | 7560.0000 | 7585.0000 | 2 | 2 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:02:07Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a58e-f786-7471-b8b6-f8975bf56572 | SPX | 2026-09-15 10:53 | put_frontspread | 2 | 2 | 2 | 25798.00 | long | ask | 7573.5400 | 1.6000 | ["7640","7700"] | ["0.1752","0.3007"] | ["7573.70"] | ["XCBO"] | 7640.0000 | 7700.0000 | 0 | 0 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:53:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a10c-75a0-7050-96b1-17413329606f | SPX | 2026-09-14 13:52 | put_frontspread | 2 | 1 | 6 | 204386.00 | long | ask | 7640.0400 | 1.6000 | ["7575","7650"] | ["0.1566","0.1508"] | ["7145.30"] | ["XCBO"] | 7575.0000 | 7650.0000 | 95 | 95 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:52:25Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a038-2de0-7d42-9bca-59efea151026 | SPX | 2026-09-14 10:00 | put_frontspread | 2 | 1 | 30 | 59830.00 | long | ask | 7615.1900 | 0.4000 | ["7375","7575"] | ["0.2346","0.1731"] | ["7280.98","7563.05"] | ["XCBO"] | 7375.0000 | 7575.0000 | 4 | 4 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:00:30Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090e5-dc98-7f01-8a91-fd0c1c49ae86 | SPX | 2026-09-11 10:36 | put_frontspread | 2 | 1 | 10 | 109805.00 | long | ask | 7658.7000 | 3.0000 | ["7690","7735"] | ["0.1191","0.1123"] | ["7607.45"] | ["XCBO"] | 7690.0000 | 7735.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:36:30Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a081db-e2d8-7790-bbe8-8d2aa615a1e2 | SPX | 2026-09-08 12:31 | put_frontspread | 2 | 1 | 4 | 122012.00 | long | ask | 7686.0100 | 1.2000 | ["7700","7900"] | ["0.1418","0.1301"] | ["7423.10"] | ["XCBO"] | 7700.0000 | 7900.0000 | 73 | 73 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:31:24Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08169-4700-7580-bd6e-14d55cdaf5bc | SPX | 2026-09-08 10:25 | put_frontspread | 2 | 1 | 3 | 78855.00 | long | ask | 7685.4300 | 1.3000 | ["7675","7700"] | ["0.1494","0.1478"] | ["7472.08"] | ["XCBO"] | 7675.0000 | 7700.0000 | 101 | 101 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:25:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |