saber-jltps on polygon vs optimism
Updated 2023-02-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with poly as (
select
count(distinct tx_hash) as poly_tx,
poly_tx/(86400 * 90) as poly_tps
from polygon.core.fact_transactions
where STATUS = 'SUCCESS'
and block_timestamp::date >= current_date - 90
),
op as (
select
count(distinct tx_hash) as op_tx,
op_tx/(86400 * 90) as op_tps
from optimism.core.fact_transactions
where STATUS = 'SUCCESS'
and block_timestamp::date >= current_date - 90
)
select * , 'Optimism' as type from op
union
select * , 'Polygon' as type from poly
Run a query to Download Data