kaibladeOptimism vs Arbitrum Transaction Data
Updated 2023-01-16
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
32
33
34
35
36
›
⌄
WITH optimism_daily AS
(SELECT DATE_TRUNC('day',block_timestamp) AS "Days",
COUNT(tx_hash) AS "Total Transaction Volume",
'Optimism' AS chain_type
FROM optimism.core.fact_transactions
WHERE status = 'SUCCESS'
GROUP BY "Days", chain_type),
arbitrum_daily AS
(SELECT DATE_TRUNC('day',block_timestamp) AS "Days",
COUNT(tx_hash) AS "Total Transaction Volume",
'Arbitrum' AS chain_type
FROM arbitrum.core.fact_transactions
WHERE status = 'SUCCESS'
GROUP BY "Days", chain_type),
optimism_trf_daily AS
(SELECT DATE_TRUNC('day',block_timestamp) AS "Days",
SUM(amount) AS "Total Transfer Size in ETH",
'Optimism' AS chain_type
FROM optimism.core.ez_eth_transfers
GROUP BY "Days", chain_type),
arbitrum_trf_daily AS
(SELECT DATE_TRUNC('day',block_timestamp) AS "Days",
SUM(amount) AS "Total Transfer Size in ETH",
'Arbitrum' AS chain_type
FROM arbitrum.core.ez_eth_transfers
GROUP BY "Days", chain_type)
SELECT (SELECT COUNT(tx_hash)
FROM optimism.core.fact_transactions
WHERE status = 'SUCCESS') AS "Total Transaction Volume (OP)",
(SELECT COUNT(tx_hash)
FROM arbitrum.core.fact_transactions
Run a query to Download Data