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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06d3a-5905-76f1-a5ea-e0f9bf5b789c | NOW | 2026-09-04 12:22 | call_condor | 4 | 1 | 10 | 106260.00 | long | ask | 141.2950 | 1.9500 | ["110","120","140","150"] | ["0.5718","0.5675","0.5574","0.5571"] | ["112.66","147.34"] | ["XMIO"] | 110.0000 | 150.0000 | 133 | 133 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:22:25Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dad-7d95-78c1-94c7-e42a828571c5 | NOW | 2026-09-04 14:27 | put_calendar | 2 | 1 | 80 | 135120.00 | short | ask | 142.2000 | 0.7500 | ["150"] | ["1.5270"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 0 | 7 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:28:25Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06ddb-4c25-7753-b779-9c6adf7a406d | NOW | 2026-09-04 15:18 | risk_reversal | 2 | 1 | 105 | 371595.00 | long | ask | 141.8200 | 1.3000 | ["115","190"] | ["0.5750","0.5622"] | ["194.11"] | ["XMIO"] | 115.0000 | 190.0000 | 378 | 378 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:18:22Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a08157-ab30-7161-85e4-27dd0ebd5904 | NOW | 2026-09-08 10:06 | call_diagonal_spread | 2 | 1 | 100 | 306800.00 | long | ask | 134.4900 | 0.8500 | ["132","150"] | ["0.5670","0.5668"] | [] | ["BATO"] | 132.0000 | 150.0000 | 101 | 129 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:06:46Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0819d-f360-7f93-aca3-b9c61b08dea8 | NOW | 2026-09-08 11:23 | call_calendar | 2 | 1 | 20 | 114240.00 | long | ask | 134.6450 | 2.0500 | ["155"] | ["0.5711"] | [] | ["XMIO"] | 155.0000 | 155.0000 | 374 | 500 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:23:33Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08282-a258-7882-b77b-2b5c1b444224 | NOW | 2026-09-08 15:33 | call_calendar | 2 | 1 | 10 | 103150.00 | short | ask | 133.7300 | 2.4000 | ["115"] | ["0.5821"] | [] | ["XCBO"] | 115.0000 | 115.0000 | 500 | 829 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:33:51Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08763-13e8-72e2-af5d-315a83fadf94 | NOW | 2026-09-09 14:16 | call_vertical_spread | 2 | 1 | 50 | 138750.00 | long | ask | 131.4350 | 0.5000 | ["120","150"] | ["0.5965","0.5905"] | ["132.75"] | ["C2OX"] | 120.0000 | 150.0000 | 72 | 72 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:17:23Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08bfd-1638-7383-b558-940f9ba1266f | NOW | 2026-09-10 11:43 | call_vertical_spread | 2 | 1 | 30 | 184770.00 | long | ask | 133.6501 | 1.5000 | ["150","160"] | ["0.5733","0.5709"] | ["153.17"] | ["XISX"] | 150.0000 | 160.0000 | 498 | 498 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:43:58Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c2c-5010-7342-981f-bf75213156ab | NOW | 2026-09-10 12:35 | strangle | 2 | 1 | 200 | 446000.00 | long | ask | 133.1800 | 0.6500 | ["120","150"] | ["0.5615","0.5654"] | ["97.70","172.30"] | ["SPHR"] | 120.0000 | 150.0000 | 127 | 127 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:35:11Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a090bd-b359-7660-a61e-2009f30f1638 | NOW | 2026-09-11 09:52 | call_vertical_spread | 2 | 2 | 93 | 150381.00 | long | ask | 133.9750 | 0.7600 | ["120","140"] | ["0.5632","0.5356"] | ["132.65"] | ["XISX"] | 120.0000 | 140.0000 | 7 | 7 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:52:28Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a028-10e0-75a1-9f81-b193cadfb3bd | NOW | 2026-09-14 09:42 | call_vertical_spread | 2 | 1 | 22 | 159654.00 | long | ask | 140.4100 | 1.3500 | ["100","110"] | ["0.6224","0.5858"] | ["109.49"] | ["MCRY"] | 100.0000 | 110.0000 | 32 | 32 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:42:54Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a178-6670-7350-ad0b-b450f5cd9609 | NOW | 2026-09-14 15:50 | call_diagonal_spread | 2 | 1 | 100 | 350300.00 | long | ask | 142.4800 | 1.2500 | ["130","135"] | ["0.5374","0.5851"] | [] | ["XCBO"] | 130.0000 | 135.0000 | 32 | 67 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:50:35Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a561-7ee6-7a22-88e1-612816d11e60 | NOW | 2026-09-15 10:03 | call_vertical_spread | 2 | 2 | 25 | 229775.00 | long | ask | 141.3000 | 3.8500 | ["90","100"] | ["3.3075","1.9784"] | ["99.95"] | ["AMXO"] | 90.0000 | 100.0000 | 3 | 3 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:03:51Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5e1-612e-7ee1-b664-d60651e5b663 | NOW | 2026-09-15 12:23 | call_vertical_spread | 2 | 6 | 31 | 114533.00 | long | ask | 146.3800 | 0.8500 | ["135","170"] | ["0.5741","0.5630"] | ["149.35"] | ["ARCO","BATO","EDGO","EMLD","SPHR","XBOX"] | 135.0000 | 170.0000 | 122 | 122 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:23:24Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a665-7996-7480-ac9e-2f3deb3f9a53 | NOW | 2026-09-15 14:47 | call_vertical_spread | 2 | 1 | 125 | 251500.00 | long | ask | 142.9500 | 0.5500 | ["133","134"] | ["0.6863","0.6717"] | ["133.90"] | ["XMIO"] | 133.0000 | 134.0000 | 3 | 3 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:48:05Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a4-ff4e-75d2-9ad9-27fc6b7b175f | NOW | 2026-09-15 15:57 | call_diagonal_spread | 2 | 1 | 194 | 442902.00 | short | ask | 141.8500 | 0.3500 | ["125","150"] | ["0.7614","0.5400"] | [] | ["EDGO"] | 125.0000 | 150.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:57:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0b06a-fbf3-7c52-ba07-c95d63fbe83d | NOW | 2026-09-17 13:29 | put_diagonal_spread | 2 | 1 | 132 | 347292.00 | long | ask | 138.5500 | 0.4000 | ["140","145"] | ["0.5648","0.6752"] | [] | ["XCBO"] | 140.0000 | 145.0000 | 1 | 155 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:30:09Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b4bf-1f48-73b3-ac5f-ceb2c71910d6 | NOW | 2026-09-18 09:40 | put_vertical_spread | 2 | 4 | 50 | 130500.00 | unknown | ask | 137.0500 | 0.6500 | ["130","145"] | ["0.5746","0.5727"] | ["124.45"] | ["XPHO"] | 130.0000 | 145.0000 | 63 | 63 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:40:24Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b54d-8c37-7930-a0f0-b504c76eaa77 | NOW | 2026-09-18 12:15 | other | 3 | 1 | 500 | 157500.00 | unknown | ask | 136.6950 | 0.1200 | ["140","145","175"] | ["0.7582","1.3126","0.5777"] | [] | ["XPHO"] | 140.0000 | 175.0000 | 0 | 63 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:16:26Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b59c-dce7-7870-a7c1-1d77038f5034 | NOW | 2026-09-18 13:42 | call_vertical_spread | 2 | 1 | 14 | 194460.00 | long | ask | 136.8800 | 2.0000 | ["65","70"] | ["2.0203","1.9059"] | ["69.98"] | ["MCRY"] | 65.0000 | 70.0000 | 14 | 14 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:43:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5b4-ba47-72c0-b67b-388256832541 | NOW | 2026-09-18 14:08 | call_diagonal_spread | 2 | 1 | 40 | 135120.00 | short | ask | 136.8800 | 0.4500 | ["115","140"] | ["5.7174","0.5689"] | [] | ["XMIO"] | 115.0000 | 140.0000 | 0 | 63 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:08:52Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ec-588f-7fe2-9841-1ecb7e4e22ae | NOW | 2026-09-18 15:09 | call_diagonal_spread | 2 | 1 | 20 | 100000.00 | long | ask | 136.7100 | 1.1000 | ["112","120"] | ["10.7605","0.5691"] | [] | ["XISX"] | 112.0000 | 120.0000 | 0 | 91 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:09:26Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |