date_trunc(day,block_timestamp) as dt,

count(*),

sum(tx_fee),

sum(((LENGTH(input_data)-2) / 2) + {{fixed_data}})/(1024*1024) AS data_size_s

from ethereum.core.fact_transactions

where block_timestamp >= current_date - 30

group by 1

order by dt asc