PREVIEW / futures_1hour / 2016-03-13
file: by_date/futures_1hour/2016/2016-03-13.parquet size: 15 KB rows: 282
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-13 18:00:00 | ES | Futures | 2170.36 | 2172.24 | 2168.21 | 2168.75 | 2923.0 |
| 2016-03-13 19:00:00 | ES | Futures | 2168.75 | 2170.09 | 2167.68 | 2169.83 | 2866.0 |
| 2016-03-13 20:00:00 | ES | Futures | 2170.09 | 2170.36 | 2167.94 | 2169.29 | 1877.0 |
| 2016-03-13 21:00:00 | ES | Futures | 2169.29 | 2170.63 | 2166.87 | 2168.75 | 3504.0 |
| 2016-03-13 22:00:00 | ES | Futures | 2168.75 | 2171.17 | 2167.94 | 2170.63 | 1434.0 |
| 2016-03-13 23:00:00 | ES | Futures | 2170.36 | 2170.9 | 2168.48 | 2169.02 | 1092.0 |
| 2016-03-13 18:00:00 | NQ | Futures | 5169.87 | 5175.22 | 5165.71 | 5166.61 | 206.0 |
| 2016-03-13 19:00:00 | NQ | Futures | 5166.61 | 5171.06 | 5163.93 | 5171.06 | 181.0 |
| 2016-03-13 20:00:00 | NQ | Futures | 5170.17 | 5170.47 | 5164.53 | 5168.39 | 145.0 |
| 2016-03-13 21:00:00 | NQ | Futures | 5170.17 | 5172.25 | 5162.75 | 5167.2 | 280.0 |
| 2016-03-13 22:00:00 | NQ | Futures | 5168.09 | 5174.33 | 5165.71 | 5172.84 | 115.0 |
| 2016-03-13 23:00:00 | NQ | Futures | 5173.43 | 5173.43 | 5166.01 | 5167.5 | 56.0 |
| 2016-03-13 18:00:00 | YM | Futures | 18295.1 | 18309.0 | 18279.0 | 18282.3 | 280.0 |
| 2016-03-13 19:00:00 | YM | Futures | 18280.1 | 18291.9 | 18275.8 | 18288.7 | 363.0 |
| 2016-03-13 20:00:00 | YM | Futures | 18289.8 | 18293.0 | 18273.7 | 18285.5 | 407.0 |
| 2016-03-13 21:00:00 | YM | Futures | 18286.5 | 18298.3 | 18269.4 | 18281.2 | 764.0 |
| 2016-03-13 22:00:00 | YM | Futures | 18282.3 | 18301.5 | 18275.8 | 18299.4 | 499.0 |
| 2016-03-13 23:00:00 | YM | Futures | 18301.5 | 18302.6 | 18282.3 | 18288.7 | 342.0 |
| 2016-03-13 18:00:00 | CL | Futures | 44.12 | 44.82 | 44.12 | 44.23 | 1956.0 |
| 2016-03-13 19:00:00 | CL | Futures | 44.23 | 44.46 | 44.23 | 44.36 | 2191.0 |
| 2016-03-13 20:00:00 | CL | Futures | 44.36 | 44.43 | 44.32 | 44.35 | 1114.0 |
| 2016-03-13 21:00:00 | CL | Futures | 44.35 | 44.39 | 44.19 | 44.31 | 1772.0 |
| 2016-03-13 22:00:00 | CL | Futures | 44.31 | 44.42 | 44.26 | 44.39 | 1460.0 |
| 2016-03-13 23:00:00 | CL | Futures | 44.4 | 44.45 | 44.35 | 44.38 | 1058.0 |
| 2016-03-13 18:00:00 | GC | Futures | 1707.6 | 1710.1 | 1704.6 | 1708.7 | 2200.0 |
| 2016-03-13 19:00:00 | GC | Futures | 1708.8 | 1712.2 | 1708.3 | 1711.4 | 2006.0 |
| 2016-03-13 20:00:00 | GC | Futures | 1711.3 | 1714.3 | 1710.3 | 1713.6 | 2662.0 |
| 2016-03-13 21:00:00 | GC | Futures | 1713.6 | 1715.7 | 1711.0 | 1713.7 | 6041.0 |
| 2016-03-13 22:00:00 | GC | Futures | 1713.9 | 1716.3 | 1713.2 | 1715.8 | 2878.0 |
| 2016-03-13 23:00:00 | GC | Futures | 1715.7 | 1716.6 | 1710.2 | 1711.3 | 3367.0 |
| 2016-03-13 18:00:00 | ZN | Futures | 124.977916 | 125.023562 | 124.947485 | 125.008346 | 6443.0 |
| 2016-03-13 19:00:00 | ZN | Futures | 125.023562 | 125.038777 | 124.962701 | 124.962701 | 3964.0 |
| 2016-03-13 20:00:00 | ZN | Futures | 124.962701 | 124.993131 | 124.90184 | 124.917055 | 11700.0 |
| 2016-03-13 21:00:00 | ZN | Futures | 124.917055 | 124.962701 | 124.871409 | 124.947485 | 9359.0 |
| 2016-03-13 22:00:00 | ZN | Futures | 124.93227 | 124.947485 | 124.886625 | 124.90184 | 5848.0 |
| 2016-03-13 23:00:00 | ZN | Futures | 124.886625 | 124.90184 | 124.871409 | 124.886625 | 4687.0 |
> showing 36 of 282 rows — these rows as CSV