PREVIEW / futures_1hour / 2017-09-17
file: by_date/futures_1hour/2017/2017-09-17.parquet size: 15 KB rows: 293
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-09-17 18:00:00 | ES | Futures | 2734.49 | 2735.59 | 2733.94 | 2734.77 | 5492.0 |
| 2017-09-17 19:00:00 | ES | Futures | 2734.77 | 2736.68 | 2734.77 | 2736.41 | 5279.0 |
| 2017-09-17 20:00:00 | ES | Futures | 2736.41 | 2737.23 | 2735.86 | 2736.41 | 5926.0 |
| 2017-09-17 21:00:00 | ES | Futures | 2736.41 | 2738.6 | 2736.13 | 2738.05 | 7850.0 |
| 2017-09-17 22:00:00 | ES | Futures | 2738.05 | 2739.69 | 2737.5 | 2738.87 | 7577.0 |
| 2017-09-17 23:00:00 | ES | Futures | 2738.87 | 2739.69 | 2738.87 | 2739.42 | 3562.0 |
| 2017-09-17 18:00:00 | NQ | Futures | 7137.1 | 7138.59 | 7133.83 | 7137.7 | 1407.0 |
| 2017-09-17 19:00:00 | NQ | Futures | 7137.7 | 7143.35 | 7137.7 | 7142.16 | 1131.0 |
| 2017-09-17 20:00:00 | NQ | Futures | 7141.86 | 7144.24 | 7139.48 | 7139.48 | 1020.0 |
| 2017-09-17 21:00:00 | NQ | Futures | 7139.78 | 7146.62 | 7139.48 | 7146.32 | 1432.0 |
| 2017-09-17 22:00:00 | NQ | Futures | 7146.62 | 7149.89 | 7145.43 | 7147.81 | 1269.0 |
| 2017-09-17 23:00:00 | NQ | Futures | 7147.81 | 7151.38 | 7147.51 | 7149.89 | 715.0 |
| 2017-09-17 18:00:00 | YM | Futures | 24176.0 | 24183.6 | 24171.6 | 24173.8 | 1013.0 |
| 2017-09-17 19:00:00 | YM | Futures | 24174.9 | 24186.8 | 24174.9 | 24181.4 | 1214.0 |
| 2017-09-17 20:00:00 | YM | Futures | 24181.4 | 24194.4 | 24179.2 | 24190.1 | 1052.0 |
| 2017-09-17 21:00:00 | YM | Futures | 24190.1 | 24227.1 | 24189.0 | 24223.8 | 2762.0 |
| 2017-09-17 22:00:00 | YM | Futures | 24224.9 | 24240.1 | 24221.6 | 24230.3 | 2093.0 |
| 2017-09-17 23:00:00 | YM | Futures | 24231.4 | 24240.1 | 24226.0 | 24240.1 | 1608.0 |
| 2017-09-17 18:00:00 | CL | Futures | 45.11 | 45.15 | 45.0 | 45.03 | 1639.0 |
| 2017-09-17 19:00:00 | CL | Futures | 45.03 | 45.08 | 45.01 | 45.07 | 639.0 |
| 2017-09-17 20:00:00 | CL | Futures | 45.08 | 45.13 | 45.06 | 45.11 | 2070.0 |
| 2017-09-17 21:00:00 | CL | Futures | 45.11 | 45.15 | 45.09 | 45.14 | 2256.0 |
| 2017-09-17 22:00:00 | CL | Futures | 45.14 | 45.17 | 45.12 | 45.15 | 2081.0 |
| 2017-09-17 23:00:00 | CL | Futures | 45.15 | 45.17 | 45.13 | 45.15 | 1750.0 |
| 2017-09-17 18:00:00 | GC | Futures | 1763.8 | 1763.8 | 1759.8 | 1759.9 | 3908.0 |
| 2017-09-17 19:00:00 | GC | Futures | 1759.9 | 1760.3 | 1755.8 | 1758.6 | 7894.0 |
| 2017-09-17 20:00:00 | GC | Futures | 1758.4 | 1760.6 | 1758.2 | 1759.8 | 4660.0 |
| 2017-09-17 21:00:00 | GC | Futures | 1759.9 | 1762.6 | 1759.8 | 1761.8 | 6757.0 |
| 2017-09-17 22:00:00 | GC | Futures | 1761.9 | 1763.0 | 1761.2 | 1761.5 | 4695.0 |
| 2017-09-17 23:00:00 | GC | Futures | 1761.5 | 1762.0 | 1759.6 | 1760.3 | 4033.0 |
| 2017-09-17 18:00:00 | ZN | Futures | 125.745627 | 125.761188 | 125.730067 | 125.761188 | 6973.0 |
| 2017-09-17 19:00:00 | ZN | Futures | 125.761188 | 125.761188 | 125.714506 | 125.714506 | 6448.0 |
| 2017-09-17 20:00:00 | ZN | Futures | 125.714506 | 125.745627 | 125.683385 | 125.683385 | 10411.0 |
| 2017-09-17 21:00:00 | ZN | Futures | 125.698945 | 125.730067 | 125.683385 | 125.714506 | 5353.0 |
| 2017-09-17 22:00:00 | ZN | Futures | 125.714506 | 125.730067 | 125.683385 | 125.714506 | 5068.0 |
| 2017-09-17 23:00:00 | ZN | Futures | 125.714506 | 125.730067 | 125.698945 | 125.714506 | 1888.0 |
> showing 36 of 293 rows — these rows as CSV