date_trunc('hour', block_timestamp) as hour,

sum((amount/power(10, 9)) * price) as fees_usd

FROM eclipse.core.fact_transfers

left outer join (

SELECT

hour as h1,

price

from ethereum.price.ez_prices_hourly

where token_address like lower('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2')

) as b

on date_trunc('hour', h1) = date_trunc('hour', block_timestamp)

where tx_to like '8ZoX5t72zSvMPzqfoHNoRChzWf5pHvYi43GXYcZ1qZL2'

and not amount = 0

and mint like 'Eth1111111111111111111111111111111111111111'

GROUP BY 1