alirsOPB-OPT06-Day
Updated 2022-10-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
block_timestamp::date as date,
count(DISTINCT tx_hash) as swap_Count,
count(distinct origin_from_address) as Swapper_count
from optimism.core.fact_event_logs
where origin_to_address = lower('0xE6Df0BB08e5A97b40B21950a0A51b94c4DbA0Ff6') --ZipSwap
and event_name = 'Swap'
and tx_status = 'SUCCESS'
group by 1
order by 2 DESC
limit 10
Run a query to Download Data