PREVIEW / futures_1hour / 2014-04-20
file: by_date/futures_1hour/2014/2014-04-20.parquet size: 14 KB rows: 266
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-20 18:00:00 | ES | Futures | 1931.17 | 1933.77 | 1930.14 | 1933.51 | 5519.0 |
| 2014-04-20 19:00:00 | ES | Futures | 1933.77 | 1934.81 | 1932.21 | 1933.77 | 3515.0 |
| 2014-04-20 20:00:00 | ES | Futures | 1934.03 | 1934.29 | 1932.73 | 1933.25 | 3159.0 |
| 2014-04-20 21:00:00 | ES | Futures | 1932.99 | 1933.77 | 1932.21 | 1932.73 | 1909.0 |
| 2014-04-20 22:00:00 | ES | Futures | 1932.99 | 1933.77 | 1931.17 | 1931.43 | 3273.0 |
| 2014-04-20 23:00:00 | ES | Futures | 1931.43 | 1932.47 | 1931.17 | 1932.21 | 961.0 |
| 2014-04-20 18:00:00 | NQ | Futures | 4106.23 | 4117.01 | 4105.07 | 4115.55 | 707.0 |
| 2014-04-20 19:00:00 | NQ | Futures | 4115.55 | 4118.47 | 4113.81 | 4116.14 | 378.0 |
| 2014-04-20 20:00:00 | NQ | Futures | 4115.55 | 4117.3 | 4114.1 | 4114.39 | 425.0 |
| 2014-04-20 21:00:00 | NQ | Futures | 4114.68 | 4115.26 | 4110.89 | 4112.06 | 597.0 |
| 2014-04-20 22:00:00 | NQ | Futures | 4112.06 | 4116.43 | 4111.48 | 4113.22 | 959.0 |
| 2014-04-20 23:00:00 | NQ | Futures | 4113.22 | 4115.84 | 4113.22 | 4115.55 | 317.0 |
| 2014-04-20 18:00:00 | YM | Futures | 16834.1 | 16862.9 | 16834.1 | 16861.9 | 991.0 |
| 2014-04-20 19:00:00 | YM | Futures | 16862.9 | 16870.1 | 16853.7 | 16867.0 | 383.0 |
| 2014-04-20 20:00:00 | YM | Futures | 16864.0 | 16868.1 | 16855.7 | 16860.9 | 412.0 |
| 2014-04-20 21:00:00 | YM | Futures | 16858.8 | 16865.0 | 16852.6 | 16857.8 | 280.0 |
| 2014-04-20 22:00:00 | YM | Futures | 16857.8 | 16862.9 | 16844.4 | 16845.4 | 568.0 |
| 2014-04-20 23:00:00 | YM | Futures | 16845.4 | 16852.6 | 16843.4 | 16850.6 | 179.0 |
| 2014-04-20 18:00:00 | CL | Futures | 166.33 | 166.44 | 165.98 | 166.01 | 750.0 |
| 2014-04-20 19:00:00 | CL | Futures | 166.01 | 166.01 | 165.77 | 165.8 | 549.0 |
| 2014-04-20 20:00:00 | CL | Futures | 165.8 | 165.85 | 165.61 | 165.67 | 778.0 |
| 2014-04-20 21:00:00 | CL | Futures | 165.69 | 165.69 | 165.3 | 165.56 | 1306.0 |
| 2014-04-20 22:00:00 | CL | Futures | 165.53 | 165.54 | 165.38 | 165.48 | 505.0 |
| 2014-04-20 23:00:00 | CL | Futures | 165.48 | 165.57 | 165.41 | 165.49 | 306.0 |
| 2014-04-20 18:00:00 | GC | Futures | 1773.9 | 1775.4 | 1767.6 | 1772.6 | 2819.0 |
| 2014-04-20 19:00:00 | GC | Futures | 1772.5 | 1772.8 | 1768.8 | 1769.4 | 1351.0 |
| 2014-04-20 20:00:00 | GC | Futures | 1769.2 | 1784.3 | 1769.2 | 1778.5 | 6060.0 |
| 2014-04-20 21:00:00 | GC | Futures | 1778.4 | 1779.1 | 1760.9 | 1762.6 | 12887.0 |
| 2014-04-20 22:00:00 | GC | Futures | 1762.5 | 1765.9 | 1755.9 | 1759.5 | 8119.0 |
| 2014-04-20 23:00:00 | GC | Futures | 1759.5 | 1763.7 | 1759.1 | 1761.7 | 2233.0 |
| 2014-04-20 18:00:00 | ZN | Futures | 115.826311 | 115.870196 | 115.811683 | 115.840939 | 2406.0 |
| 2014-04-20 19:00:00 | ZN | Futures | 115.855567 | 115.870196 | 115.811683 | 115.826311 | 5866.0 |
| 2014-04-20 20:00:00 | ZN | Futures | 115.826311 | 115.91408 | 115.826311 | 115.899452 | 7971.0 |
| 2014-04-20 21:00:00 | ZN | Futures | 115.899452 | 115.943337 | 115.899452 | 115.91408 | 6025.0 |
| 2014-04-20 22:00:00 | ZN | Futures | 115.91408 | 115.943337 | 115.899452 | 115.928709 | 3980.0 |
| 2014-04-20 23:00:00 | ZN | Futures | 115.928709 | 115.972593 | 115.91408 | 115.957965 | 6920.0 |
> showing 36 of 266 rows — these rows as CSV