SELECT

asset AS assets,

contract_address AS contract,

COUNT(DISTINCT receiver) AS number_of_receivers,

SUM(amount) AS total_amount

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

GROUP BY asset, contract_address

),

price_summary AS (

SELECT

token_address,

symbol,

decimals,

price AS avg_price_usd

FROM ethereum.price.ez_prices_hourly

WHERE token_address IN (

LOWER('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'), -- WETH

LOWER('0x657e8c867d8b37dcc18fa4caead9c45eb088c642'), -- Address 2

LOWER('0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee'), -- Address 3

LOWER('0x2260fac5e5542a773aa44fbcfedf7c193bc2c599'), -- WBTC

LOWER('0x8236a87084f8b84306f72007f36f2618a5634494'), -- Address 5

LOWER('0x35fa164735182de50811e8e2e824cfb9b6118ac2'), -- Address 6

LOWER('0xae7ab96520de3a18e5e111b5eaab095312d7fe84'), -- stETH

LOWER('0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf'), -- Address 8

LOWER('0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0') -- wstETH

)

AND hour >= '2024-12-01'

AND hour <= '2024-12-31'

),

final_summary AS (

SELECT

asets.assets,

asets.contract,

asets.number_of_receivers,

asets.total_amount,