nitsUSDT Address Stats
Updated 2022-02-11
9
1
2
3
4
5
6
7
›
⌄
SELECT date(block_timestamp) as day, count(DISTINCT address) as unique_addresses, sum(unique_addresses) over(order by day) as cumulative_addresses from
(SELECT * from (select*
from algorand.account_asset
where ASSET_ID='312769' and asset_closed = 'FALSE')
inner join algorand.block
on asset_added_at = block_id )
GROUP by 1
Run a query to Download Data