In this notebook we will be using House Sales Data from Zillow of the median house sales price by metro area. We will go over the data and then train three models on it to forecast median sales price in the Riverside Metro Area. After that we will test the model on data it hasn’t been trained on. Finally, we will use the models to forecast median sales price for homes in Riverside for the future for which we don’t have data.
We donwloaded the data as a csv from the zillow website. We can read it into r with the code below.
library(tidyverse)
library(modeltime)
library(tidymodels)
library(timetk)
house_sales <- read_csv("C:/Users/Owner/Documents/Data/Metro_median_sale_price_uc_sfrcondo_week.csv")
We have 142 records of 776 variables. Taking a glimpse()
of the data we can see that most of those columns are for the week the
data was collected. We will likely want to pivot it into a longer data
set with a new variable for the week. It does appear we have some
missing data, but it looks pretty negligible.
dim(house_sales)[1] 142 776glimpse(house_sales)Rows: 142
Columns: 776
$ RegionID <dbl> 102001, 394913, 753899, 394463, 394514, 394692, 395209, 394856, 394974, 394347, 39497…
$ SizeRank <dbl> 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 16, 17, 18, 19, 20, 21, 22, 23, 24,…
$ RegionName <chr> "United States", "New York, NY", "Los Angeles, CA", "Chicago, IL", "Dallas, TX", "Hou…
$ RegionType <chr> "country", "msa", "msa", "msa", "msa", "msa", "msa", "msa", "msa", "msa", "msa", "msa…
$ StateName <chr> NA, "NY", "CA", "IL", "TX", "TX", "VA", "FL", "PA", "GA", "AZ", "MA", "CA", "CA", "MI…
$ `2008-02-02` <dbl> 183007, 400000, 475000, 238000, 133250, 139000, 350000, 250000, 200000, 159900, 22500…
$ `2008-02-09` <dbl> 179900, 410000, 501500, 236000, 137500, 136600, 332250, 245450, 214000, 182000, 22000…
$ `2008-02-16` <dbl> 180000, 415000, 520000, 235000, 130900, 134000, 348500, 240000, 195000, 164900, 23450…
$ `2008-02-23` <dbl> 175500, 410000, 523250, 245000, 136000, 149000, 365000, 245000, 195000, 162500, 23300…
$ `2008-03-01` <dbl> 182000, 390000, 489000, 244500, 139500, 147750, 356825, 250000, 199500, 163000, 22750…
$ `2008-03-08` <dbl> 180000, 390000, 499545, 230500, 143000, 143000, 348495, 250000, 210000, 170000, 22550…
$ `2008-03-15` <dbl> 185000, 400000, 510000, 235250, 141750, 142200, 340000, 246750, 210125, 169950, 22500…
$ `2008-03-22` <dbl> 186000, 400500, 487000, 235000, 145000, 144500, 360000, 240900, 205000, 172500, 22500…
$ `2008-03-29` <dbl> 186500, 397495, 490000, 244000, 147500, 141950, 350000, 240000, 210000, 174450, 22500…
$ `2008-04-05` <dbl> 185000, 395500, 495000, 255000, 148500, 150000, 350000, 242250, 210000, 172900, 22650…
$ `2008-04-12` <dbl> 185000, 387000, 507000, 237500, 135000, 135000, 350000, 230000, 217250, 179650, 23000…
$ `2008-04-19` <dbl> 187000, 405000, 510000, 230000, 140000, 142080, 363250, 260000, 209900, 165000, 22600…
$ `2008-04-26` <dbl> 184000, 400000, 489000, 237500, 147500, 141000, 355000, 245000, 206725, 172473, 22900…
$ `2008-05-03` <dbl> 186000, 399000, 500000, 235000, 147000, 148500, 365000, 250000, 210000, 174000, 22395…
$ `2008-05-10` <dbl> 185000, 393500, 480750, 244500, 142900, 145000, 350000, 250000, 220000, 181645, 22000…
$ `2008-05-17` <dbl> 187500, 410000, 500000, 238250, 138900, 145850, 367900, 250000, 212000, 174500, 23800…
$ `2008-05-24` <dbl> 186000, 400000, 495750, 249000, 144100, 149900, 373195, 238500, 227000, 180000, 22000…
$ `2008-05-31` <dbl> 191000, 410000, 480000, 236000, 155000, 155000, 361000, 238000, 224450, 175550, 23300…
$ `2008-06-07` <dbl> 187000, 392500, 480000, 248500, 159325, 152900, 363660, 248700, 222500, 177500, 23000…
$ `2008-06-14` <dbl> 190000, 400000, 480000, 241500, 152000, 153950, 358000, 250000, 229500, 179900, 22868…
$ `2008-06-21` <dbl> 195000, 410000, 504000, 250000, 160000, 155000, 368100, 255000, 220000, 190000, 21450…
$ `2008-06-28` <dbl> 195900, 411684, 470000, 255000, 146250, 149950, 366500, 255000, 230500, 186000, 22808…
$ `2008-07-05` <dbl> 194000, 415000, 480000, 255000, 158000, 155000, 365000, 245000, 233000, 174650, 21995…
$ `2008-07-12` <dbl> 195000, 422000, 480000, 256000, 154000, 153600, 360000, 249000, 232500, 194900, 21500…
$ `2008-07-19` <dbl> 195000, 410000, 479750, 255000, 162600, 158000, 375000, 263950, 240500, 181250, 21825…
$ `2008-07-26` <dbl> 190000, 420000, 460000, 256250, 150000, 150000, 379450, 250000, 230000, 167700, 21500…
$ `2008-08-02` <dbl> 191000, 415000, 465000, 254500, 151000, 152000, 370000, 240000, 230000, 175000, 21000…
$ `2008-08-09` <dbl> 185000, 417000, 448500, 250000, 153000, 149000, 371500, 261000, 230000, 176000, 21500…
$ `2008-08-16` <dbl> 190000, 432500, 465000, 249000, 152900, 150000, 349900, 245000, 234000, 170200, 21647…
$ `2008-08-23` <dbl> 188000, 420000, 450000, 250000, 152500, 158000, 359050, 253000, 232000, 171900, 21000…
$ `2008-08-30` <dbl> 190000, 415000, 445000, 259750, 146770, 150600, 360000, 250000, 235000, 167500, 20700…
$ `2008-09-06` <dbl> 180000, 412000, 460000, 250000, 147000, 148250, 343000, 235000, 226000, 169000, 20000…
$ `2008-09-13` <dbl> 183500, 394938, 430000, 245000, 142600, 138000, 336000, 221000, 225000, 165000, 20000…
$ `2008-09-20` <dbl> 181000, 399000, 430000, 240500, 140000, 138000, 340000, 220000, 220000, 155800, 20000…
$ `2008-09-27` <dbl> 178000, 397250, 425000, 237500, 141100, 159275, 323450, 226450, 210000, 157500, 19900…
$ `2008-10-04` <dbl> 178900, 395000, 435000, 235000, 140000, 152850, 310000, 220000, 207000, 160000, 20200…
$ `2008-10-11` <dbl> 177500, 382683, 477500, 230000, 135150, 139900, 302375, 229000, 210000, 155000, 19400…
$ `2008-10-18` <dbl> 180000, 390000, 435000, 225300, 144000, 139500, 328650, 231000, 220000, 168000, 20500…
$ `2008-10-25` <dbl> 176000, 385000, 430000, 235000, 141500, 130975, 309313, 220000, 205000, 155000, 18500…
$ `2008-11-01` <dbl> 180000, 380000, 415000, 229000, 141000, 127585, 303000, 210000, 202000, 155000, 20990…
$ `2008-11-08` <dbl> 171550, 380000, 400000, 230000, 136863, 130000, 310135, 220000, 219000, 158750, 18745…
$ `2008-11-15` <dbl> 175000, 380000, 415000, 231800, 140000, 128000, 306500, 217000, 215000, 147000, 19900…
$ `2008-11-22` <dbl> 173500, 371000, 425000, 227000, 133700, 130000, 315000, 201750, 204250, 145000, 18794…
$ `2008-11-29` <dbl> 173500, 375000, 400000, 215000, 134000, 135000, 300000, 205000, 201500, 139200, 18500…
$ `2008-12-06` <dbl> 170000, 370000, 410000, 220000, 132000, 123000, 303000, 206000, 213000, 145000, 17265…
$ `2008-12-13` <dbl> 172500, 375000, 425000, 220000, 132106, 121625, 304500, 222750, 197000, 149300, 17200…
$ `2008-12-20` <dbl> 172000, 375000, 417000, 224000, 135000, 136000, 303150, 216500, 196000, 145000, 17200…
$ `2008-12-27` <dbl> 173000, 379000, 390000, 215500, 133000, 128000, 290000, 195000, 198000, 149625, 16000…
$ `2009-01-03` <dbl> 169500, 370000, 410000, 212500, 131000, 132211, 279000, 197000, 195000, 147500, 16500…
$ `2009-01-10` <dbl> 167000, 359985, 390000, 218000, 129475, 124000, 310000, 200000, 202500, 158000, 15340…
$ `2009-01-17` <dbl> 168000, 370000, 380000, 212750, 121250, 120000, 324000, 180000, 186000, 141300, 17500…
$ `2009-01-24` <dbl> 165000, 362500, 398500, 215500, 130000, 125000, 310000, 182900, 188000, 140000, 16500…
$ `2009-01-31` <dbl> 170000, 366000, 380000, 211500, 123750, 125000, 315000, 190000, 205000, 150000, 16750…
$ `2009-02-07` <dbl> 163500, 372500, 400000, 210500, 136000, 122750, 305000, 180000, 209000, 135000, 17175…
$ `2009-02-14` <dbl> 164900, 367000, 410000, 212000, 124500, 127250, 298000, 195000, 195976, 153200, 15500…
$ `2009-02-21` <dbl> 167000, 360000, 405000, 215000, 140000, 131500, 279000, 185000, 190000, 140000, 16500…
$ `2009-02-28` <dbl> 170000, 360000, 400000, 215000, 137000, 128824, 294000, 185000, 195000, 137750, 16500…
$ `2009-03-07` <dbl> 165000, 355000, 406000, 215000, 144000, 137000, 300000, 190000, 200000, 155000, 17000…
$ `2009-03-14` <dbl> 167000, 365000, 390000, 206000, 130000, 137950, 298250, 170000, 197500, 147750, 15250…
$ `2009-03-21` <dbl> 169041, 340000, 396500, 218500, 140000, 132000, 290000, 183000, 195000, 143400, 17000…
$ `2009-03-28` <dbl> 165650, NA, 385000, 235000, 133900, 142950, 286000, 175000, 195750, 139000, 155000, 2…
$ `2009-04-04` <dbl> 167500, 345000, 390000, 221500, 136000, 144200, 315000, 168000, 199900, 150000, 15800…
$ `2009-04-11` <dbl> 165000, 355000, 390000, 224750, 130000, 143250, 283000, 170000, 200000, 150000, 15990…
$ `2009-04-18` <dbl> 165000, 355000, 395250, 211500, 134900, 137500, 293000, 179000, 197250, 143478, 16500…
$ `2009-04-25` <dbl> 165000, 351500, 380000, 224500, 138700, 142000, 299900, 165000, 190000, 132300, 15650…
$ `2009-05-02` <dbl> 171000, 350200, 390000, 225000, 142250, 149900, 322000, 175000, 208000, 150001, 16000…
$ `2009-05-09` <dbl> 168500, 355000, 393000, 225000, 150000, 148000, 310100, 170000, 210850, 151900, 16000…
$ `2009-05-16` <dbl> 170000, 365000, 412000, 217750, 144500, 135750, 300000, 170000, 205000, 155000, 16450…
$ `2009-05-23` <dbl> 170000, 358500, 410000, 214250, 152000, 155000, 310000, 175000, 218000, 152000, 16280…
$ `2009-05-30` <dbl> 176800, 365000, 416000, 227500, 144900, 150000, 312500, 190000, 204950, 135000, 16406…
$ `2009-06-06` <dbl> 175000, 350000, 410000, 220000, 158000, 159000, 310000, 189000, 215550, 159900, 16300…
$ `2009-06-13` <dbl> 175000, 375000, 415000, 225000, 149900, 155000, 284900, 185000, 207000, 157000, 15300…
$ `2009-06-20` <dbl> 180000, 369000, 425000, 230000, 154000, 157500, 335000, 186000, 225000, 159900, 16300…
$ `2009-06-27` <dbl> 180000, 360000, 415000, 225000, 157500, 158900, 320000, 193000, 222600, 160000, 15500…
$ `2009-07-04` <dbl> 182500, 369500, 410000, 230500, 159900, 159500, 348000, 200000, 228000, 150000, 15995…
$ `2009-07-11` <dbl> 175000, 372250, 425000, 235000, 150260, 155000, 330000, 195000, 223000, 168000, 15975…
$ `2009-07-18` <dbl> 179900, 379125, 415000, 229000, 151000, 160000, 319950, 189900, 224900, 174500, 15600…
$ `2009-07-25` <dbl> 175000, 370000, 401000, 225000, 152000, 165000, 330000, 195000, 217000, 160000, 15500…
$ `2009-08-01` <dbl> 180000, 381500, 415000, 225000, 148000, 155000, 340000, 189000, 216000, 165000, 15700…
$ `2009-08-08` <dbl> 176500, 371000, 400000, 235000, 156900, 156000, 340000, 187500, 225000, 167000, 14725…
$ `2009-08-15` <dbl> 179755, 377500, 410000, 232500, 150000, 155000, 325000, 180000, 230000, 162250, 14900…
$ `2009-08-22` <dbl> 177500, 380000, 401000, 220000, 156000, 158500, 329300, 184900, 220000, 146100, 15500…
$ `2009-08-29` <dbl> 177000, 380839, 415000, 222000, 150500, 149500, 315000, 180000, 234900, 150000, 14990…
$ `2009-09-05` <dbl> 172500, 375000, 400000, 222000, 148000, 156975, 320000, 181000, 215000, 145000, 14900…
$ `2009-09-12` <dbl> 170150, 380000, 430000, 220000, 139900, 155500, 303500, 171000, 217000, 155950, 15290…
$ `2009-09-19` <dbl> 171900, 365000, 415000, 215095, 140000, 151000, 299500, 189000, 206650, 150000, 15000…
$ `2009-09-26` <dbl> 170000, 370000, 418000, 220000, 143000, 143600, 295000, 175000, 207000, 145000, 15000…
$ `2009-10-03` <dbl> 170000, 355000, 414000, 213000, 144000, 154840, 308000, 175000, 207000, 150000, 14500…
$ `2009-10-10` <dbl> 166000, 363250, 413500, 215000, 143000, 139000, 300562, 165000, 210000, 161500, 14000…
$ `2009-10-17` <dbl> 168900, 365000, 395000, 210000, 136950, 145000, 300000, 167450, 199900, 149950, 14912…
$ `2009-10-24` <dbl> 168000, 366000, 410000, 210000, 142000, 144500, 277000, 180000, 199900, 150000, 14500…
$ `2009-10-31` <dbl> 169000, 360000, 390000, 200000, 139900, 139000, 295000, 165000, 201250, 145000, 14500…
$ `2009-11-07` <dbl> 169900, 395000, 395000, 200000, 139900, 138090, 299000, 179200, 203000, 155000, 15000…
$ `2009-11-14` <dbl> 165000, 355000, 400000, 208000, 140000, 136250, 298985, 163000, 198000, 149900, 14170…
$ `2009-11-21` <dbl> 168000, 352000, 400000, 210000, 139900, 147500, 295000, 161000, 200000, 143000, 14500…
$ `2009-11-28` <dbl> 165000, 355000, 402000, 195000, 140000, 152100, 280000, 166000, 203000, 145000, 14200…
$ `2009-12-05` <dbl> 165000, 350000, 400000, 200000, 136000, 136500, 290000, 172000, 207500, 150000, 14300…
$ `2009-12-12` <dbl> 170000, 350000, 400000, 207000, 135950, 137900, 285000, 160500, 199000, 150000, 14495…
$ `2009-12-19` <dbl> 172000, 355000, 400000, 207000, 133800, 144000, 292000, 167250, 200000, 138000, 14263…
$ `2009-12-26` <dbl> 170000, 360000, 390000, 204000, 138000, 142000, 300000, 175000, 205000, 129000, 13300…
$ `2010-01-02` <dbl> 170000, 360000, 380000, 190500, 140000, 142250, 277375, 170000, 201000, 145000, 13902…
$ `2010-01-09` <dbl> 170000, 359225, 380000, 209500, 132000, 139950, 288500, 167000, 189950, 136000, 14800…
$ `2010-01-16` <dbl> 172900, 365000, 400000, 205000, 130000, 132500, 295000, 165000, 196000, 136600, 13225…
$ `2010-01-23` <dbl> 168000, 372000, 395500, 203600, 134900, 144900, 283000, 160000, 214900, 129000, 14000…
$ `2010-01-30` <dbl> 171000, 375000, 380000, 200000, 122750, 138000, 259900, 155000, 210000, 138000, 14000…
$ `2010-02-06` <dbl> 165000, 375000, 370000, 200000, 137850, 139215, 284900, 170000, 210000, 127000, 13120…
$ `2010-02-13` <dbl> 160000, 385000, 375000, 190000, 120900, 125900, 256500, 152000, 193250, 119900, 14000…
$ `2010-02-20` <dbl> 165000, 367500, 389000, 199500, 137500, 135500, 290000, 150000, 205000, 130375, 14300…
$ `2010-02-27` <dbl> 170000, 364000, 390000, 195000, 144900, 144097, 274000, 155000, 209250, 125000, 14500…
$ `2010-03-06` <dbl> 167000, 380500, 380000, 202500, 145000, 150000, 299000, 159000, 205750, 140000, 13790…
$ `2010-03-13` <dbl> 168000, 375000, 410000, 201500, 137877, 150000, 275000, 160000, 187000, 143350, 14350…
$ `2010-03-20` <dbl> 180000, 330000, 390000, 210000, 145000, 135000, 295000, 160000, 196500, 129000, 14000…
$ `2010-03-27` <dbl> 166000, 370000, 390000, 208750, 138000, 148250, 274000, 155000, 204950, 125000, 14500…
$ `2010-04-03` <dbl> 170000, 362725, 400000, 210000, 151814, 152000, 290000, 165000, 209300, 129900, 14500…
$ `2010-04-10` <dbl> 165000, 375000, 399000, 208000, 147500, 144500, 295000, 154500, 213000, 161500, 14000…
$ `2010-04-17` <dbl> 166000, 357750, 393000, 202375, 143000, 147000, 309450, 153000, 200000, 143500, 14000…
$ `2010-04-24` <dbl> 165000, 360000, 395500, 214000, 149700, 145000, 305000, 155000, 209900, 130000, 14500…
$ `2010-05-01` <dbl> 167900, 355000, 378500, 210000, 152000, 148000, 320000, 150000, 211000, 147900, 14700…
$ `2010-05-08` <dbl> 170000, 365000, 410000, 210250, 150000, 149950, 322450, 175000, 212000, 150000, 14050…
$ `2010-05-15` <dbl> 168700, 367000, 406700, 213000, 140000, 144000, 295000, 155500, 200000, 154900, 14750…
$ `2010-05-22` <dbl> 169849, 375000, 405000, 210000, 151000, 145000, 307500, 160000, 212500, 140000, 14500…
$ `2010-05-29` <dbl> 174500, 370000, 405000, 202750, 149300, 146000, 322500, 160000, 212000, 150000, 14900…
$ `2010-06-05` <dbl> 170000, 375000, 394000, 210450, 164000, 153000, 300000, 165000, 215000, 139900, 14300…
$ `2010-06-12` <dbl> 172000, 363000, 390000, 220000, 149900, 150750, 312250, 175000, 208000, 157000, 14200…
$ `2010-06-19` <dbl> 175000, 370000, 395000, 228500, 149000, 153000, 305000, 170000, 215000, 137000, 14000…
$ `2010-06-26` <dbl> 180000, 379000, 393000, 229750, 154000, 154500, 327000, 164900, 224000, 144000, 14000…
$ `2010-07-03` <dbl> 180000, 378000, 399000, 220000, 152250, 147450, 329000, 165000, 237000, 140000, 14200…
$ `2010-07-10` <dbl> 177500, 380000, 400000, 212000, 144503, 150000, 330000, 163756, 221000, 136000, 13200…
$ `2010-07-17` <dbl> 185000, 378000, 399000, 210000, 153750, 154000, 355000, 156000, 235000, 148000, 13100…
$ `2010-07-24` <dbl> 180725, 395000, 400000, 213000, 152500, 154500, 342500, 155000, 225000, 146500, 14000…
$ `2010-07-31` <dbl> 181000, 400000, 399500, 220000, 154000, 151000, 327000, 167500, 225000, 141900, 14000…
$ `2010-08-07` <dbl> 176000, 399000, 382000, 225000, 155806, 140000, 315000, 165000, 228000, 139950, 12900…
$ `2010-08-14` <dbl> 179900, 410000, 400000, 235000, 153700, 157500, 312000, 165000, 214500, 138500, 13500…
$ `2010-08-21` <dbl> 180000, 392500, 410000, 225000, 162950, 156000, 305000, 170000, 235000, 124000, 13000…
$ `2010-08-28` <dbl> 179925, 400000, 400000, 230000, 145000, 152000, 329450, 155000, 225000, 135000, 13490…
$ `2010-09-04` <dbl> 178500, 400000, 385000, 200000, 157000, 148750, 330000, 158250, 227618, 137900, 13500…
$ `2010-09-11` <dbl> 178000, NA, 415000, 205000, 141000, 145000, 324664, 155000, 228000, 134575, 138275, 3…
$ `2010-09-18` <dbl> 173950, NA, 400000, 210500, 144000, 152000, 329900, 165000, 225000, 131000, 135750, 3…
$ `2010-09-25` <dbl> 170000, 395000, 410000, 196000, 146900, 140000, 310000, 155000, 211000, 128500, 13275…
$ `2010-10-02` <dbl> 172500, 380000, 385000, 205000, 138000, 150000, 310000, 150000, 212000, 125000, 13800…
$ `2010-10-09` <dbl> 166900, 372500, 392000, 205000, 145500, 138000, 320000, 160000, 220000, 129980, 13300…
$ `2010-10-16` <dbl> 167500, 359000, 380000, 197750, 134000, 141000, 301000, 160000, 205000, 117500, 13500…
$ `2010-10-23` <dbl> 168000, 385000, 380000, 193000, 139250, 138000, 325000, 155000, 216500, 129000, 14005…
$ `2010-10-30` <dbl> 170000, 375000, 376000, 210000, 138000, 146500, 315000, 145000, 197000, 119900, 13395…
$ `2010-11-06` <dbl> 166000, 380000, 380000, 194023, 141350, 149000, 314750, 153000, 205000, 125750, 12500…
$ `2010-11-13` <dbl> 168675, 370000, 399500, 180000, 143800, 130000, 314000, 163500, 207000, 124900, 13775…
$ `2010-11-20` <dbl> 170000, 371000, 398000, 195000, 148250, 146850, 326500, 150000, 209900, 117000, 14000…
$ `2010-11-27` <dbl> 166000, 390000, 380000, 180000, 133000, 149700, 339949, 153750, 205000, 123250, 12350…
$ `2010-12-04` <dbl> 170000, 349900, 385000, 200000, 145710, 145000, 310000, 150000, 205000, 125000, 13500…
$ `2010-12-11` <dbl> 170000, 375000, 380000, 201000, 144000, 148450, 340000, 139450, 209900, 126500, 13550…
$ `2010-12-18` <dbl> 172500, 357000, 387250, 195000, 140000, 148000, 319000, 156000, 215000, 130750, 13990…
$ `2010-12-25` <dbl> 169000, 373000, 380000, 190000, 143500, 155000, 325000, 145000, 200000, 130000, 12995…
$ `2011-01-01` <dbl> 165000, 360000, 380000, 185000, 145000, 150000, 289900, 150000, 203000, 138000, 11990…
$ `2011-01-08` <dbl> 165000, 375000, 375000, 195000, 147950, 139980, 320000, 157000, 196700, 133000, 13000…
$ `2011-01-15` <dbl> 169000, 367476, 375000, 199900, 126000, 131450, 288000, 145000, 197500, 145000, 13290…
$ `2011-01-22` <dbl> 163000, 357000, 363000, 185000, 140000, 134700, 299900, 137750, 213200, 125000, 13000…
$ `2011-01-29` <dbl> 160000, 370000, 369000, 195000, 130000, 125000, 272000, 135000, 205000, 125000, 13000…
$ `2011-02-05` <dbl> 165000, 365000, 360002, 182000, 132500, 140000, 300000, 137000, 209000, 125000, 12825…
$ `2011-02-12` <dbl> 155500, 380000, 370000, 180000, 140000, 121000, 306450, 135000, 209000, 115000, 11725…
$ `2011-02-19` <dbl> 162500, 373000, 380000, 191250, 140000, 139450, 305000, 143000, 199950, 110000, 13500…
$ `2011-02-26` <dbl> 163250, 375000, 375000, 190500, 135000, 149900, 320000, 154250, 200000, 106000, 13000…
$ `2011-03-05` <dbl> 164000, 360000, 365000, 200000, 141500, 152700, 315000, 145250, 199350, 125000, 13200…
$ `2011-03-12` <dbl> 160000, 360000, 381000, 184750, 138750, 145000, 297000, 129900, 180000, 121500, 12500…
$ `2011-03-19` <dbl> 160000, 360000, 399500, 181000, 134950, 154000, 309950, 135000, 190000, 107000, 13240…
$ `2011-03-26` <dbl> 158000, 349900, 380000, 170000, 136000, 134000, 315240, 140000, 190000, 104900, 12450…
$ `2011-04-02` <dbl> 165000, 360000, 390000, 185500, 140000, 142000, 325000, 132000, 206500, 116500, 13000…
$ `2011-04-09` <dbl> 160000, 355000, 395000, 195000, 141000, 134900, 300000, 142000, 199000, 125000, 12900…
$ `2011-04-16` <dbl> 160000, 363000, 381000, 187000, 129500, 143000, 315000, 142500, 202500, 125000, 13000…
$ `2011-04-23` <dbl> 162500, 370000, 375000, 194000, 138000, 145000, 320000, 150000, 200000, 128000, 12700…
$ `2011-04-30` <dbl> 165000, 373295, 383000, 195000, 145000, 139000, 330000, 140000, 198900, 120000, 12900…
$ `2011-05-07` <dbl> 164000, 355000, 370000, 190000, 153500, 145250, 346000, 155000, 205000, 117000, 12500…
$ `2011-05-14` <dbl> 164900, 365000, 399000, 195000, 138000, 146000, 326000, 150000, 195000, 138750, 11775…
$ `2011-05-21` <dbl> 167000, 375000, 390000, 190500, 150000, 142950, 340000, 166000, 199950, 115900, 12490…
$ `2011-05-28` <dbl> 170000, 360000, 379000, 198750, 149675, 152125, 357500, 150000, 202362, 115000, 12500…
$ `2011-06-04` <dbl> 170000, 362078, 385000, 190750, 155000, 155000, 345000, 155500, 220000, 126700, 12850…
$ `2011-06-11` <dbl> 167500, 362250, 396250, 200000, 150000, 162000, 340000, 155000, 205550, 134000, 12897…
$ `2011-06-18` <dbl> 172000, 375000, 395000, 210000, 149000, 160000, 340000, 159450, 220000, 121450, 12525…
$ `2011-06-25` <dbl> 172435, 375000, 388500, 205000, 153000, 155000, 350000, 155000, 230000, 137000, 12000…
$ `2011-07-02` <dbl> 179000, 379000, 383250, 204000, 147450, 154000, 343750, 155000, 230000, 123000, 12500…
$ `2011-07-09` <dbl> 170000, 378500, 400000, 210000, 152900, 149350, 340000, 158000, 224900, 117150, 12450…
$ `2011-07-16` <dbl> 172000, 385000, 400000, 205000, 148317, 152650, 350000, 150000, 224500, 150000, 12500…
$ `2011-07-23` <dbl> 170000, 382500, 400000, 200000, 158700, 150000, 361500, 150000, 235000, 129700, 11995…
$ `2011-07-30` <dbl> 170000, 390000, 370000, 200000, 152000, 145000, 340000, 148000, 215000, 140000, 12080…
$ `2011-08-06` <dbl> 167450, 380000, 370000, 202500, 157250, 158000, 329000, 153000, 214450, 129000, 12390…
$ `2011-08-13` <dbl> 169900, 379000, 390000, 213250, 150000, 151900, 334950, 157500, 220000, 147900, 11850…
$ `2011-08-20` <dbl> 169900, 380000, 390500, 210000, 157000, 149950, 335000, 145000, 220000, 148000, 12500…
$ `2011-08-27` <dbl> 166000, 375090, 365000, 200000, 147000, 147000, 343500, 150000, 225000, 129000, 11825…
$ `2011-09-03` <dbl> 167000, 379000, 365000, 185000, 150000, 149900, 347500, 147500, 219000, 144950, 12500…
$ `2011-09-10` <dbl> 160000, NA, 390000, 192000, 139000, 145000, 321000, 136250, 207000, 116000, 118750, 3…
$ `2011-09-17` <dbl> 164500, 382000, 384750, 185000, 144500, 141000, 320000, 149000, 200000, 134000, 12000…
$ `2011-09-24` <dbl> 160000, 376000, 389000, 174000, 143201, 147500, 316000, 141000, 195000, 135000, 12000…
$ `2011-10-01` <dbl> 164628, 355000, 380000, 170000, 139000, 145000, 325000, 140000, 209450, 135000, 12111…
$ `2011-10-08` <dbl> 158000, 374359, 350000, 175750, 143000, 137000, 287000, 141000, 207000, 125894, 12075…
$ `2011-10-15` <dbl> 160000, 357250, 359000, 183000, 137500, 151245, 300000, 140000, 213000, 125000, 11725…
$ `2011-10-22` <dbl> 160000, 355000, 375000, 170500, 143000, 138250, 300000, 148800, 189450, 127900, 11600…
$ `2011-10-29` <dbl> 160000, 337000, 360000, 166000, 140500, 140000, 310000, 137000, 195000, 129900, 12500…
$ `2011-11-05` <dbl> 159000, 340000, 350000, 168375, 138999, 143000, 299900, 150000, 192500, 120000, 12290…
$ `2011-11-12` <dbl> 156500, 335000, 380000, 170000, 135000, 139900, 295000, 139600, 195000, 126000, 12050…
$ `2011-11-19` <dbl> 160000, 337250, 363000, 162000, 139700, 142000, 305000, 145000, 193000, 132900, 12625…
$ `2011-11-26` <dbl> 158000, 350000, 350000, 159900, 132500, 151712, 326000, 139950, 197000, 125000, 11500…
$ `2011-12-03` <dbl> 161000, 341000, 358000, 170000, 145000, 148000, 320000, 142500, 200000, 140000, 12350…
$ `2011-12-10` <dbl> 156000, 344000, 360000, 164500, 142750, 137250, 311000, 137100, 195000, 114900, 12600…
$ `2011-12-17` <dbl> 161000, 327761, 360000, 167000, 148000, 151700, 309150, 145000, 205000, 129950, 12900…
$ `2011-12-24` <dbl> 158000, 340000, 350000, 161000, 148000, 146700, 300000, 149250, 205000, 115000, 12500…
$ `2011-12-31` <dbl> 155000, 350000, 350000, 160000, 140000, 153500, 276500, 142000, 187000, 119000, 12490…
$ `2012-01-07` <dbl> 155000, 343009, 344000, 162000, 139500, 142012, 290000, 145000, 189950, 109900, 12450…
$ `2012-01-14` <dbl> 155000, 333000, 350000, 160000, 127000, 130000, 285000, 125000, 192000, 120500, 12500…
$ `2012-01-21` <dbl> 156000, 330000, 350000, 160000, 135000, 123000, 290000, 150000, 192525, 120000, 12870…
$ `2012-01-28` <dbl> 153000, 345000, 340000, 160000, 138948, 125000, 281250, 138500, 198000, 124000, 13100…
$ `2012-02-04` <dbl> 153400, 348750, 330000, 157500, 142458, 129000, 300000, 145000, 197000, 120000, 12500…
$ `2012-02-11` <dbl> 149900, 330000, 350000, 150000, 134900, 125000, 280000, 140000, 194250, 106420, 12252…
$ `2012-02-18` <dbl> 152399, 339000, 349000, 155000, 138475, 133950, 292500, 132500, 178000, 114900, 13000…
$ `2012-02-25` <dbl> 152975, 331000, 370000, 150000, 142700, 133901, 270000, 145000, 200000, 132000, 13000…
$ `2012-03-03` <dbl> 159000, 340000, 350000, 158000, 154500, 140000, 320000, 139000, 183000, 144000, 13100…
$ `2012-03-10` <dbl> 157000, 347000, 380000, 156500, 143000, 139900, 305000, 142000, 197000, 120050, 13900…
$ `2012-03-17` <dbl> 160000, 350000, 355500, 164000, 156500, 150500, 298500, 140000, 179900, 130000, 14317…
$ `2012-03-24` <dbl> 158000, 345000, 365000, 168000, 147000, 145000, 318000, 140000, 180000, 132000, 13545…
$ `2012-03-31` <dbl> 162500, 324000, 365000, 175000, 150750, 149900, 332000, 140000, 186000, 145750, 13900…
$ `2012-04-07` <dbl> 165000, 340000, 375000, 179950, 153000, 160000, 332300, 146000, 196500, 139900, 14200…
$ `2012-04-14` <dbl> 161000, 350000, 390000, 173000, 143250, 150000, 325000, 145000, 195000, 139900, 14200…
$ `2012-04-21` <dbl> 165000, 370000, 385000, 185000, 152000, 149700, 315000, 151500, 189313, 152200, 14800…
$ `2012-04-28` <dbl> 167000, 335000, 376000, 182250, 159700, 159900, 344900, 144000, 197900, 151950, 14990…
$ `2012-05-05` <dbl> 171000, 349000, 365000, 190000, 161500, 155228, 360000, 163000, 210000, 154500, 15000…
$ `2012-05-12` <dbl> 168000, 357500, 377500, 185000, 156560, 150000, 350000, 150000, 210000, 138778, 15000…
$ `2012-05-19` <dbl> 170000, 355500, 375000, 182500, 160000, 154000, 350000, 150000, 190000, 155000, 15320…
$ `2012-05-26` <dbl> 170000, 350000, 368000, 185000, 160000, 163352, 358000, 160000, 217000, 154500, 15800…
$ `2012-06-02` <dbl> 180000, 362000, 389750, 190000, 165000, 168500, 368500, 165000, 210000, 178000, 15500…
$ `2012-06-09` <dbl> 175000, 369784, 386000, 202000, 169000, 162000, 364900, 167000, 216500, 155950, 15400…
$ `2012-06-16` <dbl> 179500, 362500, 384500, 209000, 165000, 168000, 350000, 170000, 220000, 166000, 15833…
$ `2012-06-23` <dbl> 179000, 383875, 380000, 198000, 162500, 163900, 360000, 159500, 225000, 150000, 15500…
$ `2012-06-30` <dbl> 180500, 379500, 389500, 202500, 165000, 161000, 354000, 160000, 222950, 156315, 15500…
$ `2012-07-07` <dbl> 177000, 361000, 375750, 207000, 165250, 159950, 376300, 170000, 221750, 155000, 14736…
$ `2012-07-14` <dbl> 179000, 374700, 389500, 203000, 159500, 160000, 363500, 165000, 225500, 152000, 15500…
$ `2012-07-21` <dbl> 178000, 395000, 390000, 205000, 162750, 161000, 370000, 165000, 225000, 170000, 15000…
$ `2012-07-28` <dbl> 176000, 375000, 395000, 196000, 163000, 161750, 350000, 165000, 233000, 159450, 15510…
$ `2012-08-04` <dbl> 179900, 365000, 385000, 199500, 165000, 165000, 356000, 165000, 224000, 158000, 15590…
$ `2012-08-11` <dbl> 175000, 360000, 395000, 197000, 159900, 151800, 344000, 160000, 225000, 145000, 15450…
$ `2012-08-18` <dbl> 177000, 370000, 385000, 192000, 162000, 155000, 345000, 169550, 219000, 151000, 16000…
$ `2012-08-25` <dbl> 175000, 371500, 389000, 195000, 157000, 153000, 344000, 160000, 222000, 145000, 15000…
$ `2012-09-01` <dbl> 178000, 375000, 389000, 190000, 160000, 145000, 345000, 165000, 225000, 152900, 15900…
$ `2012-09-08` <dbl> 170000, 356500, 400000, 188000, 164990, 164500, 330000, 165000, 213500, 141500, 16000…
$ `2012-09-15` <dbl> 172000, 390000, 385000, 193000, 157750, 150450, 310000, 162000, 207000, 140000, 15500…
$ `2012-09-22` <dbl> 170000, 362250, 396000, 175000, 158000, 153415, 330000, 160000, 203000, 140000, 15800…
$ `2012-09-29` <dbl> 171000, 354900, 380750, 180000, 150000, 148000, 340000, 165000, 205950, 147750, 15587…
$ `2012-10-06` <dbl> 170000, 375000, 380000, 177900, 158000, 158000, 332750, 156000, 214000, 135000, 16020…
$ `2012-10-13` <dbl> 169000, 346000, 390000, 172500, 151500, 150000, 328900, 156250, 205000, 129650, 15990…
$ `2012-10-20` <dbl> 170000, 350000, 380000, 163750, 155000, 154000, 312250, 166000, 193000, 135000, 15500…
$ `2012-10-27` <dbl> 168000, 340000, 385000, 157750, 145000, 149950, 310000, 155000, 200000, 142000, 15787…
$ `2012-11-03` <dbl> 167500, 388000, 380000, 175000, 155000, 146281, 350000, 165000, 202000, 148000, 16057…
$ `2012-11-10` <dbl> 168500, 348000, 400000, 172000, 150350, 160000, 320000, 166000, 195000, 135000, 16000…
$ `2012-11-17` <dbl> 172500, 347000, 416000, 171000, 153500, 155000, 332500, 163000, 207000, 141000, 16500…
$ `2012-11-24` <dbl> 170000, 342000, 375000, 171815, 155500, 157900, 320000, 160000, 216500, 129900, 16620…
$ `2012-12-01` <dbl> 175000, 355000, 390000, 172000, 148000, 153250, 320000, 165700, 205000, 150000, 16800…
$ `2012-12-08` <dbl> 170000, 350000, 400000, 167750, 151000, 164500, 335000, 169000, 206500, 152500, 16800…
$ `2012-12-15` <dbl> 171000, 340000, 400000, 175000, 153300, 147000, 310000, 173000, 210000, 144650, 16000…
$ `2012-12-22` <dbl> 171833, 350000, 410000, 166750, 155500, 152000, 340000, 160000, 206250, 146750, 16500…
$ `2012-12-29` <dbl> 175000, 359500, 420000, 164000, 161360, 159250, 325000, 169900, 194000, 159000, 16200…
$ `2013-01-05` <dbl> 170000, 340000, 395000, 170000, 160900, 153000, 325000, 177500, 210000, 140000, 15500…
$ `2013-01-12` <dbl> 167500, 375000, 395500, 158500, 149900, 140000, 319450, 162000, 200000, 135000, 16500…
$ `2013-01-19` <dbl> 167000, 345000, 390000, 168500, 147000, 143000, 322000, 157000, 202750, 135750, 16500…
$ `2013-01-26` <dbl> 160000, 345500, 389000, 162000, 143000, 139900, 325000, 152500, 186000, 129000, 16000…
$ `2013-02-02` <dbl> 167500, 332500, 380500, 156950, 145800, 142500, 300000, 165000, 205000, 145000, 15750…
$ `2013-02-09` <dbl> 159500, 345000, 395000, 145000, 147550, 145000, 304000, 155500, 200000, 130000, 16200…
$ `2013-02-16` <dbl> 165000, 350000, 400000, 155000, 148000, 145000, 306500, 154500, 174000, 150000, 16500…
$ `2013-02-23` <dbl> 165000, 340000, 400000, 146750, 150000, 147440, 325000, 158000, 186250, 145000, 17000…
$ `2013-03-02` <dbl> 174900, 336000, 405000, 165000, 163000, 154900, 330000, 170000, 198500, 165000, 17000…
$ `2013-03-09` <dbl> 169500, 332500, 435000, 161000, 163500, 159000, 340500, 170000, 190000, 155000, 16900…
$ `2013-03-16` <dbl> 172765, 325000, 425000, 164000, 164250, 159900, 340000, 157500, 187600, 170000, 17700…
$ `2013-03-23` <dbl> 173734, 346000, 435000, 165000, 165000, 165000, 333250, 161000, 206400, 163000, 17600…
$ `2013-03-30` <dbl> 180000, 345000, 435000, 171404, 163150, 164950, 340000, 170100, 197000, 176000, 18100…
$ `2013-04-06` <dbl> 175000, 325250, 452000, 180000, 168000, 164700, 354950, 185000, 205000, 150000, 17200…
$ `2013-04-13` <dbl> 175000, 332000, 451000, 184000, 169900, 160000, 336000, 173500, 214900, 170000, 17300…
$ `2013-04-20` <dbl> 178000, 345000, 462000, 187250, 174000, 169900, 354000, 172500, 190000, 172000, 17700…
$ `2013-04-27` <dbl> 180000, 339000, 469000, 185000, 172000, 169900, 355000, 175000, 197125, 168250, 18652…
$ `2013-05-04` <dbl> 185000, 352500, 450000, 190000, 182000, 174950, 372500, 185000, 223350, 188000, 18400…
$ `2013-05-11` <dbl> 182110, 355000, 460000, 185500, 165301, 162500, 365000, 185000, 209000, 170000, 17625…
$ `2013-05-18` <dbl> 188000, 365000, 465000, 192500, 178000, 176500, 380000, 190000, 214200, 174500, 18580…
$ `2013-05-25` <dbl> 185000, 349000, 465000, 195000, 175000, 169200, 366550, 190000, 209839, 189900, 18425…
$ `2013-06-01` <dbl> 194000, 368000, 460000, 215000, 181000, 179900, 390000, 186000, 220000, 200000, 19000…
$ `2013-06-08` <dbl> 189900, 351000, 480000, 205000, 188000, 177000, 375000, 194000, 230000, 180000, 18500…
$ `2013-06-15` <dbl> 195000, 370500, 465000, 220000, 182000, 187000, 380000, 190000, 224900, 190000, 18500…
$ `2013-06-22` <dbl> 195000, 370000, 485000, 217500, 179700, 177000, 383000, 217500, 237450, 185000, 19000…
$ `2013-06-29` <dbl> 200000, 390000, 472752, 221800, 180000, 184500, 395000, 195000, 230500, 195000, 19415…
$ `2013-07-06` <dbl> 198000, 375000, 472500, 220000, 190000, 189000, 375000, 195000, 238500, 175000, 18500…
$ `2013-07-13` <dbl> 197000, 380000, 471000, 215000, 184000, 175000, 373500, 200000, 236050, 195000, 19500…
$ `2013-07-20` <dbl> 198500, 385000, 480000, 225000, 187500, 185000, 379950, 197000, 235000, 197000, 19500…
$ `2013-07-27` <dbl> 195000, 380000, 466500, 218250, 180000, 175000, 390000, 200000, 234000, 187500, 19000…
$ `2013-08-03` <dbl> 197000, 380500, 460000, 215000, 183500, 176500, 395393, 215000, 235000, 195000, 18225…
$ `2013-08-10` <dbl> 190280, 392500, 465000, 220000, 176000, 170500, 374000, 200000, 240000, 178770, 18500…
$ `2013-08-17` <dbl> 195000, 385000, 475000, 217500, 174700, 172900, 370000, 202750, 230750, 175000, 18700…
$ `2013-08-24` <dbl> 192000, 393750, 482000, 215000, 180000, 182000, 355000, 205000, 231000, 170000, 18500…
$ `2013-08-31` <dbl> 194000, 390000, 457500, 205000, 175778, 174900, 375000, 200000, 230000, 180000, 18490…
$ `2013-09-07` <dbl> 187000, 385000, 480000, 214000, 179950, 175750, 360000, 195000, 220000, 174750, 18500…
$ `2013-09-14` <dbl> 185000, 380000, 473000, 195250, 165000, 170000, 350000, 195000, 216950, 159500, 18800…
$ `2013-09-21` <dbl> 185000, 378500, 468000, 195000, 176500, 174000, 346000, 200000, 215030, 167450, 19000…
$ `2013-09-28` <dbl> 185000, 360000, 450000, 194000, 175750, 170000, 345000, 185000, 214900, 174900, 18500…
$ `2013-10-05` <dbl> 185000, 360000, 470000, 200000, 177500, 170000, 349900, 199900, 205000, 165000, 18500…
$ `2013-10-12` <dbl> 184200, 353000, 451500, 191500, 169000, 167000, 359800, 180000, 207275, 160000, 19000…
$ `2013-10-19` <dbl> 187000, 360000, 465000, 195000, 172500, 166000, 350000, 189000, 212250, 160282, 19200…
$ `2013-10-26` <dbl> 183985, 370000, 470000, 190000, 170500, 168000, 344000, 181111, 210000, 163000, 18500…
$ `2013-11-02` <dbl> 183900, 365000, 450000, 190000, 164000, 166000, 350500, 195000, 210000, 170000, 18950…
$ `2013-11-09` <dbl> 179000, 350000, 465000, 184750, 170000, 164500, 335500, 185250, 206500, 157900, 19000…
$ `2013-11-16` <dbl> 180000, 355832, 465000, 189000, 168000, 166500, 340000, 202250, 195000, 169600, 19000…
$ `2013-11-23` <dbl> 182000, 360000, 465000, 182000, 170000, 165000, 341500, 200000, 202563, 160750, 18900…
$ `2013-11-30` <dbl> 180000, 333000, 440000, 180600, 164450, 172000, 350000, 190000, 210500, 150000, 18492…
$ `2013-12-07` <dbl> 185000, 354000, 475000, 190000, 172500, 166500, 350000, 190000, 200000, 179950, 19500…
$ `2013-12-14` <dbl> 185000, 350000, 489500, 189700, 172250, 175000, 345000, 193000, 223820, 159950, 19300…
$ `2013-12-21` <dbl> 186750, 353000, 465000, 194000, 171000, 169080, 345000, 200000, 200000, 174400, 19700…
$ `2013-12-28` <dbl> 180000, 362250, 450000, 169000, 165000, 166500, 359500, 200000, 189900, 160000, 19250…
$ `2014-01-04` <dbl> 178500, 361475, 452500, 176000, 167500, 164500, 345000, 198000, 190000, 160000, 18000…
$ `2014-01-11` <dbl> 184000, 355500, 455000, 185000, 163233, 152500, 335000, 185000, 195000, 150750, 19000…
$ `2014-01-18` <dbl> 180000, 352500, 450000, 180000, 159000, 167000, 340000, 190000, 207669, 165000, 20000…
$ `2014-01-25` <dbl> 173000, 356250, 442750, 170000, 154450, 164500, 339900, 188250, 205000, 150000, 18000…
$ `2014-02-01` <dbl> 180000, 362500, 450000, 185000, 159000, 165450, 326250, 191000, 204450, 164000, 18500…
$ `2014-02-08` <dbl> 174000, 365000, 455000, 166500, 163000, 165000, 325000, 190000, 189000, 140500, 18186…
$ `2014-02-15` <dbl> 176000, 370000, 460000, 175000, 167150, 165000, 340000, 178125, 185000, 166400, 19000…
$ `2014-02-22` <dbl> 177500, 350000, 480000, 170000, 165000, 175000, 350000, 190000, 191450, 155000, 19300…
$ `2014-03-01` <dbl> 180000, 329000, 473500, 175000, 173483, 175000, 330000, 185000, 191500, 170000, 18550…
$ `2014-03-08` <dbl> 180000, 345000, 470000, 170000, 179894, 177200, 343500, 195500, 192000, 170000, 19500…
$ `2014-03-15` <dbl> 182430, 360000, 501000, 185000, 176750, 170750, 329750, 189000, 199000, 170052, 19200…
$ `2014-03-22` <dbl> 181500, 348000, 485000, 180000, 173000, 173500, 362500, 200000, 199900, 165000, 19000…
$ `2014-03-29` <dbl> 185000, 350000, 475000, 187000, 180000, 155000, 350000, 202000, 206000, 175000, 19500…
$ `2014-04-05` <dbl> 185000, 346000, 489000, 200000, 181500, 175000, 365000, 200000, 215000, 181000, 19000…
$ `2014-04-12` <dbl> 185000, 355000, 489500, 193700, 171000, 179900, 350000, 192000, 193000, 178000, 19500…
$ `2014-04-19` <dbl> 189900, 355000, 477750, 207000, 177000, 173234, 355500, 210000, 200000, 188250, 19700…
$ `2014-04-26` <dbl> 187000, 345000, 489500, 205250, 184900, 184950, 354900, 200000, 200000, 181500, 19400…
$ `2014-05-03` <dbl> 192100, 348000, 475000, 202000, 185000, 180000, 381000, 205000, 212500, 185000, 20000…
$ `2014-05-10` <dbl> 190000, 368000, 519000, 200000, 182000, 180000, 384450, 217995, 205450, 174000, 19750…
$ `2014-05-17` <dbl> 192500, 355000, 495000, 202000, 185000, 175000, 389000, 221000, 200000, 195000, 19950…
$ `2014-05-24` <dbl> 194000, 365000, 500000, 214000, 185000, 177500, 393000, 225000, 225000, 192000, 19800…
$ `2014-05-31` <dbl> 198000, 350000, 500000, 219500, 189000, 185000, 395000, 210000, 213500, 200500, 19500…
$ `2014-06-07` <dbl> 195000, 367500, 500000, 220000, 190000, 189900, 385000, 220000, 225000, 212800, 19770…
$ `2014-06-14` <dbl> 199900, 365000, 495000, 226000, 195000, 185300, 379000, 220000, 215000, 193500, 19500…
$ `2014-06-21` <dbl> 200000, 380000, 499000, 231750, 191275, 197000, 390000, 237500, 230000, 184950, 20000…
$ `2014-06-28` <dbl> 204900, 378000, 499500, 230000, 194000, 178000, 389900, 227025, 240000, 199900, 20000…
$ `2014-07-05` <dbl> 203000, 378000, 504000, 225000, 194000, 194950, 390000, 235000, 230000, 190000, 20000…
$ `2014-07-12` <dbl> 200000, 385000, 529500, 220000, 190000, 184900, 386500, 225000, 233000, 200000, 20000…
$ `2014-07-19` <dbl> 203000, 395000, 505000, 224000, 193800, 190000, 400000, 230000, 235000, 199900, 20000…
$ `2014-07-26` <dbl> 197185, 375000, 492750, 222000, 194000, 190000, 379450, 220000, 230000, 187500, 19500…
$ `2014-08-02` <dbl> 200000, 380000, 492000, 222500, 195000, 190000, 394500, 230000, 230000, 196000, 19829…
$ `2014-08-09` <dbl> 199000, 395000, 530000, 224000, 196900, 192000, 369000, 230750, 234950, 184500, 20000…
$ `2014-08-16` <dbl> 198500, 396000, 525000, 226000, 187250, 194500, 375000, 212000, 224500, 185000, 19500…
$ `2014-08-23` <dbl> 197000, 390000, 505000, 217000, 192000, 200000, 375000, 218000, 240000, 177000, 19900…
$ `2014-08-30` <dbl> 200000, 382000, 495000, 219500, 188000, 187250, 369937, 215750, 220000, 180000, 20230…
$ `2014-09-06` <dbl> 192558, 380250, 510500, 215000, 183500, 187750, 368000, 210500, 225000, 179500, 18950…
$ `2014-09-13` <dbl> 194000, 378750, 501000, 210760, 178000, 182500, 350000, 214000, 210000, 166500, 20250…
$ `2014-09-20` <dbl> 190601, 369000, 506500, 208750, 185000, 188000, 349600, 216500, 210500, 176750, 19500…
$ `2014-09-27` <dbl> 189000, 363500, 486000, 201000, 180000, 185000, 345000, 212500, 216000, 174150, 19000…
$ `2014-10-04` <dbl> 190000, 365000, 472000, 201250, 183000, 184450, 360000, 216500, 220000, 175000, 19700…
$ `2014-10-11` <dbl> 189900, 380000, 495000, 205000, 180000, 179900, 345000, 213750, 216500, 165900, 19070…
$ `2014-10-18` <dbl> 190000, 362500, 500000, 190750, 185000, 175000, 365000, 225000, 208500, 177225, 20000…
$ `2014-10-25` <dbl> 187500, 350000, 517000, 190000, 179000, 176500, 365000, 215700, 207500, 170000, 18900…
$ `2014-11-01` <dbl> 190000, 352750, 491000, 190000, 176500, 182000, 349000, 210000, 210000, 175000, 19575…
$ `2014-11-08` <dbl> 187000, 360000, 497000, 199900, 180000, 182500, 350000, 216200, 213700, 171000, 18750…
$ `2014-11-15` <dbl> 191500, 369900, 518500, 190000, 188000, 171000, 357000, 222000, 214950, 168000, 19700…
$ `2014-11-22` <dbl> 193000, 360000, 485000, 197500, 182500, 180500, 347000, 219000, 207000, 178950, 19925…
$ `2014-11-29` <dbl> 186000, 355000, 475000, 178750, 181525, 185000, 355000, 216750, 205000, 169000, 18500…
$ `2014-12-06` <dbl> 191000, 361750, 520000, 185000, 181000, 186250, 373000, 220000, 210000, 188500, 20500…
$ `2014-12-13` <dbl> 191000, 355000, 499000, 203750, 187450, 183750, 370000, 220000, 215000, 174000, 20500…
$ `2014-12-20` <dbl> 195900, 365000, 482500, 202000, 190000, 189000, 372450, 215000, 210000, 174750, 20600…
$ `2014-12-27` <dbl> 189272, 358000, 475000, 186000, 186000, 190000, 345000, 235000, 200000, 157700, 18900…
$ `2015-01-03` <dbl> 186000, 375000, 482500, 175000, 188000, 194000, 366163, 220000, 210000, 182250, 19500…
$ `2015-01-10` <dbl> 190000, 375000, 493000, 182500, 175000, 182000, 339000, 220000, 203000, 170000, 19500…
$ `2015-01-17` <dbl> 188000, 360000, 499000, 187000, 170925, 180000, 342990, 203650, 208500, 175000, 20345…
$ `2015-01-24` <dbl> 184900, 360000, 482000, 195000, 182350, 171250, 350000, 225000, 199900, 156900, 20000…
$ `2015-01-31` <dbl> 183900, 369500, 470000, 181001, 185000, 182000, 330000, 203750, 199850, 165400, 19800…
$ `2015-02-07` <dbl> 180000, 360000, 499000, 178000, 178150, 177000, 335000, 215000, 181000, 165000, 19048…
$ `2015-02-14` <dbl> 185900, 368500, 495000, 178750, 185900, 170000, 340000, 215500, 186750, 169900, 19500…
$ `2015-02-21` <dbl> 189000, 365000, 506500, 187250, 180950, 187500, 375000, 212000, 198000, 173000, 20500…
$ `2015-02-28` <dbl> 195000, 360000, 500000, 185000, 185500, 187000, 350000, 220000, 200000, 185000, 20600…
$ `2015-03-07` <dbl> 193000, 365000, 512500, 194900, 202000, 185500, 389925, 230000, 195000, 177000, 19850…
$ `2015-03-14` <dbl> 194000, 362500, 500000, 190000, 193000, 195000, 350500, 220000, 196000, 167750, 20500…
$ `2015-03-21` <dbl> 195000, 345000, 518000, 200000, 190000, 187750, 359900, 215000, 200000, 190000, 20250…
$ `2015-03-28` <dbl> 195000, 355000, 500000, 208000, 190000, 190000, 359950, 220000, 195000, 185000, 20350…
$ `2015-04-04` <dbl> 200000, 359500, 510000, 212000, 196000, 200000, 375000, 225000, 215000, 192000, 21450…
$ `2015-04-11` <dbl> 197000, 367250, 530000, 199000, 199000, 188375, 360000, 225000, 192000, 186000, 20400…
$ `2015-04-18` <dbl> 200000, 365000, 525000, 220000, 199950, 196500, 385000, 220000, 208750, 190000, 20490…
$ `2015-04-25` <dbl> 199000, 349000, 530000, 210000, 205000, 189000, 367500, 220000, 209500, 195000, 20150…
$ `2015-05-02` <dbl> 204000, 345000, 515000, 218000, 206600, 198500, 385000, 219000, 209250, 198000, 20850…
$ `2015-05-09` <dbl> 203000, 362050, 524000, 220000, 205900, 199900, 388500, 231000, 209500, 206000, 21500…
$ `2015-05-16` <dbl> 206000, 374155, 508000, 219900, 207500, 199000, 395000, 235000, 210500, 192000, 21500…
$ `2015-05-23` <dbl> 209000, 375000, 526050, 227500, 209500, 210000, 385000, 239375, 222500, 200000, 21470…
$ `2015-05-30` <dbl> 212500, 380000, 530000, 225000, 217159, 208948, 384000, 234000, 225000, 220000, 21600…
$ `2015-06-06` <dbl> 210000, 385000, 535000, 222000, 215000, 208000, 398395, 250000, 229900, 208000, 21000…
$ `2015-06-13` <dbl> 212500, 389056, 525000, 229900, 213000, 207000, 374900, 245000, 220500, 203000, 21500…
$ `2015-06-20` <dbl> 215000, 378000, 532000, 229000, 215000, 210000, 390000, 240000, 225000, 205800, 21500…
$ `2015-06-27` <dbl> 215000, 380000, 530000, 230000, 210000, 210000, 380000, 240000, 232000, 198000, 21500…
$ `2015-07-04` <dbl> 215000, 390000, 529000, 233081, 220000, 200000, 394300, 245000, 241250, 207000, 22000…
$ `2015-07-11` <dbl> 211000, 390000, 544950, 220000, 210000, 203100, 377535, 243700, 232000, 201000, 21000…
$ `2015-07-18` <dbl> 215000, 390000, 528000, 234500, 220000, 212000, 385000, 235000, 235000, 201000, 22275…
$ `2015-07-25` <dbl> 209500, 399000, 535000, 220000, 209000, 205000, 368750, 240000, 231250, 199000, 20700…
$ `2015-08-01` <dbl> 212000, 390000, 520000, 226000, 205000, 202750, 370000, 237500, 227000, 203000, 21450…
$ `2015-08-08` <dbl> 208800, 400000, 530000, 219500, 209500, 200000, 370000, 239950, 225000, 195000, 21595…
$ `2015-08-15` <dbl> 210000, 390000, 525000, 230000, 205002, 200000, 351500, 235000, 227200, 191860, 21500…
$ `2015-08-22` <dbl> 209700, 405000, 535000, 220000, 207000, 204000, 368471, 238450, 226000, 190500, 21000…
$ `2015-08-29` <dbl> 206000, 385000, 523000, 216000, 207250, 199900, 372750, 230000, 222500, 185000, 20995…
$ `2015-09-05` <dbl> 205000, 385000, 515000, 210000, 206500, 192384, 369000, 238000, 230000, 185000, 21295…
$ `2015-09-12` <dbl> 202000, 385000, 530000, 215000, 205000, 193500, 384450, 235000, 219500, 183000, 21100…
$ `2015-09-19` <dbl> 204500, 400000, 515000, 210500, 195000, 190000, 350000, 230000, 222000, 186250, 21750…
$ `2015-09-26` <dbl> 200000, 380000, 515000, 215000, 195750, 190000, 357500, 222000, 218000, 185000, 21490…
$ `2015-10-03` <dbl> 200000, 370400, 510000, 206500, 200228, 193000, 360000, 229500, 221000, 189450, 21250…
$ `2015-10-10` <dbl> 198000, 375000, 513000, 202750, 192000, 179000, 350000, 230000, 213000, 180000, 20990…
$ `2015-10-17` <dbl> 200000, 366250, 525000, 209000, 201500, 195000, 355000, 226000, 215000, 175873, 21950…
$ `2015-10-24` <dbl> 199000, 375000, 512000, 194000, 199450, 190000, 355000, 226000, 203000, 180000, 21000…
$ `2015-10-31` <dbl> 200000, 355000, 512000, 210000, 195000, 192000, 350000, 220000, 213900, 175750, 21600…
$ `2015-11-07` <dbl> 195000, 360000, 500000, 205000, 195000, 187000, 349950, 225000, 215000, 184500, 21325…
$ `2015-11-14` <dbl> 195500, 369950, 521500, 195000, 196640, 180000, 347438, 227500, 210000, 175000, 21400…
$ `2015-11-21` <dbl> 200500, 368000, 540750, 198000, 200000, 182950, 359250, 218350, 203500, 189900, 21500…
$ `2015-11-28` <dbl> 200000, 384000, 520000, 203750, 200000, 190000, 355000, 225000, 211250, 176000, 20800…
$ `2015-12-05` <dbl> 205000, 375000, 530000, 198059, 200200, 188875, 358900, 227750, 200000, 198000, 21620…
$ `2015-12-12` <dbl> 205000, 375000, 530000, 200000, 199700, 189500, 344000, 230000, 207000, 189900, 22300…
$ `2015-12-19` <dbl> 205000, 370000, 535000, 196150, 210000, 195750, 365000, 237000, 212000, 194900, 22395…
$ `2015-12-26` <dbl> 200000, 369500, 526750, 204500, 199999, 195000, 356500, 232500, 207000, 170000, 20700…
$ `2016-01-02` <dbl> 200000, 365000, 505000, 189000, 200000, 190080, 340000, 230000, 190000, 189900, 22500…
$ `2016-01-09` <dbl> 196000, 365000, 535000, 190000, 188000, 184000, 326000, 234950, 190000, 175900, 22000…
$ `2016-01-16` <dbl> 200000, 360000, 515000, 197000, 201300, 182500, 340000, 222000, 196500, 184950, 21998…
$ `2016-01-23` <dbl> 199000, 370000, 531000, 193000, 197000, 189000, 350000, 222000, 203000, 169900, 21220…
$ `2016-01-30` <dbl> 195000, 374900, 503000, 184450, 194000, 189900, 350000, 221500, 197000, 180000, 21000…
$ `2016-02-06` <dbl> 192000, 375000, 507750, 185000, 197500, 186000, 352000, 215000, 205000, 173752, 22000…
$ `2016-02-13` <dbl> 192325, 366500, 515000, 182490, 196770, 178000, 341750, 230000, 205000, 172950, 21500…
$ `2016-02-20` <dbl> 195000, 365000, 541000, 190000, 209000, 187750, 361000, 225000, 194000, 185950, 21500…
$ `2016-02-27` <dbl> 196500, 365000, 520000, 185000, 206000, 190000, 350000, 225000, 182900, 185000, 21490…
$ `2016-03-05` <dbl> 199500, 365000, 528000, 198950, 211100, 190950, 350000, 230000, 203500, 180000, 22000…
$ `2016-03-12` <dbl> 200000, 385000, 545000, 197000, 205000, 199900, 338000, 230750, 195000, 184500, 21500…
$ `2016-03-19` <dbl> 200000, 359000, 535000, 210000, 214000, 190000, 353745, 230000, 195000, 197000, 21990…
$ `2016-03-26` <dbl> 204000, 365500, 545000, 199000, 216000, 195000, 345000, 230000, 201500, 195000, 22000…
$ `2016-04-02` <dbl> 205000, 355000, 530000, 210750, 220000, 195000, 374000, 233200, 215000, 199900, 22125…
$ `2016-04-09` <dbl> 205000, 362500, 560000, 214000, 210000, 190000, 374000, 239000, 209500, 188000, 22890…
$ `2016-04-16` <dbl> 209000, 370000, 545000, 230000, 218000, 195000, 369950, 235000, 200000, 201800, 23000…
$ `2016-04-23` <dbl> 210000, 362000, 550000, 223000, 224000, 210000, 385000, 235000, 211400, 199950, 22500…
$ `2016-04-30` <dbl> 212000, 360000, 559735, 221000, 215000, 207500, 375000, 231000, 219000, 205000, 22100…
$ `2016-05-07` <dbl> 210000, 369000, 550000, 221856, 232500, 205000, 390000, 245000, 220000, 205000, 22500…
$ `2016-05-14` <dbl> 212500, 370000, 564250, 225000, 230700, 208450, 383000, 237500, 216000, 200000, 23000…
$ `2016-05-21` <dbl> 215000, 380000, 560000, 229000, 230000, 212500, 390000, 245000, 227500, 200000, 22800…
$ `2016-05-28` <dbl> 217900, 375000, 574500, 225500, 224000, 210383, 390000, 243571, 233000, 215000, 23000…
$ `2016-06-04` <dbl> 220000, 375000, 575000, 234700, 235000, 217000, 393500, 248800, 235000, 213000, 23100…
$ `2016-06-11` <dbl> 219900, 390000, 570000, 234000, 234000, 205000, 384725, 250000, 228000, 201000, 23000…
$ `2016-06-18` <dbl> 223400, 385000, 555000, 230000, 238350, 218500, 380000, 251500, 230000, 210000, 23500…
$ `2016-06-25` <dbl> 223000, 395000, 565000, 235000, 240000, 214500, 386500, 250000, 247000, 203000, 22700…
$ `2016-07-02` <dbl> 225000, 400000, 545000, 232000, 234000, 220000, 385000, 255000, 240000, 200000, 23200…
$ `2016-07-09` <dbl> 220000, 410000, 565000, 232750, 235000, 215000, 385000, 259900, 240000, 209000, 22700…
$ `2016-07-16` <dbl> 222000, 402750, 562500, 229500, 225000, 220000, 385000, 245000, 235000, 208500, 23100…
$ `2016-07-23` <dbl> 219900, 405000, 555000, 225000, 227500, 220000, 384400, 250000, 240000, 200000, 22900…
$ `2016-07-30` <dbl> 220000, 390000, 555000, 226000, 225000, 206400, 378000, 244238, 230000, 208000, 22000…
$ `2016-08-06` <dbl> 218000, 405000, 570000, 226000, 229750, 210000, 390000, 248000, 240000, 197500, 24000…
$ `2016-08-13` <dbl> 218500, 400500, 565000, 230000, 225000, 208000, 365000, 238500, 220000, 190000, 23000…
$ `2016-08-20` <dbl> 219900, 405000, 555000, 226000, 237000, 209000, 380000, 241000, 229900, 194000, 23500…
$ `2016-08-27` <dbl> 218000, 400000, 555000, 218000, 228000, 210000, 374000, 240000, 230000, 190000, 22900…
$ `2016-09-03` <dbl> 217000, 400000, 545000, 212500, 225000, 205000, 360000, 247600, 236000, 193000, 22500…
$ `2016-09-10` <dbl> 215000, 395000, 555000, 210500, 225500, 203000, 369000, 249000, 220000, 184000, 23400…
$ `2016-09-17` <dbl> 215000, 390000, 555000, 214000, 225000, 205000, 350000, 247500, 214700, 185900, 23571…
$ `2016-09-24` <dbl> 214000, 385000, 550000, 206000, 222900, 205000, 365000, 252000, 220000, 185000, 22950…
$ `2016-10-01` <dbl> 215000, 375000, 560000, 200000, 216250, 209000, 359900, 240000, 225000, 185500, 23000…
$ `2016-10-08` <dbl> 212500, 380000, 563250, 210000, 225000, 200000, 370000, 250000, 220000, 181700, 23000…
$ `2016-10-15` <dbl> 214000, 390000, 550000, 210000, 219450, 200000, 360000, 247000, 220000, 194000, 23545…
$ `2016-10-22` <dbl> 213000, 397500, 560000, 205750, 219900, 205000, 355000, 238000, 219900, 186000, 23490…
$ `2016-10-29` <dbl> 215000, 380000, 541500, 205000, 227200, 198000, 360000, 241000, 222000, 186000, 23000…
$ `2016-11-05` <dbl> 211465, 382000, 545000, 203000, 225000, 198000, 358000, 240000, 215000, 190000, 22500…
$ `2016-11-12` <dbl> 212500, 360000, 560000, 210000, 230000, 205000, 355000, 245000, 219900, 189600, 22975…
$ `2016-11-19` <dbl> 216719, 377750, 559000, 210000, 225000, 205000, 345000, 238000, 215000, 190000, 23000…
$ `2016-11-26` <dbl> 213500, 395000, 550000, 204000, 227250, 201500, 349000, 245000, 220000, 185000, 22500…
$ `2016-12-03` <dbl> 215000, 375000, 560000, 206000, 225000, 208000, 372500, 245000, 215000, 195000, 23500…
$ `2016-12-10` <dbl> 214000, 375000, 565000, 209900, 222000, 199500, 355000, 245000, 225000, 192000, 23100…
$ `2016-12-17` <dbl> 217450, 380000, 560000, 205000, 226000, 208000, 377500, 242750, 220000, 193000, 23400…
$ `2016-12-24` <dbl> 212000, 388744, 540000, 202000, 233000, 205000, 365000, 245000, 220000, 180000, 22038…
$ `2016-12-31` <dbl> 210000, 365000, 535000, 200000, 225000, 210000, 348250, 244000, 207500, 185000, 23490…
$ `2017-01-07` <dbl> 210000, 380000, 560000, 205000, 230000, 198000, 370000, 232000, 195000, 181000, 24000…
$ `2017-01-14` <dbl> 214000, 375000, 563000, 207000, 223000, 193000, 354000, 241500, 205400, 186500, 22945…
$ `2017-01-21` <dbl> 210000, 370000, 550000, 210000, 218000, 196000, 350250, 235000, 213450, 188900, 23850…
$ `2017-01-28` <dbl> 208000, 382500, 530000, 195000, 214950, 198000, 351500, 240000, 212750, 185000, 21900…
$ `2017-02-04` <dbl> 207000, 383000, 545000, 200000, 231000, 195000, 347000, 248000, 202750, 188000, 22625…
$ `2017-02-11` <dbl> 205000, 387000, 549500, 200250, 220750, 192000, 343450, 233000, 195000, 175000, 23200…
$ `2017-02-18` <dbl> 210000, 385000, 535500, 190000, 230000, 200000, 360000, 245000, 205000, 186000, 23000…
$ `2017-02-25` <dbl> 210000, 375000, 562500, 203250, 229000, 205500, 344900, 240000, 205000, 190000, 23000…
$ `2017-03-04` <dbl> 215000, 365000, 563000, 214500, 240000, 217900, 355750, 250000, 212500, 200000, 23550…
$ `2017-03-11` <dbl> 212000, 375000, 580000, 215000, 232750, 210336, 349900, 245000, 199900, 182500, 23100…
$ `2017-03-18` <dbl> 215000, 380000, 580000, 217000, 243000, 215000, 350000, 240000, 206000, 197500, 23700…
$ `2017-03-25` <dbl> 215000, 370000, 570000, 227500, 235000, 213650, 369000, 245000, 200000, 204000, 23000…
$ `2017-04-01` <dbl> 219900, 375000, 572750, 220000, 240000, 209000, 366053, 245000, 222000, 207500, 23400…
$ `2017-04-08` <dbl> 219000, 395000, 575000, 221000, 238750, 210000, 359900, 250000, 225000, 202000, 23700…
$ `2017-04-15` <dbl> 223500, 385160, 590000, 230000, 242976, 220000, 398000, 250000, 215000, 212500, 23900…
$ `2017-04-22` <dbl> 220000, 385000, 575000, 225000, 245000, 210000, 397000, 254000, 222500, 209999, 23500…
$ `2017-04-29` <dbl> 225000, 378000, 590500, 236100, 246000, 215500, 390500, 255000, 225000, 210000, 23500…
$ `2017-05-06` <dbl> 223000, 400000, 585000, 230600, 250000, 215000, 398250, 258000, 235000, 202000, 23990…
$ `2017-05-13` <dbl> 224000, 394500, 605000, 230000, 260000, 221250, 390000, 247000, 220000, 205000, 24900…
$ `2017-05-20` <dbl> 227000, 390000, 595000, 235000, 250000, 220000, 391000, 260000, 235000, 214000, 24300…
$ `2017-05-27` <dbl> 228900, 385000, 595000, 235000, 254900, 222000, 405000, 250000, 240000, 219000, 24500…
$ `2017-06-03` <dbl> 230500, 400000, 590000, 240113, 253900, 222950, 409999, 260000, 235000, 220000, 24500…
$ `2017-06-10` <dbl> 232450, 398500, 600000, 240000, 255000, 225000, 400000, 270000, 242000, 214950, 25000…
$ `2017-06-17` <dbl> 235000, 410000, 600000, 244250, 250000, 228000, 386000, 266000, 240000, 220000, 24751…
$ `2017-06-24` <dbl> 232500, 415000, 600000, 240000, 250150, 224725, 397500, 277000, 235000, 212000, 23990…
$ `2017-07-01` <dbl> 240000, 415000, 605000, 240000, 250000, 226000, 397500, 270000, 250000, 220000, 24750…
$ `2017-07-08` <dbl> 230000, 435000, 625000, 230000, 245000, 230000, 399900, 260000, 250000, 215000, 24400…
$ `2017-07-15` <dbl> 235000, 435000, 597750, 241000, 250000, 215000, 400000, 268000, 241700, 215000, 24900…
$ `2017-07-22` <dbl> 232000, 426000, 610000, 240000, 245000, 222000, 404000, 262000, 244900, 223000, 24500…
$ `2017-07-29` <dbl> 233500, 425000, 585000, 235000, 250000, 218000, 400000, 262000, 236800, 219900, 24000…
$ `2017-08-05` <dbl> 230000, 420000, 600000, 240000, 250000, 215000, 400000, 269000, 248500, 210000, 24500…
$ `2017-08-12` <dbl> 230000, 410000, 590000, 235000, 252950, 217500, 379950, 259450, 230000, 205000, 24300…
$ `2017-08-19` <dbl> 232500, 415000, 601000, 229000, 255000, 219000, 386000, 265000, 239900, 210000, 24200…
$ `2017-08-26` <dbl> 230000, 425000, 605000, 221000, 247000, 220000, 375000, 269992, 235000, 212000, 24600…
$ `2017-09-02` <dbl> 230000, 410000, 597000, 219900, 245000, 210000, 380000, 265000, 235000, 206950, 24750…
$ `2017-09-09` <dbl> 225000, 400000, 620000, 220000, 240032, 234500, 376000, 263000, 226000, 200500, 24000…
$ `2017-09-16` <dbl> 229000, 415000, 590000, 219000, 241000, 217500, 355450, 245000, 221000, 205500, 24100…
$ `2017-09-23` <dbl> 226750, 400000, 600000, 225000, 237000, 218000, 367250, 250000, 225000, 200000, 24250…
$ `2017-09-30` <dbl> 228500, 400000, 600000, 221000, 240000, 207000, 370000, 269300, 220000, 210000, 25000…
$ `2017-10-07` <dbl> 222000, 397500, 585000, 217500, 239700, 213950, 359900, 255000, 226000, 209500, 24500…
$ `2017-10-14` <dbl> 225000, 385000, 590000, 217300, 245000, 215000, 357100, 255000, 220000, 205517, 24600…
$ `2017-10-21` <dbl> 225000, 380000, 595000, 219000, 240000, 215000, 374950, 257000, 217000, 210000, 24400…
$ `2017-10-28` <dbl> 225000, 389900, 595000, 210000, 238500, 207163, 375000, 245000, 223000, 212000, 25000…
$ `2017-11-04` <dbl> 225000, 395000, 597000, 215000, 241250, 205000, 377500, 250000, 225000, 208500, 25000…
$ `2017-11-11` <dbl> 224500, 390000, 600000, 220000, 239950, 210000, 358000, 250000, 220000, 204200, 24750…
$ `2017-11-18` <dbl> 228000, 395000, 610000, 215000, 240000, 214000, 363638, 254450, 219000, 206490, 24525…
$ `2017-11-25` <dbl> 225000, 388250, 600000, 214000, 240000, 213000, 355000, 261950, 220000, 208000, 24600…
$ `2017-12-02` <dbl> 229000, 390000, 605500, 217000, 242500, 210000, 379900, 265000, 221000, 210000, 25000…
$ `2017-12-09` <dbl> 225000, 390000, 620000, 223000, 247000, 204000, 374900, 260000, 225000, 208500, 25500…
$ `2017-12-16` <dbl> 227900, 390000, 580000, 210000, 244000, 199000, 380000, 260000, 235000, 215000, 25000…
$ `2017-12-23` <dbl> 225000, 385000, 600000, 220000, 243114, 217625, 381500, 260000, 225000, 210000, 24500…
$ `2017-12-30` <dbl> 227500, 400000, 590000, 210000, 250000, 215000, 379900, 265000, 215000, 211750, 23900…
$ `2018-01-06` <dbl> 220000, 402350, 590000, 216500, 237000, 200180, 369000, 255000, 212000, 212000, 24990…
$ `2018-01-13` <dbl> 225000, 400000, 598500, 215000, 233250, 197900, 350000, 254000, 205000, 205000, 25000…
$ `2018-01-20` <dbl> 227500, 389450, 587500, 215750, 237000, 206000, 384500, 265000, 219500, 213000, 25100…
$ `2018-01-27` <dbl> 220000, 395425, 575000, 217250, 235000, 210000, 352500, 257500, 205000, 207040, 25000…
$ `2018-02-03` <dbl> 223000, 395000, 590000, 215000, 240000, 205000, 358000, 252000, 215000, 202000, 25500…
$ `2018-02-10` <dbl> 225000, 387200, 600000, 215000, 247250, 200000, 350000, 257000, 211000, 210000, 25650…
$ `2018-02-17` <dbl> 229000, 400000, 612500, 210000, 250000, 210000, 380000, 255000, 205000, 220000, 26234…
$ `2018-02-24` <dbl> 225000, 390000, 625500, 212500, 245000, 213000, 354500, 255000, 210000, 210000, 25700…
$ `2018-03-03` <dbl> 230000, 390000, 610000, 228500, 255000, 220000, 379995, 260000, 217000, 226805, 25700…
$ `2018-03-10` <dbl> 230000, 398000, 620000, 223750, 252500, 212000, 370000, 265050, 225000, 215899, 25750…
$ `2018-03-17` <dbl> 232000, 389000, 615000, 225000, 254000, 214000, 390000, 260000, 215000, 225000, 26000…
$ `2018-03-24` <dbl> 230000, 385000, 621250, 230000, 257000, 223000, 389900, 273750, 219250, 219750, 25500…
$ `2018-03-31` <dbl> 239000, 404000, 650000, 242000, 260000, 215000, 389900, 259000, 229000, 230000, 25600…
$ `2018-04-07` <dbl> 230000, 399450, 625000, 235000, 260000, 225000, 400000, 257000, 230000, 224000, 25500…
$ `2018-04-14` <dbl> 236000, 400000, 630000, 240000, 254000, 222250, 394000, 265000, 222750, 225000, 26000…
$ `2018-04-21` <dbl> 235645, 399900, 625000, 233000, 252750, 230000, 400000, 270000, 230000, 235000, 26000…
$ `2018-04-28` <dbl> 237000, 395000, 620000, 237000, 265000, 225000, 400250, 265000, 220000, 235925, 25395…
$ `2018-05-05` <dbl> 238000, 405000, 625000, 247500, 264500, 234000, 415000, 270000, 230000, 232250, 26600…
$ `2018-05-12` <dbl> 238000, 400000, 642750, 236000, 269000, 226000, 410000, 265000, 229250, 231000, 25971…
$ `2018-05-19` <dbl> 240000, 410000, 646750, 239900, 262000, 233000, 419900, 275000, 235000, 239900, 26600…
$ `2018-05-26` <dbl> 240000, 410000, 640000, 245000, 265000, 230000, 410000, 269000, 229900, 239000, 26225…
$ `2018-06-02` <dbl> 245000, 395000, 640000, 242500, 280000, 234000, 405000, 267550, 239950, 245000, 27225…
$ `2018-06-09` <dbl> 242000, 418250, 650455, 248000, 270000, 233000, 395000, 273250, 245000, 234500, 27000…
$ `2018-06-16` <dbl> 247500, 430000, 660000, 250000, 275000, 230000, 400000, 275250, 239900, 240000, 27050…
$ `2018-06-23` <dbl> 247500, 417500, 646750, 249000, 269000, 230000, 422500, 280000, 250000, 238000, 27400…
$ `2018-06-30` <dbl> 250000, 425000, 641500, 245000, 272250, 229900, 405598, 281500, 244450, 239000, 26800…
$ `2018-07-07` <dbl> 240000, 422000, 635000, 248000, 267500, 235000, 402500, 275000, 257900, 230000, 26900…
$ `2018-07-14` <dbl> 245500, 435000, 630000, 250000, 265000, 230000, 412000, 270000, 240000, 229900, 27438…
$ `2018-07-21` <dbl> 243000, 430000, 645000, 239900, 267000, 230000, 400000, 269000, 245000, 239000, 27000…
$ `2018-07-28` <dbl> 243000, 425000, 640000, 240000, 264950, 230000, 405000, 270000, 238250, 234950, 26700…
$ `2018-08-04` <dbl> 241000, 424950, 640000, 235000, 265000, 229000, 399900, 275000, 250000, 235500, 26500…
$ `2018-08-11` <dbl> 240000, 430000, 651000, 233000, 263000, 228250, 400000, 269450, 248250, 218000, 26500…
$ `2018-08-18` <dbl> 241000, 431000, 644000, 235000, 260000, 230000, 397500, 275000, 242000, 223000, 26000…
$ `2018-08-25` <dbl> 240000, 425000, 640000, 231000, 252000, 225000, 402219, 267000, 250000, 230000, 26500…
$ `2018-09-01` <dbl> 239900, 422500, 630000, 226000, 259000, 220000, 395000, 267500, 243250, 225000, 26600…
$ `2018-09-08` <dbl> 234900, 420000, 631500, 233000, 261000, 222000, 390000, 265000, 245000, 228950, 26600…
$ `2018-09-15` <dbl> 235000, 426000, 620000, 225000, 250000, 218000, 385000, 275000, 230000, 234000, 26995…
$ `2018-09-22` <dbl> 235000, 420000, 620000, 230600, 249500, 219200, 381625, 260000, 240000, 229000, 26800…
$ `2018-09-29` <dbl> 235000, 405000, 625000, 220000, 248700, 217200, 369000, 267000, 229450, 225000, 26500…
$ `2018-10-06` <dbl> 230000, 400000, 626000, 224000, 253000, 220900, 375000, 265000, 225900, 227000, 26685…
$ `2018-10-13` <dbl> 232500, 399000, 620000, 223000, 244464, 214000, 390000, 270000, 220000, 225000, 27115…
$ `2018-10-20` <dbl> 235000, 399000, 610000, 225000, 255000, 220500, 371000, 284750, 223900, 225000, 26000…
$ `2018-10-27` <dbl> 232000, 405000, 639500, 214749, 245000, 220000, 373000, 265000, 225000, 225000, 26500…
$ `2018-11-03` <dbl> 234900, 393000, 625000, 223000, 252500, 219000, 379950, 268000, 229700, 230000, 25990…
$ `2018-11-10` <dbl> 232000, 400000, 625000, 217500, 245000, 225000, 369999, 273000, 225000, 220000, 26300…
$ `2018-11-17` <dbl> 236000, 405000, 637500, 225000, 254950, 215000, 383900, 282000, 223000, 225000, 27500…
$ `2018-11-24` <dbl> 231000, 405000, 620000, 220000, 245000, 217750, 380000, 275000, 244000, 215000, 26600…
$ `2018-12-01` <dbl> 235000, 402250, 633500, 217000, 250000, 215450, 381100, 265000, 225000, 224900, 26500…
$ `2018-12-08` <dbl> 231000, 390000, 625000, 222500, 249900, 225000, 385495, 265000, 229450, 228000, 27000…
$ `2018-12-15` <dbl> 235000, 399000, 610000, 224000, 250050, 215000, 394000, 270000, 225000, 230000, 26900…
$ `2018-12-22` <dbl> 230000, 392350, 600000, 216500, 255000, 224900, 392250, 270000, 230000, 218900, 27000…
$ `2018-12-29` <dbl> 233550, 404500, 605000, 215000, 254450, 225000, 388000, 265000, 225000, 218250, 26150…
$ `2019-01-05` <dbl> 230000, 405000, 618950, 210000, 248900, 215000, 375000, 265000, 231000, 215000, 26500…
$ `2019-01-12` <dbl> 235000, 397500, 599000, 223000, 237000, 214000, 370000, 265000, 224450, 215000, 27200…
$ `2019-01-19` <dbl> 233000, 396866, 611000, 225000, 244950, 214990, 375000, 260000, 215000, 220000, 26400…
$ `2019-01-26` <dbl> 228000, 397000, 594000, 214000, 227000, 207000, 360000, 269250, 217750, 219000, 26150…
$ `2019-02-02` <dbl> 233500, 400000, 600000, 210000, 250000, 212000, 373950, 260000, 216000, 214450, 26200…
$ `2019-02-09` <dbl> 225000, 395000, 604000, 210000, 244900, 215000, 370000, 265000, 212000, 215000, 26000…
$ `2019-02-16` <dbl> 230000, 415000, 610000, 212000, 243400, 210000, 379900, 260000, 200000, 219900, 26900…
$ `2019-02-23` <dbl> 232000, 410000, 625000, 230000, 250000, 227000, 390000, 265000, 222000, 220000, 27300…
$ `2019-03-02` <dbl> 239000, 389000, 625000, 225000, 255000, 221950, 385000, 274300, 233000, 235000, 26845…
$ `2019-03-09` <dbl> 235000, 400000, 635000, 233500, 261000, 225000, 379000, 275000, 227500, 235000, 27000…
$ `2019-03-16` <dbl> 239500, 395000, 630000, 228000, 260000, 225000, 395000, 280000, 225000, 240000, 27000…
$ `2019-03-23` <dbl> 238500, 390000, 625000, 233000, 261000, 225000, 406850, 283000, 237500, 235000, 26200…
$ `2019-03-30` <dbl> 244900, 390263, 625000, 234000, 262000, 229000, 409500, 270000, 234000, 237700, 27275…
$ `2019-04-06` <dbl> 239000, 387000, 635000, 234000, 250000, 224450, 390000, 269000, 235000, 235000, 27300…
$ `2019-04-13` <dbl> 244900, 405000, 630000, 245000, 261250, 235000, 410000, 270000, 225000, 240000, 26900…
$ `2019-04-20` <dbl> 247000, 410000, 650000, 240000, 265000, 232500, 390000, 269450, 235000, 235000, 27500…
$ `2019-04-27` <dbl> 243000, 395000, 641000, 235000, 264500, 227500, 406000, 280000, 236950, 240250, 27300…
$ `2019-05-04` <dbl> 250000, 400000, 645000, 235000, 266900, 235000, 430000, 280000, 248000, 255000, 28100…
$ `2019-05-11` <dbl> 249900, 410000, 640000, 243000, 270000, 240000, 400000, 277500, 230500, 244900, 28025…
$ `2019-05-18` <dbl> 250000, 410000, 630000, 246500, 274056, 234945, 420000, 281000, 242500, 245000, 27934…
$ `2019-05-25` <dbl> 250000, 400000, 640000, 245250, 276500, 240000, 419000, 280000, 241000, 249900, 27990…
$ `2019-06-01` <dbl> 259000, 400000, 645000, 245000, 275000, 243500, 416000, 288000, 247500, 258000, 28500…
$ `2019-06-08` <dbl> 255000, 430000, 650000, 245000, 280000, 243000, 415000, 287500, 250000, 258440, 28500…
$ `2019-06-15` <dbl> 258000, 410000, 642000, 250000, 275000, 245000, 415000, 287500, 265000, 260000, 28000…
$ `2019-06-22` <dbl> 257925, 432000, 660000, 252500, 271500, 243900, 422000, 285000, 257000, 250000, 28100…
$ `2019-06-29` <dbl> 260500, 425000, 635000, 247000, 280000, 238000, 420000, 290000, 259900, 250000, 28129…
$ `2019-07-06` <dbl> 255980, 432500, 672000, 253000, 275000, 240000, 429000, 297000, 270000, 250000, 28500…
$ `2019-07-13` <dbl> 255000, 450000, 669000, 245000, 269000, 237250, 408000, 293000, 258900, 250000, 28000…
$ `2019-07-20` <dbl> 257500, 427950, 665000, 249000, 270000, 237000, 415000, 289000, 260000, 250000, 28500…
$ `2019-07-27` <dbl> 255000, 433800, 649000, 250000, 267400, 235000, 415450, 289000, 260000, 260000, 28050…
$ `2019-08-03` <dbl> 255000, 420000, 660000, 245000, 273250, 242500, 415000, 289000, 262000, 248000, 28200…
$ `2019-08-10` <dbl> 250000, 418000, 650000, 244000, 275750, 235000, 420000, 294000, 255000, 238000, 28000…
$ `2019-08-17` <dbl> 255000, 420000, 639000, 249000, 270000, 239450, 400000, 290000, 265000, 250000, 28100…
$ `2019-08-24` <dbl> 253000, 435000, 645000, 235250, 270000, 235000, 400000, 290000, 257995, 242250, 28000…
$ `2019-08-31` <dbl> 255000, 425000, 635000, 235000, 265250, 235300, 400000, 270000, 259900, 245000, 28700…
$ `2019-09-07` <dbl> 249000, 425000, 668000, 235000, 261450, 231000, 407000, 277500, 250000, 248000, 29000…
$ `2019-09-14` <dbl> 250000, 430000, 642500, 236000, 267500, 228000, 389900, 290000, 236000, 238000, 28900…
$ `2019-09-21` <dbl> 249900, 410000, 630000, 230000, 256033, 225625, 390000, 275000, 240000, 245000, 28000…
$ `2019-09-28` <dbl> 250000, 424250, 648000, 227000, 263250, 232995, 385000, 276500, 250000, 242000, 28200…
$ `2019-10-05` <dbl> 250000, 410000, 632000, 232250, 272000, 230000, 399900, 285000, 249900, 243000, 28800…
$ `2019-10-12` <dbl> 250000, 429500, 640500, 225000, 268000, 231000, 394500, 285000, 233000, 237900, 29000…
$ `2019-10-19` <dbl> 250000, 410000, 639000, 230000, 265000, 225000, 380000, 285000, 235500, 246500, 28490…
$ `2019-10-26` <dbl> 250000, 410000, 650000, 232000, 253438, 225000, 389000, 282950, 240000, 240000, 28500…
$ `2019-11-02` <dbl> 250000, 410000, 635000, 230000, 258000, 222000, 400000, 295000, 229950, 235000, 29000…
$ `2019-11-09` <dbl> 246300, 405000, 642000, 224700, 259950, 230000, 400000, 286500, 250000, 239900, 29000…
$ `2019-11-16` <dbl> 250000, 415000, 655000, 240000, 260000, 230000, 405000, 292000, 250000, 245000, 29150…
$ `2019-11-23` <dbl> 250000, 410000, 640000, 229000, 262000, 230000, 410000, 295000, 237250, 249900, 29000…
$ `2019-11-30` <dbl> 249900, 417750, 626000, 230000, 260000, 225000, 408000, 285000, 233000, 235000, 27675…
$ `2019-12-07` <dbl> 252000, 410000, 661000, 228000, 262000, 228000, 410000, 283000, 249900, 248000, 29500…
$ `2019-12-14` <dbl> 253000, 420000, 650000, 226700, 260000, 233000, 400000, 300000, 249900, 245000, 29000…
$ `2019-12-21` <dbl> 253000, 417500, 650000, 229450, 267000, 240000, 415000, 283000, 250000, 247400, 29000…
$ `2019-12-28` <dbl> 249900, 410000, 642000, 220000, 270000, 235000, 385000, 285000, 230000, 235000, 28500…
$ `2020-01-04` <dbl> 249000, 410000, 638500, 226250, 270000, 235000, 407000, 287250, 245000, 235000, 29500…
$ `2020-01-11` <dbl> 249500, 415000, 657500, 220900, 255000, 216000, 355000, 290000, 230000, 243907, 29500…
$ `2020-01-18` <dbl> 250000, 415000, 650000, 220000, 261800, 224000, 367000, 285000, 239000, 239250, 29000…
$ `2020-01-25` <dbl> 240000, 417500, 628000, 224450, 258764, 219950, 380000, 280000, 235000, 225000, 28990…
$ `2020-02-01` <dbl> 247900, 419500, 642000, 210000, 260000, 225000, 385000, 285000, 239000, 239900, 29700…
$ `2020-02-08` <dbl> 245000, 416000, 635000, 232500, 260000, 230000, 387750, 290000, 236500, 243100, 29900…
$ `2020-02-15` <dbl> 253000, 427500, 662000, 220000, 260000, 228000, 402500, 280000, 230000, 240000, 30100…
$ `2020-02-22` <dbl> 250000, 420000, 661000, 220200, 270000, 230000, 410000, 290000, 223500, 245000, 29490…
$ `2020-02-29` <dbl> 255100, 420000, 650000, 229000, 264900, 233000, 405000, 285000, 247250, 252500, 30500…
$ `2020-03-07` <dbl> 254000, 415000, 667000, 239450, 275000, 235000, 420000, 293000, 240000, 249950, 30250…
$ `2020-03-14` <dbl> 257500, 420000, 680000, 240000, 271450, 230000, 415500, 300000, 233500, 254000, 30500…
$ `2020-03-21` <dbl> 260000, 420000, 699000, 250000, 274000, 235000, 431250, 299000, 245000, 261000, 31500…
$ `2020-03-28` <dbl> 265000, 411600, 651000, 240000, 273000, 240000, 422500, 303500, 245000, 260000, 30800…
$ `2020-04-04` <dbl> 262000, 420000, 640000, 260000, 276000, 245000, 446000, 297000, 274000, 270000, 31000…
$ `2020-04-11` <dbl> 263900, 420000, 665000, 254450, 281500, 242000, 445000, 310000, 270000, 260000, 31000…
$ `2020-04-18` <dbl> 260000, 433800, 675000, 263500, 280000, 235000, 447000, 301500, 260000, 270000, 30110…
$ `2020-04-25` <dbl> 259100, 415000, 650000, 253500, 285000, 235500, 415000, 314900, 250255, 257250, 29990…
$ `2020-05-02` <dbl> 259889, 435000, 646000, 255000, 278300, 240000, 425000, 310500, 272000, 263000, 29500…
$ `2020-05-09` <dbl> 253000, 430000, 652000, 245000, 265000, 235000, 423500, 295000, 259900, 250000, 29500…
$ `2020-05-16` <dbl> 255000, 420000, 626500, 249900, 268500, 229000, 419000, 307500, 255000, 250000, 29945…
$ `2020-05-23` <dbl> 255000, 425000, 634000, 243000, 280000, 235000, 436000, 300000, 255000, 248500, 29850…
$ `2020-05-30` <dbl> 261000, 429900, 670000, 245000, 275000, 239900, 432000, 317000, 266500, 260000, 30375…
$ `2020-06-06` <dbl> 260000, 441450, 655000, 253250, 280000, 245000, 430000, 305000, 257900, 254650, 30000…
$ `2020-06-13` <dbl> 260000, 420000, 670000, 248000, 276143, 236025, 425000, 314900, 264900, 258900, 30150…
$ `2020-06-20` <dbl> 268000, 445000, 677000, 250000, 285000, 254900, 420000, 305000, 265000, 263000, 31000…
$ `2020-06-27` <dbl> 269890, 443000, 675000, 254900, 290000, 251000, 435000, 314500, 265000, 267300, 31500…
$ `2020-07-04` <dbl> 277500, 448944, 706500, 251500, 290000, 258000, 447000, 318000, 270000, 270000, 32500…
$ `2020-07-11` <dbl> 274000, 437500, 710000, 253000, 295000, 260000, 450000, 319950, 269000, 270000, 31000…
$ `2020-07-18` <dbl> 279000, 439000, 710000, 260000, 290000, 265000, 465000, 320000, 279900, 272000, 32325…
$ `2020-07-25` <dbl> 277000, 446500, 709000, 255000, 295000, 259700, 450000, 323000, 279000, 272000, 32000…
$ `2020-08-01` <dbl> 282000, 444000, 709000, 264250, 305000, 260000, 450000, 320000, 275000, 279950, 31500…
$ `2020-08-08` <dbl> 277000, 435000, 718500, 265000, 308000, 265100, 450000, 330000, 284393, 285000, 32490…
$ `2020-08-15` <dbl> 280000, 450000, 722500, 272500, 290000, 255000, 440000, 325000, 275000, 279900, 32500…
$ `2020-08-22` <dbl> 280000, 455000, 710000, 265000, 295000, 255000, 457000, 321500, 285000, 269900, 32900…
$ `2020-08-29` <dbl> 282500, 450000, 730000, 265000, 285000, 258000, 440000, 321000, 287000, 275000, 32500…
$ `2020-09-05` <dbl> 280000, 465000, 725000, 257000, 296000, 258450, 455000, 337000, 275000, 279000, 32500…
$ `2020-09-12` <dbl> 282500, 460000, 730000, 260000, 298000, 250000, 435000, 323000, 280000, 275000, 33000…
$ `2020-09-19` <dbl> 285000, 462500, 740000, 265000, 295000, 257000, 440000, 320000, 280000, 275000, 32750…
$ `2020-09-26` <dbl> 282000, 440000, 730000, 260000, 293000, 250500, 429525, 317750, 280000, 274000, 33000…
$ `2020-10-03` <dbl> 285000, 459900, 716000, 260000, 293000, 258750, 450000, 320000, 270000, 280000, 33200…
$ `2020-10-10` <dbl> 280000, 465000, 739000, 259000, 300000, 253000, 430000, 325500, 265000, 275000, 33500…
$ `2020-10-17` <dbl> 285000, 460000, 725000, 265000, 294950, 252000, 435000, 325000, 276000, 282000, 33500…
$ `2020-10-24` <dbl> 285000, 469900, 740000, 270000, 295000, 265000, 441763, 320000, 266000, 279000, 33500…
$ `2020-10-31` <dbl> 290000, 462500, 726000, 265000, 301000, 255000, 450000, 325000, 279913, 275000, 33500…
$ `2020-11-07` <dbl> 285000, 463900, 715000, 255000, 295000, 260000, 450000, 338900, 265000, 276500, 33434…
$ `2020-11-14` <dbl> 285700, 464000, 730000, 258000, 307000, 262000, 440000, 320000, 272000, 280000, 33500…
$ `2020-11-21` <dbl> 289000, 485000, 729000, 262000, 303000, 260000, 433000, 325000, 277500, 275000, 33500…
$ `2020-11-28` <dbl> 285000, 464000, 728000, 250000, 295000, 260000, 440000, 320000, 275000, 265000, 32490…
$ `2020-12-05` <dbl> 289000, 465000, 726500, 257000, 297000, 261000, 432500, 324000, 275000, 290000, 34000…
$ `2020-12-12` <dbl> 284500, 470000, 720000, 255000, 293000, 259000, 441750, 325000, 270000, 280000, 33000…
$ `2020-12-19` <dbl> 285000, 480000, 715000, 258500, 300000, 268165, 440000, 335000, 282750, 275000, 34000…
$ `2020-12-26` <dbl> 283068, 465854, 730000, 250000, 295000, 257000, 425000, 333000, 265000, 265000, 33000…
$ `2021-01-02` <dbl> 280000, 455000, 720000, 250000, 290000, 269995, 435000, 324900, 265000, 280000, 32837…
$ `2021-01-09` <dbl> 280000, 470000, 725000, 250000, 290000, 254900, 430000, 325000, 267000, 275000, 34502…
$ `2021-01-16` <dbl> 283000, 470000, 729500, 255000, 290000, 250000, 415000, 335000, 265000, 275700, 35000…
$ `2021-01-23` <dbl> 277500, 465000, 700000, 250000, 290000, 252750, 410000, 325000, 269000, 276000, 34500…
$ `2021-01-30` <dbl> 279000, 464000, 719500, 249000, 290000, 255000, 403500, 330000, 269000, 272750, 34000…
$ `2021-02-06` <dbl> 276000, 485000, 730000, 250000, 290809, 262500, 400000, 335000, 268000, 275000, 35950…
$ `2021-02-13` <dbl> 280000, 461000, 730000, 250000, 300000, 257250, 405000, 330000, 257000, 275650, 35500…
$ `2021-02-20` <dbl> 292000, 470000, 755500, 245000, 318000, 274500, 421750, 337000, 255000, 285000, 35570…
$ `2021-02-27` <dbl> 290000, 477500, 762000, 248000, 320000, 273000, 420000, 340000, 260000, 285000, 35500…
$ `2021-03-06` <dbl> 294000, 470000, 775000, 247000, 326000, 280000, 450000, 338000, 262500, 293000, 36500…
$ `2021-03-13` <dbl> 290000, 465000, 780500, 253000, 310000, 280000, 426600, 330500, 260000, 295000, 36000…
$ `2021-03-20` <dbl> 298000, 460000, 760000, 273000, 317000, 290000, 449000, 339250, 267000, 300000, 36000…
$ `2021-03-27` <dbl> 300000, 479950, 775000, 265000, 325000, 285000, 440000, 340000, 265000, 300000, 37500…
$ `2021-04-03` <dbl> 310000, 480000, 776000, 270555, 323972, 280000, 460000, 340000, 270000, 311000, 37100…
$ `2021-04-10` <dbl> 301000, 485000, 800000, 275000, 330000, 287500, 470000, 350000, 265000, 305000, 37500…
$ `2021-04-17` <dbl> 310000, 473500, 799000, 275000, 335000, 287000, 470000, 345000, 275000, 320000, 38270…
$ `2021-04-24` <dbl> 309900, 495000, 810000, 275000, 330000, 285000, 468000, 350000, 279900, 310000, 37500…
$ `2021-05-01` <dbl> 314000, 495000, 785000, 285000, 325345, 294250, 475000, 350000, 275000, 314750, 37900…
$ `2021-05-08` <dbl> 310000, 500000, 831000, 285750, 352000, 299000, 500000, 350000, 285000, 310000, 39000…
$ `2021-05-15` <dbl> 315000, 505000, 800000, 299000, 350000, 294250, 489700, 350000, 278000, 327500, 39495…
$ `2021-05-22` <dbl> 317000, 490000, 825000, 287000, 350000, 305000, 503000, 360000, 278000, 320075, 39300…
$ `2021-05-29` <dbl> 320000, 499000, 817000, 285000, 350000, 303000, 485000, 350000, 291000, 330000, 39999…
$ `2021-06-05` <dbl> 320000, 510000, 820000, 292000, 355000, 310000, 490000, 358000, 305000, 335000, 40500…
$ `2021-06-12` <dbl> 320000, 500000, 822000, 295000, 355000, 309950, 485000, 360000, 290000, 327500, 39950…
$ `2021-06-19` <dbl> 325000, 517000, 822750, 295000, 354527, 305000, 485000, 364000, 280000, 335600, 40000…
$ `2021-06-26` <dbl> 324500, 525000, 818000, 285000, 345000, 305000, 500000, 350000, 300000, 320000, 40300…
$ `2021-07-03` <dbl> 330000, 525000, 825000, 292000, 366000, 311000, 494000, 360000, 309950, 345000, 41000…
$ `2021-07-10` <dbl> 325000, 525000, 835500, 280000, 355000, 305000, 499900, 360000, 300000, 332500, 41500…
$ `2021-07-17` <dbl> 327000, 526000, 825000, 287250, 355500, 301000, 483000, 360250, 310000, 339000, 40275…
$ `2021-07-24` <dbl> 325000, 530000, 820000, 295000, 358500, 300000, 492000, 365000, 300000, 333650, 40500…
$ `2021-07-31` <dbl> 325000, 535000, 816000, 290000, 350000, 300000, 475000, 360000, 300000, 335000, 41500…
$ `2021-08-07` <dbl> 325000, 535000, 822500, 290000, 355000, 305000, 490000, 368000, 316250, 325000, 42000…
$ `2021-08-14` <dbl> 325000, 525000, 829000, 295000, 365000, 297000, 473000, 355000, 308000, 324000, 41000…
$ `2021-08-21` <dbl> 325000, 530000, 829500, 287000, 350000, 302500, 485000, 362250, 315000, 330500, 42000…
$ `2021-08-28` <dbl> 321000, 540000, 818500, 285000, 350000, 296000, 475000, 360000, 310000, 325000, 41000…
$ `2021-09-04` <dbl> 325000, 530000, 824500, 280000, 347200, 300000, 460000, 360000, 295000, 327500, 42000…
$ `2021-09-11` <dbl> 325000, 535000, 834250, 280000, 355000, 292250, 480000, 369000, 310000, 325050, 43000…
$ `2021-09-18` <dbl> 325000, 525000, 828250, 280000, 350000, 291500, 482250, 350000, 295000, 334250, 41725…
$ `2021-09-25` <dbl> 319962, 537000, 810500, 279000, 345000, 292000, 450000, 350000, 310000, 330000, 41900…
$ `2021-10-02` <dbl> 324950, 520000, 825000, 275000, 350000, 295000, 450000, 360000, 288000, 330000, 42500…
$ `2021-10-09` <dbl> 320000, 525000, 839500, 276750, 346000, 294500, 465000, 370000, 300000, 332500, 43132…
$ `2021-10-16` <dbl> 325000, 520750, 815000, 270000, 356000, 295000, 455000, 369950, 284900, 349900, 42500…
$ `2021-10-23` <dbl> 325000, 515000, 825000, 276000, 356500, 300000, 475000, 365000, 285000, 343350, 42500…
$ `2021-10-30` <dbl> 325000, 515000, 815000, 275000, 352000, 299000, 464500, 355000, 294999, 334450, 42500…
$ `2021-11-06` <dbl> 320000, 500000, 805000, 275000, 355250, 307000, 465000, 360000, 285000, 341000, 42900…
$ `2021-11-13` <dbl> 325000, 515000, 843000, 275000, 352950, 305000, 465000, 355000, 290000, 340000, 42700…
$ `2021-11-20` <dbl> 329999, 515000, 830000, 277500, 355000, 304000, 459900, 375000, 290000, 347000, 43000…
$ `2021-11-27` <dbl> 325000, 525000, 835000, 275000, 345000, 305000, 460000, 370000, 290000, 338000, 42500…
$ `2021-12-04` <dbl> 330000, 500000, 850000, 275000, 360000, 305000, 483000, 375000, 299450, 340000, 43225…
$ `2021-12-11` <dbl> 325000, 515000, 855000, 275000, 355000, 308000, 460000, 375000, 294950, 335000, 43100…
$ `2021-12-18` <dbl> 328000, 510000, 840000, 271250, 361000, 310000, 469000, 369900, 285000, 346000, 43100…
$ `2021-12-25` <dbl> 324000, 500000, 825000, 270000, 359451, 309000, 470000, 375000, 279000, 331500, 42500…
$ `2022-01-01` <dbl> 320000, 520000, 835000, 265000, 366450, 304500, 435000, 387050, 269900, 350000, 43000…
$ `2022-01-08` <dbl> 322500, 515000, 850000, 266000, 352950, 295650, 460000, 385000, 290000, 333158, 43600…
$ `2022-01-15` <dbl> 325000, 520000, 835000, 270000, 351000, 303500, 430000, 380000, 290000, 345000, 44250…
$ `2022-01-22` <dbl> 318000, 525000, 820000, 265000, 363000, 293000, 425450, 375000, 294000, 326000, 44250…
$ `2022-01-29` <dbl> 315000, 520000, 820000, 265000, 355500, 299900, 420000, 380000, 285000, 335000, 43500…
$ `2022-02-05` <dbl> 325000, 500000, 845000, 281000, 362200, 300000, 432100, 390000, 289999, 340000, 45000…
$ `2022-02-12` <dbl> 320000, 520000, 835000, 270000, 355000, 310000, 435000, 380000, 277500, 335000, 45000…
$ `2022-02-19` <dbl> 335000, 515000, 870000, 270000, 375000, 309900, 460000, 385350, 280000, 350000, 45500…
$ `2022-02-26` <dbl> 335000, 520000, 880000, 265000, 375000, 328000, 469000, 382000, 280000, 349000, 46550…
$ `2022-03-05` <dbl> 340000, 519000, 890000, 275000, 390000, 325000, 475000, 390000, 282000, 354550, 45550…
$ `2022-03-12` <dbl> 340000, 525500, 905250, 270000, 389950, 318000, 480000, 399000, 275000, 360000, 46475…
$ `2022-03-19` <dbl> 345000, 515000, 890000, 283000, 385000, 310000, 500000, 400000, 280000, 350000, 47500…
$ `2022-03-26` <dbl> 349288, 530000, 900000, 280000, 385000, 320500, 485000, 394000, 279900, 355000, 46300…
$ `2022-04-02` <dbl> 353000, 530000, 920000, 295000, 392200, 323000, 512000, 410000, 295000, 364450, 46920…
$ `2022-04-09` <dbl> 358000, 570000, 950000, 295000, 419950, 330000, 522250, 410000, 285000, 369950, 47500…
$ `2022-04-16` <dbl> 362850, 525000, 950000, 300000, 405000, 332000, 510250, 400000, 300000, 370000, 48500…
$ `2022-04-23` <dbl> 359000, 530000, 945000, 300000, 410000, 332250, 530000, 415000, 305000, 373400, 48000…
$ `2022-04-30` <dbl> 361447, 535000, 929000, 299000, 421000, 335000, 530000, 396250, 310000, 379000, 47385…
$ `2022-05-07` <dbl> 362000, 540000, 916000, 310000, 420000, 348000, 542750, 415000, 325000, 388150, 49200…
$ `2022-05-14` <dbl> 365000, 550000, 925000, 310000, 425000, 345000, 540000, 420000, 320000, 385000, 48600…
$ `2022-05-21` <dbl> 365000, 536875, 925000, 303500, 427961, 350000, 525500, 435000, 325000, 380000, 49999…
$ `2022-05-28` <dbl> 365000, 559850, 950000, 305000, 425000, 345000, 534000, 430000, 325000, 399000, 49000…
$ `2022-06-04` <dbl> 370000, 560000, 940000, 305000, 441000, 348000, 550000, 426000, 331000, 390000, 49900…
$ `2022-06-11` <dbl> 365000, 565000, 916000, 315000, 420000, 349900, 520000, 425000, 330000, 395000, 49500…
$ `2022-06-18` <dbl> 368598, 578000, 925000, 312750, 425000, 349900, 525000, 435000, 340000, 400000, 48800…
$ `2022-06-25` <dbl> 364000, 570000, 894000, 322000, 425000, 345000, 535000, 430000, 342250, 382750, 49500…
$ `2022-07-02` <dbl> 365000, 580000, 900000, 315000, 410000, 345000, 533000, 430000, 340000, 393600, 48700…
$ `2022-07-09` <dbl> 360000, 585000, 904000, 310000, 415000, 344000, 520000, 430250, 340000, 396000, 46740…
$ `2022-07-16` <dbl> 357000, 590000, 911000, 310000, 420000, 350000, 520000, 430000, 337000, 375100, 47000…
$ `2022-07-23` <dbl> 351000, 595000, 880000, 310000, 405000, 334000, 507500, 420000, 335000, 390000, 47174…
$ `2022-07-30` <dbl> 350000, 575000, 874500, 310000, 400000, 333750, 501250, 416000, 345000, 385000, 46500…
$ `2022-08-06` <dbl> 347000, 590000, 890000, 315000, 399950, 325000, 510000, 424000, 340000, 385000, 46375…
$ `2022-08-13` <dbl> 347900, 580000, 890000, 299000, 405000, 333500, 510000, 435000, 325000, 375000, 45000…
$ `2022-08-20` <dbl> 350000, 575000, 895000, 300000, 399500, 339950, 500000, 415000, 330000, 375000, 46000…
$ `2022-08-27` <dbl> 347000, 575000, 850000, 288700, 395000, 325000, 490000, 410000, 333250, 365000, 45545…
$ `2022-09-03` <dbl> 349900, 581000, 860000, 295000, 399725, 323000, 488100, 410000, 335000, 365000, 45000…
$ `2022-09-10` <dbl> 345000, 580000, 875000, 285000, 400000, 335250, 475000, 405000, 329000, 369200, 45500…
$ `2022-09-17` <dbl> 343000, 574000, 863250, 282250, 390000, 325000, 477500, 420000, 320000, 365000, 45000…
$ `2022-09-24` <dbl> 340000, 560000, 871000, 290000, 380000, 325000, 465000, 405000, 320000, 366000, 44000…
$ `2022-10-01` <dbl> 340000, 535000, 860000, 280000, 383500, 318000, 493000, 410000, 320000, 360000, 44000…
$ `2022-10-08` <dbl> 340000, 560000, 860000, 295000, 394999, 312600, 481500, 425000, 315000, 355000, 45000…
$ `2022-10-15` <dbl> 340000, 545000, 850000, 280000, 393500, 315000, 482000, 406450, 310000, 355000, 45000…
$ `2022-10-22` <dbl> 335850, 535000, 877000, 279000, 380000, 318000, 475000, 435000, 320000, 358000, 45000…
$ `2022-10-29` <dbl> 330000, 530000, 830000, 278000, 380000, 300000, 475000, 420000, 315000, 358000, 44800…
$ `2022-11-05` <dbl> 330000, 547750, 878000, 285000, 385000, 320000, 484000, 420000, 310000, 350000, 44750…summary(house_sales) RegionID SizeRank RegionName RegionType StateName
Min. :102001 Min. : 0.00 Length:142 Length:142 Length:142
2008-02-02 2008-02-09 2008-02-16 2008-02-23 2008-03-01 2008-03-08
Min. : 82000 Min. : 85000 Min. : 78000 Min. : 64750 Min. : 78000 Min. : 89000
2008-03-15 2008-03-22 2008-03-29 2008-04-05 2008-04-12 2008-04-19
Min. : 82500 Min. : 79500 Min. : 84000 Min. : 89450 Min. : 77750 Min. : 77500
2008-04-26 2008-05-03 2008-05-10 2008-05-17 2008-05-24 2008-05-31
Min. : 65000 Min. : 89500 Min. : 85000 Min. : 98000 Min. : 85500 Min. : 75000
2008-06-07 2008-06-14 2008-06-21 2008-06-28 2008-07-05 2008-07-12
Min. :107000 Min. : 74900 Min. : 90000 Min. : 82750 Min. : 98250 Min. : 89999
2008-07-19 2008-07-26 2008-08-02 2008-08-09 2008-08-16 2008-08-23
Min. : 95000 Min. : 92000 Min. : 98750 Min. : 89850 Min. : 87500 Min. :100000
2008-08-30 2008-09-06 2008-09-13 2008-09-20 2008-09-27 2008-10-04
Min. :100750 Min. : 84550 Min. : 75000 Min. : 87000 Min. : 78000 Min. : 83000
2008-10-11 2008-10-18 2008-10-25 2008-11-01 2008-11-08 2008-11-15
Min. : 86000 Min. : 75000 Min. : 79000 Min. : 81750 Min. : 75000 Min. : 74000
2008-11-22 2008-11-29 2008-12-06 2008-12-13 2008-12-20 2008-12-27
Min. : 70500 Min. : 80000 Min. : 75450 Min. : 76070 Min. : 70750 Min. : 74750
2009-01-03 2009-01-10 2009-01-17 2009-01-24 2009-01-31 2009-02-07
Min. : 78500 Min. : 66500 Min. : 85900 Min. : 70000 Min. : 79000 Min. : 85000
2009-02-14 2009-02-21 2009-02-28 2009-03-07 2009-03-14 2009-03-21
Min. : 76950 Min. : 65000 Min. : 72400 Min. : 65450 Min. : 61000 Min. : 85750
2009-03-28 2009-04-04 2009-04-11 2009-04-18 2009-04-25 2009-05-02
Min. : 72750 Min. : 89500 Min. : 76000 Min. : 82950 Min. : 78625 Min. : 65000
2009-05-09 2009-05-16 2009-05-23 2009-05-30 2009-06-06 2009-06-13
Min. : 82000 Min. : 81450 Min. : 82500 Min. : 83000 Min. : 83950 Min. : 89750
2009-06-20 2009-06-27 2009-07-04 2009-07-11 2009-07-18 2009-07-25
Min. : 95250 Min. : 87150 Min. : 90000 Min. :110500 Min. : 93500 Min. : 89500
2009-08-01 2009-08-08 2009-08-15 2009-08-22 2009-08-29 2009-09-05
Min. : 85500 Min. : 88000 Min. : 83100 Min. : 75000 Min. : 84950 Min. : 85000
2009-09-12 2009-09-19 2009-09-26 2009-10-03 2009-10-10 2009-10-17
Min. : 70000 Min. : 81000 Min. : 85000 Min. : 97250 Min. : 89575 Min. : 73088
2009-10-24 2009-10-31 2009-11-07 2009-11-14 2009-11-21 2009-11-28
Min. : 75000 Min. : 86100 Min. : 75000 Min. : 85000 Min. : 87900 Min. : 85250
2009-12-05 2009-12-12 2009-12-19 2009-12-26 2010-01-02 2010-01-09
Min. : 88750 Min. : 88250 Min. : 95100 Min. : 73000 Min. : 77250 Min. : 55000
2010-01-16 2010-01-23 2010-01-30 2010-02-06 2010-02-13 2010-02-20
Min. : 74950 Min. : 78900 Min. : 88888 Min. : 82000 Min. : 78000 Min. : 84000
2010-02-27 2010-03-06 2010-03-13 2010-03-20 2010-03-27 2010-04-03
Min. : 62500 Min. : 86250 Min. : 70000 Min. : 80700 Min. : 75000 Min. : 83500
2010-04-10 2010-04-17 2010-04-24 2010-05-01 2010-05-08 2010-05-15
Min. : 69750 Min. : 86000 Min. : 64950 Min. : 79500 Min. : 92000 Min. : 80250
2010-05-22 2010-05-29 2010-06-05 2010-06-12 2010-06-19 2010-06-26
Min. : 88500 Min. : 86250 Min. : 78000 Min. :105000 Min. : 99000 Min. : 92345
2010-07-03 2010-07-10 2010-07-17 2010-07-24 2010-07-31 2010-08-07
Min. : 76500 Min. : 72000 Min. : 80000 Min. : 85450 Min. : 75650 Min. : 82500
2010-08-14 2010-08-21 2010-08-28 2010-09-04 2010-09-11 2010-09-18
Min. : 73705 Min. : 72500 Min. : 80000 Min. : 95000 Min. : 58750 Min. : 84000
2010-09-25 2010-10-02 2010-10-09 2010-10-16 2010-10-23 2010-10-30
Min. : 70000 Min. : 87500 Min. : 84900 Min. : 70000 Min. : 80000 Min. : 85107
2010-11-06 2010-11-13 2010-11-20 2010-11-27 2010-12-04 2010-12-11
Min. : 81000 Min. : 79400 Min. : 60000 Min. : 74500 Min. : 81800 Min. : 76400
2010-12-18 2010-12-25 2011-01-01 2011-01-08 2011-01-15 2011-01-22
Min. : 72000 Min. : 79500 Min. : 77000 Min. : 68950 Min. : 75714 Min. : 79050
2011-01-29 2011-02-05 2011-02-12 2011-02-19 2011-02-26 2011-03-05
Min. : 80500 Min. : 71900 Min. : 64000 Min. : 55000 Min. : 54000 Min. : 65250
2011-03-12 2011-03-19 2011-03-26 2011-04-02 2011-04-09 2011-04-16
Min. : 60000 Min. : 66000 Min. : 70000 Min. : 77500 Min. : 65000 Min. : 56000
2011-04-23 2011-04-30 2011-05-07 2011-05-14 2011-05-21 2011-05-28
Min. : 75000 Min. : 61801 Min. : 65000 Min. : 65000 Min. : 71000 Min. : 69000
2011-06-04 2011-06-11 2011-06-18 2011-06-25 2011-07-02 2011-07-09
Min. : 76500 Min. : 72000 Min. : 65000 Min. : 79900 Min. : 78000 Min. : 78950
2011-07-16 2011-07-23 2011-07-30 2011-08-06 2011-08-13 2011-08-20
Min. : 72000 Min. : 66000 Min. : 64750 Min. : 85850 Min. : 70000 Min. : 74700
2011-08-27 2011-09-03 2011-09-10 2011-09-17 2011-09-24 2011-10-01
Min. : 77500 Min. : 77000 Min. : 69000 Min. : 70000 Min. : 79149 Min. : 70000
2011-10-08 2011-10-15 2011-10-22 2011-10-29 2011-11-05 2011-11-12
Min. : 73250 Min. : 70000 Min. : 69000 Min. : 77000 Min. : 67500 Min. : 74625
2011-11-19 2011-11-26 2011-12-03 2011-12-10 2011-12-17 2011-12-24
Min. : 71500 Min. : 68900 Min. : 78500 Min. : 72000 Min. : 70000 Min. : 60500
2011-12-31 2012-01-07 2012-01-14 2012-01-21 2012-01-28 2012-02-04
Min. : 45000 Min. : 60000 Min. : 60109 Min. : 67500 Min. : 67473 Min. : 74500
2012-02-11 2012-02-18 2012-02-25 2012-03-03 2012-03-10 2012-03-17
Min. : 61750 Min. : 66000 Min. : 63500 Min. : 66000 Min. : 66850 Min. : 60625
2012-03-24 2012-03-31 2012-04-07 2012-04-14 2012-04-21 2012-04-28
Min. : 75000 Min. : 75000 Min. : 65000 Min. : 65766 Min. : 63000 Min. : 77250
2012-05-05 2012-05-12 2012-05-19 2012-05-26 2012-06-02 2012-06-09
Min. : 73000 Min. : 71100 Min. : 67250 Min. : 74500 Min. : 79000 Min. : 81000
2012-06-16 2012-06-23 2012-06-30 2012-07-07 2012-07-14 2012-07-21
Min. : 77500 Min. : 79850 Min. : 80000 Min. : 84500 Min. : 78000 Min. : 87000
2012-07-28 2012-08-04 2012-08-11 2012-08-18 2012-08-25 2012-09-01
Min. : 82500 Min. : 92750 Min. : 88000 Min. : 67800 Min. : 78000 Min. : 77250
2012-09-08 2012-09-15 2012-09-22 2012-09-29 2012-10-06 2012-10-13
Min. : 55000 Min. : 77750 Min. : 75000 Min. : 81500 Min. : 95475 Min. : 64000
2012-10-20 2012-10-27 2012-11-03 2012-11-10 2012-11-17 2012-11-24
Min. : 71450 Min. : 88000 Min. : 71600 Min. : 75975 Min. : 74200 Min. : 85000
2012-12-01 2012-12-08 2012-12-15 2012-12-22 2012-12-29 2013-01-05
Min. : 76450 Min. : 87000 Min. : 72500 Min. : 79000 Min. : 60450 Min. : 77000
2013-01-12 2013-01-19 2013-01-26 2013-02-02 2013-02-09 2013-02-16
Min. : 67500 Min. : 79500 Min. : 59500 Min. : 57000 Min. : 63000 Min. : 65000
2013-02-23 2013-03-02 2013-03-09 2013-03-16 2013-03-23 2013-03-30
Min. : 74000 Min. : 57251 Min. : 73500 Min. : 67000 Min. : 86875 Min. : 82001
2013-04-06 2013-04-13 2013-04-20 2013-04-27 2013-05-04 2013-05-11
Min. : 49500 Min. : 79500 Min. : 78900 Min. : 75000 Min. : 81200 Min. : 77250
2013-05-18 2013-05-25 2013-06-01 2013-06-08 2013-06-15 2013-06-22
Min. : 63000 Min. : 85450 Min. : 83000 Min. : 88800 Min. : 86200 Min. : 94250
2013-06-29 2013-07-06 2013-07-13 2013-07-20 2013-07-27 2013-08-03
Min. : 92250 Min. : 93527 Min. : 80500 Min. :100000 Min. : 86500 Min. : 78701
2013-08-10 2013-08-17 2013-08-24 2013-08-31 2013-09-07 2013-09-14
Min. : 83500 Min. : 79000 Min. : 99750 Min. : 75000 Min. : 82050 Min. : 79500
2013-09-21 2013-09-28 2013-10-05 2013-10-12 2013-10-19 2013-10-26
Min. : 76050 Min. : 86950 Min. : 92500 Min. : 72900 Min. : 73900 Min. : 76000
2013-11-02 2013-11-09 2013-11-16 2013-11-23 2013-11-30 2013-12-07
Min. : 84250 Min. : 78250 Min. : 70500 Min. : 78000 Min. : 75000 Min. : 69000
2013-12-14 2013-12-21 2013-12-28 2014-01-04 2014-01-11 2014-01-18
Min. : 76650 Min. : 79000 Min. : 76000 Min. : 71213 Min. : 71000 Min. : 63000
2014-01-25 2014-02-01 2014-02-08 2014-02-15 2014-02-22 2014-03-01
Min. : 62000 Min. : 72500 Min. : 56000 Min. : 60000 Min. : 78500 Min. : 53000
2014-03-08 2014-03-15 2014-03-22 2014-03-29 2014-04-05 2014-04-12
Min. : 73450 Min. : 60080 Min. : 63000 Min. : 76000 Min. : 75000 Min. : 71000
2014-04-19 2014-04-26 2014-05-03 2014-05-10 2014-05-17 2014-05-24
Min. : 76000 Min. : 78000 Min. : 83528 Min. : 80000 Min. : 85000 Min. : 93500
2014-05-31 2014-06-07 2014-06-14 2014-06-21 2014-06-28 2014-07-05
Min. : 89500 Min. : 95500 Min. : 80000 Min. : 86500 Min. : 89200 Min. : 89000
2014-07-12 2014-07-19 2014-07-26 2014-08-02 2014-08-09 2014-08-16
Min. : 95500 Min. : 90000 Min. : 86250 Min. : 92000 Min. : 93000 Min. :100000
2014-08-23 2014-08-30 2014-09-06 2014-09-13 2014-09-20 2014-09-27
Min. : 94500 Min. : 81000 Min. : 85000 Min. : 90000 Min. : 77000 Min. : 85500
2014-10-04 2014-10-11 2014-10-18 2014-10-25 2014-11-01 2014-11-08
Min. : 95000 Min. : 78500 Min. : 80000 Min. : 75000 Min. : 88000 Min. : 93000
2014-11-15 2014-11-22 2014-11-29 2014-12-06 2014-12-13 2014-12-20
Min. : 78150 Min. : 82000 Min. : 74000 Min. : 89000 Min. : 80000 Min. : 87250
2014-12-27 2015-01-03 2015-01-10 2015-01-17 2015-01-24 2015-01-31
Min. : 90000 Min. : 82000 Min. : 60413 Min. : 72000 Min. : 74950 Min. : 75950
2015-02-07 2015-02-14 2015-02-21 2015-02-28 2015-03-07 2015-03-14
Min. : 75900 Min. : 68900 Min. : 90000 Min. : 45000 Min. : 79000 Min. : 81500
2015-03-21 2015-03-28 2015-04-04 2015-04-11 2015-04-18 2015-04-25
Min. : 92500 Min. : 68000 Min. : 89000 Min. : 95750 Min. : 75000 Min. : 85000
2015-05-02 2015-05-09 2015-05-16 2015-05-23 2015-05-30 2015-06-06
Min. : 92500 Min. : 89500 Min. : 86313 Min. : 80000 Min. : 95000 Min. : 90000
2015-06-13 2015-06-20 2015-06-27 2015-07-04 2015-07-11 2015-07-18
Min. : 99500 Min. : 85000 Min. : 85500 Min. :103000 Min. : 91000 Min. : 99250
2015-07-25 2015-08-01 2015-08-08 2015-08-15 2015-08-22 2015-08-29
Min. : 93750 Min. : 89250 Min. : 98500 Min. :100000 Min. : 84500 Min. : 90000
2015-09-05 2015-09-12 2015-09-19 2015-09-26 2015-10-03 2015-10-10
Min. :100000 Min. : 88000 Min. : 95000 Min. : 89750 Min. : 90000 Min. : 90750
2015-10-17 2015-10-24 2015-10-31 2015-11-07 2015-11-14 2015-11-21
Min. : 77500 Min. : 77000 Min. : 85000 Min. : 96250 Min. : 76000 Min. : 90000
2015-11-28 2015-12-05 2015-12-12 2015-12-19 2015-12-26 2016-01-02
Min. : 75250 Min. : 85000 Min. : 79200 Min. : 86617 Min. : 80000 Min. : 80500
2016-01-09 2016-01-16 2016-01-23 2016-01-30 2016-02-06 2016-02-13
Min. : 81750 Min. : 72290 Min. : 72000 Min. : 80000 Min. : 85000 Min. : 70000
2016-02-20 2016-02-27 2016-03-05 2016-03-12 2016-03-19 2016-03-26
Min. : 76000 Min. : 66000 Min. : 85950 Min. : 88000 Min. : 76500 Min. : 83900
2016-04-02 2016-04-09 2016-04-16 2016-04-23 2016-04-30 2016-05-07
Min. : 89000 Min. : 84750 Min. : 83000 Min. :100000 Min. :104000 Min. : 93800
2016-05-14 2016-05-21 2016-05-28 2016-06-04 2016-06-11 2016-06-18
Min. : 89300 Min. : 87750 Min. : 81450 Min. : 81500 Min. : 97000 Min. :109500
2016-06-25 2016-07-02 2016-07-09 2016-07-16 2016-07-23 2016-07-30
Min. : 89500 Min. : 94000 Min. :103500 Min. : 90000 Min. :107950 Min. :104000
2016-08-06 2016-08-13 2016-08-20 2016-08-27 2016-09-03 2016-09-10
Min. : 98500 Min. :110000 Min. : 87500 Min. : 87950 Min. :102500 Min. : 89450
2016-09-17 2016-09-24 2016-10-01 2016-10-08 2016-10-15 2016-10-22
Min. : 90000 Min. : 88900 Min. : 98500 Min. :111000 Min. : 85989 Min. : 94500
2016-10-29 2016-11-05 2016-11-12 2016-11-19 2016-11-26 2016-12-03
Min. : 86900 Min. :110000 Min. : 85000 Min. : 80000 Min. : 93000 Min. :103250
2016-12-10 2016-12-17 2016-12-24 2016-12-31 2017-01-07 2017-01-14
Min. : 92000 Min. : 92000 Min. : 92000 Min. : 85000 Min. : 79250 Min. : 76000
2017-01-21 2017-01-28 2017-02-04 2017-02-11 2017-02-18 2017-02-25
Min. : 80750 Min. : 73700 Min. : 76000 Min. : 73500 Min. : 76000 Min. : 70550
2017-03-04 2017-03-11 2017-03-18 2017-03-25 2017-04-01 2017-04-08
Min. : 89000 Min. : 78500 Min. : 89900 Min. : 85000 Min. : 98000 Min. : 79750
2017-04-15 2017-04-22 2017-04-29 2017-05-06 2017-05-13 2017-05-20
Min. : 88000 Min. : 86000 Min. :100800 Min. : 83000 Min. :101000 Min. : 98750
2017-05-27 2017-06-03 2017-06-10 2017-06-17 2017-06-24 2017-07-01
Min. :110500 Min. : 95500 Min. : 89500 Min. : 105878 Min. :103000 Min. : 97500
2017-07-08 2017-07-15 2017-07-22 2017-07-29 2017-08-05 2017-08-12
Min. :116500 Min. :108750 Min. : 94000 Min. :100000 Min. : 94000 Min. : 96500
2017-08-19 2017-08-26 2017-09-02 2017-09-09 2017-09-16 2017-09-23
Min. : 90000 Min. : 92000 Min. :115000 Min. : 85000 Min. : 102900 Min. : 94000
2017-09-30 2017-10-07 2017-10-14 2017-10-21 2017-10-28 2017-11-04
Min. : 99000 Min. :103500 Min. : 82000 Min. : 90000 Min. : 92700 Min. :105000
2017-11-11 2017-11-18 2017-11-25 2017-12-02 2017-12-09
Min. : 96500 Min. : 87750 Min. : 110000 Min. : 100000 Min. : 78000
2017-12-16 2017-12-23 2017-12-30 2018-01-06 2018-01-13 2018-01-20
Min. : 102000 Min. : 90000 Min. : 98500 Min. : 90000 Min. : 100000 Min. : 97500
2018-01-27 2018-02-03 2018-02-10 2018-02-17 2018-02-24 2018-03-03
Min. : 85450 Min. : 95000 Min. : 87750 Min. : 101500 Min. : 108000 Min. : 97250
2018-03-10 2018-03-17 2018-03-24 2018-03-31 2018-04-07
Min. : 93000 Min. : 94000 Min. : 90000 Min. : 110000 Min. : 90000
2018-04-14 2018-04-21 2018-04-28 2018-05-05 2018-05-12
Min. : 93000 Min. : 79250 Min. : 85600 Min. : 95088 Min. : 105000
2018-05-19 2018-05-26 2018-06-02 2018-06-09 2018-06-16
Min. : 98500 Min. : 104950 Min. : 99000 Min. : 99250 Min. : 105200
2018-06-23 2018-06-30 2018-07-07 2018-07-14 2018-07-21
Min. : 118000 Min. : 104000 Min. : 94250 Min. : 117000 Min. : 86500
2018-07-28 2018-08-04 2018-08-11 2018-08-18 2018-08-25
Min. : 111900 Min. : 115000 Min. : 109000 Min. : 106250 Min. : 90750
2018-09-01 2018-09-08 2018-09-15 2018-09-22 2018-09-29
Min. : 105000 Min. : 99450 Min. : 108000 Min. : 109000 Min. : 110000
2018-10-06 2018-10-13 2018-10-20 2018-10-27 2018-11-03
Min. : 120000 Min. : 97500 Min. : 108450 Min. : 85500 Min. : 87950
2018-11-10 2018-11-17 2018-11-24 2018-12-01 2018-12-08
Min. : 91500 Min. : 113000 Min. : 91750 Min. : 99900 Min. : 109900
2018-12-15 2018-12-22 2018-12-29 2019-01-05 2019-01-12 2019-01-19
Min. : 115000 Min. : 94500 Min. : 87500 Min. : 84000 Min. : 83000 Min. : 92500
2019-01-26 2019-02-02 2019-02-09 2019-02-16 2019-02-23 2019-03-02
Min. : 81150 Min. : 95000 Min. : 85250 Min. : 94900 Min. : 85000 Min. : 97750
2019-03-09 2019-03-16 2019-03-23 2019-03-30 2019-04-06
Min. : 95500 Min. : 92500 Min. : 105000 Min. : 95623 Min. : 108000
2019-04-13 2019-04-20 2019-04-27 2019-05-04 2019-05-11
Min. : 93000 Min. : 99000 Min. : 91000 Min. : 102000 Min. : 98900
2019-05-18 2019-05-25 2019-06-01 2019-06-08 2019-06-15
Min. : 108200 Min. : 117500 Min. : 110000 Min. : 110251 Min. : 124900
2019-06-22 2019-06-29 2019-07-06 2019-07-13 2019-07-20
Min. : 101500 Min. : 110000 Min. : 117250 Min. : 110250 Min. : 110000
2019-07-27 2019-08-03 2019-08-10 2019-08-17 2019-08-24
Min. : 97000 Min. : 115000 Min. : 98450 Min. : 99750 Min. : 119450
2019-08-31 2019-09-07 2019-09-14 2019-09-21 2019-09-28 2019-10-05
Min. : 107450 Min. : 108500 Min. : 119750 Min. : 115000 Min. :116500 Min. : 119700
2019-10-12 2019-10-19 2019-10-26 2019-11-02 2019-11-09 2019-11-16
Min. : 114947 Min. : 113000 Min. : 112000 Min. :111250 Min. : 109000 Min. : 105000
2019-11-23 2019-11-30 2019-12-07 2019-12-14 2019-12-21 2019-12-28
Min. : 116000 Min. :106500 Min. : 114950 Min. : 117000 Min. : 100000 Min. : 84200
2020-01-04 2020-01-11 2020-01-18 2020-01-25 2020-02-01 2020-02-08
Min. :119250 Min. : 79750 Min. : 98000 Min. : 89900 Min. : 104500 Min. :105500
2020-02-15 2020-02-22 2020-02-29 2020-03-07 2020-03-14
Min. : 90500 Min. : 99900 Min. : 112000 Min. : 99250 Min. : 105000
2020-03-21 2020-03-28 2020-04-04 2020-04-11 2020-04-18
Min. : 89500 Min. : 100000 Min. : 130000 Min. : 120000 Min. : 110000
2020-04-25 2020-05-02 2020-05-09 2020-05-16 2020-05-23
Min. : 118000 Min. : 116500 Min. : 121000 Min. : 104000 Min. : 126240
2020-05-30 2020-06-06 2020-06-13 2020-06-20 2020-06-27
Min. : 118500 Min. : 118500 Min. : 92000 Min. : 106500 Min. : 106000
2020-07-04 2020-07-11 2020-07-18 2020-07-25 2020-08-01
Min. : 122650 Min. : 126250 Min. : 124950 Min. : 122500 Min. : 125500
2020-08-08 2020-08-15 2020-08-22 2020-08-29 2020-09-05
Min. : 125000 Min. : 126000 Min. : 121500 Min. : 119000 Min. : 85000
2020-09-12 2020-09-19 2020-09-26 2020-10-03 2020-10-10
Min. : 125000 Min. : 130500 Min. : 132000 Min. : 125000 Min. : 112500
2020-10-17 2020-10-24 2020-10-31 2020-11-07 2020-11-14
Min. : 126000 Min. : 122000 Min. : 125000 Min. : 120000 Min. : 131000
2020-11-21 2020-11-28 2020-12-05 2020-12-12 2020-12-19
Min. : 117000 Min. : 104250 Min. : 129000 Min. : 114950 Min. : 123850
2020-12-26 2021-01-02 2021-01-09 2021-01-16 2021-01-23
Min. : 113375 Min. : 100200 Min. : 110000 Min. : 113000 Min. : 108263
2021-01-30 2021-02-06 2021-02-13 2021-02-20 2021-02-27
Min. : 110000 Min. : 111450 Min. : 120000 Min. : 109250 Min. : 102500
2021-03-06 2021-03-13 2021-03-20 2021-03-27 2021-04-03
Min. : 117400 Min. : 110000 Min. : 120000 Min. : 114900 Min. : 127563
2021-04-10 2021-04-17 2021-04-24 2021-05-01 2021-05-08
Min. : 106000 Min. : 112000 Min. : 122500 Min. : 125700 Min. : 126750
2021-05-15 2021-05-22 2021-05-29 2021-06-05 2021-06-12
Min. : 115000 Min. : 133700 Min. : 125000 Min. : 123250 Min. : 126450
2021-06-19 2021-06-26 2021-07-03 2021-07-10 2021-07-17
Min. : 128000 Min. : 129900 Min. : 136750 Min. : 129400 Min. : 117500
2021-07-24 2021-07-31 2021-08-07 2021-08-14 2021-08-21
Min. : 141000 Min. : 119900 Min. : 147500 Min. : 133500 Min. : 123500
2021-08-28 2021-09-04 2021-09-11 2021-09-18 2021-09-25
Min. : 127000 Min. : 129900 Min. : 131010 Min. : 124250 Min. : 112000
2021-10-02 2021-10-09 2021-10-16 2021-10-23 2021-10-30
Min. : 130000 Min. : 138950 Min. : 127275 Min. : 131000 Min. : 135000
2021-11-06 2021-11-13 2021-11-20 2021-11-27 2021-12-04
Min. : 128000 Min. : 122000 Min. : 118950 Min. : 105000 Min. : 122500
2021-12-11 2021-12-18 2021-12-25 2022-01-01 2022-01-08
Min. : 125000 Min. : 115000 Min. : 114750 Min. : 125750 Min. : 91000
2022-01-15 2022-01-22 2022-01-29 2022-02-05 2022-02-12
Min. : 115500 Min. : 120900 Min. : 110000 Min. : 125950 Min. : 123000
2022-02-19 2022-02-26 2022-03-05 2022-03-12 2022-03-19
Min. : 114250 Min. : 109000 Min. : 132000 Min. : 122000 Min. : 129000
2022-03-26 2022-04-02 2022-04-09 2022-04-16 2022-04-23
Min. : 115000 Min. : 138250 Min. : 113500 Min. : 110000 Min. : 125000
2022-04-30 2022-05-07 2022-05-14 2022-05-21 2022-05-28
Min. : 124000 Min. : 130000 Min. : 140000 Min. : 135000 Min. : 130000
2022-06-04 2022-06-11 2022-06-18 2022-06-25 2022-07-02
Min. : 146500 Min. : 150000 Min. : 140000 Min. : 145000 Min. : 141250
2022-07-09 2022-07-16 2022-07-23 2022-07-30 2022-08-06
Min. : 153000 Min. : 139950 Min. : 135500 Min. : 141000 Min. : 134000
2022-08-13 2022-08-20 2022-08-27 2022-09-03 2022-09-10
Min. : 130000 Min. : 141400 Min. : 138250 Min. : 144100 Min. : 131250
2022-09-17 2022-09-24 2022-10-01 2022-10-08 2022-10-15
Min. : 138000 Min. : 116000 Min. : 130000 Min. : 140000 Min. : 133750
2022-10-22 2022-10-29 2022-11-05
Min. : 119900 Min. : 128000 Min. : 127000
[ reached getOption("max.print") -- omitted 6 rows ]Based on what we saw above, we’re going to want to pivot our data into a longer data frame with the weeks moved into a new variable. Then we will filter for the regions we want, then we will pivot it wider again using the regions as the columns. Once we are done we will have a dataframe where every row is a week the data was collected, the columns will be the regions we are interested in and the actual cells will be the median sales prices.
house_sales_cleaned <- house_sales %>%
# Convert the columns that are weeks to be rows
pivot_longer(!c(RegionID:StateName), names_to = "week", values_to = "median_sales_price") %>%
# Filter for the regions we want
filter(RegionName %in% c("United States", "Riverside, CA", "Los Angeles, CA", "San Diego, CA",
"Bakersfield, CA", "Phoenix, AZ")) %>%
select(-c(RegionID, RegionType, StateName, SizeRank)) %>%
# Pivot wider again to make the regions columns
pivot_wider(names_from = RegionName, values_from = median_sales_price) %>%
mutate(week = lubridate::ymd(week))
Below we plot the median sales price for houses in the Riverside metro area over time. You can see it starts with a downard trend until about 2012, then it increases over the next decade just starting another downward trend in mid 2022.
house_sales_cleaned %>%
plot_time_series(week, `Riverside, CA`)NANow we need to split the data into a training and test set. First, though, we will want to extend it and create lagged variables so we can predict on data that comes prior to our dependent variable is reported and actually forecast future values. We will have a training data set which the model will be trained on and then a test data set the model will not have been exposed to yet to test its performance, finally we will also have a future dataset for predicting the median sales price for future dates which haven’t been reported yet. Our test set will be 24 weeks. The plot below indicates the training dataset with the blue portion of the line and the test dataset with the red portion of the line.
house_sales_cleaned_extended <- house_sales_cleaned %>%
future_frame(
.length_out = 24,
.bind_data = TRUE
)
lag_roll_transformer <- function(data){
data %>%
tk_augment_lags(c(`United States`:`Bakersfield, CA`), .lags = 1:24) %>%
tk_augment_slidify(
contains("lag6"),
.f = ~mean(.x, na.rm = T),
.period = 3,
.partial = TRUE
)
}
house_sales_cleaned_model <- house_sales_cleaned_extended %>%
lag_roll_transformer() %>%
select(-c(`United States`:`Phoenix, AZ`, `San Diego, CA`:`Bakersfield, CA`,
ends_with("_lag1"), ends_with("_lag2"), ends_with("_lag3"), ends_with("_lag4"),
ends_with("_lag5"), ends_with("_lag6")))
splits <- house_sales_cleaned_model %>%
filter(!is.na(`Riverside, CA`)) %>%
time_series_split(
assess = "24 weeks",
cumulative = TRUE
)
splits %>%
tk_time_series_cv_plan() %>%
plot_time_series_cv_plan(week, `Riverside, CA`)
future_data <- house_sales_cleaned_model %>%
filter(is.na(`Riverside, CA`))The code below traings three models. We have a lindear model, a glmnet model and an xgboost model. We don’t tune parameters in this project (no do we do feature engineering), we simply use the models out of the box.
hs_sls_lm <- linear_reg() %>%
set_engine("lm") %>%
fit(`Riverside, CA` ~ ., training(splits))
hs_sls_lmparsnip model object
Call:
stats::lm(formula = `Riverside, CA` ~ ., data = data)
Coefficients:
(Intercept) week `United States_lag7`
-6.267e+04 5.597e+00 1.335e-02
`Los Angeles, CA_lag7` `Phoenix, AZ_lag7` `Riverside, CA_lag7`
-5.342e-02 -5.743e-03 -5.192e-02
`San Diego, CA_lag7` `Bakersfield, CA_lag7` `United States_lag8`
-6.460e-02 -1.224e-02 -9.187e-02
`Los Angeles, CA_lag8` `Phoenix, AZ_lag8` `Riverside, CA_lag8`
-2.392e-02 -8.962e-03 9.788e-02
`San Diego, CA_lag8` `Bakersfield, CA_lag8` `United States_lag9`
2.915e-02 -2.047e-02 -2.144e-01
`Los Angeles, CA_lag9` `Phoenix, AZ_lag9` `Riverside, CA_lag9`
-8.147e-03 1.900e-02 1.163e-01
`San Diego, CA_lag9` `Bakersfield, CA_lag9` `United States_lag10`
2.772e-02 -1.561e-03 -3.654e-02
`Los Angeles, CA_lag10` `Phoenix, AZ_lag10` `Riverside, CA_lag10`
-4.994e-02 -9.742e-02 5.397e-02
`San Diego, CA_lag10` `Bakersfield, CA_lag10` `United States_lag11`
4.492e-02 5.445e-03 6.446e-02
`Los Angeles, CA_lag11` `Phoenix, AZ_lag11` `Riverside, CA_lag11`
-2.943e-02 -9.266e-02 1.413e-01
`San Diego, CA_lag11` `Bakersfield, CA_lag11` `United States_lag12`
1.543e-02 -1.206e-02 1.217e-02
`Los Angeles, CA_lag12` `Phoenix, AZ_lag12` `Riverside, CA_lag12`
-7.526e-03 -2.009e-01 8.435e-02
`San Diego, CA_lag12` `Bakersfield, CA_lag12` `United States_lag13`
-5.422e-02 3.207e-03 8.865e-02
`Los Angeles, CA_lag13` `Phoenix, AZ_lag13` `Riverside, CA_lag13`
2.149e-02 5.417e-03 7.120e-02
`San Diego, CA_lag13` `Bakersfield, CA_lag13` `United States_lag14`
-1.888e-02 -1.518e-03 1.534e-01
`Los Angeles, CA_lag14` `Phoenix, AZ_lag14` `Riverside, CA_lag14`
3.493e-03 2.172e-02 2.732e-02
`San Diego, CA_lag14` `Bakersfield, CA_lag14` `United States_lag15`
-2.524e-02 -2.227e-02 7.752e-02
`Los Angeles, CA_lag15` `Phoenix, AZ_lag15` `Riverside, CA_lag15`
6.230e-02 2.392e-02 3.460e-02
`San Diego, CA_lag15` `Bakersfield, CA_lag15` `United States_lag16`
-5.004e-02 7.977e-03 4.111e-01
`Los Angeles, CA_lag16` `Phoenix, AZ_lag16` `Riverside, CA_lag16`
1.298e-02 2.433e-02 9.800e-03
`San Diego, CA_lag16` `Bakersfield, CA_lag16` `United States_lag17`
-6.134e-02 1.579e-02 -2.788e-01
`Los Angeles, CA_lag17` `Phoenix, AZ_lag17` `Riverside, CA_lag17`
-2.671e-03 5.998e-02 1.264e-02
`San Diego, CA_lag17` `Bakersfield, CA_lag17` `United States_lag18`
-4.473e-02 -5.593e-03 -1.938e-02
`Los Angeles, CA_lag18` `Phoenix, AZ_lag18` `Riverside, CA_lag18`
2.613e-02 -1.427e-02 -4.215e-02
`San Diego, CA_lag18` `Bakersfield, CA_lag18` `United States_lag19`
-4.972e-02 6.794e-03 -7.840e-02
`Los Angeles, CA_lag19` `Phoenix, AZ_lag19` `Riverside, CA_lag19`
-2.944e-02 3.676e-02 1.224e-02
`San Diego, CA_lag19` `Bakersfield, CA_lag19` `United States_lag20`
-4.246e-02 3.479e-02 -1.174e-02
`Los Angeles, CA_lag20` `Phoenix, AZ_lag20` `Riverside, CA_lag20`
1.123e-03 -1.434e-02 3.875e-02
`San Diego, CA_lag20` `Bakersfield, CA_lag20` `United States_lag21`
-1.880e-02 4.186e-02 -1.690e-02
`Los Angeles, CA_lag21` `Phoenix, AZ_lag21` `Riverside, CA_lag21`
-5.454e-02 6.138e-02 5.371e-02
`San Diego, CA_lag21` `Bakersfield, CA_lag21` `United States_lag22`
-2.466e-02 -2.265e-02 2.922e-02
`Los Angeles, CA_lag22` `Phoenix, AZ_lag22` `Riverside, CA_lag22`
4.269e-02 6.229e-02 -4.460e-02
`San Diego, CA_lag22` `Bakersfield, CA_lag22` `United States_lag23`
7.940e-03 -5.647e-02 -1.200e-01
`Los Angeles, CA_lag23` `Phoenix, AZ_lag23` `Riverside, CA_lag23`
-2.352e-02 7.403e-02 -3.107e-02
`San Diego, CA_lag23` `Bakersfield, CA_lag23` `United States_lag24`
4.597e-02 -4.056e-02 2.896e-01
`Los Angeles, CA_lag24` `Phoenix, AZ_lag24` `Riverside, CA_lag24`
-2.784e-02 -5.203e-03 -1.425e-01
`San Diego, CA_lag24` `Bakersfield, CA_lag24` `United States_lag6_roll_3`
8.630e-03 -4.983e-02 -1.812e-01
`Los Angeles, CA_lag6_roll_3` `Phoenix, AZ_lag6_roll_3` `Riverside, CA_lag6_roll_3`
6.174e-02 2.785e-01 4.596e-01
`San Diego, CA_lag6_roll_3` `Bakersfield, CA_lag6_roll_3`
2.656e-01 1.227e-02 hs_sls_glmnt <- linear_reg(penalty = 0.01) %>%
set_engine("glmnet") %>%
fit(`Riverside, CA` ~ lubridate::month(week,label = T) + as.numeric(week)+.,
training(splits))
hs_sls_glmntparsnip model object
Call: glmnet::glmnet(x = maybe_matrix(x), y = y, family = "gaussian")
Df %Dev Lambda
1 0 0.00 94650
2 1 16.81 86240
3 1 30.76 78580
4 1 42.35 71600
5 1 51.97 65240
6 1 59.95 59440
7 1 66.58 54160
8 1 72.09 49350
9 1 76.66 44970
10 2 80.47 40970
11 2 83.63 37330
12 2 86.25 34020
13 2 88.43 30990
14 2 90.24 28240
15 2 91.74 25730
16 2 92.98 23450
17 2 94.02 21360
18 2 94.87 19470
19 3 95.59 17740
20 3 96.18 16160
21 3 96.68 14720
22 3 97.09 13420
23 3 97.43 12220
24 3 97.71 11140
25 3 97.95 10150
26 6 98.15 9247
27 7 98.32 8426
28 7 98.47 7677
29 7 98.59 6995
30 7 98.68 6374
31 7 98.77 5808
32 7 98.84 5292
33 7 98.90 4822
34 7 98.95 4393
35 7 98.99 4003
36 7 99.02 3647
37 7 99.05 3323
38 7 99.07 3028
39 7 99.09 2759
40 8 99.12 2514
41 8 99.14 2291
42 8 99.16 2087
43 9 99.18 1902
44 10 99.20 1733
45 10 99.21 1579
46 11 99.23 1439
47 12 99.25 1311
48 12 99.26 1194
49 12 99.28 1088
50 12 99.29 992
51 13 99.30 904
52 14 99.31 823
53 15 99.31 750
54 15 99.32 684
55 12 99.33 623
56 13 99.33 567
57 14 99.33 517
58 16 99.34 471
59 16 99.34 429
60 16 99.34 391
61 16 99.35 356
62 19 99.35 325
63 19 99.35 296
64 22 99.35 270
65 22 99.35 246
66 22 99.35 224
67 22 99.35 204
68 22 99.36 186
69 21 99.36 169hs_sls_xgboost <- boost_tree() %>%
set_engine("xgboost") %>%
set_mode("regression") %>%
fit(`Riverside, CA` ~ lubridate::month(week,label = T) + as.numeric(week)+.,
training(splits))
hs_sls_xgboostparsnip model object
##### xgb.Booster
raw: 34.3 Kb
call:
xgboost::xgb.train(params = list(eta = 0.3, max_depth = 6, gamma = 0,
colsample_bytree = 1, colsample_bynode = 1, min_child_weight = 1,
subsample = 1), data = x$data, nrounds = 15, watchlist = x$watchlist,
verbose = 0, nthread = 1, objective = "reg:squarederror")
params (as set within xgb.train):
eta = "0.3", max_depth = "6", gamma = "0", colsample_bytree = "1", colsample_bynode = "1", min_child_weight = "1", subsample = "1", nthread = "1", objective = "reg:squarederror", validate_parameters = "TRUE"
xgb.attributes:
niter
callbacks:
cb.evaluation.log()
# of features: 127
niter: 15
nfeatures : 127
evaluation_log:The xgboost model has the lowest rmse with about 22,319, but it apparently explains the least amount of the variance in our dependent variable. By the metrics it appears the linear models performs well too, but looking at the plot the glmet and the xgboost models follow the trends in the data while the linear model is almost just a horizontal line. It doesn’t appear to catch movement in the actual median price at all. I would likely include all models in a report though unless the linear model seems to diverge by more.
model_compare <- modeltime_table(hs_sls_lm, hs_sls_glmnt, hs_sls_xgboost)
calibration <- model_compare %>%
modeltime_calibrate(testing(splits))
calibration %>% modeltime_accuracy()
calibration %>%
modeltime_forecast(
new_data = testing(splits),
actual_data = house_sales_cleaned_model
) %>%
plot_modeltime_forecast()NAAll three models seem to predict the start of a downward trend with
the xgboost model (which can handle NA values better)
predicting a long fall in housing prices over the next two years.
hs_sls_forecast <- calibration %>%
modeltime_refit(house_sales_cleaned_model %>%
drop_na()) %>%
modeltime_forecast(
actual_data = house_sales_cleaned_model %>%
drop_na(),
new_data = future_data
)
hs_sls_forecast %>%
plot_modeltime_forecast()NA