theericstoneTVL in All Liquidity Pools on Ethereum
    Updated 2021-02-02
    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;
    Run a query to Download Data