SELECT 'Average Price' as type, SYMBOL, avg (PRICE_USD) as Price from flow.core.fact_prices GROUP BY 2 UNION
SELECT 'Maximum Price' as type, SYMBOL, max (PRICE_USD) as Price from flow.core.fact_prices GROUP BY 2 UNION
SELECT 'Minimum Price' as type, SYMBOL, min (PRICE_USD) as Price from flow.core.fact_prices GROUP BY 2 UNION
SELECT 'Median Price' as type, SYMBOL, median (PRICE_USD) as Price from flow.core.fact_prices GROUP BY 2