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 |
|---|
| 01a0c9b9-78f6-71d2-9970-097cbb320aa6 | SPY | 2026-09-22 11:26 | call_calendar | 2 | 2 | 38 | 27968.00 | short | bid | 773.6500 | 0.0200 | ["775"] | ["0.1026"] | [] | ["EDGO"] | 775.0000 | 775.0000 | 3 | 10 | false | true | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:26:48Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c4d2-19f7-7a51-b08e-7b626a96136f | SPY | 2026-09-21 12:34 | call_calendar | 2 | 1 | 30 | 45780.00 | long | bid | 772.3900 | 0.0400 | ["776"] | ["0.1228"] | [] | ["XISX"] | 776.0000 | 776.0000 | 4 | 39 | false | true | true | false | |||||||||
| 01a0c4a8-e717-7d53-a822-c22c91c8dde7 | SPY | 2026-09-21 11:49 | call_calendar | 2 | 1 | 4 | 56032.00 | long | bid | 770.9650 | 2.6000 | ["760"] | ["0.1687"] | [] | ["XISX"] | 760.0000 | 760.0000 | 282 | 361 | false | false | true | false | |||||||||
| 01a0c46a-4fa7-7620-a4a0-8b4193909ac6 | SPY | 2026-09-21 10:41 | call_calendar | 2 | 1 | 99 | 27819.00 | long | ask | 769.2200 | 0.0200 | ["769"] | ["0.1063"] | [] | ["XISX"] | 769.0000 | 769.0000 | 0 | 1 | false | false | true | false | |||||||||
| 01a0b0bf-d2b3-7741-b98d-72dad296bad1 | SPY | 2026-09-17 15:02 | call_calendar | 2 | 1 | 200 | 53000.00 | long | bid | 762.7000 | 0.0200 | ["762"] | ["0.1149"] | [] | ["XISX"] | 762.0000 | 762.0000 | 0 | 1 | false | false | true | false | |||||||||
| 01a0afdc-c99b-7f30-9be4-bb4f41199d20 | SPY | 2026-09-17 10:54 | call_calendar | 2 | 1 | 18 | 113076.00 | short | bid | 760.6400 | 3.0500 | ["730"] | ["0.1427"] | [] | ["C2OX"] | 730.0000 | 730.0000 | 8 | 15 | false | false | true | false | |||||||||
| 01a0afc0-0a3b-7852-9d9c-00073f7212e2 | SPY | 2026-09-17 10:23 | call_calendar | 2 | 1 | 13 | 35659.00 | unknown | — | 761.8700 | 0.0900 | ["750"] | ["0.1258"] | [] | ["XISX"] | 750.0000 | 750.0000 | 1 | 15 | false | false | true | false | false | mesl | |||||||
| 01a0afbf-8d3b-7911-87c5-c2084514fd39 | SPY | 2026-09-17 10:22 | call_calendar | 2 | 2 | 15 | 41175.00 | short | bid | 761.8800 | 0.1687 | ["750"] | ["0.1259"] | [] | ["ARCO","EDGO"] | 750.0000 | 750.0000 | 1 | 15 | false | false | true | false | |||||||||
| 01a0abab-aec3-7502-9b79-f913feeb9ad0 | SPY | 2026-09-16 15:22 | call_calendar | 2 | 1 | 7 | 85316.00 | long | bid | 750.3500 | 5.0100 | ["700"] | ["0.2207"] | [] | ["MCRY"] | 700.0000 | 700.0000 | 14 | 121 | false | false | true | false | |||||||||
| 01a0a654-acce-7d40-af80-d190d52bb9e3 | SPY | 2026-09-15 14:29 | call_calendar | 2 | 1 | 5 | 67345.00 | long | bid | 757.6200 | 3.7400 | ["700"] | ["0.2183"] | [] | ["MCRY"] | 700.0000 | 700.0000 | 15 | 122 | false | false | true | false | |||||||||
| 01a0a648-c9d6-7612-a258-832c0290e10d | SPY | 2026-09-15 14:16 | call_calendar | 2 | 1 | 3 | 40329.00 | long | bid | 757.5500 | 3.0500 | ["700"] | ["0.2131"] | [] | ["XISX"] | 700.0000 | 700.0000 | 15 | 122 | false | false | true | false | |||||||||
| 01a091b5-ee38-7633-98ad-b6779c0a26fc | SPY | 2026-09-11 14:23 | call_calendar | 2 | 1 | 87 | 25839.00 | short | bid | 765.3850 | 0.0200 | ["765"] | ["0.0941"] | [] | ["XISX"] | 765.0000 | 765.0000 | 0 | 3 | false | false | true | false | |||||||||
| 01a08cc7-1528-7262-96c4-5e911f300ff9 | SPY | 2026-09-10 15:24 | call_calendar | 2 | 1 | 22 | 29260.00 | short | bid | 757.4500 | 0.1000 | ["820"] | ["0.1262"] | [] | ["ARCO"] | 820.0000 | 820.0000 | 99 | 169 | false | true | true | false | |||||||||
| 01a08731-1321-71a1-bb82-61ec869be27f | SPY | 2026-09-09 13:22 | call_calendar | 2 | 1 | 5 | 93850.00 | short | bid | 763.0100 | 4.1100 | ["670"] | ["0.5795"] | [] | ["XCBO"] | 670.0000 | 670.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0821c-04d0-7130-aed4-d0224ba6bfc6 | SPY | 2026-09-08 13:41 | call_calendar | 2 | 1 | 50 | 44300.00 | long | ask | 767.5100 | 0.0400 | ["768"] | ["0.1053"] | [] | ["C2OX"] | 768.0000 | 768.0000 | 1 | 17 | false | true | true | false | |||||||||
| 01a08140-3b31-7793-8e7a-ef5d5140af75 | SPY | 2026-09-08 09:41 | call_calendar | 2 | 1 | 40 | 151160.00 | short | bid | 767.6700 | 0.3710 | ["755"] | ["0.1346"] | [] | ["C2OX"] | 755.0000 | 755.0000 | 10 | 38 | false | false | true | false | |||||||||
| 01a06dab-85ad-7f00-a14b-238a327d2837 | SPY | 2026-09-04 14:25 | call_calendar | 2 | 1 | 76 | 69312.00 | long | ask | 769.8842 | 0.0200 | ["785"] | ["0.0975"] | [] | ["XISX"] | 785.0000 | 785.0000 | 7 | 56 | false | true | true | false | |||||||||
| 01a06da9-66b6-7f33-b889-eb535da77d79 | SPY | 2026-09-04 14:23 | call_calendar | 2 | 1 | 61 | 55632.00 | long | ask | 769.8800 | 0.0400 | ["785"] | ["0.0975"] | [] | ["XISX"] | 785.0000 | 785.0000 | 7 | 56 | false | true | true | false | |||||||||
| 01a06d80-4375-7040-b5b2-058b629f9365 | SPY | 2026-09-04 13:38 | call_calendar | 2 | 1 | 38 | 31616.00 | short | ask | 769.7150 | 0.0400 | ["770"] | ["0.0831"] | [] | ["XISX"] | 770.0000 | 770.0000 | 5 | 12 | false | true | true | false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:35:15Z"} |
| 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-21T15:50:12Z"} |
| 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:54Z"} |
| 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-17T19:03:06Z"} |
| 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-17T14:55:04Z"} |
| 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-17T14:23:15Z"} |
| 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-17T14:22:57Z"} |
| 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:22:38Z"} |
| 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-15T18:29:36Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:16:33Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:23:33Z"} |
| 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:24:22Z"} |
| 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-09T17:22:18Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:41:28Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:41:05Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:25:55Z"} |
| 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-04T18:24:11Z"} |
| 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-04T17:38:39Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |