feyikemiTop Projects Based on Users
Updated 2024-10-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH Kaia_stats AS (
SELECT
b.PROJECT_NAME,
count(DISTINCT a.tx_hash) AS txns,
count(DISTINCT a.ORIGIN_FROM_ADDRESS) AS Users
FROM
kaia.core.fact_event_logs a
JOIN kaia.core.dim_labels b ON a.contract_address = b.address
WHERE
a.TX_SUCCEEDED = 'TRUE'
AND b.label_type IS NOT NULL
AND a.block_timestamp >= '2024-01-01'
GROUP BY 1
)
SELECT
project_name,
users
FROM
kaia_stats
ORDER BY 2 DESC
LIMIT 10
QueryRunArchived: QueryRun has been archived