TIMESTAMP::date as date, tx_hash, (ACTUAL_FEE/pow(10,18)) as feth, feth*avg(price) as fusd

from external.tokenflow_starknet.decoded_transactions

join crosschain.core.ez_hourly_prices on HOUR::date = TIMESTAMP::date

where SYMBOL = 'WETH'

and CHAIN_ID = 'mainnet'

and TIMESTAMP::date = '2023-09-11'

GROUP by 1,2,3)

SELECT sum(feth) as "fees in eth", sum(fusd) as "fees in usd"

from t0