PREVIEW / futures_1hour / 2017-02-12
file: by_date/futures_1hour/2017/2017-02-12.parquet size: 15 KB rows: 292
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-12 18:00:00 | ES | Futures | 2525.02 | 2526.39 | 2523.93 | 2526.11 | 6633.0 |
| 2017-02-12 19:00:00 | ES | Futures | 2526.11 | 2526.11 | 2524.2 | 2524.48 | 3664.0 |
| 2017-02-12 20:00:00 | ES | Futures | 2524.2 | 2526.11 | 2524.2 | 2525.84 | 4348.0 |
| 2017-02-12 21:00:00 | ES | Futures | 2525.84 | 2529.11 | 2525.57 | 2528.84 | 10358.0 |
| 2017-02-12 22:00:00 | ES | Futures | 2529.11 | 2529.11 | 2527.75 | 2527.75 | 3567.0 |
| 2017-02-12 23:00:00 | ES | Futures | 2528.02 | 2528.3 | 2527.2 | 2527.48 | 986.0 |
| 2017-02-12 18:00:00 | NQ | Futures | 6239.96 | 6243.83 | 6236.97 | 6243.83 | 1568.0 |
| 2017-02-12 19:00:00 | NQ | Futures | 6243.83 | 6243.83 | 6237.57 | 6238.17 | 1094.0 |
| 2017-02-12 20:00:00 | NQ | Futures | 6237.87 | 6243.83 | 6237.57 | 6242.94 | 1201.0 |
| 2017-02-12 21:00:00 | NQ | Futures | 6243.24 | 6248.61 | 6242.04 | 6248.31 | 1986.0 |
| 2017-02-12 22:00:00 | NQ | Futures | 6248.31 | 6249.8 | 6245.92 | 6246.22 | 860.0 |
| 2017-02-12 23:00:00 | NQ | Futures | 6246.52 | 6248.01 | 6245.92 | 6246.82 | 506.0 |
| 2017-02-12 18:00:00 | YM | Futures | 21948.1 | 21964.3 | 21940.5 | 21964.3 | 1756.0 |
| 2017-02-12 19:00:00 | YM | Futures | 21964.3 | 21965.4 | 21950.2 | 21951.3 | 1029.0 |
| 2017-02-12 20:00:00 | YM | Futures | 21950.2 | 21964.3 | 21950.2 | 21962.2 | 1128.0 |
| 2017-02-12 21:00:00 | YM | Futures | 21963.3 | 22003.4 | 21961.1 | 22000.1 | 3499.0 |
| 2017-02-12 22:00:00 | YM | Futures | 22001.2 | 22001.2 | 21983.9 | 21986.0 | 993.0 |
| 2017-02-12 23:00:00 | YM | Futures | 21987.1 | 21989.3 | 21980.6 | 21983.9 | 346.0 |
| 2017-02-12 18:00:00 | CL | Futures | 51.04 | 51.13 | 50.98 | 51.06 | 368.0 |
| 2017-02-12 19:00:00 | CL | Futures | 51.06 | 51.07 | 50.92 | 50.92 | 577.0 |
| 2017-02-12 20:00:00 | CL | Futures | 50.92 | 50.96 | 50.91 | 50.96 | 497.0 |
| 2017-02-12 21:00:00 | CL | Futures | 50.97 | 51.08 | 50.95 | 51.06 | 586.0 |
| 2017-02-12 22:00:00 | CL | Futures | 51.06 | 51.09 | 50.98 | 50.99 | 260.0 |
| 2017-02-12 23:00:00 | CL | Futures | 50.99 | 51.01 | 50.97 | 51.0 | 238.0 |
| 2017-02-12 18:00:00 | GC | Futures | 1662.1 | 1662.4 | 1656.6 | 1658.6 | 4177.0 |
| 2017-02-12 19:00:00 | GC | Futures | 1658.6 | 1659.7 | 1656.7 | 1659.0 | 4832.0 |
| 2017-02-12 20:00:00 | GC | Futures | 1659.0 | 1660.6 | 1658.3 | 1659.8 | 5523.0 |
| 2017-02-12 21:00:00 | GC | Futures | 1659.7 | 1659.7 | 1657.5 | 1657.7 | 4774.0 |
| 2017-02-12 22:00:00 | GC | Futures | 1657.8 | 1658.7 | 1656.7 | 1657.1 | 2776.0 |
| 2017-02-12 23:00:00 | GC | Futures | 1657.0 | 1657.9 | 1656.7 | 1657.4 | 1690.0 |
| 2017-02-12 18:00:00 | ZN | Futures | 123.11009 | 123.125512 | 122.986718 | 123.048404 | 14073.0 |
| 2017-02-12 19:00:00 | ZN | Futures | 123.048404 | 123.11009 | 122.971297 | 123.063826 | 17141.0 |
| 2017-02-12 20:00:00 | ZN | Futures | 123.079247 | 123.094669 | 123.017561 | 123.032983 | 9399.0 |
| 2017-02-12 21:00:00 | ZN | Futures | 123.032983 | 123.048404 | 122.986718 | 123.00214 | 10641.0 |
| 2017-02-12 22:00:00 | ZN | Futures | 123.00214 | 123.048404 | 123.00214 | 123.032983 | 3508.0 |
| 2017-02-12 23:00:00 | ZN | Futures | 123.048404 | 123.048404 | 123.017561 | 123.032983 | 2251.0 |
> showing 36 of 292 rows — these rows as CSV