PREVIEW / futures_5min / 2018-09-23
file: by_date/futures_5min/2018/2018-09-23.parquet size: 41 KB rows: 2,428
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-23 18:00:00 | ES | Futures | 3187.28 | 3187.82 | 3182.92 | 3184.28 | 6223.0 |
| 2018-09-23 18:05:00 | ES | Futures | 3184.28 | 3184.56 | 3182.11 | 3183.47 | 1825.0 |
| 2018-09-23 18:10:00 | ES | Futures | 3183.47 | 3184.01 | 3182.92 | 3183.74 | 970.0 |
| 2018-09-23 18:15:00 | ES | Futures | 3183.74 | 3184.56 | 3183.74 | 3184.56 | 618.0 |
| 2018-09-23 18:20:00 | ES | Futures | 3184.56 | 3185.92 | 3184.56 | 3185.1 | 1303.0 |
| 2018-09-23 18:25:00 | ES | Futures | 3185.1 | 3185.64 | 3184.83 | 3185.37 | 392.0 |
| 2018-09-23 18:30:00 | ES | Futures | 3185.37 | 3185.64 | 3185.1 | 3185.37 | 298.0 |
| 2018-09-23 18:35:00 | ES | Futures | 3185.37 | 3185.64 | 3184.56 | 3185.37 | 434.0 |
| 2018-09-23 18:40:00 | ES | Futures | 3185.1 | 3185.92 | 3185.1 | 3185.92 | 523.0 |
| 2018-09-23 18:45:00 | ES | Futures | 3185.64 | 3185.92 | 3184.56 | 3184.56 | 345.0 |
| 2018-09-23 18:50:00 | ES | Futures | 3184.83 | 3185.1 | 3183.47 | 3183.47 | 687.0 |
| 2018-09-23 18:55:00 | ES | Futures | 3183.74 | 3184.28 | 3183.47 | 3184.28 | 394.0 |
| 2018-09-23 19:00:00 | ES | Futures | 3184.01 | 3184.83 | 3183.74 | 3184.83 | 439.0 |
| 2018-09-23 19:05:00 | ES | Futures | 3184.83 | 3185.37 | 3184.56 | 3185.37 | 415.0 |
| 2018-09-23 19:10:00 | ES | Futures | 3185.37 | 3185.37 | 3184.28 | 3184.28 | 509.0 |
| 2018-09-23 19:15:00 | ES | Futures | 3184.28 | 3184.56 | 3182.92 | 3182.92 | 645.0 |
| 2018-09-23 19:20:00 | ES | Futures | 3182.92 | 3184.83 | 3182.92 | 3184.83 | 496.0 |
| 2018-09-23 19:25:00 | ES | Futures | 3184.83 | 3185.1 | 3184.56 | 3184.56 | 168.0 |
| 2018-09-23 19:30:00 | ES | Futures | 3184.83 | 3185.37 | 3184.83 | 3185.1 | 224.0 |
| 2018-09-23 19:35:00 | ES | Futures | 3185.37 | 3185.92 | 3185.1 | 3185.1 | 433.0 |
| 2018-09-23 19:40:00 | ES | Futures | 3185.1 | 3185.37 | 3184.56 | 3185.1 | 322.0 |
| 2018-09-23 19:45:00 | ES | Futures | 3185.1 | 3185.92 | 3185.1 | 3185.1 | 378.0 |
| 2018-09-23 19:50:00 | ES | Futures | 3185.1 | 3185.64 | 3185.1 | 3185.64 | 264.0 |
| 2018-09-23 19:55:00 | ES | Futures | 3185.64 | 3185.92 | 3185.64 | 3185.64 | 149.0 |
| 2018-09-23 20:00:00 | ES | Futures | 3185.64 | 3185.64 | 3184.83 | 3185.1 | 268.0 |
| 2018-09-23 20:05:00 | ES | Futures | 3185.1 | 3185.37 | 3184.83 | 3184.83 | 138.0 |
| 2018-09-23 20:10:00 | ES | Futures | 3184.83 | 3185.64 | 3184.83 | 3185.37 | 270.0 |
| 2018-09-23 20:15:00 | ES | Futures | 3185.1 | 3185.37 | 3184.56 | 3184.83 | 359.0 |
| 2018-09-23 20:20:00 | ES | Futures | 3184.56 | 3185.37 | 3184.56 | 3184.83 | 209.0 |
| 2018-09-23 20:25:00 | ES | Futures | 3184.83 | 3184.83 | 3184.28 | 3184.83 | 168.0 |
| 2018-09-23 20:30:00 | ES | Futures | 3184.56 | 3184.83 | 3183.74 | 3184.28 | 341.0 |
| 2018-09-23 20:35:00 | ES | Futures | 3184.28 | 3184.83 | 3184.28 | 3184.56 | 185.0 |
| 2018-09-23 20:40:00 | ES | Futures | 3184.83 | 3185.1 | 3184.56 | 3184.83 | 164.0 |
| 2018-09-23 20:45:00 | ES | Futures | 3184.83 | 3185.1 | 3184.01 | 3184.28 | 340.0 |
| 2018-09-23 20:50:00 | ES | Futures | 3184.28 | 3184.28 | 3183.74 | 3183.74 | 210.0 |
| 2018-09-23 20:55:00 | ES | Futures | 3184.01 | 3184.01 | 3183.47 | 3183.47 | 312.0 |
| 2018-09-23 21:00:00 | ES | Futures | 3183.47 | 3184.01 | 3182.92 | 3183.2 | 528.0 |
| 2018-09-23 21:05:00 | ES | Futures | 3182.92 | 3182.92 | 3181.84 | 3182.92 | 1849.0 |
| 2018-09-23 21:10:00 | ES | Futures | 3182.92 | 3182.92 | 3181.84 | 3182.11 | 467.0 |
| 2018-09-23 21:15:00 | ES | Futures | 3181.84 | 3182.65 | 3180.48 | 3182.38 | 2650.0 |
| 2018-09-23 21:20:00 | ES | Futures | 3182.38 | 3182.92 | 3182.38 | 3182.65 | 423.0 |
| 2018-09-23 21:25:00 | ES | Futures | 3182.38 | 3183.2 | 3182.38 | 3182.92 | 504.0 |
| 2018-09-23 21:30:00 | ES | Futures | 3183.2 | 3183.74 | 3182.65 | 3183.47 | 545.0 |
| 2018-09-23 21:35:00 | ES | Futures | 3183.47 | 3184.01 | 3183.2 | 3184.01 | 450.0 |
| 2018-09-23 21:40:00 | ES | Futures | 3184.01 | 3184.28 | 3183.2 | 3183.47 | 592.0 |
| 2018-09-23 21:45:00 | ES | Futures | 3183.47 | 3183.74 | 3182.65 | 3183.47 | 719.0 |
| 2018-09-23 21:50:00 | ES | Futures | 3183.47 | 3183.74 | 3183.2 | 3183.2 | 200.0 |
| 2018-09-23 21:55:00 | ES | Futures | 3183.47 | 3183.74 | 3183.2 | 3183.74 | 309.0 |
| 2018-09-23 22:00:00 | ES | Futures | 3183.74 | 3184.01 | 3183.47 | 3184.01 | 349.0 |
| 2018-09-23 22:05:00 | ES | Futures | 3184.28 | 3184.83 | 3184.01 | 3184.01 | 575.0 |
> showing 50 of 2,428 rows — these rows as CSV