shreexDaily Active Addresses Of Optimism
Updated 2022-09-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with active_addresses as (
select
distinct from_address as active_addresses,
count(distinct date_trunc('day',block_timestamp)) as active_days,
count(*) as txs
from optimism.core.fact_transactions where block_timestamp >CURRENT_DATE - interval '30 days'
GROUP BY active_addresses
HAVING active_days >= 2
ORDER BY active_days DESC
)
select
date_trunc('day',block_timestamp) as date,
count(distinct from_address) as daily_active_addresses,
count(*) as transactions
from active_addresses,optimism.core.fact_transactions where from_address=active_addresses
GROUP BY date
ORDER BY date
Run a query to Download Data