ramishoow2023-02-21 09:22 PM
    Updated 2023-02-21
    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