theericstoneUniswap TVL for Selected Pools
    Updated 2021-02-08
    SELECT
    balance_date,
    address_name as pool,
    sum(amount_usd) as tvl
    FROM gold.ethereum_erc20_balances
    WHERE user_address IN (
    '0x0d4a11d5eeaac28ec3f61d100daf4d40471f1852', --ETH/USDT
    '0xb4e16d0168e52d35cacd2c6185b44281ec28c9dc', --ETH/USDC
    '0xa478c2975ab1ea89e8196811f51a7b7ade33eb11', -- ETH/DAI
    '0xbb2b8038a1640196fbe3e38816f3e67cba72d940' --ETH/WBTC
    )
    AND
    /*symbol in (
    'USDT','WETH','USDC','DAI','WBTC'
    )*/
    contract_address IN (
    '0xdac17f958d2ee523a2206206994597c13d831ec7', --USDT
    '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2',--WETH
    '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48',--USDC
    '0x6b175474e89094c44da98b954eedeac495271d0f',--DAI
    '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599'--WBTC
    )
    AND balance_date > '2020-09-12' AND balance_date < '2020-12-17'
    GROUP BY 1,2
    ORDER BY 1,2 DESC

    Run a query to Download Data