flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
SEI TX COUNT OVERTIME
Keyrock
SEI TX COUNT OVERTIME
Updated 2024-05-30
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
date_trunc
(
'month'
,
block_timestamp
)
AS
month
,
count
(
DISTINCT
FACT_TRANSACTIONS_ID
)
as
monthly_transactions
FROM
sei
.
core
.
fact_transactions
GROUP
BY
month
ORDER
BY
month
Results
QueryRunArchived: QueryRun has been archived