piperBase - NFT Collections by size
    Updated 2023-11-07
    SELECT
    --BLOCK_TIMESTAMP as date,
    PROJECT_NAME AS "NFT Collection",
    COUNT(TX_HASH) AS "NFTs minted"
    FROM
    base.core.ez_nft_transfers
    WHERE
    EVENT_TYPE = 'mint'
    AND
    PROJECT_NAME != ''
    GROUP BY 1
    ORDER BY 2 DESC
    Run a query to Download Data