PREVIEW / futures_1hour / 2014-03-09
file: by_date/futures_1hour/2014/2014-03-09.parquet size: 14 KB rows: 270
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-03-09 18:00:00 | ES | Futures | 1940.42 | 1940.93 | 1938.61 | 1939.12 | 7451.0 |
| 2014-03-09 19:00:00 | ES | Futures | 1939.64 | 1941.19 | 1938.86 | 1938.86 | 5299.0 |
| 2014-03-09 20:00:00 | ES | Futures | 1939.12 | 1941.45 | 1938.61 | 1939.38 | 5605.0 |
| 2014-03-09 21:00:00 | ES | Futures | 1939.64 | 1939.64 | 1936.8 | 1937.31 | 9964.0 |
| 2014-03-09 22:00:00 | ES | Futures | 1937.31 | 1938.35 | 1936.28 | 1937.31 | 4682.0 |
| 2014-03-09 23:00:00 | ES | Futures | 1937.31 | 1938.09 | 1936.8 | 1937.57 | 2252.0 |
| 2014-03-09 18:00:00 | NQ | Futures | 4303.88 | 4305.62 | 4300.1 | 4302.72 | 1231.0 |
| 2014-03-09 19:00:00 | NQ | Futures | 4303.01 | 4306.2 | 4302.13 | 4302.42 | 694.0 |
| 2014-03-09 20:00:00 | NQ | Futures | 4302.42 | 4307.37 | 4300.68 | 4302.72 | 813.0 |
| 2014-03-09 21:00:00 | NQ | Futures | 4303.01 | 4303.88 | 4297.48 | 4299.23 | 1601.0 |
| 2014-03-09 22:00:00 | NQ | Futures | 4299.52 | 4300.97 | 4297.19 | 4298.06 | 661.0 |
| 2014-03-09 23:00:00 | NQ | Futures | 4298.06 | 4301.26 | 4297.19 | 4299.23 | 295.0 |
| 2014-03-09 18:00:00 | YM | Futures | 16854.5 | 16854.5 | 16826.9 | 16835.1 | 411.0 |
| 2014-03-09 19:00:00 | YM | Futures | 16835.1 | 16847.4 | 16831.0 | 16833.0 | 419.0 |
| 2014-03-09 20:00:00 | YM | Futures | 16833.0 | 16854.5 | 16828.9 | 16835.1 | 485.0 |
| 2014-03-09 21:00:00 | YM | Futures | 16834.0 | 16839.2 | 16818.7 | 16824.8 | 1116.0 |
| 2014-03-09 22:00:00 | YM | Futures | 16825.8 | 16829.9 | 16817.6 | 16823.8 | 583.0 |
| 2014-03-09 23:00:00 | YM | Futures | 16823.8 | 16829.9 | 16819.7 | 16823.8 | 288.0 |
| 2014-03-09 18:00:00 | CL | Futures | 162.42 | 162.53 | 161.93 | 161.96 | 617.0 |
| 2014-03-09 19:00:00 | CL | Futures | 161.96 | 161.99 | 161.73 | 161.9 | 463.0 |
| 2014-03-09 20:00:00 | CL | Futures | 161.9 | 161.98 | 161.74 | 161.95 | 607.0 |
| 2014-03-09 21:00:00 | CL | Futures | 161.96 | 161.96 | 161.85 | 161.92 | 452.0 |
| 2014-03-09 22:00:00 | CL | Futures | 161.9 | 162.09 | 161.87 | 162.06 | 704.0 |
| 2014-03-09 23:00:00 | CL | Futures | 162.06 | 162.1 | 161.87 | 161.93 | 344.0 |
| 2014-03-09 18:00:00 | GC | Futures | 1836.3 | 1837.7 | 1832.5 | 1833.3 | 1225.0 |
| 2014-03-09 19:00:00 | GC | Futures | 1833.3 | 1834.1 | 1830.4 | 1832.8 | 1522.0 |
| 2014-03-09 20:00:00 | GC | Futures | 1832.9 | 1833.2 | 1829.2 | 1831.0 | 2067.0 |
| 2014-03-09 21:00:00 | GC | Futures | 1830.9 | 1831.0 | 1818.1 | 1824.6 | 10361.0 |
| 2014-03-09 22:00:00 | GC | Futures | 1824.6 | 1829.8 | 1824.1 | 1827.7 | 4843.0 |
| 2014-03-09 23:00:00 | GC | Futures | 1827.8 | 1828.0 | 1825.5 | 1827.3 | 1671.0 |
| 2014-03-09 18:00:00 | ZN | Futures | 115.709285 | 115.723913 | 115.680029 | 115.723913 | 5595.0 |
| 2014-03-09 19:00:00 | ZN | Futures | 115.709285 | 115.723913 | 115.650772 | 115.680029 | 5007.0 |
| 2014-03-09 20:00:00 | ZN | Futures | 115.680029 | 115.75317 | 115.665401 | 115.75317 | 10839.0 |
| 2014-03-09 21:00:00 | ZN | Futures | 115.738542 | 115.782426 | 115.723913 | 115.767798 | 10746.0 |
| 2014-03-09 22:00:00 | ZN | Futures | 115.767798 | 115.811683 | 115.75317 | 115.782426 | 9300.0 |
| 2014-03-09 23:00:00 | ZN | Futures | 115.782426 | 115.811683 | 115.767798 | 115.782426 | 5423.0 |
> showing 36 of 270 rows — these rows as CSV