PREVIEW / futures_1hour / 2011-08-14
file: by_date/futures_1hour/2011/2011-08-14.parquet size: 14 KB rows: 257
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 |
|---|---|---|---|---|---|---|---|
| 2011-08-14 18:00:00 | ES | Futures | 1176.94 | 1178.19 | 1173.45 | 1175.7 | 9502.0 |
| 2011-08-14 19:00:00 | ES | Futures | 1175.45 | 1182.18 | 1175.2 | 1180.94 | 7859.0 |
| 2011-08-14 20:00:00 | ES | Futures | 1180.94 | 1183.68 | 1180.19 | 1182.43 | 7093.0 |
| 2011-08-14 21:00:00 | ES | Futures | 1182.18 | 1183.43 | 1180.44 | 1180.69 | 4750.0 |
| 2011-08-14 22:00:00 | ES | Futures | 1180.69 | 1181.43 | 1179.44 | 1180.19 | 3787.0 |
| 2011-08-14 23:00:00 | ES | Futures | 1179.94 | 1181.43 | 1178.44 | 1180.19 | 3485.0 |
| 2011-08-14 18:00:00 | NQ | Futures | 2513.63 | 2514.78 | 2505.86 | 2508.16 | 1662.0 |
| 2011-08-14 19:00:00 | NQ | Futures | 2507.87 | 2522.84 | 2507.87 | 2519.96 | 605.0 |
| 2011-08-14 20:00:00 | NQ | Futures | 2520.54 | 2526.0 | 2517.66 | 2522.55 | 808.0 |
| 2011-08-14 21:00:00 | NQ | Futures | 2522.55 | 2524.56 | 2517.95 | 2519.1 | 258.0 |
| 2011-08-14 22:00:00 | NQ | Futures | 2519.1 | 2521.69 | 2517.37 | 2519.1 | 451.0 |
| 2011-08-14 23:00:00 | NQ | Futures | 2519.1 | 2521.97 | 2515.36 | 2519.67 | 542.0 |
| 2011-08-14 18:00:00 | YM | Futures | 10911.9 | 10924.5 | 10887.7 | 10894.5 | 743.0 |
| 2011-08-14 19:00:00 | YM | Futures | 10894.5 | 10949.7 | 10894.5 | 10938.1 | 634.0 |
| 2011-08-14 20:00:00 | YM | Futures | 10941.9 | 10969.1 | 10941.9 | 10959.4 | 553.0 |
| 2011-08-14 21:00:00 | YM | Futures | 10958.4 | 10963.2 | 10939.0 | 10944.8 | 223.0 |
| 2011-08-14 22:00:00 | YM | Futures | 10942.9 | 10946.8 | 10932.3 | 10935.2 | 243.0 |
| 2011-08-14 23:00:00 | YM | Futures | 10934.2 | 10946.8 | 10922.6 | 10939.0 | 374.0 |
| 2011-08-14 18:00:00 | CL | Futures | 145.54 | 145.54 | 144.42 | 145.22 | 80.0 |
| 2011-08-14 19:00:00 | CL | Futures | 145.37 | 145.39 | 145.25 | 145.32 | 37.0 |
| 2011-08-14 20:00:00 | CL | Futures | 145.28 | 145.59 | 145.22 | 145.3 | 318.0 |
| 2011-08-14 21:00:00 | CL | Futures | 145.59 | 145.62 | 145.1 | 145.22 | 182.0 |
| 2011-08-14 22:00:00 | CL | Futures | 145.15 | 145.25 | 145.11 | 145.17 | 35.0 |
| 2011-08-14 23:00:00 | CL | Futures | 145.3 | 145.37 | 145.28 | 145.32 | 124.0 |
| 2011-08-14 18:00:00 | GC | Futures | 2433.0 | 2437.7 | 2426.7 | 2427.4 | 1723.0 |
| 2011-08-14 19:00:00 | GC | Futures | 2427.3 | 2428.5 | 2414.9 | 2417.1 | 2535.0 |
| 2011-08-14 20:00:00 | GC | Futures | 2417.4 | 2421.6 | 2410.3 | 2420.2 | 3928.0 |
| 2011-08-14 21:00:00 | GC | Futures | 2420.1 | 2434.7 | 2419.8 | 2433.0 | 3810.0 |
| 2011-08-14 22:00:00 | GC | Futures | 2432.6 | 2436.2 | 2431.8 | 2433.1 | 2535.0 |
| 2011-08-14 23:00:00 | GC | Futures | 2432.9 | 2435.8 | 2427.7 | 2428.8 | 1675.0 |
| 2011-08-14 18:00:00 | ZN | Futures | 111.688139 | 111.715046 | 111.580514 | 111.701592 | 2390.0 |
| 2011-08-14 19:00:00 | ZN | Futures | 111.701592 | 111.715046 | 111.634327 | 111.634327 | 3290.0 |
| 2011-08-14 20:00:00 | ZN | Futures | 111.634327 | 111.634327 | 111.567061 | 111.567061 | 6728.0 |
| 2011-08-14 21:00:00 | ZN | Futures | 111.580514 | 111.620874 | 111.567061 | 111.620874 | 2513.0 |
| 2011-08-14 22:00:00 | ZN | Futures | 111.620874 | 111.701592 | 111.620874 | 111.634327 | 2379.0 |
| 2011-08-14 23:00:00 | ZN | Futures | 111.634327 | 111.701592 | 111.60742 | 111.64778 | 3595.0 |
> showing 36 of 257 rows — these rows as CSV