select date_trunc('hour',BLOCK_TIMESTAMP) as hour

,sum((GAS_PRICE/1e9)*CUMULATIVE_GAS_USED) as fee_paid

,sum(fee_paid)over(order by hour) as total_fee_paid

from ronin.core.fact_transactions

where TO_ADDRESS='0xbe21424c284654c8b4b1d1b11e732bd1e654b3c4'

and ORIGIN_FUNCTION_SIGNATURE='0xf1151e76'

group by 1