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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |