MLDZMNnft2
    Updated 2023-09-03
    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