PREVIEW / futures_1hour / 2015-09-27
file: by_date/futures_1hour/2015/2015-09-27.parquet size: 14 KB rows: 266
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-09-27 18:00:00 | ES | Futures | 2050.17 | 2051.24 | 2039.2 | 2044.02 | 17311.0 |
| 2015-09-27 19:00:00 | ES | Futures | 2044.29 | 2045.62 | 2041.88 | 2044.82 | 5408.0 |
| 2015-09-27 20:00:00 | ES | Futures | 2044.82 | 2049.1 | 2040.81 | 2045.62 | 12045.0 |
| 2015-09-27 21:00:00 | ES | Futures | 2045.89 | 2049.1 | 2044.02 | 2047.5 | 10400.0 |
| 2015-09-27 22:00:00 | ES | Futures | 2047.5 | 2048.03 | 2045.09 | 2046.96 | 3437.0 |
| 2015-09-27 23:00:00 | ES | Futures | 2046.69 | 2050.97 | 2046.69 | 2050.44 | 4117.0 |
| 2015-09-27 18:00:00 | NQ | Futures | 4984.01 | 4990.83 | 4958.81 | 4970.67 | 2301.0 |
| 2015-09-27 19:00:00 | NQ | Futures | 4970.67 | 4975.12 | 4962.96 | 4973.64 | 766.0 |
| 2015-09-27 20:00:00 | NQ | Futures | 4973.93 | 4990.54 | 4962.07 | 4975.71 | 2269.0 |
| 2015-09-27 21:00:00 | NQ | Futures | 4976.6 | 4986.39 | 4971.26 | 4982.24 | 1544.0 |
| 2015-09-27 22:00:00 | NQ | Futures | 4982.53 | 4983.42 | 4975.42 | 4979.57 | 656.0 |
| 2015-09-27 23:00:00 | NQ | Futures | 4979.86 | 4988.46 | 4978.38 | 4988.46 | 699.0 |
| 2015-09-27 18:00:00 | YM | Futures | 17119.7 | 17139.8 | 17051.9 | 17085.8 | 2406.0 |
| 2015-09-27 19:00:00 | YM | Futures | 17087.9 | 17098.5 | 17069.9 | 17094.2 | 633.0 |
| 2015-09-27 20:00:00 | YM | Futures | 17092.1 | 17127.1 | 17063.5 | 17102.7 | 1999.0 |
| 2015-09-27 21:00:00 | YM | Futures | 17101.6 | 17126.0 | 17091.1 | 17117.5 | 1413.0 |
| 2015-09-27 22:00:00 | YM | Futures | 17117.5 | 17119.7 | 17097.4 | 17113.3 | 727.0 |
| 2015-09-27 23:00:00 | YM | Futures | 17113.3 | 17141.9 | 17111.2 | 17141.9 | 908.0 |
| 2015-09-27 18:00:00 | CL | Futures | 64.92 | 65.09 | 64.79 | 64.96 | 706.0 |
| 2015-09-27 19:00:00 | CL | Futures | 64.96 | 65.03 | 64.86 | 64.96 | 384.0 |
| 2015-09-27 20:00:00 | CL | Futures | 64.96 | 64.99 | 64.83 | 64.93 | 534.0 |
| 2015-09-27 21:00:00 | CL | Futures | 64.93 | 64.96 | 64.59 | 64.71 | 1564.0 |
| 2015-09-27 22:00:00 | CL | Futures | 64.71 | 64.78 | 64.62 | 64.72 | 614.0 |
| 2015-09-27 23:00:00 | CL | Futures | 64.71 | 64.82 | 64.68 | 64.79 | 593.0 |
| 2015-09-27 18:00:00 | GC | Futures | 1563.3 | 1564.9 | 1561.8 | 1564.7 | 847.0 |
| 2015-09-27 19:00:00 | GC | Futures | 1564.7 | 1565.2 | 1564.7 | 1565.2 | 528.0 |
| 2015-09-27 20:00:00 | GC | Futures | 1565.1 | 1567.1 | 1564.1 | 1564.9 | 1989.0 |
| 2015-09-27 21:00:00 | GC | Futures | 1564.8 | 1565.5 | 1562.2 | 1562.5 | 2494.0 |
| 2015-09-27 22:00:00 | GC | Futures | 1562.5 | 1565.1 | 1560.8 | 1564.8 | 2199.0 |
| 2015-09-27 23:00:00 | GC | Futures | 1564.8 | 1566.0 | 1563.4 | 1563.7 | 1927.0 |
| 2015-09-27 18:00:00 | ZN | Futures | 123.491008 | 123.536271 | 123.475921 | 123.521183 | 3145.0 |
| 2015-09-27 19:00:00 | ZN | Futures | 123.521183 | 123.551358 | 123.491008 | 123.536271 | 2310.0 |
| 2015-09-27 20:00:00 | ZN | Futures | 123.536271 | 123.611708 | 123.506096 | 123.551358 | 8847.0 |
| 2015-09-27 21:00:00 | ZN | Futures | 123.551358 | 123.596621 | 123.536271 | 123.581533 | 3373.0 |
| 2015-09-27 22:00:00 | ZN | Futures | 123.596621 | 123.611708 | 123.566446 | 123.611708 | 2516.0 |
| 2015-09-27 23:00:00 | ZN | Futures | 123.611708 | 123.641883 | 123.581533 | 123.596621 | 5357.0 |
> showing 36 of 266 rows — these rows as CSV