freemartianNFT Mint - Stand with Crypto Hourly
    Updated 2023-08-17
    -- forked from NFT Mint - Stand with Crypto @ https://flipsidecrypto.xyz/edit/queries/d780b56b-e20d-41d1-8d46-36b9f38f570d

    -- forked from On-Chain Summer NFTs Total - Day 0 to 3 @ https://flipsidecrypto.xyz/edit/queries/23178b3f-e51c-495c-b098-601f13d10722

    -- forked from Bridge to Base NFT #1 quest Totals @ https://flipsidecrypto.xyz/edit/queries/b1903ab4-23a4-4c2d-b07a-d93fa3b0443b

    with mints as (
    select * from base.core.ez_nft_transfers
    where nft_address = '0x874ad7c13935f73c7bbe94efbd8e766de2a585eb'
    and event_type = 'mint')

    select
    date_trunc('hour', block_timestamp) as time,
    count(distinct nft_to_address) as Unique_minters,
    count(tx_hash) as Total_mints
    from mints
    group by 1


    Run a query to Download Data