PREVIEW / futures_1hour / 2017-02-19
file: by_date/futures_1hour/2017/2017-02-19.parquet size: 13 KB rows: 252
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 |
|---|---|---|---|---|---|---|---|
| 2017-02-19 18:00:00 | ES | Futures | 2560.21 | 2561.85 | 2559.94 | 2561.3 | 4731.0 |
| 2017-02-19 19:00:00 | ES | Futures | 2561.03 | 2561.85 | 2559.66 | 2561.57 | 2921.0 |
| 2017-02-19 20:00:00 | ES | Futures | 2561.57 | 2562.12 | 2560.21 | 2561.57 | 2714.0 |
| 2017-02-19 21:00:00 | ES | Futures | 2561.57 | 2562.66 | 2561.3 | 2561.85 | 2784.0 |
| 2017-02-19 22:00:00 | ES | Futures | 2562.12 | 2562.94 | 2561.85 | 2562.94 | 905.0 |
| 2017-02-19 23:00:00 | ES | Futures | 2562.94 | 2564.57 | 2562.66 | 2563.21 | 3694.0 |
| 2017-02-19 18:00:00 | NQ | Futures | 6352.42 | 6354.51 | 6349.74 | 6350.93 | 1415.0 |
| 2017-02-19 19:00:00 | NQ | Futures | 6351.23 | 6353.91 | 6348.84 | 6353.02 | 992.0 |
| 2017-02-19 20:00:00 | NQ | Futures | 6352.72 | 6356.3 | 6350.04 | 6355.11 | 841.0 |
| 2017-02-19 21:00:00 | NQ | Futures | 6355.41 | 6358.39 | 6354.81 | 6356.3 | 897.0 |
| 2017-02-19 22:00:00 | NQ | Futures | 6356.0 | 6357.49 | 6355.11 | 6356.6 | 473.0 |
| 2017-02-19 23:00:00 | NQ | Futures | 6356.6 | 6359.88 | 6356.0 | 6356.0 | 866.0 |
| 2017-02-19 18:00:00 | YM | Futures | 22327.7 | 22331.0 | 22315.8 | 22324.5 | 1208.0 |
| 2017-02-19 19:00:00 | YM | Futures | 22324.5 | 22331.0 | 22311.5 | 22326.7 | 901.0 |
| 2017-02-19 20:00:00 | YM | Futures | 22327.7 | 22338.6 | 22318.0 | 22334.2 | 1018.0 |
| 2017-02-19 21:00:00 | YM | Futures | 22334.2 | 22347.3 | 22332.1 | 22342.9 | 932.0 |
| 2017-02-19 22:00:00 | YM | Futures | 22341.8 | 22345.1 | 22340.8 | 22345.1 | 413.0 |
| 2017-02-19 23:00:00 | YM | Futures | 22345.1 | 22358.1 | 22345.1 | 22346.2 | 868.0 |
| 2017-02-19 18:00:00 | CL | Futures | 50.64 | 50.71 | 50.52 | 50.54 | 3197.0 |
| 2017-02-19 19:00:00 | CL | Futures | 50.53 | 50.59 | 50.51 | 50.56 | 1225.0 |
| 2017-02-19 20:00:00 | CL | Futures | 50.56 | 50.58 | 50.48 | 50.5 | 2131.0 |
| 2017-02-19 21:00:00 | CL | Futures | 50.51 | 50.55 | 50.49 | 50.52 | 1102.0 |
| 2017-02-19 22:00:00 | CL | Futures | 50.53 | 50.58 | 50.52 | 50.57 | 1392.0 |
| 2017-02-19 23:00:00 | CL | Futures | 50.56 | 50.6 | 50.55 | 50.59 | 1151.0 |
| 2017-02-19 18:00:00 | GC | Futures | 1665.1 | 1668.8 | 1664.7 | 1666.3 | 3697.0 |
| 2017-02-19 19:00:00 | GC | Futures | 1666.1 | 1667.0 | 1664.9 | 1665.7 | 2949.0 |
| 2017-02-19 20:00:00 | GC | Futures | 1665.7 | 1666.3 | 1659.7 | 1663.6 | 8139.0 |
| 2017-02-19 21:00:00 | GC | Futures | 1663.7 | 1663.9 | 1662.0 | 1662.6 | 3236.0 |
| 2017-02-19 22:00:00 | GC | Futures | 1662.6 | 1663.7 | 1662.4 | 1663.3 | 1626.0 |
| 2017-02-19 23:00:00 | GC | Futures | 1663.5 | 1664.5 | 1662.9 | 1664.0 | 1587.0 |
| 2017-02-19 18:00:00 | ZN | Futures | 123.063826 | 123.125512 | 123.048404 | 123.094669 | 4949.0 |
| 2017-02-19 19:00:00 | ZN | Futures | 123.094669 | 123.11009 | 123.063826 | 123.079247 | 2346.0 |
| 2017-02-19 20:00:00 | ZN | Futures | 123.079247 | 123.11009 | 123.079247 | 123.094669 | 2330.0 |
| 2017-02-19 21:00:00 | ZN | Futures | 123.079247 | 123.079247 | 123.032983 | 123.063826 | 2769.0 |
| 2017-02-19 22:00:00 | ZN | Futures | 123.079247 | 123.079247 | 123.048404 | 123.063826 | 1301.0 |
| 2017-02-19 23:00:00 | ZN | Futures | 123.063826 | 123.063826 | 123.048404 | 123.063826 | 1936.0 |
> showing 36 of 252 rows — these rows as CSV