PREVIEW / futures_1hour / 2013-12-22
file: by_date/futures_1hour/2013/2013-12-22.parquet size: 13 KB rows: 254
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-12-22 18:00:00 | ES | Futures | 1879.89 | 1883.0 | 1879.63 | 1881.96 | 6167.0 |
| 2013-12-22 19:00:00 | ES | Futures | 1882.22 | 1883.25 | 1881.96 | 1883.25 | 3050.0 |
| 2013-12-22 20:00:00 | ES | Futures | 1883.0 | 1884.81 | 1883.0 | 1883.51 | 3748.0 |
| 2013-12-22 21:00:00 | ES | Futures | 1883.51 | 1884.03 | 1882.48 | 1882.48 | 1943.0 |
| 2013-12-22 22:00:00 | ES | Futures | 1882.74 | 1883.77 | 1882.48 | 1883.51 | 1484.0 |
| 2013-12-22 23:00:00 | ES | Futures | 1883.51 | 1884.55 | 1882.74 | 1882.74 | 2006.0 |
| 2013-12-22 18:00:00 | NQ | Futures | 4117.26 | 4123.94 | 4117.26 | 4123.36 | 1259.0 |
| 2013-12-22 19:00:00 | NQ | Futures | 4123.07 | 4125.4 | 4122.78 | 4124.82 | 419.0 |
| 2013-12-22 20:00:00 | NQ | Futures | 4124.82 | 4126.85 | 4123.36 | 4124.82 | 827.0 |
| 2013-12-22 21:00:00 | NQ | Futures | 4124.82 | 4125.69 | 4123.65 | 4124.24 | 499.0 |
| 2013-12-22 22:00:00 | NQ | Futures | 4124.24 | 4125.11 | 4123.65 | 4125.11 | 159.0 |
| 2013-12-22 23:00:00 | NQ | Futures | 4125.11 | 4128.89 | 4124.53 | 4124.82 | 682.0 |
| 2013-12-22 18:00:00 | YM | Futures | 16619.7 | 16636.1 | 16619.7 | 16630.0 | 541.0 |
| 2013-12-22 19:00:00 | YM | Futures | 16629.0 | 16636.1 | 16627.9 | 16636.1 | 316.0 |
| 2013-12-22 20:00:00 | YM | Futures | 16635.1 | 16647.4 | 16632.0 | 16635.1 | 831.0 |
| 2013-12-22 21:00:00 | YM | Futures | 16635.1 | 16636.1 | 16623.8 | 16626.9 | 628.0 |
| 2013-12-22 22:00:00 | YM | Futures | 16626.9 | 16633.1 | 16626.9 | 16633.1 | 141.0 |
| 2013-12-22 23:00:00 | YM | Futures | 16633.1 | 16641.3 | 16632.0 | 16633.1 | 296.0 |
| 2013-12-22 18:00:00 | CL | Futures | 156.21 | 156.26 | 156.15 | 156.21 | 392.0 |
| 2013-12-22 19:00:00 | CL | Futures | 156.21 | 156.34 | 156.21 | 156.31 | 250.0 |
| 2013-12-22 20:00:00 | CL | Futures | 156.32 | 156.37 | 156.24 | 156.35 | 363.0 |
| 2013-12-22 21:00:00 | CL | Futures | 156.37 | 156.38 | 156.29 | 156.34 | 234.0 |
| 2013-12-22 22:00:00 | CL | Futures | 156.35 | 156.37 | 156.13 | 156.18 | 812.0 |
| 2013-12-22 23:00:00 | CL | Futures | 156.21 | 156.23 | 156.13 | 156.23 | 232.0 |
| 2013-12-22 18:00:00 | GC | Futures | 1648.3 | 1651.8 | 1647.7 | 1649.2 | 834.0 |
| 2013-12-22 19:00:00 | GC | Futures | 1649.3 | 1650.3 | 1646.4 | 1648.1 | 1092.0 |
| 2013-12-22 20:00:00 | GC | Futures | 1648.3 | 1649.0 | 1645.6 | 1646.6 | 1608.0 |
| 2013-12-22 21:00:00 | GC | Futures | 1646.6 | 1648.6 | 1644.8 | 1645.3 | 1483.0 |
| 2013-12-22 22:00:00 | GC | Futures | 1645.5 | 1647.3 | 1644.1 | 1646.8 | 1112.0 |
| 2013-12-22 23:00:00 | GC | Futures | 1646.8 | 1647.0 | 1643.7 | 1645.3 | 767.0 |
| 2013-12-22 18:00:00 | ZN | Futures | 114.39457 | 114.409018 | 114.336781 | 114.380123 | 3905.0 |
| 2013-12-22 19:00:00 | ZN | Futures | 114.380123 | 114.409018 | 114.365676 | 114.39457 | 2514.0 |
| 2013-12-22 20:00:00 | ZN | Futures | 114.39457 | 114.409018 | 114.365676 | 114.365676 | 1020.0 |
| 2013-12-22 21:00:00 | ZN | Futures | 114.365676 | 114.380123 | 114.351228 | 114.365676 | 863.0 |
| 2013-12-22 22:00:00 | ZN | Futures | 114.365676 | 114.365676 | 114.351228 | 114.351228 | 907.0 |
| 2013-12-22 23:00:00 | ZN | Futures | 114.351228 | 114.365676 | 114.322333 | 114.322333 | 1427.0 |
> showing 36 of 254 rows — these rows as CSV