keshan1M algorand - assets
Updated 2022-05-15
9
1
2
3
4
5
6
7
8
9
›
⌄
select count(address) number_of_wallets, asset_name, sum(amount) as amount
from flipside_prod_db.algorand.account_asset
where address in (select address
from flipside_prod_db.algorand.account a inner join flipside_prod_db.algorand.block b on a.created_at=b.block_id
where b.block_timestamp between '2022-5-4' and '2022-5-11' -- This will fetch only data from 4th to 10th (excluding 11th)
)
group by asset_name
order by number_of_wallets desc
limit 100
Run a query to Download Data