PREVIEW / futures_1hour / 2014-11-30
file: by_date/futures_1hour/2014/2014-11-30.parquet size: 15 KB rows: 289
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-11-30 18:00:00 | ES | Futures | 2162.02 | 2162.8 | 2153.63 | 2156.78 | 33012.0 |
| 2014-11-30 19:00:00 | ES | Futures | 2157.04 | 2160.18 | 2155.73 | 2159.92 | 7787.0 |
| 2014-11-30 20:00:00 | ES | Futures | 2159.66 | 2161.23 | 2157.3 | 2157.56 | 9062.0 |
| 2014-11-30 21:00:00 | ES | Futures | 2157.3 | 2158.61 | 2155.47 | 2155.73 | 6417.0 |
| 2014-11-30 22:00:00 | ES | Futures | 2155.73 | 2157.3 | 2155.47 | 2157.04 | 3662.0 |
| 2014-11-30 23:00:00 | ES | Futures | 2157.04 | 2157.83 | 2155.21 | 2157.04 | 3306.0 |
| 2014-11-30 18:00:00 | NQ | Futures | 5075.74 | 5079.84 | 5059.92 | 5067.53 | 5447.0 |
| 2014-11-30 19:00:00 | NQ | Futures | 5067.53 | 5076.32 | 5065.19 | 5075.45 | 2320.0 |
| 2014-11-30 20:00:00 | NQ | Futures | 5075.15 | 5079.55 | 5071.93 | 5072.81 | 1918.0 |
| 2014-11-30 21:00:00 | NQ | Futures | 5072.22 | 5075.45 | 5068.12 | 5068.71 | 1491.0 |
| 2014-11-30 22:00:00 | NQ | Futures | 5068.71 | 5072.81 | 5068.12 | 5072.22 | 748.0 |
| 2014-11-30 23:00:00 | NQ | Futures | 5071.93 | 5073.69 | 5066.95 | 5071.64 | 742.0 |
| 2014-11-30 18:00:00 | YM | Futures | 18491.1 | 18494.3 | 18408.0 | 18455.8 | 4990.0 |
| 2014-11-30 19:00:00 | YM | Futures | 18455.8 | 18488.0 | 18450.6 | 18483.9 | 1858.0 |
| 2014-11-30 20:00:00 | YM | Futures | 18483.9 | 18492.2 | 18465.2 | 18465.2 | 1694.0 |
| 2014-11-30 21:00:00 | YM | Futures | 18466.2 | 18473.5 | 18451.6 | 18452.7 | 1217.0 |
| 2014-11-30 22:00:00 | YM | Futures | 18453.7 | 18470.4 | 18450.6 | 18468.3 | 1055.0 |
| 2014-11-30 23:00:00 | YM | Futures | 18468.3 | 18470.4 | 18451.6 | 18464.1 | 603.0 |
| 2014-11-30 18:00:00 | CL | Futures | 111.17 | 111.48 | 108.06 | 108.28 | 20943.0 |
| 2014-11-30 19:00:00 | CL | Futures | 108.31 | 109.46 | 107.97 | 109.15 | 10235.0 |
| 2014-11-30 20:00:00 | CL | Futures | 109.14 | 109.29 | 108.66 | 109.24 | 5248.0 |
| 2014-11-30 21:00:00 | CL | Futures | 109.24 | 109.41 | 108.82 | 108.98 | 3484.0 |
| 2014-11-30 22:00:00 | CL | Futures | 108.98 | 109.09 | 108.68 | 108.8 | 1888.0 |
| 2014-11-30 23:00:00 | CL | Futures | 108.78 | 109.09 | 108.28 | 108.92 | 4513.0 |
| 2014-11-30 18:00:00 | GC | Futures | 1586.1 | 1586.2 | 1561.9 | 1572.8 | 22808.0 |
| 2014-11-30 19:00:00 | GC | Futures | 1572.8 | 1578.0 | 1570.2 | 1575.7 | 9890.0 |
| 2014-11-30 20:00:00 | GC | Futures | 1575.7 | 1576.7 | 1567.1 | 1574.3 | 9768.0 |
| 2014-11-30 21:00:00 | GC | Futures | 1574.5 | 1575.7 | 1572.6 | 1574.3 | 2921.0 |
| 2014-11-30 22:00:00 | GC | Futures | 1574.2 | 1575.0 | 1572.7 | 1574.1 | 1586.0 |
| 2014-11-30 23:00:00 | GC | Futures | 1574.1 | 1574.9 | 1572.4 | 1574.2 | 1658.0 |
| 2014-11-30 18:00:00 | ZN | Futures | 120.981652 | 121.026011 | 120.922506 | 120.981652 | 584.0 |
| 2014-11-30 19:00:00 | ZN | Futures | 120.981652 | 120.996438 | 120.952079 | 120.981652 | 179.0 |
| 2014-11-30 20:00:00 | ZN | Futures | 120.981652 | 121.011224 | 120.966865 | 121.011224 | 388.0 |
| 2014-11-30 21:00:00 | ZN | Futures | 121.011224 | 121.011224 | 120.996438 | 120.996438 | 366.0 |
| 2014-11-30 22:00:00 | ZN | Futures | 121.011224 | 121.011224 | 120.981652 | 120.981652 | 124.0 |
| 2014-11-30 23:00:00 | ZN | Futures | 120.981652 | 120.981652 | 120.966865 | 120.981652 | 21.0 |
> showing 36 of 289 rows — these rows as CSV