flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
Top 10 User with most transactions
kingharald-eth
Top 10 User with most transactions
Updated 2022-08-04
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
select
from_address
as
wallet_address
,
count
(
distinct
(
tx_hash
)
)
as
tx_num
from
optimism
.
core
.
fact_transactions
where
status
=
'SUCCESS'
group
by
from_address
order
by
tx_num
desc
limit
10
Results
Run a query to Download Data