flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
COUNT TRANSACTIONS Per User
roket
COUNT TRANSACTIONS Per User
Updated 2022-07-07
Copy Reference
Fork
9
1
2
3
›
⌄
SELECT
DISTINCT
(
SENDER
)
AS
users
,
COUNT
(
TX_ID
)
AS
COUNT_OF_TRANSACTIONS
FROM
flipside_prod_db
.
algorand
.
transactions
WHERE
BLOCK_TIMESTAMP
::
DATE
>
'2022-01-01'
GROUP
BY
users
ORDER
BY
COUNT_OF_TRANSACTIONS
DESC
LIMIT
15
Results
Run a query to Download Data