alirsop-opt-02
Updated 2022-11-03
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select block_timestamp::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,
sum(eth_value) as total_volume from optimism.core.fact_event_logs
join optimism.core.fact_transactions using(tx_hash)
where tx_status = 'SUCCESS'
and date>='2022-06-04' and date<='2022-11-01'
group by 1,2
order by 1
Run a query to Download Data