select

hour::date as price_date

,symbol

,avg(PRICE) as avg_price

from arbitrum.price.ez_prices_hourly

where hour >= '2024-07-30'

and symbol ='LAVA'

group by 1,2

)

select * from lst_lava_price