afonsoUntitled Query
    Updated 2023-01-19
    select
    block_timestamp ::date as day,
    count(distinct tx_hash) as txns_count,
    count(distinct from_address) as users_count,
    sum(txns_count) over (order by day) as cumulative_txns_count,
    sum(users_count) over (order by day) as cumulative_users_count
    from optimism.core.fact_transactions
    where block_timestamp >= '2022-06-01'
    group by day
    order by day
    Run a query to Download Data