PREVIEW / futures_1hour / 2014-01-26
file: by_date/futures_1hour/2014/2014-01-26.parquet size: 14 KB rows: 277
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-01-26 18:00:00 | ES | Futures | 1843.42 | 1844.72 | 1837.73 | 1842.39 | 31783.0 |
| 2014-01-26 19:00:00 | ES | Futures | 1842.13 | 1845.75 | 1839.8 | 1845.75 | 16335.0 |
| 2014-01-26 20:00:00 | ES | Futures | 1845.75 | 1846.27 | 1843.16 | 1846.01 | 11981.0 |
| 2014-01-26 21:00:00 | ES | Futures | 1846.01 | 1847.56 | 1844.97 | 1847.3 | 10301.0 |
| 2014-01-26 22:00:00 | ES | Futures | 1847.56 | 1847.56 | 1844.2 | 1846.78 | 6778.0 |
| 2014-01-26 23:00:00 | ES | Futures | 1847.04 | 1849.37 | 1846.53 | 1848.34 | 8601.0 |
| 2014-01-26 18:00:00 | NQ | Futures | 4106.5 | 4108.25 | 4093.13 | 4103.02 | 4160.0 |
| 2014-01-26 19:00:00 | NQ | Futures | 4102.72 | 4111.74 | 4098.07 | 4110.57 | 1895.0 |
| 2014-01-26 20:00:00 | NQ | Futures | 4110.28 | 4112.32 | 4105.63 | 4110.28 | 1864.0 |
| 2014-01-26 21:00:00 | NQ | Futures | 4110.57 | 4114.64 | 4109.12 | 4114.06 | 1437.0 |
| 2014-01-26 22:00:00 | NQ | Futures | 4113.77 | 4113.77 | 4103.6 | 4109.7 | 1690.0 |
| 2014-01-26 23:00:00 | NQ | Futures | 4109.99 | 4114.64 | 4108.25 | 4112.32 | 989.0 |
| 2014-01-26 18:00:00 | YM | Futures | 16202.4 | 16218.8 | 16143.9 | 16179.8 | 5851.0 |
| 2014-01-26 19:00:00 | YM | Futures | 16179.8 | 16207.5 | 16156.2 | 16206.5 | 2464.0 |
| 2014-01-26 20:00:00 | YM | Futures | 16205.5 | 16208.5 | 16183.9 | 16207.5 | 2038.0 |
| 2014-01-26 21:00:00 | YM | Futures | 16207.5 | 16219.8 | 16202.4 | 16219.8 | 1284.0 |
| 2014-01-26 22:00:00 | YM | Futures | 16219.8 | 16219.8 | 16194.2 | 16216.7 | 1355.0 |
| 2014-01-26 23:00:00 | YM | Futures | 16217.8 | 16234.2 | 16212.6 | 16226.0 | 1405.0 |
| 2014-01-26 18:00:00 | CL | Futures | 152.22 | 152.62 | 152.21 | 152.55 | 783.0 |
| 2014-01-26 19:00:00 | CL | Futures | 152.52 | 152.66 | 152.48 | 152.52 | 479.0 |
| 2014-01-26 20:00:00 | CL | Futures | 152.52 | 152.52 | 152.02 | 152.11 | 1058.0 |
| 2014-01-26 21:00:00 | CL | Futures | 152.13 | 152.15 | 151.8 | 151.82 | 559.0 |
| 2014-01-26 22:00:00 | CL | Futures | 151.82 | 151.97 | 151.75 | 151.91 | 557.0 |
| 2014-01-26 23:00:00 | CL | Futures | 151.91 | 151.99 | 151.85 | 151.96 | 292.0 |
| 2014-01-26 18:00:00 | GC | Futures | 1739.2 | 1753.2 | 1739.2 | 1747.0 | 1360.0 |
| 2014-01-26 19:00:00 | GC | Futures | 1746.9 | 1748.4 | 1742.5 | 1742.8 | 589.0 |
| 2014-01-26 20:00:00 | GC | Futures | 1742.9 | 1743.9 | 1740.3 | 1743.7 | 758.0 |
| 2014-01-26 21:00:00 | GC | Futures | 1743.9 | 1746.4 | 1743.1 | 1743.5 | 443.0 |
| 2014-01-26 22:00:00 | GC | Futures | 1743.5 | 1744.8 | 1741.3 | 1741.7 | 199.0 |
| 2014-01-26 23:00:00 | GC | Futures | 1742.0 | 1742.7 | 1740.5 | 1740.7 | 151.0 |
| 2014-01-26 18:00:00 | ZN | Futures | 115.767074 | 115.853759 | 115.738179 | 115.795969 | 11069.0 |
| 2014-01-26 19:00:00 | ZN | Futures | 115.795969 | 115.810416 | 115.738179 | 115.738179 | 9997.0 |
| 2014-01-26 20:00:00 | ZN | Futures | 115.752627 | 115.767074 | 115.694837 | 115.709284 | 9322.0 |
| 2014-01-26 21:00:00 | ZN | Futures | 115.709284 | 115.709284 | 115.6226 | 115.637047 | 9699.0 |
| 2014-01-26 22:00:00 | ZN | Futures | 115.651495 | 115.723732 | 115.637047 | 115.651495 | 7074.0 |
| 2014-01-26 23:00:00 | ZN | Futures | 115.665942 | 115.665942 | 115.608153 | 115.637047 | 5273.0 |
> showing 36 of 277 rows — these rows as CSV