PREVIEW / futures_1hour / 2018-09-30
file: by_date/futures_1hour/2018/2018-09-30.parquet size: 15 KB rows: 301
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-09-30 18:00:00 | ES | Futures | 3179.66 | 3184.28 | 3179.66 | 3183.2 | 11563.0 |
| 2018-09-30 19:00:00 | ES | Futures | 3183.2 | 3187.55 | 3183.2 | 3185.92 | 9609.0 |
| 2018-09-30 20:00:00 | ES | Futures | 3185.92 | 3187.28 | 3184.56 | 3187.0 | 7428.0 |
| 2018-09-30 21:00:00 | ES | Futures | 3187.28 | 3188.36 | 3186.19 | 3187.55 | 8771.0 |
| 2018-09-30 22:00:00 | ES | Futures | 3187.55 | 3194.35 | 3187.28 | 3192.99 | 15820.0 |
| 2018-09-30 23:00:00 | ES | Futures | 3192.99 | 3194.35 | 3192.72 | 3193.26 | 5772.0 |
| 2018-09-30 18:00:00 | NQ | Futures | 9001.22 | 9018.53 | 8999.76 | 9013.84 | 3536.0 |
| 2018-09-30 19:00:00 | NQ | Futures | 9013.84 | 9029.09 | 9013.25 | 9018.82 | 3644.0 |
| 2018-09-30 20:00:00 | NQ | Futures | 9019.12 | 9023.52 | 9014.13 | 9022.93 | 2091.0 |
| 2018-09-30 21:00:00 | NQ | Futures | 9023.22 | 9026.45 | 9017.06 | 9023.52 | 2039.0 |
| 2018-09-30 22:00:00 | NQ | Futures | 9023.81 | 9049.91 | 9023.22 | 9042.58 | 5730.0 |
| 2018-09-30 23:00:00 | NQ | Futures | 9043.17 | 9048.74 | 9042.0 | 9043.17 | 3374.0 |
| 2018-09-30 18:00:00 | YM | Futures | 28818.7 | 28859.9 | 28810.0 | 28851.2 | 1572.0 |
| 2018-09-30 19:00:00 | YM | Futures | 28851.2 | 28923.0 | 28850.2 | 28895.8 | 3282.0 |
| 2018-09-30 20:00:00 | YM | Futures | 28896.9 | 28909.9 | 28880.6 | 28908.8 | 1478.0 |
| 2018-09-30 21:00:00 | YM | Futures | 28908.8 | 28915.4 | 28895.8 | 28904.5 | 1554.0 |
| 2018-09-30 22:00:00 | YM | Futures | 28905.6 | 28970.8 | 28901.2 | 28954.5 | 3000.0 |
| 2018-09-30 23:00:00 | YM | Futures | 28954.5 | 28969.7 | 28952.3 | 28955.6 | 1204.0 |
| 2018-09-30 18:00:00 | CL | Futures | 67.51 | 67.75 | 67.5 | 67.64 | 2730.0 |
| 2018-09-30 19:00:00 | CL | Futures | 67.64 | 67.73 | 67.63 | 67.7 | 1333.0 |
| 2018-09-30 20:00:00 | CL | Futures | 67.71 | 67.71 | 67.63 | 67.7 | 2097.0 |
| 2018-09-30 21:00:00 | CL | Futures | 67.7 | 67.71 | 67.59 | 67.65 | 2926.0 |
| 2018-09-30 22:00:00 | CL | Futures | 67.65 | 67.85 | 67.65 | 67.78 | 6831.0 |
| 2018-09-30 23:00:00 | CL | Futures | 67.79 | 67.8 | 67.74 | 67.77 | 1854.0 |
| 2018-09-30 18:00:00 | GC | Futures | 1558.3 | 1558.9 | 1557.0 | 1557.2 | 1677.0 |
| 2018-09-30 19:00:00 | GC | Futures | 1557.2 | 1558.1 | 1556.0 | 1556.5 | 2614.0 |
| 2018-09-30 20:00:00 | GC | Futures | 1556.5 | 1556.8 | 1555.0 | 1555.2 | 5551.0 |
| 2018-09-30 21:00:00 | GC | Futures | 1555.2 | 1555.7 | 1552.7 | 1553.9 | 7651.0 |
| 2018-09-30 22:00:00 | GC | Futures | 1554.0 | 1554.8 | 1553.4 | 1553.8 | 3782.0 |
| 2018-09-30 23:00:00 | GC | Futures | 1553.7 | 1554.4 | 1553.0 | 1553.7 | 2586.0 |
| 2018-09-30 18:00:00 | ZN | Futures | 119.58238 | 119.598119 | 119.535164 | 119.58238 | 12119.0 |
| 2018-09-30 19:00:00 | ZN | Futures | 119.58238 | 119.58238 | 119.535164 | 119.566641 | 7511.0 |
| 2018-09-30 20:00:00 | ZN | Futures | 119.566641 | 119.598119 | 119.550903 | 119.566641 | 7967.0 |
| 2018-09-30 21:00:00 | ZN | Futures | 119.58238 | 119.598119 | 119.535164 | 119.535164 | 13509.0 |
| 2018-09-30 22:00:00 | ZN | Futures | 119.535164 | 119.550903 | 119.519425 | 119.535164 | 12587.0 |
| 2018-09-30 23:00:00 | ZN | Futures | 119.519425 | 119.535164 | 119.503687 | 119.519425 | 6936.0 |
> showing 36 of 301 rows — these rows as CSV