Abbas_ra21ARB vs OP: transactions Volume #3
Updated 2023-01-20
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
›
⌄
WITH transactions AS (
SELECT
'Optimism' AS Chain,
DATE_TRUNC('day', BLOCK_TIMESTAMP) as day,
case when LABEL_TYPE is not null then LABEL_TYPE else 'other' end AS type,
COUNT(*) as transactions
FROM optimism.core.fact_transactions left join optimism.core.dim_labels on TO_ADDRESS=ADDRESS
GROUP BY day,type
union ALL
SELECT
'Arbitrum' AS Chain,
DATE_TRUNC('day', BLOCK_TIMESTAMP) as day,
case when LABEL_TYPE is not null then LABEL_TYPE else 'other' end AS type,
COUNT(*) as transactions
FROM arbitrum.core.fact_transactions left join arbitrum.core.dim_labels on TO_ADDRESS=ADDRESS
GROUP BY day,typezzz
)
SELECT
day,
DAYNAME(day) AS "Day Name",
type,
chain,
transactions
FROM transactions where day>= '2022-04-18'
ORDER BY day
Run a query to Download Data