HOUR::date as day,

avg(price) as WETH_price

from ethereum.price.ez_prices_hourly

where SYMBOL = 'WETH'

group by 1),

donations as (select

BLOCK_TIMESTAMP,

tx_hash,

DECODED_LOG:sender as "Sender",

DECODED_LOG:donation/1e18 as "Total donation (ETH)",

(DECODED_LOG:donation/1e18)*WETH_price as "Total donation (USD)",

DECODED_LOG:serviceIds as "Service ID",

DECODED_LOG:amounts as "Donation (ETH)"

from ethereum.core.ez_decoded_event_logs s

join price_tab p on s.BLOCK_TIMESTAMP::date = p.day

where CONTRACT_ADDRESS = '0xa0da53447c0f6c4987964d8463da7e6628b30f82'

and EVENT_NAME = 'DonateToServicesETH'

select

sum("Total donation (ETH)") as total_eth,

sum("Total donation (USD)") as total_usd

from donations