PREVIEW / futures_1hour / 2012-04-15
file: by_date/futures_1hour/2012/2012-04-15.parquet size: 14 KB rows: 273
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 |
|---|---|---|---|---|---|---|---|
| 2012-04-15 18:00:00 | ES | Futures | 1382.31 | 1382.56 | 1378.51 | 1380.54 | 10467.0 |
| 2012-04-15 19:00:00 | ES | Futures | 1380.28 | 1381.29 | 1378.51 | 1380.54 | 6084.0 |
| 2012-04-15 20:00:00 | ES | Futures | 1380.54 | 1381.8 | 1376.74 | 1376.99 | 14931.0 |
| 2012-04-15 21:00:00 | ES | Futures | 1376.99 | 1380.28 | 1376.74 | 1379.02 | 10650.0 |
| 2012-04-15 22:00:00 | ES | Futures | 1379.02 | 1379.52 | 1377.5 | 1378.51 | 3198.0 |
| 2012-04-15 23:00:00 | ES | Futures | 1378.51 | 1378.76 | 1377.25 | 1377.75 | 2305.0 |
| 2012-04-15 18:00:00 | NQ | Futures | 3117.29 | 3118.45 | 3110.06 | 3113.53 | 1225.0 |
| 2012-04-15 19:00:00 | NQ | Futures | 3113.53 | 3113.82 | 3108.04 | 3112.38 | 950.0 |
| 2012-04-15 20:00:00 | NQ | Futures | 3112.38 | 3114.69 | 3102.54 | 3105.44 | 1483.0 |
| 2012-04-15 21:00:00 | NQ | Futures | 3105.44 | 3111.8 | 3104.86 | 3108.91 | 1029.0 |
| 2012-04-15 22:00:00 | NQ | Futures | 3109.2 | 3109.77 | 3106.3 | 3108.33 | 400.0 |
| 2012-04-15 23:00:00 | NQ | Futures | 3108.33 | 3108.62 | 3106.59 | 3107.17 | 110.0 |
| 2012-04-15 18:00:00 | YM | Futures | 12742.7 | 12747.7 | 12715.8 | 12729.7 | 946.0 |
| 2012-04-15 19:00:00 | YM | Futures | 12729.7 | 12734.7 | 12714.8 | 12727.7 | 273.0 |
| 2012-04-15 20:00:00 | YM | Futures | 12729.7 | 12740.7 | 12700.8 | 12704.8 | 718.0 |
| 2012-04-15 21:00:00 | YM | Futures | 12703.8 | 12730.7 | 12702.8 | 12717.8 | 669.0 |
| 2012-04-15 22:00:00 | YM | Futures | 12718.8 | 12722.7 | 12708.8 | 12717.8 | 322.0 |
| 2012-04-15 23:00:00 | YM | Futures | 12716.8 | 12717.8 | 12707.8 | 12708.8 | 214.0 |
| 2012-04-15 18:00:00 | CL | Futures | 171.61 | 171.68 | 171.1 | 171.11 | 359.0 |
| 2012-04-15 19:00:00 | CL | Futures | 171.11 | 171.28 | 170.88 | 170.9 | 263.0 |
| 2012-04-15 20:00:00 | CL | Futures | 170.96 | 171.01 | 170.53 | 170.55 | 487.0 |
| 2012-04-15 21:00:00 | CL | Futures | 170.53 | 170.82 | 170.53 | 170.72 | 240.0 |
| 2012-04-15 22:00:00 | CL | Futures | 170.7 | 170.85 | 170.62 | 170.72 | 129.0 |
| 2012-04-15 23:00:00 | CL | Futures | 170.73 | 170.73 | 170.53 | 170.57 | 150.0 |
| 2012-04-15 18:00:00 | GC | Futures | 2298.7 | 2298.7 | 2289.7 | 2291.9 | 1628.0 |
| 2012-04-15 19:00:00 | GC | Futures | 2292.2 | 2294.7 | 2291.4 | 2291.9 | 602.0 |
| 2012-04-15 20:00:00 | GC | Futures | 2291.9 | 2292.9 | 2287.0 | 2292.8 | 2740.0 |
| 2012-04-15 21:00:00 | GC | Futures | 2292.8 | 2293.2 | 2288.6 | 2290.6 | 2262.0 |
| 2012-04-15 22:00:00 | GC | Futures | 2290.3 | 2290.7 | 2289.3 | 2290.1 | 1077.0 |
| 2012-04-15 23:00:00 | GC | Futures | 2290.1 | 2290.4 | 2288.9 | 2289.2 | 653.0 |
| 2012-04-15 18:00:00 | ZN | Futures | 115.120768 | 115.16178 | 115.107097 | 115.120768 | 3049.0 |
| 2012-04-15 19:00:00 | ZN | Futures | 115.134439 | 115.175451 | 115.079756 | 115.107097 | 7019.0 |
| 2012-04-15 20:00:00 | ZN | Futures | 115.107097 | 115.202792 | 115.079756 | 115.202792 | 13817.0 |
| 2012-04-15 21:00:00 | ZN | Futures | 115.202792 | 115.243804 | 115.120768 | 115.175451 | 10476.0 |
| 2012-04-15 22:00:00 | ZN | Futures | 115.175451 | 115.189121 | 115.148109 | 115.175451 | 3038.0 |
| 2012-04-15 23:00:00 | ZN | Futures | 115.189121 | 115.230133 | 115.175451 | 115.230133 | 5282.0 |
> showing 36 of 273 rows — these rows as CSV