Eman-RazNumber of $AI Holders on Different Chains
Updated 2024-09-18
999
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 arbitrum as (with tab2 as (with tab1 as (select to_address as user, sum(amount) as amount
from arbitrum.core.ez_token_transfers
where contract_address=lower('0x2598c30330D5771AE9F983979209486aE26dE875')
group by 1
union all
select from_address as user, -sum(amount) as amount
from arbitrum.core.ez_token_transfers
where contract_address=lower('0x2598c30330D5771AE9F983979209486aE26dE875')
group by 1)
select user, sum(amount) as balance
from tab1
where user<>'0x0000000000000000000000000000000000000000'
group by 1
order by 2 desc)
select count(distinct user) as "Holders Count", 'Arbitrum' as "Chain"
from tab2
where balance>0),
-----
-----
avalanche as (with tab2 as (with tab1 as (select to_address as user, sum(amount) as amount
from avalanche.core.ez_token_transfers
where contract_address=lower('0x2598c30330D5771AE9F983979209486aE26dE875')
group by 1
union all
select from_address as user, -sum(amount) as amount
from avalanche.core.ez_token_transfers
where contract_address=lower('0x2598c30330D5771AE9F983979209486aE26dE875')
group by 1)
QueryRunArchived: QueryRun has been archived