date_trunc('day',BLOCK_TIMESTAMP) as date,

count(*) as number,

count(distinct TX_FROM) as users,

count(case when TX_SUCCEEDED='TRUE' then 1 else null end)*100/number as success_rate,

number/users as daily_average

from

axelar.core.fact_transactions

group by date

order by date