count(distinct tx_hash) as transactions,

count(distinct from_address) as users,

transactions / datediff('seconds', min(block_timestamp), max(block_timestamp)) as tps,

sum(tx_fee) as volume_fee,

avg(tx_fee) as average_fee_amount,

transactions / count(distinct block_timestamp::date) as daily_average_transactions,

users / count(distinct block_timestamp::date) as daily_average_users

mantle.core.fact_transactions

block_timestamp between '{{ start_date }}' and '{{ end_date }}'

and tx_succeeded