Popex404MoM Transactions Cosmos
Updated 2023-02-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT Month, ((Monthly_Transactions/Previous_Month)-1) *100 as "MoM Growth Rates", Monthly_Transactions as "Monthly Transactions"
FROM(
SELECT
date_trunc('month', block_timestamp) as Month
,COUNT(DISTINCT tx_id) as Monthly_Transactions
,lag(Monthly_Transactions) OVER (ORDER BY Month) as Previous_Month
FROM cosmos.core.fact_transactions
where tx_succeeded= true
and block_timestamp between '2021-03-01' and '2022-11-30'
GROUP BY Month
ORDER BY Month ASC
)
WHERE Previous_Month != 0
Run a query to Download Data