PREVIEW / futures_5min / 2018-09-02
file: by_date/futures_5min/2018/2018-09-02.parquet size: 42 KB rows: 2,238
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 |
|---|---|---|---|---|---|---|---|
| 2018-09-02 18:00:00 | ES | Futures | 3167.69 | 3168.24 | 3166.88 | 3167.15 | 1611.0 |
| 2018-09-02 18:05:00 | ES | Futures | 3167.42 | 3167.42 | 3166.06 | 3166.6 | 755.0 |
| 2018-09-02 18:10:00 | ES | Futures | 3166.88 | 3166.88 | 3165.79 | 3165.79 | 492.0 |
| 2018-09-02 18:15:00 | ES | Futures | 3166.06 | 3166.33 | 3166.06 | 3166.33 | 270.0 |
| 2018-09-02 18:20:00 | ES | Futures | 3166.33 | 3166.88 | 3166.06 | 3166.88 | 299.0 |
| 2018-09-02 18:25:00 | ES | Futures | 3166.88 | 3166.88 | 3166.33 | 3166.6 | 196.0 |
| 2018-09-02 18:30:00 | ES | Futures | 3166.33 | 3166.6 | 3166.33 | 3166.6 | 163.0 |
| 2018-09-02 18:35:00 | ES | Futures | 3166.6 | 3166.6 | 3166.33 | 3166.6 | 175.0 |
| 2018-09-02 18:40:00 | ES | Futures | 3166.33 | 3167.69 | 3166.33 | 3167.15 | 393.0 |
| 2018-09-02 18:45:00 | ES | Futures | 3167.15 | 3167.69 | 3167.15 | 3167.69 | 185.0 |
| 2018-09-02 18:50:00 | ES | Futures | 3167.69 | 3167.69 | 3166.6 | 3167.15 | 421.0 |
| 2018-09-02 18:55:00 | ES | Futures | 3167.15 | 3167.15 | 3166.88 | 3167.15 | 98.0 |
| 2018-09-02 19:00:00 | ES | Futures | 3167.15 | 3167.15 | 3166.6 | 3166.6 | 340.0 |
| 2018-09-02 19:05:00 | ES | Futures | 3166.33 | 3166.6 | 3166.06 | 3166.6 | 303.0 |
| 2018-09-02 19:10:00 | ES | Futures | 3166.6 | 3166.88 | 3166.33 | 3166.88 | 140.0 |
| 2018-09-02 19:15:00 | ES | Futures | 3166.88 | 3167.69 | 3166.88 | 3167.69 | 249.0 |
| 2018-09-02 19:20:00 | ES | Futures | 3167.69 | 3167.97 | 3167.42 | 3167.69 | 182.0 |
| 2018-09-02 19:25:00 | ES | Futures | 3167.69 | 3167.97 | 3167.69 | 3167.69 | 138.0 |
| 2018-09-02 19:30:00 | ES | Futures | 3167.69 | 3168.24 | 3167.69 | 3168.24 | 265.0 |
| 2018-09-02 19:35:00 | ES | Futures | 3168.24 | 3168.51 | 3167.69 | 3167.97 | 617.0 |
| 2018-09-02 19:40:00 | ES | Futures | 3167.69 | 3167.97 | 3167.69 | 3167.69 | 154.0 |
| 2018-09-02 19:45:00 | ES | Futures | 3167.69 | 3167.97 | 3167.42 | 3167.69 | 164.0 |
| 2018-09-02 19:50:00 | ES | Futures | 3167.69 | 3168.24 | 3167.42 | 3168.24 | 395.0 |
| 2018-09-02 19:55:00 | ES | Futures | 3168.24 | 3168.24 | 3167.69 | 3167.69 | 266.0 |
| 2018-09-02 20:00:00 | ES | Futures | 3167.69 | 3167.69 | 3166.6 | 3167.15 | 771.0 |
| 2018-09-02 20:05:00 | ES | Futures | 3167.15 | 3167.42 | 3166.6 | 3166.88 | 636.0 |
| 2018-09-02 20:10:00 | ES | Futures | 3166.88 | 3167.15 | 3166.06 | 3167.15 | 751.0 |
| 2018-09-02 20:15:00 | ES | Futures | 3167.15 | 3167.69 | 3166.33 | 3167.15 | 699.0 |
| 2018-09-02 20:20:00 | ES | Futures | 3167.15 | 3167.69 | 3167.15 | 3167.42 | 462.0 |
| 2018-09-02 20:25:00 | ES | Futures | 3167.15 | 3167.69 | 3167.15 | 3167.69 | 143.0 |
| 2018-09-02 20:30:00 | ES | Futures | 3167.69 | 3167.69 | 3167.15 | 3167.42 | 311.0 |
| 2018-09-02 20:35:00 | ES | Futures | 3167.15 | 3167.42 | 3166.33 | 3166.6 | 466.0 |
| 2018-09-02 20:40:00 | ES | Futures | 3166.6 | 3166.6 | 3165.24 | 3166.33 | 1115.0 |
| 2018-09-02 20:45:00 | ES | Futures | 3166.33 | 3167.42 | 3166.33 | 3167.42 | 318.0 |
| 2018-09-02 20:50:00 | ES | Futures | 3167.15 | 3167.42 | 3166.6 | 3166.6 | 165.0 |
| 2018-09-02 20:55:00 | ES | Futures | 3166.33 | 3167.42 | 3166.06 | 3167.42 | 404.0 |
| 2018-09-02 21:00:00 | ES | Futures | 3167.42 | 3167.42 | 3166.6 | 3167.15 | 261.0 |
| 2018-09-02 21:05:00 | ES | Futures | 3167.15 | 3167.15 | 3166.33 | 3166.6 | 248.0 |
| 2018-09-02 21:10:00 | ES | Futures | 3166.33 | 3166.88 | 3165.79 | 3165.79 | 389.0 |
| 2018-09-02 21:15:00 | ES | Futures | 3165.51 | 3166.33 | 3164.7 | 3165.79 | 1346.0 |
| 2018-09-02 21:20:00 | ES | Futures | 3165.51 | 3166.6 | 3165.51 | 3166.33 | 278.0 |
| 2018-09-02 21:25:00 | ES | Futures | 3166.33 | 3166.88 | 3166.06 | 3166.88 | 324.0 |
| 2018-09-02 21:30:00 | ES | Futures | 3166.6 | 3167.42 | 3165.79 | 3167.42 | 1018.0 |
| 2018-09-02 21:35:00 | ES | Futures | 3167.69 | 3167.69 | 3166.88 | 3167.42 | 513.0 |
| 2018-09-02 21:40:00 | ES | Futures | 3167.42 | 3167.69 | 3167.15 | 3167.42 | 223.0 |
| 2018-09-02 21:45:00 | ES | Futures | 3167.42 | 3168.24 | 3167.42 | 3167.69 | 565.0 |
| 2018-09-02 21:50:00 | ES | Futures | 3167.69 | 3167.97 | 3167.15 | 3167.42 | 330.0 |
| 2018-09-02 21:55:00 | ES | Futures | 3167.42 | 3168.24 | 3167.42 | 3167.97 | 721.0 |
| 2018-09-02 22:00:00 | ES | Futures | 3167.69 | 3167.69 | 3166.6 | 3166.6 | 554.0 |
| 2018-09-02 22:05:00 | ES | Futures | 3166.6 | 3166.6 | 3166.06 | 3166.06 | 649.0 |
> showing 50 of 2,238 rows — these rows as CSV