PREVIEW / futures_1hour / 2018-09-02
file: by_date/futures_1hour/2018/2018-09-02.parquet size: 14 KB rows: 261
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-02 18:00:00 | ES | Futures | 3167.69 | 3168.24 | 3165.79 | 3167.15 | 5058.0 |
| 2018-09-02 19:00:00 | ES | Futures | 3167.15 | 3168.51 | 3166.06 | 3167.69 | 3213.0 |
| 2018-09-02 20:00:00 | ES | Futures | 3167.69 | 3167.69 | 3165.24 | 3167.42 | 6241.0 |
| 2018-09-02 21:00:00 | ES | Futures | 3167.42 | 3168.24 | 3164.7 | 3167.97 | 6216.0 |
| 2018-09-02 22:00:00 | ES | Futures | 3167.69 | 3167.69 | 3165.24 | 3166.33 | 4690.0 |
| 2018-09-02 23:00:00 | ES | Futures | 3166.33 | 3166.88 | 3163.88 | 3165.24 | 4078.0 |
| 2018-09-02 18:00:00 | NQ | Futures | 9032.75 | 9038.64 | 9026.27 | 9029.51 | 1201.0 |
| 2018-09-02 19:00:00 | NQ | Futures | 9029.51 | 9040.11 | 9027.15 | 9036.87 | 1365.0 |
| 2018-09-02 20:00:00 | NQ | Futures | 9036.58 | 9037.46 | 9029.8 | 9035.1 | 1892.0 |
| 2018-09-02 21:00:00 | NQ | Futures | 9035.1 | 9042.17 | 9026.86 | 9038.93 | 2579.0 |
| 2018-09-02 22:00:00 | NQ | Futures | 9038.64 | 9039.81 | 9029.51 | 9033.34 | 1344.0 |
| 2018-09-02 23:00:00 | NQ | Futures | 9033.04 | 9034.22 | 9024.8 | 9029.51 | 1122.0 |
| 2018-09-02 18:00:00 | YM | Futures | 28288.5 | 28305.8 | 28266.7 | 28272.1 | 798.0 |
| 2018-09-02 19:00:00 | YM | Futures | 28271.1 | 28284.1 | 28259.1 | 28279.8 | 779.0 |
| 2018-09-02 20:00:00 | YM | Futures | 28277.6 | 28278.7 | 28250.4 | 28266.7 | 1461.0 |
| 2018-09-02 21:00:00 | YM | Futures | 28268.9 | 28276.5 | 28242.8 | 28271.1 | 1759.0 |
| 2018-09-02 22:00:00 | YM | Futures | 28270.0 | 28270.0 | 28240.6 | 28252.6 | 1182.0 |
| 2018-09-02 23:00:00 | YM | Futures | 28252.6 | 28256.9 | 28229.7 | 28240.6 | 999.0 |
| 2018-09-02 18:00:00 | CL | Futures | 64.17 | 64.27 | 64.17 | 64.22 | 1365.0 |
| 2018-09-02 19:00:00 | CL | Futures | 64.22 | 64.22 | 64.16 | 64.2 | 767.0 |
| 2018-09-02 20:00:00 | CL | Futures | 64.19 | 64.22 | 64.04 | 64.08 | 3327.0 |
| 2018-09-02 21:00:00 | CL | Futures | 64.08 | 64.11 | 64.01 | 64.06 | 3932.0 |
| 2018-09-02 22:00:00 | CL | Futures | 64.05 | 64.06 | 63.84 | 63.9 | 6810.0 |
| 2018-09-02 23:00:00 | CL | Futures | 63.9 | 63.95 | 63.86 | 63.91 | 3901.0 |
| 2018-09-02 18:00:00 | GC | Futures | 1571.6 | 1572.2 | 1570.1 | 1570.6 | 1352.0 |
| 2018-09-02 19:00:00 | GC | Futures | 1570.6 | 1571.1 | 1569.2 | 1569.8 | 2338.0 |
| 2018-09-02 20:00:00 | GC | Futures | 1569.7 | 1569.9 | 1565.0 | 1567.5 | 9046.0 |
| 2018-09-02 21:00:00 | GC | Futures | 1567.3 | 1570.2 | 1565.0 | 1569.3 | 13073.0 |
| 2018-09-02 22:00:00 | GC | Futures | 1569.2 | 1571.4 | 1568.5 | 1569.9 | 5212.0 |
| 2018-09-02 23:00:00 | GC | Futures | 1569.9 | 1570.9 | 1568.6 | 1570.2 | 3694.0 |
| 2018-09-02 18:00:00 | ZN | Futures | 121.029548 | 121.076696 | 121.013832 | 121.076696 | 182.0 |
| 2018-09-02 19:00:00 | ZN | Futures | 121.06098 | 121.06098 | 121.013832 | 121.013832 | 175.0 |
| 2018-09-02 20:00:00 | ZN | Futures | 121.013832 | 121.029548 | 121.013832 | 121.013832 | 218.0 |
| 2018-09-02 21:00:00 | ZN | Futures | 121.013832 | 121.045264 | 121.013832 | 121.045264 | 978.0 |
| 2018-09-02 22:00:00 | ZN | Futures | 121.045264 | 121.045264 | 121.045264 | 121.045264 | 121.0 |
| 2018-09-02 23:00:00 | ZN | Futures | 121.029548 | 121.06098 | 121.029548 | 121.029548 | 114.0 |
> showing 36 of 261 rows — these rows as CSV