flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
the 30 most popular events that have been used on Flow over the last week.
farid-c9j0VM
the 30 most popular events that have been used on Flow over the last week.
Updated 2022-06-18
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with
top_30
as
(
select
event_type
as
popular_events
,
count
(
tx_id
)
as
event_count
from
flow
.
core
.
fact_events
where
block_timestamp
::
date
>=
CURRENT_DATE
(
)
-
7
group
by
event_type
order
by
event_count
desc
limit
30
)
select
*
from
top_30
Results
Run a query to Download Data