How to write query to select highest value from same date

please help me write this query for MySQL. I want to select highest value from same datetime. So if there are multiple equal datetime value, return only one row with highest price. For summary, one row per timestamp with highest price. +------+---------------+--------------+---------+---------+---------------------+ | id | source_curr | dest_curr | price | act | timestamp | +------+---------------+--------------+---------+---------+---------------------+ | 164 | EUR | USD | 0.99332 | bids | 2022-07-18 20:52:38 | | 769 | EUR | USD | 0.99125 | bids | 2022-07-18 20:52:38 | | 1370 | EUR | USD | 0.99332 | bids | 2022-07-18 20:52:38 | | 568 | EUR | USD | 0.99322 | bids | 2022-07-18 20:52:38 | | 1572 | EUR | USD | 0.96335 | bids | 2022-07-18 20:52:38 | | 1771 | EUR | USD | 0.99432 | bids | 2022-07-18 20:52:38 | | 971 | EUR | USD | 0.99535 | bids | 2022-07-18 20:52:38 | | 367 | EUR | USD | 0.99334 | bids | 2022-07-18 20:52:38 | | 1173 | EUR | USD | 0.99332 | bids | 2022-07-18 20:52:38 | | 574 | EUR | USD | 0.9865 | bids | 2022-08-11 15:33:22 | | 1179 | EUR | USD | 0.9845 | bids | 2022-08-11 15:33:22 | | 373 | EUR | USD | 0.9863 | bids | 2022-08-11 15:33:22 | | 1578 | EUR | USD | 0.9875 | bids | 2022-08-11 15:33:22 | | 977 | EUR | USD | 0.9868 | bids | 2022-08-11 15:33:22 | | 1376 | EUR | USD | 0.9864 | bids | 2022-08-11 15:33:22 | | 1777 | EUR | USD | 0.9365 | bids | 2022-08-11 15:33:22 | | 170 | EUR | USD | 0.9165 | bids | 2022-08-11 15:33:22 | | 775 | EUR | USD | 0.9865 | bids | 2022-08-11 15:33:22 | | 773 | EUR | USD | 0.99 | bids | 2022-08-11 17:50:31 | | 1775 | EUR | USD | 0.99 | bids | 2022-08-11 17:50:31 | | 1576 | EUR | USD | 0.98 | bids | 2022-08-11 17:50:31 | | 572 | EUR | USD | 0.99 | bids | 2022-08-11 17:50:31 | | 168 | EUR | USD | 0.99 | bids | 2022-08-11 17:50:31 | | 371 | EUR | USD | 0.95 | bids | 2022-08-11 17:50:31 | | 1177 | EUR | USD | 0.99 | bids | 2022-08-11 17:50:31 | | 1374 | EUR | USD | 0.91 | bids | 2022-08-11 17:50:31 | | 975 | EUR | USD | 0.96 | bids | 2022-08-11 17:50:31 | | 581 | EUR | USD | 0.98465 | bids | 2022-08-11 21:10:27 | | 1784 | EUR | USD | 0.98564 | bids | 2022-08-11 21:10:27 | | 984 | EUR | USD | 0.98123 | bids | 2022-08-11 21:10:27 | | 782 | EUR | USD | 0.98132 | bids | 2022-08-11 21:10:27 | | 1383 | EUR | USD | 0.98115 | bids | 2022-08-11 21:10:27 | | 1585 | EUR | USD | 0.98848 | bids | 2022-08-11 21:10:27 | | 1186 | EUR | USD | 0.98185 | bids | 2022-08-11 21:10:27 | | 380 | EUR | USD | 0.98184 | bids | 2022-08-11 21:10:27 | | 177 | EUR | USD | 0.98148 | bids | 2022-08-11 21:10:27 | +------+---------------+--------------+---------+---------+---------------------+