Top 5 addresses with most transactions (velo)

adambalaTop 5 addresses with most transactions (velo)

Updated 2022-09-02

select

FROM_ADDRESS , count(distinct tx_hash) as txs

from optimism.core.fact_transactions

where TO_ADDRESS=lower('0x3c8B650257cFb5f272f799F5e2b4e65093a11a05')

group by 1

order by 2 desc limit 5

Run a query to Download Data

flipside