farid-c9j0VMnear mints
    Updated 2022-10-24
    SELECT
    COUNT(DISTINCT tx_hash) AS mints,
    COUNT(DISTINCT tx_signer) AS minters,
    COUNT(DISTINCT tx_receiver) AS collections,
    COUNT(DISTINCT TRY_PARSE_JSON(REPLACE(tx:receipt[0]:outcome:logs[0], 'EVENT_JSON:')):data[0]:token_ids[0]) AS nfts,
    SUM(tx:actions[0]:FunctionCall:deposit / POW(10, 24)) AS volume,
    AVG(tx:actions[0]:FunctionCall:deposit / POW(10, 24)) AS price
    FROM
    near.core.fact_transactions
    WHERE
    block_timestamp::date >= '2022-01-01'
    AND SPLIT_PART(tx:receipt[0]:outcome:status, '"', 2) = 'SuccessValue'
    AND tx:actions[0]:FunctionCall:method_name = 'nft_mint'
    Run a query to Download Data