with sushi_swap as ( select origin_from_address as user, count(DISTINCT tx_hash) as count_tx, sum(AMOUNT_IN_USD) as USD_volume, avg(amount_in_usd) as average_volume from ethereum.sushi.ez_swaps where platform = 'sushiswap' and block_timestamp::date >= '2022-10-20' and block_timestamp::date <= '2022-11-07' group by 1) , Jupiter as ( select trunc(block_timestamp,'day') as day, tx_id, swapper, swap_from_amount, SWAP_TO_MINT, SWAP_from_MINT from solana.core.fact_swaps where SWAP_PROGRAM ilike '%jupiter%' and block_timestamp::date >= '2022-10-20' and block_timestamp::date <= '2022-11-07') , sol_price as ( select trunc(block_timestamp,'day') as day, a.swap_from_mint , (sum(SWAP_TO_AMOUNT)/sum(a.SWAP_FROM_AMOUNT)) as price from solana.core.fact_swaps a join Jupiter b on a.SWAP_FROM_MINT = b.SWAP_FROM_MINT where a.SWAP_FROM_MINT = b.SWAP_FROM_MINT and a.SWAP_TO_MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' and block_timestamp::date >= '2022-10-20' and block_timestamp::date <= '2022-11-07' and SWAP_TO_AMOUNT > 0 and a.SWAP_FROM_AMOUNT > 0 group by 1,2 ) , jupiter_volume as ( select a.day , tx_id, swapper, swap_from_amount*price as amount_usd from jupiter a left outer join sol_price b on a.day = b.day where a.swap_from_mint = b.SWAP_FROM_MINT) , jupiter_swap as ( select swapper, count(DISTINCT tx_id) as count_tx, count(DISTINCT swapper) as count_user, sum(AMOUNT_USD) as usd_volume, avg(amount_usd) as avg_volume from jupiter_volume where day >= '2022-10-20' and day <= '2022-11-07' group by 1) , tb2 as ( select 'SushiSwap' as platform, user, usd_volume as volume, count_tx from sushi_swap UNION select 'Jupiter' as platform, swapper as user, usd_volume as volume, count_tx from jupiter_swap) , tb3 as ( select count(DISTINCT user ) as total, platform, case when volume > 0 and volume <= 1 then 'Up to 1$' when volume > 1 and volume <= 10 then '1-10$' when volume > 10 and volume <= 100 then '10-100$' when volume > 100 and volume <= 1000 then '100-1K$' when volume > 1000 and volume <= 10000 then '1K-10K$' when volume > 10000 and volume <= 100000 then '10K-100K$' when volume > 100000 and volume <= 1000000 then '100K-1M$' when volume > 1000000 then '+1MK$' end as category from tb2 group by 2,3) select * from tb3 where category is not null

Sushiswap VS. Jupiter