PREVIEW / futures_1hour / 2014-04-27
file: by_date/futures_1hour/2014/2014-04-27.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 |
|---|---|---|---|---|---|---|---|
| 2014-04-27 18:00:00 | ES | Futures | 1933.77 | 1934.03 | 1931.95 | 1933.51 | 6516.0 |
| 2014-04-27 19:00:00 | ES | Futures | 1933.51 | 1935.07 | 1932.21 | 1932.47 | 4943.0 |
| 2014-04-27 20:00:00 | ES | Futures | 1932.73 | 1932.99 | 1929.88 | 1930.4 | 6238.0 |
| 2014-04-27 21:00:00 | ES | Futures | 1930.14 | 1931.69 | 1930.14 | 1930.91 | 3535.0 |
| 2014-04-27 22:00:00 | ES | Futures | 1931.17 | 1933.25 | 1931.17 | 1933.25 | 3335.0 |
| 2014-04-27 23:00:00 | ES | Futures | 1933.25 | 1933.51 | 1932.73 | 1932.73 | 1710.0 |
| 2014-04-27 18:00:00 | NQ | Futures | 4119.05 | 4119.34 | 4111.77 | 4114.39 | 1440.0 |
| 2014-04-27 19:00:00 | NQ | Futures | 4114.39 | 4117.01 | 4109.73 | 4111.48 | 840.0 |
| 2014-04-27 20:00:00 | NQ | Futures | 4112.06 | 4112.06 | 4104.49 | 4105.65 | 1300.0 |
| 2014-04-27 21:00:00 | NQ | Futures | 4105.94 | 4107.98 | 4105.36 | 4106.53 | 1445.0 |
| 2014-04-27 22:00:00 | NQ | Futures | 4106.82 | 4111.48 | 4106.53 | 4111.48 | 760.0 |
| 2014-04-27 23:00:00 | NQ | Futures | 4111.48 | 4112.35 | 4110.6 | 4111.77 | 491.0 |
| 2014-04-27 18:00:00 | YM | Futures | 16817.6 | 16828.9 | 16806.3 | 16815.5 | 824.0 |
| 2014-04-27 19:00:00 | YM | Futures | 16815.5 | 16824.8 | 16804.2 | 16807.3 | 357.0 |
| 2014-04-27 20:00:00 | YM | Futures | 16809.4 | 16809.4 | 16788.8 | 16791.9 | 765.0 |
| 2014-04-27 21:00:00 | YM | Futures | 16793.9 | 16806.3 | 16793.9 | 16801.1 | 671.0 |
| 2014-04-27 22:00:00 | YM | Futures | 16802.2 | 16814.5 | 16800.1 | 16813.5 | 537.0 |
| 2014-04-27 23:00:00 | YM | Futures | 16815.5 | 16818.6 | 16811.4 | 16814.5 | 362.0 |
| 2014-04-27 18:00:00 | CL | Futures | 161.18 | 161.82 | 161.18 | 161.74 | 1271.0 |
| 2014-04-27 19:00:00 | CL | Futures | 161.71 | 161.76 | 161.57 | 161.6 | 412.0 |
| 2014-04-27 20:00:00 | CL | Futures | 161.61 | 161.79 | 161.61 | 161.76 | 654.0 |
| 2014-04-27 21:00:00 | CL | Futures | 161.76 | 161.92 | 161.76 | 161.87 | 841.0 |
| 2014-04-27 22:00:00 | CL | Futures | 161.87 | 161.89 | 161.74 | 161.77 | 442.0 |
| 2014-04-27 23:00:00 | CL | Futures | 161.77 | 162.13 | 161.76 | 162.05 | 1461.0 |
| 2014-04-27 18:00:00 | GC | Futures | 1785.2 | 1788.4 | 1784.3 | 1785.0 | 1751.0 |
| 2014-04-27 19:00:00 | GC | Futures | 1785.0 | 1786.6 | 1785.0 | 1786.3 | 581.0 |
| 2014-04-27 20:00:00 | GC | Futures | 1786.6 | 1787.8 | 1784.7 | 1785.4 | 1765.0 |
| 2014-04-27 21:00:00 | GC | Futures | 1785.4 | 1789.9 | 1784.8 | 1788.5 | 4194.0 |
| 2014-04-27 22:00:00 | GC | Futures | 1788.3 | 1788.7 | 1787.2 | 1787.4 | 1482.0 |
| 2014-04-27 23:00:00 | GC | Futures | 1787.6 | 1787.6 | 1786.1 | 1786.5 | 1120.0 |
| 2014-04-27 18:00:00 | ZN | Futures | 116.148132 | 116.177388 | 116.133504 | 116.148132 | 3271.0 |
| 2014-04-27 19:00:00 | ZN | Futures | 116.148132 | 116.16276 | 116.118876 | 116.133504 | 3388.0 |
| 2014-04-27 20:00:00 | ZN | Futures | 116.133504 | 116.133504 | 116.074991 | 116.118876 | 7790.0 |
| 2014-04-27 21:00:00 | ZN | Futures | 116.104247 | 116.118876 | 116.060363 | 116.074991 | 2901.0 |
| 2014-04-27 22:00:00 | ZN | Futures | 116.074991 | 116.104247 | 116.060363 | 116.089619 | 2835.0 |
| 2014-04-27 23:00:00 | ZN | Futures | 116.074991 | 116.089619 | 116.074991 | 116.074991 | 987.0 |
> showing 36 of 270 rows — these rows as CSV