headitmanagerDaily creation of NFT owned wallets
    Updated 2022-06-21
    with asset_ides as (select asset_id from algorand.asset where asset_name like 'Warrior Croc%' and
    (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU'
    or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ'))
    , wallet_address as (select sum(amount) as Wildlife_amount,address from algorand.account_asset
    inner join asset_ides
    on algorand.account_asset.asset_id =asset_ides.asset_id
    group by address
    having sum(amount)>0)
    ,wallet_created_at as (select block_timestamp::date, count(1) from algorand.account inner join wallet_address on algorand.account.address=wallet_address.address
    inner join algorand.block on block_id=created_at
    group by block_timestamp::date)
    , drop_or_established as (select count(asset_id) as cnt, address,case when cnt > 1 then 'established' else 'drop' end as de
    , 1 from algorand.account_asset where address in (select address from wallet_address)
    group by address
    )
    ,algo_balance as (select sum(balance) as ALGO_balance,algorand.account.address from algorand.account inner join wallet_address
    on algorand.account.address=wallet_address.address
    group by algorand.account.address)


    select * from wallet_created_at
    Run a query to Download Data