PREVIEW / futures_1hour / 2017-08-06
file: by_date/futures_1hour/2017/2017-08-06.parquet size: 14 KB rows: 285
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-06 18:00:00 | ES | Futures | 2703.05 | 2704.69 | 2702.78 | 2703.87 | 3941.0 |
| 2017-08-06 19:00:00 | ES | Futures | 2703.87 | 2704.42 | 2703.6 | 2704.15 | 1161.0 |
| 2017-08-06 20:00:00 | ES | Futures | 2704.15 | 2708.25 | 2703.87 | 2707.97 | 8703.0 |
| 2017-08-06 21:00:00 | ES | Futures | 2707.7 | 2708.79 | 2707.15 | 2707.15 | 7977.0 |
| 2017-08-06 22:00:00 | ES | Futures | 2707.43 | 2707.97 | 2706.88 | 2707.97 | 1848.0 |
| 2017-08-06 23:00:00 | ES | Futures | 2707.97 | 2708.25 | 2707.7 | 2707.97 | 1595.0 |
| 2017-08-06 18:00:00 | NQ | Futures | 7026.93 | 7034.97 | 7024.55 | 7030.8 | 983.0 |
| 2017-08-06 19:00:00 | NQ | Futures | 7030.8 | 7032.88 | 7029.61 | 7032.59 | 173.0 |
| 2017-08-06 20:00:00 | NQ | Futures | 7032.88 | 7042.71 | 7031.69 | 7041.22 | 1253.0 |
| 2017-08-06 21:00:00 | NQ | Futures | 7041.22 | 7049.86 | 7040.33 | 7045.69 | 1798.0 |
| 2017-08-06 22:00:00 | NQ | Futures | 7045.99 | 7048.96 | 7045.09 | 7048.67 | 468.0 |
| 2017-08-06 23:00:00 | NQ | Futures | 7048.96 | 7051.94 | 7048.37 | 7051.34 | 796.0 |
| 2017-08-06 18:00:00 | YM | Futures | 23970.5 | 23978.2 | 23967.3 | 23971.6 | 454.0 |
| 2017-08-06 19:00:00 | YM | Futures | 23971.6 | 23978.2 | 23968.4 | 23976.0 | 423.0 |
| 2017-08-06 20:00:00 | YM | Futures | 23976.0 | 24034.8 | 23973.8 | 24026.1 | 2168.0 |
| 2017-08-06 21:00:00 | YM | Futures | 24025.0 | 24030.4 | 24014.1 | 24016.3 | 1363.0 |
| 2017-08-06 22:00:00 | YM | Futures | 24016.3 | 24025.0 | 24013.0 | 24025.0 | 588.0 |
| 2017-08-06 23:00:00 | YM | Futures | 24025.0 | 24027.1 | 24022.8 | 24026.1 | 483.0 |
| 2017-08-06 18:00:00 | CL | Futures | 44.98 | 45.1 | 44.91 | 44.98 | 2965.0 |
| 2017-08-06 19:00:00 | CL | Futures | 44.98 | 44.98 | 44.92 | 44.93 | 813.0 |
| 2017-08-06 20:00:00 | CL | Futures | 44.92 | 45.04 | 44.91 | 45.03 | 3309.0 |
| 2017-08-06 21:00:00 | CL | Futures | 45.03 | 45.05 | 44.86 | 44.91 | 7201.0 |
| 2017-08-06 22:00:00 | CL | Futures | 44.91 | 44.94 | 44.89 | 44.92 | 2179.0 |
| 2017-08-06 23:00:00 | CL | Futures | 44.91 | 44.92 | 44.86 | 44.88 | 2938.0 |
| 2017-08-06 18:00:00 | GC | Futures | 1684.2 | 1685.2 | 1682.0 | 1683.0 | 1903.0 |
| 2017-08-06 19:00:00 | GC | Futures | 1683.2 | 1683.6 | 1681.6 | 1682.6 | 2097.0 |
| 2017-08-06 20:00:00 | GC | Futures | 1682.5 | 1684.5 | 1682.2 | 1683.2 | 4012.0 |
| 2017-08-06 21:00:00 | GC | Futures | 1683.2 | 1684.8 | 1682.8 | 1684.1 | 4267.0 |
| 2017-08-06 22:00:00 | GC | Futures | 1684.1 | 1684.9 | 1683.2 | 1683.4 | 3272.0 |
| 2017-08-06 23:00:00 | GC | Futures | 1683.4 | 1684.6 | 1682.9 | 1684.1 | 2840.0 |
| 2017-08-06 18:00:00 | ZN | Futures | 125.329012 | 125.360073 | 125.235831 | 125.297952 | 5125.0 |
| 2017-08-06 19:00:00 | ZN | Futures | 125.297952 | 125.313482 | 125.266891 | 125.282422 | 5651.0 |
| 2017-08-06 20:00:00 | ZN | Futures | 125.297952 | 125.313482 | 125.266891 | 125.282422 | 7513.0 |
| 2017-08-06 21:00:00 | ZN | Futures | 125.282422 | 125.329012 | 125.266891 | 125.329012 | 6596.0 |
| 2017-08-06 22:00:00 | ZN | Futures | 125.329012 | 125.329012 | 125.297952 | 125.313482 | 3556.0 |
| 2017-08-06 23:00:00 | ZN | Futures | 125.329012 | 125.329012 | 125.313482 | 125.313482 | 2190.0 |
> showing 36 of 285 rows — these rows as CSV