SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,

COUNT(DISTINCT TX_HASH) AS daily_transactions,

COUNT(DISTINCT FROM_ADDRESS) AS daily_active_users,

SUM(TX_FEE) AS daily_fees

FROM

boba.core.fact_transactions

WHERE

BLOCK_TIMESTAMP >= DATEADD('year', -1, CURRENT_DATE)

GROUP BY

1

),

weekly_data AS (

SELECT

DATE_TRUNC('week', BLOCK_TIMESTAMP) AS week,

COUNT(DISTINCT TX_HASH) AS weekly_transactions,

COUNT(DISTINCT FROM_ADDRESS) AS weekly_active_users,

SUM(TX_FEE) AS weekly_fees

FROM

boba.core.fact_transactions

WHERE

BLOCK_TIMESTAMP >= DATEADD('year', -1, CURRENT_DATE)

GROUP BY

1

),

monthly_data AS (

SELECT

DATE_TRUNC('month', BLOCK_TIMESTAMP) AS month,

COUNT(DISTINCT TX_HASH) AS monthly_transactions,

COUNT(DISTINCT FROM_ADDRESS) AS monthly_active_users,

SUM(TX_FEE) AS monthly_fees

FROM

boba.core.fact_transactions

WHERE

BLOCK_TIMESTAMP >= DATEADD('year', -1, CURRENT_DATE)