select date_trunc('day', block_timestamp) as date, sum(event_data:amount) as volume, sum(iff(tx_succeeded = true, 1, 0)) / count(*) as tx_success_rate
from flow.core.fact_events
where date >= '2022-05-09' and tx_id in (select tx_id from flow.core.fact_transactions where block_timestamp::date >= '2022-05-09')
group by 1