select date_trunc('day', block_timestamp) as dt, pool_name, avg(price_usd) as price_usd