adriaparcerisasavalanche euro 5
Updated 2025-03-25
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
›
⌄
with
transfers_in as (
select
to_address,
sum(amount) as volume
from avalanche.core.ez_token_transfers
where contract_address = lower('0xC891EB4cbdEFf6e073e859e987815Ed1505c2ACD')
and block_timestamp >= '2023-05-25' and to_address<>'0x0000000000000000000000000000000000000000'
group by 1
),
transfers_out as (
select
from_address,
sum(amount) as volume
from avalanche.core.ez_token_transfers
where contract_address = lower('0xC891EB4cbdEFf6e073e859e987815Ed1505c2ACD')
and block_timestamp >= '2023-05-25' and (from_address<>'0x0000000000000000000000000000000000000000')
group by 1
),
final_transfers as (
SELECT
ifnull(x.to_address,y.from_address) as wallet,
ifnull(x.volume,0)-ifnull(y.volume,0) as total_netflow
from transfers_in x left join transfers_out y on x.to_address=y.from_address
)
select count (distinct wallet) as holders, avg(total_netflow) as avg_holdings, sum(total_netflow) as total_holdings
from final_transfers where total_netflow>0.000001
QueryRunArchived: QueryRun has been archived