freemartianAll Pools
Updated 2022-07-17
9
1
2
3
4
5
6
7
8
9
›
⌄
select
distinct contract_address as Pool_address,
count (distinct tx_hash) as swap_count
from optimism.core.fact_event_logs
where origin_to_address = '0xbe811a0d44e2553d25d11cb8dc0d3f0d0e6430e6'
and event_name = 'Swap'
group by pool_address
order by swap_count DESC
Run a query to Download Data