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 |
|---|
| 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 |
|---|
| 01a0c967-0397-7422-a8a8-0445ed3bf7ef | SPY | 2026-09-22 09:56 | jade_lizard | 3 | 1 | 9 | 79380.00 | short | bid | 773.9700 | 0.5200 | ["580","750","760"] | ["0.3101","0.1564","0.1498"] | ["570.58","759.42"] | ["XCBO"] | 580.0000 | 760.0000 | 115 | 115 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T13:56:14Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0b5f1-2ed7-7b52-becb-dc1239def886 | SPY | 2026-09-18 15:14 | jade_lizard | 3 | 1 | 2 | 25422.00 | short | bid | 761.1000 | 0.5300 | ["625","770","790"] | ["0.2404","0.1677","0.1598"] | ["599.45"] | ["XCBO"] | 625.0000 | 790.0000 | 364 | 364 | false | true | false | true | |||||||||
| 01a0b4f6-5417-7473-846f-10d817431e1d | SPY | 2026-09-18 10:40 | jade_lizard | 3 | 2 | 39 | 47238.00 | long | bid | 759.4290 | 0.0900 | ["735","750","785"] | ["0.1586","0.1382","0.1035"] | ["745.58","789.42"] | ["XCBO","XPHO"] | 735.0000 | 785.0000 | 28 | 28 | false | true | false | true | |||||||||
| 01a0b4ce-7ce0-7ed2-8f5f-e2729d2e6dce | SPY | 2026-09-18 09:57 | jade_lizard | 3 | 3 | 45 | 41168.00 | long | bid | 759.9400 | 0.0500 | ["725","745","790"] | ["0.1731","0.1451","0.1025"] | ["741.28","793.72"] | ["EDGO","XCBO","XISX"] | 725.0000 | 790.0000 | 28 | 28 | false | true | false | true | |||||||||
| 01a0b4ce-7ce0-7ed2-8f5f-e24ddbe0483e | SPY | 2026-09-18 09:57 | jade_lizard | 3 | 2 | 30 | 27480.00 | long | bid | 759.9400 | 0.0500 | ["725","745","790"] | ["0.1732","0.1451","0.1025"] | ["741.28","793.72"] | ["XPHO"] | 725.0000 | 790.0000 | 28 | 28 | false | true | false | true | |||||||||
| 01a0b4c6-08d0-71a1-b57a-faf1868551b2 | SPY | 2026-09-18 09:47 | jade_lizard | 3 | 4 | 49 | 43550.00 | long | bid | 760.8000 | 0.0600 | ["725","745","790"] | ["0.1733","0.1451","0.1021"] | ["741.32","793.68"] | ["ARCO","EDGO","XCBO","XPHO"] | 725.0000 | 790.0000 | 28 | 28 | false | true | false | true | |||||||||
| 01a0b080-9733-7962-a423-860819153a94 | SPY | 2026-09-17 13:53 | jade_lizard | 3 | 1 | 7 | 72401.00 | short | bid | 762.3000 | 0.4900 | ["655","765","855"] | ["0.2216","0.1647","0.1356"] | ["592.69","827.31"] | ["XISX"] | 655.0000 | 855.0000 | 365 | 365 | false | true | false | true | |||||||||
| 01a0afce-c7ab-7850-b171-1051533b8f7e | SPY | 2026-09-17 10:39 | jade_lizard | 3 | 1 | 28 | 70924.00 | long | bid | 761.9600 | 0.1400 | ["720","750","800"] | ["0.1823","0.1557","0.1126"] | ["739.41","810.59"] | ["C2OX"] | 720.0000 | 800.0000 | 74 | 74 | false | true | false | true | |||||||||
| 01a0a564-45d6-7073-a31c-90a4015f45cd | SPY | 2026-09-15 10:06 | jade_lizard | 3 | 1 | 514 | 29298.00 | long | bid | 758.7450 | 0.0300 | ["750","757","772"] | ["0.2351","0.1518","0.2650"] | ["756.53","772.47"] | ["XISX"] | 750.0000 | 772.0000 | 0 | 0 | false | true | false | true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:14:50Z"} |
| 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-18T14:41:04Z"} |
| 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-18T13:57:16Z"} |
| 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-18T13:57:16Z"} |
| 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-18T13:47:53Z"} |
| 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 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:39:22Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:06:59Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |