headitmanagerwallets got created each day
    Updated 2022-07-14
    with shuffle_asset_ides as (select asset_id from flipside_prod_db.algorand.asset
    where creator_address='CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM')

    ,shuffle_sales_overtime as (select sum(amount), block_timestamp::date
    from algorand.payment_transaction
    where
    (sender='CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'
    or receiver='CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM')
    and block_timestamp::date !='2022-05-19'
    group by block_timestamp::date)
    ,shuffle_algo_sales as (select sum(amount)
    from algorand.payment_transaction
    where
    (sender='CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'
    or receiver='CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM')
    and block_timestamp::date !='2022-05-19')
    ,shuffle_holders as (select sum(amount) as sm,address, case
    when sm = 1 then '1 NFT'
    when sm > 1 and sm < 10 then '1 to 10 NFT'
    when sm>=10 and sm< 100 then '10 to 100 NFT'
    when sm>=100 and sm<1000 then '100 to 1000 NFT'
    when sm>=1000 then 'more than 1000 NFT' end as dist , 1
    from algorand.account_asset inner join shuffle_asset_ides
    on algorand.account_asset.asset_id=shuffle_asset_ides.asset_id
    where address!='CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'
    group by address
    having sum(amount)>0)
    ,shuffle_holders_count as (select count(distinct address)
    from algorand.account_asset inner join shuffle_asset_ides
    on algorand.account_asset.asset_id=shuffle_asset_ides.asset_id
    where address!='CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM' and amount>0)

    ,hold_COSG as (select sum(amount) as COSG,algorand.account_asset.address , case
    Run a query to Download Data