Tobi_12024-06-07 09:02 PM
Updated 2024-06-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
⌄
WITH recent_transactions AS (
SELECT
BLOCK_TIMESTAMP,
SIGNERS
FROM
solana.core.fact_transactions;
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP())
),
unnested_signers AS (
SELECT
BLOCK_TIMESTAMP,
s.value AS signer
FROM
recent_transactions,
LATERAL FLATTEN(input => SIGNERS) s
)
SELECT
COUNT(DISTINCT signer) AS active_signers
FROM
unnested_signers;
QueryRunArchived: QueryRun has been archived