HosseinUntitled Query
Updated 2023-01-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with t as (
select
from_address as address,
block_timestamp
from optimism.core.fact_transactions
union all
select
to_address as address,
block_timestamp
from optimism.core.fact_transactions
)
select count(distinct address) as users_count from t
where block_timestamp::date >= '2022-01-01'
Run a query to Download Data