nsa2000FLS1
Updated 2022-12-12
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc('day',block_timestamp::date) as "Date" ,
count(distinct tx_id) as "Number of Daily Transactions",
count(distinct PROPOSER) as "Number of Daily Users",
("Number of Daily Transactions"/1440) as "Transactions per Minute", ("Number of Daily Transactions"/86400) as "Transactions per second",
("Number of Daily Transactions"/"Number of Daily Users") as "Tx/User"
from flow.core.fact_transactions
where block_timestamp >= '2022-01-01'
and TX_SUCCEEDED = true
group by 1
order by 1
Run a query to Download Data