KARTODShroomDK Mint
Updated 2022-07-01Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
MIN(BLOCK_TIMESTAMP) AS "First Mint",
MAX(BLOCK_TIMESTAMP) AS "Last Mint",
COUNT(DISTINCT "TX_HASH") AS "Mints",
COUNT(DISTINCT NFT_TO_ADDRESS) AS "Minetrs",
SUM(TX_FEE) AS "Gas Spent on Mints (ETH)",
SUM(TX_FEE)*AVG(PRICE) AS "Gas Spent on Mints (USD)",
"Mints"/"Minetrs" AS "Mints Per Address"
FROM ethereum.core.ez_nft_mints
LEFT JOIN ethereum.core.fact_hourly_token_prices ON DATE_TRUNC('hour', BLOCK_TIMESTAMP) = HOUR AND SYMBOL = 'WETH'
WHERE NFT_ADDRESS = '0xdfb57b6e16ddb97aeb8847386989f4dca7202146'
Run a query to Download Data