headitmanagerDaily creation of NFT owned wallets
Updated 2022-06-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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