select date_trunc('day',HOUR) as date

, avg(PRICE)*1e10 as Price

, 'PEPE*1e10' as Token

from ethereum.price.fact_hourly_token_prices

where TOKEN_ADDRESS = '0x6982508145454ce325ddbe47a25d4ec3d2311933'

and date >= '2024-01-01'

group by 1

select date_trunc('day',HOUR) as date

, avg(PRICE)*25 as Price

, 'ETH*25' as Token

from ethereum.price.fact_hourly_token_prices

where TOKEN_ADDRESS = lower('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2')

and date >= '2024-01-01'

group by 1

select date_trunc('day',HOUR) as date

, avg(PRICE) as Price

, 'BTC' as Token

from ethereum.price.fact_hourly_token_prices

where TOKEN_ADDRESS = lower('0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599')

and date >= '2024-01-01'

group by 1