core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 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 |
|---|
| 01a0e851-b7a7-7e81-854d-899f40e3debb | SPY | 2026-09-28 10:01 | box_spread | 4 | 2 | 3 | 43002.00 | unknown | — | 768.2800 | 3.6500 | ["701","785"] | ["0.1943","0.1413"] | [] | ["ARCO","C2OX"] | 701.0000 | 785.0000 | 123 | 123 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-28T14:01:11Z"} | 2026-09-28 | 2026-09-28 17:15 | 2026-09-28 17:15 |
| 01a0e851-b3bf-7d52-bd00-0844529296f4 | SPY | 2026-09-28 10:01 | box_spread | 4 | 1 | 3 | 43002.00 | unknown | — | 768.2700 | 3.6400 | ["701","785"] | ["0.1943","0.1413"] | [] | ["EDGO"] | 701.0000 | 785.0000 | 123 | 123 | false | false | false | true | true | mlet | |||||||
| 01a0e838-0d57-7eb2-a037-2b63de2a3198 | SPY | 2026-09-28 09:32 | box_spread | 4 | 1 | 9 | 62433.00 | short | bid | 768.3400 | 0.3200 | ["772","776"] | ["0.1374","0.1347"] | [] | ["XPHO"] | 772.0000 | 776.0000 | 63 | 63 | false | false | false | true | |||||||||
| 01a0d3a4-42a7-7d72-bac8-537ded4baf1d | SPY | 2026-09-24 09:39 | box_spread | 4 | 1 | 4 | 79304.00 | unknown | — | 764.9700 | 3.4500 | ["690","730"] | ["0.2005","0.1769"] | [] | ["XISX"] | 690.0000 | 730.0000 | 188 | 188 | false | false | false | true | true | mlet | |||||||
| 01a0cf55-fb0f-7682-88be-7615eebdd997 | SPY | 2026-09-23 13:35 | box_spread | 4 | 1 | 5 | 33430.00 | unknown | — | 767.5150 | 0.1400 | ["770","775"] | ["0.1387","0.1348"] | [] | ["XCBO"] | 770.0000 | 775.0000 | 58 | 58 | false | false | false | true | true | mlat | |||||||
| 01a0ca99-49d7-7931-b37d-97df4fbc5991 | SPY | 2026-09-22 15:30 | box_spread | 4 | 1 | 5 | 63185.00 | unknown | — | 774.3400 | 2.2700 | ["725","775"] | ["0.1743","0.1438"] | [] | ["XCBO"] | 725.0000 | 775.0000 | 115 | 115 | false | false | false | true | true | mlat | |||||||
| 01a0ca67-396f-7900-8e4b-60dbe83a2f54 | SPY | 2026-09-22 14:35 | box_spread | 4 | 2 | 3 | 41700.00 | long | ask | 773.8657 | 2.1100 | ["710","810"] | ["0.1870","0.1340"] | [] | ["ARCO","EMLD"] | 710.0000 | 810.0000 | 115 | 115 | false | false | false | true | |||||||||
| 01a0ca4f-dcf7-7f32-9c63-60f77ef9d3ef | SPY | 2026-09-22 14:10 | box_spread | 4 | 1 | 3 | 41706.00 | long | ask | 774.0800 | 2.3200 | ["710","810"] | ["0.1865","0.1341"] | [] | ["XMIO"] | 710.0000 | 810.0000 | 115 | 115 | false | false | false | true | |||||||||
| 01a0ca4f-d13f-7ad1-84af-7c0ca7ad3382 | SPY | 2026-09-22 14:10 | box_spread | 4 | 2 | 3 | 41706.00 | long | ask | 774.0900 | 2.2400 | ["710","810"] | ["0.1866","0.1340"] | [] | ["EMLD","XMIO"] | 710.0000 | 810.0000 | 115 | 115 | false | false | false | true | |||||||||
| 01a0c988-2bdf-7eb2-a8cb-625990b92765 | SPY | 2026-09-22 10:32 | box_spread | 4 | 1 | 3 | 62205.00 | unknown | — | 773.9000 | 0.7100 | ["800","805"] | ["0.1704","0.1690"] | [] | ["EDGO"] | 800.0000 | 805.0000 | 360 | 360 | false | false | false | true | true | mlet | |||||||
| 01a0c48d-5c4e-7e61-8eef-c1328eac7ea9 | SPY | 2026-09-21 11:19 | box_spread | 4 | 1 | 7 | 49504.00 | unknown | — | 770.1700 | 0.3700 | ["765","770"] | ["0.1421","0.1383"] | [] | ["XISX"] | 765.0000 | 770.0000 | 60 | 60 | false | false | false | true | true | mlet | |||||||
| 01a0b5e7-d837-7ac0-b93f-ba0fd2cd5e51 | SPY | 2026-09-18 15:04 | box_spread | 4 | 1 | 3 | 27429.00 | short | bid | 761.3450 | 0.7200 | ["735","795"] | ["0.1617","0.1240"] | [] | ["EMLD"] | 735.0000 | 795.0000 | 73 | 73 | false | false | false | true | |||||||||
| 01a0b5e7-d837-7ac0-b93f-b9f5349c0c7c | SPY | 2026-09-18 15:04 | box_spread | 4 | 3 | 7 | 63975.00 | short | bid | 761.3450 | 0.7200 | ["735","795"] | ["0.1618","0.1237"] | [] | ["ARCO","EMLD","XMIO"] | 735.0000 | 795.0000 | 73 | 73 | false | false | false | ||||||||||
| 01a0b5e6-651f-7711-8c6c-14092417d4f4 | SPY | 2026-09-18 15:02 | box_spread | 4 | 2 | 9 | 82317.00 | short | bid | 761.1800 | 0.4133 | ["735","795"] | ["0.1620","0.1238"] | [] | ["ARCO","EMLD"] | 735.0000 | 795.0000 | 73 | 73 | false | false | false | true | |||||||||
| 01a0b080-be43-7e73-8e5a-e5ea95ea4827 | SPY | 2026-09-17 13:53 | box_spread | 4 | 1 | 3 | 64860.00 | short | bid | 762.3050 | 3.6400 | ["755","775"] | ["0.1748","0.1676"] | [] | ["XMIO"] | 755.0000 | 775.0000 | 365 | 365 | false | false | false | true | |||||||||
| 01a0afe4-b8db-7000-9519-7678248feae9 | SPY | 2026-09-17 11:03 | box_spread | 4 | 2 | 4 | 53472.00 | short | bid | 760.8000 | 1.9300 | ["705","790"] | ["0.1850","0.1354"] | [] | ["EMLD","XMIO"] | 705.0000 | 790.0000 | 120 | 120 | false | false | false | true | |||||||||
| 01a0afe4-b8db-7000-9519-76696aa807f1 | SPY | 2026-09-17 11:03 | box_spread | 4 | 2 | 5 | 66840.00 | short | bid | 760.8000 | 1.9300 | ["705","790"] | ["0.1850","0.1354"] | [] | ["EMLD","XMIO"] | 705.0000 | 790.0000 | 120 | 120 | false | false | false | true | |||||||||
| 01a0afdc-6bdb-7543-b35a-8b13acdcc888 | SPY | 2026-09-17 10:54 | box_spread | 4 | 1 | 3 | 43422.00 | short | bid | 760.6900 | 3.4500 | ["720","800"] | ["0.1780","0.1439"] | [] | ["ARCO"] | 720.0000 | 800.0000 | 162 | 162 | false | false | false | true | |||||||||
| 01a0afd1-b993-7c40-b2c8-a1e832251597 | SPY | 2026-09-17 10:42 | box_spread | 4 | 1 | 5 | 78295.00 | long | ask | 762.2100 | 2.1500 | ["700","792"] | ["0.1896","0.1443"] | [] | ["EMLD"] | 700.0000 | 792.0000 | 162 | 162 | false | false | false | true | |||||||||
| 01a0afd1-a60b-7113-b2b8-2ec2e27ee756 | SPY | 2026-09-17 10:42 | box_spread | 4 | 2 | 4 | 62656.00 | long | ask | 762.1500 | 1.9700 | ["700","792"] | ["0.1903","0.1440"] | [] | ["ARCO","EMLD"] | 700.0000 | 792.0000 | 162 | 162 | false | false | false | true | |||||||||
| 01a0afb9-14fc-74b0-8c1a-0875c30a7267 | SPY | 2026-09-17 10:15 | box_spread | 4 | 1 | 4 | 62376.00 | long | ask | 761.1200 | 2.5600 | ["700","792"] | ["0.1890","0.1444"] | [] | ["EMLD"] | 700.0000 | 792.0000 | 162 | 162 | false | false | false | true | |||||||||
| 01a0afb9-055b-7841-9353-5fb62859d7c5 | SPY | 2026-09-17 10:15 | box_spread | 4 | 2 | 5 | 77980.00 | long | ask | 761.1800 | 2.6800 | ["700","792"] | ["0.1888","0.1445"] | [] | ["EMLD","XMIO"] | 700.0000 | 792.0000 | 162 | 162 | false | false | false | true | |||||||||
| 01a0aa7e-98a3-75d0-b230-3abf6a56476f | SPY | 2026-09-16 09:53 | box_spread | 4 | 1 | 2 | 43004.00 | unknown | — | 760.0800 | 8.1500 | ["755","775"] | ["0.1780","0.1736"] | [] | ["XISX"] | 755.0000 | 775.0000 | 366 | 366 | false | false | false | true | true | mlet | |||||||
| 01a0a5a6-86c6-7093-a7ed-3194377660a9 | SPY | 2026-09-15 11:19 | box_spread | 4 | 2 | 4 | 59166.00 | long | ask | 757.3200 | 2.4900 | ["715","769"] | ["0.1828","0.1526"] | [] | ["ARCO","EMLD"] | 715.0000 | 769.0000 | 164 | 164 | false | false | false | true | |||||||||
| 01a0a593-ae8e-78f3-89e3-a35be5b7c7dc | SPY | 2026-09-15 10:58 | box_spread | 4 | 2 | 4 | 58900.00 | long | ask | 756.6400 | 2.5100 | ["715","769"] | ["0.1823","0.1524"] | [] | ["EMLD","XMIO"] | 715.0000 | 769.0000 | 164 | 164 | false | false | false | true | |||||||||
| 01a0a55c-1bfe-75b3-93f0-c47d531b93dd | SPY | 2026-09-15 09:57 | box_spread | 4 | 1 | 3 | 28662.00 | long | ask | 759.5000 | 2.1200 | ["735","795"] | ["0.1657","0.1320"] | [] | ["EMLD"] | 735.0000 | 795.0000 | 76 | 76 | false | false | false | true | |||||||||
| 01a091cc-25b8-7b20-a896-772a67e76dfc | SPY | 2026-09-11 14:47 | box_spread | 4 | 1 | 6 | 58164.00 | short | bid | 765.2400 | 0.3100 | ["735","795"] | ["0.1647","0.1297"] | [] | ["SPHR"] | 735.0000 | 795.0000 | 80 | 80 | false | false | false | true | |||||||||
| 01a091cc-25b8-7b20-a896-77124aa331a7 | SPY | 2026-09-11 14:47 | box_spread | 4 | 2 | 9 | 87362.00 | short | bid | 765.2400 | 0.5778 | ["735","795"] | ["0.1656","0.1294"] | [] | ["ARCO","EMLD"] | 735.0000 | 795.0000 | 80 | 80 | false | false | false | true | |||||||||
| 01a08cb3-1fc8-7cf2-8a00-f0c36f2613d0 | SPY | 2026-09-10 15:02 | box_spread | 4 | 1 | 18 | 42174.00 | unknown | — | 757.5400 | 0.4300 | ["765","770"] | ["0.1190","0.1117"] | [] | ["ARCO"] | 765.0000 | 770.0000 | 5 | 5 | false | false | false | true | true | mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:01:11Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T13:33:08Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:39:34Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:35:42Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:31:16Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:36:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:11:06Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:10:24Z"} |
| 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:32:30Z"} |
| 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-21T15:19:56Z"} |
| 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-18T19:04:25Z"} |
| 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-18T19:04:25Z"} |
| 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-18T19:02:57Z"} |
| 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-17T17:54:04Z"} |
| 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-17T15:03: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-17T15:03:22Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:54:34Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:42:50Z"} |
| 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:42:26Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:15:36Z"} |
| 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:15:36Z"} |
| 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-16T13:53:45Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:19:09Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:59:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:57:53Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:48:11Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:48:11Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:02:56Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |