saeedmzn[Avalanche active users (2024)] - Total
Updated 2024-05-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
›
⌄
with txns as (
select BLOCK_TIMESTAMP::date date ,
FROM_ADDRESS user ,
TX_HASH ,
TX_FEE
from avalanche.core.fact_transactions
where BLOCK_TIMESTAMP::date >= '2024-01-01'
and status = 'SUCCESS'
),
avax_price as (
select date_trunc ('day',HOUR)::Date date ,
median(price) price
from avalanche.price.ez_prices_hourly
where SYMBOL ='AVAX'
and date_trunc ('day',HOUR)::Date >= '2024-01-01'
group by 1
),
final as (
select
date ,
user ,
TX_HASH ,
TX_FEE ,
TX_FEE * price TX_FEE_USD
from txns left join avax_price using (date)
)
select count (tx_hash) num_transactions ,
count (DISTINCT user ) num_users ,
sum (TX_FEE) paid_fees_amount,
sum (TX_FEE_USD) paid_fees_amount_USD,
num_transactions / num_users avg_transactions_per_user,
paid_fees_amount / num_users "avg paid fees per wallet"
from final
QueryRunArchived: QueryRun has been archived