PREVIEW / futures_1hour / 2014-09-07
file: by_date/futures_1hour/2014/2014-09-07.parquet size: 13 KB rows: 258
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-09-07 18:00:00 | ES | Futures | 2091.69 | 2091.95 | 2089.34 | 2090.38 | 7372.0 |
| 2014-09-07 19:00:00 | ES | Futures | 2090.12 | 2091.43 | 2089.86 | 2091.17 | 2204.0 |
| 2014-09-07 20:00:00 | ES | Futures | 2091.17 | 2091.17 | 2089.6 | 2090.12 | 4143.0 |
| 2014-09-07 21:00:00 | ES | Futures | 2089.86 | 2090.12 | 2089.08 | 2089.6 | 2424.0 |
| 2014-09-07 22:00:00 | ES | Futures | 2089.34 | 2089.86 | 2088.56 | 2088.56 | 3176.0 |
| 2014-09-07 23:00:00 | ES | Futures | 2088.56 | 2089.34 | 2088.56 | 2089.08 | 1707.0 |
| 2014-09-07 18:00:00 | NQ | Futures | 4773.27 | 4774.44 | 4770.06 | 4771.52 | 1028.0 |
| 2014-09-07 19:00:00 | NQ | Futures | 4772.1 | 4774.15 | 4771.23 | 4773.86 | 241.0 |
| 2014-09-07 20:00:00 | NQ | Futures | 4773.56 | 4773.86 | 4769.77 | 4772.1 | 618.0 |
| 2014-09-07 21:00:00 | NQ | Futures | 4772.1 | 4772.1 | 4770.06 | 4771.52 | 282.0 |
| 2014-09-07 22:00:00 | NQ | Futures | 4771.52 | 4772.1 | 4768.89 | 4769.18 | 481.0 |
| 2014-09-07 23:00:00 | NQ | Futures | 4769.18 | 4771.23 | 4769.18 | 4770.35 | 167.0 |
| 2014-09-07 18:00:00 | YM | Futures | 17710.7 | 17713.8 | 17695.2 | 17703.5 | 649.0 |
| 2014-09-07 19:00:00 | YM | Futures | 17704.5 | 17709.7 | 17700.4 | 17709.7 | 361.0 |
| 2014-09-07 20:00:00 | YM | Futures | 17710.7 | 17710.7 | 17696.3 | 17701.4 | 623.0 |
| 2014-09-07 21:00:00 | YM | Futures | 17701.4 | 17701.4 | 17695.2 | 17697.3 | 162.0 |
| 2014-09-07 22:00:00 | YM | Futures | 17697.3 | 17700.4 | 17685.9 | 17689.0 | 939.0 |
| 2014-09-07 23:00:00 | YM | Futures | 17689.0 | 17698.3 | 17689.0 | 17696.3 | 733.0 |
| 2014-09-07 18:00:00 | CL | Futures | 154.2 | 154.42 | 153.99 | 154.17 | 828.0 |
| 2014-09-07 19:00:00 | CL | Futures | 154.17 | 154.2 | 154.16 | 154.17 | 134.0 |
| 2014-09-07 20:00:00 | CL | Futures | 154.17 | 154.17 | 153.76 | 153.78 | 976.0 |
| 2014-09-07 21:00:00 | CL | Futures | 153.78 | 153.84 | 153.59 | 153.61 | 822.0 |
| 2014-09-07 22:00:00 | CL | Futures | 153.63 | 154.04 | 153.63 | 153.81 | 1366.0 |
| 2014-09-07 23:00:00 | CL | Futures | 153.83 | 153.96 | 153.79 | 153.91 | 322.0 |
| 2014-09-07 18:00:00 | GC | Futures | 1737.9 | 1740.2 | 1736.6 | 1737.5 | 854.0 |
| 2014-09-07 19:00:00 | GC | Futures | 1737.5 | 1737.6 | 1735.1 | 1735.1 | 474.0 |
| 2014-09-07 20:00:00 | GC | Futures | 1735.1 | 1736.5 | 1734.0 | 1736.2 | 879.0 |
| 2014-09-07 21:00:00 | GC | Futures | 1736.2 | 1737.1 | 1735.3 | 1735.4 | 682.0 |
| 2014-09-07 22:00:00 | GC | Futures | 1735.4 | 1738.6 | 1734.3 | 1738.3 | 1548.0 |
| 2014-09-07 23:00:00 | GC | Futures | 1738.2 | 1742.1 | 1737.6 | 1740.9 | 2421.0 |
| 2014-09-07 20:00:00 | ZN | Futures | 118.453289 | 118.468024 | 118.438554 | 118.468024 | 197.0 |
| 2014-09-07 21:00:00 | ZN | Futures | 118.482758 | 118.482758 | 118.482758 | 118.482758 | 1.0 |
> showing 32 of 258 rows — these rows as CSV