core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_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 |
|---|
| 01a06dfd-7a25-76a3-ac87-f5d086448c6e | SPX | 2026-09-04 15:55 | call_diagonal_spread_bearish | 2 | 1 | 50 | 82150.00 | long | ask | 7719.0300 | 0.6000 | ["7925","7930"] | ["0.0907","0.0920"] | [] | ["XCBO"] | 7925.0000 | 7930.0000 | 14 | 21 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:55:40Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfc-4975-71a2-a813-e4ad4452d814 | SPX | 2026-09-04 15:54 | call_diagonal_spread_bearish | 2 | 1 | 88 | 55440.00 | long | ask | 7718.6800 | 0.2500 | ["7770","7835"] | ["0.0475","0.0815"] | [] | ["XCBO"] | 7770.0000 | 7835.0000 | 4 | 7 | false | true | true | ||||||||||
| 01a06dfa-0b3d-7e90-a7c2-48038516530a | SPX | 2026-09-04 15:51 | call_diagonal_spread_bearish | 2 | 1 | 10 | 352930.00 | long | bid | 7718.6600 | 7.9000 | ["7540","7620"] | ["3.7823","0.1222"] | [] | ["XCBO"] | 7540.0000 | 7620.0000 | 0 | 28 | false | false | |||||||||||
| 01a06df9-72e5-7001-a294-bfa16732dee3 | SPX | 2026-09-04 15:50 | call_diagonal_spread_bearish | 2 | 1 | 5 | 45480.00 | long | ask | 7717.7400 | 0.7000 | ["7775","7785"] | ["0.0976","0.1004"] | [] | ["XCBO"] | 7775.0000 | 7785.0000 | 14 | 21 | false | true | |||||||||||
| 01a06df3-6fd5-79c3-aaa6-0b6e4e9a5400 | SPX | 2026-09-04 15:44 | call_diagonal_spread_bearish | 2 | 1 | 6 | 186246.00 | long | ask | 7714.8900 | 1.6000 | ["7730","7780"] | ["0.1166","0.1270"] | [] | ["XCBO"] | 7730.0000 | 7780.0000 | 42 | 77 | false | true | |||||||||||
| 01a06dd8-e2f5-7533-8e95-8b6ab03bedbb | SPX | 2026-09-04 15:15 | call_diagonal_spread_bearish | 2 | 1 | 2 | 33056.00 | long | ask | 7712.2300 | 1.3000 | ["8060","8400"] | ["0.1141","0.1247"] | [] | ["XCBO"] | 8060.0000 | 8400.0000 | 77 | 196 | false | true | |||||||||||
| 01a06dcf-039d-72f2-b58b-de79b7e4176e | SPX | 2026-09-04 15:04 | call_diagonal_spread_bearish | 2 | 1 | 6 | 54756.00 | long | ask | 7713.2500 | 0.7000 | ["7810","7820"] | ["0.0972","0.1023"] | [] | ["XCBO"] | 7810.0000 | 7820.0000 | 21 | 28 | false | true | |||||||||||
| 01a06dbe-716d-7f41-9f2f-a5587bd37127 | SPX | 2026-09-04 14:46 | call_diagonal_spread_bearish | 2 | 1 | 6 | 188922.00 | long | ask | 7716.9600 | 1.7000 | ["7720","7780"] | ["0.1158","0.1255"] | [] | ["XCBO"] | 7720.0000 | 7780.0000 | 42 | 77 | false | true | |||||||||||
| 01a06db4-20cd-74c3-a7bf-3c0270e0c53b | SPX | 2026-09-04 14:35 | call_diagonal_spread_bearish | 2 | 1 | 5 | 63705.00 | long | bid | 7715.3200 | 0.6000 | ["7750","7800"] | ["0.1016","0.1032"] | [] | ["XCBO"] | 7750.0000 | 7800.0000 | 21 | 28 | false | true | |||||||||||
| 01a06db0-8305-77d0-a6d9-b3ab107fd842 | SPX | 2026-09-04 14:31 | call_diagonal_spread_bearish | 2 | 1 | 2 | 32396.00 | long | ask | 7714.6500 | 1.5000 | ["8070","8400"] | ["0.1130","0.1241"] | [] | ["XCBO"] | 8070.0000 | 8400.0000 | 77 | 196 | false | true | |||||||||||
| 01a06daf-d33d-7f20-82ac-20f745652eff | SPX | 2026-09-04 14:30 | call_diagonal_spread_bearish | 2 | 1 | 19 | 50863.00 | long | bid | 7714.9300 | 0.8000 | ["8300","9300"] | ["0.1091","0.1193"] | [] | ["XCBO"] | 8300.0000 | 9300.0000 | 77 | 196 | false | true | |||||||||||
| 01a06da2-65bd-7431-a3da-a601ec2992fe | SPX | 2026-09-04 14:15 | call_diagonal_spread_bearish | 2 | 1 | 2 | 32806.00 | long | ask | 7711.9300 | 1.2000 | ["8060","8400"] | ["0.1135","0.1244"] | [] | ["XCBO"] | 8060.0000 | 8400.0000 | 77 | 196 | false | true | |||||||||||
| 01a06d9a-3fcd-7fc3-a22d-8d9b3dbfc992 | SPX | 2026-09-04 14:06 | call_diagonal_spread_bearish | 2 | 1 | 6 | 289632.00 | long | ask | 7709.3400 | 10.4000 | ["7520","7530"] | ["0.1243","0.1262"] | [] | ["XCBO"] | 7520.0000 | 7530.0000 | 26 | 32 | false | false | |||||||||||
| 01a06d92-6415-77c0-8ab0-fe698b3d09fb | SPX | 2026-09-04 13:58 | call_diagonal_spread_bearish | 2 | 1 | 35 | 74165.00 | long | bid | 7709.1600 | 0.4000 | ["7725","7750"] | ["0.0545","0.0640"] | [] | ["XCBO"] | 7725.0000 | 7750.0000 | 4 | 5 | false | true | |||||||||||
| 01a06d7d-9fad-7ca1-979e-6bbb7318bc47 | SPX | 2026-09-04 13:35 | call_diagonal_spread_bearish | 2 | 1 | 15 | 240765.00 | long | ask | 7711.1700 | 1.0000 | ["7725","7730"] | ["0.1056","0.1023"] | [] | ["XCBO"] | 7725.0000 | 7730.0000 | 21 | 24 | false | true | |||||||||||
| 01a06d7b-7115-70d0-9be0-7171fd569db7 | SPX | 2026-09-04 13:33 | call_diagonal_spread_bearish | 2 | 1 | 10 | 30304.00 | long | ask | 7711.8800 | 0.4000 | ["7700","7720"] | ["0.1349","0.0563"] | [] | ["XCBO"] | 7700.0000 | 7720.0000 | 0 | 4 | false | false | |||||||||||
| 01a06d7a-e85d-7851-9c83-6c43f64487d6 | SPX | 2026-09-04 13:32 | call_diagonal_spread_bearish | 2 | 1 | 45 | 717930.00 | long | bid | 7711.2900 | 0.9000 | ["7700","7750"] | ["0.1012","0.1038"] | [] | ["XCBO"] | 7700.0000 | 7750.0000 | 18 | 26 | false | false | |||||||||||
| 01a06d79-b7ad-7100-8b5c-bfc27bb4253b | SPX | 2026-09-04 13:31 | call_diagonal_spread_bearish | 2 | 1 | 50 | 799900.00 | long | bid | 7711.6200 | 0.8000 | ["7700","7750"] | ["0.1013","0.1039"] | [] | ["XCBO"] | 7700.0000 | 7750.0000 | 18 | 26 | false | false | |||||||||||
| 01a06d6f-b145-74b2-9d41-6c23542fe546 | SPX | 2026-09-04 13:20 | call_diagonal_spread_bearish | 2 | 1 | 20 | 535320.00 | long | ask | 7718.8100 | 1.7000 | ["8125","8150"] | ["0.1228","0.1273"] | [] | ["XCBO"] | 8125.0000 | 8150.0000 | 133 | 168 | false | true | |||||||||||
| 01a06d63-0ee5-72c1-a8fc-00c550e4692d | SPX | 2026-09-04 13:06 | call_diagonal_spread_bearish | 2 | 2 | 500 | 161500.00 | long | ask | 7720.8500 | 0.2500 | ["7890","7910"] | ["0.0872","0.0797"] | [] | ["XCBO"] | 7890.0000 | 7910.0000 | 7 | 10 | false | true | |||||||||||
| 01a06d5d-65ad-7a23-b108-a4af7b00d78c | SPX | 2026-09-04 13:00 | call_diagonal_spread_bearish | 2 | 1 | 2 | 32380.00 | long | ask | 7723.7200 | 1.3000 | ["8070","8425"] | ["0.1139","0.1241"] | [] | ["XCBO"] | 8070.0000 | 8425.0000 | 77 | 196 | false | true | |||||||||||
| 01a06d53-8a3d-7c83-a0d4-e3f2d54d577a | SPX | 2026-09-04 12:49 | call_diagonal_spread_bearish | 2 | 1 | 16 | 1561424.00 | long | ask | 7727.8100 | 3.4500 | ["7700","7900"] | ["0.1353","0.1614"] | [] | ["XCBO"] | 7700.0000 | 7900.0000 | 105 | 469 | false | false | |||||||||||
| 01a06d53-5b5d-7101-8387-91258e9a5db1 | SPX | 2026-09-04 12:49 | call_diagonal_spread_bearish | 2 | 1 | 90 | 1971000.00 | long | ask | 7727.8400 | 1.6000 | ["8225","8650"] | ["0.1200","0.1298"] | [] | ["XCBO"] | 8225.0000 | 8650.0000 | 133 | 286 | false | true | |||||||||||
| 01a06d53-4fa5-7802-8caa-13f332f8b3cb | SPX | 2026-09-04 12:49 | call_diagonal_spread_bearish | 2 | 1 | 60 | 1311480.00 | long | ask | 7727.8700 | 1.0000 | ["8225","8650"] | ["0.1198","0.1297"] | [] | ["XCBO"] | 8225.0000 | 8650.0000 | 133 | 286 | false | true | |||||||||||
| 01a06d44-0595-7891-894e-79c7793d5b4a | SPX | 2026-09-04 12:32 | call_diagonal_spread_bearish | 2 | 1 | 19 | 118617.00 | long | ask | 7724.1400 | 0.4000 | ["7720","7725"] | ["0.0560","0.0890"] | [] | ["XCBO"] | 7720.0000 | 7725.0000 | 4 | 7 | false | false | |||||||||||
| 01a06d32-def5-74d3-9075-51ff8bf54b16 | SPX | 2026-09-04 12:14 | call_diagonal_spread_bearish | 2 | 1 | 20 | 89940.00 | long | ask | 7721.4500 | 0.5000 | ["7730","7760"] | ["0.0665","0.0873"] | [] | ["XCBO"] | 7730.0000 | 7760.0000 | 5 | 7 | false | true |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:54:07Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:51:59Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:51:13Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:44:39Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:15:49Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:04:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:46:50Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:35:51Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:31:18Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:31:18Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:16:10Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:07:43Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:58:40Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:36:16Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:33:34Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:32:52Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:31:38Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:20:49Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:07:25Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:00:41Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:49:50Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:49:50Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:49:50Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:32:51Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:14:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |