COUNT(TX_HASH) AS Total_Transactions

FROM

kaia.core.fact_transactions;

WHERE

BLOCK_TIMESTAMP >= DATEADD(DAY, -90, CURRENT_DATE) -- Get transactions from the last 90 days

AND TX_SUCCEEDED = TRUE; -- Only include successful transactions