pouya_22Aave_deposits
    Updated 2023-11-02
    SELECT date_trunc(month, block_timestamp) date,
    symbol,
    count(DISTINCT tx_hash) txs,
    count(DISTINCT depositor_address) users,
    sum(supplied_usd) vol,
    txs / users as tx_per_user,
    vol / txs as vol_per_tx
    FROM ethereum.aave.ez_deposits
    WHERE symbol IS NOT NULL
    GROUP BY 1,2
    Run a query to Download Data