tomilayoright-lavender
Updated 2024-09-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
⌄
SELECT
COUNT(DISTINCT user_address) AS Total_Active_Users
FROM (
SELECT
FROM_ADDRESS AS user_address
FROM
kaia.core.fact_transactions;
WHERE
BLOCK_TIMESTAMP >= DATEADD(DAY, -90, CURRENT_DATE)
AND TX_SUCCEEDED = TRUE
UNION
SELECT
TO_ADDRESS AS user_address
FROM
kaia.core.fact_transactions
WHERE
BLOCK_TIMESTAMP >= DATEADD(DAY, -90, CURRENT_DATE)
AND TX_SUCCEEDED = TRUE
) AS active_users;
QueryRunArchived: QueryRun has been archived