select

DATE_DAY as date

from crosschain.core.dim_dates

where date >= '2023-10-01'

and date <= current_date

group by date

),

price as (

select

date_trunc('day', hour) as date,

token_address,

symbol,

avg(price) as usd_price

from avalanche.price.ez_prices_hourly

where token_address IN (

'0x53fc82f14f009009b440a706e31c9021e1196a2f',

'0xe08b4c1005603427420e64252a8b120cace4d122',

'0x7c64925002bfa705834b118a923e9911bee32875',

'0x3a206f8f7cec45f1bd48ee5f370d04f609504d56',

'0x0b84f124596dac26010a9f79b7d8feade4ebbdbf',

'0x7c6a937943f135283a2561938de2200994a8f7a7',

'0xad6605f4987031fd2d6d6816be53eb7c5b764bf7',

'0xbb9360d57f68075e98d022784c12f2fda082316b',

'0xbfdef5e389bb403426337081ecd1d05bc5193203',

'0xbc370355963281b150307717520294effe2d9c50',

'0x8c21c5f64e17f77a6af671b6f51c2dd14ea6cf4a',

'0xca30c93b02514f86d5c86a6e375e3a330b435fb5',

'0x7f4546ef315efc65336187fe3765ea779ac90183',

'0x1e2c4fb7ede391d116e6b41cd0608260e8801d59'

)

and date >= '2023-10-01'

group by 1 , 2 , 3

,buidl_data as ( -- -- Blackrock Usd Institutional Digital Liquidity Fund -- BUIDL