COUNT (DISTINCT TX_HASH) AS transactions,

COUNT (DISTINCT FROM_ADDRESS) AS users,

SUM (TX_FEE_PRECISE) AS fee

FROM berachain.testnet.fact_transactions

WHERE TX_SUCCEEDED

AND BLOCK_TIMESTAMP::date >= current_date-30