strawbetty top 10 pools
    Updated 2022-04-17
    with top_pools as (
    select contract_address, symbol from ethereum.erc20_balances
    WHERE balance_date::date = CURRENT_DATE - 2
    and symbol like 'km%' and ( symbol like '%USDC%' or symbol like '%DAI%' or symbol like '%UST%' or symbol like '%USDT%' )
    group by 1, 2
    )
    select symbol, sum(balance) as t_value from ethereum.erc20_balances
    where balance_date::date = CURRENT_DATE - 1
    and contract_address in (select contract_address from top_pools)
    group by 1
    order by 2 desc
    limit 10
    Run a query to Download Data