SELECT

DATE_TRUNC('day', block_timestamp) AS date,

COUNT(distinct tx_hash) AS num_transactions,

sum(case when status='SUCCESS' then 1 else 0 end)/sum(case when status='SUCCESS' then 1 else 1 end) as success_rate,

avg(tx_fee) as avg_tx_fee,

avg(gas_price) as avg_gas_price

FROM base.goerli.fact_transactions

GROUP BY 1

order by 1 asc