SELECT address

FROM avalanche.core.dim_labels

WHERE project_name ILIKE '%benqi%'

),

New_Users AS (

SELECT

origin_from_address,

MIN(block_timestamp::date) AS min_date

FROM avalanche.core.ez_decoded_event_logs

WHERE origin_to_address IN (SELECT address FROM Tab1)

AND tx_status = 'SUCCESS'

AND block_timestamp::date >= '2024-01-01'

GROUP BY origin_from_address

),

Active_Users AS (

SELECT

origin_from_address,

block_timestamp::date AS date

FROM avalanche.core.ez_decoded_event_logs

WHERE origin_to_address IN (SELECT address FROM Tab1)

AND tx_status = 'SUCCESS'

AND block_timestamp::date >= '2024-01-01'

SELECT

'New Users' AS type,

date_trunc('day', min_date) AS date,

COUNT(DISTINCT origin_from_address) AS users

FROM

New_Users

GROUP BY

1, 2