PREVIEW / futures_1hour / 2016-02-07
file: by_date/futures_1hour/2016/2016-02-07.parquet size: 14 KB rows: 277
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-07 18:00:00 | ES | Futures | 2016.66 | 2018.27 | 2014.24 | 2015.86 | 12280.0 |
| 2016-02-07 19:00:00 | ES | Futures | 2016.12 | 2020.42 | 2015.32 | 2019.62 | 10258.0 |
| 2016-02-07 20:00:00 | ES | Futures | 2019.62 | 2024.45 | 2018.81 | 2022.57 | 11048.0 |
| 2016-02-07 21:00:00 | ES | Futures | 2022.57 | 2023.38 | 2018.54 | 2020.15 | 6175.0 |
| 2016-02-07 22:00:00 | ES | Futures | 2020.15 | 2020.96 | 2017.47 | 2020.42 | 3822.0 |
| 2016-02-07 23:00:00 | ES | Futures | 2020.15 | 2024.19 | 2019.35 | 2023.11 | 5361.0 |
| 2016-02-07 18:00:00 | NQ | Futures | 4783.27 | 4783.86 | 4770.5 | 4773.17 | 2306.0 |
| 2016-02-07 19:00:00 | NQ | Futures | 4773.47 | 4786.24 | 4772.87 | 4782.08 | 1701.0 |
| 2016-02-07 20:00:00 | NQ | Futures | 4782.67 | 4799.0 | 4781.49 | 4795.14 | 2247.0 |
| 2016-02-07 21:00:00 | NQ | Futures | 4795.74 | 4795.74 | 4785.64 | 4789.8 | 1106.0 |
| 2016-02-07 22:00:00 | NQ | Futures | 4790.1 | 4791.58 | 4782.38 | 4789.5 | 812.0 |
| 2016-02-07 23:00:00 | NQ | Futures | 4790.1 | 4801.68 | 4788.61 | 4799.3 | 1053.0 |
| 2016-02-07 18:00:00 | YM | Futures | 17188.1 | 17189.2 | 17160.5 | 17173.2 | 860.0 |
| 2016-02-07 19:00:00 | YM | Futures | 17176.4 | 17204.1 | 17166.8 | 17196.6 | 2180.0 |
| 2016-02-07 20:00:00 | YM | Futures | 17199.8 | 17237.1 | 17194.5 | 17222.2 | 1702.0 |
| 2016-02-07 21:00:00 | YM | Futures | 17223.3 | 17226.5 | 17192.4 | 17208.4 | 1061.0 |
| 2016-02-07 22:00:00 | YM | Futures | 17206.2 | 17208.4 | 17178.6 | 17203.0 | 1110.0 |
| 2016-02-07 23:00:00 | YM | Futures | 17202.0 | 17233.9 | 17196.6 | 17227.5 | 1424.0 |
| 2016-02-07 18:00:00 | CL | Futures | 39.45 | 39.63 | 39.23 | 39.28 | 2930.0 |
| 2016-02-07 19:00:00 | CL | Futures | 39.27 | 39.5 | 39.18 | 39.48 | 5001.0 |
| 2016-02-07 20:00:00 | CL | Futures | 39.48 | 39.53 | 39.2 | 39.44 | 2701.0 |
| 2016-02-07 21:00:00 | CL | Futures | 39.45 | 39.51 | 39.25 | 39.4 | 1403.0 |
| 2016-02-07 22:00:00 | CL | Futures | 39.4 | 39.49 | 39.36 | 39.48 | 787.0 |
| 2016-02-07 23:00:00 | CL | Futures | 39.46 | 39.72 | 39.44 | 39.67 | 1463.0 |
| 2016-02-07 18:00:00 | GC | Futures | 1602.6 | 1602.6 | 1590.6 | 1590.7 | 4451.0 |
| 2016-02-07 19:00:00 | GC | Futures | 1590.7 | 1595.7 | 1590.2 | 1595.1 | 3534.0 |
| 2016-02-07 20:00:00 | GC | Futures | 1595.0 | 1595.7 | 1590.5 | 1590.9 | 1824.0 |
| 2016-02-07 21:00:00 | GC | Futures | 1590.9 | 1592.7 | 1589.9 | 1591.0 | 1963.0 |
| 2016-02-07 22:00:00 | GC | Futures | 1591.2 | 1592.8 | 1590.2 | 1592.1 | 1384.0 |
| 2016-02-07 23:00:00 | GC | Futures | 1592.1 | 1595.8 | 1591.6 | 1592.8 | 2156.0 |
| 2016-02-07 18:00:00 | ZN | Futures | 126.466262 | 126.526903 | 126.420781 | 126.451102 | 9897.0 |
| 2016-02-07 19:00:00 | ZN | Futures | 126.451102 | 126.466262 | 126.344981 | 126.360141 | 10156.0 |
| 2016-02-07 20:00:00 | ZN | Futures | 126.344981 | 126.360141 | 126.31466 | 126.31466 | 7862.0 |
| 2016-02-07 21:00:00 | ZN | Futures | 126.31466 | 126.360141 | 126.2995 | 126.344981 | 4695.0 |
| 2016-02-07 22:00:00 | ZN | Futures | 126.32982 | 126.405621 | 126.32982 | 126.344981 | 5972.0 |
| 2016-02-07 23:00:00 | ZN | Futures | 126.344981 | 126.375301 | 126.2995 | 126.344981 | 3079.0 |
> showing 36 of 277 rows — these rows as CSV