onchainbrainDAUs by Chain
Updated 2023-03-13Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from 912a1fe7-9a5d-4db0-a0e1-32d2ca802b8b
WITH solana_waus AS (
SELECT DATE_TRUNC('day', block_timestamp) AS day
,'solana (fee payers)' AS chain
,COUNT(DISTINCT signers[0]) AS dayly_active_accounts
FROM solana.core.fact_transactions
WHERE block_timestamp::DATE >= DATE_TRUNC('day', CURRENT_DATE - 180)
AND block_timestamp::DATE < DATE_TRUNC('day', CURRENT_DATE)
AND succeeded
GROUP BY 1, 2
)
,solana_waus2 AS (
SELECT DATE_TRUNC('day', block_timestamp) AS day
,'solana (signers)' AS chain
,COUNT(DISTINCT s.value) AS dayly_active_accounts
FROM solana.core.fact_transactions,
LATERAL FLATTEN(signers) AS s
WHERE block_timestamp::DATE >= DATE_TRUNC('day', CURRENT_DATE - 180)
AND block_timestamp::DATE < DATE_TRUNC('day', CURRENT_DATE)
AND succeeded
GROUP BY 1, 2
)
,ethereum_waus AS (
SELECT DATE_TRUNC('day', block_timestamp) AS day
,'ethereum' AS chain
,COUNT(DISTINCT from_address) AS dayly_active_accounts
FROM ethereum.core.fact_transactions
WHERE block_timestamp::DATE >= DATE_TRUNC('day', CURRENT_DATE - 180)
AND block_timestamp::DATE < DATE_TRUNC('day', CURRENT_DATE)
AND status = 'SUCCESS'
GROUP BY 1, 2
)
,polygon_waus AS (
WITH polygon_transactions AS (
SELECT DATE_TRUNC('day', block_timestamp) AS block_timestamp
Run a query to Download Data