SELECT

COUNT(DISTINCT FROM_ADDRESS) AS active_users_last_30_days

FROM

base.core.fact_transactions;

WHERE

BLOCK_TIMESTAMP >= DATEADD(DAY, -30, CURRENT_TIMESTAMP())

AND BLOCK_TIMESTAMP < CURRENT_TIMESTAMP()

),

Active_Users_Previous_30_Days AS (

SELECT

COUNT(DISTINCT FROM_ADDRESS) AS active_users_previous_30_days

FROM

base.core.fact_transactions

WHERE

BLOCK_TIMESTAMP >= DATEADD(DAY, -60, CURRENT_TIMESTAMP())

AND BLOCK_TIMESTAMP < DATEADD(DAY, -30, CURRENT_TIMESTAMP())

active_users_last_30_days,

active_users_previous_30_days,

CASE

WHEN active_users_previous_30_days = 0 THEN NULL

ELSE (active_users_last_30_days - active_users_previous_30_days) / active_users_previous_30_days::FLOAT * 100

END AS percentage_difference

FROM

Active_Users_Last_30_Days,

Active_Users_Previous_30_Days;