boomer77Top 5 V2
    Updated 2021-08-11
    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