SELECT block_timestamp::date as date

, split_part(pool_name, '-', 1) as token

, max(asset_usd) AS price

from thorchain.price.fact_prices

where block_timestamp >= current_date - 10

group by 1, 2

order by 1, 2