-- forked from adriaparcerisas / flow stats: txs (over time) weekly @ https://flipsidecrypto.xyz/adriaparcerisas/q/iNdF3ST8N50r/flow-stats-txs-over-time-weekly
SELECT
trunc(block_timestamp,'day') as day,
case when tx_succeeded='true' then 'Succeeded' else 'Failed' end as type,
count(*) as total_transactions
from flow.core.fact_transactions x
--where month<trunc(current_date,'week')
group by 1,2
order by 1 asc