PREVIEW / futures_1hour / 2013-07-14
file: by_date/futures_1hour/2013/2013-07-14.parquet size: 14 KB rows: 260
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-07-14 18:00:00 | ES | Futures | 1726.75 | 1728.81 | 1726.49 | 1728.04 | 4888.0 |
| 2013-07-14 19:00:00 | ES | Futures | 1728.04 | 1728.81 | 1727.78 | 1728.81 | 1914.0 |
| 2013-07-14 20:00:00 | ES | Futures | 1728.81 | 1728.81 | 1727.52 | 1728.55 | 2224.0 |
| 2013-07-14 21:00:00 | ES | Futures | 1728.3 | 1729.59 | 1728.04 | 1729.33 | 2761.0 |
| 2013-07-14 22:00:00 | ES | Futures | 1729.33 | 1731.66 | 1728.55 | 1730.88 | 6181.0 |
| 2013-07-14 23:00:00 | ES | Futures | 1730.88 | 1731.66 | 1730.36 | 1730.88 | 1645.0 |
| 2013-07-14 18:00:00 | NQ | Futures | 3580.18 | 3584.57 | 3580.18 | 3583.4 | 574.0 |
| 2013-07-14 19:00:00 | NQ | Futures | 3583.4 | 3584.27 | 3582.23 | 3583.98 | 254.0 |
| 2013-07-14 20:00:00 | NQ | Futures | 3583.98 | 3584.86 | 3582.81 | 3584.27 | 209.0 |
| 2013-07-14 21:00:00 | NQ | Futures | 3584.27 | 3586.61 | 3583.69 | 3586.32 | 447.0 |
| 2013-07-14 22:00:00 | NQ | Futures | 3586.03 | 3591.58 | 3584.86 | 3589.83 | 947.0 |
| 2013-07-14 23:00:00 | NQ | Futures | 3589.83 | 3590.7 | 3588.95 | 3590.41 | 252.0 |
| 2013-07-14 18:00:00 | YM | Futures | 15608.0 | 15622.2 | 15601.9 | 15620.2 | 424.0 |
| 2013-07-14 19:00:00 | YM | Futures | 15620.2 | 15624.2 | 15617.1 | 15624.2 | 162.0 |
| 2013-07-14 20:00:00 | YM | Futures | 15622.2 | 15624.2 | 15615.1 | 15622.2 | 265.0 |
| 2013-07-14 21:00:00 | YM | Futures | 15622.2 | 15630.3 | 15621.2 | 15628.3 | 530.0 |
| 2013-07-14 22:00:00 | YM | Futures | 15628.3 | 15649.6 | 15624.2 | 15643.5 | 1151.0 |
| 2013-07-14 23:00:00 | YM | Futures | 15643.5 | 15648.6 | 15639.5 | 15645.6 | 304.0 |
| 2013-07-14 18:00:00 | CL | Futures | 166.1 | 166.2 | 165.43 | 165.74 | 284.0 |
| 2013-07-14 19:00:00 | CL | Futures | 165.74 | 165.74 | 165.49 | 165.57 | 64.0 |
| 2013-07-14 20:00:00 | CL | Futures | 165.63 | 165.68 | 165.3 | 165.38 | 154.0 |
| 2013-07-14 21:00:00 | CL | Futures | 165.35 | 165.6 | 165.25 | 165.44 | 338.0 |
| 2013-07-14 22:00:00 | CL | Futures | 165.46 | 166.09 | 165.44 | 166.05 | 460.0 |
| 2013-07-14 23:00:00 | CL | Futures | 165.99 | 166.1 | 165.83 | 165.87 | 174.0 |
| 2013-07-14 18:00:00 | GC | Futures | 1760.8 | 1774.2 | 1760.2 | 1770.0 | 3727.0 |
| 2013-07-14 19:00:00 | GC | Futures | 1770.2 | 1772.0 | 1764.0 | 1766.9 | 1559.0 |
| 2013-07-14 20:00:00 | GC | Futures | 1766.7 | 1770.0 | 1765.1 | 1767.8 | 1891.0 |
| 2013-07-14 21:00:00 | GC | Futures | 1768.1 | 1771.3 | 1761.5 | 1769.8 | 5827.0 |
| 2013-07-14 22:00:00 | GC | Futures | 1770.2 | 1773.9 | 1768.7 | 1770.3 | 2495.0 |
| 2013-07-14 23:00:00 | GC | Futures | 1770.4 | 1770.4 | 1763.2 | 1766.5 | 2267.0 |
| 2013-07-14 18:00:00 | ZN | Futures | 114.255087 | 114.269238 | 114.198483 | 114.240936 | 3181.0 |
| 2013-07-14 19:00:00 | ZN | Futures | 114.240936 | 114.29754 | 114.226785 | 114.269238 | 1096.0 |
| 2013-07-14 20:00:00 | ZN | Futures | 114.269238 | 114.339993 | 114.240936 | 114.339993 | 2927.0 |
| 2013-07-14 21:00:00 | ZN | Futures | 114.325842 | 114.382446 | 114.311691 | 114.311691 | 3416.0 |
| 2013-07-14 22:00:00 | ZN | Futures | 114.311691 | 114.325842 | 114.283389 | 114.29754 | 2885.0 |
| 2013-07-14 23:00:00 | ZN | Futures | 114.29754 | 114.339993 | 114.283389 | 114.339993 | 2016.0 |
> showing 36 of 260 rows — these rows as CSV