hessTotal
Updated 2024-09-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with final as ( select trader as user,
tx_hash,
amount_usd as volume_usd
from blast.blitz.ez_clearing_house_events
where MODIFICATION_TYPE = 'deposit')
select
count(DISTINCT user) as users,
count(DISTINCT tx_hash) as total_tx,
sum(volume_usd) as volume,
volume/users as avg_vol_per_user,
total_tx/users as avg_deposit_per_user,
avg(volume_usd) as avg_volume,
median(volume_usd) as median_usd,
max(volume_usd) as max_usd
from final
QueryRunArchived: QueryRun has been archived