shreexDaily Active Addresses Of Optimism
    Updated 2022-09-08
    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