with tab1 as (

SELECT

distinct origin_from_address as withdrawers,'Stakewise' as platform,count(distinct tx_hash) as transactions,sum(amount_out_usd) as total_eth_withdrawn_usd, sum(amount_out) as total_eth_withdrawn

FROM ethereum.core.ez_dex_swaps

where symbol_out like '%sETH2%' and block_timestamp >='2023-01-01'

GROUP BY withdrawers,platform

), tab2 as (

SELECT

distinct origin_from_address as withdrawers,'Ankr' as platform,count(distinct tx_hash) as transactions,sum(amount_out_usd) as total_eth_withdrawn_usd, sum(amount_out) as total_eth_withdrawn

FROM ethereum.core.ez_dex_swaps

where symbol_out like '%aETH%' and block_timestamp >='2023-01-01'

GROUP BY withdrawers,platform

), tab3 as (

SELECT

distinct origin_from_address as withdrawers,'Rocketpool' as platform,count(distinct tx_hash) as transactions,sum(amount_out_usd) as total_eth_withdrawn_usd, sum(amount_out) as total_eth_withdrawn

FROM ethereum.core.ez_dex_swaps

where symbol_out like '%rETH%' and block_timestamp >='2023-01-01'

GROUP BY withdrawers,platform

), tab4 as (

SELECT

distinct origin_from_address as withdrawers,'Lido' as platform,count(distinct tx_hash) as transactions,sum(amount_out_usd) as total_eth_withdrawn_usd, sum(amount_out) as total_eth_withdrawn

FROM ethereum.core.ez_dex_swaps

where symbol_out like '%stETH%' and block_timestamp >='2023-01-01'

GROUP BY withdrawers,platform

),

tab5 as (

SELECT

distinct origin_from_address as withdrawers,'Cream Finance' as platform,count(distinct tx_hash) as transactions,sum(amount_out_usd) as total_eth_withdrawn_usd, sum(amount_out) as total_eth_withdrawn

FROM ethereum.core.ez_dex_swaps

where symbol_out like '%crETH2%' and block_timestamp >='2023-01-01'

group by withdrawers,platform

),

tab6 as (

SELECT * FROM tab1

UNION SELECT * FROM tab2