PREVIEW / futures_1hour / 2014-07-20
file: by_date/futures_1hour/2014/2014-07-20.parquet size: 13 KB rows: 268
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-07-20 18:00:00 | ES | Futures | 2053.9 | 2054.94 | 2053.64 | 2054.42 | 4519.0 |
| 2014-07-20 19:00:00 | ES | Futures | 2054.42 | 2055.2 | 2053.9 | 2055.2 | 1971.0 |
| 2014-07-20 20:00:00 | ES | Futures | 2054.94 | 2055.2 | 2054.42 | 2055.2 | 2086.0 |
| 2014-07-20 21:00:00 | ES | Futures | 2055.2 | 2055.2 | 2054.16 | 2054.42 | 2447.0 |
| 2014-07-20 22:00:00 | ES | Futures | 2054.42 | 2054.68 | 2054.16 | 2054.42 | 1327.0 |
| 2014-07-20 23:00:00 | ES | Futures | 2054.42 | 2054.94 | 2053.9 | 2054.16 | 996.0 |
| 2014-07-20 18:00:00 | NQ | Futures | 4589.89 | 4590.47 | 4586.38 | 4590.47 | 1014.0 |
| 2014-07-20 19:00:00 | NQ | Futures | 4590.47 | 4591.05 | 4588.43 | 4591.05 | 215.0 |
| 2014-07-20 20:00:00 | NQ | Futures | 4591.05 | 4591.93 | 4589.59 | 4590.47 | 188.0 |
| 2014-07-20 21:00:00 | NQ | Futures | 4590.76 | 4590.76 | 4587.84 | 4588.13 | 344.0 |
| 2014-07-20 22:00:00 | NQ | Futures | 4588.43 | 4589.3 | 4588.13 | 4588.72 | 162.0 |
| 2014-07-20 23:00:00 | NQ | Futures | 4588.43 | 4589.89 | 4587.84 | 4588.13 | 187.0 |
| 2014-07-20 18:00:00 | YM | Futures | 17608.3 | 17615.6 | 17606.3 | 17611.4 | 489.0 |
| 2014-07-20 19:00:00 | YM | Futures | 17611.4 | 17616.6 | 17606.3 | 17615.6 | 238.0 |
| 2014-07-20 20:00:00 | YM | Futures | 17615.6 | 17615.6 | 17610.4 | 17612.5 | 265.0 |
| 2014-07-20 21:00:00 | YM | Futures | 17612.5 | 17613.5 | 17607.3 | 17608.3 | 445.0 |
| 2014-07-20 22:00:00 | YM | Futures | 17608.3 | 17610.4 | 17607.3 | 17608.3 | 246.0 |
| 2014-07-20 23:00:00 | YM | Futures | 17609.4 | 17612.5 | 17605.2 | 17606.3 | 140.0 |
| 2014-07-20 18:00:00 | CL | Futures | 166.47 | 166.54 | 166.02 | 166.07 | 710.0 |
| 2014-07-20 19:00:00 | CL | Futures | 166.07 | 166.26 | 166.05 | 166.23 | 380.0 |
| 2014-07-20 20:00:00 | CL | Futures | 166.23 | 166.47 | 166.23 | 166.36 | 729.0 |
| 2014-07-20 21:00:00 | CL | Futures | 166.38 | 166.49 | 166.23 | 166.36 | 716.0 |
| 2014-07-20 22:00:00 | CL | Futures | 166.34 | 166.44 | 166.31 | 166.36 | 235.0 |
| 2014-07-20 23:00:00 | CL | Futures | 166.34 | 166.64 | 166.34 | 166.56 | 870.0 |
| 2014-07-20 18:00:00 | GC | Futures | 1796.1 | 1796.2 | 1794.6 | 1795.4 | 554.0 |
| 2014-07-20 19:00:00 | GC | Futures | 1795.4 | 1798.1 | 1795.2 | 1796.1 | 484.0 |
| 2014-07-20 20:00:00 | GC | Futures | 1795.9 | 1796.5 | 1793.3 | 1794.1 | 646.0 |
| 2014-07-20 21:00:00 | GC | Futures | 1794.0 | 1795.1 | 1791.4 | 1794.6 | 1807.0 |
| 2014-07-20 22:00:00 | GC | Futures | 1794.4 | 1797.4 | 1794.4 | 1797.4 | 1361.0 |
| 2014-07-20 23:00:00 | GC | Futures | 1797.4 | 1798.1 | 1795.9 | 1796.5 | 1015.0 |
| 2014-07-20 18:00:00 | ZN | Futures | 118.099653 | 118.129123 | 118.084918 | 118.129123 | 3323.0 |
| 2014-07-20 19:00:00 | ZN | Futures | 118.129123 | 118.129123 | 118.099653 | 118.114388 | 722.0 |
| 2014-07-20 20:00:00 | ZN | Futures | 118.114388 | 118.143857 | 118.099653 | 118.129123 | 2808.0 |
| 2014-07-20 21:00:00 | ZN | Futures | 118.129123 | 118.158592 | 118.129123 | 118.143857 | 3062.0 |
| 2014-07-20 22:00:00 | ZN | Futures | 118.129123 | 118.143857 | 118.099653 | 118.099653 | 2185.0 |
| 2014-07-20 23:00:00 | ZN | Futures | 118.114388 | 118.129123 | 118.099653 | 118.129123 | 676.0 |
> showing 36 of 268 rows — these rows as CSV