yasmin-- 10 NFT Mints and Sales Volume Count of NFT mints, sales and sum of sales in USD
    Updated 2025-03-11
    -- forked from cloudr3n / Avax NFT Trading Volume @ https://flipsidecrypto.xyz/cloudr3n/q/YNNC6_TfoAoe/avax-nft-trading-volume

    -- 7 Stablecoin to Non-Stable Sales Dex sell of an asset NOT in the stablecoin list to an asset in the stablecoin list
    -- 8 Primary Asset Deposits Gas token or proprietary token lending deposits
    -- 9 Stablecoin borrows Borrows of tokens in the list of stablecoins
    -- 10 NFT Mints and Sales Volume Count of NFT mints, sales and sum of sales in USD
    -- 11 Developer Contract/Program depolyments Count of daily contract deployments
    ----------10-----------------
    WITH nft_mint AS (
    SELECT
    DATE_TRUNC('day', block_timestamp) AS day,
    COUNT(DISTINCT ez_nft_transfers_id) AS nft_mint
    FROM avalanche.nft.ez_nft_transfers
    WHERE EVENT_TYPE = 'mint'
    and block_timestamp >= DATEADD(month, -1, CURRENT_DATE())
    GROUP BY day
    ),
    nft_sales AS (
    SELECT day,
    SUM(nft_sale_usd) AS nft_sale_usd,
    SUM(tx) AS tx,
    SUM(SUM(nft_sale_usd)) OVER (ORDER BY day) AS cumulative_nft_sales_usd
    FROM (SELECT DATE(block_timestamp) AS day,
    SUM(price_usd) AS nft_sale_usd,
    COUNT(*) AS tx
    FROM avalanche.nft.ez_nft_sales
    WHERE block_timestamp >= DATEADD(month, -1, CURRENT_DATE())
    GROUP BY 1
    UNION ALL
    -- Hyperspace Sales--------------
    SELECT DATE(l.block_timestamp) AS day,
    SUM(l.decoded_log:erc20TokenAmount * POW(10, -18) * p.price) AS nft_sale_usd,
    COUNT(*) AS tx
    FROM avalanche.core.ez_decoded_event_logs l
    LEFT JOIN avalanche.price.ez_prices_hourly p
    ON DATE_TRUNC('hour', l.block_timestamp) = p.hour
    QueryRunArchived: QueryRun has been archived