john-adamUntitled Query
    Updated 2022-10-19
    with tbltemp as (select distinct TX_RECEIVER from near.core.ez_nft_mints )
    select date_trunc('day', t.block_timestamp) , count(distinct t.TX_HASH) , count (distinct t.TX_SIGNER) , sum(t.TRANSACTION_FEE / 1e24 )
    from near.core.fact_transactions as t inner join tbltemp as tt
    on t.TX_RECEIVER=tt.TX_RECEIVER
    where t.TX_STATUS='Success'
    and date_trunc('day', t.block_timestamp) > getdate() - interval '90 days'
    group by 1
    Run a query to Download Data