with group_1 as (
select
address
from algorand.account account
join algorand.block block
on account.created_at = block.block_id
where block.block_timestamp::date < '2022-05-01'
and account.balance > 1
and account.account_closed = false
),
arc69_nft_asset_list as (
select
configuration.asset_id as asset_id
from algorand.asset_configuration_transaction configuration
join algorand.asset asset using(asset_id)
where try_parse_json(try_base64_decode_string(configuration.tx_message:txn:note::string)):standard::string = 'arc69'
and asset.total_supply = 1 and asset.decimals = 0
and asset.asset_deleted = false
group by asset_id
),
group_1_arc69_nft as (
select
address
from algorand.account_asset
join group_1 using(address)
where asset_id in (select asset_id from arc69_nft_asset_list)
and amount > 0
and asset_closed = false
group by address
),
group_1_arc69_nft_may_jun as (
select
account.address as address
from algorand.account_asset account
join algorand.block block on block.block_id = account.asset_added_at
where account.address in (select address from group_1_arc69_nft)