freemartianOn-Chain Summer New Era ETH
    Updated 2023-09-10
    -- forked from On-Chain Summer BtB Hourly @ https://flipsidecrypto.xyz/edit/queries/d8aa39bb-d071-485e-bd7a-064566de4ee7

    -- 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 = '0xc9cca8e570f81a7476760279b5b19cc1130b7580'
    and event_type = 'mint')

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



    Run a query to Download Data