amirozaholders wallets created over time.
Updated 2022-07-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
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