maybeyonasalgo_stable_holders
Updated 2022-02-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
asset_name,
count(distinct address) as holders,
sum(amount)/pow(10,6) as amount
from algorand.account_asset
where asset_id in (
31566704, --USDC
312769 --USDT
)
and address not in (
'XIU7HGGAJ3QOTATPDSIIHPFVKMICXKHMOR2FJKHTVLII4FAOA3CYZQDLG4', --usdt
'2UEQTE5QDNXPI7M3TU44G6SYKLFWLPQO7EBZM7K7MHMQQMFI4QJPLHQFHM' --usdc
)
and amount > 0
and asset_closed = FALSE
group by 1
limit 100
Run a query to Download Data