flipside

    Base - 'Bridge to Base' mints over time
    piperBase - 'Bridge to Base' mints over time
    Updated 2023-11-07
    SELECT
    TO_CHAR(BLOCK_TIMESTAMP, 'YYYY-MM-DD HH24') AS time,
    COUNT(TX_HASH) AS "Number of mints per hour"
    FROM
    base.core.ez_nft_transfers
    WHERE
    EVENT_TYPE = 'mint'
    AND
    PROJECT_NAME = 'Bridge to Base'
    GROUP BY time
    ORDER BY 2 DESC
    Run a query to Download Data