PREVIEW / futures_1hour / 2012-07-08
file: by_date/futures_1hour/2012/2012-07-08.parquet size: 14 KB rows: 272
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-07-08 18:00:00 | ES | Futures | 1372.37 | 1372.88 | 1371.1 | 1371.6 | 12671.0 |
| 2012-07-08 19:00:00 | ES | Futures | 1371.6 | 1371.86 | 1370.84 | 1371.1 | 3690.0 |
| 2012-07-08 20:00:00 | ES | Futures | 1371.1 | 1372.11 | 1370.59 | 1371.6 | 5797.0 |
| 2012-07-08 21:00:00 | ES | Futures | 1371.35 | 1373.13 | 1370.33 | 1372.62 | 5885.0 |
| 2012-07-08 22:00:00 | ES | Futures | 1372.88 | 1373.38 | 1371.86 | 1372.62 | 3785.0 |
| 2012-07-08 23:00:00 | ES | Futures | 1372.37 | 1372.37 | 1369.82 | 1371.35 | 4885.0 |
| 2012-07-08 18:00:00 | NQ | Futures | 3017.7 | 3021.47 | 3017.7 | 3018.86 | 578.0 |
| 2012-07-08 19:00:00 | NQ | Futures | 3019.15 | 3020.02 | 3017.7 | 3017.99 | 214.0 |
| 2012-07-08 20:00:00 | NQ | Futures | 3017.99 | 3020.89 | 3017.12 | 3018.86 | 348.0 |
| 2012-07-08 21:00:00 | NQ | Futures | 3018.86 | 3022.63 | 3016.54 | 3022.63 | 586.0 |
| 2012-07-08 22:00:00 | NQ | Futures | 3022.05 | 3023.21 | 3020.02 | 3021.47 | 573.0 |
| 2012-07-08 23:00:00 | NQ | Futures | 3021.47 | 3021.47 | 3015.67 | 3018.86 | 520.0 |
| 2012-07-08 18:00:00 | YM | Futures | 12636.9 | 12638.9 | 12622.0 | 12627.9 | 353.0 |
| 2012-07-08 19:00:00 | YM | Futures | 12627.9 | 12632.9 | 12622.9 | 12626.9 | 183.0 |
| 2012-07-08 20:00:00 | YM | Futures | 12625.9 | 12633.9 | 12622.9 | 12628.9 | 392.0 |
| 2012-07-08 21:00:00 | YM | Futures | 12627.9 | 12645.8 | 12622.0 | 12641.8 | 571.0 |
| 2012-07-08 22:00:00 | YM | Futures | 12642.8 | 12648.8 | 12636.9 | 12643.8 | 509.0 |
| 2012-07-08 23:00:00 | YM | Futures | 12642.8 | 12642.8 | 12622.9 | 12633.9 | 575.0 |
| 2012-07-08 18:00:00 | CL | Futures | 138.97 | 139.33 | 138.64 | 139.3 | 1557.0 |
| 2012-07-08 19:00:00 | CL | Futures | 139.3 | 139.4 | 139.14 | 139.25 | 801.0 |
| 2012-07-08 20:00:00 | CL | Futures | 139.25 | 139.51 | 139.2 | 139.48 | 1167.0 |
| 2012-07-08 21:00:00 | CL | Futures | 139.5 | 140.16 | 139.42 | 139.98 | 1189.0 |
| 2012-07-08 22:00:00 | CL | Futures | 140.01 | 140.34 | 140.01 | 140.21 | 1263.0 |
| 2012-07-08 23:00:00 | CL | Futures | 140.22 | 140.26 | 139.89 | 140.16 | 856.0 |
| 2012-07-08 18:00:00 | GC | Futures | 2189.6 | 2190.5 | 2184.9 | 2186.6 | 760.0 |
| 2012-07-08 19:00:00 | GC | Futures | 2186.7 | 2186.7 | 2180.8 | 2184.8 | 809.0 |
| 2012-07-08 20:00:00 | GC | Futures | 2184.5 | 2188.7 | 2183.7 | 2188.0 | 2051.0 |
| 2012-07-08 21:00:00 | GC | Futures | 2188.1 | 2191.4 | 2186.7 | 2190.8 | 2323.0 |
| 2012-07-08 22:00:00 | GC | Futures | 2190.8 | 2191.6 | 2184.9 | 2189.2 | 2717.0 |
| 2012-07-08 23:00:00 | GC | Futures | 2189.1 | 2189.5 | 2186.5 | 2188.8 | 871.0 |
| 2012-07-08 18:00:00 | ZN | Futures | 118.268431 | 118.295938 | 118.240923 | 118.268431 | 2765.0 |
| 2012-07-08 19:00:00 | ZN | Futures | 118.268431 | 118.309692 | 118.254677 | 118.295938 | 1466.0 |
| 2012-07-08 20:00:00 | ZN | Futures | 118.295938 | 118.295938 | 118.268431 | 118.282184 | 1240.0 |
| 2012-07-08 21:00:00 | ZN | Futures | 118.268431 | 118.295938 | 118.254677 | 118.254677 | 2661.0 |
| 2012-07-08 22:00:00 | ZN | Futures | 118.268431 | 118.282184 | 118.240923 | 118.240923 | 1498.0 |
| 2012-07-08 23:00:00 | ZN | Futures | 118.240923 | 118.309692 | 118.240923 | 118.309692 | 2353.0 |
> showing 36 of 272 rows — these rows as CSV