rackhaelAAVE STAKING ACTIVITY
    Updated 2023-06-05
    SELECT date_trunc('day',block_timestamp) as date,
    sum(SUPPLIED_USD) total_deposits,
    avg(SUPPLIED_USD) AS average_deposits,
    count(distinct TX_HASH),
    count(distinct DEPOSITOR_ADDRESS)AS depositors,
    avg(token_price) as token_price
    FROM ethereum.aave.ez_deposits
    WHERE block_timestamp::date >= '2023-01-01'
    AND SYMBOL='AAVE'
    GROUP BY 1



    /* Visualizations depicting the daily, weekly and/or monthly movements of AAVE tokens on the
    Aave protocol specifically occurring on the Ethereum Mainnet, including both supply and
    withdrawal activities, as well as the daily staking and unstaking of AAVE tokens */

    Run a query to Download Data