Elprognerd5 - total transactions
Updated 2023-03-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
'Arbitrum' as chain,
count(*) as "Number of TXs",
count(distinct from_address) as "Number of users"
from arbitrum.core.fact_transactions
where block_timestamp >= '2023-01-01'
group by 1
union all
select
'Optimism' as chain,
count(*) as "Number of TXs",
count(distinct from_address) as "Number of users"
from optimism.core.fact_transactions
where block_timestamp >= '2023-01-01'
group by 1
Run a query to Download Data