Getting Last, 24h, 7d dextrade prices in one query?

Please also check this