WITH lps AS (
select address from public.ethereum_address_labels
where (l1_label IN ('defi','dex') AND
l2_label in ('general_contract','liquidity_pool','converter_contract')) OR
address in (
)
SELECT
balance_date,
sum(amount_usd) as tvl
from gold.ethereum_erc20_balances
where balance_date >= getdate() - interval '1 month'
and user_address IN (SELECT address from lps)
group by 1 order by 1 desc;