BALANCES | HOLDERS | AVG_HOLDINGS | TOTAL_HOLDINGS | |
|---|---|---|---|---|
1 | 1. >100k EUROC | 6 | 476197.358172497 | 2857184.14903498 |
2 | 2. 10k-100k EUROC | 8 | 48214.451936128 | 385715.61548902 |
3 | 3. 1k-10k EUROC | 30 | 2152.447272767 | 64573.418182999 |
4 | 4. 100-1k EUROC | 185 | 252.30401067 | 46676.241973939 |
5 | 5. 10-100 EUROC | 597 | 26.592167697 | 15875.524115004 |
6 | 6. 1-10 EUROC | 1336 | 3.540105701 | 4729.581216001 |
7 | 7. <1 EUROC | 1017 | 0.1135886637 | 115.519670987 |
adriaparcerisasavalanche euro 5.3
Updated 10 days ago
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
35
36
›
⌄
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
case when total_netflow>100000 then '1. >100k EUROC'
when total_netflow between 10000 and 100000 then '2. 10k-100k EUROC'
when total_netflow between 1000 and 10000 then '3. 1k-10k EUROC'
when total_netflow between 100 and 1000 then '4. 100-1k EUROC'
when total_netflow between 10 and 100 then '5. 10-100 EUROC'
when total_netflow between 1 and 10 then '6. 1-10 EUROC'
else '7. <1 EUROC' end as balances,
count (distinct wallet) as holders,
avg(total_netflow) as avg_holdings,
Last run: 10 days ago
7
370B
7s