nitsDaily assets added
Updated 2023-01-02
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT date(block_timestamp) as day, count(DISTINCT asset_id ) as total_assets, sum(total_supply) as total_asset_supply,
sum(total_asset_supply) over (order by day) as cum_asset_supply,
sum(total_assets) over (order by day) as cum_assets
from
(SELECT * from
(SELECT * from algorand.asset
where creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA' and asset_deleted= 'FALSE')
inner JOIN algorand.block
on created_at = block_id )
GROUP by 1
-- limit 100
Run a query to Download Data