I am trying to prepare data for candle stick chart. i have some records on mySQL database as shown below:

| Rate     | Date                | |----------|---------------------| | 0.001111 | 2017-11-12 19:13:05 | | 0.001214 | 2017-11-12 19:14:11 | | 0.001612 | 2017-11-12 19:15:42 | | 0.001231 | 2017-11-12 19:16:23 | | 0.001514 | 2017-11-12 19:17:23 | | 0.001611 | 2017-11-12 19:26:33 | | 0.001421 | 2017-11-12 19:27:25 | | 0.001214 | 2017-11-12 19:28:27 | | 0.001611 | 2017-11-12 19:29:55 | |----------|---------------------| 

I want to group below data as shown below:

| Rate     | Date                | |----------|---------------------| | 0.002325 | 2017-11-12 19:10:00 | | 0.004357 | 2017-11-12 19:15:00 | | 0.004357 | 2017-11-12 19:20:00 |  # Auto generated record of missing record. | 0.005857 | 2017-11-12 19:25:00 | |----------|---------------------| 

i was trying to understand calendar table, but i wasn’t able to do with that. i also followed this link https://stackoverflow.com/questions/4342370/grouping-into-interval-of-5-minutes-within-a-time-range but still failed.