0xHaM-daUSD Holders
Updated 2025-03-26
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 aUSD & avUSD Holders @ https://flipsidecrypto.xyz/studio/queries/676ba955-464e-4044-8352-a2eb8b7505a0
with avUSD_sendt as (
select
from_address as Sender,
sum (amount) as Sent_Volume
from avalanche.core.ez_token_transfers
where contract_address = '0x24de8771bc5ddb3362db529fc3358f2df3a0e346'
group by 1
),
avUSD_receivet as (
select
to_address as Receiver,
sum (amount) as Received_Volume
from avalanche.core.ez_token_transfers
where contract_address = '0x24de8771bc5ddb3362db529fc3358f2df3a0e346'
group by 1
)
,
aUSD_receivet as (
select
to_address as Receiver,
coalesce (sum (amount),0) as Received_Volume
from avalanche.core.ez_token_transfers
where contract_address = '0xabe7a9dfda35230ff60d1590a929ae0644c47dc1'
and to_address not in ('0x0000000000000000000000000000000000000000','0x000000000000000000000000000000000000dead')
group by 1
)
,
aUSD_sendt as (
select
from_address as Sender,
coalesce (sum (amount),0) as Sent_Volume
from avalanche.core.ez_token_transfers
where contract_address = '0xabe7a9dfda35230ff60d1590a929ae0644c47dc1'
group by 1
QueryRunArchived: QueryRun has been archived