PREVIEW / futures_1hour / 2018-04-01
file: by_date/futures_1hour/2018/2018-04-01.parquet size: 15 KB rows: 295
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-04-01 18:00:00 | ES | Futures | 2876.45 | 2883.55 | 2872.36 | 2878.63 | 12673.0 |
| 2018-04-01 19:00:00 | ES | Futures | 2878.63 | 2881.64 | 2872.63 | 2877.54 | 8954.0 |
| 2018-04-01 20:00:00 | ES | Futures | 2877.54 | 2883.27 | 2875.63 | 2878.09 | 10213.0 |
| 2018-04-01 21:00:00 | ES | Futures | 2878.09 | 2883.0 | 2876.72 | 2882.18 | 7322.0 |
| 2018-04-01 22:00:00 | ES | Futures | 2882.18 | 2883.27 | 2875.09 | 2878.09 | 5304.0 |
| 2018-04-01 23:00:00 | ES | Futures | 2877.82 | 2880.54 | 2875.9 | 2879.18 | 4095.0 |
| 2018-04-01 18:00:00 | NQ | Futures | 7751.22 | 7788.45 | 7749.44 | 7763.04 | 3961.0 |
| 2018-04-01 19:00:00 | NQ | Futures | 7763.04 | 7770.43 | 7740.87 | 7753.58 | 3017.0 |
| 2018-04-01 20:00:00 | NQ | Futures | 7753.88 | 7774.27 | 7745.31 | 7762.15 | 3861.0 |
| 2018-04-01 21:00:00 | NQ | Futures | 7761.56 | 7771.9 | 7754.47 | 7765.99 | 2420.0 |
| 2018-04-01 22:00:00 | NQ | Futures | 7765.7 | 7769.84 | 7748.26 | 7755.35 | 1980.0 |
| 2018-04-01 23:00:00 | NQ | Futures | 7755.65 | 7765.11 | 7750.33 | 7761.27 | 1594.0 |
| 2018-04-01 18:00:00 | YM | Futures | 26169.9 | 26224.2 | 26121.0 | 26180.8 | 2028.0 |
| 2018-04-01 19:00:00 | YM | Futures | 26180.8 | 26201.4 | 26129.7 | 26164.5 | 1666.0 |
| 2018-04-01 20:00:00 | YM | Futures | 26166.6 | 26214.4 | 26149.3 | 26175.3 | 3440.0 |
| 2018-04-01 21:00:00 | YM | Futures | 26174.2 | 26222.0 | 26162.3 | 26211.2 | 3941.0 |
| 2018-04-01 22:00:00 | YM | Futures | 26212.3 | 26219.9 | 26151.4 | 26166.6 | 2458.0 |
| 2018-04-01 23:00:00 | YM | Futures | 26167.7 | 26179.7 | 26138.4 | 26169.9 | 2849.0 |
| 2018-04-01 18:00:00 | CL | Futures | 57.91 | 58.08 | 57.87 | 58.04 | 3813.0 |
| 2018-04-01 19:00:00 | CL | Futures | 58.04 | 58.12 | 58.0 | 58.07 | 2425.0 |
| 2018-04-01 20:00:00 | CL | Futures | 58.07 | 58.31 | 58.07 | 58.13 | 7653.0 |
| 2018-04-01 21:00:00 | CL | Futures | 58.13 | 58.21 | 58.13 | 58.18 | 5016.0 |
| 2018-04-01 22:00:00 | CL | Futures | 58.19 | 58.25 | 58.12 | 58.15 | 4384.0 |
| 2018-04-01 23:00:00 | CL | Futures | 58.15 | 58.17 | 58.13 | 58.16 | 1608.0 |
| 2018-04-01 18:00:00 | GC | Futures | 1753.3 | 1753.7 | 1751.0 | 1752.9 | 2999.0 |
| 2018-04-01 19:00:00 | GC | Futures | 1752.7 | 1754.6 | 1752.6 | 1753.5 | 2988.0 |
| 2018-04-01 20:00:00 | GC | Futures | 1753.4 | 1753.7 | 1752.3 | 1753.5 | 4316.0 |
| 2018-04-01 21:00:00 | GC | Futures | 1753.5 | 1757.9 | 1753.5 | 1757.4 | 11757.0 |
| 2018-04-01 22:00:00 | GC | Futures | 1757.5 | 1758.0 | 1756.0 | 1757.4 | 6889.0 |
| 2018-04-01 23:00:00 | GC | Futures | 1757.2 | 1757.6 | 1756.2 | 1756.6 | 3955.0 |
| 2018-04-01 18:00:00 | ZN | Futures | 121.403724 | 121.43507 | 121.372378 | 121.419397 | 8355.0 |
| 2018-04-01 19:00:00 | ZN | Futures | 121.403724 | 121.43507 | 121.388051 | 121.403724 | 6858.0 |
| 2018-04-01 20:00:00 | ZN | Futures | 121.403724 | 121.43507 | 121.372378 | 121.372378 | 9016.0 |
| 2018-04-01 21:00:00 | ZN | Futures | 121.388051 | 121.388051 | 121.325359 | 121.341032 | 19495.0 |
| 2018-04-01 22:00:00 | ZN | Futures | 121.325359 | 121.372378 | 121.325359 | 121.356705 | 9493.0 |
| 2018-04-01 23:00:00 | ZN | Futures | 121.356705 | 121.372378 | 121.356705 | 121.372378 | 319.0 |
> showing 36 of 295 rows — these rows as CSV