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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 01a0b608-d96f-7521-a456-9fb806cbd005 | MSTR | 2026-09-18 15:40 | call_ratio_spread | 2 | 1 | 136 | 332384.00 | unknown | ask | 153.2600 | 0.8500 | ["136","142"] | ["0.6768","0.6699"] | ["156.29"] | ["XISX"] | 136.0000 | 142.0000 | 14 | 14 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:40:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e9-7260-76e0-976d-0d5f757375a5 | MSTR | 2026-09-18 15:06 | other | 4 | 5 | 108 | 149485.00 | unknown | ask | 152.2500 | 1.6400 | ["100","135","155","157.5"] | ["0.7601","0.7145","0.7018","0.7199"] | [] | ["BATO","C2OX","EDGO","XPHO"] | 100.0000 | 157.5000 | 7 | 91 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:06:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e4-3687-7663-938f-28f6515c051a | MSTR | 2026-09-18 15:00 | other | 4 | 1 | 1675 | 5740225.00 | unknown | ask | 151.7350 | 1.6200 | ["134","142","155","165"] | ["6.7502","4.2676","0.6957","0.7477"] | [] | ["XCBO"] | 134.0000 | 165.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:00:32Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5db-6c87-74b2-8776-bb5281efc0b3 | MSTR | 2026-09-18 14:50 | call_diagonal_spread | 2 | 5 | 32 | 120046.00 | unknown | ask | 151.9800 | 0.3500 | ["125","155"] | ["8.1423","0.6907"] | [] | ["AMXO","ARCO","XBOX","XISX","XPHO"] | 125.0000 | 155.0000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:51:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5db-6c87-74b2-8776-bb26493bd190 | MSTR | 2026-09-18 14:50 | call_diagonal_spread | 2 | 5 | 32 | 120046.00 | unknown | ask | 151.9900 | 0.3406 | ["125","155"] | ["7.9814","0.6904"] | [] | ["AMXO","ARCO","XBOX","XISX","XPHO"] | 125.0000 | 155.0000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:51:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5db-689f-7ed0-91ac-1b7d08c327e1 | MSTR | 2026-09-18 14:50 | call_diagonal_spread | 2 | 5 | 32 | 120046.00 | unknown | ask | 151.9674 | 0.3500 | ["125","155"] | ["8.2461","0.6910"] | [] | ["AMXO","ARCO","XBOX","XISX","XPHO"] | 125.0000 | 155.0000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:51:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5db-495f-7a53-98c3-f1988630a585 | MSTR | 2026-09-18 14:50 | call_diagonal_spread | 2 | 5 | 32 | 120128.00 | unknown | ask | 151.9800 | 0.3000 | ["125","155"] | ["8.3575","0.6914"] | [] | ["AMXO","ARCO","XBOX","XISX","XPHO"] | 125.0000 | 155.0000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:51:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5da-4f5f-7e92-8db0-0ecb80013e48 | MSTR | 2026-09-18 14:49 | call_diagonal_spread | 2 | 5 | 32 | 119856.00 | unknown | ask | 151.9200 | 0.2500 | ["125","155"] | ["8.3638","0.6916"] | [] | ["AMXO","ARCO","XBOX","XISX","XPHO"] | 125.0000 | 155.0000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:49:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5da-2467-7b82-bba1-2e7838696817 | MSTR | 2026-09-18 14:49 | call_diagonal_spread | 2 | 5 | 29 | 108757.00 | unknown | ask | 151.9700 | 0.1845 | ["125","155"] | ["7.6365","0.6927"] | [] | ["AMXO","ARCO","XBOX","XISX","XPHO"] | 125.0000 | 155.0000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:49:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5da-0cf7-7273-9e53-369bf511b826 | MSTR | 2026-09-18 14:49 | call_diagonal_spread | 2 | 7 | 50 | 187078.00 | unknown | ask | 151.9450 | 0.4500 | ["125","155"] | ["7.6019","0.6908"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 125.0000 | 155.0000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:49:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5da-0910-7ac3-b936-b3fdf2c62ef2 | MSTR | 2026-09-18 14:49 | call_diagonal_spread | 2 | 7 | 50 | 187036.00 | unknown | ask | 151.9450 | 0.4500 | ["125","155"] | ["8.2047","0.6912"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 125.0000 | 155.0000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:49:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5bd-c2c8-7442-af61-3d18150f04f8 | MSTR | 2026-09-18 14:18 | other | 4 | 2 | 50 | 152000.00 | unknown | ask | 151.2700 | 0.7700 | ["115","120","135","145"] | ["0.8676","0.7589","0.6675","0.6712"] | [] | ["MCRY"] | 115.0000 | 145.0000 | 7 | 14 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:18:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b59c-736f-78e1-b4f4-6121629f8417 | MSTR | 2026-09-18 13:42 | call_diagonal_spread | 2 | 1 | 14 | 201992.00 | unknown | ask | 150.5900 | 3.0000 | ["85","105"] | ["0.8457","0.7574"] | [] | ["ARCO"] | 85.0000 | 105.0000 | 119 | 637 | 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 |
| 01a0b57d-bc27-7c42-b37d-b1c3d5908628 | MSTR | 2026-09-18 13:08 | put_vertical_spread | 2 | 1 | 286 | 3455452.00 | unknown | ask | 150.3150 | 4.7500 | ["150","155"] | ["0.8174","0.8133"] | ["92.09"] | ["ARCO"] | 150.0000 | 155.0000 | 854 | 854 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:08:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b568-634f-7ab0-89fd-61b8e2e4b233 | MSTR | 2026-09-18 12:45 | other | 4 | 1 | 32 | 180864.00 | unknown | ask | 150.0423 | 1.0500 | ["140","145","150","155"] | ["0.7194","0.7202","0.7227","0.7238"] | ["134.10"] | ["XISX"] | 140.0000 | 155.0000 | 91 | 91 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:45:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55d-dc00-7fe2-a874-4148aa81e9f7 | MSTR | 2026-09-18 12:33 | put_condor | 4 | 2 | 7 | 142064.00 | unknown | ask | 150.9500 | 8.7000 | ["65","125","140","200"] | ["0.8366","0.8217","0.8264","0.8468"] | ["96.46"] | ["XBOX","XMIO"] | 65.0000 | 200.0000 | 819 | 819 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:34:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55c-a768-7273-a362-adc04152bb60 | MSTR | 2026-09-18 12:32 | other | 4 | 3 | 39 | 114075.00 | unknown | ask | 150.4000 | 1.1000 | ["105","115","120"] | ["0.7514","0.7330","0.7310"] | [] | ["XPHO"] | 105.0000 | 120.0000 | 91 | 119 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:32:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b544-4d07-79c2-adc2-f59d95308c06 | MSTR | 2026-09-18 12:05 | other | 4 | 2 | 18 | 210001.00 | unknown | ask | 149.1000 | 2.0500 | ["110","115","125","130"] | ["1.2624","6.4769","0.7413","2.9544"] | [] | ["XBOX","XCBO"] | 110.0000 | 130.0000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:06:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b541-95b7-7512-ad6a-950c6a1fb40b | MSTR | 2026-09-18 12:02 | call_vertical_spread | 2 | 1 | 20 | 111000.00 | unknown | ask | 149.0500 | 1.1500 | ["121","122"] | ["0.7213","0.7376"] | ["149.25"] | ["XISX"] | 121.0000 | 122.0000 | 7 | 7 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:03:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b53a-2377-7cf2-a68f-4133b43d9c8e | MSTR | 2026-09-18 11:54 | put_ratio_spread | 2 | 4 | 36 | 109186.00 | unknown | ask | 148.6700 | 0.4083 | ["130","165"] | ["0.7186","0.7276"] | ["121.45"] | ["AMXO","XISX","XPHO"] | 130.0000 | 165.0000 | 119 | 119 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:54:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b52b-5667-7b52-ac7e-8dc8854af088 | MSTR | 2026-09-18 11:38 | call_ladder | 3 | 1 | 3000 | 2387248.00 | unknown | ask | 147.9600 | 0.4000 | ["150","155","157.5"] | ["0.7116","0.7404","0.7505"] | ["151.92"] | ["EDGO"] | 150.0000 | 157.5000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:38:30Z"} | 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 |
| 01a0b50f-eadf-7ee2-ac21-c9b4a7e183c2 | MSTR | 2026-09-18 11:08 | call_vertical_spread | 2 | 1 | 2170 | 1770720.00 | unknown | ask | 147.5050 | 0.2500 | ["150","155"] | ["0.7289","0.7552"] | ["156.58"] | ["XPHO"] | 150.0000 | 155.0000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:08:47Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b507-578f-7320-a691-77e4f29c2803 | MSTR | 2026-09-18 10:59 | put_vertical_spread | 2 | 1 | 21 | 103740.00 | unknown | ask | 147.7700 | 0.6000 | ["150","160"] | ["0.7249","0.7300"] | ["130.30"] | ["XISX"] | 150.0000 | 160.0000 | 91 | 91 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:59:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b507-578f-7320-a691-77d196cf276f | MSTR | 2026-09-18 10:59 | put_vertical_spread | 2 | 5 | 24 | 118416.00 | unknown | ask | 147.7700 | 0.6000 | ["150","160"] | ["0.7239","0.7290"] | ["130.33"] | ["AMXO","EDGO","XBOX","XMIO","XPHO"] | 150.0000 | 160.0000 | 91 | 91 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:59:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4df-6117-7f20-b6c5-56cdaaebfe45 | MSTR | 2026-09-18 10:15 | call_vertical_spread | 2 | 1 | 7 | 101325.00 | unknown | ask | 144.9500 | 7.7000 | ["105","195"] | ["0.8356","0.8035"] | ["222.38"] | ["ARCO"] | 105.0000 | 195.0000 | 854 | 854 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:15:32Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ca-17df-7111-8d31-f9029adf5c70 | MSTR | 2026-09-18 09:52 | call_diagonal_spread | 2 | 1 | 125 | 191250.00 | unknown | ask | 144.1450 | 0.4000 | ["140","165"] | ["1.3127","0.7417"] | [] | ["XBOX"] | 140.0000 | 165.0000 | 0 | 63 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:52:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c5-5520-7ed0-8b75-4cc91c1150d0 | MSTR | 2026-09-18 09:47 | strangle | 2 | 1 | 11 | 150366.00 | unknown | ask | 142.3700 | 6.6000 | ["140","160"] | ["0.8135","0.8197"] | ["151.5"] | ["XISX"] | 140.0000 | 160.0000 | 819 | 819 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:47:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |