Updated 2020-11-24
    -- APY lets you lock DAI, USDC, and USDT for the purposes of options

    SELECT
    balance_date,
    contract_address,
    symbol,
    sum(amount_usd) as total_value_locked
    FROM gold.ethereum_erc20_balances
    WHERE
    user_address in (
    '0x75ce0e501e2e6776fcaaa514f394a88a772a8970', -- APY DAI pool
    '0xe18b0365d5d09f394f84ee56ed29dd2d8d6fba5f', -- APY USDC pool
    '0xea9c5a2717d5ab75afaac340151e73a7e37d99a7') -- APY USDT pool
    AND symbol in ('DAI','USDC','USDT')
    AND amount_usd > 0
    AND balance_date > '2020-08-30'
    GROUP BY 1,2,3
    ORDER BY 1,2,3;



    Run a query to Download Data