Loading...Loading chart...
1SELECT
2 DATE_TRUNC('month', date) AS month,
3 ROUND(AVG(close), 2) AS avg_price,
4 ROUND(MAX(close), 2) AS high_price,
5 ROUND(MIN(close), 2) AS low_price
6FROM
7 "@yahoo.finance.daily_prices"
8WHERE
9 symbol = 'BAR'
10GROUP BY
11 DATE_TRUNC('month', date)
12ORDER BY
13 month ASC| month | avg_price | high_price | low_price |
|---|---|---|---|
| 2017-09-01 00:00:00+00 | 13.15 | 13.5 | 12.82 |
| 2017-10-01 00:00:00+00 | 12.8 | 13.01 | 12.68 |
| 2017-11-01 00:00:00+00 | 12.82 | 12.95 | 12.68 |
| 2017-12-01 00:00:00+00 | 12.64 | 13.03 | 12.37 |
| 2018-01-01 00:00:00+00 | 13.3 | 13.54 | 13.09 |
| 2018-02-01 00:00:00+00 | 13.29 | 13.53 | 13.12 |
| 2018-03-01 00:00:00+00 | 13.24 | 13.54 | 13.1 |
| 2018-04-01 00:00:00+00 | 13.34 | 13.49 | 13.16 |
| 2018-05-01 00:00:00+00 | 13.03 | 13.19 | 12.87 |
| 2018-06-01 00:00:00+00 | 12.79 | 13.01 | 12.47 |
| 2018-07-01 00:00:00+00 | 12.35 | 12.57 | 12.2 |
| 2018-08-01 00:00:00+00 | 11.98 | 12.14 | 11.72 |
| 2018-09-01 00:00:00+00 | 11.95 | 12.05 | 11.82 |
| 2018-10-01 00:00:00+00 | 12.13 | 12.31 | 11.86 |
| 2018-11-01 00:00:00+00 | 12.18 | 12.31 | 11.97 |
| 2018-12-01 00:00:00+00 | 12.49 | 12.79 | 12.27 |
| 2019-01-01 00:00:00+00 | 12.9 | 13.16 | 12.77 |
| 2019-02-01 00:00:00+00 | 13.15 | 13.38 | 13.02 |
| 2019-03-01 00:00:00+00 | 12.97 | 13.19 | 12.82 |
| 2019-04-01 00:00:00+00 | 12.82 | 13.05 | 12.69 |
| 2019-05-01 00:00:00+00 | 12.8 | 13.02 | 12.67 |
| 2019-06-01 00:00:00+00 | 13.57 | 14.18 | 13.21 |
| 2019-07-01 00:00:00+00 | 14.11 | 14.41 | 13.8 |
| 2019-08-01 00:00:00+00 | 14.99 | 15.39 | 14.37 |
| 2019-09-01 00:00:00+00 | 15.01 | 15.49 | 14.71 |
| 2019-10-01 00:00:00+00 | 14.89 | 15.05 | 14.75 |
| 2019-11-01 00:00:00+00 | 14.65 | 15.06 | 14.48 |
| 2019-12-01 00:00:00+00 | 14.76 | 15.11 | 14.55 |
| 2020-01-01 00:00:00+00 | 15.56 | 15.81 | 15.23 |
| 2020-02-01 00:00:00+00 | 15.89 | 16.51 | 15.48 |
| 2020-03-01 00:00:00+00 | 15.82 | 16.71 | 14.63 |
| 2020-04-01 00:00:00+00 | 16.81 | 17.28 | 15.85 |
| 2020-05-01 00:00:00+00 | 17.11 | 17.42 | 16.84 |
| 2020-06-01 00:00:00+00 | 17.29 | 17.74 | 16.73 |
| 2020-07-01 00:00:00+00 | 18.41 | 19.65 | 17.65 |
| 2020-08-01 00:00:00+00 | 19.59 | 20.51 | 18.98 |
| 2020-09-01 00:00:00+00 | 19.12 | 19.6 | 18.51 |
| 2020-10-01 00:00:00+00 | 18.9 | 19.18 | 18.59 |
| 2020-11-01 00:00:00+00 | 18.57 | 19.4 | 17.67 |
| 2020-12-01 00:00:00+00 | 18.49 | 18.89 | 18.03 |
| 2021-01-01 00:00:00+00 | 18.55 | 19.39 | 18.14 |
| 2021-02-01 00:00:00+00 | 17.95 | 18.47 | 17.17 |
| 2021-03-01 00:00:00+00 | 17.1 | 17.34 | 16.7 |
| 2021-04-01 00:00:00+00 | 17.5 | 17.84 | 17.16 |
| 2021-05-01 00:00:00+00 | 18.39 | 18.92 | 17.67 |
| 2021-06-01 00:00:00+00 | 18.21 | 18.96 | 17.5 |
| 2021-07-01 00:00:00+00 | 17.95 | 18.17 | 17.64 |
| 2021-08-01 00:00:00+00 | 17.74 | 18.07 | 17.17 |
| 2021-09-01 00:00:00+00 | 17.63 | 18.16 | 17.14 |
| 2021-10-01 00:00:00+00 | 17.63 | 17.93 | 17.41 |
| 2021-11-01 00:00:00+00 | 18.06 | 18.53 | 17.57 |
| 2021-12-01 00:00:00+00 | 17.79 | 18.15 | 17.55 |
| 2022-01-01 00:00:00+00 | 18.02 | 18.33 | 17.74 |
| 2022-02-01 00:00:00+00 | 18.43 | 18.95 | 17.88 |
| 2022-03-01 00:00:00+00 | 19.36 | 20.35 | 19.01 |
| 2022-04-01 00:00:00+00 | 19.19 | 19.62 | 18.71 |
| 2022-05-01 00:00:00+00 | 18.32 | 18.69 | 17.94 |
| 2022-06-01 00:00:00+00 | 18.21 | 18.56 | 17.91 |
| 2022-07-01 00:00:00+00 | 17.17 | 17.9 | 16.82 |
| 2022-08-01 00:00:00+00 | 17.48 | 17.87 | 16.94 |
| 2022-09-01 00:00:00+00 | 16.64 | 17.09 | 16.09 |
| 2022-10-01 00:00:00+00 | 16.51 | 17.1 | 16.11 |
| 2022-11-01 00:00:00+00 | 17.12 | 17.61 | 16.17 |
| 2022-12-01 00:00:00+00 | 17.8 | 18.05 | 17.5 |
| 2023-01-01 00:00:00+00 | 18.84 | 19.28 | 18.16 |
| 2023-02-01 00:00:00+00 | 18.36 | 19.36 | 17.94 |
| 2023-03-01 00:00:00+00 | 18.96 | 19.79 | 17.95 |
| 2023-04-01 00:00:00+00 | 19.81 | 20.21 | 19.62 |
| 2023-05-01 00:00:00+00 | 19.73 | 20.29 | 19.21 |
| 2023-06-01 00:00:00+00 | 19.21 | 19.58 | 18.88 |
| 2023-07-01 00:00:00+00 | 19.3 | 19.58 | 18.9 |
| 2023-08-01 00:00:00+00 | 18.98 | 19.24 | 18.69 |
| 2023-09-01 00:00:00+00 | 18.92 | 19.21 | 18.28 |
| 2023-10-01 00:00:00+00 | 18.96 | 19.86 | 18 |
| 2023-11-01 00:00:00+00 | 19.63 | 20.23 | 19.15 |
| 2023-12-01 00:00:00+00 | 20.11 | 20.55 | 19.57 |
| 2024-01-01 00:00:00+00 | 20.07 | 20.34 | 19.83 |
| 2024-02-01 00:00:00+00 | 20.02 | 20.31 | 19.69 |
| 2024-03-01 00:00:00+00 | 21.38 | 21.96 | 20.59 |
| 2024-04-01 00:00:00+00 | 23.07 | 23.61 | 22.18 |
| 2024-05-01 00:00:00+00 | 23.22 | 23.98 | 22.75 |
| 2024-06-01 00:00:00+00 | 22.98 | 23.42 | 22.61 |
| 2024-07-01 00:00:00+00 | 23.66 | 24.38 | 23.01 |
| 2024-08-01 00:00:00+00 | 24.4 | 24.93 | 23.55 |
| 2024-09-01 00:00:00+00 | 25.42 | 26.4 | 24.6 |
| 2024-10-01 00:00:00+00 | 26.57 | 27.51 | 25.76 |
| 2024-11-01 00:00:00+00 | 26.17 | 27.09 | 25.3 |
| 2024-12-01 00:00:00+00 | 26.04 | 26.81 | 25.58 |
| 2025-01-01 00:00:00+00 | 26.78 | 27.65 | 26.01 |
| 2025-02-01 00:00:00+00 | 28.58 | 29.12 | 27.81 |
| 2025-03-01 00:00:00+00 | 29.46 | 30.84 | 28.47 |
| 2025-04-01 00:00:00+00 | 31.78 | 33.78 | 29.34 |
| 2025-05-01 00:00:00+00 | 32.41 | 33.76 | 31.38 |
| 2025-06-01 00:00:00+00 | 33.06 | 33.87 | 32.26 |
| 2025-07-01 00:00:00+00 | 32.95 | 33.85 | 32.23 |
| 2025-08-01 00:00:00+00 | 33.23 | 34.07 | 32.7 |
| 2025-09-01 00:00:00+00 | 36.27 | 38.06 | 34.89 |
| 2025-10-01 00:00:00+00 | 39.99 | 43.17 | 38 |
| 2025-11-01 00:00:00+00 | 40.24 | 41.55 | 38.83 |
| 2025-12-01 00:00:00+00 | 41.66 | 42.37 | 41.31 |