with p1 as -- (SELECT 'Base' as Layer_2, -- origin_from_address AS user, -- count(distinct tx_hash) AS number_of_swaps, -- (sum(case when amount_in_usd is null then amount_out_usd else amount_in_usd end))/2 AS swap_amount_in_USD, -- ((sum(case when amount_in_usd is null then amount_out_usd else amount_in_usd end))/2) * 0.003 AS USD_fee, -- --number_of_swaps/count_swappers as avg_swap_per_swapper, -- swap_amount_in_USD/number_of_swaps as avg_USD_amount_per_txn -- FROM base.defi.ez_dex_swaps -- WHERE platform ilike '%uniswap%' -- and ABS (AMOUNT_IN_USD - AMOUNT_OUT_USD) <= 2000 -- GROUP BY 1,2) -- union all -- (select 'Polygon' as Layer_2, -- origin_from_address AS user, -- count(distinct tx_hash) AS number_of_swaps, -- (sum(case when amount_in_usd is null then amount_out_usd else amount_in_usd end))/2 AS swap_amount_in_USD, -- ((sum(case when amount_in_usd is null then amount_out_usd else amount_in_usd end))/2) * 0.003 AS USD_fee, -- --number_of_swaps/count_swappers as avg_swap_per_swapper, -- swap_amount_in_USD/number_of_swaps as avg_USD_amount_per_txn -- from polygon.defi.ez_dex_swaps -- WHERE platform ilike '%uniswap%' -- and ABS (AMOUNT_IN_USD - AMOUNT_OUT_USD) <= 2000 -- group by 1,2) -- union all (select 'Arbitrum' as Layer_2, origin_from_address AS user, count(distinct tx_hash) AS number_of_swaps, (sum(case when amount_in_usd is null then amount_out_usd else amount_in_usd end))/2 AS swap_amount_in_USD, ((sum(case when amount_in_usd is null then amount_out_usd else amount_in_usd end))/2) * 0.003 AS USD_fee, -- number_of_swaps/count_swappers as avg_swap_per_swapper, swap_amount_in_USD/number_of_swaps as avg_USD_amount_per_txn from arbitrum.defi.ez_dex_swaps WHERE platform ilike '%uniswap%' and ABS (AMOUNT_IN_USD - AMOUNT_OUT_USD) <= 2000 group by 1,2) select Layer_2, case when swap_amount_in_USD >0 and swap_amount_in_USD < 50 then 'Swapping under 50 USD' when swap_amount_in_USD >=50 and swap_amount_in_USD < 500 then 'Swapping from 50 to 500 USD' when swap_amount_in_USD >=500 and swap_amount_in_USD < 5000 then 'Swapping from 500 to < 5K USD' when swap_amount_in_USD >=5000 and swap_amount_in_USD < 50000 then 'Swapping with 5K to 50K USD' when swap_amount_in_USD >=50000 and swap_amount_in_USD < 100000 then 'Swapping from 50K to 100K USD' when swap_amount_in_USD >=100000 and swap_amount_in_USD < 1000000 then 'Swapping from 100K to 1M USD ' else 'Swapping more than 1M USD' end as type, count (distinct user) as count_swappers from p1 WHERE swap_amount_in_USD >0 group by 1,2

Query	Creator	Created
uni p3 amount - polygon uniswap kyberswap woofi hashflow quickswap	hyoeiseman	Nov 24, 2023
uni p 3 amount - arbitrum uniswap kyberswap woofi hashflow quickswap	hyoeiseman	Nov 24, 2023
Profit from swapping stETH to ETH sushi balancer synthetix uniswap swaps	hyoeiseman	Jun 16, 2022

hyoeiseman