Spreadsheet: 816233d1675437258-need-help-finding-top-10-of-values-for-each-date-example
Sheet: Sheet8

Day | Date | Time | Open | High | Low | Close | Volume | HighofDay | LowofDay | HiVolofDay | LoVolofDay | Candle Range | TopWickRange | BtmWickRange | AvgCandleRange | AvgTopWick | AvgBtmWick | MaxCandleRange | MaxTopWick | MaxBtmWick | MinCandleRange | MinTopWick | MinBtmWick
 | 2022-02-01 00:00:00 | 00:00:00 | 1.3444 | 1.34449 | 1.344 | 1.34408 | 650
 | 2022-02-01 00:00:00 | 00:15:00 | 1.34408 | 1.34409 | 1.34388 | 1.34389 | 371
 | 2022-02-01 00:00:00 | 00:30:00 | 1.34392 | 1.34408 | 1.34385 | 1.34399 | 238
 | 2022-02-01 00:00:00 | 00:45:00 | 1.34399 | 1.34405 | 1.3434 | 1.34363 | 466
 | 2022-02-01 00:00:00 | 01:00:00 | 1.34361 | 1.34413 | 1.34354 | 1.34408 | 499
 | 2022-02-01 00:00:00 | 01:15:00 | 1.34408 | 1.34412 | 1.3438 | 1.34396 | 504
 | 2022-02-01 00:00:00 | 01:30:00 | 1.34397 | 1.34418 | 1.34388 | 1.34391 | 659
 | 2022-02-01 00:00:00 | 01:45:00 | 1.34391 | 1.34392 | 1.34357 | 1.34383 | 512
 | 2022-02-01 00:00:00 | 02:00:00 | 1.34382 | 1.344 | 1.34376 | 1.344 | 429
 | 2022-02-01 00:00:00 | 02:15:00 | 1.34401 | 1.34419 | 1.34395 | 1.34418 | 513
 | 2022-02-01 00:00:00 | 02:30:00 | 1.3442 | 1.34451 | 1.34415 | 1.34448 | 491
 | 2022-02-01 00:00:00 | 02:45:00 | 1.34449 | 1.3446 | 1.34429 | 1.34447 | 327
 | 2022-02-01 00:00:00 | 03:00:00 | 1.34448 | 1.34449 | 1.34429 | 1.34439 | 271
 | 2022-02-01 00:00:00 | 03:15:00 | 1.34439 | 1.34479 | 1.34439 | 1.34448 | 382
 | 2022-02-01 00:00:00 | 03:30:00 | 1.34448 | 1.34453 | 1.34349 | 1.34367 | 1687
 | 2022-02-01 00:00:00 | 03:45:00 | 1.34369 | 1.34409 | 1.34359 | 1.344 | 523
 | 2022-02-01 00:00:00 | 04:00:00 | 1.34401 | 1.3444 | 1.34399 | 1.34437 | 451
 | 2022-02-01 00:00:00 | 04:15:00 | 1.34438 | 1.3447 | 1.34437 | 1.34463 | 534
 | 2022-02-01 00:00:00 | 04:30:00 | 1.34463 | 1.34503 | 1.34455 | 1.34498 | 477
 | 2022-02-02 00:00:00 | 00:00:00 | 1.35239 | 1.35246 | 1.35217 | 1.35218 | 397
 | 2022-02-02 00:00:00 | 00:15:00 | 1.35219 | 1.35238 | 1.35204 | 1.35218 | 481
 | 2022-02-02 00:00:00 | 00:30:00 | 1.35216 | 1.35226 | 1.3521 | 1.35219 | 369
 | 2022-02-02 00:00:00 | 00:45:00 | 1.35219 | 1.35264 | 1.35219 | 1.3524 | 449
 | 2022-02-02 00:00:00 | 01:00:00 | 1.35241 | 1.35249 | 1.3522 | 1.3522 | 574
 | 2022-02-02 00:00:00 | 01:15:00 | 1.3522 | 1.3526 | 1.35214 | 1.35256 | 602
 | 2022-02-02 00:00:00 | 01:30:00 | 1.3526 | 1.3527 | 1.35239 | 1.35246 | 697
 | 2022-02-02 00:00:00 | 01:45:00 | 1.35245 | 1.35259 | 1.35238 | 1.35256 | 518
 | 2022-02-02 00:00:00 | 02:00:00 | 1.35256 | 1.35272 | 1.35238 | 1.35256 | 456
 | 2022-02-02 00:00:00 | 02:15:00 | 1.35254 | 1.35257 | 1.35216 | 1.35239 | 558
 | 2022-02-02 00:00:00 | 02:30:00 | 1.3524 | 1.35257 | 1.3523 | 1.3524 | 348
 | 2022-02-02 00:00:00 | 02:45:00 | 1.3524 | 1.35243 | 1.35214 | 1.35217 | 251
 | 2022-02-02 00:00:00 | 03:00:00 | 1.35216 | 1.35226 | 1.35207 | 1.35207 | 329
 | 2022-02-02 00:00:00 | 03:15:00 | 1.35208 | 1.35219 | 1.35198 | 1.3521 | 288
 | 2022-02-02 00:00:00 | 03:30:00 | 1.35209 | 1.3521 | 1.35186 | 1.35195 | 208
 | 2022-02-02 00:00:00 | 03:45:00 | 1.35193 | 1.352 | 1.35164 | 1.35164 | 375
 | 2022-02-02 00:00:00 | 04:00:00 | 1.35165 | 1.35214 | 1.35165 | 1.35209 | 264
 | 2022-02-02 00:00:00 | 04:15:00 | 1.35211 | 1.3522 | 1.35207 | 1.35209 | 193
 | 2022-02-02 00:00:00 | 04:30:00 | 1.3521 | 1.35234 | 1.35205 | 1.35209 | 240
 | 2022-02-02 00:00:00 | 04:45:00 | 1.35207 | 1.35212 | 1.35194 | 1.35196 | 293