alirsop-opt-03
    Updated 2022-11-03
    select
    mindate::date as date,case when date>='2022-06-04' and date<='2022-08-17' then 'Before hack fake rumors'
    when date>'2022-08-17' and date<='2022-08-24' then 'A few daysAfter hack fake rumors(1 Week)'
    else 'After hack fake rumors' end as Time,
    count (distinct from_address) as New_Users
    from (select from_address, min(block_timestamp) as mindate from optimism.core.fact_transactions group by 1)
    where date>='2022-06-04' and date<='2022-11-01'
    group by 1
    Run a query to Download Data