date_trunc('week', block_timestamp) AS date,

COUNT(tx_from) AS WEEKLY_wallet_addresses,

COUNT(DISTINCT tx_from) AS weekly_accounts,

COUNT(tx_id) AS weekly_transactions,

SUM(fee/ pow(10, 6)) AS weekly_gas_fees,

SUM(CASE WHEN tx_succeeded = TRUE THEN 1 ELSE 0 END) AS total_successful,

SUM(CASE WHEN tx_succeeded = FALSE THEN 1 ELSE 0 END) AS total_failed

FROM lava.core.fact_transactions

WHERE block_timestamp >= '2024-07-01' AND block_timestamp < '2024-08-01'

GROUP BY date

ORDER BY date;