theericstoneDAI Liquidity in Uniswap
    Updated 2021-02-06
    SELECT
    balance_date,
    sum(balance) as dai_tvl,
    sum(amount_usd) as dai_tvl_usd,
    count(distinct user_address) as n_pools
    from gold.ethereum_erc20_balances
    where balance_date >= getdate() - interval '1 month'
    and contract_address = '0x6b175474e89094c44da98b954eedeac495271d0f' --DAI
    and address_name ~ ' LP$'
    and label = 'uniswap'
    group by 1 order by 1 desc;
    Run a query to Download Data