elsina✅daily information
Updated 2022-07-22
9
1
2
3
4
5
6
7
8
›
⌄
select date_trunc('day', block_timestamp) as "date",
count(tx_hash) as "tx_count",
count(distinct from_address) as "unique_address",
count(tx_hash) / 1440 as "tx_per_min",
(sum(iff(status = 'SUCCESS', 1, 0)) / count(*)) * 100 as "success_rate"
from optimism.core.fact_transactions
where "date" <= current_date - 1
group by 1
Run a query to Download Data