PREVIEW / futures_1hour / 2014-10-19
file: by_date/futures_1hour/2014/2014-10-19.parquet size: 14 KB rows: 281
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 |
|---|---|---|---|---|---|---|---|
| 2014-10-19 18:00:00 | ES | Futures | 1974.19 | 1984.14 | 1974.19 | 1983.36 | 22710.0 |
| 2014-10-19 19:00:00 | ES | Futures | 1983.09 | 1984.14 | 1979.95 | 1980.47 | 9852.0 |
| 2014-10-19 20:00:00 | ES | Futures | 1980.47 | 1981.52 | 1978.12 | 1981.52 | 8783.0 |
| 2014-10-19 21:00:00 | ES | Futures | 1981.52 | 1981.78 | 1978.9 | 1979.95 | 4849.0 |
| 2014-10-19 22:00:00 | ES | Futures | 1979.95 | 1981.0 | 1979.16 | 1981.0 | 3946.0 |
| 2014-10-19 23:00:00 | ES | Futures | 1981.0 | 1982.05 | 1979.16 | 1981.78 | 3952.0 |
| 2014-10-19 18:00:00 | NQ | Futures | 4467.46 | 4490.9 | 4467.46 | 4489.73 | 1887.0 |
| 2014-10-19 19:00:00 | NQ | Futures | 4488.85 | 4491.78 | 4482.11 | 4482.99 | 1014.0 |
| 2014-10-19 20:00:00 | NQ | Futures | 4483.28 | 4487.38 | 4477.42 | 4487.09 | 1414.0 |
| 2014-10-19 21:00:00 | NQ | Futures | 4487.38 | 4487.97 | 4480.06 | 4482.99 | 882.0 |
| 2014-10-19 22:00:00 | NQ | Futures | 4482.4 | 4485.33 | 4481.23 | 4485.33 | 568.0 |
| 2014-10-19 23:00:00 | NQ | Futures | 4485.62 | 4488.26 | 4482.4 | 4487.38 | 594.0 |
| 2014-10-19 18:00:00 | YM | Futures | 16983.5 | 17070.8 | 16983.5 | 17066.7 | 2672.0 |
| 2014-10-19 19:00:00 | YM | Futures | 17063.6 | 17071.9 | 17036.5 | 17041.7 | 1082.0 |
| 2014-10-19 20:00:00 | YM | Futures | 17042.8 | 17052.1 | 17026.1 | 17051.1 | 1200.0 |
| 2014-10-19 21:00:00 | YM | Futures | 17050.0 | 17052.1 | 17031.3 | 17039.6 | 754.0 |
| 2014-10-19 22:00:00 | YM | Futures | 17038.6 | 17045.9 | 17032.4 | 17043.8 | 607.0 |
| 2014-10-19 23:00:00 | YM | Futures | 17044.8 | 17049.0 | 17030.3 | 17048.0 | 958.0 |
| 2014-10-19 18:00:00 | CL | Futures | 138.62 | 139.19 | 138.55 | 139.13 | 1494.0 |
| 2014-10-19 19:00:00 | CL | Futures | 139.13 | 139.19 | 138.86 | 139.09 | 1094.0 |
| 2014-10-19 20:00:00 | CL | Futures | 139.09 | 139.09 | 138.76 | 138.96 | 975.0 |
| 2014-10-19 21:00:00 | CL | Futures | 138.97 | 139.02 | 138.64 | 138.69 | 967.0 |
| 2014-10-19 22:00:00 | CL | Futures | 138.67 | 138.81 | 138.52 | 138.72 | 753.0 |
| 2014-10-19 23:00:00 | CL | Futures | 138.72 | 138.79 | 138.57 | 138.6 | 447.0 |
| 2014-10-19 18:00:00 | GC | Futures | 1696.3 | 1698.7 | 1691.9 | 1693.0 | 1789.0 |
| 2014-10-19 19:00:00 | GC | Futures | 1692.8 | 1693.4 | 1690.5 | 1690.5 | 1078.0 |
| 2014-10-19 20:00:00 | GC | Futures | 1690.7 | 1692.7 | 1690.5 | 1691.7 | 1463.0 |
| 2014-10-19 21:00:00 | GC | Futures | 1691.6 | 1693.7 | 1690.9 | 1692.8 | 2418.0 |
| 2014-10-19 22:00:00 | GC | Futures | 1692.7 | 1693.9 | 1692.4 | 1693.3 | 1147.0 |
| 2014-10-19 23:00:00 | GC | Futures | 1693.3 | 1694.2 | 1691.7 | 1692.0 | 1508.0 |
| 2014-10-19 18:00:00 | ZN | Futures | 120.774643 | 120.789429 | 120.567635 | 120.582421 | 13865.0 |
| 2014-10-19 19:00:00 | ZN | Futures | 120.582421 | 120.611994 | 120.552848 | 120.597207 | 5596.0 |
| 2014-10-19 20:00:00 | ZN | Futures | 120.611994 | 120.671139 | 120.611994 | 120.62678 | 7070.0 |
| 2014-10-19 21:00:00 | ZN | Futures | 120.611994 | 120.62678 | 120.552848 | 120.567635 | 8899.0 |
| 2014-10-19 22:00:00 | ZN | Futures | 120.582421 | 120.611994 | 120.567635 | 120.597207 | 4937.0 |
| 2014-10-19 23:00:00 | ZN | Futures | 120.582421 | 120.611994 | 120.567635 | 120.582421 | 2872.0 |
> showing 36 of 281 rows — these rows as CSV