Prerequisites

1. SQLite3

2. jq

3. sh, wc, uniq, sort.

4. and a CSV file columned by timestamp,price,volume (named as trades.csv).

Procedures And Scripts

1. 00-download-csv.sh
2. 01-verify-timestamps.sh
3. 02-create-table-and-import-csv.sh
4. 03-mimx-timestamp.sh
5. 04-verify-counts.sh
6. 05-window-by-timestamp.sh
7. 06-all-stat.sh