Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | 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 |