farid-c9j0VMnear mints
Updated 2022-10-24Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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