ThatGuyOptimism - User Behavior 3. user
Updated 2022-10-26
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
›
⌄
WITH
opt as (
SELECT
DATE_TRUNC('week',block_timestamp) as week,
COUNT(DISTINCT FROM_ADDRESS) as "OP User Count"
FROM optimism.core.fact_transactions
WHERE
STATUS = 'SUCCESS'
GROUP BY 1
ORDER BY 1
)
,
eth as (
SELECT
DATE_TRUNC('week',block_timestamp) as week,
COUNT(DISTINCT FROM_ADDRESS) as "ETH User Count"
FROM ethereum.core.fact_transactions
WHERE
STATUS = 'SUCCESS'
GROUP BY 1
ORDER BY 1
)
SELECT
*
FROM opt
JOIN eth USING(week)
WHERE week > '2021-01-01' AND week < CURRENT_DATE
Run a query to Download Data