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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c460-1e46-70f2-9fef-26d71186e2b8 | MSTR | 2026-09-21 10:30 | call_vertical_spread | 2 | 1 | 200 | 4054000.00 | unknown | — | 165.7500 | 6.1000 | ["100","110"] | ["0.8308","0.8273"] | [] | ["SPHR"] | 100.0000 | 110.0000 | 816 | 816 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:30:28Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b617-cd90-70e1-8711-d89a61e710e8 | MSTR | 2026-09-18 15:56 | call_diagonal_spread | 2 | 1 | 6272 | 135402276.00 | unknown | ask | 153.7100 | 4.7500 | ["40","50"] | ["218.8612","3.4619"] | [] | ["SPHR"] | 40.0000 | 50.0000 | 0 | 7 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:57:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b526-fd1f-72e0-bc98-febed2d7f270 | MSTR | 2026-09-18 11:33 | call_calendar | 2 | 1 | 100 | 751700.00 | unknown | ask | 147.9650 | 2.6000 | ["111"] | ["4.7258"] | [] | ["XBOX"] | 111.0000 | 111.0000 | 0 | 7 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:33:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0a0-969b-7be2-befd-c8998254f561 | MSTR | 2026-09-17 14:28 | put_ladder | 8 | 1 | 1590 | 17794920.00 | unknown | — | 132.5600 | 12.4000 | ["155","180","185","190","195","200","310","320"] | ["2.1244","3.6433","4.0598","4.3025","4.5356","4.4836","8.3271","8.5684"] | [] | ["XBOX"] | 155.0000 | 320.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:28:37Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afc2-ae03-7281-851b-1a977bfc0e86 | MSTR | 2026-09-17 10:26 | call_diagonal_spread | 2 | 1 | 20 | 197700.00 | unknown | — | 132.3000 | 4.2000 | ["125","130"] | ["0.7748","0.7736"] | [] | ["AMXO"] | 125.0000 | 130.0000 | 456 | 491 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:26:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aba7-0f2b-7813-83db-520903040976 | MSTR | 2026-09-16 15:17 | put_ladder | 5 | 1 | 316 | 6273120.00 | unknown | — | 124.7400 | 11.2500 | ["185","200","280","290","300"] | ["2.4834","3.6417","6.4310","6.6363","6.8329"] | [] | ["XBOX"] | 185.0000 | 300.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:17:35Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab2b-18cb-7d82-9218-6e05974472b7 | MSTR | 2026-09-16 13:02 | call_diagonal_spread | 2 | 1 | 52 | 113100.00 | unknown | — | 126.1750 | 1.1500 | ["125","130"] | ["0.6944","0.7099"] | [] | ["XBOX"] | 125.0000 | 130.0000 | 30 | 44 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:02:17Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5f9-abee-74d0-bad0-02e25de523d4 | MSTR | 2026-09-15 12:49 | put_ratio_spread | 2 | 3 | 1313 | 5286612.00 | unknown | — | 132.0550 | 3.2000 | ["65","130"] | ["0.8685","0.8303"] | [] | ["AMXO"] | 65.0000 | 130.0000 | 640 | 640 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:50:51Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a158-3058-7373-ad96-f166b6d8eda4 | MSTR | 2026-09-14 15:15 | other | 4 | 1 | 322 | 6937200.00 | unknown | — | 136.3999 | 5.3500 | ["200","280","290","300"] | ["2.1210","3.2563","4.0620","3.9698"] | [] | ["XBOX"] | 200.0000 | 300.0000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:15:23Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a153-a060-7123-be9f-0369f1580d37 | MSTR | 2026-09-14 15:10 | other | 4 | 1 | 235 | 5050020.00 | unknown | — | 135.9450 | 5.4500 | ["200","280","290","300"] | ["1.7953","3.3203","3.7719","3.5811"] | [] | ["XBOX"] | 200.0000 | 300.0000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:10:13Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0dd-7278-7a20-80b3-807ff40d5e25 | MSTR | 2026-09-14 13:01 | other | 2 | 2 | 1500 | 11730000.00 | unknown | — | 136.1600 | 2.3000 | ["95","100"] | ["0.8010","1.9338"] | [] | ["AMXO"] | 95.0000 | 100.0000 | 4 | 32 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:01:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0920b-b340-7ce2-a1c7-c5b5eb8c0099 | MSTR | 2026-09-11 15:57 | other | 2 | 1 | 6209 | 107373330.00 | unknown | — | 130.8900 | 6.7500 | ["40","45"] | ["4.4246","346.7845"] | [] | ["SPHR"] | 40.0000 | 45.0000 | 0 | 7 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:57:30Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091e6-0aa0-7251-8c96-733d5f174fb5 | MSTR | 2026-09-11 15:16 | other | 5 | 1 | 132 | 6535724.00 | unknown | — | 130.9400 | 4.0500 | ["200","280","290","300","310"] | ["1.0980","1.9615","2.1493","2.2521","2.3177"] | [] | ["XPHO"] | 200.0000 | 310.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:16:17Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c9a-5808-7e60-b808-2eb6bd390d9b | MSTR | 2026-09-10 14:35 | other | 8 | 1 | 197 | 8369260.00 | unknown | — | 129.4100 | 7.0000 | ["165","167.5","170","280","290","300","310","320"] | ["2.7240","2.8558","3.7404","1.8820","1.9856","2.7166","2.8740","2.2808"] | [] | ["XBOX"] | 165.0000 | 320.0000 | 1 | 8 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:35:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08274-88f8-76b2-8e45-9ba09a0f99b2 | MSTR | 2026-09-08 15:17 | other | 5 | 1 | 132 | 6191224.00 | unknown | — | 136.6100 | 9.6000 | ["280","290","300","310","340"] | ["2.4653","2.5594","2.4043","2.7364","2.8945"] | [] | ["XBOX"] | 280.0000 | 340.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:18:10Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0826e-0500-7420-bd69-6d23ead28528 | MSTR | 2026-09-08 15:10 | other | 5 | 1 | 98 | 4475580.00 | unknown | — | 136.7350 | 10.1000 | ["280","290","300","310","340"] | ["2.5074","2.6023","2.5563","2.7807","2.9452"] | [] | ["XBOX"] | 280.0000 | 340.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:10:57Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06e00-161e-7ee1-976d-8f462a03644a | MSTR | 2026-09-04 15:58 | other | 2 | 1 | 5737 | 115096359.00 | unknown | — | 142.9350 | 4.6000 | ["40","45"] | ["270.7709","3.4768"] | [] | ["SPHR"] | 40.0000 | 45.0000 | 0 | 7 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:58:25Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd7-dd3e-7990-b7d5-8b616f62a4da | MSTR | 2026-09-04 15:14 | other | 5 | 1 | 132 | 5954968.00 | unknown | — | 143.5550 | 7.0500 | ["280","290","300","310","340"] | ["1.5019","2.0409","2.1177","2.1944","2.3205"] | [] | ["XBOX"] | 280.0000 | 340.0000 | 14 | 14 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:14:49Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |