PREVIEW / futures_1hour / 2015-05-10
file: by_date/futures_1hour/2015/2015-05-10.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-05-10 18:00:00 | ES | Futures | 2229.15 | 2229.68 | 2227.57 | 2228.63 | 4174.0 |
| 2015-05-10 19:00:00 | ES | Futures | 2228.63 | 2229.42 | 2228.36 | 2228.89 | 1658.0 |
| 2015-05-10 20:00:00 | ES | Futures | 2228.89 | 2228.89 | 2227.57 | 2227.83 | 5356.0 |
| 2015-05-10 21:00:00 | ES | Futures | 2227.83 | 2227.83 | 2225.72 | 2226.78 | 6287.0 |
| 2015-05-10 22:00:00 | ES | Futures | 2226.51 | 2227.57 | 2226.25 | 2226.51 | 1530.0 |
| 2015-05-10 23:00:00 | ES | Futures | 2226.51 | 2227.31 | 2226.25 | 2226.51 | 2437.0 |
| 2015-05-10 18:00:00 | NQ | Futures | 5237.27 | 5238.45 | 5232.27 | 5235.51 | 826.0 |
| 2015-05-10 19:00:00 | NQ | Futures | 5235.8 | 5236.68 | 5234.62 | 5236.68 | 238.0 |
| 2015-05-10 20:00:00 | NQ | Futures | 5236.1 | 5236.1 | 5233.45 | 5234.33 | 550.0 |
| 2015-05-10 21:00:00 | NQ | Futures | 5234.62 | 5234.92 | 5229.33 | 5232.86 | 766.0 |
| 2015-05-10 22:00:00 | NQ | Futures | 5232.57 | 5234.33 | 5231.68 | 5232.27 | 275.0 |
| 2015-05-10 23:00:00 | NQ | Futures | 5232.27 | 5234.04 | 5231.68 | 5232.57 | 369.0 |
| 2015-05-10 18:00:00 | YM | Futures | 19011.3 | 19018.6 | 19001.8 | 19012.3 | 544.0 |
| 2015-05-10 19:00:00 | YM | Futures | 19013.4 | 19016.5 | 19010.2 | 19012.3 | 436.0 |
| 2015-05-10 20:00:00 | YM | Futures | 19011.3 | 19011.3 | 19002.9 | 19005.0 | 574.0 |
| 2015-05-10 21:00:00 | YM | Futures | 19005.0 | 19006.0 | 18986.1 | 18996.6 | 805.0 |
| 2015-05-10 22:00:00 | YM | Futures | 18995.5 | 19003.9 | 18993.4 | 18995.5 | 373.0 |
| 2015-05-10 23:00:00 | YM | Futures | 18994.5 | 19000.8 | 18992.4 | 18995.5 | 356.0 |
| 2015-05-10 18:00:00 | CL | Futures | 90.61 | 90.62 | 90.2 | 90.32 | 873.0 |
| 2015-05-10 19:00:00 | CL | Futures | 90.32 | 90.52 | 90.3 | 90.41 | 312.0 |
| 2015-05-10 20:00:00 | CL | Futures | 90.41 | 90.44 | 90.33 | 90.35 | 659.0 |
| 2015-05-10 21:00:00 | CL | Futures | 90.35 | 90.56 | 90.27 | 90.52 | 1495.0 |
| 2015-05-10 22:00:00 | CL | Futures | 90.53 | 90.64 | 90.35 | 90.36 | 727.0 |
| 2015-05-10 23:00:00 | CL | Futures | 90.38 | 90.41 | 90.26 | 90.35 | 604.0 |
| 2015-05-10 18:00:00 | GC | Futures | 1623.9 | 1623.9 | 1621.6 | 1622.6 | 630.0 |
| 2015-05-10 19:00:00 | GC | Futures | 1622.6 | 1624.7 | 1622.1 | 1624.1 | 685.0 |
| 2015-05-10 20:00:00 | GC | Futures | 1624.0 | 1624.7 | 1623.5 | 1624.0 | 708.0 |
| 2015-05-10 21:00:00 | GC | Futures | 1623.9 | 1624.6 | 1622.5 | 1622.6 | 1747.0 |
| 2015-05-10 22:00:00 | GC | Futures | 1622.8 | 1623.3 | 1622.5 | 1622.6 | 958.0 |
| 2015-05-10 23:00:00 | GC | Futures | 1622.6 | 1622.6 | 1621.6 | 1622.0 | 1081.0 |
| 2015-05-10 18:00:00 | ZN | Futures | 122.140834 | 122.230435 | 122.125901 | 122.230435 | 3611.0 |
| 2015-05-10 19:00:00 | ZN | Futures | 122.215502 | 122.260302 | 122.215502 | 122.260302 | 1409.0 |
| 2015-05-10 20:00:00 | ZN | Futures | 122.260302 | 122.334969 | 122.245368 | 122.290169 | 8855.0 |
| 2015-05-10 21:00:00 | ZN | Futures | 122.290169 | 122.320036 | 122.275235 | 122.275235 | 6089.0 |
| 2015-05-10 22:00:00 | ZN | Futures | 122.290169 | 122.290169 | 122.245368 | 122.245368 | 5551.0 |
| 2015-05-10 23:00:00 | ZN | Futures | 122.245368 | 122.260302 | 122.215502 | 122.245368 | 2510.0 |
> showing 36 of 275 rows — these rows as CSV