PREVIEW / futures_1hour / 2016-04-03
file: by_date/futures_1hour/2016/2016-04-03.parquet size: 14 KB rows: 285
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-04-03 18:00:00 | ES | Futures | 2228.95 | 2229.22 | 2225.98 | 2227.6 | 6471.0 |
| 2016-04-03 19:00:00 | ES | Futures | 2227.87 | 2227.87 | 2225.98 | 2226.25 | 4405.0 |
| 2016-04-03 20:00:00 | ES | Futures | 2226.25 | 2230.03 | 2225.72 | 2228.68 | 12641.0 |
| 2016-04-03 21:00:00 | ES | Futures | 2228.68 | 2230.3 | 2228.14 | 2228.68 | 5019.0 |
| 2016-04-03 22:00:00 | ES | Futures | 2228.68 | 2230.03 | 2227.87 | 2229.49 | 4065.0 |
| 2016-04-03 23:00:00 | ES | Futures | 2229.76 | 2233.27 | 2229.76 | 2231.11 | 8745.0 |
| 2016-04-03 18:00:00 | NQ | Futures | 5387.37 | 5388.86 | 5380.82 | 5383.8 | 999.0 |
| 2016-04-03 19:00:00 | NQ | Futures | 5384.4 | 5384.69 | 5379.34 | 5379.34 | 552.0 |
| 2016-04-03 20:00:00 | NQ | Futures | 5379.63 | 5388.56 | 5378.15 | 5385.29 | 1326.0 |
| 2016-04-03 21:00:00 | NQ | Futures | 5384.99 | 5389.45 | 5383.5 | 5385.88 | 434.0 |
| 2016-04-03 22:00:00 | NQ | Futures | 5385.59 | 5388.56 | 5383.5 | 5387.97 | 304.0 |
| 2016-04-03 23:00:00 | NQ | Futures | 5388.56 | 5396.89 | 5388.26 | 5391.83 | 1049.0 |
| 2016-04-03 18:00:00 | YM | Futures | 18948.0 | 18948.0 | 18920.2 | 18934.1 | 2539.0 |
| 2016-04-03 19:00:00 | YM | Futures | 18933.1 | 18936.3 | 18923.4 | 18924.5 | 768.0 |
| 2016-04-03 20:00:00 | YM | Futures | 18923.4 | 18955.5 | 18921.3 | 18943.8 | 2723.0 |
| 2016-04-03 21:00:00 | YM | Futures | 18943.8 | 18955.5 | 18936.3 | 18941.6 | 617.0 |
| 2016-04-03 22:00:00 | YM | Futures | 18941.6 | 18950.2 | 18935.2 | 18949.1 | 539.0 |
| 2016-04-03 23:00:00 | YM | Futures | 18950.2 | 18975.9 | 18950.2 | 18960.9 | 1708.0 |
| 2016-04-03 18:00:00 | CL | Futures | 40.64 | 40.74 | 40.2 | 40.34 | 5481.0 |
| 2016-04-03 19:00:00 | CL | Futures | 40.34 | 40.47 | 40.33 | 40.38 | 2199.0 |
| 2016-04-03 20:00:00 | CL | Futures | 40.38 | 40.59 | 40.19 | 40.34 | 13587.0 |
| 2016-04-03 21:00:00 | CL | Futures | 40.34 | 40.39 | 40.16 | 40.38 | 4132.0 |
| 2016-04-03 22:00:00 | CL | Futures | 40.37 | 40.48 | 40.31 | 40.38 | 2346.0 |
| 2016-04-03 23:00:00 | CL | Futures | 40.38 | 40.42 | 40.34 | 40.38 | 1044.0 |
| 2016-04-03 18:00:00 | GC | Futures | 1668.0 | 1668.1 | 1663.1 | 1664.0 | 1900.0 |
| 2016-04-03 19:00:00 | GC | Futures | 1664.2 | 1667.2 | 1664.0 | 1666.5 | 1203.0 |
| 2016-04-03 20:00:00 | GC | Futures | 1666.5 | 1669.0 | 1665.1 | 1669.0 | 2548.0 |
| 2016-04-03 21:00:00 | GC | Futures | 1669.0 | 1669.4 | 1660.6 | 1662.4 | 3998.0 |
| 2016-04-03 22:00:00 | GC | Futures | 1662.3 | 1665.8 | 1661.3 | 1662.1 | 2295.0 |
| 2016-04-03 23:00:00 | GC | Futures | 1662.0 | 1664.5 | 1661.2 | 1664.2 | 1533.0 |
| 2016-04-03 18:00:00 | ZN | Futures | 127.047188 | 127.138479 | 127.016757 | 127.092833 | 7259.0 |
| 2016-04-03 19:00:00 | ZN | Futures | 127.092833 | 127.123264 | 127.047188 | 127.092833 | 3645.0 |
| 2016-04-03 20:00:00 | ZN | Futures | 127.077618 | 127.184125 | 127.077618 | 127.138479 | 12328.0 |
| 2016-04-03 21:00:00 | ZN | Futures | 127.138479 | 127.184125 | 127.077618 | 127.184125 | 6729.0 |
| 2016-04-03 22:00:00 | ZN | Futures | 127.168909 | 127.184125 | 127.108048 | 127.123264 | 3404.0 |
| 2016-04-03 23:00:00 | ZN | Futures | 127.123264 | 127.168909 | 127.077618 | 127.168909 | 7708.0 |
> showing 36 of 285 rows — these rows as CSV