from polygon.events_emitted

where event_inputs:to::string = '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073' and contract_name = 'weth' and block_day >= CURRENT_DATE - 90

group by 1),

ethprice as (select date_trunc('day', hour) as block_day, avg(price) as Average_ETH_daily

from ethereum.token_prices_hourly

where symbol = 'ETH' and block_day >= CURRENT_DATE - 90

group by 1)

select A.block_day, A.fees, B.Average_ETH_daily, (A.fees * B.Average_ETH_daily) as Fees_WETH_collected

from fees A

join ethprice B on A.block_day = B.block_day

order by 1 desc