headitmanagerwallets got created each day
Updated 2022-07-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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