WITH

matic_price AS (

SELECT hour::date AS day ,AVG(price) AS price

FROM polygon.price.ez_hourly_token_prices

WHERE token_address = '0x0000000000000000000000000000000000001010'

AND Hour::date >= '2024-04-22'

GROUP BY 1

),

eth_price AS(

SELECT hour::date AS day ,AVG(price) AS price

FROM ethereum.price.ez_hourly_token_prices

WHERE token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

AND hour::date >= '2024-04-22'

GROUP BY 1

),

ethereum AS (

transfer.block_timestamp,

transfer.tx_hash,

transfer.origin_function_signature,

origin_from_address,

origin_to_address,

raw_amount/pow(10,6) AS amount,

tx_fee*price AS fee_usd,

'Ethereum' AS network

FROM ethereum.core.ez_token_transfers transfer