PREVIEW / futures_1min / 2019-01-02
file: by_date/futures_1min/2019/2019-01-02.parquet size: 852 KB rows: 67,418
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2019-01-02 00:00:00 | ES | Futures | 2699.82 | 2700.64 | 2699.55 | 2700.37 | 158.0 |
| 2019-01-02 00:01:00 | ES | Futures | 2700.37 | 2700.91 | 2700.37 | 2700.91 | 75.0 |
| 2019-01-02 00:02:00 | ES | Futures | 2700.64 | 2700.91 | 2699.55 | 2699.82 | 131.0 |
| 2019-01-02 00:03:00 | ES | Futures | 2699.82 | 2701.18 | 2699.82 | 2700.91 | 93.0 |
| 2019-01-02 00:04:00 | ES | Futures | 2700.91 | 2701.72 | 2700.91 | 2701.18 | 128.0 |
| 2019-01-02 00:05:00 | ES | Futures | 2701.18 | 2701.99 | 2700.64 | 2700.64 | 141.0 |
| 2019-01-02 00:06:00 | ES | Futures | 2700.64 | 2700.91 | 2699.82 | 2700.91 | 239.0 |
| 2019-01-02 00:07:00 | ES | Futures | 2700.64 | 2702.54 | 2700.64 | 2701.45 | 356.0 |
| 2019-01-02 00:08:00 | ES | Futures | 2701.45 | 2701.99 | 2701.18 | 2701.18 | 116.0 |
| 2019-01-02 00:09:00 | ES | Futures | 2701.45 | 2701.45 | 2700.91 | 2700.91 | 34.0 |
| 2019-01-02 00:10:00 | ES | Futures | 2700.91 | 2701.18 | 2700.37 | 2700.37 | 67.0 |
| 2019-01-02 00:11:00 | ES | Futures | 2700.64 | 2701.18 | 2700.64 | 2700.91 | 78.0 |
| 2019-01-02 00:12:00 | ES | Futures | 2701.18 | 2701.18 | 2700.91 | 2701.18 | 32.0 |
| 2019-01-02 00:13:00 | ES | Futures | 2701.18 | 2701.45 | 2699.82 | 2700.37 | 120.0 |
| 2019-01-02 00:14:00 | ES | Futures | 2700.09 | 2700.64 | 2699.82 | 2700.37 | 75.0 |
| 2019-01-02 00:15:00 | ES | Futures | 2700.37 | 2701.18 | 2700.37 | 2700.64 | 77.0 |
| 2019-01-02 00:16:00 | ES | Futures | 2700.37 | 2700.91 | 2700.09 | 2700.37 | 47.0 |
| 2019-01-02 00:17:00 | ES | Futures | 2700.09 | 2700.09 | 2697.38 | 2698.19 | 621.0 |
| 2019-01-02 00:18:00 | ES | Futures | 2698.19 | 2698.74 | 2697.65 | 2697.92 | 203.0 |
| 2019-01-02 00:19:00 | ES | Futures | 2697.92 | 2700.37 | 2697.92 | 2699.55 | 265.0 |
| 2019-01-02 00:20:00 | ES | Futures | 2699.55 | 2700.37 | 2699.55 | 2699.55 | 80.0 |
| 2019-01-02 00:21:00 | ES | Futures | 2699.55 | 2699.82 | 2699.55 | 2699.55 | 36.0 |
| 2019-01-02 00:22:00 | ES | Futures | 2699.55 | 2699.82 | 2699.55 | 2699.82 | 37.0 |
| 2019-01-02 00:23:00 | ES | Futures | 2699.82 | 2700.37 | 2699.82 | 2700.09 | 55.0 |
| 2019-01-02 00:24:00 | ES | Futures | 2700.37 | 2700.64 | 2699.82 | 2700.09 | 74.0 |
| 2019-01-02 00:25:00 | ES | Futures | 2700.09 | 2700.64 | 2700.09 | 2700.64 | 45.0 |
| 2019-01-02 00:26:00 | ES | Futures | 2700.64 | 2700.64 | 2699.82 | 2699.82 | 93.0 |
| 2019-01-02 00:27:00 | ES | Futures | 2699.82 | 2699.82 | 2698.46 | 2699.01 | 124.0 |
| 2019-01-02 00:28:00 | ES | Futures | 2699.28 | 2699.28 | 2698.74 | 2698.74 | 55.0 |
| 2019-01-02 00:29:00 | ES | Futures | 2698.74 | 2699.01 | 2697.11 | 2697.38 | 292.0 |
| 2019-01-02 00:30:00 | ES | Futures | 2697.38 | 2698.74 | 2697.38 | 2698.74 | 151.0 |
| 2019-01-02 00:31:00 | ES | Futures | 2698.74 | 2698.74 | 2697.65 | 2697.65 | 67.0 |
| 2019-01-02 00:32:00 | ES | Futures | 2697.65 | 2697.92 | 2697.11 | 2697.11 | 132.0 |
| 2019-01-02 00:33:00 | ES | Futures | 2697.11 | 2697.65 | 2697.11 | 2697.38 | 120.0 |
| 2019-01-02 00:34:00 | ES | Futures | 2697.65 | 2698.46 | 2697.65 | 2697.92 | 101.0 |
| 2019-01-02 00:35:00 | ES | Futures | 2698.46 | 2699.28 | 2697.92 | 2698.74 | 115.0 |
| 2019-01-02 00:36:00 | ES | Futures | 2699.01 | 2699.01 | 2698.46 | 2698.74 | 67.0 |
| 2019-01-02 00:37:00 | ES | Futures | 2699.01 | 2699.55 | 2699.01 | 2699.28 | 40.0 |
| 2019-01-02 00:38:00 | ES | Futures | 2699.55 | 2699.55 | 2698.74 | 2699.01 | 38.0 |
| 2019-01-02 00:39:00 | ES | Futures | 2699.28 | 2699.55 | 2697.11 | 2697.38 | 276.0 |
| 2019-01-02 00:40:00 | ES | Futures | 2697.65 | 2697.65 | 2696.56 | 2697.38 | 367.0 |
| 2019-01-02 00:41:00 | ES | Futures | 2697.38 | 2698.19 | 2697.11 | 2697.38 | 115.0 |
| 2019-01-02 00:42:00 | ES | Futures | 2697.65 | 2697.92 | 2697.65 | 2697.65 | 34.0 |
| 2019-01-02 00:43:00 | ES | Futures | 2697.65 | 2697.92 | 2697.38 | 2697.38 | 40.0 |
| 2019-01-02 00:44:00 | ES | Futures | 2697.38 | 2697.38 | 2697.11 | 2697.11 | 85.0 |
| 2019-01-02 00:45:00 | ES | Futures | 2697.38 | 2697.65 | 2697.11 | 2697.38 | 65.0 |
| 2019-01-02 00:46:00 | ES | Futures | 2697.38 | 2697.65 | 2697.38 | 2697.65 | 53.0 |
| 2019-01-02 00:47:00 | ES | Futures | 2697.65 | 2697.65 | 2696.56 | 2696.56 | 82.0 |
| 2019-01-02 00:48:00 | ES | Futures | 2696.29 | 2696.29 | 2695.21 | 2695.75 | 328.0 |
| 2019-01-02 00:49:00 | ES | Futures | 2696.02 | 2697.11 | 2696.02 | 2696.83 | 57.0 |
> showing 50 of 67,418 rows — these rows as CSV