ramishoowUntitled Query
    Updated 2022-10-19
    with ramishow as (select distinct TX_RECEIVER from near.core.ez_nft_mints ) select date_trunc('month', ra.block_timestamp)as "date" , count(distinct ra.TX_HASH)as "Transactions " , count (distinct ra.TX_SIGNER) as "Users ", sum(ra.TRANSACTION_FEE / 1e24 ) as "Transactions Fee"
    from near.core.fact_transactions as ra inner join ramishow as r on ra.TX_RECEIVER=r.TX_RECEIVER where ra.TX_STATUS='Success' and date_trunc('day', ra.block_timestamp) > getdate() - interval '90 days' group by 1
    Run a query to Download Data