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 422 days 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-042025-07-16
View data table
dayordersrevenue
2023-06-042263
2023-06-05192
2023-06-06113
2023-06-11138
2023-06-131176
2023-06-15368
2023-06-18117
2023-06-19115
2023-06-23117
2023-06-272349
2023-06-286653
2023-06-29135
2023-06-303198
2023-07-01156
2023-07-02155
2023-07-03187
2023-07-05271
2023-07-06244
2023-07-07185
2023-07-081224
2023-07-114243
2023-07-122248
2023-07-134268
2023-07-14146
2023-07-152126
2023-07-161177
2023-07-173183
2023-07-181101
2023-07-19115
2023-07-213296
2023-07-22113
2023-07-231259
2023-07-24122
2023-07-263348
2023-07-27172
2023-07-283121
2023-07-292180
2023-07-31295
2023-08-01191
2023-08-022360
2023-08-032327
2023-08-042506
2023-08-053149
2023-08-072265
2023-08-082217
2023-08-095757
2023-08-105536
2023-08-112205
2023-08-125739
2023-08-131272
2023-08-143126
2023-08-16154
2023-08-172274
2023-08-181219
2023-08-191130
2023-08-201199
2023-08-222147
2023-08-23186
2023-08-241250
2023-08-25171
2023-08-262394
2023-08-282394
2023-08-29116
2023-08-304437
2023-08-312355
2023-09-01126.1
2023-09-023375
2023-09-03293.6
2023-09-054502
2023-09-06114.4
2023-09-075704
2023-09-092152
2023-09-121237.6
2023-09-132223.2
2023-09-142442
2023-09-152117
2023-09-162308.2
2023-09-181196
2023-09-206506.3
2023-09-211216
2023-09-223107.5
2023-09-232240
2023-09-241274
2023-09-251147
2023-09-265611.8
2023-09-273259.5
2023-09-292143.1
2023-09-30156
2023-10-012446
2023-10-02117
2023-10-032107
2023-10-044361
2023-10-063323
2023-10-082364
2023-10-09151
2023-10-103332
2023-10-113121
2023-10-124160
2023-10-131192
2023-10-142350
2023-10-153553
2023-10-16289
2023-10-172242
2023-10-184411
2023-10-191176
2023-10-206770
2023-10-212220
2023-10-22116
2023-10-237599
2023-10-242330
2023-10-253105
2023-10-263243
2023-10-273453
2023-10-28129
2023-10-294324
2023-10-305551
2023-10-314193
2023-11-016851
2023-11-02101126
2023-11-039777
2023-11-043336
2023-11-052298
2023-11-065557
2023-11-076444
2023-11-086925
2023-11-093421
2023-11-105523
2023-11-112244
2023-11-123183
2023-11-133592
2023-11-145621
2023-11-157502
2023-11-167685
2023-11-1781220
2023-11-1871186
2023-11-197786
2023-11-203519
2023-11-217895
2023-11-228758
2023-11-2361060
2023-11-24141461
2023-11-255566.5
2023-11-269793.25
2023-11-274506
2023-11-28171989.5
2023-11-2910692
2023-11-30131218
2023-12-019986.5
2023-12-029865.9
2023-12-038768.45
2023-12-04121900.5
2023-12-056675.85
2023-12-06121125.15
2023-12-0710832.9
2023-12-085438.55
2023-12-097735.25
2023-12-1091047.85
2023-12-119736.05
2023-12-1291091.15
2023-12-134324.8
2023-12-14121461.15
2023-12-15111960.9
2023-12-16101135.9
2023-12-17111428.6
2023-12-185653.5
2023-12-198936.85
2023-12-20101020.7
2023-12-21151312.85
2023-12-226433.15
2023-12-233205.45
2023-12-244565
2023-12-25111150
2023-12-267432
2023-12-27121482
2023-12-2871211
2023-12-29111182
2023-12-305437
2023-12-313342
2024-01-01186
2024-01-02142.3
2024-01-044211
2024-01-055225.3
2024-01-0681086.9
2024-01-073235.2
2024-01-082447
2024-01-092234.1
2024-01-10146
2024-01-112113.1
2024-01-131170
2024-01-141243
2024-01-152199
2024-01-164349
2024-01-172269
2024-01-18113
2024-01-195453
2024-01-20175
2024-01-222235
2024-01-233121
2024-01-24144
2024-01-252223
2024-01-263292
2024-01-274447
2024-01-281116
2024-01-291140
2024-01-30138
2024-01-316811
2024-02-012318
2024-02-022262
2024-02-031138
2024-02-053245
2024-02-061104
2024-02-073405
2024-02-084458
2024-02-094453
2024-02-111245
2024-02-122308
2024-02-13295
2024-02-144222
2024-02-153487
2024-02-163507
2024-02-17265
2024-02-18264
2024-02-195876
2024-02-202195
2024-02-212126
2024-02-222131
2024-02-233487
2024-02-241165
2024-02-252364
2024-02-265444
2024-02-27149
2024-02-285266
2024-02-29153
2024-03-01151632
2024-03-02131372
2024-03-03111295
2024-03-04141575
2024-03-05182527
2024-03-06171719
2024-03-076766
2024-03-08161512
2024-03-097297
2024-03-10101211
2024-03-11121262
2024-03-12232664
2024-03-13161579
2024-03-14141087
2024-03-15131162
2024-03-169803
2024-03-177551
2024-03-18172167
2024-03-19121759
2024-03-20172580
2024-03-216817
2024-03-22172045
2024-03-23111412
2024-03-247874
2024-03-25151934
2024-03-26161507
2024-03-27162315
2024-03-28131594
2024-03-2981019
2024-03-30151883
2024-03-31131808
2024-04-01121618
2024-04-02192471
2024-04-03262663
2024-04-04151560
2024-04-05191301
2024-04-06151671
2024-04-07161924
2024-04-08191849
2024-04-09111289
2024-04-10182635
2024-04-11191778
2024-04-12222830
2024-04-13162101
2024-04-148966
2024-04-15232466
2024-04-16222961
2024-04-17222229
2024-04-18161688
2024-04-19161757
2024-04-20213088
2024-04-21242841
2024-04-22263049
2024-04-23222567
2024-04-24152066
2024-04-25201683
2024-04-26152310
2024-04-27151531
2024-04-28141713
2024-04-29192070
2024-04-30201931
2024-05-01212400
2024-05-02222562
2024-05-03212505
2024-05-04161524
2024-05-05172155
2024-05-06161999
2024-05-07253205
2024-05-08282981
2024-05-09192184
2024-05-10162012
2024-05-11182076
2024-05-1211963
2024-05-1311836
2024-05-14161818
2024-05-15141325
2024-05-16141165
2024-05-17201614
2024-05-18121032
2024-05-19121030
2024-05-20211981
2024-05-21282835
2024-05-22182194
2024-05-23201847
2024-05-24232890
2024-05-25182419
2024-05-26161197
2024-05-27211744
2024-05-28242290
2024-05-29282780
2024-05-30303115
2024-05-31293077
2024-06-01111264
2024-06-0281139
2024-06-039867
2024-06-04121265
2024-06-0571022
2024-06-0691000
2024-06-07121046
2024-06-089730
2024-06-097698
2024-06-10151195
2024-06-112130
2024-06-12121404
2024-06-1391116
2024-06-14121103
2024-06-157418
2024-06-16121194
2024-06-178954
2024-06-18182036
2024-06-199938
2024-06-205935
2024-06-219655
2024-06-228766
2024-06-235690
2024-06-245692
2024-06-256758
2024-06-263543
2024-06-275487
2024-06-283500
2024-06-29111613
2024-06-304259
2024-07-01131306
2024-07-024306
2024-07-034275
2024-07-043294
2024-07-052208
2024-07-06275
2024-07-073436
2024-07-088891
2024-07-09111350
2024-07-107639
2024-07-1191190
2024-07-127637
2024-07-133483
2024-07-145175
2024-07-155763
2024-07-165897
2024-07-172169
2024-07-182119
2024-07-195688
2024-07-205695
2024-07-217560
2024-07-225668
2024-07-235541
2024-07-245733
2024-07-255759
2024-07-262272
2024-07-276921
2024-07-282231
2024-07-293423
2024-07-30268
2024-07-316594
2024-08-01101066
2024-08-027725
2024-08-032246
2024-08-044644
2024-08-055356
2024-08-068909
2024-08-074417
2024-08-083232
2024-08-098880
2024-08-10128
2024-08-11177
2024-08-126689
2024-08-136668
2024-08-147673
2024-08-153474
2024-08-165472
2024-08-178997
2024-08-182310
2024-08-192380
2024-08-219740
2024-08-2281375
2024-08-23144
2024-08-243157
2024-08-254333
2024-08-264791
2024-08-27121516
2024-08-286485
2024-08-295854
2024-08-306588
2024-08-313382
2024-09-014418
2024-09-025327
2024-09-036484
2024-09-0451045
2024-09-05121313
2024-09-065523
2024-09-076810
2024-09-08131454
2024-09-099814
2024-09-103396
2024-09-1181060
2024-09-123221
2024-09-1310852
2024-09-1481101
2024-09-157494
2024-09-1611916
2024-09-179948
2024-09-183571
2024-09-1961043
2024-09-2091389
2024-09-213429
2024-09-2271285
2024-09-238488
2024-09-24121506
2024-09-257982
2024-09-2610840
2024-09-279744
2024-09-282209
2024-09-295307
2024-09-3081344
2024-10-01121556
2024-10-027544
2024-10-03172066
2024-10-04131308
2024-10-058997
2024-10-0671067
2024-10-078927
2024-10-088823
2024-10-09192791
2024-10-10101048
2024-10-11121330
2024-10-126934
2024-10-135470
2024-10-148857
2024-10-157708
2024-10-168732
2024-10-175741
2024-10-1881085
2024-10-196764
2024-10-203388
2024-10-2181026
2024-10-22121127
2024-10-236681
2024-10-246855
2024-10-256708
2024-10-262231
2024-10-272118
2024-10-28121482
2024-10-296591
2024-10-306513
2024-10-31131023
2024-11-01151495
2024-11-027815
2024-11-03121386
2024-11-04151466
2024-11-05202743
2024-11-06151867
2024-11-07141405
2024-11-08172419
2024-11-09101208
2024-11-1091604
2024-11-11121491
2024-11-12151911
2024-11-13182630
2024-11-14192215
2024-11-15213038
2024-11-16161822
2024-11-17121203
2024-11-18242687
2024-11-19253873
2024-11-20343622
2024-11-21303431
2024-11-22313557
2024-11-23283467
2024-11-24273696
2024-11-25304108
2024-11-26354526
2024-11-27395279
2024-11-28313154
2024-11-29313687
2024-11-30303120
2024-12-01283371
2024-12-02393788
2024-12-03292977
2024-12-04464898
2024-12-05435549
2024-12-06465089
2024-12-07273015
2024-12-08323945
2024-12-09303136
2024-12-10455176
2024-12-11535571
2024-12-12597174
2024-12-13495324
2024-12-14313914
2024-12-15374690
2024-12-16596944
2024-12-17474955
2024-12-18516583
2024-12-19415476
2024-12-20465930
2024-12-21323128
2024-12-22342753
2024-12-23354582
2024-12-24363994
2024-12-25455747
2024-12-26465856
2024-12-27414483
2024-12-28242476
2024-12-29262546
2024-12-30303936
2024-12-31293448
2025-01-01101675
2025-01-0291370
2025-01-03191788
2025-01-04122007
2025-01-05131470
2025-01-067749
2025-01-07152317
2025-01-08131530
2025-01-09121537
2025-01-10192408
2025-01-11111674
2025-01-125450
2025-01-13141408
2025-01-146870
2025-01-15101262
2025-01-169752
2025-01-17131408
2025-01-1891016
2025-01-19101244
2025-01-2010760
2025-01-21131396
2025-01-22111084
2025-01-23141293
2025-01-24111921
2025-01-25101205
2025-01-26122304
2025-01-27111095
2025-01-28151851
2025-01-29151939
2025-01-30252766
2025-01-31262991
2025-02-01101323
2025-02-02141118
2025-02-03171792
2025-02-04111038
2025-02-058667
2025-02-06131639
2025-02-07111564
2025-02-08111079
2025-02-09151551
2025-02-10151232
2025-02-11111042
2025-02-12121608
2025-02-13101368
2025-02-14212423
2025-02-15111267
2025-02-1691142
2025-02-17141856
2025-02-18182178
2025-02-19182814
2025-02-20151580
2025-02-21131497
2025-02-2291154
2025-02-23121498
2025-02-24171858
2025-02-25181954
2025-02-26162165
2025-02-27212181
2025-02-28111928
2025-03-01507257
2025-03-02698956
2025-03-039110799
2025-03-0410113188
2025-03-0511814864
2025-03-0611715143
2025-03-0711616186
2025-03-088810261
2025-03-097910928
2025-03-109711889
2025-03-1110814259
2025-03-1211313662
2025-03-1311214460
2025-03-1411115783
2025-03-15729124
2025-03-16688431
2025-03-179812887
2025-03-1810813131
2025-03-1910612783
2025-03-209812017
2025-03-2112215939
2025-03-22839458
2025-03-23557242
2025-03-2410211256
2025-03-2511013653
2025-03-268910855
2025-03-2710412961
2025-03-288911738
2025-03-29739088
2025-03-30709500
2025-03-3111114428
2025-04-019713289
2025-04-0211714961
2025-04-0311113340
2025-04-0410414591
2025-04-059911858
2025-04-0610011931
2025-04-079414191
2025-04-0811114845
2025-04-0911014018
2025-04-1011515147
2025-04-1110914449
2025-04-127810392
2025-04-13728408
2025-04-1411114540
2025-04-1512116754
2025-04-1612115761
2025-04-1712015532
2025-04-1813016273
2025-04-198110401
2025-04-20799333
2025-04-219412423
2025-04-2212415425
2025-04-2310815137
2025-04-2412515379
2025-04-2515320401
2025-04-268311732
2025-04-279411285
2025-04-2810612247
2025-04-2911616357
2025-04-3011914887
2025-05-0111715021
2025-05-0212315284
2025-05-039211162
2025-05-048410417
2025-05-0511515010
2025-05-0611915511
2025-05-0712114897
2025-05-0812115296
2025-05-0911214471
2025-05-108813253
2025-05-11658151
2025-05-1210112508
2025-05-1311714601
2025-05-1411415259
2025-05-1512015346
2025-05-169712206
2025-05-178711831
2025-05-18739857
2025-05-199712816
2025-05-2011115772
2025-05-2111315850
2025-05-2212716450
2025-05-2311213748
2025-05-247811451
2025-05-25669298
2025-05-268310878
2025-05-2713118437
2025-05-2811614980
2025-05-2912017092
2025-05-3013517406
2025-05-317910189
2025-06-01354244
2025-06-02475860
2025-06-03496844
2025-06-04435292
2025-06-05405257
2025-06-06394552
2025-06-07343892
2025-06-08385930
2025-06-09445321
2025-06-10294019
2025-06-11355107
2025-06-12487742
2025-06-13476144
2025-06-14466128
2025-06-15334237
2025-06-16395872
2025-06-17396097
2025-06-18536577
2025-06-19466066
2025-06-20324031
2025-06-21273834
2025-06-22396057
2025-06-23507051
2025-06-24548099
2025-06-25436128
2025-06-26546379
2025-06-27343873
2025-06-28303845
2025-06-29354339
2025-06-30313848
2025-07-01537452
2025-07-02345423
2025-07-03354557
2025-07-04416071
2025-07-05252757
2025-07-06334317
2025-07-07363490
2025-07-08354395
2025-07-09395070
2025-07-10445189
2025-07-11364044
2025-07-12294357
2025-07-13324382
2025-07-14395022
2025-07-15415526
2025-07-16425736

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-05-292025-07-14
View data table
week_startordersrevenuerevenue_4w_avg
2023-05-292263263
2023-06-053143203
2023-06-125261222
2023-06-19232175
2023-06-26141346446
2023-07-037511538
2023-07-10141108749
2023-07-1710867958
2023-07-2410743807
2023-07-311215281062
2023-08-072229911532
2023-08-14910021566
2023-08-2179481617
2023-08-281516971659
2023-09-041213721255
2023-09-11913281336
2023-09-181415401484
2023-09-251416631476
2023-10-021211721426
2023-10-091717591534
2023-10-161819241630
2023-10-232320831735
2023-10-303941322475
2023-11-063032972859
2023-11-134455923776
2023-11-205260534768
2023-11-277070265492
2023-12-046167566357
2023-12-116681396993
2023-12-185151286762
2023-12-255662366565
2024-01-012218875347
2024-01-08912533626
2024-01-151513582683
2024-01-221614781494
2024-01-291317071449
2024-02-051619101613
2024-02-121817481711
2024-02-191723441927
2024-02-265151112778
2024-03-048896074703
2024-03-119491086543
2024-03-1887116548870
2024-03-25961206010607
2024-04-011221320811508
2024-04-081131344812593
2024-04-151441703013937
2024-04-221271491914651
2024-04-291361514715136
2024-05-061331542015629
2024-05-1399882013577
2024-05-201441536313688
2024-05-271511540913753
2024-06-0365662811555
2024-06-1069656010990
2024-06-176269748893
2024-06-243748526254
2024-07-013129005322
2024-07-085053655023
2024-07-153138914252
2024-07-223041254070
2024-07-293437664287
2024-08-053028993670
2024-08-123742833768
2024-08-192730293494
2024-08-264050343811
2024-09-025259564576
2024-09-094849384739
2024-09-164865815627
2024-09-235350765638
2024-09-307288826369
2024-10-076883237216
2024-10-144552756889
2024-10-214247466807
2024-10-287173056412
2024-11-04100127127510
2024-11-11113143109768
2024-11-181992433314665
2024-11-252242724519650
2024-12-022622926123787
2024-12-093043498528956
2024-12-163103576931815
2024-12-232532968432425
2024-12-301221569429033
2025-01-06821066522953
2025-01-1371796016001
2025-01-2081996311071
2025-01-271161308310418
2025-02-0386933010084
2025-02-10891008210615
2025-02-17991257711268
2025-02-242022629914572
2025-03-037109136935082
2025-03-106818760854463
2025-03-176708345772183
2025-03-246377905185371
2025-03-317399439886129
2025-04-076899145087089
2025-04-147639859490873
2025-04-2178110178296556
2025-04-287579537596800
2025-05-057419658998085
2025-05-127099160896339
2025-05-197049538594739
2025-05-266999322694202
2025-06-022903762779462
2025-06-092823869866234
2025-06-162753853452021
2025-06-233003971438643
2025-06-302523442537843
2025-07-072513092735900
2025-07-141221628430338

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