SELECT

DISTINCT from_address AS "Users",

MIN(block_timestamp) AS "First Date on Blast"

FROM

blast.core.fact_transactions

WHERE

block_timestamp >= '2024-02-24 00:00:00.000'

GROUP BY

from_address

),

NewUsers AS (

SELECT

COUNT(DISTINCT f."Users") AS "New Users"

FROM

FirstTimeUsers f

WHERE

f."First Date on Blast" >= '2024-02-24 00:00:00.000'

),

ReturningUsers AS (

SELECT

COUNT(DISTINCT t.from_address) AS "Returning Users"

FROM

blast.core.fact_transactions t

JOIN FirstTimeUsers f ON t.from_address = f."Users"

WHERE

t.block_timestamp > f."First Date on Blast"

),

currentUsers AS (

SELECT

COUNT(DISTINCT from_address) AS "Current Users"

FROM

blast.core.fact_transactions

(