count(tx_hash) as transaction_count,

sum(TX_FEE) as gas_fee,

date_trunc('day', block_timestamp::date) as TIME

from arbitrum.core.fact_transactions

where block_timestamp > CURRENT_DATE - 30

and tx_hash != '0x62b7f8049679e7509ace9ed2e58579b83c8670d73f467a1e1cfa95076033c76a'

and status = 'SUCCESS'

group by TIME