freemartianAll Pools
    Updated 2022-07-17
    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