SELECT

CAST(HOUR as DATE) as date,

symbol,

AVG(price) as price,

token_address

FROM ethereum.price.ez_hourly_token_prices

WHERE TOKEN_ADDRESS in (

'0x320623b8e4ff03373931769a31fc52a4e78b5d70', -- RSR

'0x514910771af9ca656af840dff83e8264ecf986ca', -- LINK

'0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0', -- Matic

'0xd533a949740bb3306d119cc777fa900ba034cd52', -- CRV

'0x73968b9a57c6e53d41345fd57a6e6ae27d6cdb2f' -- SDT

AND '{{start_date}}' < HOUR

GROUP BY (

CAST(HOUR as DATE),

SYMBOL,

TOKEN_ADDRESS

ORDER BY date

),

eth_prices as (

SELECT

CAST(BLOCK_TIMESTAMP as DATE) as date,

AVG(LATEST_ANSWER_UNADJ / pow(10,8)) as eth_price

FROM ethereum.chainlink.ez_oracle_feeds

WHERE FEED_ADDRESS = lower('0x5f4eC3Df9cbd43714FE2740f5E3616155c5b8419')

GROUP BY CAST(BLOCK_TIMESTAMP as DATE)

Select

tokens.date,

tokens.symbol,