PREVIEW / futures_5min / 2017-08-13
file: by_date/futures_5min/2017/2017-08-13.parquet size: 45 KB rows: 2,570
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 |
|---|---|---|---|---|---|---|---|
| 2017-08-13 18:00:00 | ES | Futures | 2669.43 | 2672.98 | 2669.43 | 2672.16 | 3600.0 |
| 2017-08-13 18:05:00 | ES | Futures | 2672.16 | 2673.53 | 2672.16 | 2672.98 | 1467.0 |
| 2017-08-13 18:10:00 | ES | Futures | 2672.98 | 2673.53 | 2672.71 | 2673.26 | 988.0 |
| 2017-08-13 18:15:00 | ES | Futures | 2673.26 | 2673.26 | 2672.16 | 2672.44 | 815.0 |
| 2017-08-13 18:20:00 | ES | Futures | 2672.44 | 2672.71 | 2672.44 | 2672.71 | 87.0 |
| 2017-08-13 18:25:00 | ES | Futures | 2672.44 | 2672.71 | 2672.44 | 2672.44 | 187.0 |
| 2017-08-13 18:30:00 | ES | Futures | 2672.44 | 2672.71 | 2672.44 | 2672.44 | 235.0 |
| 2017-08-13 18:35:00 | ES | Futures | 2672.44 | 2672.98 | 2672.44 | 2672.71 | 288.0 |
| 2017-08-13 18:40:00 | ES | Futures | 2672.44 | 2672.98 | 2672.44 | 2672.71 | 296.0 |
| 2017-08-13 18:45:00 | ES | Futures | 2672.44 | 2672.98 | 2672.44 | 2672.71 | 212.0 |
| 2017-08-13 18:50:00 | ES | Futures | 2672.71 | 2672.98 | 2672.44 | 2672.71 | 190.0 |
| 2017-08-13 18:55:00 | ES | Futures | 2672.71 | 2672.98 | 2672.44 | 2672.98 | 515.0 |
| 2017-08-13 19:00:00 | ES | Futures | 2672.71 | 2673.26 | 2672.71 | 2673.26 | 353.0 |
| 2017-08-13 19:05:00 | ES | Futures | 2672.98 | 2674.35 | 2672.98 | 2674.35 | 1164.0 |
| 2017-08-13 19:10:00 | ES | Futures | 2674.35 | 2674.35 | 2673.53 | 2673.53 | 322.0 |
| 2017-08-13 19:15:00 | ES | Futures | 2673.53 | 2674.62 | 2673.53 | 2674.35 | 657.0 |
| 2017-08-13 19:20:00 | ES | Futures | 2674.35 | 2674.35 | 2673.8 | 2673.8 | 140.0 |
| 2017-08-13 19:25:00 | ES | Futures | 2674.08 | 2674.35 | 2673.8 | 2674.35 | 421.0 |
| 2017-08-13 19:30:00 | ES | Futures | 2674.35 | 2674.62 | 2674.08 | 2674.08 | 229.0 |
| 2017-08-13 19:35:00 | ES | Futures | 2674.08 | 2674.35 | 2672.98 | 2673.53 | 845.0 |
| 2017-08-13 19:40:00 | ES | Futures | 2673.8 | 2673.8 | 2673.26 | 2673.53 | 219.0 |
| 2017-08-13 19:45:00 | ES | Futures | 2673.53 | 2673.8 | 2672.98 | 2673.8 | 314.0 |
| 2017-08-13 19:50:00 | ES | Futures | 2673.53 | 2675.17 | 2673.53 | 2674.9 | 1220.0 |
| 2017-08-13 19:55:00 | ES | Futures | 2674.9 | 2675.72 | 2674.62 | 2675.17 | 1045.0 |
| 2017-08-13 20:00:00 | ES | Futures | 2675.17 | 2676.26 | 2675.17 | 2675.99 | 1828.0 |
| 2017-08-13 20:05:00 | ES | Futures | 2675.99 | 2676.54 | 2675.17 | 2675.44 | 1652.0 |
| 2017-08-13 20:10:00 | ES | Futures | 2675.17 | 2676.81 | 2674.9 | 2676.54 | 2341.0 |
| 2017-08-13 20:15:00 | ES | Futures | 2676.26 | 2678.18 | 2675.99 | 2677.63 | 3270.0 |
| 2017-08-13 20:20:00 | ES | Futures | 2677.9 | 2678.18 | 2677.36 | 2677.9 | 1400.0 |
| 2017-08-13 20:25:00 | ES | Futures | 2677.63 | 2678.18 | 2677.63 | 2677.63 | 630.0 |
| 2017-08-13 20:30:00 | ES | Futures | 2677.9 | 2677.9 | 2677.08 | 2677.36 | 862.0 |
| 2017-08-13 20:35:00 | ES | Futures | 2677.36 | 2677.63 | 2677.36 | 2677.36 | 784.0 |
| 2017-08-13 20:40:00 | ES | Futures | 2677.36 | 2677.63 | 2677.08 | 2677.08 | 558.0 |
| 2017-08-13 20:45:00 | ES | Futures | 2677.08 | 2677.63 | 2676.81 | 2677.36 | 939.0 |
| 2017-08-13 20:50:00 | ES | Futures | 2677.36 | 2677.63 | 2677.36 | 2677.36 | 268.0 |
| 2017-08-13 20:55:00 | ES | Futures | 2677.36 | 2677.9 | 2677.36 | 2677.63 | 432.0 |
| 2017-08-13 21:00:00 | ES | Futures | 2677.9 | 2678.18 | 2677.63 | 2677.9 | 550.0 |
| 2017-08-13 21:05:00 | ES | Futures | 2677.63 | 2677.9 | 2677.08 | 2677.63 | 1000.0 |
| 2017-08-13 21:10:00 | ES | Futures | 2677.9 | 2678.18 | 2677.36 | 2677.9 | 581.0 |
| 2017-08-13 21:15:00 | ES | Futures | 2677.9 | 2678.45 | 2677.9 | 2677.9 | 1103.0 |
| 2017-08-13 21:20:00 | ES | Futures | 2677.9 | 2678.18 | 2677.36 | 2677.36 | 681.0 |
| 2017-08-13 21:25:00 | ES | Futures | 2677.36 | 2677.36 | 2677.08 | 2677.08 | 551.0 |
| 2017-08-13 21:30:00 | ES | Futures | 2677.08 | 2677.36 | 2675.99 | 2676.26 | 1130.0 |
| 2017-08-13 21:35:00 | ES | Futures | 2676.54 | 2676.81 | 2676.54 | 2676.54 | 347.0 |
| 2017-08-13 21:40:00 | ES | Futures | 2676.54 | 2676.81 | 2675.72 | 2675.72 | 1274.0 |
| 2017-08-13 21:45:00 | ES | Futures | 2675.72 | 2676.54 | 2675.72 | 2676.54 | 517.0 |
| 2017-08-13 21:50:00 | ES | Futures | 2676.54 | 2676.81 | 2676.26 | 2676.54 | 413.0 |
| 2017-08-13 21:55:00 | ES | Futures | 2676.81 | 2676.81 | 2675.99 | 2676.26 | 423.0 |
| 2017-08-13 22:00:00 | ES | Futures | 2676.54 | 2676.54 | 2675.72 | 2675.72 | 413.0 |
| 2017-08-13 22:05:00 | ES | Futures | 2675.72 | 2676.54 | 2675.72 | 2676.26 | 292.0 |
> showing 50 of 2,570 rows — these rows as CSV