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;