core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg438,407 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 |
|---|
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |