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 when COSG < 10 then 'less than 1 COSG' when COSG > 100000 and COSG < 1000000 then '100K to 1M COSG' when COSG>=1000000 and COSG< 100000000 then '1m to 100M COSG' when COSG>=100000000 and COSG<1000000000 then '100M to 1B COSG' when COSG>=1000000000 then 'more than 1B COSG' end as dist , 1 from algorand.account_asset inner join shuffle_holders on algorand.account_asset.address=shuffle_holders.address where algorand.account_asset.address!='CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM' and amount > 0 and asset_id=571576867 group by 2 ) , hold_algo as (select sum(balance) as ALGO,algorand.account.address , case when ALGO < 1 then 'less than 1 ALGO' when ALGO >= 1 and ALGO < 100 then '1 to 100 ALGO' when ALGO>=100 and ALGO< 1000 then '100 to 1000 ALGO' when ALGO>=1000 and ALGO<10000 then '100 to 10000 ALGO' when ALGO>=10000 then 'more than 10000 ALGO' end as dist , 1 from algorand.account inner join shuffle_holders on algorand.account.address=shuffle_holders.address where algorand.account.address!='CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM' and balance > 0 group by 2) , wallet_created as (select min(block_timestamp::date) as created_date ,sender from algorand.transactions inner join hold_algo on hold_algo.address=sender group by sender ) select count(*),created_date from wallet_created group by created_date