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 | 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 |
|---|
| 01a0ca47-073f-73b2-8c4b-5fe43de8e51c | SPY | 2026-09-22 14:00 | synthetic | 2 | 1 | 26 | 28262.00 | short | bid | 774.0400 | 0.0400 | ["774"] | ["0.1062"] | ["775.05"] | ["ARCO"] | 774.0000 | 774.0000 | 10 | 10 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:00:58Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c968-72c7-70d3-adcd-c703810fd94d | SPY | 2026-09-22 09:57 | synthetic | 2 | 1 | 10 | 64750.00 | short | ask | 773.9700 | 0.0400 | ["790"] | ["0.1502"] | ["787.79"] | ["XISX"] | 790.0000 | 790.0000 | 178 | 178 | false | false | false | false | |||||||||
| 01a0c968-2c77-76d2-a0a9-9b3f53789a35 | SPY | 2026-09-22 09:57 | synthetic | 2 | 1 | 7 | 45325.00 | short | ask | 773.9500 | 0.0500 | ["790"] | ["0.1502"] | ["787.77"] | ["ARCO"] | 790.0000 | 790.0000 | 178 | 178 | false | false | false | false | |||||||||
| 01a0c967-bb2e-7062-bdb4-d2a3538ef0ca | SPY | 2026-09-22 09:56 | synthetic | 2 | 1 | 12 | 77700.00 | short | ask | 773.7500 | 0.0400 | ["790"] | ["0.1503"] | ["787.49"] | ["XISX"] | 790.0000 | 790.0000 | 178 | 178 | false | false | false | false | |||||||||
| 01a0c469-ea17-7450-a603-c4b5662fec95 | SPY | 2026-09-21 10:41 | synthetic | 2 | 1 | 39 | 31746.00 | long | bid | 769.2500 | 0.0200 | ["770"] | ["0.0957"] | ["769.74"] | ["XISX"] | 770.0000 | 770.0000 | 7 | 7 | false | false | false | false | |||||||||
| 01a0c469-cad7-7742-a61c-b94ede44ae1f | SPY | 2026-09-21 10:40 | synthetic | 2 | 1 | 36 | 29304.00 | long | bid | 769.2100 | 0.0200 | ["770"] | ["0.0957"] | ["769.72"] | ["XISX"] | 770.0000 | 770.0000 | 7 | 7 | false | false | false | false | |||||||||
| 01a0afa3-a4b4-7323-985e-2f42ad41dd16 | SPY | 2026-09-17 09:52 | synthetic | 2 | 1 | 93 | 399435.00 | short | ask | 761.3000 | 0.0300 | ["770"] | ["0.1408"] | ["766.55"] | ["XISX"] | 770.0000 | 770.0000 | 92 | 92 | false | false | false | false | |||||||||
| 01a0afa3-a4b4-7323-985e-2f312fdefbfd | SPY | 2026-09-17 09:52 | synthetic | 2 | 1 | 77 | 330715.00 | long | bid | 761.3000 | 0.0300 | ["770"] | ["0.1408"] | ["766.59"] | ["XISX"] | 770.0000 | 770.0000 | 92 | 92 | false | false | false | false | |||||||||
| 01a0abb9-4f0b-77a2-b155-4c6d36f930d7 | SPY | 2026-09-16 15:37 | synthetic | 2 | 2 | 67 | 43282.00 | short | ask | 751.5699 | 0.0200 | ["752"] | ["0.2056"] | ["751.62"] | ["XBOX","XISX"] | 752.0000 | 752.0000 | 1 | 1 | false | false | false | false | |||||||||
| 01a0abb2-a01b-7420-85e0-78936d07e449 | SPY | 2026-09-16 15:30 | synthetic | 2 | 1 | 25 | 26175.00 | short | ask | 751.1824 | 0.1900 | ["758"] | ["0.1981"] | ["749.63"] | ["XPHO"] | 758.0000 | 758.0000 | 2 | 2 | false | false | false | false | |||||||||
| 01a0ab9f-087b-7a40-bac4-96aa74c5a573 | SPY | 2026-09-16 15:08 | synthetic | 2 | 1 | 30 | 27000.00 | long | bid | 753.2500 | 0.0200 | ["755"] | ["0.2000"] | ["751.94"] | ["XISX"] | 755.0000 | 755.0000 | 2 | 2 | false | false | false | false | |||||||||
| 01a0ab9a-16db-7dd0-bb94-286278689378 | SPY | 2026-09-16 15:03 | synthetic | 2 | 2 | 41 | 35465.00 | long | bid | 754.5350 | 0.0500 | ["755"] | ["0.1933"] | ["753.33"] | ["XISX","XPHO"] | 755.0000 | 755.0000 | 2 | 2 | false | false | false | false | |||||||||
| 01a0ab2b-2c53-7352-b3fe-9254918f246b | SPY | 2026-09-16 13:02 | synthetic | 2 | 3 | 83 | 39923.00 | short | ask | 759.3950 | 0.0200 | ["760"] | ["0.4292"] | ["759.39"] | ["MCRY","XBOX","XISX"] | 760.0000 | 760.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0a69f-dae6-72f0-80de-bf2bf474a57f | SPY | 2026-09-15 15:51 | synthetic | 2 | 1 | 54 | 33534.00 | long | bid | 756.6850 | 0.0200 | ["757"] | ["0.1964"] | ["756.83"] | ["XISX"] | 757.0000 | 757.0000 | 1 | 1 | false | false | false | false | |||||||||
| 01a0a147-ffd0-7c53-9d7b-d5683b37ed5b | SPY | 2026-09-14 14:57 | synthetic | 2 | 1 | 28 | 128576.00 | short | bid | 762.3800 | 0.0200 | ["765"] | ["0.1495"] | ["768.02"] | ["XISX"] | 765.0000 | 765.0000 | 95 | 95 | false | false | false | false | |||||||||
| 01a0a08e-2d80-78a0-8c2a-eb3b6351109d | SPY | 2026-09-14 11:34 | synthetic | 2 | 1 | 2 | 36232.00 | short | bid | 760.6000 | 1.7600 | ["760"] | ["0.1978"] | ["820.78"] | ["XISX"] | 760.0000 | 760.0000 | 823 | 823 | false | false | false | false | |||||||||
| 01a091e7-c020-7492-a17d-8b9a6dbb702e | SPY | 2026-09-11 15:17 | synthetic | 2 | 1 | 20 | 26980.00 | short | bid | 765.0000 | 0.0600 | ["757"] | ["0.1368"] | ["764.57"] | ["XISX"] | 757.0000 | 757.0000 | 7 | 7 | false | false | false | false | |||||||||
| 01a08cce-a6a8-7803-8a7d-b05b106a6107 | SPY | 2026-09-10 15:32 | synthetic | 2 | 2 | 19 | 27170.00 | long | ask | 757.7000 | 0.0400 | ["757"] | ["0.1594"] | ["757.24"] | ["XISX","XPHO"] | 757.0000 | 757.0000 | 8 | 8 | false | false | false | false | |||||||||
| 01a08cce-a6a8-7803-8a7d-b0497e1d0dd4 | SPY | 2026-09-10 15:32 | synthetic | 2 | 3 | 34 | 48620.00 | long | ask | 757.6950 | 0.0456 | ["757"] | ["0.1594"] | ["757.23"] | ["ARCO","XISX","XPHO"] | 757.0000 | 757.0000 | 8 | 8 | false | false | false | false | |||||||||
| 01a08ccc-02e0-79a2-88c3-7451de479e7c | SPY | 2026-09-10 15:29 | synthetic | 2 | 2 | 23 | 33120.00 | long | ask | 757.6200 | 0.0300 | ["757"] | ["0.1606"] | ["757.16"] | ["XISX","XPHO"] | 757.0000 | 757.0000 | 8 | 8 | false | false | false | false | |||||||||
| 01a08b96-b348-7cd2-8c23-86716c9a916e | SPY | 2026-09-10 09:51 | synthetic | 2 | 1 | 2 | 33844.00 | long | ask | 757.6500 | 4.5500 | ["675"] | ["0.2096"] | ["789.52"] | ["XISX"] | 675.0000 | 675.0000 | 498 | 498 | false | false | false | false | |||||||||
| 01a06d45-c2e5-72a3-a695-0766efafbc34 | SPY | 2026-09-04 12:34 | synthetic | 2 | 1 | 40 | 32040.00 | short | bid | 770.9000 | 0.0200 | ["771"] | ["0.0940"] | ["771.29"] | ["XISX"] | 771.0000 | 771.0000 | 7 | 7 | false | false | false | false | |||||||||
| 01a06d42-6b6d-7ae0-9b8a-7c5569264d7a | SPY | 2026-09-04 12:31 | synthetic | 2 | 1 | 39 | 31239.00 | short | ask | 770.6050 | 0.0200 | ["771"] | ["0.0941"] | ["770.99"] | ["XISX"] | 771.0000 | 771.0000 | 7 | 7 | false | false | false | false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:57:59Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mesl |
| 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 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:56:55Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:41:09Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:41:09Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:52:24Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:52:24Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:37:35Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:30:12Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:08:39Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:03:36Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:02:17Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:51:56Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:57:43Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:34:40Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:18:02Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:32:55Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:32:55Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:29:58Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:51:42Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:34:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:31:08Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |