nitsDaily assets added
    Updated 2023-01-02
    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