SELECT

TX_FROM AS user_address,

MIN(DATE(BLOCK_TIMESTAMP)) AS first_activity

FROM

axelar.core.fact_transactions

GROUP BY

TX_FROM

HAVING

MIN(DATE(BLOCK_TIMESTAMP)) >= CURRENT_DATE - INTERVAL '30 DAYS'

),

TotalUsers AS (

SELECT

COUNT(DISTINCT TX_FROM) AS total_users

FROM

axelar.core.fact_transactions

WHERE

BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '30 DAYS'

SELECT

(SELECT COUNT(*) FROM NewUsers) AS new_users,

(SELECT total_users FROM TotalUsers) AS total_users,

((SELECT COUNT(*) FROM NewUsers) * 100.0 / (SELECT total_users FROM TotalUsers)) AS new_users_percentage

;