flipside

    Base - 'Bridge to Base' mints per wallet
    piperBase - 'Bridge to Base' mints per wallet
    Updated 2023-08-07
    SELECT
    NFT_TO_ADDRESS,
    COUNT(TX_HASH) AS "Number of mints"
    FROM
    base.core.ez_nft_transfers
    WHERE
    EVENT_TYPE = 'mint'
    AND
    PROJECT_NAME = 'Bridge to Base'
    GROUP BY 1
    ORDER BY 2 DESC
    Run a query to Download Data