date_trunc('day', block_timestamp) as date,

count(distinct from_address) as current_users,

count(distinct tx_hash) as transaction_volume,

sum(tx_fee) as gas_fee

from blast.core.fact_transactions

where status = 'SUCCESS'

AND block_timestamp >= '2024-01-01'

AND block_timestamp < current_timestamp

group by 1

order by 1 DESC