saeide-ahmadi-7Art Gobblers: mint activity (Aggregate data)
    Updated 2022-11-03
    SELECT

    count(DISTINCT tx_hash) as "the total number of mints",
    count(DISTINCT NFT_TO_ADDRESS) as "the total number of unique minters" ,
    SUM(TX_FEE) AS "total paid fee in ETH",
    avg(TX_FEE) AS "average fee in total",
    sum(MINT_PRICE_ETH) as "total sum of mint prices in ETH" ,
    SUM(MINT_PRICE_USD) AS "total sum of mint prices in USD" ,
    avg(MINT_PRICE_ETH) as "totaly average mint prices in ETH" ,
    avg(MINT_PRICE_USD) AS "totaly average mint prices in USD"

    FROM ethereum.core.ez_nft_mints
    WHERE nft_address LIKE lower('0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769')

    Run a query to Download Data