mcfemi6SUPERDOGENFT ANALYSIS
Updated 2022-11-30
9
1
2
3
4
5
6
7
8
9
›
⌄
--Select one or few recent project mints and determine how successful they were
SELECT date_trunc('Month', block_timestamp) "DATE", NFT_COUNT "Number of NFTs Minted", COUNT(DISTINCT TX_HASH) "Number of Transactions",
SUM(MINT_PRICE_ETH) "Total Volume, ETH", Sum(MINT_PRICE_USD) "Total Volume, USD"-- TX_HASH, NFT_TO_ADDRESS
FROM ethereum.core.ez_nft_mints
WHERE PROJECT_NAME = 'SuperDogeNFT'
GROUP BY 1, 2
ORDER BY 1 DESC
Run a query to Download Data