SocioAnalyticaUsers and D/W/MAU
Updated 2024-10-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT date,
count(DISTINCT user) as DAU,
ROUND(AVG(Dau) OVER (ORDER BY date ROWS BETWEEN 7 PRECEDING AND CURRENT ROW)) AS avarage_7_Dau,
ROUND(AVG(Dau) OVER (ORDER BY date ROWS BETWEEN 30 PRECEDING AND CURRENT ROW)) AS avarage_30_Dau
FROM
(SELECT date_trunc('{{interval}}',block_timestamp) as date,
sender as user
FROM axelar.defi.ez_bridge_satellite
UNION
SELECT date_trunc('{{interval}}', block_timestamp) AS date,
sender as user
FROM axelar.defi.ez_bridge_squid
)
GROUP BY date
ORDER BY date DESC
QueryRunArchived: QueryRun has been archived