adambala127
Updated 2022-09-02Copy Reference Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
select block_timestamp::date as date, 'veldrome'as title ,
count (distinct tx_hash) as Swap_num,
count (distinct Origin_from_address) as users
from optimism.core.fact_event_logs
where origin_to_address in('0xa132dab612db5cb9fc9ac426a0cc215a3423f9c9')
and event_name = 'Swap'
group by 1
Run a query to Download Data