ramishoowUntitled Query
Updated 2023-07-04
9
1
2
3
4
5
›
⌄
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