PREVIEW / futures_1hour / 2018-03-11
file: by_date/futures_1hour/2018/2018-03-11.parquet size: 14 KB rows: 275
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 |
|---|---|---|---|---|---|---|---|
| 2018-03-11 18:00:00 | ES | Futures | 3043.78 | 3052.53 | 3043.23 | 3051.98 | 5784.0 |
| 2018-03-11 19:00:00 | ES | Futures | 3052.25 | 3054.17 | 3050.61 | 3051.43 | 3832.0 |
| 2018-03-11 20:00:00 | ES | Futures | 3051.71 | 3054.71 | 3049.52 | 3052.8 | 5490.0 |
| 2018-03-11 21:00:00 | ES | Futures | 3053.07 | 3054.44 | 3050.34 | 3051.71 | 5699.0 |
| 2018-03-11 22:00:00 | ES | Futures | 3051.71 | 3055.53 | 3050.89 | 3054.44 | 4470.0 |
| 2018-03-11 23:00:00 | ES | Futures | 3054.71 | 3056.9 | 3053.89 | 3054.99 | 3686.0 |
| 2018-03-11 18:00:00 | NQ | Futures | 8422.39 | 8444.63 | 8411.41 | 8443.15 | 958.0 |
| 2018-03-11 19:00:00 | NQ | Futures | 8443.15 | 8452.34 | 8443.15 | 8447.89 | 834.0 |
| 2018-03-11 20:00:00 | NQ | Futures | 8447.89 | 8463.02 | 8445.52 | 8456.79 | 1581.0 |
| 2018-03-11 21:00:00 | NQ | Futures | 8456.79 | 8464.8 | 8452.34 | 8454.72 | 1575.0 |
| 2018-03-11 22:00:00 | NQ | Futures | 8454.72 | 8466.88 | 8452.64 | 8466.58 | 1170.0 |
| 2018-03-11 23:00:00 | NQ | Futures | 8466.58 | 8471.92 | 8464.5 | 8465.1 | 944.0 |
| 2018-03-11 18:00:00 | YM | Futures | 27545.9 | 27645.8 | 27540.5 | 27640.4 | 1948.0 |
| 2018-03-11 19:00:00 | YM | Futures | 27641.5 | 27665.4 | 27636.0 | 27639.3 | 1449.0 |
| 2018-03-11 20:00:00 | YM | Futures | 27640.4 | 27677.3 | 27623.0 | 27652.3 | 2987.0 |
| 2018-03-11 21:00:00 | YM | Futures | 27653.4 | 27669.7 | 27624.1 | 27632.8 | 2349.0 |
| 2018-03-11 22:00:00 | YM | Futures | 27633.9 | 27665.4 | 27625.2 | 27658.8 | 1317.0 |
| 2018-03-11 23:00:00 | YM | Futures | 27662.1 | 27680.6 | 27648.0 | 27658.8 | 1353.0 |
| 2018-03-11 18:00:00 | CL | Futures | 55.41 | 55.49 | 55.34 | 55.4 | 2740.0 |
| 2018-03-11 19:00:00 | CL | Futures | 55.4 | 55.52 | 55.4 | 55.47 | 3289.0 |
| 2018-03-11 20:00:00 | CL | Futures | 55.48 | 55.55 | 55.43 | 55.51 | 4306.0 |
| 2018-03-11 21:00:00 | CL | Futures | 55.52 | 55.62 | 55.49 | 55.56 | 5634.0 |
| 2018-03-11 22:00:00 | CL | Futures | 55.56 | 55.57 | 55.43 | 55.46 | 3951.0 |
| 2018-03-11 23:00:00 | CL | Futures | 55.46 | 55.5 | 55.41 | 55.43 | 3403.0 |
| 2018-03-11 18:00:00 | GC | Futures | 1752.2 | 1753.4 | 1751.0 | 1751.4 | 1347.0 |
| 2018-03-11 19:00:00 | GC | Futures | 1751.5 | 1752.1 | 1751.0 | 1751.7 | 1314.0 |
| 2018-03-11 20:00:00 | GC | Futures | 1751.7 | 1752.2 | 1749.7 | 1750.6 | 3939.0 |
| 2018-03-11 21:00:00 | GC | Futures | 1750.5 | 1752.2 | 1749.0 | 1751.9 | 7363.0 |
| 2018-03-11 22:00:00 | GC | Futures | 1751.8 | 1752.7 | 1751.0 | 1751.5 | 6251.0 |
| 2018-03-11 23:00:00 | GC | Futures | 1751.4 | 1751.7 | 1750.4 | 1751.4 | 2990.0 |
| 2018-03-11 18:00:00 | ZN | Futures | 120.353627 | 120.353627 | 120.306608 | 120.306608 | 5688.0 |
| 2018-03-11 19:00:00 | ZN | Futures | 120.322281 | 120.337954 | 120.290935 | 120.337954 | 7894.0 |
| 2018-03-11 20:00:00 | ZN | Futures | 120.322281 | 120.337954 | 120.275262 | 120.290935 | 12641.0 |
| 2018-03-11 21:00:00 | ZN | Futures | 120.290935 | 120.337954 | 120.259589 | 120.322281 | 9839.0 |
| 2018-03-11 22:00:00 | ZN | Futures | 120.306608 | 120.322281 | 120.290935 | 120.306608 | 5161.0 |
| 2018-03-11 23:00:00 | ZN | Futures | 120.306608 | 120.322281 | 120.290935 | 120.306608 | 5070.0 |
> showing 36 of 275 rows — these rows as CSV