PREVIEW / futures_1hour / 2018-02-11
file: by_date/futures_1hour/2018/2018-02-11.parquet size: 16 KB rows: 311
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-02-11 18:00:00 | ES | Futures | 2873.5 | 2880.33 | 2867.76 | 2880.06 | 26948.0 |
| 2018-02-11 19:00:00 | ES | Futures | 2880.06 | 2883.61 | 2875.96 | 2882.52 | 16786.0 |
| 2018-02-11 20:00:00 | ES | Futures | 2882.52 | 2885.8 | 2875.96 | 2877.87 | 15180.0 |
| 2018-02-11 21:00:00 | ES | Futures | 2877.6 | 2882.24 | 2876.5 | 2880.88 | 8346.0 |
| 2018-02-11 22:00:00 | ES | Futures | 2880.88 | 2883.61 | 2878.69 | 2879.24 | 5763.0 |
| 2018-02-11 23:00:00 | ES | Futures | 2879.24 | 2880.88 | 2878.14 | 2880.6 | 3166.0 |
| 2018-02-11 18:00:00 | NQ | Futures | 7633.74 | 7643.53 | 7609.72 | 7639.97 | 7040.0 |
| 2018-02-11 19:00:00 | NQ | Futures | 7640.27 | 7650.65 | 7629.89 | 7648.28 | 8735.0 |
| 2018-02-11 20:00:00 | NQ | Futures | 7648.57 | 7657.17 | 7638.19 | 7641.45 | 7534.0 |
| 2018-02-11 21:00:00 | NQ | Futures | 7641.16 | 7649.46 | 7632.56 | 7648.28 | 4208.0 |
| 2018-02-11 22:00:00 | NQ | Futures | 7647.68 | 7648.57 | 7638.49 | 7639.38 | 2051.0 |
| 2018-02-11 23:00:00 | NQ | Futures | 7639.67 | 7646.2 | 7638.19 | 7645.01 | 1152.0 |
| 2018-02-11 18:00:00 | YM | Futures | 26357.9 | 26423.1 | 26322.1 | 26416.6 | 4948.0 |
| 2018-02-11 19:00:00 | YM | Futures | 26416.6 | 26464.4 | 26389.5 | 26459.0 | 3709.0 |
| 2018-02-11 20:00:00 | YM | Futures | 26460.1 | 26492.7 | 26378.6 | 26394.9 | 4173.0 |
| 2018-02-11 21:00:00 | YM | Futures | 26394.9 | 26452.5 | 26381.8 | 26438.4 | 2870.0 |
| 2018-02-11 22:00:00 | YM | Futures | 26440.5 | 26474.2 | 26422.1 | 26430.8 | 1772.0 |
| 2018-02-11 23:00:00 | YM | Futures | 26431.8 | 26439.4 | 26403.6 | 26422.1 | 1607.0 |
| 2018-02-11 18:00:00 | CL | Futures | 52.44 | 52.81 | 52.44 | 52.78 | 1053.0 |
| 2018-02-11 19:00:00 | CL | Futures | 52.76 | 53.06 | 52.75 | 53.05 | 1797.0 |
| 2018-02-11 20:00:00 | CL | Futures | 53.05 | 53.17 | 53.03 | 53.09 | 1793.0 |
| 2018-02-11 21:00:00 | CL | Futures | 53.1 | 53.33 | 53.04 | 53.25 | 1812.0 |
| 2018-02-11 22:00:00 | CL | Futures | 53.25 | 53.25 | 53.16 | 53.21 | 601.0 |
| 2018-02-11 23:00:00 | CL | Futures | 53.2 | 53.25 | 53.18 | 53.2 | 443.0 |
| 2018-02-11 18:00:00 | GC | Futures | 1742.9 | 1745.5 | 1741.9 | 1744.9 | 3861.0 |
| 2018-02-11 19:00:00 | GC | Futures | 1744.9 | 1746.1 | 1744.4 | 1745.3 | 3122.0 |
| 2018-02-11 20:00:00 | GC | Futures | 1745.5 | 1760.0 | 1745.3 | 1754.6 | 18638.0 |
| 2018-02-11 21:00:00 | GC | Futures | 1754.7 | 1757.8 | 1752.5 | 1754.9 | 8543.0 |
| 2018-02-11 22:00:00 | GC | Futures | 1754.9 | 1755.8 | 1753.4 | 1755.1 | 3485.0 |
| 2018-02-11 23:00:00 | GC | Futures | 1755.0 | 1755.4 | 1753.5 | 1754.9 | 2069.0 |
| 2018-02-11 18:00:00 | ZN | Futures | 120.681629 | 120.681629 | 120.572485 | 120.603669 | 21399.0 |
| 2018-02-11 19:00:00 | ZN | Futures | 120.603669 | 120.619261 | 120.556893 | 120.556893 | 11871.0 |
| 2018-02-11 20:00:00 | ZN | Futures | 120.556893 | 120.588077 | 120.525709 | 120.525709 | 12589.0 |
| 2018-02-11 21:00:00 | ZN | Futures | 120.525709 | 120.541301 | 120.494526 | 120.494526 | 8163.0 |
| 2018-02-11 22:00:00 | ZN | Futures | 120.510118 | 120.510118 | 120.463342 | 120.494526 | 7454.0 |
| 2018-02-11 23:00:00 | ZN | Futures | 120.494526 | 120.494526 | 120.478934 | 120.478934 | 3953.0 |
> showing 36 of 311 rows — these rows as CSV