PREVIEW / futures_1hour / 2013-08-18
file: by_date/futures_1hour/2013/2013-08-18.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 |
|---|---|---|---|---|---|---|---|
| 2013-08-18 18:00:00 | ES | Futures | 1707.1 | 1709.17 | 1705.55 | 1706.84 | 8423.0 |
| 2013-08-18 19:00:00 | ES | Futures | 1706.84 | 1708.91 | 1706.58 | 1708.39 | 3199.0 |
| 2013-08-18 20:00:00 | ES | Futures | 1708.65 | 1709.17 | 1707.36 | 1707.62 | 5188.0 |
| 2013-08-18 21:00:00 | ES | Futures | 1707.62 | 1709.94 | 1707.36 | 1709.43 | 6279.0 |
| 2013-08-18 22:00:00 | ES | Futures | 1709.17 | 1709.68 | 1707.62 | 1708.13 | 4694.0 |
| 2013-08-18 23:00:00 | ES | Futures | 1707.88 | 1709.17 | 1707.1 | 1707.36 | 2923.0 |
| 2013-08-18 18:00:00 | NQ | Futures | 3586.9 | 3590.7 | 3577.26 | 3586.32 | 842.0 |
| 2013-08-18 19:00:00 | NQ | Futures | 3586.32 | 3590.12 | 3586.03 | 3589.24 | 289.0 |
| 2013-08-18 20:00:00 | NQ | Futures | 3589.83 | 3591.29 | 3588.36 | 3588.36 | 814.0 |
| 2013-08-18 21:00:00 | NQ | Futures | 3588.07 | 3593.04 | 3587.49 | 3592.16 | 626.0 |
| 2013-08-18 22:00:00 | NQ | Futures | 3591.87 | 3593.04 | 3589.83 | 3590.99 | 557.0 |
| 2013-08-18 23:00:00 | NQ | Futures | 3590.99 | 3592.16 | 3588.95 | 3589.53 | 336.0 |
| 2013-08-18 18:00:00 | YM | Futures | 15275.8 | 15293.1 | 15266.7 | 15275.8 | 679.0 |
| 2013-08-18 19:00:00 | YM | Futures | 15275.8 | 15289.1 | 15274.8 | 15289.1 | 421.0 |
| 2013-08-18 20:00:00 | YM | Futures | 15289.1 | 15292.1 | 15280.9 | 15280.9 | 847.0 |
| 2013-08-18 21:00:00 | YM | Futures | 15281.9 | 15297.2 | 15276.9 | 15293.1 | 893.0 |
| 2013-08-18 22:00:00 | YM | Futures | 15293.1 | 15295.1 | 15283.0 | 15286.0 | 631.0 |
| 2013-08-18 23:00:00 | YM | Futures | 15286.0 | 15292.1 | 15278.9 | 15280.9 | 371.0 |
| 2013-08-18 18:00:00 | CL | Futures | 169.82 | 169.87 | 168.95 | 169.05 | 1002.0 |
| 2013-08-18 19:00:00 | CL | Futures | 169.03 | 169.4 | 168.81 | 169.25 | 964.0 |
| 2013-08-18 20:00:00 | CL | Futures | 169.29 | 169.38 | 169.13 | 169.35 | 616.0 |
| 2013-08-18 21:00:00 | CL | Futures | 169.33 | 169.52 | 169.1 | 169.4 | 836.0 |
| 2013-08-18 22:00:00 | CL | Futures | 169.38 | 169.46 | 169.19 | 169.25 | 910.0 |
| 2013-08-18 23:00:00 | CL | Futures | 169.24 | 169.51 | 169.18 | 169.38 | 800.0 |
| 2013-08-18 18:00:00 | GC | Futures | 1887.7 | 1892.8 | 1885.6 | 1886.2 | 2321.0 |
| 2013-08-18 19:00:00 | GC | Futures | 1886.2 | 1888.6 | 1884.4 | 1886.7 | 679.0 |
| 2013-08-18 20:00:00 | GC | Futures | 1886.6 | 1888.6 | 1884.9 | 1886.6 | 1682.0 |
| 2013-08-18 21:00:00 | GC | Futures | 1886.6 | 1897.3 | 1885.6 | 1893.9 | 5406.0 |
| 2013-08-18 22:00:00 | GC | Futures | 1893.7 | 1895.1 | 1892.1 | 1893.3 | 2181.0 |
| 2013-08-18 23:00:00 | GC | Futures | 1893.2 | 1894.4 | 1890.0 | 1892.1 | 2784.0 |
| 2013-08-18 18:00:00 | ZN | Futures | 113.222064 | 113.222064 | 113.052253 | 113.094706 | 7152.0 |
| 2013-08-18 19:00:00 | ZN | Futures | 113.094706 | 113.123008 | 113.066404 | 113.066404 | 4717.0 |
| 2013-08-18 20:00:00 | ZN | Futures | 113.066404 | 113.080555 | 113.023951 | 113.066404 | 5620.0 |
| 2013-08-18 21:00:00 | ZN | Futures | 113.066404 | 113.108857 | 113.0098 | 113.023951 | 6756.0 |
| 2013-08-18 22:00:00 | ZN | Futures | 113.038102 | 113.038102 | 112.995649 | 112.995649 | 7159.0 |
| 2013-08-18 23:00:00 | ZN | Futures | 113.0098 | 113.0098 | 112.896592 | 112.924894 | 11686.0 |
> showing 36 of 266 rows — these rows as CSV