Kruys-CollinsMonthly Active Users
Updated 2024-09-25
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
›
⌄
WITH UserActivities AS (
SELECT
origin_from_address AS user,
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS activity_date
FROM
bsc.defi.ez_dex_swaps
WHERE
BLOCK_TIMESTAMP >= '2024-01-01'
AND
PLATFORM LIKE '%pancakeswap%'
),
FirstActivity AS (
SELECT
user,
MIN(activity_date) AS first_activity_date
FROM
UserActivities
GROUP BY
user
),
Dates AS (
SELECT
DISTINCT DATE_TRUNC('month', activity_date) AS month
FROM
UserActivities
),
DAUs AS (
SELECT
activity_date,
COUNT(DISTINCT user) AS daus
FROM
UserActivities
GROUP BY
activity_date
),
MAUs AS (
QueryRunArchived: QueryRun has been archived