messariMonthly signers copy
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- forked from dsaber / Monthly signers @ https://flipsidecrypto.xyz/dsaber/q/YtFos1KDAW9U/monthly-signers
SELECT DATE_TRUNC('month', t.block_timestamp) AS month
,COUNT(DISTINCT s.value) AS num_signers
FROM solana.core.fact_transactions t,
LATERAL FLATTEN(t.signers) s
WHERE t.block_timestamp::DATE >= '2021-01-01'
AND t.block_timestamp::DATE < DATE_TRUNC('month', CURRENT_DATE)
AND t.succeeded
GROUP BY 1
ORDER BY 1 DESC
Run a query to Download Data