PREVIEW / futures_1hour / 2015-06-21
file: by_date/futures_1hour/2015/2015-06-21.parquet size: 13 KB rows: 257
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 |
|---|---|---|---|---|---|---|---|
| 2015-06-21 18:00:00 | ES | Futures | 2242.61 | 2245.8 | 2240.21 | 2244.47 | 11718.0 |
| 2015-06-21 19:00:00 | ES | Futures | 2244.74 | 2245.01 | 2243.41 | 2243.94 | 3158.0 |
| 2015-06-21 20:00:00 | ES | Futures | 2243.67 | 2244.21 | 2242.88 | 2243.94 | 4111.0 |
| 2015-06-21 21:00:00 | ES | Futures | 2243.67 | 2244.47 | 2242.88 | 2244.21 | 3229.0 |
| 2015-06-21 22:00:00 | ES | Futures | 2244.21 | 2244.47 | 2242.88 | 2243.14 | 992.0 |
| 2015-06-21 23:00:00 | ES | Futures | 2243.41 | 2244.21 | 2243.14 | 2243.67 | 1858.0 |
| 2015-06-21 18:00:00 | NQ | Futures | 5339.0 | 5349.35 | 5338.7 | 5346.39 | 1193.0 |
| 2015-06-21 19:00:00 | NQ | Futures | 5346.69 | 5346.99 | 5342.55 | 5344.32 | 223.0 |
| 2015-06-21 20:00:00 | NQ | Futures | 5344.32 | 5345.21 | 5341.66 | 5344.91 | 577.0 |
| 2015-06-21 21:00:00 | NQ | Futures | 5344.32 | 5345.51 | 5342.25 | 5344.91 | 280.0 |
| 2015-06-21 22:00:00 | NQ | Futures | 5344.91 | 5344.91 | 5342.55 | 5343.14 | 103.0 |
| 2015-06-21 23:00:00 | NQ | Futures | 5342.84 | 5344.32 | 5342.55 | 5343.44 | 161.0 |
| 2015-06-21 18:00:00 | YM | Futures | 18927.5 | 18956.0 | 18926.5 | 18946.5 | 953.0 |
| 2015-06-21 19:00:00 | YM | Futures | 18946.5 | 18949.6 | 18937.0 | 18938.1 | 300.0 |
| 2015-06-21 20:00:00 | YM | Futures | 18939.1 | 18941.2 | 18932.8 | 18938.1 | 387.0 |
| 2015-06-21 21:00:00 | YM | Futures | 18938.1 | 18942.3 | 18932.8 | 18942.3 | 269.0 |
| 2015-06-21 22:00:00 | YM | Futures | 18941.2 | 18942.3 | 18934.9 | 18935.9 | 89.0 |
| 2015-06-21 23:00:00 | YM | Futures | 18937.0 | 18941.2 | 18934.9 | 18940.2 | 145.0 |
| 2015-06-21 18:00:00 | CL | Futures | 89.01 | 89.09 | 88.75 | 88.95 | 825.0 |
| 2015-06-21 19:00:00 | CL | Futures | 88.95 | 88.97 | 88.7 | 88.82 | 1011.0 |
| 2015-06-21 20:00:00 | CL | Futures | 88.82 | 89.13 | 88.82 | 89.0 | 1004.0 |
| 2015-06-21 21:00:00 | CL | Futures | 89.01 | 89.18 | 89.01 | 89.13 | 659.0 |
| 2015-06-21 22:00:00 | CL | Futures | 89.13 | 89.19 | 89.06 | 89.12 | 554.0 |
| 2015-06-21 23:00:00 | CL | Futures | 89.12 | 89.34 | 89.06 | 89.22 | 1046.0 |
| 2015-06-21 18:00:00 | GC | Futures | 1637.5 | 1639.0 | 1632.6 | 1635.5 | 2319.0 |
| 2015-06-21 19:00:00 | GC | Futures | 1635.8 | 1636.9 | 1634.9 | 1636.3 | 1301.0 |
| 2015-06-21 20:00:00 | GC | Futures | 1636.2 | 1637.3 | 1635.4 | 1636.7 | 769.0 |
| 2015-06-21 21:00:00 | GC | Futures | 1636.7 | 1637.7 | 1635.9 | 1636.7 | 1747.0 |
| 2015-06-21 22:00:00 | GC | Futures | 1636.6 | 1637.7 | 1634.9 | 1635.5 | 2485.0 |
| 2015-06-21 23:00:00 | GC | Futures | 1635.8 | 1636.6 | 1635.4 | 1636.2 | 515.0 |
| 2015-06-21 18:00:00 | ZN | Futures | 121.626601 | 121.671692 | 121.476296 | 121.491326 | 16693.0 |
| 2015-06-21 19:00:00 | ZN | Futures | 121.491326 | 121.581509 | 121.476296 | 121.566479 | 8351.0 |
| 2015-06-21 20:00:00 | ZN | Futures | 121.566479 | 121.626601 | 121.521387 | 121.551448 | 7615.0 |
| 2015-06-21 21:00:00 | ZN | Futures | 121.551448 | 121.59654 | 121.536418 | 121.581509 | 3331.0 |
| 2015-06-21 22:00:00 | ZN | Futures | 121.581509 | 121.581509 | 121.521387 | 121.521387 | 2823.0 |
| 2015-06-21 23:00:00 | ZN | Futures | 121.521387 | 121.581509 | 121.506357 | 121.581509 | 3351.0 |
> showing 36 of 257 rows — these rows as CSV