select
date_trunc('hour', block_timestamp) as datetime,
count(
case
when succeeded = 'FALSE' then succeeded
end
) as fails,
count(
case
when succeeded = 'TRUE' then succeeded
end
) as success,
count(DISTINCT tx_id) as tx_count,
success / (tx_count) as success_rate
from
flipside_prod_db.solana.fact_transactions
where
block_timestamp::date >= '2022-05-11'
group by
datetime
order by
datetime