niloCopy of solana
Updated 2022-12-20
9
1
2
3
4
›
⌄
with base as (SELECT TX_SENDER as users, count(DISTINCT date_trunc('month', block_timestamp)) as weekly
FROM algorand.core.fact_transaction WHERE BLOCK_TIMESTAMP >= CURRENT_DATE - interval'6 months' GROUP BY 1 )
SELECT concat( 'Active ' , weekly,' Month in Last 6 Month') as weeks, COUNT (users) as Active_Users FROM base GROUP BY 1
Run a query to Download Data