-- SELECT date_trunc('day', block_timestamp) as date, succeeded, COUNT(DISTINCT TX_id) as num_tx, COUNT
-- FROM solana.core.fact_transactions
-- -- WHERE block_number = 16329897
-- WHERE block_timestamp > CURRENT_DATE - 150
-- GROUP BY 1, 2
SELECT date_trunc('day',block_timestamp) as date, count(1) as total, count_if(succeeded = TRUE) as success, count_if(succeeded != TRUE) as failure
from solana.fact_transactions
where block_timestamp > CURRENT_DATE - 186 and block_timestamp < CURRENT_DATE
group by 1