theericstoneUniswap TVL
    Updated 2020-12-03

    WITH uniswap as (
    select address as pool_address,
    project_name,
    symbol from public.ethereum_address_labels_updates
    where project_name = 'uniswap'
    and symbol like '%LP'
    )
    select
    --bals.balance_date,
    --bals.symbol,
    bals.address_name,
    sum(amount_usd) as tvl
    from
    gold.ethereum_erc20_balances bals
    join uniswap
    on uniswap.pool_address = bals.user_address
    where bals.balance_date > '2020-12-02'
    group by 1
    order by tvl desc;

    Run a query to Download Data