Date_trunc('day', block_timestamp) Date,

Count(DISTINCT tx_id) Txns,

Sum(gas_used) gas_fee,

(gas_fee*0.482586)/1000000 as gas_fee_usd

FROM sei.core.fact_transactions

WHERE block_timestamp :: date > current_date - 30

GROUP BY 1

ORDER BY 1 DESC