check_skedARB OP 1 Week TPS
Updated 2023-08-09Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
SELECT
arb.TXS AS ARB_TXS,
arb.TXS / 604800.0 AS ARB_TPS,
op.TXS AS OP_TXS,
op.TXS / 604800.0 AS OP_TPS
FROM
(
SELECT
COUNT(DISTINCT TX_HASH) AS TXS
FROM
arbitrum.core.fact_transactions
WHERE
block_timestamp >= CURRENT_DATE - INTERVAL '7 day'
) arb,
(
SELECT
COUNT(DISTINCT TX_HASH) AS TXS
FROM
optimism.core.fact_transactions
WHERE
block_timestamp >= CURRENT_DATE - INTERVAL '7 day'
) op;
Run a query to Download Data