HippynonsenseUntitled Query
    Updated 2021-12-09
    SELECT
    date_trunc('day', balance_date) as metric_date,
    symbol,
    amount_usd
    FROM ethereum.erc20_balances
    WHERE
    -- the user address is the Curve Liquidty Pool
    user_address = '0xa5407eae9ba41422680e2e00537571bcc53efbfd' AND
    -- the contract address is the USDC proxy contract
    contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' AND
    balance_date >= getdate() - interval '1 month'
    Run a query to Download Data