alirsop-opt-03
Updated 2022-11-03
9
1
2
3
4
5
6
7
8
›
⌄
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