core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg570,195 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 |
|---|
| 01a0eebc-ff56-7630-bbfa-bbe98a91a104 | SPX | 2026-09-29 15:55 | strip | 2 | 1 | 4 | 53610.00 | unknown | bid | 7670.7700 | 2.7000 | ["7525"] | ["0.1460"] | ["7390.98","7793.05"] | ["XCBO"] | 7525.0000 | 7525.0000 | 17 | 17 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-29T19:56:11Z"} | 2026-09-29 | 2026-09-29 17:15 | 2026-09-29 17:15 |
| 01a0edc9-834f-76a0-a4bc-150191eab69b | SPX | 2026-09-29 11:29 | strip | 2 | 2 | 1000 | 1835000.00 | unknown | bid | 7658.6400 | 0.3000 | ["7650"] | ["0.1912"] | ["7648.95"] | ["XCBO"] | 7650.0000 | 7650.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0da27-34ef-7633-8248-3eb1a104bc81 | SPX | 2026-09-25 15:59 | strip | 2 | 1 | 4 | 50310.00 | unknown | bid | 7742.0900 | 3.5000 | ["7650"] | ["0.1249"] | ["7524.22","7901.55"] | ["XCBO"] | 7650.0000 | 7650.0000 | 21 | 21 | false | false | false | false | |||||||||
| 01a0da21-58ef-70a0-918d-110138577015 | SPX | 2026-09-25 15:53 | strip | 2 | 1 | 2 | 27200.00 | unknown | bid | 7748.1100 | 2.2000 | ["7600"] | ["0.1315"] | ["7464","7872.00"] | ["XCBO"] | 7600.0000 | 7600.0000 | 21 | 21 | false | false | false | false | |||||||||
| 01a0da1a-cd27-7792-836f-ba6114f2b0ba | SPX | 2026-09-25 15:46 | strip | 2 | 1 | 4 | 92780.00 | unknown | bid | 7746.8000 | 2.3000 | ["7635"] | ["0.1414"] | ["7403.05","8098.90"] | ["XCBO"] | 7635.0000 | 7635.0000 | 56 | 56 | false | false | false | false | |||||||||
| 01a0d9d3-8326-75c3-9900-3e409cd80f5c | SPX | 2026-09-25 14:28 | strip | 2 | 1 | 4 | 43910.00 | unknown | bid | 7736.5500 | 5.9000 | ["7610"] | ["0.1291"] | ["7500.22","7829.55"] | ["XCBO"] | 7610.0000 | 7610.0000 | 14 | 14 | false | false | false | false | |||||||||
| 01a0d9a7-9cde-7833-af83-6a01cba637cc | SPX | 2026-09-25 13:40 | strip | 2 | 2 | 10 | 299250.00 | unknown | bid | 7740.9500 | 1.4000 | ["7800"] | ["0.1366"] | ["7700.25"] | ["XCBO"] | 7800.0000 | 7800.0000 | 84 | 84 | false | false | false | false | |||||||||
| 01a0d8cc-7f1e-7740-a337-163674267c93 | SPX | 2026-09-25 09:41 | strip | 2 | 2 | 148 | 4462200.00 | unknown | bid | 7727.7000 | 1.6000 | ["7780"] | ["0.1386"] | ["7683.50"] | ["XCBO"] | 7780.0000 | 7780.0000 | 84 | 84 | false | false | false | false | |||||||||
| 01a0caa9-340f-7581-9515-b240282cf068 | SPX | 2026-09-22 15:47 | strip | 2 | 1 | 2 | 120570.00 | unknown | bid | 7776.5200 | 5.8000 | ["7750"] | ["0.1664"] | ["7147.15","8955.70"] | ["XCBO"] | 7750.0000 | 7750.0000 | 268 | 268 | false | false | false | false | |||||||||
| 01a0caa9-340f-7581-9515-b23403d36139 | SPX | 2026-09-22 15:47 | strip | 2 | 1 | 6 | 361755.00 | unknown | bid | 7776.5200 | 5.8000 | ["7750"] | ["0.1664"] | ["7147.08","8955.85"] | ["XCBO"] | 7750.0000 | 7750.0000 | 268 | 268 | false | false | false | false | |||||||||
| 01a0caa9-3027-7af2-be44-7d627785cbd5 | SPX | 2026-09-22 15:47 | strip | 2 | 1 | 6 | 361755.00 | unknown | bid | 7776.5200 | 5.8000 | ["7750"] | ["0.1664"] | ["7147.08","8955.85"] | ["XCBO"] | 7750.0000 | 7750.0000 | 268 | 268 | false | false | false | false | |||||||||
| 01a0caa9-3027-7af2-be44-7d5658bb1f12 | SPX | 2026-09-22 15:47 | strip | 2 | 1 | 6 | 361755.00 | unknown | bid | 7776.5200 | 5.8000 | ["7750"] | ["0.1664"] | ["7147.08","8955.85"] | ["XCBO"] | 7750.0000 | 7750.0000 | 268 | 268 | false | false | false | false | |||||||||
| 01a0caa9-3027-7af2-be44-7d43b0086b5e | SPX | 2026-09-22 15:47 | strip | 2 | 1 | 6 | 361755.00 | unknown | bid | 7776.5500 | 5.8000 | ["7750"] | ["0.1664"] | ["7147.08","8955.85"] | ["XCBO"] | 7750.0000 | 7750.0000 | 268 | 268 | false | false | false | false | |||||||||
| 01a0c597-429f-7650-87f1-1351ede00d47 | SPX | 2026-09-21 16:10 | strip | 2 | 1 | 16 | 496400.00 | unknown | bid | 7764.7000 | 2.0000 | ["7830"] | ["0.1374"] | ["7727.25"] | ["XCBO"] | 7830.0000 | 7830.0000 | 88 | 88 | false | false | false | false | |||||||||
| 01a0c529-9c4f-7c43-b334-4176f73bab79 | SPX | 2026-09-21 14:10 | strip | 2 | 1 | 126 | 3912300.00 | unknown | bid | 7763.1500 | 1.7000 | ["7830"] | ["0.1374"] | ["7726.50"] | ["XCBO"] | 7830.0000 | 7830.0000 | 88 | 88 | false | false | false | false | |||||||||
| 01a0c514-187e-7333-8534-0ce6b686dec9 | SPX | 2026-09-21 13:47 | strip | 2 | 1 | 108 | 3339900.00 | unknown | bid | 7761.4000 | 1.9000 | ["7825"] | ["0.1373"] | ["7723.25"] | ["XCBO"] | 7825.0000 | 7825.0000 | 88 | 88 | false | false | false | false | |||||||||
| 01a0c4da-6adf-73a3-86e3-37c71c318706 | SPX | 2026-09-21 12:44 | strip | 2 | 1 | 4 | 35290.00 | unknown | bid | 7751.6700 | 4.7000 | ["7690"] | ["0.1208"] | ["7601.78","7866.45"] | ["XCBO"] | 7690.0000 | 7690.0000 | 11 | 11 | false | false | false | false | |||||||||
| 01a0c4da-6adf-73a3-86e3-37bb9637076c | SPX | 2026-09-21 12:44 | strip | 2 | 1 | 4 | 45970.00 | unknown | bid | 7751.6700 | 1.1000 | ["7680"] | ["0.1231"] | ["7565.08","7909.85"] | ["XCBO"] | 7680.0000 | 7680.0000 | 18 | 18 | false | false | false | false | |||||||||
| 01a0c4cc-323f-7aa3-b05f-bd4eff5b5a94 | SPX | 2026-09-21 12:28 | strip | 2 | 1 | 10 | 149600.00 | unknown | bid | 7750.3700 | 4.1000 | ["7615"] | ["0.1352"] | ["7465.40","7914.20"] | ["XCBO"] | 7615.0000 | 7615.0000 | 25 | 25 | false | false | false | false | |||||||||
| 01a0c4cb-95ff-7b30-b737-7fdbfc5358be | SPX | 2026-09-21 12:27 | strip | 2 | 1 | 4 | 45930.00 | unknown | bid | 7750.0100 | 0.8000 | ["7680"] | ["0.1230"] | ["7565.18","7909.65"] | ["XCBO"] | 7680.0000 | 7680.0000 | 18 | 18 | false | false | false | false | |||||||||
| 01a0c4c8-d2f7-79d1-bfb9-cede6bdce063 | SPX | 2026-09-21 12:24 | strip | 2 | 1 | 4 | 55980.00 | unknown | bid | 7746.4500 | 2.6000 | ["7660"] | ["0.1274"] | ["7520.05","7939.90"] | ["XCBO"] | 7660.0000 | 7660.0000 | 25 | 25 | false | false | false | false | |||||||||
| 01a0c4c4-23be-76c2-ab4b-aa9de3d5dd6b | SPX | 2026-09-21 12:19 | strip | 2 | 1 | 4 | 97770.00 | unknown | bid | 7746.5700 | 1.6000 | ["7640"] | ["0.1437"] | ["7395.58","8128.85"] | ["XCBO"] | 7640.0000 | 7640.0000 | 60 | 60 | false | false | false | false | |||||||||
| 01a0c4a6-52ef-7ba3-992b-7256a40ba6aa | SPX | 2026-09-21 11:47 | strip | 2 | 1 | 4 | 36020.00 | unknown | bid | 7740.1400 | 3.7000 | ["7660"] | ["0.1228"] | ["7569.95","7840.10"] | ["XCBO"] | 7660.0000 | 7660.0000 | 11 | 11 | false | false | false | false | |||||||||
| 01a0c49e-e497-7180-b046-3d11f4004a37 | SPX | 2026-09-21 11:39 | strip | 2 | 2 | 400 | 9657000.00 | unknown | bid | 7733.6200 | 1.3000 | ["7650"] | ["0.1413"] | ["7661.09"] | ["XCBO"] | 7650.0000 | 7650.0000 | 60 | 60 | false | false | false | false | |||||||||
| 01a0b616-d38f-76e1-9f5a-fe9984ccb4dd | SPX | 2026-09-18 15:55 | strip | 2 | 1 | 42 | 1305150.00 | unknown | bid | 7648.5000 | 1.9000 | ["7710"] | ["0.1382"] | ["7607.75"] | ["XCBO"] | 7710.0000 | 7710.0000 | 91 | 91 | false | false | false | false | |||||||||
| 01a0b5fe-84e7-7c11-a9f5-42e649a56cd1 | SPX | 2026-09-18 15:29 | strip | 2 | 1 | 4 | 54590.00 | unknown | bid | 7640.4400 | 5.6000 | ["7430"] | ["0.1464"] | ["7293.52","7702.95"] | ["XCBO"] | 7430.0000 | 7430.0000 | 14 | 14 | false | false | false | false | |||||||||
| 01a0b534-d417-7660-9666-0357598debc3 | SPX | 2026-09-18 11:48 | strip | 2 | 1 | 76 | 2406920.00 | unknown | bid | 7621.7400 | 1.4000 | ["7685"] | ["0.1411"] | ["7580.10"] | ["XCBO"] | 7685.0000 | 7685.0000 | 91 | 91 | false | false | false | false | |||||||||
| 01a0b505-1957-7bc1-b826-71e0e21e045f | SPX | 2026-09-18 10:56 | strip | 2 | 2 | 250 | 24660000.00 | unknown | bid | 7628.4100 | 7.2000 | ["7600"] | ["0.1870"] | ["7687.20"] | ["XCBO"] | 7600.0000 | 7600.0000 | 637 | 637 | false | false | false | false |
| cbmo |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T15:30:24Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T20:00:47Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:53:53Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:46:27Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:28:44Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| cbmo |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:41:06Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| cbmo |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:41:23Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:48:17Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:48:17Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:48:17Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:48:17Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:48:17Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| cbmo |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T20:11:56Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| cbmo |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:10:41Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| cbmo |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:47:08Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:44:23Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:44:23Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:28:36Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:28:06Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:25:01Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:19:50Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:47:22Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:39:03Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| cbmo |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:55:48Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:29:23Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:48:57Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:56:45Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |