metricsdao101 C4W2Q2
    Updated 2023-03-06
    SELECT
    block_timestamp::date AS _date
    ,count(tokenid) AS n_nft_mints
    ,count(distinct tx_hash) AS n_tx
    ,count(distinct nft_to_address) AS n_minter_wallets
    ,sum(mint_price_eth) AS total_eth_raised
    ,sum(mint_price_usd) AS total_usd_raised
    ,sum(tx_fee) AS total_tx_fees_paid_eth
    FROM ethereum.core.ez_nft_mints
    WHERE nft_address = lower('0xed5af388653567af2f388e6224dc7c4b3241c544')
    GROUP BY _date
    -- ORDER BY n_nft_mints DESC
    Run a query to Download Data