rcepdaPool Balances
    Updated 2023-07-06
    SELECT date_trunc('month', block_timestamp) as metric_date,
    symbol,
    contract_address,
    avg(current_bal_usd) as balance,
    label,
    address_name,
    address
    FROM ethereum.core.ez_balance_deltas INNER JOIN ethereum.core.dim_labels ON ethereum.core.ez_balance_deltas.user_address = ethereum.core.dim_labels.address
    WHERE
    -- the user address is the Curve Liquidty Pool
    --user_address = '0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7' AND
    -- the contract address is the USDC proxy contract
    --contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' AND
    block_timestamp >= getdate() - interval '24 months'
    and label_subtype='pool' AND current_bal_usd > 500000
    GROUP BY metric_date, symbol, contract_address,label,address_name ,address
    Run a query to Download Data