gsunSWAP-SUSHI-users
Updated 2021-11-14
9
1
2
3
›
⌄
select count(distinct from_address) wallets,decode(platform,'uniswap-v2','uniswap','uniswap-v3','uniswap',platform) platform, date_trunc('week',block_timestamp::DATE) week
FROM ethereum.dex_swaps where block_timestamp >= getdate() - INTERVAL '365 days' and platform in ('sushiswap','uniswap-v2','uniswap-v3')
GROUP by decode(platform,'uniswap-v2','uniswap','uniswap-v3','uniswap',platform),date_trunc('week',block_timestamp::DATE) ORDER by date_trunc('week',block_timestamp::DATE) desc
Run a query to Download Data