nimasadjadiOptimism network performance in June and in July
Updated 2022-08-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
WITH July AS (
SELECT
date_trunc ('day', block_timestamp) AS daily_July,
COUNT (DISTINCT tx_hash) AS TX_July,
sum (eth_VALUE) AS SUM_ETH_VALUE_July
FROM optimism.core.fact_transactions
WHERE BLOCK_TIMESTAMP BETWEEN '2022-07-01' AND '2022-07-31'
GROUP BY daily_July
ORDER BY daily_July),
June AS (
SELECT
date_trunc ('day', block_timestamp) AS daily_June,
COUNT (DISTINCT tx_hash) AS TX_June,
sum (eth_VALUE) AS SUM_ETH_VALUE_June
FROM optimism.core.fact_transactions
WHERE block_timestamp BETWEEN '2022-06-01' AND '2022-06-30'
GROUP BY daily_June
ORDER BY daily_June
)
SELECT
July.daily_July,
July.TX_July,
July.SUM_ETH_VALUE_July,
June.daily_June,
June.TX_June,
June.SUM_ETH_VALUE_June
FROM July JOIN June
ORDER BY daily_June, daily_July
Run a query to Download Data