Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
403,968 rowsCSV — whole table, not this view
Sources in this table
uw_multileg403,968 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c9ca-f586-7f81-ad0f-cbf65c2390c7 | SPX | 2026-09-22 11:45 | jade_lizard | 3 | 1 | 50 | 29452.00 | short | bid | 7758.7100 | 0.1580 | ["7745","7770","7850"] | ["0.1163","0.1054","0.2187"] | ["7739.30","7775.70"] | ["XCBO"] | 7745.0000 | 7850.0000 | 0 | 0 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:46:02Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9ca-da2f-74f3-8098-2ee40989c850 | SPX | 2026-09-22 11:45 | jade_lizard | 3 | 1 | 55 | 26950.00 | short | bid | 7758.4300 | 0.2500 | ["7745","7775","7825"] | ["0.1170","0.1060","0.1764"] | ["7740.40","7779.60"] | ["XCBO"] | 7745.0000 | 7825.0000 | 0 | 0 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:45:15Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c574-9f6f-7e61-829b-5611bf29890f | SPX | 2026-09-21 15:32 | jade_lizard | 3 | 1 | 14 | 679198.00 | long | bid | 7773.0000 | 1.2000 | ["6900","7740"] | ["0.2193","0.1430"] | ["7342.98","8137.02"] | ["XCBO"] | 6900.0000 | 7740.0000 | 88 | 88 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:32:57Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c512-6eb7-7e00-8aa3-6bd90b4818db | SPX | 2026-09-21 13:45 | jade_lizard | 3 | 1 | 58 | 32480.00 | long | bid | 7759.7700 | 0.2000 | ["7590","7750","7765"] | ["0.5589","0.1219","0.1065"] | ["7744.70","7770.30"] | ["XCBO"] | 7590.0000 | 7765.0000 | 0 | 0 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:45:25Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4b7-239e-7231-b42f-dee8ec391380 | SPX | 2026-09-21 12:05 | jade_lizard | 3 | 1 | 2 | 49392.00 | short | bid | 7741.4900 | 2.8000 | ["7665","7920"] | ["0.1251","0.1082"] | ["7480.30","7849.70"] | ["XCBO"] | 7665.0000 | 7920.0000 | 25 | 25 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:05:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4b6-f4be-7552-b761-c6fb07a46b70 | SPX | 2026-09-21 12:05 | jade_lizard | 3 | 1 | 2 | 49812.00 | short | bid | 7741.1600 | 2.8000 | ["7660","7920"] | ["0.1257","0.1082"] | ["7473.10","7846.90"] | ["XCBO"] | 7660.0000 | 7920.0000 | 25 | 25 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:05:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4a4-a157-7812-b99b-d092c364cb94 | SPX | 2026-09-21 11:45 | jade_lizard | 3 | 1 | 56 | 35000.00 | long | bid | 7738.4100 | 0.2500 | ["7560","7725","7750"] | ["0.4264","0.1181","0.1098"] | ["7719.05","7755.95"] | ["XCBO"] | 7560.0000 | 7750.0000 | 0 | 0 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:45:28Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4a4-7e2f-7f31-8a21-bb5008627c78 | SPX | 2026-09-21 11:45 | jade_lizard | 3 | 1 | 58 | 30740.00 | long | bid | 7738.1200 | 0.2500 | ["7630","7725","7755"] | ["0.2924","0.1158","0.1140"] | ["7720.20","7759.80"] | ["XCBO"] | 7630.0000 | 7755.0000 | 0 | 0 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:45:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5d6-4437-7eb2-ba44-aa162f444257 | SPX | 2026-09-18 14:45 | jade_lizard | 3 | 1 | 53 | 26235.00 | long | bid | 7635.7700 | 0.2000 | ["7545","7630","7640"] | ["0.4380","0.1182","0.1263"] | ["7625.35","7644.65"] | ["XCBO"] | 7545.0000 | 7640.0000 | 0 | 0 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:45:24Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b588-8daf-7fb2-b7d1-4330dc0c7b21 | SPX | 2026-09-18 13:20 | jade_lizard | 3 | 1 | 20 | 164400.00 | short | bid | 7624.1500 | 0.6000 | ["7550","7625","7700"] | ["0.1246","0.1049","0.0928"] | ["7495.40","7679.60"] | ["XCBO"] | 7550.0000 | 7700.0000 | 7 | 7 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:20:28Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b588-8daf-7fb2-b7d1-4323222b7fee | SPX | 2026-09-18 13:20 | jade_lizard | 3 | 2 | 30 | 246600.00 | short | bid | 7624.1500 | 0.6000 | ["7550","7625","7700"] | ["0.1246","0.1049","0.0928"] | ["7495.40","7679.60"] | ["XCBO"] | 7550.0000 | 7700.0000 | 7 | 7 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:20:28Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afcf-63ea-74f3-b216-554bbe3525f7 | SPX | 2026-09-17 10:39 | jade_lizard | 3 | 1 | 10 | 30520.00 | long | bid | 7628.2400 | 0.5000 | ["7475","7605","7660"] | ["0.2441","0.1662","0.1539"] | ["7579","7686.00"] | ["XCBO"] | 7475.0000 | 7660.0000 | 1 | 1 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:40:15Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afca-37b2-7653-92c4-c2962c28c24f | SPX | 2026-09-17 10:34 | jade_lizard | 3 | 1 | 9 | 26208.00 | long | bid | 7628.4200 | 0.5000 | ["7465","7595","7655"] | ["0.2484","0.1702","0.1546"] | ["7569.70","7680.30"] | ["XCBO"] | 7465.0000 | 7655.0000 | 1 | 1 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:34:22Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa7-b3c3-7e63-b229-8f60ed13e27e | SPX | 2026-09-17 09:56 | jade_lizard | 3 | 1 | 10 | 31770.00 | long | bid | 7622.3800 | 0.5000 | ["7450","7595","7650"] | ["0.2582","0.1733","0.1592"] | ["7566.95","7678.05"] | ["XCBO"] | 7450.0000 | 7650.0000 | 1 | 1 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:56:38Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa6-a253-7e83-b426-2031c847dafc | SPX | 2026-09-17 09:55 | jade_lizard | 3 | 1 | 10 | 32720.00 | long | bid | 7623.6400 | 0.5000 | ["7475","7595","7650"] | ["0.2438","0.1735","0.1610"] | ["7567.30","7677.70"] | ["XCBO"] | 7475.0000 | 7650.0000 | 1 | 1 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:55:33Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a08671-c290-7ad3-898d-c56cada2baae | SPX | 2026-09-09 09:53 | jade_lizard | 3 | 1 | 51 | 104346.00 | long | bid | 7650.0100 | 0.2500 | ["7645","7650","7685"] | ["0.1349","0.1319","0.1391"] | ["7646.46","7688.54"] | ["XCBO"] | 7645.0000 | 7685.0000 | 0 | 0 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:53:37Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0823b-4ca0-7dc3-bab5-4356b60b8641 | SPX | 2026-09-08 14:15 | jade_lizard | 3 | 1 | 53 | 29945.00 | short | bid | 7693.2000 | 0.1500 | ["7690","7695","7745"] | ["0.0953","0.0844","0.2118"] | ["7684.55","7700.45"] | ["XCBO"] | 7690.0000 | 7745.0000 | 0 | 0 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:16:09Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |