MLDZMNusa1
    Updated 2024-06-03
    select
    count(distinct tx_hash) as no_txn,
    count(distinct DEPOSITOR_ADDRESS) as no_users,
    sum(SUPPLIED_USD) as volume,
    avg(SUPPLIED_USD) as avg_volume,
    median(SUPPLIED_USD) as median_volume,
    no_users/count(distinct date_trunc(day, block_timestamp)) as "Average user per day",
    volume/count(distinct date_trunc(day, block_timestamp)) as volume_per_day
    from ethereum.aave.ez_deposits
    where
    BLOCK_TIMESTAMP >= CURRENT_DATE - {{Time_period_days}}
    QueryRunArchived: QueryRun has been archived