MLDZMNnft2
Updated 2023-09-03
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc('month',s.block_timestamp) as date,
project_name,
count(distinct s.tx_hash) as no_mints,
count(distinct a.NFT_TO_ADDRESS) as no_users,
count(distinct TOKENID) as no_nfts
from avalanche.core.fact_transactions s
left join avalanche.core.ez_nft_transfers a on s.tx_hash=a.tx_hash
where to_address='0x13d8c4e3741e968cc8e740bdb02537cb1d2d70e6'
and EVENT_TYPE = 'mint'
and project_name != 'Galxe OAT'
group by 1,2 having project_name is not null
Run a query to Download Data