PREVIEW / futures_1hour / 2019-02-24
file: by_date/futures_1hour/2019/2019-02-24.parquet size: 16 KB rows: 330
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 |
|---|---|---|---|---|---|---|---|
| 2019-02-24 18:00:00 | ES | Futures | 3041.2 | 3045.55 | 3039.3 | 3042.56 | 21193.0 |
| 2019-02-24 19:00:00 | ES | Futures | 3042.56 | 3043.38 | 3040.12 | 3042.29 | 7886.0 |
| 2019-02-24 20:00:00 | ES | Futures | 3042.29 | 3044.46 | 3040.66 | 3041.2 | 11645.0 |
| 2019-02-24 21:00:00 | ES | Futures | 3041.48 | 3043.11 | 3035.77 | 3038.22 | 14018.0 |
| 2019-02-24 22:00:00 | ES | Futures | 3038.49 | 3039.85 | 3037.67 | 3039.03 | 6571.0 |
| 2019-02-24 23:00:00 | ES | Futures | 3039.03 | 3040.12 | 3037.4 | 3040.12 | 3365.0 |
| 2019-02-24 18:00:00 | NQ | Futures | 8308.11 | 8330.61 | 8308.11 | 8320.97 | 5952.0 |
| 2019-02-24 19:00:00 | NQ | Futures | 8320.68 | 8322.72 | 8309.86 | 8318.34 | 3793.0 |
| 2019-02-24 20:00:00 | NQ | Futures | 8318.34 | 8326.81 | 8314.83 | 8316.0 | 4666.0 |
| 2019-02-24 21:00:00 | NQ | Futures | 8316.59 | 8321.26 | 8300.51 | 8307.53 | 5097.0 |
| 2019-02-24 22:00:00 | NQ | Futures | 8307.23 | 8311.03 | 8304.31 | 8308.11 | 2733.0 |
| 2019-02-24 23:00:00 | NQ | Futures | 8308.4 | 8313.37 | 8303.73 | 8312.49 | 1414.0 |
| 2019-02-24 18:00:00 | YM | Futures | 28308.7 | 28356.5 | 28300.0 | 28334.8 | 3540.0 |
| 2019-02-24 19:00:00 | YM | Futures | 28334.8 | 28344.5 | 28314.1 | 28332.6 | 2347.0 |
| 2019-02-24 20:00:00 | YM | Futures | 28333.7 | 28352.1 | 28314.1 | 28322.8 | 2958.0 |
| 2019-02-24 21:00:00 | YM | Futures | 28323.9 | 28336.9 | 28271.8 | 28293.5 | 3227.0 |
| 2019-02-24 22:00:00 | YM | Futures | 28293.5 | 28310.9 | 28289.2 | 28305.5 | 1915.0 |
| 2019-02-24 23:00:00 | YM | Futures | 28304.4 | 28314.1 | 28279.4 | 28312.0 | 1569.0 |
| 2019-02-24 18:00:00 | CL | Futures | 51.51 | 51.67 | 51.47 | 51.67 | 4435.0 |
| 2019-02-24 19:00:00 | CL | Futures | 51.67 | 51.8 | 51.65 | 51.76 | 4799.0 |
| 2019-02-24 20:00:00 | CL | Futures | 51.77 | 51.84 | 51.49 | 51.55 | 11793.0 |
| 2019-02-24 21:00:00 | CL | Futures | 51.56 | 51.6 | 51.46 | 51.53 | 7637.0 |
| 2019-02-24 22:00:00 | CL | Futures | 51.53 | 51.54 | 51.4 | 51.44 | 5019.0 |
| 2019-02-24 23:00:00 | CL | Futures | 51.44 | 51.48 | 51.39 | 51.48 | 3479.0 |
| 2019-02-24 18:00:00 | GC | Futures | 1717.5 | 1717.6 | 1714.1 | 1715.0 | 2798.0 |
| 2019-02-24 19:00:00 | GC | Futures | 1715.0 | 1717.6 | 1714.8 | 1717.5 | 4004.0 |
| 2019-02-24 20:00:00 | GC | Futures | 1717.5 | 1719.3 | 1716.3 | 1718.5 | 7788.0 |
| 2019-02-24 21:00:00 | GC | Futures | 1718.5 | 1719.9 | 1718.3 | 1719.7 | 4628.0 |
| 2019-02-24 22:00:00 | GC | Futures | 1719.7 | 1720.3 | 1719.3 | 1719.6 | 2572.0 |
| 2019-02-24 23:00:00 | GC | Futures | 1719.6 | 1719.7 | 1718.8 | 1719.2 | 2491.0 |
| 2019-02-24 18:00:00 | ZN | Futures | 122.950613 | 122.982095 | 122.903391 | 122.934873 | 17592.0 |
| 2019-02-24 19:00:00 | ZN | Futures | 122.934873 | 122.982095 | 122.934873 | 122.966354 | 12165.0 |
| 2019-02-24 20:00:00 | ZN | Futures | 122.950613 | 122.982095 | 122.950613 | 122.966354 | 11577.0 |
| 2019-02-24 21:00:00 | ZN | Futures | 122.982095 | 123.029317 | 122.966354 | 123.013576 | 11800.0 |
| 2019-02-24 22:00:00 | ZN | Futures | 123.013576 | 123.029317 | 123.013576 | 123.013576 | 7379.0 |
| 2019-02-24 23:00:00 | ZN | Futures | 123.013576 | 123.029317 | 122.997835 | 122.997835 | 5285.0 |
> showing 36 of 330 rows — these rows as CSV