Ali3NTop 10 Interacted Protocols in Optimism (By Number of Transactions)
    Updated 2022-11-04
    select origin_to_address,
    case when origin_to_address = '0xa132dab612db5cb9fc9ac426a0cc215a3423f9c9' or origin_to_address = '0x9c12939390052919af3155f41bf4160fd3666a6f' then 'Velodrome Router'
    when origin_to_address = '0xc30141b657f4216252dc59af2e7cdb9d8792e1b0' then 'Socket Registry'
    when origin_to_address = '0x74a002d13f5f8af7f9a971f006b9a46c9b31dabd' then 'Rabbithole'
    when origin_to_address = '0x2e42f214467f647fe687fd9a2bf3baddfa737465' then 'Galxe SpaceStation'
    else initcap(ifnull(t2.address_name,t3.address_name)) end as Destination_Label,
    count (distinct origin_from_address) as Users_Count,
    count (distinct tx_hash) as TX_Count
    from optimism.core.fact_event_logs t1 full outer join optimism.core.dim_labels t2 on t1.origin_to_address = t2.address
    full outer join flipside_prod_db.crosschain.address_labels t3 on t1.origin_to_address = t3.address
    where tx_status = 'SUCCESS'
    group by 1,2 having users_count >= 1000
    order by 4 DESC
    limit 10
    Run a query to Download Data