freemartianOn-Chain Summer New Era BTC ETH
    Updated 2023-09-01
    -- forked from On-Chain Summer New Era ETH @ https://flipsidecrypto.xyz/edit/queries/58a2bfab-ea4e-4a71-aefd-6d15ca943dd5

    -- 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 in ('0x05b8ee5658f3ad6c268c08b7a70f2fb4b10cf348', '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,
    case
    when nft_address = '0xc9cca8e570f81a7476760279b5b19cc1130b7580' then 'New Era ETH'
    when nft_address = '0x05b8ee5658f3ad6c268c08b7a70f2fb4b10cf348' then 'New Era BTC'
    end as Type
    from mints
    where block_timestamp > '2023-08-10 15:00:00.000'
    group by time, type




    Run a query to Download Data