hose Demo data with a pulse

A claim about Overwater

Three years of daily sales, with weekends and seasons in them, that regenerate byte for byte.

A daily series with lower weekends, a spring hump and a February trough each year, a level that drifts across years, and identical values on every regeneration.

holds on the current window

as of moments ago

Daily sales series

SELECT date(ordered_at)          AS day,
       COUNT(*)                  AS orders,
       ROUND(SUM(total_usd), 2)  AS revenue
FROM orders
GROUP BY 1
ORDER BY 1;
2023-06-062026-11-05
View data table
dayordersrevenue
2023-06-061288
2023-06-12146
2023-06-15146
2023-06-26121
2023-06-27131
2023-06-28298
2023-06-29192
2023-06-302128
2023-07-012163
2023-07-03153
2023-07-06155
2023-07-08111
2023-07-114266
2023-07-12131
2023-07-132176
2023-07-15291
2023-07-172238
2023-07-184408
2023-07-193108
2023-07-211157
2023-07-22122
2023-07-23157
2023-07-252332
2023-07-265393
2023-07-27289
2023-07-284367
2023-07-30288
2023-07-31115
2023-08-031302
2023-08-061101
2023-08-073591
2023-08-083230
2023-08-104244
2023-08-113291
2023-08-123148
2023-08-142192
2023-08-153124
2023-08-16177
2023-08-183268
2023-08-19159
2023-08-20138
2023-08-21274
2023-08-22282
2023-08-232134
2023-08-24131
2023-08-26121
2023-08-28141
2023-08-29261
2023-08-303335
2023-08-312313
2023-09-015344.8
2023-09-044431.6
2023-09-052250.9
2023-09-061267.3
2023-09-087304.9
2023-09-094371.2
2023-09-11299.8
2023-09-124383.7
2023-09-14259.4
2023-09-15199
2023-09-163321
2023-09-172129.3
2023-09-183151.1
2023-09-193186.7
2023-09-204165.9
2023-09-214254
2023-09-252247
2023-09-263155.3
2023-09-274451.7
2023-09-283180.9
2023-09-294230.5
2023-09-30397.1
2023-10-022146
2023-10-034281
2023-10-042236
2023-10-051128
2023-10-063399
2023-10-08115
2023-10-092163
2023-10-105345
2023-10-11251
2023-10-12131
2023-10-133199
2023-10-142137
2023-10-153351
2023-10-161123
2023-10-173115
2023-10-18277
2023-10-193355
2023-10-202121
2023-10-213314
2023-10-22177
2023-10-234617
2023-10-243144
2023-10-264203
2023-10-275346
2023-10-28131
2023-10-292221
2023-10-301191
2023-10-314466
2023-11-01277
2023-11-025720
2023-11-039468
2023-11-045279
2023-11-05120
2023-11-064379
2023-11-078335
2023-11-08143
2023-11-097923
2023-11-10286
2023-11-113205
2023-11-123114
2023-11-137456
2023-11-145488
2023-11-153484
2023-11-164434
2023-11-1761022
2023-11-181109
2023-11-195510
2023-11-207393
2023-11-214240
2023-11-227396
2023-11-234188
2023-11-2410815
2023-11-255322.75
2023-11-268974
2023-11-2714750.25
2023-11-28111144
2023-11-294457
2023-11-304316
2023-12-018586.75
2023-12-026726.45
2023-12-036443.3
2023-12-0410603.45
2023-12-05131135.95
2023-12-066274.8
2023-12-077305
2023-12-0810579.65
2023-12-0912883.85
2023-12-107317.45
2023-12-1113878.55
2023-12-129789.55
2023-12-13121262.05
2023-12-148418.05
2023-12-156496.4
2023-12-16111146.3
2023-12-177573
2023-12-18181782.35
2023-12-197536.85
2023-12-2013993.4
2023-12-21171127.95
2023-12-223209.6
2023-12-2314997.8
2023-12-249459.4
2023-12-258401
2023-12-269576
2023-12-278322
2023-12-286405
2023-12-296692
2023-12-303169
2023-12-315647
2024-01-019885.8
2024-01-028949.9
2024-01-039513.4
2024-01-047328
2024-01-056306.1
2024-01-063222.3
2024-01-073164.7
2024-01-0813965.3
2024-01-096512.7
2024-01-106447.6
2024-01-11114.4
2024-01-124249.6
2024-01-135576.9
2024-01-144483.8
2024-01-156245.3
2024-01-164418
2024-01-177446
2024-01-186511
2024-01-19498
2024-01-201179
2024-01-21297
2024-01-225307
2024-01-23165
2024-01-246893
2024-01-253521
2024-01-264402
2024-01-272149
2024-01-283144
2024-01-292203
2024-01-306937
2024-01-317464
2024-02-017671
2024-02-023318
2024-02-03141
2024-02-04144
2024-02-051119
2024-02-065241
2024-02-071260
2024-02-084272
2024-02-091146
2024-02-10152
2024-02-11115
2024-02-125347
2024-02-134191
2024-02-142161
2024-02-156487
2024-02-163276
2024-02-174311
2024-02-18283
2024-02-196335
2024-02-20131
2024-02-21121
2024-02-223330
2024-02-232215
2024-02-241307
2024-02-259513
2024-02-267630
2024-02-2710555
2024-02-286547
2024-02-2981034
2024-03-0111750
2024-03-023143
2024-03-037689
2024-03-04201975
2024-03-05211668
2024-03-06262327
2024-03-07251853
2024-03-08252127
2024-03-09171608
2024-03-10111037
2024-03-11141602
2024-03-12181821
2024-03-13192013
2024-03-14161204
2024-03-15161223.4
2024-03-16111107.9
2024-03-1713826.55
2024-03-18303185.25
2024-03-19261568.8
2024-03-20161662.9
2024-03-21221941.65
2024-03-22211560.45
2024-03-2313787.8
2024-03-2413758.1
2024-03-25232184.8
2024-03-26261726.15
2024-03-27221682.7
2024-03-28342585.3
2024-03-29191729.4
2024-03-30171386.7
2024-03-3116797
2024-04-0117899.65
2024-04-02151003.35
2024-04-03181407.5
2024-04-04212292.35
2024-04-05161127.85
2024-04-06201305.3
2024-04-0713968.45
2024-04-08262297.15
2024-04-09181301.9
2024-04-1016926.25
2024-04-11231137.8
2024-04-12251528.65
2024-04-13151207.25
2024-04-14202087.45
2024-04-15251876.45
2024-04-16222284.5
2024-04-17332614.85
2024-04-18221697.6
2024-04-19201326.95
2024-04-20141395.95
2024-04-2111816.05
2024-04-22291828.5
2024-04-23271988.8
2024-04-2415963.75
2024-04-25171380.55
2024-04-26272281.3
2024-04-27211485.65
2024-04-28211826.75
2024-04-29302556.7
2024-04-30373620.7
2024-05-01252177.2
2024-05-02382422.4
2024-05-03181430.6
2024-05-04211567
2024-05-05181654.8
2024-05-06302073.4
2024-05-07382772.4
2024-05-08383240.6
2024-05-09342540.4
2024-05-10353007.6
2024-05-11382948.2
2024-05-12382408.2
2024-05-13322312.2
2024-05-14251726.6
2024-05-15202078
2024-05-16272344
2024-05-17201584
2024-05-18171040
2024-05-19141430
2024-05-20252496
2024-05-21202281
2024-05-22262521
2024-05-23181618
2024-05-24273340
2024-05-25121572
2024-05-26191812
2024-05-27262665
2024-05-28282240
2024-05-29211780
2024-05-30212053
2024-05-31201733
2024-06-01101239
2024-06-0213913
2024-06-03171469
2024-06-04211842
2024-06-0511503
2024-06-06151032
2024-06-07101366
2024-06-08141219
2024-06-0910775
2024-06-1015778
2024-06-11151324
2024-06-12171602
2024-06-13151415
2024-06-1412641
2024-06-15131346
2024-06-1610774
2024-06-17181388
2024-06-1812992
2024-06-1910860
2024-06-2013988
2024-06-21211502
2024-06-22111059
2024-06-23101061
2024-06-24151902
2024-06-25181255
2024-06-26131428
2024-06-2710686
2024-06-2810717
2024-06-296581
2024-06-308563
2024-07-01171341
2024-07-02151048
2024-07-03151738
2024-07-04151159
2024-07-05161334
2024-07-065350
2024-07-075194
2024-07-08131030
2024-07-09161900
2024-07-10181246
2024-07-11191319
2024-07-12111019
2024-07-1311786
2024-07-14111133
2024-07-15242442
2024-07-16201351
2024-07-1711772
2024-07-1814971
2024-07-19141081
2024-07-20121270
2024-07-2111854
2024-07-22151079
2024-07-238869
2024-07-24161152
2024-07-25131474
2024-07-266520
2024-07-2710872
2024-07-2814948
2024-07-29161257
2024-07-3010677
2024-07-31181422
2024-08-01141196
2024-08-02101472
2024-08-037702
2024-08-0410712
2024-08-059779
2024-08-067389
2024-08-078441
2024-08-08121163
2024-08-09151071
2024-08-106450
2024-08-116349
2024-08-1211993
2024-08-13152258
2024-08-1413889
2024-08-15161192
2024-08-1610528
2024-08-177492
2024-08-1811930
2024-08-19181700
2024-08-209409
2024-08-21101278
2024-08-22222202
2024-08-2311756
2024-08-248487
2024-08-25131219
2024-08-268326
2024-08-276868
2024-08-28151428
2024-08-29151154
2024-08-3012795
2024-08-318754
2024-09-01121148.3
2024-09-025446.2
2024-09-03121118.4
2024-09-048718.8
2024-09-0591025.7
2024-09-066397.8
2024-09-07111025.1
2024-09-0811832.6
2024-09-0912975
2024-09-109729.2
2024-09-11101100.8
2024-09-1214857.7
2024-09-1310998.6
2024-09-149753.4
2024-09-159416.1
2024-09-16131705.9
2024-09-17161237.5
2024-09-188752.8
2024-09-197604.5
2024-09-208686.5
2024-09-2191016.3
2024-09-227684.1
2024-09-237553.8
2024-09-24111490.2
2024-09-259808.5
2024-09-269752
2024-09-275643.2
2024-09-2811578.7
2024-09-296554.5
2024-09-30131210.2
2024-10-01181982
2024-10-028661
2024-10-038704
2024-10-0410743
2024-10-057679
2024-10-069857
2024-10-074407
2024-10-0811816
2024-10-099819
2024-10-1012939
2024-10-117676
2024-10-126397
2024-10-1391219
2024-10-1410853
2024-10-156524
2024-10-169652
2024-10-177717
2024-10-1810584
2024-10-198671
2024-10-203367
2024-10-215318
2024-10-2211741
2024-10-235476
2024-10-247442
2024-10-259919
2024-10-269963
2024-10-275284
2024-10-2811948
2024-10-297797
2024-10-3091242
2024-10-31131227
2024-11-01141368
2024-11-025423
2024-11-037414
2024-11-047509
2024-11-0514602
2024-11-0610896
2024-11-07131293
2024-11-08151550
2024-11-094574
2024-11-107386
2024-11-119678
2024-11-12191682
2024-11-1391293
2024-11-14121605
2024-11-1510872
2024-11-167993
2024-11-175513
2024-11-18161128
2024-11-1911997
2024-11-207697
2024-11-2112818
2024-11-229796
2024-11-2313854
2024-11-24141266
2024-11-25151682
2024-11-26101124
2024-11-27131118
2024-11-286838
2024-11-29241938.25
2024-11-30121049.5
2024-12-0111862
2024-12-02241969.5
2024-12-03131055.45
2024-12-0412901.55
2024-12-05121180.15
2024-12-06101162.6
2024-12-074285.6
2024-12-087893.6
2024-12-09161301.7
2024-12-108883.5
2024-12-117441.75
2024-12-1210950.65
2024-12-1311506.35
2024-12-146911.25
2024-12-159469.6
2024-12-1614732.15
2024-12-17151157.75
2024-12-1813708.15
2024-12-1913804
2024-12-20151540.05
2024-12-2111766
2024-12-22141431.8
2024-12-2312935.5
2024-12-24222576.4
2024-12-2581096
2024-12-26171702
2024-12-279993
2024-12-284124
2024-12-297600
2024-12-308593
2024-12-31181
2025-01-017434
2025-01-025594.8
2025-01-038723.1
2025-01-043126
2025-01-053425.1
2025-01-063341.4
2025-01-075624.9
2025-01-082171.9
2025-01-092303.6
2025-01-10292.9
2025-01-114120.6
2025-01-12282.8
2025-01-13138.7
2025-01-143578.1
2025-01-154387
2025-01-162195
2025-01-176482
2025-01-183160
2025-01-193176
2025-01-213435
2025-01-221264
2025-01-23156
2025-01-242147
2025-01-251108
2025-01-263281
2025-01-274329
2025-01-284169
2025-01-291282
2025-01-305359
2025-01-31199
2025-02-01126
2025-02-024332
2025-02-03122
2025-02-043145
2025-02-053420
2025-02-06160
2025-02-075291
2025-02-092184
2025-02-104190
2025-02-112217
2025-02-121106
2025-02-132140
2025-02-143217
2025-02-161223
2025-02-174163
2025-02-183113
2025-02-191190
2025-02-205326
2025-02-21289
2025-02-22152
2025-02-24162
2025-02-252103
2025-02-26156
2025-02-272106
2025-02-286530
2025-03-017738
2025-03-028357
2025-03-039877
2025-03-04141012
2025-03-05192057
2025-03-0613964
2025-03-0711898
2025-03-088910
2025-03-096693
2025-03-109471
2025-03-1111677
2025-03-12181780
2025-03-1312822
2025-03-149473
2025-03-15161124.3
2025-03-1611793.15
2025-03-17141312.6
2025-03-18181648.4
2025-03-19201460.2
2025-03-20171609.8
2025-03-21131914.6
2025-03-2281023.95
2025-03-23151193.4
2025-03-24201648.75
2025-03-25221706.3
2025-03-26182173.4
2025-03-27151523.45
2025-03-28241376.75
2025-03-29141261.55
2025-03-30201969.75
2025-03-31231826.45
2025-04-01292718.85
2025-04-02302853.7
2025-04-03232265.3
2025-04-04242596.6
2025-04-05212084.7
2025-04-06201593.55
2025-04-07262372.5
2025-04-08131545.35
2025-04-09192040.05
2025-04-10242300.45
2025-04-11201871.5
2025-04-12161201.75
2025-04-13181690
2025-04-14252327.75
2025-04-15252694.2
2025-04-16242059.45
2025-04-17232060.1
2025-04-18212096.3
2025-04-19111334.15
2025-04-20221673.35
2025-04-21242044.25
2025-04-22282433.6
2025-04-23241666.95
2025-04-24141663.25
2025-04-25242054.8
2025-04-2613916.35
2025-04-27191311.1
2025-04-28202268.8
2025-04-29171439.05
2025-04-30262024.05
2025-05-01222028.8
2025-05-02251599
2025-05-03171295.8
2025-05-0414987.4
2025-05-05181336.6
2025-05-06231379.2
2025-05-07504769.8
2025-05-08353273
2025-05-09303268.2
2025-05-10302415.6
2025-05-11343037.8
2025-05-12363542.6
2025-05-13383671.2
2025-05-14272686.2
2025-05-15221786
2025-05-16232405
2025-05-17212162
2025-05-18202158
2025-05-19283366
2025-05-20231733
2025-05-21312953
2025-05-22363328
2025-05-23323739
2025-05-24151456
2025-05-25211765
2025-05-26201921
2025-05-27141916
2025-05-28222393
2025-05-29221866
2025-05-30181857
2025-05-3115987
2025-06-01111508
2025-06-02171433
2025-06-03222324
2025-06-04171887
2025-06-05162072
2025-06-06131007
2025-06-076372
2025-06-089810
2025-06-09101517
2025-06-10101315
2025-06-119802
2025-06-125482
2025-06-137948
2025-06-146357
2025-06-158836
2025-06-168716
2025-06-17101125
2025-06-188791
2025-06-1981223
2025-06-207624
2025-06-2113948
2025-06-226680
2025-06-239985
2025-06-242233
2025-06-25111226
2025-06-265435
2025-06-27161629
2025-06-28101071
2025-06-2910913
2025-06-30101094
2025-07-01151489
2025-07-0211567
2025-07-035217
2025-07-044237
2025-07-052220
2025-07-0610697
2025-07-075501
2025-07-086776
2025-07-098429
2025-07-109949
2025-07-1191330
2025-07-126330
2025-07-136397
2025-07-147668
2025-07-159463
2025-07-1681153
2025-07-179651
2025-07-1813723
2025-07-198945
2025-07-209899
2025-07-21121257
2025-07-22121174
2025-07-2310994
2025-07-24131226
2025-07-25121046
2025-07-268835
2025-07-276755
2025-07-289786
2025-07-295327
2025-07-30152196
2025-07-31121534
2025-08-013182
2025-08-02101091
2025-08-038667
2025-08-0411674
2025-08-05101022
2025-08-069651
2025-08-07171702
2025-08-084404
2025-08-094655
2025-08-108763
2025-08-11121034
2025-08-12131862
2025-08-1313982
2025-08-148996
2025-08-15111129
2025-08-167558
2025-08-176609
2025-08-185445
2025-08-199933
2025-08-2011625
2025-08-21121290
2025-08-22131019
2025-08-2310769
2025-08-245572
2025-08-256514
2025-08-26121197
2025-08-275414
2025-08-287432
2025-08-295574
2025-08-304345
2025-08-313689
2025-09-019924.1
2025-09-026878.8
2025-09-03131533.8
2025-09-046617.1
2025-09-0511808.6
2025-09-066542
2025-09-0710542.4
2025-09-089790.5
2025-09-09101255.5
2025-09-1091012.7
2025-09-117825.4
2025-09-123240.2
2025-09-138636.6
2025-09-143297.4
2025-09-155223.5
2025-09-16121137
2025-09-17141031.7
2025-09-186278.1
2025-09-196242.6
2025-09-209954.3
2025-09-216522.3
2025-09-2211704.9
2025-09-234289
2025-09-248938.9
2025-09-258505.6
2025-09-264675.8
2025-09-278656.1
2025-09-2810443.9
2025-09-29141559.6
2025-09-3010917.1
2025-10-018708
2025-10-028803
2025-10-037802
2025-10-046571
2025-10-057869
2025-10-0610804
2025-10-0711821
2025-10-087321
2025-10-097899
2025-10-106634
2025-10-114384
2025-10-1281097
2025-10-134263
2025-10-14111166
2025-10-15141068
2025-10-16131706
2025-10-178676
2025-10-188642
2025-10-1911550
2025-10-209684
2025-10-21212672
2025-10-22162033
2025-10-238588
2025-10-243322
2025-10-2571321
2025-10-26131646
2025-10-27202774
2025-10-28182115
2025-10-29181964
2025-10-30222106
2025-10-31181505
2025-11-0111918
2025-11-029972
2025-11-03222067
2025-11-04242329
2025-11-05231987
2025-11-06222850
2025-11-07283035
2025-11-08251758
2025-11-0911866
2025-11-10232475
2025-11-11111148
2025-11-12172134
2025-11-13232416
2025-11-14191585
2025-11-15141302
2025-11-16192840
2025-11-17181265
2025-11-18201422
2025-11-19212210
2025-11-20202136
2025-11-21111263
2025-11-22141691
2025-11-23141062
2025-11-24212421
2025-11-25232376
2025-11-26181839
2025-11-27101047
2025-11-28432677
2025-11-29191611.75
2025-11-30242642.75
2025-12-01413382.25
2025-12-02292079.85
2025-12-03303080.4
2025-12-04191588.2
2025-12-05212261.85
2025-12-06162397.7
2025-12-07281707.85
2025-12-08413528.3
2025-12-09394254.7
2025-12-10373120.05
2025-12-11313380.55
2025-12-12322448.35
2025-12-13262218.05
2025-12-14344141.8
2025-12-15525123.95
2025-12-16464213.2
2025-12-17404558.8
2025-12-18423518.15
2025-12-19494819
2025-12-20384829.55
2025-12-21312715.3
2025-12-22533985.95
2025-12-23596124.25
2025-12-24676801.15
2025-12-25373703
2025-12-26363983
2025-12-27192117
2025-12-28343519
2025-12-29252244
2025-12-30302752
2025-12-31182347
2026-01-01181722.7
2026-01-02151439.2
2026-01-03141606.5
2026-01-04122114.9
2026-01-05161266.1
2026-01-0691084.2
2026-01-079924.2
2026-01-0812730.5
2026-01-09121432.2
2026-01-10111041.5
2026-01-1171015.8
2026-01-12131188.3
2026-01-13111287.9
2026-01-14111026.7
2026-01-156412.1
2026-01-166412
2026-01-175370
2026-01-185464
2026-01-19131374
2026-01-207649
2026-01-216511
2026-01-22111320
2026-01-232181
2026-01-246424
2026-01-256542
2026-01-2610819
2026-01-276488
2026-01-28101106
2026-01-299726
2026-01-309939
2026-01-315433
2026-02-017813
2026-02-027909
2026-02-039369
2026-02-044282
2026-02-0591418
2026-02-0681156
2026-02-075442
2026-02-085383
2026-02-096643
2026-02-109820
2026-02-1111931
2026-02-124442
2026-02-136726
2026-02-143118
2026-02-157382
2026-02-163258
2026-02-179989
2026-02-185734
2026-02-19111649
2026-02-2081092
2026-02-214352
2026-02-227815
2026-02-23131341
2026-02-24162367
2026-02-25201414
2026-02-26131469
2026-02-27202301
2026-02-28192812
2026-03-01344678
2026-03-02302663
2026-03-03404140
2026-03-04496224
2026-03-05333691
2026-03-06434367
2026-03-07314131
2026-03-08374242
2026-03-09535398
2026-03-10575685
2026-03-11504815
2026-03-12465013
2026-03-13445176
2026-03-14443907
2026-03-15474148.8
2026-03-16625616.5
2026-03-17544786.2
2026-03-18675118.9
2026-03-19585658.4
2026-03-20453924.3
2026-03-21474460.6
2026-03-22434363.3
2026-03-23566025.55
2026-03-24464208.4
2026-03-25475068.25
2026-03-26535057.5
2026-03-27595930.55
2026-03-28464616.55
2026-03-29454561.85
2026-03-30655634.1
2026-03-31655303.4
2026-04-01595624.65
2026-04-02505064.9
2026-04-03667375
2026-04-04445227.6
2026-04-05546732.2
2026-04-06636768.2
2026-04-07656322.75
2026-04-08715875.6
2026-04-09524940.65
2026-04-10716817.9
2026-04-11423915.3
2026-04-12535816.55
2026-04-13554761.9
2026-04-14767574.8
2026-04-15525505.1
2026-04-16565305.95
2026-04-17504980.75
2026-04-18402924.75
2026-04-19454517.25
2026-04-20768192.3
2026-04-21666011.35
2026-04-22606372.35
2026-04-23625214.55
2026-04-24566560.5
2026-04-25474322.5
2026-04-26525237.15
2026-04-27798447.25
2026-04-28606277.2
2026-04-29695777.15
2026-04-30667652.45
2026-05-01676557.8
2026-05-02474381.8
2026-05-03524537.8
2026-05-04747309.2
2026-05-05877188.4
2026-05-06988472.8
2026-05-071029754.4
2026-05-08726280.2
2026-05-09738169
2026-05-10787998.4
2026-05-11645747.8
2026-05-12566070.2
2026-05-13544775.6
2026-05-14474494.6
2026-05-15433313
2026-05-16333733
2026-05-17353507
2026-05-18515097
2026-05-19514824
2026-05-20646857
2026-05-21485655
2026-05-22383962
2026-05-23373689
2026-05-24414227
2026-05-25384513
2026-05-26545826
2026-05-27494527
2026-05-28525486
2026-05-29383855
2026-05-30364553
2026-05-31414308
2026-06-01373963
2026-06-02405146
2026-06-03283533
2026-06-04212026
2026-06-05353623
2026-06-06182931
2026-06-07191661
2026-06-08313617
2026-06-09221867
2026-06-10182596
2026-06-11222603
2026-06-12303639
2026-06-1314944
2026-06-14151648
2026-06-15181797
2026-06-16303301
2026-06-17202255
2026-06-18272606
2026-06-1911791
2026-06-20182212
2026-06-21273008
2026-06-22221895
2026-06-23363572
2026-06-24221973
2026-06-25202463
2026-06-26303300
2026-06-27183065
2026-06-28121020
2026-06-29292858
2026-06-30212317
2026-07-01262233
2026-07-02242742
2026-07-03182172
2026-07-04101078
2026-07-05192666
2026-07-06272866
2026-07-07363924
2026-07-08242828
2026-07-09243469
2026-07-10374115
2026-07-11202084
2026-07-12302647
2026-07-13162724
2026-07-14313798
2026-07-15243363
2026-07-16353738
2026-07-17192073
2026-07-18274296
2026-07-19181904
2026-07-20242173
2026-07-21293224
2026-07-22363305
2026-07-23251884
2026-07-24313166
2026-07-25151507
2026-07-26232431
2026-07-27252026
2026-07-28333810
2026-07-29243494
2026-07-30252960
2026-07-31262738
2026-08-01222358
2026-08-02181683
2026-08-03283012
2026-08-04271942
2026-08-05212784
2026-08-06182052
2026-08-07232111
2026-08-08201776
2026-08-09131080
2026-08-10232539
2026-08-11222899
2026-08-12252538
2026-08-13212060
2026-08-14162338
2026-08-15131330
2026-08-1691303
2026-08-17274219
2026-08-18221906
2026-08-19212531
2026-08-20141585
2026-08-21232040
2026-08-22141085
2026-08-23132207
2026-08-24202060
2026-08-25201989
2026-08-26131381
2026-08-27221966
2026-08-28171480
2026-08-29171534
2026-08-30161706
2026-08-31121313
2026-09-01212479.9
2026-09-02161943.2
2026-09-03242515.9
2026-09-04182152.4
2026-09-05161514.5
2026-09-06161413.1
2026-09-07161158.1
2026-09-08211572.6
2026-09-09243040.6
2026-09-10212925.6
2026-09-11141516.5
2026-09-12121163.1
2026-09-137383.3
2026-09-14261788.8
2026-09-15233239.6
2026-09-16182095.7
2026-09-1710916.9
2026-09-18273123.8
2026-09-19121297.1
2026-09-20172291.7
2026-09-21182229.3
2026-09-22181919.8
2026-09-23171412
2026-09-24242345.8
2026-09-25282656.7
2026-09-26161936.8
2026-09-2712762.2
2026-09-28272904.6
2026-09-29252632.4
2026-09-30192361.5
2026-10-01232517
2026-10-02172061
2026-10-03141394
2026-10-0411843
2026-10-05202173
2026-10-06272762
2026-10-07323755
2026-10-08171559
2026-10-09202527
2026-10-10151662
2026-10-11151557
2026-10-12181867
2026-10-13171341
2026-10-14272992
2026-10-1513788
2026-10-16212080
2026-10-17192608
2026-10-18121449
2026-10-19172426
2026-10-20222387
2026-10-21191991
2026-10-22181830
2026-10-23272734
2026-10-248724
2026-10-256312
2026-10-26222553
2026-10-27292355
2026-10-28273989
2026-10-29251780
2026-10-30172061
2026-10-31141390
2026-11-01191495
2026-11-02272943
2026-11-03293451
2026-11-04162146
2026-11-054207

