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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5ae-652f-7a33-b5e6-3f66f78fb932 | SHOP | 2026-09-18 14:01 | other | 4 | 5 | 82 | 223501.00 | unknown | ask | 127.2200 | 1.0268 | ["100","120","125","155"] | ["6.2947","1.9404","0.9096","5.1203"] | ["10.75","127.26"] | ["ARCO","XCBO","XISX","XPHO"] | 100.0000 | 155.0000 | 0 | 0 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:01:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab71-2e33-76e3-8ed2-90c6e3e4d221 | SHOP | 2026-09-16 14:18 | other | 4 | 1 | 20 | 126500.00 | unknown | — | 131.3100 | 9.2500 | ["140","145"] | ["0.5769","0.5720"] | [] | ["XCBO"] | 140.0000 | 145.0000 | 9 | 65 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:18:56Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a087b4-0e60-70f3-ac3f-8a6d7b7b3e38 | SHOP | 2026-09-09 15:45 | other | 2 | 1 | 50 | 104850.00 | unknown | — | 126.6900 | 1.2000 | ["125","134"] | ["0.6000","0.5509"] | [] | ["XPHO"] | 125.0000 | 134.0000 | 9 | 72 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:45:38Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08788-4758-7040-b502-c255b10ba372 | SHOP | 2026-09-09 14:57 | other | 2 | 1 | 120 | 1261660.00 | unknown | — | 127.3700 | 4.9500 | ["180"] | ["0.5598"] | [] | ["XMIO"] | 180.0000 | 180.0000 | 37 | 499 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:57:42Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08787-7850-7990-b13c-51ec3b6299f3 | SHOP | 2026-09-09 14:56 | other | 2 | 1 | 18 | 152350.00 | unknown | — | 127.4300 | 5.4000 | ["165","170"] | ["0.5864","0.8468"] | [] | ["XISX"] | 165.0000 | 170.0000 | 23 | 828 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:57:02Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0875c-64f8-7042-9d1a-213846c64c89 | SHOP | 2026-09-09 14:09 | other | 2 | 1 | 35 | 106165.00 | unknown | — | 127.9450 | 2.1500 | ["120","130"] | ["0.6000","0.5703"] | [] | ["ARCO"] | 120.0000 | 130.0000 | 72 | 100 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:10:04Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08752-eb30-74a0-93d9-6f4740347341 | SHOP | 2026-09-09 13:59 | other | 2 | 1 | 110 | 180760.00 | unknown | — | 127.8000 | 2.1000 | ["120","125"] | ["0.5149","0.5047"] | [] | ["XISX"] | 120.0000 | 125.0000 | 16 | 23 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:59:38Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0874e-3bf8-7171-bef2-33fc759c234f | SHOP | 2026-09-09 13:54 | other | 2 | 1 | 200 | 298080.00 | unknown | — | 127.8604 | 2.1000 | ["120","125"] | ["0.5554","0.5410"] | [] | ["XCBO"] | 120.0000 | 125.0000 | 9 | 16 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:54:34Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0872d-a820-7a11-91a6-0a3df4a26358 | SHOP | 2026-09-09 13:18 | other | 2 | 1 | 42 | 114612.00 | unknown | — | 129.4000 | 1.1000 | ["125","135"] | ["0.5704","0.5665"] | [] | ["XISX"] | 125.0000 | 135.0000 | 100 | 100 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:19:17Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086cc-2b18-78b3-ba24-f81b1307e9f8 | SHOP | 2026-09-09 11:31 | other | 2 | 1 | 40 | 109680.00 | unknown | — | 128.8200 | 2.5500 | ["125","130"] | ["0.5903","0.6076"] | [] | ["ARCO"] | 125.0000 | 130.0000 | 72 | 100 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:32:05Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0820c-9798-78c1-bf40-50357a196060 | SHOP | 2026-09-08 13:24 | other | 2 | 1 | 26 | 136500.00 | unknown | — | 134.8200 | 2.3000 | ["155","160"] | ["0.5464","0.8844"] | [] | ["BATO"] | 155.0000 | 160.0000 | 3 | 101 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:24:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08145-b1a0-7c81-9187-a486b4c34511 | SHOP | 2026-09-08 09:47 | other | 2 | 1 | 52 | 185940.00 | unknown | — | 136.4100 | 4.3500 | ["125","135"] | ["0.6167","0.5755"] | [] | ["XISX"] | 125.0000 | 135.0000 | 73 | 101 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:47:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dd2-ef85-7a73-bfcf-1d76d3419818 | SHOP | 2026-09-04 15:08 | other | 2 | 1 | 460 | 103730.00 | unknown | — | 145.2000 | 0.6300 | ["145","146"] | ["0.5337","0.4934"] | [] | ["EDGO"] | 145.0000 | 146.0000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:09:09Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d3b-a8f5-7232-81f7-a5ea9147c48c | SHOP | 2026-09-04 12:23 | other | 2 | 1 | 90 | 344582.00 | unknown | — | 147.6100 | 3.1000 | ["130","145"] | ["0.5699","0.5392"] | [] | ["XMIO"] | 130.0000 | 145.0000 | 77 | 105 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:23:43Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |