date_trunc('day',BLOCK_TIMESTAMP) as dt,

sum(GAS_USED/1e9) as collected_fee,

count(TX_ID) as no_txn

from osmosis.core.fact_transactions

where BLOCK_TIMESTAMP>= CURRENT_DATE-30

and TX_STATUS='SUCCEEDED'

group by 1