HosseinUntitled Query
Updated 2022-08-02
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select b.contract_address as to_address, count(*) as number from optimism.core.fact_event_logs a
join optimism.core.fact_event_logs b on a.tx_hash = b.tx_hash
where a.event_name = 'Swap'
and b.event_name = 'Transfer'
and b.event_inputs:from = a.contract_address
and b.event_inputs:to = a.origin_from_address
and a.tx_status = 'SUCCESS'
and b.origin_to_address = '0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45'
and b.origin_function_signature = '0x5ae401dc'
group by b.contract_address
order by number desc
limit 10
Run a query to Download Data