mondovNumber of $JOE Holders and Their Average Median Balance copy
Updated 2023-10-30
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
›
⌄
-- forked from fa88924f-d427-4d1c-9d3f-cb27e704144d
with
receivetable as (
select
to_address as receiver,
sum(raw_amount / 1e18) as Received_Volume
from
avalanche.core.fact_token_transfers
where
contract_address = '0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd'
group by
1
),
sendtable as (
select
from_address as sender,
sum(raw_amount / 1e18) as sent_volume
from
avalanche.core.fact_token_transfers
where
contract_address = '0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd'
group by
1
),
balancetable as (
select
sender as JOE_Holder,
sum(received_volume - sent_volume) as JOE_Balance
from
receivetable t1
join sendtable t2 on t1.receiver = t2.sender
group by
1
having
JOE_Balance > 0
)
Run a query to Download Data