mamad-5XN3k3Debank 1
Updated 2024-05-09
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
›
⌄
SELECT
'Ethereum' as network,
BLOCK_TIMESTAMP::date AS "Day",
COUNT(DISTINCT from_address) AS registrations,
SUM(COUNT(DISTINCT from_address)) OVER (ORDER BY BLOCK_TIMESTAMP::date ) AS cum_registrations
FROM ethereum.core.fact_transactions
WHERE to_address = lower('0x6f922284798dE645E8Bc1040450d32Bde963c992')
AND STATUS ='SUCCESS'
GROUP BY 1,2
UNION
SELECT
'Arbitrum',
BLOCK_TIMESTAMP::date AS "Day",
COUNT(DISTINCT from_address) AS arb_registrations,
SUM(COUNT(DISTINCT from_address)) OVER (ORDER BY BLOCK_TIMESTAMP::date) AS total_arb_registrations
FROM arbitrum.core.fact_transactions
WHERE to_address = lower('0x7bfc80a1dc182720220265e0fe0a02f0f4607748')
AND STATUS ='SUCCESS'
GROUP BY 1,2
UNION
SELECT
'Polygon',
BLOCK_TIMESTAMP::date AS "Day",
COUNT(DISTINCT from_address) AS poly_registrations,
SUM(COUNT(DISTINCT from_address)) OVER (ORDER BY BLOCK_TIMESTAMP::date) AS total_poly_registrations
FROM polygon.core.fact_transactions
WHERE to_address = lower('0xf93517e466867c6ce1ccbd017681220ebfc8bd56')
AND STATUS ='SUCCESS'
GROUP BY 1,2
UNION
QueryRunArchived: QueryRun has been archived