Week 3: Apply 2
Ronan Taylor
2026-9-14
Import stock prices
## # A tibble: 7,545 × 8
## symbol date open high low close volume adjusted
## <chr> <date> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 TSLA 2012-01-03 1.93 1.97 1.84 1.87 13921500 1.87
## 2 TSLA 2012-01-04 1.88 1.91 1.83 1.85 9451500 1.85
## 3 TSLA 2012-01-05 1.85 1.86 1.79 1.81 15082500 1.81
## 4 TSLA 2012-01-06 1.81 1.85 1.76 1.79 14794500 1.79
## 5 TSLA 2012-01-09 1.80 1.83 1.74 1.82 13455000 1.82
## 6 TSLA 2012-01-10 1.83 1.85 1.82 1.84 10077000 1.84
## 7 TSLA 2012-01-11 1.84 1.89 1.82 1.88 10084500 1.88
## 8 TSLA 2012-01-12 1.90 1.91 1.85 1.88 10939500 1.88
## 9 TSLA 2012-01-13 1.89 1.90 1.51 1.52 82506000 1.52
## 10 TSLA 2012-01-17 1.77 1.82 1.76 1.77 69774000 1.77
## # ℹ 7,535 more rowsPlot stock prices
#Chapter 5
Filter Rows
## # A tibble: 3,674 × 8
## symbol date open high low close volume adjusted
## <chr> <date> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 AMZN 2015-10-26 30.1 30.5 29.8 30.4 85394000 30.4
## 2 AMZN 2015-10-27 30.4 30.7 30.3 30.6 75742000 30.6
## 3 AMZN 2015-10-28 30.6 30.9 30.5 30.9 78524000 30.9
## 4 AMZN 2015-10-29 30.9 31.4 30.8 31.3 77920000 31.3
## 5 AMZN 2015-10-30 31.3 31.5 31.3 31.3 77488000 31.3
## 6 AMZN 2015-11-02 31.4 31.4 31.0 31.4 56330000 31.4
## 7 AMZN 2015-11-03 31.5 31.5 31.1 31.3 64938000 31.3
## 8 AMZN 2015-11-04 31.4 32.3 31.4 32.0 96810000 32.0
## 9 AMZN 2015-11-05 32.4 32.8 32.2 32.8 94476000 32.8
## 10 AMZN 2015-11-06 32.8 33.1 32.6 33.0 81844000 33.0
## # ℹ 3,664 more rowsArrange Rows
## # A tibble: 7,545 × 8
## symbol date open high low close volume adjusted
## <chr> <date> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 AAPL 2012-02-15 18.4 18.8 17.7 17.8 1506120000 14.9
## 2 AAPL 2013-01-24 16.4 16.6 16.1 16.1 1460852400 13.6
## 3 AAPL 2012-03-14 20.6 21.2 20.5 21.1 1418844000 17.6
## 4 AAPL 2012-11-16 18.8 18.9 18.1 18.8 1266893600 15.9
## 5 AAPL 2013-01-25 16.1 16.3 15.5 15.7 1208026400 13.3
## 6 AAPL 2012-12-06 18.9 19.8 18.5 19.5 1177212400 16.5
## 7 AAPL 2012-03-15 21.4 21.4 20.7 20.9 1159718000 17.5
## 8 AAPL 2012-04-24 20.1 20.3 19.8 20.0 1076149200 16.8
## 9 AAPL 2014-01-28 18.2 18.4 17.9 18.1 1065523200 15.7
## 10 AAPL 2012-11-08 20.0 20.1 19.1 19.2 1056146000 16.2
## # ℹ 7,535 more rowsSelect Column
## # A tibble: 7,545 × 4
## open high low close
## <dbl> <dbl> <dbl> <dbl>
## 1 1.93 1.97 1.84 1.87
## 2 1.88 1.91 1.83 1.85
## 3 1.85 1.86 1.79 1.81
## 4 1.81 1.85 1.76 1.79
## 5 1.80 1.83 1.74 1.82
## 6 1.83 1.85 1.82 1.84
## 7 1.84 1.89 1.82 1.88
## 8 1.90 1.91 1.85 1.88
## 9 1.89 1.90 1.51 1.52
## 10 1.77 1.82 1.76 1.77
## # ℹ 7,535 more rowsAdd Column
## # A tibble: 7,545 × 1
## growth
## <dbl>
## 1 -0.0573
## 2 -0.0333
## 3 -0.0427
## 4 -0.0193
## 5 0.0167
## 6 0.0120
## 7 0.0407
## 8 -0.0153
## 9 -0.374
## 10 -0.00133
## # ℹ 7,535 more rowsSummarise with groups
## # A tibble: 1 × 1
## average
## <dbl>
## 1 96088517.