date_trunc('day', hour) as date,

avg(price) as price

from ethereum.token_prices_hourly

where token_address = lower('0xc5bddf9843308380375a611c18b50fb9341f502a')

and hour > '2021-04-01'

group by date

order by date