Query editor
with relabel_w_uni as (-- uni frontend router switch history: https://dune.com/queries/2984801/4950777-- 2021/05/06 v2 -> v3 router 1-- 2021/12/16 v3 router 1 -> v3 router 2-- 2023/01/18 v3 router 2-> old universal router-- 2023/06/05 old -> universal routerselect hash, block_time,case when metaaggregator = 'Uniswap X' then metaaggregatorwhen frontend like '%Uniswap%' then 'Uniswap Frontend'--when metaaggregator = '1inch Fusion' then '1inch Integrators'when frontend='Unknown' and solver = 'Uniswap V2 Router' and block_time <= date('2021-05-06') then 'Uniswap Frontend'when frontend='Unknown' and solver = 'Uniswap V3 Router 1' and block_time <= date('2021-12-16') then 'Uniswap Frontend'when frontend='Unknown' and solver = 'Uniswap V3 Router 2' and block_time <= date('2023-01-18') then 'Uniswap Frontend'when frontend='Unknown' and solver = 'Uniswap Old Universal Router' and block_time <= date('2023-06-05') then 'Uniswap Frontend'else frontend end as frontend, metaaggregator, solver, trade_usd, userfrom dune.flashbots.result_overall_of_alltime) select date_trunc('month', block_time) as date,case when metaaggregator in ('1inch Fusion', 'Uniswap X', 'Cowswap') then 'Solver Models'when frontend like 'DefiLlama%' or frontend = 'Matcha' or frontend like '%Integrators%' then 'Agg Integrators'when frontend like '%Telegram Bot%' then 'Telegram Bots'when frontend like '%Frontend%' or frontend like '%Uniswap%' then 'DEX Frontends'when frontend like '%Wallet%' or frontend = 'MetaMask Swaps' then 'Wallet Swaps'else null end frontend,sum(trade_usd) as volume,count(distinct user) as wallet,count(distinct hash) as tx_countfrom relabel_w_uniwhere frontend !='Unknown'group by 1,2