select

trunc(block_timestamp,'day') as hour,

count(distinct tx_hash) as transactions,

count(distinct from_address) as active_users,

sum(tx_fee) as fees,

avg(tx_fee) as avg_tx_fee

from blast.core.fact_transactions

where status='SUCCESS'

and block_timestamp>'2024-02-29 10:00'

and block_timestamp<current_date

group by 1 order by 1 DESC