flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
BECOME A PARTNER
flipside
Cosmos Events Query
hesam
Cosmos Events Query
Updated 2022-12-14
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
-- date_trunc('day', block_timestamp) as Date,
MSG_TYPE
as
Event
,
COUNT
(
DISTINCT
tx_id
)
as
"Number of Transactions"
FROM
cosmos
.
core
.
fact_msgs
WHERE
MSG_TYPE
IN
(
'delegate'
,
'redelegate'
,
'unbond'
)
GROUP
BY
1
-- ,2
Results
Run a query to Download Data