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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 01a0b59c-ae07-7720-9c2a-03d3437a30bb | SHOP | 2026-09-18 13:42 | call_diagonal_spread | 2 | 1 | 10 | 104250.00 | unknown | bid | 127.2911 | 4.3000 | ["75","80"] | ["16.7892","0.6052"] | [] | ["ARCO"] | 75.0000 | 80.0000 | 0 | 182 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:42:21Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b02e-be13-7ed1-b884-fecc76c1eec9 | SHOP | 2026-09-17 12:24 | call_vertical_spread | 2 | 1 | 35 | 126490.00 | unknown | — | 128.2600 | 1.4500 | ["120","160"] | ["0.5711","0.5515"] | [] | ["BATO"] | 120.0000 | 160.0000 | 183 | 183 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:24:25Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abc6-1c63-7d70-9f19-e174e3f1c222 | SHOP | 2026-09-16 15:51 | call_vertical_spread | 2 | 1 | 50 | 328300.00 | unknown | — | 129.8450 | 4.2000 | ["95","100"] | ["0.7378","0.4382"] | [] | ["XMIO"] | 95.0000 | 100.0000 | 37 | 37 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:51:39Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abc2-6b13-7ea3-add3-5433155aea18 | SHOP | 2026-09-16 15:47 | put_vertical_spread | 2 | 1 | 40 | 108160.00 | unknown | — | 129.5600 | 4.3000 | ["140","145"] | ["0.9543","1.1804"] | [] | ["XISX"] | 140.0000 | 145.0000 | 2 | 2 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:47:23Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 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 |
| 01a0ab61-0193-7c71-bdab-d0932ab6e471 | SHOP | 2026-09-16 14:00 | call_calendar | 2 | 2 | 56 | 180068.00 | unknown | — | 130.6450 | 5.9000 | ["120"] | ["0.6584"] | [] | ["ARCO","XISX"] | 120.0000 | 120.0000 | 2 | 93 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:01:04Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a627-630e-75c2-a5e1-0c0d5bec5871 | SHOP | 2026-09-15 13:39 | call_vertical_spread | 2 | 1 | 331 | 512057.00 | unknown | — | 130.2550 | 1.0900 | ["115","145"] | ["0.6936","0.6485"] | [] | ["XCBO"] | 115.0000 | 145.0000 | 3 | 3 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:40:08Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a625-5b85-7010-a8c2-a5c5a0ad9c75 | SHOP | 2026-09-15 13:37 | call_vertical_spread | 2 | 3 | 194 | 300118.00 | unknown | — | 130.2400 | 1.2400 | ["115","145"] | ["0.7159","0.6491"] | [] | ["XCBO"] | 115.0000 | 145.0000 | 3 | 3 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:37:56Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5c3-f9d6-7680-a87c-ed3350ac89ba | SHOP | 2026-09-15 11:51 | call_diagonal_spread | 2 | 1 | 25 | 291276.00 | unknown | — | 131.1250 | 5.6000 | ["50","110"] | ["6.2484","0.5919"] | [] | ["XMIO"] | 50.0000 | 110.0000 | 3 | 857 | true | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:51:42Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a569-720e-7341-962d-76d2ef6aa947 | SHOP | 2026-09-15 10:12 | put_diagonal_spread | 2 | 1 | 20 | 119080.00 | unknown | — | 131.7000 | 3.2500 | ["140","165"] | ["0.5670","0.6031"] | [] | ["BATO"] | 140.0000 | 165.0000 | 367 | 822 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:12:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a076-7730-7fa0-9758-a72b2a282ad6 | SHOP | 2026-09-14 11:08 | call_calendar | 2 | 2 | 92 | 217580.00 | unknown | — | 131.4300 | 5.6457 | ["120"] | ["0.7290"] | [] | ["XISX"] | 120.0000 | 120.0000 | 4 | 11 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:08:43Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 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-95d0-7011-a0fd-5aeb87032c6c | SHOP | 2026-09-09 13:54 | call_vertical_spread | 2 | 1 | 50 | 220300.00 | unknown | — | 127.8500 | 2.9500 | ["100","150"] | ["0.5914","0.5530"] | [] | ["XISX"] | 100.0000 | 150.0000 | 128 | 128 | false | false | false | 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 |
| 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 |
| 01a08682-c9f0-77e1-8531-d43998120f14 | SHOP | 2026-09-09 10:11 | call_calendar | 2 | 1 | 97 | 173824.00 | unknown | — | 131.1900 | 3.8500 | ["125"] | ["0.5569"] | [] | ["BATO"] | 125.0000 | 125.0000 | 9 | 16 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:12:08Z"} | 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 |
| 01a0815d-f0a8-7733-8984-150584a5893f | SHOP | 2026-09-08 10:13 | call_vertical_spread | 2 | 2 | 500 | 881750.00 | unknown | — | 134.8600 | 1.7250 | ["160","230"] | ["0.5612","0.5685"] | [] | ["ARCO","XISX"] | 160.0000 | 230.0000 | 192 | 192 | true | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:13:51Z"} | 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 |
| 01a08136-778a-76c3-8e74-532e154bcf6a | SHOP | 2026-09-08 09:30 | call_calendar | 2 | 1 | 30 | 111960.00 | unknown | — | 141.5300 | 6.3500 | ["125"] | ["0.5779"] | [] | ["XMIO"] | 125.0000 | 125.0000 | 10 | 38 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:30:13Z"} | 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 |