Monitize AIAI Arena Mint Pass NFT Holders
Updated 2024-07-15
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 claimert as (
select
distinct TO_ADDRESS as claimer,
sum(amount) as claimed_amount
from arbitrum.core.ez_token_transfers
where CONTRACT_ADDRESS = lower('0xdadeca1167fe47499e53Eb50F261103630974905')
and FROM_ADDRESS = lower('0xb063f2af926af95f08515fd9d5f2397ce97148bf')
and ORIGIN_FUNCTION_SIGNATURE = '0x2f0879f7'
group by 1
),
holdert as (
select
distinct holder,
--BLOCK_TIMESTAMP as "Transfer Date",
count(distinct TOKENID) as NFTs
from(
select
TOKENID,
NFT_TO_ADDRESS as holder,
BLOCK_TIMESTAMP,
row_number() over (partition by TOKENID order by BLOCK_TIMESTAMP desc) as rank
from arbitrum.nft.ez_nft_transfers
where nft_address = lower('0xA4734bf76F511357d4353D88b84204957972Ac84')
)
where rank = 1
group by 1
order by 2 desc)
select
distinct holder,
NFTs,
coalesce(claimed_amount,0) as "Claimed Airdrop"
from holdert left join claimert on claimer = holder
order by 2 desc
QueryRunArchived: QueryRun has been archived