boomer77Top 5 V2
Updated 2021-08-11
9
1
2
3
4
5
6
7
›
⌄
SELECT
date_trunc('week', block_timestamp) as week, pool_name, pool_address, sum(amount_usd) as Swapin, direction
from ethereum.dex_swaps
where amount_usd is not null and platform = 'uniswap-v2' and direction = 'IN' and week = '2021-08-2' and amount_usd < 5000000
group by 1,2,3,5
order by 4 desc
limit 5
Run a query to Download Data