afonsoUntitled Query
Updated 2023-01-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with t as (
select
block_timestamp::date as day,
count(distinct tx_hash) as txns_count,
count(distinct tx_signer) as active_wallets_count
from near.core.fact_transactions
where block_timestamp >= '2022-12-01'
group by day
order by day
)
select
avg(txns_count) as average_txns_count,
avg(active_wallets_count) as average_active_wallets_count
from t
Run a query to Download Data