holds on the current window

Weekly sales trend

WITH weekly AS (
  SELECT date(ordered_at, 'weekday 0', '-6 days') AS week_start,
         COUNT(*) AS orders, SUM(total_usd) AS revenue
  FROM orders GROUP BY 1
)
SELECT week_start, orders, ROUND(revenue) AS revenue,
       ROUND(AVG(revenue) OVER (ORDER BY week_start ROWS BETWEEN 3 PRECEDING AND CURRENT ROW)) AS revenue_4w_avg
FROM weekly
ORDER BY week_start;
2023-06-052026-11-02
View data table
week_startordersrevenuerevenue_4w_avg
2023-06-051288288
2023-06-12292190
2023-06-269533304
2023-07-033119258
2023-07-109564327
2023-07-1712990552
2023-07-24151269736
2023-07-313418810
2023-08-071615041045
2023-08-1411758987
2023-08-218342756
2023-08-28131095925
2023-09-04181626955
2023-09-111410921039
2023-09-18147581143
2023-09-251913631210
2023-10-021312051104
2023-10-091812771151
2023-10-161511821257
2023-10-231915621307
2023-10-302722211561
2023-11-062820851763
2023-11-133135032343
2023-11-204533292784
2023-11-275344243335
2023-12-046541003839
2023-12-116655644354
2023-12-188161075049
2023-12-254532124746
2024-01-014533704563
2024-01-083932503985
2024-01-153019942957
2024-01-222424812774
2024-01-292726782601
2024-02-051411052065
2024-02-122618562030
2024-02-192317521848
2024-02-265243482265
2024-03-04145125955138
2024-03-1110797987123
2024-03-18141114659551
2024-03-251571209211487
2024-04-01120900410590
2024-04-081431048610762
2024-04-151471201210899
2024-04-221571175510815
2024-04-291871542912421
2024-05-062511899114547
2024-05-131551251514673
2024-05-201471564015644
2024-05-271391262314942
2024-06-0398820612246
2024-06-1097788011087
2024-06-179578509140
2024-06-248071327767
2024-07-018871647507
2024-07-089984337645
2024-07-1510687417868
2024-07-228269147813
2024-07-298574387882
2024-08-056346426934
2024-08-128372826569
2024-08-199180516853
2024-08-267664736612
2024-09-026255656843
2024-09-097358316480
2024-09-166866886139
2024-09-235853815866
2024-09-307368366184
2024-10-075852736044
2024-10-145343685465
2024-10-215141435155
2024-10-286664195051
2024-11-047058105185
2024-11-117176366002
2024-11-188265566605
2024-11-259186127153
2024-12-028274487563
2024-12-096754657020
2024-12-169571407166
2024-12-237980277020
2024-12-303529775902
2025-01-062017384970
2025-01-132220173690
2025-01-201112912006
2025-01-272015961660
2025-02-031511221506
2025-02-101310931276
2025-02-17169331186
2025-02-242719521275
2025-03-038074112847
2025-03-108661404109
2025-03-17105101636417
2025-03-24133116608844
2025-03-311701593910976
2025-04-071361302212696
2025-04-141511424513717
2025-04-211461209013824
2025-04-281411164312750
2025-05-052201948014365
2025-05-121871841115406
2025-05-191861834016969
2025-05-261221244817170
2025-06-02100990514776
2025-06-0955625711738
2025-06-166061078679
2025-06-236364927190
2025-06-305745215844
2025-07-074947125458
2025-07-146355025307
2025-07-217372875506
2025-07-286267836071
2025-08-046358716361
2025-08-117071706778
2025-08-186556536369
2025-08-254241655715
2025-09-016158475709
2025-09-084950585181
2025-09-155843904865
2025-09-225342144877
2025-09-296062304973
2025-10-065349604948
2025-10-136960715369
2025-10-207792666632
2025-10-27116123548163
2025-11-031551489210646
2025-11-101261390012603
2025-11-171181104913049
2025-11-241581461513614
2025-12-011841649814015
2025-12-082402309216313
2025-12-152982977820996
2025-12-223053023324900
2025-12-291321422624332
2026-01-0576749520433
2026-01-1257516114279
2026-01-195150017971
2026-01-265653245745
2026-02-024749595111
2026-02-094640624837
2026-02-164758895059
2026-02-23135163827823
2026-03-022632945813948
2026-03-093413414321468
2026-03-163763392828478
2026-03-233523546933249
2026-03-304034096236125
2026-04-064174045737704
2026-04-133743557138114
2026-04-204194191139725
2026-04-274404363140392
2026-05-045845517244071
2026-05-113323164143089
2026-05-183303431141189
2026-05-253083306838548
2026-06-011982288330476
2026-06-081521691426794
2026-06-151511597022209
2026-06-221601728818264
2026-06-291471606616560
2026-07-061982193317814
2026-07-131702189619296
2026-07-201831769019396
2026-07-271731906920147
2026-08-031501475718353
2026-08-101291500716631
2026-08-171341557316102
2026-08-241251211614363
2026-08-311231333214007
2026-09-071151176013195
2026-09-141331475412990
2026-09-211331326313277
2026-09-281361471413622
2026-10-051461599514681
2026-10-121271312514274
2026-10-191171240414059
2026-10-261531562314287
2026-11-0276874712475

holds on the current window

Testing a forecasting job, a dashboard, or a data pipeline needs a sales series long enough to have seasons and honest enough to have bad weeks. Synthetic time series tools give you a sine wave plus noise. Overwater’s daily sales are the sum of individual orders from individual customers, so weekends are lower because fewer people shop, spring is higher because plants sell in spring, and the level wanders between years because the business had good and bad quarters. The whole thing is a pure function of one seed. Regenerate it and every order id and timestamp comes back the same, so a test that passed yesterday is testing the same data today.

What you should see

Roughly a thousand daily rows. Saturdays and Sundays run below the weekdays around them. Every March to May runs far above the winter before it, and the weekly average ends each year at a different level. Run the download again next month and the historical rows have not changed. Only new days have been appended.

Run it yourself

More on Overwater