bertaNFT 5.2
    Updated 2023-01-06
    select project_name, count (distinct tx_hash) as count_transactions,
    count (distinct nft_to_address) as count_users,
    ifnull(sum(mint_price_usd),0) as USD_Volume
    from ethereum.core.ez_nft_mints, ethereum.core.dim_labels
    where block_timestamp >= '2021-01-01' and block_timestamp < '2022-01-01' and nft_address = address
    and mint_price_usd > 0 and project_name is not null
    group by 1
    order by 3 DESC
    limit {{count_mint_projects}}
    Run a query to Download Data