freemartianOn-Chain Summer BtB Hourly
    Updated 2023-08-21
    -- 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 = '0xea2a41c02fa86a4901826615f9796e603c6a4491'
    and event_type = 'mint')

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


    Run a query to Download Data