SELECT

asset AS assets,

contract_address AS contract,

receiver AS address,

SUM(amount) AS total_amount,

tx_hash

FROM $query('9edcf0c4-fb19-479b-9a0e-e12718f57ac8')

WHERE asset IS NOT NULL

AND contract_address IS NOT NULL

AND receiver IS NOT NULL

AND tx_hash IS NOT NULL

AND amount IS NOT NULL

GROUP BY asset, contract_address, receiver, tx_hash

),

price_summary AS (

SELECT

token_address,

symbol,

decimals,

AVG(price) AS avg_price_usd

FROM ethereum.price.ez_prices_hourly

WHERE token_address IN (

LOWER('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'), -- WETH

LOWER('0x657e8c867d8b37dcc18fa4caead9c45eb088c642'), -- EBTC

LOWER('0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee'), -- WEETH

LOWER('0x2260fac5e5542a773aa44fbcfedf7c193bc2c599'), -- WBTC

LOWER('0x8236a87084f8b84306f72007f36f2618a5634494'), -- LBTC

LOWER('0x35fa164735182de50811e8e2e824cfb9b6118ac2'), -- EETH

LOWER('0xae7ab96520de3a18e5e111b5eaab095312d7fe84'), -- stETH

LOWER('0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf'), -- CBBTC

LOWER('0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0') -- wstETH

)

AND hour >= '2024-12-01'

AND hour <= '2024-12-31'

GROUP BY token_address, symbol, decimals