core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
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 |
|---|
| 01a0b0ee-ca23-71e3-8498-3384d7fddd1d | SPX | 2026-09-17 15:53 | strap | 2 | 1 | 4 | 35870.00 | unknown | — | 7646.6900 | 5.5000 | ["7765"] | ["0.1028"] | [] | ["XCBO"] | 7765.0000 | 7765.0000 | 15 | 15 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:54:01Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0ee-fcea-7c62-b46e-3ec3624bc53a | SPX | 2026-09-17 15:54 | strap | 2 | 1 | 4 | 36040.00 | unknown | — | 7646.1200 | 4.9000 | ["7770"] | ["0.1024"] | [] | ["XCBO"] | 7770.0000 | 7770.0000 | 15 | 15 | false | false | false | false | true | mlet | |||||||
| 01a0b0ef-4b0b-7ce0-9e77-9e6316a75895 | SPX | 2026-09-17 15:54 | strap | 2 | 1 | 4 | 36100.00 | unknown | — | 7646.6800 | 0.8000 | ["7730"] | ["0.1063"] | [] | ["XCBO"] | 7730.0000 | 7730.0000 | 15 | 15 | false | false | false | false | true | mlet | |||||||
| 01a0b4ba-e157-72b2-bf51-ff9ee1eaa3fa | META | 2026-09-18 09:35 | strap | 2 | 2 | 30 | 33750.00 | long | ask | 678.7899 | 0.9500 | ["685"] | ["0.3307"] | ["662.50","696.25"] | ["XPHO"] | 685.0000 | 685.0000 | 3 | 3 | false | false | false | false | true | ||||||||
| 01a0b4e1-224f-7f92-8d2e-592db1df8700 | SPX | 2026-09-18 10:17 | strap | 2 | 1 | 20 | 259650.00 | unknown | bid | 7619.1600 | 1.0000 | ["7760"] | ["0.1117"] | ["7500.35","7889.82"] | ["XCBO"] | 7760.0000 | 7760.0000 | 28 | 28 | false | false | false | false | true | ||||||||
| 01a0b4e1-2e07-77d0-8ff6-0765aa043db7 | SPX | 2026-09-18 10:17 | strap | 2 | 1 | 20 | 259700.00 | long | ask | 7620.0800 | 2.9000 | ["7760"] | ["0.1118"] | ["7500.30","7889.85"] | ["XCBO"] | 7760.0000 | 7760.0000 | 28 | 28 | false | false | false | false | true | ||||||||
| 01a0b4e1-35d8-7c93-96bc-a1e697ceeb67 | SPX | 2026-09-18 10:17 | strap | 2 | 1 | 12 | 155820.00 | long | ask | 7620.9100 | 2.8000 | ["7760"] | ["0.1118"] | ["7500.30","7889.85"] | ["XCBO"] | 7760.0000 | 7760.0000 | 28 | 28 | false | false | false | false | true | ||||||||
| 01a0b61f-2c47-7681-85ff-a3f9fe45ae6f | SPX | 2026-09-18 16:04 | strap | 2 | 1 | 12 | 32400.00 | long | ask | 7650.5000 | 0.3917 | ["7655"] | ["0.0662"] | ["7601","7682.00"] | ["XCBO"] | 7655.0000 | 7655.0000 | 3 | 3 | false | false | false | false | true | ||||||||
| 01a0c4e2-795e-75d0-bf03-e8786e4a100f | META | 2026-09-21 12:52 | strap | 2 | 8 | 14 | 33873.00 | long | ask | 728.6550 | 0.3500 | ["750"] | ["0.5729"] | ["701.61","774.20"] | ["AMXO","ARCO","C2OX","EDGO","XCBO","XISX","XPHO"] | 750.0000 | 750.0000 | 4 | 4 | false | false | false | false | true | ||||||||
| 01a0c4e5-963e-71f2-87bb-2deeffe816ca | AMZN | 2026-09-21 12:56 | strap | 2 | 2 | 12 | 104805.00 | unknown | ask | 257.8200 | 4.0500 | ["330"] | ["0.3856"] | ["328.30"] | ["AMXO","XISX"] | 330.0000 | 330.0000 | 816 | 816 | false | false | false | false | true | ||||||||
| 01a0c587-c1de-7201-a736-46811cc41ef7 | SPX | 2026-09-21 15:53 | strap | 2 | 1 | 4 | 41310.00 | long | ask | 7768.8400 | 5.4000 | ["7920"] | ["0.1038"] | ["7713.45","8023.28"] | ["XCBO"] | 7920.0000 | 7920.0000 | 18 | 18 | false | false | false | false | true | ||||||||
| 01a0c589-9a87-77d2-ac6e-a042ef92a878 | SPX | 2026-09-21 15:55 | strap | 2 | 1 | 4 | 41630.00 | long | ask | 7767.2800 | 10.0000 | ["7925"] | ["0.1033"] | ["7716.85","8029.08"] | ["XCBO"] | 7925.0000 | 7925.0000 | 18 | 18 | false | false | false | false | true | ||||||||
| 01a0c589-ec8e-7952-a7f5-ca13358e7f0f | SPX | 2026-09-21 15:55 | strap | 2 | 1 | 4 | 86400.00 | unknown | bid | 7768.2600 | 2.4000 | ["8100"] | ["0.1185"] | ["7668","8316.00"] | ["XCBO"] | 8100.0000 | 8100.0000 | 60 | 60 | false | false | false | false | true | ||||||||
| 01a0c58a-2727-7d72-9ee3-6d021c90d5a6 | SPX | 2026-09-21 15:55 | strap | 2 | 1 | 4 | 41580.00 | long | ask | 7767.9100 | 4.7000 | ["7925"] | ["0.1033"] | ["7717.10","8028.95"] | ["XCBO"] | 7925.0000 | 7925.0000 | 18 | 18 | false | false | false | false | true | ||||||||
| 01a0c58a-fdff-74f0-aea4-02695d91c977 | SPX | 2026-09-21 15:56 | strap | 2 | 1 | 4 | 33300.00 | unknown | — | 7767.6600 | 5.1000 | ["7900"] | ["0.1027"] | [] | ["XCBO"] | 7900.0000 | 7900.0000 | 11 | 11 | false | false | false | false | true | mlet | |||||||
| 01a0c594-9ed7-7e80-a8dc-1614fbd18711 | SPX | 2026-09-21 16:07 | strap | 2 | 2 | 12 | 29520.00 | long | ask | 7764.7000 | 0.4000 | ["7765"] | ["0.1006"] | ["7715.80","7789.60"] | ["XCBO"] | 7765.0000 | 7765.0000 | 1 | 1 | false | false | false | false | true | ||||||||
| 01a0c968-1cd7-7da0-ae17-8efbbb615d20 | QQQ | 2026-09-22 09:57 | strap | 2 | 1 | 104 | 64844.00 | long | ask | 744.7200 | 0.0800 | ["750"] | ["0.1687"] | ["737.53","756.24"] | ["XCBO"] | 750.0000 | 750.0000 | 3 | 3 | false | false | false | false | true | ||||||||
| 01a0c968-1cd7-7da0-ae17-8f12397013d8 | QQQ | 2026-09-22 09:57 | strap | 2 | 3 | 1888 | 1179003.00 | long | ask | 744.6350 | 0.0800 | ["750"] | ["0.1690"] | ["737.51","756.24"] | ["XCBO"] | 750.0000 | 750.0000 | 3 | 3 | false | false | false | false | true | ||||||||
| 01a0c968-1cd7-7da0-ae17-8f0fd593a32c | QQQ | 2026-09-22 09:57 | strap | 2 | 2 | 440 | 274502.00 | long | ask | 744.6350 | 0.0800 | ["750"] | ["0.1688"] | ["737.52","756.24"] | ["XCBO"] | 750.0000 | 750.0000 | 3 | 3 | false | false | false | false | true | ||||||||
| 01a0c99c-3c97-7e83-883f-5b31d0d5b45f | NDX | 2026-09-22 10:54 | strap | 2 | 1 | 2 | 31989.00 | long | ask | 0.0000 | 12.7000 | ["30650"] | ["0.1530"] | ["30330.11","30809.94"] | ["XISX"] | 30650.0000 | 30650.0000 | 1 | 1 | false | false | false | false | true | ||||||||
| 01a0c99c-3c97-7e83-883f-5b2818f280d1 | NDX | 2026-09-22 10:54 | strap | 2 | 1 | 2 | 31882.00 | long | ask | 0.0000 | 12.7000 | ["30650"] | ["0.1530"] | ["30331.18","30809.41"] | ["XISX"] | 30650.0000 | 30650.0000 | 1 | 1 | false | false | false | false | true | ||||||||
| 01a0c99c-3c97-7e83-883f-5b6796a471c3 | NDX | 2026-09-22 10:54 | strap | 2 | 1 | 2 | 31995.00 | long | ask | 0.0000 | 12.5000 | ["30650"] | ["0.1530"] | ["30330.05","30809.98"] | ["XISX"] | 30650.0000 | 30650.0000 | 1 | 1 | false | false | false | false | true | ||||||||
| 01a0c99c-3c97-7e83-883f-5b5236a8e400 | NDX | 2026-09-22 10:54 | strap | 2 | 1 | 2 | 31992.00 | long | ask | 0.0000 | 12.5000 | ["30650"] | ["0.1530"] | ["30330.08","30809.96"] | ["XISX"] | 30650.0000 | 30650.0000 | 1 | 1 | false | false | false | false | true | ||||||||
| 01a0c99c-3c97-7e83-883f-5b4d2805be28 | NDX | 2026-09-22 10:54 | strap | 2 | 1 | 2 | 31992.00 | long | ask | 0.0000 | 12.7000 | ["30650"] | ["0.1530"] | ["30330.08","30809.96"] | ["XISX"] | 30650.0000 | 30650.0000 | 1 | 1 | false | false | false | false | true | ||||||||
| 01a0c9cf-4ecf-79f3-969a-3a0c9d6d175f | SPX | 2026-09-22 11:49 | strap | 2 | 1 | 4 | 45860.00 | long | ask | 7760.1100 | 1.3000 | ["7855"] | ["0.1048"] | ["7625.70","7969.65"] | ["XCBO"] | 7855.0000 | 7855.0000 | 24 | 24 | false | false | false | false | true | ||||||||
| 01a0ca1a-abc6-7753-b745-42436ec58cf8 | SPX | 2026-09-22 13:12 | strap | 2 | 1 | 2 | 28400.00 | unknown | bid | 7763.4300 | 3.0000 | ["7630"] | ["0.1436"] | ["7346","7772.00"] | ["XCBO"] | 7630.0000 | 7630.0000 | 3 | 3 | false | false | false | false | true | ||||||||
| 01a0cab9-222f-78d2-8dcb-1164f5e374e8 | SPX | 2026-09-22 16:05 | strap | 2 | 1 | 20 | 46200.00 | long | ask | 7764.6400 | 0.3500 | ["7765"] | ["0.0945"] | ["7718.80","7788.10"] | ["XCBO"] | 7765.0000 | 7765.0000 | 1 | 1 | false | false | false | false | true |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:54:18Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:54:40Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:35:51Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:17:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:17:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:17:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T20:06:22Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:53:22Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:56:51Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:53:22Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:55:25Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:55:46Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:56:07Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:57:12Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T20:09:30Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:57:37Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:57:37Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:57:37Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:54:40Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:54:40Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:54:40Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:54:40Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:54:40Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:50:21Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:12:39Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T20:06:56Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |