MLDZMNusa1
Updated 2024-06-03Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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