john-adamUntitled Query
Updated 2022-10-19
9
1
2
3
4
5
6
7
›
⌄
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