KARTODShroomDK Mint
    Updated 2022-07-01
    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