PREVIEW / futures_1hour / 2014-09-14
file: by_date/futures_1hour/2014/2014-09-14.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 |
|---|---|---|---|---|---|---|---|
| 2014-09-14 18:00:00 | ES | Futures | 2068.23 | 2069.8 | 2062.21 | 2064.04 | 17849.0 |
| 2014-09-14 19:00:00 | ES | Futures | 2064.3 | 2064.56 | 2063.26 | 2063.52 | 4350.0 |
| 2014-09-14 20:00:00 | ES | Futures | 2063.78 | 2064.83 | 2063.26 | 2063.78 | 5817.0 |
| 2014-09-14 21:00:00 | ES | Futures | 2063.78 | 2064.83 | 2063.52 | 2063.52 | 3898.0 |
| 2014-09-14 22:00:00 | ES | Futures | 2063.52 | 2065.09 | 2063.26 | 2064.56 | 4997.0 |
| 2014-09-14 23:00:00 | ES | Futures | 2064.56 | 2064.56 | 2063.52 | 2063.78 | 3809.0 |
| 2014-09-14 18:00:00 | NQ | Futures | 4748.45 | 4752.26 | 4729.11 | 4742.88 | 3843.0 |
| 2014-09-14 19:00:00 | NQ | Futures | 4743.18 | 4744.64 | 4741.42 | 4742.0 | 667.0 |
| 2014-09-14 20:00:00 | NQ | Futures | 4742.3 | 4745.23 | 4741.71 | 4742.59 | 836.0 |
| 2014-09-14 21:00:00 | NQ | Futures | 4742.88 | 4746.11 | 4742.88 | 4743.18 | 1058.0 |
| 2014-09-14 22:00:00 | NQ | Futures | 4743.47 | 4746.11 | 4742.59 | 4745.23 | 712.0 |
| 2014-09-14 23:00:00 | NQ | Futures | 4745.23 | 4745.52 | 4742.59 | 4742.59 | 417.0 |
| 2014-09-14 18:00:00 | YM | Futures | 17547.0 | 17567.8 | 17508.6 | 17520.0 | 2463.0 |
| 2014-09-14 19:00:00 | YM | Futures | 17520.0 | 17523.1 | 17513.8 | 17516.9 | 709.0 |
| 2014-09-14 20:00:00 | YM | Futures | 17517.9 | 17525.2 | 17514.8 | 17517.9 | 963.0 |
| 2014-09-14 21:00:00 | YM | Futures | 17516.9 | 17529.4 | 17516.9 | 17517.9 | 657.0 |
| 2014-09-14 22:00:00 | YM | Futures | 17516.9 | 17529.4 | 17515.9 | 17525.2 | 831.0 |
| 2014-09-14 23:00:00 | YM | Futures | 17525.2 | 17525.2 | 17517.9 | 17520.0 | 812.0 |
| 2014-09-14 18:00:00 | CL | Futures | 151.99 | 152.33 | 151.38 | 151.56 | 369.0 |
| 2014-09-14 19:00:00 | CL | Futures | 151.56 | 151.56 | 149.53 | 150.0 | 1515.0 |
| 2014-09-14 20:00:00 | CL | Futures | 150.0 | 150.51 | 149.95 | 150.48 | 651.0 |
| 2014-09-14 21:00:00 | CL | Futures | 150.48 | 150.63 | 150.36 | 150.53 | 281.0 |
| 2014-09-14 22:00:00 | CL | Futures | 150.53 | 150.55 | 150.26 | 150.48 | 169.0 |
| 2014-09-14 23:00:00 | CL | Futures | 150.48 | 150.81 | 150.45 | 150.65 | 521.0 |
| 2014-09-14 18:00:00 | GC | Futures | 1681.5 | 1684.4 | 1678.7 | 1680.8 | 3091.0 |
| 2014-09-14 19:00:00 | GC | Futures | 1680.7 | 1683.0 | 1679.3 | 1682.2 | 1056.0 |
| 2014-09-14 20:00:00 | GC | Futures | 1682.4 | 1683.8 | 1681.6 | 1682.3 | 1114.0 |
| 2014-09-14 21:00:00 | GC | Futures | 1682.3 | 1688.2 | 1682.2 | 1686.8 | 3038.0 |
| 2014-09-14 22:00:00 | GC | Futures | 1686.7 | 1689.6 | 1686.4 | 1689.3 | 1454.0 |
| 2014-09-14 23:00:00 | GC | Futures | 1689.4 | 1691.3 | 1688.7 | 1689.8 | 2249.0 |
| 2014-09-14 18:00:00 | ZN | Futures | 117.388576 | 117.432935 | 117.37379 | 117.418149 | 5620.0 |
| 2014-09-14 19:00:00 | ZN | Futures | 117.403363 | 117.418149 | 117.37379 | 117.418149 | 1953.0 |
| 2014-09-14 20:00:00 | ZN | Futures | 117.403363 | 117.418149 | 117.37379 | 117.418149 | 3286.0 |
| 2014-09-14 21:00:00 | ZN | Futures | 117.403363 | 117.432935 | 117.403363 | 117.403363 | 2807.0 |
| 2014-09-14 22:00:00 | ZN | Futures | 117.403363 | 117.432935 | 117.403363 | 117.418149 | 1874.0 |
| 2014-09-14 23:00:00 | ZN | Futures | 117.418149 | 117.432935 | 117.403363 | 117.418149 | 1993.0 |
> showing 36 of 275 rows — these rows as CSV