date_trunc('day', minute) as day,

avg(number_transaction) as avg_number_transaction

from (select date_trunc('minute', block_timestamp) as minute,

case when succeeded = 'TRUE' then 'successful_transaction' else 'failed_transaction'

end as status, count(distinct tx_id) as number_transaction

from solana.core.fact_transactions

where date(block_timestamp) >= '2022-01-01' and date(block_timestamp) < current_date

group by 1, 2)

group by 1