SELECT price, token_address

from ethereum.price.ez_prices_hourly

where token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

and hour = current_date()

),

Cyber AS (

SELECT

'ethereum' AS chain,

SUM(TX_FEE * (SELECT price FROM Ethprice)) AS Tx_USD,

AVG(TX_FEE * (SELECT price FROM Ethprice)) AS Avg_fee_USD

FROM ethereum.core.fact_transactions

WHERE to_address = '0xfdf7c22ca4704dfef46e7e5ef53dca1d5a9f8e12'

AND block_timestamp >= '2024-05-24'

AND status = 'SUCCESS'

UNION ALL

SELECT

'optimism' AS chain,

SUM(TX_FEE * (SELECT price FROM Ethprice)) AS Tx_USD,

AVG(TX_FEE * (SELECT price FROM Ethprice)) AS Avg_fee_USD

FROM optimism.core.fact_transactions

WHERE to_address = '0xfdf7c22ca4704dfef46e7e5ef53dca1d5a9f8e12'

AND block_timestamp >= '2024-05-24'

AND status = 'SUCCESS'

UNION ALL

SELECT

'base' AS chain,

SUM(TX_FEE * (SELECT price FROM Ethprice)) AS Tx_USD,

AVG(TX_FEE * (SELECT price FROM Ethprice)) AS Avg_fee_USD

FROM base.core.fact_transactions

WHERE to_address = '0xfdf7c22ca4704dfef46e7e5ef53dca1d5a9f8e12'

AND block_timestamp >= '2024-05-24'