lagandispenserTop 10 Asa's Hold
Updated 2022-06-14
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 top_ten as (
select distinct asset_name, count(distinct address) as holders, asset_added_at
from algorand.account_asset where
amount>0 and amount is not null
and (
asset_name = 'PLANET'
or
asset_name = 'Yieldly'
or
asset_name = 'Tinyman Pool USDC-ALGO'
or
asset_name = 'Tether USDt'
or
asset_name = 'USDC'
or
asset_name = 'Boom'
or
asset_name = 'Kitsune Inu'
or
asset_name = 'Crypto Knight'
or
asset_name = 'KittenCoin'
or
asset_name = 'Boobs'
)
group by 1, 3
),
datetimes as (
select
trunc(a.block_timestamp,'day') as date,
b.asset_name,
b.holders
from top_ten b, algorand.block a where a.block_id = b.asset_added_at
group by 1,2,3
Run a query to Download Data