Hessish1g - mint t2
    Updated 2025-03-28
    -- forked from 1g - mint ov @ https://flipsidecrypto.xyz/studio/queries/15badd62-4452-405a-8125-6f295640e697

    with mnts as (select
    BLOCK_TIMESTAMP,
    TOKENID,
    TO_ADDRESS,
    TX_HASH
    from ethereum.nft.ez_nft_transfers
    where --tx_hash = '0xe2b5084ea66af96d317bec749e5a9be47553d689e26892293f6176e2daa9f64b'
    EVENT_TYPE = 'mint'
    and FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
    and NFT_ADDRESS = '0xf39c410dac956ba98004f411e182fb4eed595270'
    )

    select
    count(distinct TO_ADDRESS) as "Minters"
    from mnts
    group by all





    Last run: 14 days ago
    Minters
    1
    1395
    1
    8B
    3s