PREVIEW / futures_1hour / 2015-07-19
file: by_date/futures_1hour/2015/2015-07-19.parquet size: 14 KB rows: 267
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 |
|---|---|---|---|---|---|---|---|
| 2015-07-19 18:00:00 | ES | Futures | 2255.66 | 2256.72 | 2255.39 | 2256.72 | 2108.0 |
| 2015-07-19 19:00:00 | ES | Futures | 2256.72 | 2256.72 | 2255.66 | 2255.92 | 875.0 |
| 2015-07-19 20:00:00 | ES | Futures | 2256.19 | 2256.99 | 2255.92 | 2256.72 | 1859.0 |
| 2015-07-19 21:00:00 | ES | Futures | 2256.99 | 2258.05 | 2256.72 | 2256.99 | 2633.0 |
| 2015-07-19 22:00:00 | ES | Futures | 2256.99 | 2257.79 | 2256.99 | 2257.25 | 1379.0 |
| 2015-07-19 23:00:00 | ES | Futures | 2257.25 | 2257.52 | 2256.45 | 2256.72 | 808.0 |
| 2015-07-19 18:00:00 | NQ | Futures | 5500.5 | 5504.94 | 5497.54 | 5504.64 | 704.0 |
| 2015-07-19 19:00:00 | NQ | Futures | 5504.64 | 5504.94 | 5502.57 | 5503.75 | 178.0 |
| 2015-07-19 20:00:00 | NQ | Futures | 5503.75 | 5506.12 | 5503.16 | 5505.82 | 370.0 |
| 2015-07-19 21:00:00 | NQ | Futures | 5505.53 | 5510.26 | 5505.53 | 5506.42 | 725.0 |
| 2015-07-19 22:00:00 | NQ | Futures | 5505.82 | 5506.71 | 5502.27 | 5503.46 | 654.0 |
| 2015-07-19 23:00:00 | NQ | Futures | 5503.46 | 5504.35 | 5501.98 | 5502.87 | 208.0 |
| 2015-07-19 18:00:00 | YM | Futures | 18954.9 | 18961.2 | 18948.6 | 18959.1 | 168.0 |
| 2015-07-19 19:00:00 | YM | Futures | 18960.2 | 18963.3 | 18959.1 | 18963.3 | 196.0 |
| 2015-07-19 20:00:00 | YM | Futures | 18963.3 | 18970.7 | 18960.2 | 18969.7 | 281.0 |
| 2015-07-19 21:00:00 | YM | Futures | 18969.7 | 18982.3 | 18967.5 | 18972.8 | 784.0 |
| 2015-07-19 22:00:00 | YM | Futures | 18972.8 | 18979.1 | 18971.8 | 18972.8 | 235.0 |
| 2015-07-19 23:00:00 | YM | Futures | 18971.8 | 18976.0 | 18965.4 | 18970.7 | 238.0 |
| 2015-07-19 18:00:00 | CL | Futures | 75.41 | 75.75 | 75.29 | 75.56 | 1248.0 |
| 2015-07-19 19:00:00 | CL | Futures | 75.56 | 75.65 | 75.42 | 75.56 | 905.0 |
| 2015-07-19 20:00:00 | CL | Futures | 75.54 | 75.56 | 75.39 | 75.5 | 444.0 |
| 2015-07-19 21:00:00 | CL | Futures | 75.5 | 75.51 | 75.28 | 75.51 | 1399.0 |
| 2015-07-19 22:00:00 | CL | Futures | 75.51 | 75.57 | 75.37 | 75.39 | 513.0 |
| 2015-07-19 23:00:00 | CL | Futures | 75.39 | 75.39 | 75.29 | 75.38 | 855.0 |
| 2015-07-19 18:00:00 | GC | Futures | 1545.7 | 1545.8 | 1539.9 | 1543.1 | 3354.0 |
| 2015-07-19 19:00:00 | GC | Futures | 1543.2 | 1544.6 | 1543.1 | 1543.8 | 556.0 |
| 2015-07-19 20:00:00 | GC | Futures | 1543.6 | 1544.3 | 1542.0 | 1544.3 | 691.0 |
| 2015-07-19 21:00:00 | GC | Futures | 1544.3 | 1544.7 | 1474.2 | 1508.8 | 36045.0 |
| 2015-07-19 22:00:00 | GC | Futures | 1508.8 | 1516.1 | 1506.5 | 1508.5 | 13686.0 |
| 2015-07-19 23:00:00 | GC | Futures | 1508.5 | 1513.1 | 1507.5 | 1511.3 | 4245.0 |
| 2015-07-19 18:00:00 | ZN | Futures | 121.325991 | 121.356052 | 121.250839 | 121.265869 | 2454.0 |
| 2015-07-19 19:00:00 | ZN | Futures | 121.265869 | 121.29593 | 121.235808 | 121.265869 | 1357.0 |
| 2015-07-19 20:00:00 | ZN | Futures | 121.2809 | 121.29593 | 121.265869 | 121.2809 | 1322.0 |
| 2015-07-19 21:00:00 | ZN | Futures | 121.265869 | 121.2809 | 121.205747 | 121.220778 | 4006.0 |
| 2015-07-19 22:00:00 | ZN | Futures | 121.220778 | 121.220778 | 121.160656 | 121.190717 | 2134.0 |
| 2015-07-19 23:00:00 | ZN | Futures | 121.190717 | 121.190717 | 121.160656 | 121.175686 | 1789.0 |
> showing 36 of 267 rows — these rows as CSV