Updated 2023-01-07
9
1
2
3
4
5
6
7
8
9
›
⌄
with transfers as (select count(distinct tx_hash) as transfer_count ,count(distinct tx_signer) as users_count , sum(deposit/1e18) as trasnfer_amount
, block_timestamp::date as dt
from near.core.fact_transfers
group by dt)
select min(transfer_count) , max(transfer_count) , avg(transfer_count) , median(transfer_count) from transfers where dt>= '2022-12-01' and dt!=CURRENT_DATE
Run a query to Download Data