kingharald-ethPopular Velodrome Pools
    Updated 2022-08-19
    select contract_address, count(distinct(tx_hash)) as tx_num from optimism.core.fact_event_logs
    where origin_to_address = '0xa132dab612db5cb9fc9ac426a0cc215a3423f9c9'
    and (
    contract_address = lower('0xFFD74EF185989BFF8752c818A53a47FC45388F08') OR
    contract_address = lower('0xfc77e39De40E54F820E313039207DC850E4C9E60') OR
    contract_address = lower('0xf8ae1a9FF9f853A7837c251f09befd43AbEbcf90') OR
    contract_address = lower('0xe8537b6FF1039CB9eD0B71713f697DDbaDBb717d') OR
    contract_address = lower('0x47029bc8f5CBe3b464004E87eF9c9419a48018cd') OR
    contract_address = lower('0x20d33fF7880f65a3554bBEE9C4E9BF79812C6ef6') OR
    contract_address = lower('0xd62C9D8a3D4fd98b27CaaEfE3571782a3aF0a737') OR
    contract_address = lower('0x5edac6B8EA08d535c01981D75B3361481C0EE999') OR
    contract_address = lower('0xfc77e39De40E54F820E313039207DC850E4C9E60') OR
    contract_address = lower('0xf8ae1a9FF9f853A7837c251f09befd43AbEbcf90') OR
    contract_address = lower('0xBbEc8B042b88D720Bf12eF1684a280Daa3bb73EA') OR
    contract_address = lower('0x42e889c0730DAED1034c7e9f8A49b9AB8fc426A4') OR
    contract_address = lower('0x9629a694C041f3b10cE974DC37eF4dD4596c4F54')
    )
    and tx_status = 'SUCCESS'
    group by contract_address
    order by tx_num desc
    Run a query to Download Data