PREVIEW / futures_1hour / 2015-07-12
file: by_date/futures_1hour/2015/2015-07-12.parquet size: 14 KB rows: 275
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 |
|---|---|---|---|---|---|---|---|
| 2015-07-12 18:00:00 | ES | Futures | 2188.29 | 2198.68 | 2185.37 | 2191.76 | 30371.0 |
| 2015-07-12 19:00:00 | ES | Futures | 2192.02 | 2196.02 | 2191.76 | 2193.89 | 8078.0 |
| 2015-07-12 20:00:00 | ES | Futures | 2193.89 | 2194.15 | 2192.02 | 2193.35 | 6747.0 |
| 2015-07-12 21:00:00 | ES | Futures | 2193.09 | 2194.95 | 2192.82 | 2194.42 | 6779.0 |
| 2015-07-12 22:00:00 | ES | Futures | 2194.68 | 2197.88 | 2194.42 | 2197.61 | 5926.0 |
| 2015-07-12 23:00:00 | ES | Futures | 2197.61 | 2203.74 | 2197.35 | 2200.54 | 17857.0 |
| 2015-07-12 18:00:00 | NQ | Futures | 5186.96 | 5201.75 | 5173.36 | 5189.33 | 2969.0 |
| 2015-07-12 19:00:00 | NQ | Futures | 5189.92 | 5199.68 | 5189.63 | 5196.43 | 887.0 |
| 2015-07-12 20:00:00 | NQ | Futures | 5196.43 | 5197.61 | 5191.7 | 5194.95 | 1023.0 |
| 2015-07-12 21:00:00 | NQ | Futures | 5194.65 | 5201.46 | 5194.06 | 5199.09 | 1118.0 |
| 2015-07-12 22:00:00 | NQ | Futures | 5199.09 | 5207.67 | 5199.09 | 5207.67 | 1043.0 |
| 2015-07-12 23:00:00 | NQ | Futures | 5207.37 | 5223.05 | 5207.37 | 5213.88 | 2549.0 |
| 2015-07-12 18:00:00 | YM | Futures | 18504.0 | 18571.4 | 18473.5 | 18525.1 | 2924.0 |
| 2015-07-12 19:00:00 | YM | Futures | 18526.1 | 18560.9 | 18526.1 | 18544.1 | 690.0 |
| 2015-07-12 20:00:00 | YM | Futures | 18544.1 | 18545.1 | 18527.2 | 18539.8 | 1294.0 |
| 2015-07-12 21:00:00 | YM | Futures | 18539.8 | 18553.5 | 18535.6 | 18548.3 | 837.0 |
| 2015-07-12 22:00:00 | YM | Futures | 18547.2 | 18574.6 | 18546.2 | 18574.6 | 954.0 |
| 2015-07-12 23:00:00 | YM | Futures | 18575.7 | 18618.9 | 18574.6 | 18593.6 | 2886.0 |
| 2015-07-12 18:00:00 | CL | Futures | 77.69 | 77.88 | 77.12 | 77.35 | 4120.0 |
| 2015-07-12 19:00:00 | CL | Futures | 77.35 | 77.78 | 77.33 | 77.63 | 1165.0 |
| 2015-07-12 20:00:00 | CL | Futures | 77.63 | 77.77 | 77.6 | 77.63 | 1102.0 |
| 2015-07-12 21:00:00 | CL | Futures | 77.63 | 77.65 | 77.15 | 77.2 | 2702.0 |
| 2015-07-12 22:00:00 | CL | Futures | 77.18 | 77.39 | 77.14 | 77.27 | 1753.0 |
| 2015-07-12 23:00:00 | CL | Futures | 77.29 | 77.44 | 77.23 | 77.35 | 1378.0 |
| 2015-07-12 18:00:00 | GC | Futures | 1586.5 | 1588.7 | 1584.3 | 1586.1 | 2271.0 |
| 2015-07-12 19:00:00 | GC | Futures | 1585.9 | 1586.1 | 1584.3 | 1585.4 | 684.0 |
| 2015-07-12 20:00:00 | GC | Futures | 1585.5 | 1587.7 | 1583.8 | 1587.0 | 1694.0 |
| 2015-07-12 21:00:00 | GC | Futures | 1586.9 | 1587.0 | 1582.9 | 1583.3 | 2525.0 |
| 2015-07-12 22:00:00 | GC | Futures | 1583.3 | 1585.3 | 1583.3 | 1584.4 | 951.0 |
| 2015-07-12 23:00:00 | GC | Futures | 1584.3 | 1585.3 | 1584.0 | 1584.3 | 786.0 |
| 2015-07-12 18:00:00 | ZN | Futures | 121.566479 | 121.566479 | 121.205747 | 121.2809 | 25582.0 |
| 2015-07-12 19:00:00 | ZN | Futures | 121.2809 | 121.2809 | 121.175686 | 121.205747 | 7093.0 |
| 2015-07-12 20:00:00 | ZN | Futures | 121.205747 | 121.2809 | 121.205747 | 121.235808 | 6914.0 |
| 2015-07-12 21:00:00 | ZN | Futures | 121.235808 | 121.250839 | 121.130595 | 121.175686 | 10061.0 |
| 2015-07-12 22:00:00 | ZN | Futures | 121.175686 | 121.220778 | 121.145625 | 121.190717 | 4285.0 |
| 2015-07-12 23:00:00 | ZN | Futures | 121.175686 | 121.29593 | 121.160656 | 121.190717 | 16014.0 |
> showing 36 of 275 rows — these rows as CSV