Updated 2022-11-21
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
date_trunc('WEEK', block_timestamp) as date,
COUNT(DISTINCT TX_ID) as TRANSACTIONS,
COUNT(DISTINCT proposer) as users ,
sum(users) over (order by date) as cumulative_users_growth,
sum(TRANSACTIONS) over (order by date) as cumulative_TRANSACTIONS_growth
FROM flow.core.fact_transactions WHERE TX_SUCCEEDED='TRUE'AND date > CURRENT_DATE - 365
GROUP by 1
Run a query to Download Data