date(block_timestamp) as date,

sum(cast(gas_used as double) * gas_price)/power(10,9) as gas_fee_in_eth,

count(distinct from_address) as from_num

from

ethereum.core.fact_transactions

where block_timestamp >= CURRENT_DATE - 30

group by 1

order by 1 desc

limit 1