ramishoow2023-02-21 09:22 PM
Updated 2023-02-21
9
1
2
3
4
5
6
7
8
›
⌄
with ramishow as (SELECT Block_timestamp, TX_SIGNER, tx_hash,
TRY_PARSE_JSON(REPLACE(tx:receipt[0]:outcome:logs[0], 'EVENT_JSON:')):data[0]:token_ids[0] AS NFT,
tx:actions[0]:FunctionCall:deposit / 1e24 AS Volume from near.core.fact_transactions
where tx:actions[0]:FunctionCall:method_name = 'nft_buy') SELECT--ramishow
COUNT(DISTINCT TX_SIGNER) as Total_Number_of_NFT_Buyers, COUNT(DISTINCT tx_hash) as Total_Number_of_NFT_Sales,
COUNT(DISTINCT NFT) as Total_Number_of_Sold_NFTs, sum(Volume) as Total_Volume_of_Sold_NFTs
from ramishow where block_timestamp >= CURRENT_DATE - INTERVAL '14 days'--ramishow
Run a query to Download Data