bertaNFT 5.2
Updated 2023-01-06Copy Reference Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
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