PREVIEW / futures_1hour / 2012-10-28
file: by_date/futures_1hour/2012/2012-10-28.parquet size: 14 KB rows: 270
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-10-28 18:00:00 | ES | Futures | 1436.98 | 1437.75 | 1433.41 | 1433.41 | 7036.0 |
| 2012-10-28 19:00:00 | ES | Futures | 1433.66 | 1434.17 | 1431.87 | 1433.66 | 5850.0 |
| 2012-10-28 20:00:00 | ES | Futures | 1433.66 | 1435.96 | 1433.41 | 1433.66 | 6548.0 |
| 2012-10-28 21:00:00 | ES | Futures | 1433.92 | 1435.71 | 1433.66 | 1435.45 | 5292.0 |
| 2012-10-28 22:00:00 | ES | Futures | 1435.71 | 1436.98 | 1435.2 | 1436.22 | 4360.0 |
| 2012-10-28 23:00:00 | ES | Futures | 1436.22 | 1436.47 | 1432.64 | 1434.68 | 6040.0 |
| 2012-10-28 18:00:00 | NQ | Futures | 3085.34 | 3089.99 | 3081.27 | 3081.27 | 793.0 |
| 2012-10-28 19:00:00 | NQ | Futures | 3081.27 | 3082.72 | 3077.2 | 3081.85 | 744.0 |
| 2012-10-28 20:00:00 | NQ | Futures | 3081.56 | 3085.92 | 3079.53 | 3080.69 | 870.0 |
| 2012-10-28 21:00:00 | NQ | Futures | 3080.69 | 3084.47 | 3080.11 | 3083.89 | 602.0 |
| 2012-10-28 22:00:00 | NQ | Futures | 3084.18 | 3087.66 | 3083.6 | 3085.34 | 577.0 |
| 2012-10-28 23:00:00 | NQ | Futures | 3085.63 | 3086.21 | 3078.66 | 3080.98 | 685.0 |
| 2012-10-28 18:00:00 | YM | Futures | 13054.7 | 13054.7 | 13024.7 | 13024.7 | 479.0 |
| 2012-10-28 19:00:00 | YM | Futures | 13023.7 | 13029.7 | 13012.7 | 13026.7 | 504.0 |
| 2012-10-28 20:00:00 | YM | Futures | 13027.7 | 13041.7 | 13019.7 | 13025.7 | 717.0 |
| 2012-10-28 21:00:00 | YM | Futures | 13024.7 | 13041.7 | 13024.7 | 13037.7 | 609.0 |
| 2012-10-28 22:00:00 | YM | Futures | 13039.7 | 13048.7 | 13034.7 | 13043.7 | 590.0 |
| 2012-10-28 23:00:00 | YM | Futures | 13043.7 | 13043.7 | 13017.7 | 13028.7 | 633.0 |
| 2012-10-28 18:00:00 | CL | Futures | 140.44 | 140.44 | 139.39 | 139.42 | 1444.0 |
| 2012-10-28 19:00:00 | CL | Futures | 139.4 | 139.71 | 139.39 | 139.66 | 616.0 |
| 2012-10-28 20:00:00 | CL | Futures | 139.66 | 139.91 | 139.5 | 139.62 | 1309.0 |
| 2012-10-28 21:00:00 | CL | Futures | 139.62 | 139.81 | 139.49 | 139.76 | 642.0 |
| 2012-10-28 22:00:00 | CL | Futures | 139.79 | 139.91 | 139.75 | 139.84 | 530.0 |
| 2012-10-28 23:00:00 | CL | Futures | 139.83 | 139.84 | 139.4 | 139.63 | 1124.0 |
| 2012-10-28 18:00:00 | GC | Futures | 2362.0 | 2364.5 | 2360.1 | 2362.2 | 1287.0 |
| 2012-10-28 19:00:00 | GC | Futures | 2362.3 | 2365.5 | 2361.2 | 2365.2 | 834.0 |
| 2012-10-28 20:00:00 | GC | Futures | 2365.3 | 2368.2 | 2365.1 | 2365.5 | 1861.0 |
| 2012-10-28 21:00:00 | GC | Futures | 2365.9 | 2367.0 | 2364.8 | 2366.7 | 1818.0 |
| 2012-10-28 22:00:00 | GC | Futures | 2366.6 | 2367.3 | 2364.8 | 2365.9 | 1245.0 |
| 2012-10-28 23:00:00 | GC | Futures | 2365.9 | 2366.2 | 2363.4 | 2364.4 | 1387.0 |
| 2012-10-28 18:00:00 | ZN | Futures | 117.715973 | 117.771427 | 117.674382 | 117.7437 | 11141.0 |
| 2012-10-28 19:00:00 | ZN | Futures | 117.729836 | 117.813018 | 117.688245 | 117.702109 | 16171.0 |
| 2012-10-28 20:00:00 | ZN | Futures | 117.702109 | 117.702109 | 117.632791 | 117.688245 | 12839.0 |
| 2012-10-28 21:00:00 | ZN | Futures | 117.674382 | 117.688245 | 117.660518 | 117.660518 | 2677.0 |
| 2012-10-28 22:00:00 | ZN | Futures | 117.660518 | 117.660518 | 117.605064 | 117.646654 | 6766.0 |
| 2012-10-28 23:00:00 | ZN | Futures | 117.646654 | 117.660518 | 117.605064 | 117.618927 | 7573.0 |
> showing 36 of 270 rows — these rows as CSV