Updated 2025-04-11
999
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
›
⌄
----------------------- Base, Polygon, Solana, Ronin blockchain data-----------
WITH
standard_chains AS (
-- SELECT
-- 'Base' AS blockchain,
-- block_timestamp::date AS date,
-- COUNT(DISTINCT from_address) AS users
-- FROM
-- base.core.fact_transactions
-- WHERE
-- block_timestamp::date >= DATEADD(DAY, -{{period}}, CURRENT_DATE)
-- AND TX_SUCCEEDED = 'TRUE'
-- GROUP BY
-- blockchain, date
-- UNION ALL
SELECT
'Polygon' AS blockchain,
block_timestamp::date AS date,
COUNT(DISTINCT from_address) AS users
FROM
polygon.core.fact_transactions
WHERE
block_timestamp::date >= DATEADD(DAY, -{{period}}, CURRENT_DATE)
AND status = 'SUCCESS'
GROUP BY
blockchain, date
UNION ALL
-- SELECT
-- 'avalanche' AS blockchain,
-- block_timestamp::date AS date,
-- COUNT(DISTINCT from_address) AS users
-- FROM
-- avalanche.core.fact_transactions
-- WHERE
-- block_timestamp::date >= DATEADD(DAY, -{{period}}, CURRENT_DATE)
-- AND status = 'SUCCESS'