PREVIEW / futures_1hour / 2015-01-11
file: by_date/futures_1hour/2015/2015-01-11.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-01-11 18:00:00 | ES | Futures | 2141.53 | 2146.0 | 2139.42 | 2140.21 | 13083.0 |
| 2015-01-11 19:00:00 | ES | Futures | 2140.21 | 2141.53 | 2139.42 | 2140.48 | 5064.0 |
| 2015-01-11 20:00:00 | ES | Futures | 2140.48 | 2143.11 | 2139.95 | 2142.85 | 4267.0 |
| 2015-01-11 21:00:00 | ES | Futures | 2142.85 | 2144.69 | 2142.58 | 2143.37 | 2327.0 |
| 2015-01-11 22:00:00 | ES | Futures | 2143.37 | 2143.64 | 2139.69 | 2141.0 | 2589.0 |
| 2015-01-11 23:00:00 | ES | Futures | 2141.0 | 2142.06 | 2140.48 | 2141.79 | 943.0 |
| 2015-01-11 18:00:00 | NQ | Futures | 4935.43 | 4943.66 | 4928.09 | 4931.03 | 1298.0 |
| 2015-01-11 19:00:00 | NQ | Futures | 4931.03 | 4933.67 | 4928.97 | 4931.03 | 416.0 |
| 2015-01-11 20:00:00 | NQ | Futures | 4931.03 | 4936.31 | 4929.85 | 4936.02 | 484.0 |
| 2015-01-11 21:00:00 | NQ | Futures | 4935.73 | 4939.25 | 4935.14 | 4936.9 | 541.0 |
| 2015-01-11 22:00:00 | NQ | Futures | 4937.49 | 4938.37 | 4928.68 | 4931.03 | 390.0 |
| 2015-01-11 23:00:00 | NQ | Futures | 4932.2 | 4934.85 | 4930.44 | 4933.08 | 279.0 |
| 2015-01-11 18:00:00 | YM | Futures | 18421.3 | 18454.7 | 18399.4 | 18406.7 | 1096.0 |
| 2015-01-11 19:00:00 | YM | Futures | 18411.9 | 18417.1 | 18398.3 | 18407.7 | 626.0 |
| 2015-01-11 20:00:00 | YM | Futures | 18408.8 | 18429.7 | 18403.6 | 18427.6 | 582.0 |
| 2015-01-11 21:00:00 | YM | Futures | 18427.6 | 18440.1 | 18423.4 | 18430.7 | 379.0 |
| 2015-01-11 22:00:00 | YM | Futures | 18430.7 | 18432.8 | 18400.4 | 18409.8 | 446.0 |
| 2015-01-11 23:00:00 | YM | Futures | 18409.8 | 18417.1 | 18405.6 | 18414.0 | 282.0 |
| 2015-01-11 18:00:00 | CL | Futures | 82.02 | 82.02 | 80.93 | 81.16 | 4139.0 |
| 2015-01-11 19:00:00 | CL | Futures | 81.16 | 81.47 | 80.94 | 81.05 | 2208.0 |
| 2015-01-11 20:00:00 | CL | Futures | 81.03 | 81.13 | 80.69 | 80.93 | 3401.0 |
| 2015-01-11 21:00:00 | CL | Futures | 80.94 | 81.25 | 80.72 | 81.16 | 1967.0 |
| 2015-01-11 22:00:00 | CL | Futures | 81.18 | 81.3 | 80.98 | 81.1 | 1947.0 |
| 2015-01-11 23:00:00 | CL | Futures | 81.11 | 81.18 | 80.77 | 80.89 | 1850.0 |
| 2015-01-11 18:00:00 | GC | Futures | 1673.1 | 1677.9 | 1672.8 | 1676.7 | 4044.0 |
| 2015-01-11 19:00:00 | GC | Futures | 1676.8 | 1677.9 | 1672.3 | 1674.1 | 1896.0 |
| 2015-01-11 20:00:00 | GC | Futures | 1674.1 | 1678.4 | 1672.1 | 1677.3 | 3343.0 |
| 2015-01-11 21:00:00 | GC | Futures | 1677.3 | 1680.2 | 1675.3 | 1677.2 | 3390.0 |
| 2015-01-11 22:00:00 | GC | Futures | 1677.1 | 1679.0 | 1675.8 | 1676.3 | 1588.0 |
| 2015-01-11 23:00:00 | GC | Futures | 1676.3 | 1678.3 | 1675.4 | 1676.5 | 1081.0 |
| 2015-01-11 18:00:00 | ZN | Futures | 122.459403 | 122.503977 | 122.399972 | 122.489119 | 4780.0 |
| 2015-01-11 19:00:00 | ZN | Futures | 122.489119 | 122.503977 | 122.429687 | 122.444545 | 1917.0 |
| 2015-01-11 20:00:00 | ZN | Futures | 122.429687 | 122.459403 | 122.414829 | 122.444545 | 1550.0 |
| 2015-01-11 21:00:00 | ZN | Futures | 122.444545 | 122.444545 | 122.414829 | 122.429687 | 2024.0 |
| 2015-01-11 22:00:00 | ZN | Futures | 122.429687 | 122.459403 | 122.414829 | 122.444545 | 1383.0 |
| 2015-01-11 23:00:00 | ZN | Futures | 122.429687 | 122.459403 | 122.429687 | 122.429687 | 1072.0 |
> showing 36 of 275 rows — these rows as CSV