mlhUntitled Query
Updated 2022-10-26Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select address_name as swap_to,
count(distinct a.tx_hash) as swap_count
from optimism.core.fact_event_logs a
inner join optimism.core.dim_labels b
on a.contract_address = b.address
where a.origin_to_address IN ('0xa132dab612db5cb9fc9ac426a0cc215a3423f9c9')
and a.event_inputs:to = a.origin_from_address
and event_name = 'Transfer'
and tx_status = 'SUCCESS'
group by 1
order by 2 DESC
limit 10
Run a query to Download Data