Elprognerd3-NFT Monthly mints
    Updated 2023-01-05
    select
    date_trunc('month', Block_timestamp) as "Date",
    count(distinct tx_hash) as "Number of Mints",
    count(distinct nft_to_address) as "Number of Minters",
    count(distinct tokenid) as "Number Minted NFTs",
    sum (mint_price_usd) as "Total Minted Volume (USD)",
    avg (mint_price_usd) as "Average Minted Volume (USD)"
    from ethereum.core.ez_nft_mints
    where block_timestamp >= '2022-01-01' and block_timestamp <= '2022-12-30'
    GROUP BY 1
    ORDER BY 1
    Run a query to Download Data