PREVIEW / futures_1hour / 2014-05-18
file: by_date/futures_1hour/2014/2014-05-18.parquet size: 13 KB rows: 261
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-05-18 18:00:00 | ES | Futures | 1948.83 | 1950.13 | 1948.57 | 1949.87 | 6178.0 |
| 2014-05-18 19:00:00 | ES | Futures | 1949.61 | 1949.87 | 1948.57 | 1948.57 | 1455.0 |
| 2014-05-18 20:00:00 | ES | Futures | 1948.57 | 1949.09 | 1947.79 | 1948.83 | 4534.0 |
| 2014-05-18 21:00:00 | ES | Futures | 1948.83 | 1948.83 | 1947.27 | 1948.05 | 2937.0 |
| 2014-05-18 22:00:00 | ES | Futures | 1948.05 | 1948.31 | 1947.27 | 1947.79 | 1627.0 |
| 2014-05-18 23:00:00 | ES | Futures | 1947.79 | 1948.05 | 1947.27 | 1947.53 | 2277.0 |
| 2014-05-18 18:00:00 | NQ | Futures | 4178.17 | 4182.83 | 4177.87 | 4181.95 | 1006.0 |
| 2014-05-18 19:00:00 | NQ | Futures | 4181.95 | 4182.24 | 4179.62 | 4179.91 | 387.0 |
| 2014-05-18 20:00:00 | NQ | Futures | 4179.91 | 4179.91 | 4176.71 | 4178.75 | 569.0 |
| 2014-05-18 21:00:00 | NQ | Futures | 4178.46 | 4179.04 | 4174.09 | 4176.71 | 637.0 |
| 2014-05-18 22:00:00 | NQ | Futures | 4176.71 | 4177.29 | 4175.25 | 4176.42 | 314.0 |
| 2014-05-18 23:00:00 | NQ | Futures | 4176.42 | 4176.71 | 4174.96 | 4175.25 | 282.0 |
| 2014-05-18 18:00:00 | YM | Futures | 16957.7 | 16980.3 | 16956.6 | 16975.2 | 591.0 |
| 2014-05-18 19:00:00 | YM | Futures | 16974.1 | 16976.2 | 16962.8 | 16962.8 | 219.0 |
| 2014-05-18 20:00:00 | YM | Futures | 16961.8 | 16966.9 | 16955.6 | 16962.8 | 608.0 |
| 2014-05-18 21:00:00 | YM | Futures | 16961.8 | 16962.8 | 16952.5 | 16957.7 | 580.0 |
| 2014-05-18 22:00:00 | YM | Futures | 16956.6 | 16957.7 | 16952.5 | 16954.6 | 300.0 |
| 2014-05-18 23:00:00 | YM | Futures | 16955.6 | 16957.7 | 16951.5 | 16951.5 | 282.0 |
| 2014-05-18 18:00:00 | CL | Futures | 164.13 | 164.15 | 163.88 | 163.94 | 1344.0 |
| 2014-05-18 19:00:00 | CL | Futures | 163.94 | 164.05 | 163.93 | 163.97 | 278.0 |
| 2014-05-18 20:00:00 | CL | Futures | 163.99 | 164.02 | 163.96 | 163.99 | 280.0 |
| 2014-05-18 21:00:00 | CL | Futures | 164.01 | 164.1 | 163.94 | 164.07 | 526.0 |
| 2014-05-18 22:00:00 | CL | Futures | 164.07 | 164.23 | 164.05 | 164.22 | 774.0 |
| 2014-05-18 23:00:00 | CL | Futures | 164.22 | 164.3 | 164.18 | 164.18 | 397.0 |
| 2014-05-18 18:00:00 | GC | Futures | 1771.3 | 1771.4 | 1766.5 | 1768.8 | 1021.0 |
| 2014-05-18 19:00:00 | GC | Futures | 1768.8 | 1771.4 | 1768.4 | 1771.3 | 560.0 |
| 2014-05-18 20:00:00 | GC | Futures | 1770.9 | 1771.0 | 1769.6 | 1770.9 | 706.0 |
| 2014-05-18 21:00:00 | GC | Futures | 1770.7 | 1772.9 | 1769.8 | 1772.2 | 1804.0 |
| 2014-05-18 22:00:00 | GC | Futures | 1772.2 | 1775.2 | 1772.1 | 1775.1 | 2761.0 |
| 2014-05-18 23:00:00 | GC | Futures | 1775.2 | 1776.5 | 1773.2 | 1774.6 | 3056.0 |
| 2014-05-18 18:00:00 | ZN | Futures | 117.669468 | 117.727981 | 117.669468 | 117.713352 | 5780.0 |
| 2014-05-18 19:00:00 | ZN | Futures | 117.713352 | 117.727981 | 117.684096 | 117.727981 | 1941.0 |
| 2014-05-18 20:00:00 | ZN | Futures | 117.727981 | 117.757237 | 117.713352 | 117.727981 | 5901.0 |
| 2014-05-18 21:00:00 | ZN | Futures | 117.727981 | 117.742609 | 117.698724 | 117.713352 | 3052.0 |
| 2014-05-18 22:00:00 | ZN | Futures | 117.727981 | 117.727981 | 117.698724 | 117.713352 | 1765.0 |
| 2014-05-18 23:00:00 | ZN | Futures | 117.713352 | 117.727981 | 117.698724 | 117.713352 | 1774.0 |
> showing 36 of 261 rows — these rows as CSV