I have a table with Share transaction times and Price. What is the proper query to get the records counts for each minute for any given hour. I want opening value, closing value, minimum price, maximum price, volume of trade group by each minute for any given hour. Thanks
Sample data
Company_Name|Quote|TrnTime| XXXXXXXXXXXX|90.00|09:55:06| XXXXXXXXXXXX|90.50|09:55:06| XXXXXXXXXXXX|90.40|09:55:06|