Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5a2-4f6f-7c90-8031-f5a9fbff68eb | SPY | 2026-09-18 13:48 | call_ratio_spread | 2 | 1 | 24 | 29880.00 | unknown | ask | 759.7500 | 0.0800 | ["758","770"] | ["0.1265","0.1128"] | ["774.30"] | ["XISX"] | 758.0000 | 770.0000 | 28 | 28 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:49:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b507-6347-7f53-a17b-038c4c51ddfb | SPY | 2026-09-18 10:59 | call_ratio_spread | 2 | 1 | 6 | 63378.00 | unknown | — | 759.7850 | 0.4300 | ["685","760"] | ["0.1991","0.1441"] | [] | ["EDGO"] | 685.0000 | 760.0000 | 119 | 119 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:59:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b506-7117-76f0-8dd1-f138b4280c05 | SPY | 2026-09-18 10:58 | call_ratio_spread | 2 | 1 | 10 | 105595.00 | unknown | ask | 759.8200 | 1.4600 | ["685","760"] | ["0.1986","0.1438"] | ["760.87"] | ["XCBO"] | 685.0000 | 760.0000 | 119 | 119 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:58:40Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b505-8e87-7133-b448-05dd4ef1f066 | SPY | 2026-09-18 10:57 | call_ratio_spread | 2 | 1 | 10 | 105590.00 | unknown | — | 759.6600 | 2.7200 | ["685","760"] | ["0.2001","0.1441"] | [] | ["EMLD"] | 685.0000 | 760.0000 | 119 | 119 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:57:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b090-2f62-7572-85ec-a4b2f933c22e | SPY | 2026-09-17 14:10 | call_ratio_spread | 2 | 1 | 7 | 192512.00 | unknown | — | 762.5300 | 6.0600 | ["500","525"] | ["3.7321","3.9770"] | [] | ["XCBO"] | 500.0000 | 525.0000 | 1 | 1 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:10:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b08b-ca63-7a71-9c23-c20fcf7eed60 | SPY | 2026-09-17 14:05 | call_ratio_spread | 2 | 1 | 2 | 30811.00 | unknown | — | 762.8100 | 2.6600 | ["680","735"] | ["0.2124","0.1838"] | [] | ["XISX"] | 680.0000 | 735.0000 | 273 | 273 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:05:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb9-e7eb-7482-af2e-d0798de45436 | SPY | 2026-09-17 10:16 | call_ratio_spread | 2 | 1 | 132 | 51348.00 | unknown | — | 761.2700 | 0.1500 | ["757","762"] | ["0.1121","0.1148"] | [] | ["XPHO"] | 757.0000 | 762.0000 | 1 | 1 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:16:41Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb8-c2f3-7330-b4de-e5f59469b4ea | SPY | 2026-09-17 10:15 | call_ratio_spread | 2 | 1 | 116 | 44428.00 | unknown | — | 761.2100 | 0.1700 | ["757","762"] | ["0.1111","0.1146"] | [] | ["XPHO"] | 757.0000 | 762.0000 | 1 | 1 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:15:14Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb7-fbbb-77b0-b10c-5e8aeebc31f0 | SPY | 2026-09-17 10:14 | call_ratio_spread | 2 | 1 | 3300 | 1237500.00 | unknown | — | 761.1100 | 0.0700 | ["757","762"] | ["0.1115","0.1148"] | [] | ["XCBO"] | 757.0000 | 762.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:14:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb1-c173-7001-b762-fa768a53b1eb | SPY | 2026-09-16 15:29 | call_ratio_spread | 2 | 1 | 11 | 46868.00 | unknown | — | 750.6700 | 1.8900 | ["735","750"] | ["0.1625","0.1487"] | [] | ["XISX"] | 735.0000 | 750.0000 | 65 | 65 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:29:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba8-95cb-7af2-8e08-4ba4d3f0ea5e | SPY | 2026-09-16 15:19 | call_ratio_spread | 2 | 1 | 30 | 32604.00 | unknown | — | 750.9900 | 0.1400 | ["764","770"] | ["0.1250","0.1193"] | [] | ["XMIO"] | 764.0000 | 770.0000 | 37 | 37 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:19:22Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba2-9a8b-78e0-b78c-2ed3f63e8d45 | SPY | 2026-09-16 15:12 | call_ratio_spread | 2 | 1 | 17 | 29551.00 | unknown | — | 751.7200 | 0.1400 | ["755","760"] | ["0.1329","0.1272"] | [] | ["EDGO"] | 755.0000 | 760.0000 | 30 | 30 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:12:39Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab37-0393-70d3-a501-71d834bdf4a5 | SPY | 2026-09-16 13:15 | call_ratio_spread | 2 | 1 | 12 | 63486.00 | unknown | — | 759.7350 | 0.3600 | ["730","760"] | ["0.1646","0.1389"] | [] | ["XISX"] | 730.0000 | 760.0000 | 65 | 65 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:15:38Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aac2-40f3-73d3-91c0-7b375b32db25 | SPY | 2026-09-16 11:07 | call_ratio_spread | 2 | 1 | 486 | 37584.00 | unknown | — | 760.4800 | 0.0200 | ["765","775"] | ["0.1587","0.1514"] | [] | ["C2OX"] | 765.0000 | 775.0000 | 2 | 2 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:07:50Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a69f-ee6e-7183-a1c5-f5430b6b5a5d | SPY | 2026-09-15 15:51 | call_ratio_spread | 2 | 1 | 100 | 97600.00 | unknown | — | 756.7300 | 0.0900 | ["764","774"] | ["0.1208","0.1110"] | [] | ["XISX"] | 764.0000 | 774.0000 | 24 | 24 | false | true | false | true | false | mlet | 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 |
| 01a0a651-93d6-7c22-9747-25c6f631cf14 | SPY | 2026-09-15 14:25 | call_ratio_spread | 2 | 1 | 10 | 50545.00 | unknown | — | 757.5100 | 0.4000 | ["770","810"] | ["0.1537","0.1384"] | [] | ["AMXO"] | 770.0000 | 810.0000 | 288 | 288 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:26:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a589-d706-7a42-ad37-d0ec354130c2 | SPY | 2026-09-15 10:47 | call_ratio_spread | 2 | 1 | 20 | 26070.00 | unknown | — | 757.1600 | 0.1200 | ["759","773"] | ["0.1302","0.1177"] | [] | ["AMXO"] | 759.0000 | 773.0000 | 38 | 38 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:48:07Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |