ramishoowUntitled Query
    Updated 2023-07-04
    select tx:actions[0]:FunctionCall:method_name as action_names, count(tx_hash) as transactions, COUNT (DISTINCT tx_signer) as unique_users, sum(tx:actions[0]:FunctionCall:deposit/1e24) as near_amount
    --from near.core.fact_transactions where action_names in ('nft_mint','buy','nft_buy' ,'add_offer','nft_transfer') and tx_status = 'Success' and block_timestamp >=CURRENT_DATE - 90 GROUP by action_names

    from near.core.fact_transactions where action_names in ('nft_mint','buy','nft_buy' ,'add_offer','nft_transfer') and tx_status = 'Success' and block_timestamp >=CURRENT_DATE - 90 GROUP by action_names

    Run a query to Download Data