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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06df3-1dcd-75e1-a18d-20294629e29a | MSTR | 2026-09-04 15:44 | call_butterfly_spread | 3 | 1 | 40 | 304680.00 | long | ask | 143.0450 | 1.9000 | ["103","105","107"] | ["25.4388","23.5051","19.6188"] | [] | ["XMIO"] | 103.0000 | 107.0000 | 0 | 0 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:44:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a08140-0480-7fc3-b821-48b7833a726a | MSTR | 2026-09-08 09:40 | call_butterfly_spread | 3 | 2 | 68 | 137564.00 | long | ask | 135.9400 | 1.6500 | ["200","250","280"] | ["0.8034","0.8264","0.8391"] | ["203.70"] | ["EDGO"] | 200.0000 | 280.0000 | 192 | 192 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:40:51Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a09135-8b08-7252-8d8a-3d9c70ff884a | MSTR | 2026-09-11 12:03 | call_butterfly_spread | 3 | 1 | 100 | 231350.00 | short | bid | 134.0555 | 0.9000 | ["165","185","190"] | ["0.7753","0.7875","0.7902"] | ["168.15"] | ["XCBO"] | 165.0000 | 190.0000 | 126 | 126 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:03:34Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09144-38d8-70a0-b6f3-a3ced8999065 | MSTR | 2026-09-11 12:19 | call_butterfly_spread | 3 | 1 | 100 | 226650.00 | long | ask | 133.1700 | 0.8000 | ["165","185","190"] | ["0.7770","0.7904","0.7929"] | ["168.05"] | ["XCBO"] | 165.0000 | 190.0000 | 126 | 126 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:19:23Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a573-e5d6-7342-85a6-3d3356fd059a | MSTR | 2026-09-15 10:23 | call_butterfly_spread | 3 | 1 | 16 | 164368.00 | short | bid | 130.2550 | 6.9000 | ["100","130","150"] | ["0.8242","0.8141","0.8053"] | ["105.10"] | ["BATO"] | 100.0000 | 150.0000 | 493 | 493 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:23:59Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0b4c8-9cf8-76f3-9f5e-151f43f23a86 | MSTR | 2026-09-18 09:50 | call_butterfly_spread | 3 | 5 | 120 | 1287452.00 | short | bid | 142.8400 | 10.0000 | ["80","100","120"] | ["0.7003","0.7265","0.7370"] | ["82.65","117.35"] | ["ARCO","BATO","C2OX","EMLD","SPHR"] | 80.0000 | 120.0000 | 182 | 182 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:50:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5fc-71a7-7c41-8110-e4071fbf316d | MSTR | 2026-09-18 15:26 | call_butterfly_spread | 3 | 1 | 132 | 527538.00 | short | bid | 153.4300 | 2.8000 | ["260","290","300"] | ["0.7668","0.7714","0.7735"] | ["262.69"] | ["XCBO"] | 260.0000 | 300.0000 | 364 | 364 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:26:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5fc-6dc0-7651-93ef-e5212a433eb4 | MSTR | 2026-09-18 15:26 | call_butterfly_spread | 3 | 1 | 40 | 161800.00 | long | ask | 153.4300 | 1.6000 | ["260","290","300"] | ["0.7705","0.7756","0.7783"] | ["262.70"] | ["XBOX"] | 260.0000 | 300.0000 | 364 | 364 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:26:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c42e-4c5f-7b71-a7c0-7e4d92966cab | MSTR | 2026-09-21 09:36 | call_butterfly_spread | 3 | 1 | 100 | 227650.00 | long | ask | 169.3800 | 2.2500 | ["200","250","300"] | ["0.7685","0.7969","0.8269"] | ["204.77","295.23"] | ["XISX"] | 200.0000 | 300.0000 | 116 | 116 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:36:12Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c42e-4c5f-7b71-a7c0-7e2f88f9baef | MSTR | 2026-09-21 09:36 | call_butterfly_spread | 3 | 1 | 100 | 227850.00 | long | ask | 169.3800 | 2.2500 | ["200","250","300"] | ["0.7698","0.7973","0.8256"] | ["204.77","295.23"] | ["XPHO"] | 200.0000 | 300.0000 | 116 | 116 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:36:12Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c42e-4876-71f1-a7c6-1662d96f78f5 | MSTR | 2026-09-21 09:36 | call_butterfly_spread | 3 | 1 | 100 | 227500.00 | long | ask | 169.4450 | 2.2500 | ["200","250","300"] | ["0.7682","0.7961","0.8252"] | ["204.78","295.22"] | ["XPHO"] | 200.0000 | 300.0000 | 116 | 116 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:36:12Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c42e-4876-71f1-a7c6-163115ec2633 | MSTR | 2026-09-21 09:36 | call_butterfly_spread | 3 | 1 | 100 | 226850.00 | long | ask | 169.5000 | 2.1000 | ["200","250","300"] | ["0.7655","0.7946","0.8252"] | ["204.77","295.23"] | ["XPHO"] | 200.0000 | 300.0000 | 116 | 116 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:36:12Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c42e-7f27-7fc2-9833-5f32ad9b4317 | MSTR | 2026-09-21 09:36 | call_butterfly_spread | 3 | 2 | 20 | 158098.00 | long | ask | 168.5600 | 5.4000 | ["100","150","200"] | ["0.8430","0.7735","0.7854"] | ["117.30","182.70"] | ["XCBO","XISX"] | 100.0000 | 200.0000 | 88 | 88 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:36:24Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c42e-7f27-7fc2-9833-5f2916f3524e | MSTR | 2026-09-21 09:36 | call_butterfly_spread | 3 | 2 | 18 | 142200.00 | short | bid | 168.5600 | 5.4000 | ["100","150","200"] | ["0.8264","0.7753","0.7848"] | ["117","183"] | ["XPHO"] | 100.0000 | 200.0000 | 88 | 88 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:36:24Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c48b-be3f-77f1-8eda-0af5aee1238c | MSTR | 2026-09-21 11:18 | call_butterfly_spread | 3 | 1 | 50 | 104400.00 | unknown | — | 167.0350 | 0.5000 | ["155","160","165"] | ["0.8838","0.8891","0.9035"] | [] | ["XCBO"] | 155.0000 | 165.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:18:18Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |