(select 'Base' as chain,

date(block_timestamp) as datetime,

'ETH' as symbol,

Null as token_contract,

sum(TX_FEE) as fees_token

from base.core.fact_transactions

group by 1,2,3)

where datetime >= current_date() - 30