binhachonNew Wallets from NFTs - #6
Updated 2022-06-07
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 wallet_list as (
select
address,
created_at,
balance,
block_timestamp
from flipside_prod_db.algorand.account
inner join flipside_prod_db.algorand.block on (block_id = created_at)
where account_closed = 'FALSE'
and balance > 1
),
NFT_list as (
select
asset_id
from flipside_prod_db.algorand.asset
where total_supply = 1
and decimals = 0
),
arc69_NFT_list as (
select
asset_id
from flipside_prod_db.algorand.asset_configuration_transaction
where asset_id in (select asset_id from NFT_list)
and try_parse_json(try_base64_decode_string(tx_message:txn:note::string)):standard::string = 'arc69'
),
address_with_NFT as (
select
asset_receiver as NFT_address,
count(distinct asset_id) as number_of_NFTs
from flipside_prod_db.algorand.asset_transfer_transaction
where NFT_address in (select address from wallet_list)
and asset_id in (select asset_id from arc69_NFT_list)
and block_timestamp::date >= '2022-05-01'
group by 1
),
address_with_NFT_1 as (
Run a query to Download Data