Spreadsheet: 771942d1646925291-average-last-n-rows-with-if-weekdayweekendaverages
Sheet: Sheet1

Date | Volume | Day | Last 60 weekdays avg | Last 8 weekends avg
2021-01-31 00:00:00 | 0
2021-02-19 00:00:00 | 11
2021-02-20 00:00:00 | 5
2021-02-23 00:00:00 | 3497
2021-02-24 00:00:00 | 11865
2021-02-25 00:00:00 | 11705
2021-02-26 00:00:00 | 14447
2021-02-27 00:00:00 | 11378
2021-02-28 00:00:00 | 161
2021-03-02 00:00:00 | 13427
2021-03-03 00:00:00 | 2233
2021-03-04 00:00:00 | 14300
2021-03-05 00:00:00 | 19988
2021-03-06 00:00:00 | 17510
2021-03-08 00:00:00 | 578
2021-03-09 00:00:00 | 8983
2021-03-10 00:00:00 | 30034
2021-03-11 00:00:00 | 19978
2021-03-12 00:00:00 | 6951
2021-03-13 00:00:00 | 6836
2021-03-14 00:00:00 | 511
2021-03-16 00:00:00 | 9471
2021-03-17 00:00:00 | 4387
2021-03-18 00:00:00 | 8744
2021-03-19 00:00:00 | 10979
2021-03-20 00:00:00 | 6080
2021-03-23 00:00:00 | 8185
2021-03-24 00:00:00 | 20429
2021-03-25 00:00:00 | 17209
2021-03-26 00:00:00 | 26210
2021-03-27 00:00:00 | 14306
2021-03-28 00:00:00 | 1450
2021-03-30 00:00:00 | 17028
2021-03-31 00:00:00 | 14206
2021-04-01 00:00:00 | 11697
2021-04-02 00:00:00 | 21880
2021-04-03 00:00:00 | 4943
2021-04-04 00:00:00 | 213
2021-04-06 00:00:00 | 22153
2021-04-07 00:00:00 | 25708
2021-04-08 00:00:00 | 38201
2021-04-09 00:00:00 | 22756
2021-04-10 00:00:00 | 20633
2021-04-12 00:00:00 | 0
2021-04-13 00:00:00 | 10171
2021-04-14 00:00:00 | 37006
2021-04-15 00:00:00 | 18936
2021-04-16 00:00:00 | 32392
2021-04-17 00:00:00 | 38816
2021-04-18 00:00:00 | 847
2021-04-19 00:00:00 | 548
2021-04-20 00:00:00 | 19104
2021-04-21 00:00:00 | 34829
2021-04-22 00:00:00 | 26061
2021-04-23 00:00:00 | 14970
2021-04-24 00:00:00 | 25387
2021-04-25 00:00:00 | 2626
2021-04-27 00:00:00 | 29895
2021-04-28 00:00:00 | 28744
2021-04-29 00:00:00 | 63231
2021-04-30 00:00:00 | 21752
2021-05-01 00:00:00 | 27694
2021-05-02 00:00:00 | 3744
2021-05-03 00:00:00 | 369
2021-05-04 00:00:00 | 20244
2021-05-05 00:00:00 | 30412
2021-05-06 00:00:00 | 41134
2021-05-07 00:00:00 | 56089
2021-05-08 00:00:00 | 63760
2021-05-09 00:00:00 | 3833
2021-05-10 00:00:00 | 2646
2021-05-11 00:00:00 | 48910
2021-05-12 00:00:00 | 42356
2021-05-13 00:00:00 | 57548
2021-05-14 00:00:00 | 78155
2021-05-15 00:00:00 | 61994
2021-05-16 00:00:00 | 975
2021-05-17 00:00:00 | 5815
2021-05-18 00:00:00 | 38925
2021-05-19 00:00:00 | 26794
2021-05-20 00:00:00 | 39460
2021-05-21 00:00:00 | 76797
2021-05-22 00:00:00 | 34287
2021-05-23 00:00:00 | 13231
2021-05-24 00:00:00 | 1410
2021-05-25 00:00:00 | 44264
2021-05-26 00:00:00 | 75645
2021-05-27 00:00:00 | 68214
2021-05-28 00:00:00 | 61962
2021-05-29 00:00:00 | 71179
2021-05-30 00:00:00 | 3806
2021-05-31 00:00:00 | 4919
2021-06-02 00:00:00 | 73961
2021-06-03 00:00:00 | 43227
2021-06-04 00:00:00 | 75791
2021-06-05 00:00:00 | 55670
2021-06-06 00:00:00 | 85
2021-06-07 00:00:00 | 7705
2021-06-08 00:00:00 | 74163
2021-06-09 00:00:00 | 75563
2021-06-10 00:00:00 | 97727
2021-06-11 00:00:00 | 93314
2021-06-12 00:00:00 | 83428
2021-06-13 00:00:00 | 3701
2021-06-14 00:00:00 | 2743
2021-06-15 00:00:00 | 71675
2021-06-16 00:00:00 | 79166
2021-06-17 00:00:00 | 80846
2021-06-18 00:00:00 | 107787
2021-06-19 00:00:00 | 107524
2021-06-20 00:00:00 | 11130
2021-06-21 00:00:00 | 5021
2021-06-22 00:00:00 | 91303
2021-06-23 00:00:00 | 77811
2021-06-24 00:00:00 | 115112
2021-06-25 00:00:00 | 108597
2021-06-26 00:00:00 | 103946
2021-06-27 00:00:00 | 11475
2021-06-28 00:00:00 | 7212
2021-06-29 00:00:00 | 77449
2021-06-30 00:00:00 | 130832
2021-07-01 00:00:00 | 94618
2021-07-02 00:00:00 | 180090
2021-07-03 00:00:00 | 106943
2021-07-04 00:00:00 | 2894
2021-07-05 00:00:00 | 4441
2021-07-06 00:00:00 | 18730
2021-07-07 00:00:00 | 49882
2021-07-08 00:00:00 | 130994
2021-07-09 00:00:00 | 86952
2021-07-10 00:00:00 | 87753
2021-07-11 00:00:00 | 11486
2021-07-12 00:00:00 | 2946
2021-07-13 00:00:00 | 80699
2021-07-14 00:00:00 | 106358
2021-07-15 00:00:00 | 113472
2021-07-16 00:00:00 | 129552
2021-07-17 00:00:00 | 105340
2021-07-18 00:00:00 | 6323
2021-07-20 00:00:00 | 83949
2021-07-21 00:00:00 | 91069
2021-07-22 00:00:00 | 105035
2021-07-23 00:00:00 | 128741
2021-07-24 00:00:00 | 115480
2021-07-25 00:00:00 | 11607
2021-07-26 00:00:00 | 938
2021-07-27 00:00:00 | 86814
2021-07-28 00:00:00 | 113376
2021-07-29 00:00:00 | 128053
2021-07-30 00:00:00 | 142957
2021-07-31 00:00:00 | 175528
2021-08-01 00:00:00 | 7964
2021-08-02 00:00:00 | 1833
2021-08-03 00:00:00 | 184416
2021-08-04 00:00:00 | 108553
2021-08-05 00:00:00 | 105100
2021-08-06 00:00:00 | 131428
2021-08-07 00:00:00 | 161880
2021-08-08 00:00:00 | 14742
2021-08-09 00:00:00 | 1247
2021-08-10 00:00:00 | 104397
2021-08-11 00:00:00 | 157747
2021-08-12 00:00:00 | 160769
2021-08-13 00:00:00 | 120933
2021-08-14 00:00:00 | 122660
2021-08-15 00:00:00 | 13784
2021-08-16 00:00:00 | 5178
2021-08-17 00:00:00 | 117163
2021-08-18 00:00:00 | 114488
2021-08-19 00:00:00 | 175926
2021-08-20 00:00:00 | 166246
2021-08-21 00:00:00 | 130729
2021-08-22 00:00:00 | 10691
2021-08-23 00:00:00 | 10547
2021-08-24 00:00:00 | 106114
2021-08-25 00:00:00 | 147293
2021-08-26 00:00:00 | 155710
2021-08-27 00:00:00 | 134670
2021-08-28 00:00:00 | 138918
2021-08-29 00:00:00 | 13499
2021-08-30 00:00:00 | 8995
2021-08-31 00:00:00 | 131303
2021-09-01 00:00:00 | 145078
2021-09-02 00:00:00 | 294888
2021-09-03 00:00:00 | 112451
2021-09-04 00:00:00 | 172533
2021-09-05 00:00:00 | 24645
2021-09-06 00:00:00 | 5190
2021-09-07 00:00:00 | 15033
2021-09-08 00:00:00 | 111158
2021-09-09 00:00:00 | 143902
2021-09-10 00:00:00 | 201792
2021-09-11 00:00:00 | 139183
2021-09-12 00:00:00 | 14451
2021-09-13 00:00:00 | 3581
2021-09-14 00:00:00 | 157904
2021-09-15 00:00:00 | 187097
2021-09-16 00:00:00 | 114185
2021-09-17 00:00:00 | 115315
2021-09-18 00:00:00 | 150493
2021-09-19 00:00:00 | 21083
2021-09-20 00:00:00 | 8685
2021-09-21 00:00:00 | 152020
2021-09-22 00:00:00 | 133125
2021-09-23 00:00:00 | 155190
2021-09-24 00:00:00 | 126393
2021-09-25 00:00:00 | 126847
2021-09-26 00:00:00 | 5472
2021-09-27 00:00:00 | 3365
2021-09-28 00:00:00 | 166920
2021-09-29 00:00:00 | 164210
2021-09-30 00:00:00 | 240406
2021-10-01 00:00:00 | 213402
2021-10-02 00:00:00 | 244804
2021-10-03 00:00:00 | 69303
2021-10-04 00:00:00 | 16723
2021-10-05 00:00:00 | 179791
2021-10-06 00:00:00 | 144156
2021-10-07 00:00:00 | 200373
2021-10-08 00:00:00 | 144495
2021-10-09 00:00:00 | 219430
2021-10-10 00:00:00 | 39462
2021-10-11 00:00:00 | 10221
2021-10-12 00:00:00 | 168622
2021-10-13 00:00:00 | 176535
2021-10-14 00:00:00 | 193693
2021-10-15 00:00:00 | 209665
2021-10-16 00:00:00 | 181952
2021-10-17 00:00:00 | 14131
2021-10-18 00:00:00 | 5888
2021-10-19 00:00:00 | 161758
2021-10-20 00:00:00 | 178274
2021-10-21 00:00:00 | 171874
2021-10-22 00:00:00 | 204926
2021-10-23 00:00:00 | 175075
2021-10-24 00:00:00 | 11913
2021-10-25 00:00:00 | 5407
2021-10-26 00:00:00 | 189944
2021-10-27 00:00:00 | 243972
2021-10-28 00:00:00 | 247627
2021-10-29 00:00:00 | 252516
2021-10-30 00:00:00 | 236123
2021-10-31 00:00:00 | 11888
2021-11-01 00:00:00 | 8166
2021-11-02 00:00:00 | 207480
2021-11-03 00:00:00 | 205216
2021-11-04 00:00:00 | 348397
2021-11-05 00:00:00 | 231509
2021-11-06 00:00:00 | 214290
2021-11-07 00:00:00 | 25087
2021-11-08 00:00:00 | 8057
2021-11-09 00:00:00 | 207561
2021-11-10 00:00:00 | 190748
2021-11-11 00:00:00 | 271443
2021-11-12 00:00:00 | 253119
2021-11-13 00:00:00 | 261935
2021-11-14 00:00:00 | 17322
2021-11-15 00:00:00 | 6810
2021-11-16 00:00:00 | 197327
2021-11-17 00:00:00 | 270198
2021-11-18 00:00:00 | 216888
2021-11-19 00:00:00 | 208473
2021-11-20 00:00:00 | 223110
2021-11-21 00:00:00 | 19323
2021-11-22 00:00:00 | 8560
2021-11-23 00:00:00 | 234105
2021-11-24 00:00:00 | 277134
2021-11-25 00:00:00 | 231527
2021-11-26 00:00:00 | 45568
2021-11-27 00:00:00 | 38927
2021-11-28 00:00:00 | 6398
2021-11-29 00:00:00 | 19168
2021-11-30 00:00:00 | 233600
2021-12-01 00:00:00 | 283053
2021-12-02 00:00:00 | 314574
2021-12-03 00:00:00 | 370884
2021-12-04 00:00:00 | 317696
2021-12-05 00:00:00 | 39368
2021-12-06 00:00:00 | 6094
2021-12-07 00:00:00 | 194933
2021-12-08 00:00:00 | 239785
2021-12-09 00:00:00 | 265326
2021-12-10 00:00:00 | 219496
2021-12-11 00:00:00 | 222957
2021-12-12 00:00:00 | 14970
2021-12-13 00:00:00 | 9561
2021-12-14 00:00:00 | 208501
2021-12-15 00:00:00 | 274830
2021-12-16 00:00:00 | 242784
2021-12-17 00:00:00 | 262096
2021-12-18 00:00:00 | 260547
2021-12-19 00:00:00 | 14554
2021-12-20 00:00:00 | 27108
2021-12-21 00:00:00 | 203940
2021-12-22 00:00:00 | 207080
2021-12-23 00:00:00 | 285779
2021-12-24 00:00:00 | 161834
2021-12-25 00:00:00 | 28728
2021-12-26 00:00:00 | 146
2021-12-27 00:00:00 | 4498
2021-12-28 00:00:00 | 179602
2021-12-29 00:00:00 | 246594
2021-12-30 00:00:00 | 203711
2021-12-31 00:00:00 | 180256
2022-01-01 00:00:00 | 80194
2022-01-02 00:00:00 | 4682
2022-01-03 00:00:00 | 8010
2022-01-04 00:00:00 | 202832
2022-01-05 00:00:00 | 254174
2022-01-06 00:00:00 | 355220
2022-01-07 00:00:00 | 224478
2022-01-08 00:00:00 | 204219
2022-01-09 00:00:00 | 14968
2022-01-10 00:00:00 | 7939
2022-01-11 00:00:00 | 218719
2022-01-12 00:00:00 | 246248
2022-01-13 00:00:00 | 237614
2022-01-14 00:00:00 | 207393
2022-01-15 00:00:00 | 206459
2022-01-16 00:00:00 | 17502
2022-01-17 00:00:00 | 5308
2022-01-18 00:00:00 | 138919
2022-01-19 00:00:00 | 225842
2022-01-20 00:00:00 | 222048
2022-01-21 00:00:00 | 173150
2022-01-22 00:00:00 | 223784
2022-01-23 00:00:00 | 8639
2022-01-24 00:00:00 | 9858
2022-01-25 00:00:00 | 207279
2022-01-26 00:00:00 | 212332
2022-01-27 00:00:00 | 256123
2022-01-28 00:00:00 | 250515
2022-01-29 00:00:00 | 233230
2022-01-30 00:00:00 | 22711
2022-01-31 00:00:00 | 8549
2022-02-01 00:00:00 | 256012
2022-02-02 00:00:00 | 304218
2022-02-03 00:00:00 | 241124
2022-02-04 00:00:00 | 424279
2022-02-05 00:00:00 | 217235
2022-02-06 00:00:00 | 19110
2022-02-07 00:00:00 | 28689
2022-02-08 00:00:00 | 227034
2022-02-09 00:00:00 | 317923
2022-02-10 00:00:00 | 308592
2022-02-11 00:00:00 | 251649
2022-02-12 00:00:00 | 224390
2022-02-13 00:00:00 | 30336
2022-02-14 00:00:00 | 19942
2022-02-15 00:00:00 | 264101
2022-02-16 00:00:00 | 261844
2022-02-17 00:00:00 | 300269
2022-02-18 00:00:00 | 270064
2022-02-19 00:00:00 | 253145
2022-02-20 00:00:00 | 9362
2022-02-21 00:00:00 | 131959
2022-02-22 00:00:00 | 185885
2022-02-23 00:00:00 | 274878
2022-02-24 00:00:00 | 248047
2022-02-25 00:00:00 | 280707
2022-02-27 00:00:00 | 296675
2022-02-28 00:00:00 | 6447
2022-03-01 00:00:00 | 298963
2022-03-02 00:00:00 | 391285
2022-03-03 00:00:00 | 370298
2022-03-04 00:00:00 | 291608
2022-03-05 00:00:00 | 366568
2022-03-06 00:00:00 | 29234
2022-03-07 00:00:00 | 16205
2022-03-08 00:00:00 | 291331
2022-03-09 00:00:00 | 268740