PREVIEW / futures_1hour / 2017-06-18
file: by_date/futures_1hour/2017/2017-06-18.parquet size: 14 KB rows: 287
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 |
|---|---|---|---|---|---|---|---|
| 2017-06-18 18:00:00 | ES | Futures | 2660.68 | 2662.05 | 2659.86 | 2660.68 | 7293.0 |
| 2017-06-18 19:00:00 | ES | Futures | 2660.96 | 2661.23 | 2660.41 | 2660.68 | 3002.0 |
| 2017-06-18 20:00:00 | ES | Futures | 2660.68 | 2663.96 | 2660.41 | 2662.87 | 11320.0 |
| 2017-06-18 21:00:00 | ES | Futures | 2663.14 | 2665.06 | 2663.14 | 2663.42 | 6443.0 |
| 2017-06-18 22:00:00 | ES | Futures | 2663.14 | 2664.24 | 2663.14 | 2663.69 | 2897.0 |
| 2017-06-18 23:00:00 | ES | Futures | 2663.42 | 2663.96 | 2663.14 | 2663.14 | 1716.0 |
| 2017-06-18 18:00:00 | NQ | Futures | 6781.88 | 6781.88 | 6768.78 | 6774.73 | 1817.0 |
| 2017-06-18 19:00:00 | NQ | Futures | 6775.03 | 6778.9 | 6773.54 | 6778.9 | 625.0 |
| 2017-06-18 20:00:00 | NQ | Futures | 6778.6 | 6795.28 | 6776.22 | 6793.19 | 3011.0 |
| 2017-06-18 21:00:00 | NQ | Futures | 6793.19 | 6803.32 | 6793.19 | 6796.77 | 2500.0 |
| 2017-06-18 22:00:00 | NQ | Futures | 6797.07 | 6802.72 | 6796.77 | 6801.53 | 1448.0 |
| 2017-06-18 23:00:00 | NQ | Futures | 6801.53 | 6801.83 | 6798.55 | 6798.55 | 709.0 |
| 2017-06-18 18:00:00 | YM | Futures | 23257.6 | 23257.6 | 23241.3 | 23243.4 | 1199.0 |
| 2017-06-18 19:00:00 | YM | Futures | 23242.4 | 23245.6 | 23240.2 | 23242.4 | 565.0 |
| 2017-06-18 20:00:00 | YM | Futures | 23241.3 | 23267.4 | 23238.0 | 23261.9 | 1974.0 |
| 2017-06-18 21:00:00 | YM | Futures | 23263.0 | 23276.1 | 23261.9 | 23265.2 | 1389.0 |
| 2017-06-18 22:00:00 | YM | Futures | 23265.2 | 23271.7 | 23258.7 | 23268.5 | 1480.0 |
| 2017-06-18 23:00:00 | YM | Futures | 23268.5 | 23271.7 | 23266.3 | 23266.3 | 607.0 |
| 2017-06-18 18:00:00 | CL | Futures | 40.87 | 40.94 | 40.83 | 40.84 | 1853.0 |
| 2017-06-18 19:00:00 | CL | Futures | 40.84 | 40.89 | 40.82 | 40.84 | 1513.0 |
| 2017-06-18 20:00:00 | CL | Futures | 40.84 | 40.86 | 40.68 | 40.72 | 4315.0 |
| 2017-06-18 21:00:00 | CL | Futures | 40.71 | 40.78 | 40.7 | 40.75 | 4199.0 |
| 2017-06-18 22:00:00 | CL | Futures | 40.75 | 40.82 | 40.74 | 40.81 | 3311.0 |
| 2017-06-18 23:00:00 | CL | Futures | 40.82 | 40.85 | 40.8 | 40.83 | 2754.0 |
| 2017-06-18 18:00:00 | GC | Futures | 1681.2 | 1682.8 | 1680.0 | 1682.0 | 1547.0 |
| 2017-06-18 19:00:00 | GC | Futures | 1682.0 | 1683.2 | 1680.0 | 1681.6 | 4316.0 |
| 2017-06-18 20:00:00 | GC | Futures | 1681.6 | 1682.6 | 1679.5 | 1679.8 | 4130.0 |
| 2017-06-18 21:00:00 | GC | Futures | 1679.8 | 1679.8 | 1676.4 | 1679.0 | 7917.0 |
| 2017-06-18 22:00:00 | GC | Futures | 1678.8 | 1680.0 | 1678.3 | 1679.9 | 3170.0 |
| 2017-06-18 23:00:00 | GC | Futures | 1679.9 | 1680.0 | 1679.0 | 1679.1 | 1808.0 |
| 2017-06-18 18:00:00 | ZN | Futures | 126.012343 | 126.058933 | 125.981282 | 125.996812 | 6979.0 |
| 2017-06-18 19:00:00 | ZN | Futures | 125.996812 | 126.012343 | 125.981282 | 125.996812 | 2552.0 |
| 2017-06-18 20:00:00 | ZN | Futures | 125.996812 | 126.012343 | 125.934692 | 125.965752 | 13443.0 |
| 2017-06-18 21:00:00 | ZN | Futures | 125.965752 | 125.996812 | 125.919161 | 125.996812 | 6585.0 |
| 2017-06-18 22:00:00 | ZN | Futures | 125.981282 | 125.996812 | 125.965752 | 125.981282 | 6050.0 |
| 2017-06-18 23:00:00 | ZN | Futures | 125.981282 | 125.996812 | 125.965752 | 125.965752 | 4156.0 |
> showing 36 of 287 rows — these rows as CSV