pouya_22Optimism DEXs - Velodrome swap to
    Updated 2022-08-04
    select
    address_name,
    t.contract_address,
    count(distinct e.tx_hash) as number_of_swaps
    from optimism.core.fact_event_logs e
    join optimism.core.fact_token_transfers t
    join optimism.core.dim_labels l on l.address = t.contract_address
    on e.tx_hash = t.tx_hash and e.origin_from_address = t.to_address
    where event_name = 'Swap'
    and e.origin_to_address = '0xa132dab612db5cb9fc9ac426a0cc215a3423f9c9'
    group by 1,2
    order by 2 desc
    limit 10
    Run a query to Download Data