PREVIEW / futures_1hour / 2014-08-17
file: by_date/futures_1hour/2014/2014-08-17.parquet size: 14 KB rows: 274
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 |
|---|---|---|---|---|---|---|---|
| 2014-08-17 18:00:00 | ES | Futures | 2038.78 | 2044.52 | 2038.78 | 2041.91 | 15531.0 |
| 2014-08-17 19:00:00 | ES | Futures | 2041.91 | 2043.21 | 2041.65 | 2042.43 | 3284.0 |
| 2014-08-17 20:00:00 | ES | Futures | 2042.17 | 2042.43 | 2040.87 | 2042.43 | 3506.0 |
| 2014-08-17 21:00:00 | ES | Futures | 2042.43 | 2042.43 | 2040.87 | 2041.91 | 4856.0 |
| 2014-08-17 22:00:00 | ES | Futures | 2041.91 | 2041.91 | 2039.83 | 2040.35 | 4340.0 |
| 2014-08-17 23:00:00 | ES | Futures | 2040.61 | 2041.91 | 2040.35 | 2041.65 | 2118.0 |
| 2014-08-17 18:00:00 | NQ | Futures | 4661.72 | 4673.99 | 4661.72 | 4668.73 | 2821.0 |
| 2014-08-17 19:00:00 | NQ | Futures | 4668.73 | 4671.36 | 4668.73 | 4670.77 | 303.0 |
| 2014-08-17 20:00:00 | NQ | Futures | 4670.48 | 4670.48 | 4667.56 | 4670.48 | 506.0 |
| 2014-08-17 21:00:00 | NQ | Futures | 4670.19 | 4670.19 | 4666.98 | 4667.56 | 889.0 |
| 2014-08-17 22:00:00 | NQ | Futures | 4667.85 | 4667.85 | 4662.89 | 4665.23 | 715.0 |
| 2014-08-17 23:00:00 | NQ | Futures | 4665.23 | 4668.15 | 4665.23 | 4667.56 | 431.0 |
| 2014-08-17 18:00:00 | YM | Futures | 17241.1 | 17284.5 | 17231.8 | 17260.7 | 1565.0 |
| 2014-08-17 19:00:00 | YM | Futures | 17259.7 | 17268.0 | 17258.7 | 17261.8 | 287.0 |
| 2014-08-17 20:00:00 | YM | Futures | 17260.7 | 17263.8 | 17252.5 | 17263.8 | 489.0 |
| 2014-08-17 21:00:00 | YM | Futures | 17263.8 | 17263.8 | 17252.5 | 17258.7 | 628.0 |
| 2014-08-17 22:00:00 | YM | Futures | 17257.6 | 17257.6 | 17243.1 | 17247.3 | 481.0 |
| 2014-08-17 23:00:00 | YM | Futures | 17247.3 | 17258.7 | 17247.3 | 17255.6 | 378.0 |
| 2014-08-17 18:00:00 | CL | Futures | 156.93 | 156.93 | 156.37 | 156.45 | 626.0 |
| 2014-08-17 19:00:00 | CL | Futures | 156.46 | 156.56 | 156.37 | 156.51 | 405.0 |
| 2014-08-17 20:00:00 | CL | Futures | 156.53 | 156.63 | 156.43 | 156.46 | 313.0 |
| 2014-08-17 21:00:00 | CL | Futures | 156.43 | 156.48 | 156.37 | 156.46 | 271.0 |
| 2014-08-17 22:00:00 | CL | Futures | 156.43 | 156.48 | 156.4 | 156.46 | 126.0 |
| 2014-08-17 23:00:00 | CL | Futures | 156.48 | 156.51 | 156.4 | 156.45 | 148.0 |
| 2014-08-17 18:00:00 | GC | Futures | 1785.4 | 1786.1 | 1782.8 | 1784.6 | 1171.0 |
| 2014-08-17 19:00:00 | GC | Futures | 1784.6 | 1784.8 | 1783.1 | 1783.6 | 424.0 |
| 2014-08-17 20:00:00 | GC | Futures | 1783.5 | 1783.6 | 1778.9 | 1780.2 | 3133.0 |
| 2014-08-17 21:00:00 | GC | Futures | 1780.3 | 1781.0 | 1777.4 | 1780.2 | 3176.0 |
| 2014-08-17 22:00:00 | GC | Futures | 1780.3 | 1781.5 | 1779.6 | 1780.9 | 2226.0 |
| 2014-08-17 23:00:00 | GC | Futures | 1780.7 | 1782.2 | 1780.6 | 1782.2 | 1647.0 |
| 2014-08-17 18:00:00 | ZN | Futures | 119.411053 | 119.440522 | 119.263704 | 119.263704 | 16096.0 |
| 2014-08-17 19:00:00 | ZN | Futures | 119.278439 | 119.307909 | 119.263704 | 119.307909 | 4259.0 |
| 2014-08-17 20:00:00 | ZN | Futures | 119.307909 | 119.322644 | 119.278439 | 119.307909 | 7905.0 |
| 2014-08-17 21:00:00 | ZN | Futures | 119.307909 | 119.337379 | 119.278439 | 119.293174 | 9279.0 |
| 2014-08-17 22:00:00 | ZN | Futures | 119.307909 | 119.366848 | 119.293174 | 119.337379 | 6695.0 |
| 2014-08-17 23:00:00 | ZN | Futures | 119.352113 | 119.366848 | 119.322644 | 119.322644 | 3122.0 |
> showing 36 of 274 rows — these rows as CSV