feyikemiBenqi Users 2
Updated 2024-06-18
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
›
⌄
WITH Tab1 AS (
SELECT
address
FROM
avalanche.core.dim_labels
WHERE
project_name ILIKE '%benqi%'
)
SELECT
Date_trunc('Day', Block_timestamp) AS Date,
COUNT(DISTINCT Tx_hash) AS Transactions,
COUNT(DISTINCT origin_from_address) AS Total_Users
FROM
avalanche.core.ez_decoded_event_logs
WHERE
origin_to_address IN (
SELECT
address
FROM
Tab1
)
AND Date >= '2024-01-01'
AND tx_status = 'SUCCESS'
GROUP BY 1
QueryRunArchived: QueryRun has been archived