date_trunc('day', recorded_hour) as date

, min(close) as minimum

, avg(close) as average

, median(close) as median

, max(close) as maximum

from solana.core.ez_token_prices_hourly

where token_address = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

and recorded_hour ::date > current_date() - interval '7 days'

group by 1