Query editor
1SELECT2 symbol3 , d1_closing_price4 , price 5 , ((price - d1_closing_price)/d1_closing_price)*100 as retail_roi_d16FROM query_37038577ORDER BY 4 DESC
SELECT
symbol
, d1_closing_price
, price
, ((price - d1_closing_price)/d1_closing_price)*100 as retail_roi_d1
FROM query_3703857
ORDER BY 4 DESC