Athena(Presto)でSUM()やAVG()といった集計関数にOVERを付けてWindow集計を行う。 Window Functions — Presto 0.247 Documentation 次のテストデータを使う。 $ cat test-data.csv {"date":"2021-02-01","user":1,"value":10} {"date":"2021-02-01","user":2,"value":20} {"date":"2021-02-01","user":3,"value":30} {"date":"2021-02-01","user":1,"value":40} {"date":"2021-02-01","user":2,"value":50} {"date":"2021-02-01","user":3,"value":60} {"date":"2021
![Athena(Presto)でWindow関数を用いた集計を行う - sambaiz-net](https://cdn-ak-scissors.b.st-hatena.com/image/square/a9e6dfd6b8e1d1d20651a18da5f07e08d04e3d5e/height=288;version=1;width=512/https%3A%2F%2Fwww.sambaiz.net%2Fimages%2Fmy_l.jpg)