amirozaholders wallets created over time.
    Updated 2022-07-13
    with nfts as (select a.asset_id,total_supply
    from flipside_prod_db.algorand.asset a
    join flipside_prod_db.algorand.block b on a.CREATED_AT=b.BLOCK_ID
    where 1=1
    -- and asset_id in (786130476,786131555)
    and CREATOR_ADDRESS='CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'
    and ASSET_NAME not in ('Cosmic Champs Whitelist TOKEN','SINGULARITY ERA COMMEMORATIVE')
    and ASSET_DELETED='FALSE'
    and b.BLOCK_TIMESTAMP::date >='2022-06-22'),
    holders as (
    select address
    from flipside_prod_db.algorand.account_asset a
    where 1=1
    --and asset_id in (select asset_id from nfts)
    and ASSET_CLOSED=FALSE and AMOUNT>0
    and asset_id in (select asset_id from nfts))
    select b.block_timestamp::date date,count(*) wallets_created
    from flipside_prod_db.algorand.account a
    join flipside_prod_db.algorand.block b on a.CREATED_AT=b.block_id
    where address in ( select address from holders)
    and CLOSED_AT is null and BALANCE>0
    group by 1