PREVIEW / futures_1hour / 2015-02-01
file: by_date/futures_1hour/2015/2015-02-01.parquet size: 14 KB rows: 275
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 |
|---|---|---|---|---|---|---|---|
| 2015-02-01 18:00:00 | ES | Futures | 2095.22 | 2098.37 | 2088.37 | 2091.79 | 28367.0 |
| 2015-02-01 19:00:00 | ES | Futures | 2091.79 | 2096.27 | 2091.79 | 2096.27 | 6543.0 |
| 2015-02-01 20:00:00 | ES | Futures | 2096.0 | 2098.37 | 2094.69 | 2098.11 | 5125.0 |
| 2015-02-01 21:00:00 | ES | Futures | 2098.11 | 2099.95 | 2095.22 | 2096.53 | 4045.0 |
| 2015-02-01 22:00:00 | ES | Futures | 2096.53 | 2099.43 | 2096.27 | 2098.37 | 2833.0 |
| 2015-02-01 23:00:00 | ES | Futures | 2098.37 | 2098.37 | 2095.22 | 2096.0 | 2843.0 |
| 2015-02-01 18:00:00 | NQ | Futures | 4867.59 | 4874.93 | 4850.85 | 4858.49 | 1577.0 |
| 2015-02-01 19:00:00 | NQ | Futures | 4859.07 | 4869.65 | 4858.19 | 4869.06 | 1035.0 |
| 2015-02-01 20:00:00 | NQ | Futures | 4869.35 | 4874.93 | 4866.71 | 4874.93 | 725.0 |
| 2015-02-01 21:00:00 | NQ | Futures | 4874.64 | 4878.46 | 4867.59 | 4869.94 | 529.0 |
| 2015-02-01 22:00:00 | NQ | Futures | 4871.12 | 4878.16 | 4869.94 | 4875.23 | 787.0 |
| 2015-02-01 23:00:00 | NQ | Futures | 4875.23 | 4875.52 | 4867.59 | 4868.18 | 761.0 |
| 2015-02-01 18:00:00 | YM | Futures | 17858.7 | 17892.1 | 17813.8 | 17837.8 | 2169.0 |
| 2015-02-01 19:00:00 | YM | Futures | 17839.9 | 17875.4 | 17839.9 | 17872.2 | 1169.0 |
| 2015-02-01 20:00:00 | YM | Futures | 17872.2 | 17894.1 | 17859.7 | 17892.1 | 773.0 |
| 2015-02-01 21:00:00 | YM | Futures | 17892.1 | 17904.6 | 17866.0 | 17875.4 | 646.0 |
| 2015-02-01 22:00:00 | YM | Futures | 17875.4 | 17899.4 | 17875.4 | 17893.1 | 405.0 |
| 2015-02-01 23:00:00 | YM | Futures | 17890.0 | 17891.0 | 17866.0 | 17871.2 | 400.0 |
| 2015-02-01 18:00:00 | CL | Futures | 79.9 | 80.32 | 78.96 | 79.47 | 5005.0 |
| 2015-02-01 19:00:00 | CL | Futures | 79.45 | 79.52 | 79.1 | 79.2 | 1506.0 |
| 2015-02-01 20:00:00 | CL | Futures | 79.2 | 79.28 | 78.36 | 78.71 | 5594.0 |
| 2015-02-01 21:00:00 | CL | Futures | 78.73 | 78.76 | 78.44 | 78.66 | 1949.0 |
| 2015-02-01 22:00:00 | CL | Futures | 78.65 | 79.13 | 78.63 | 79.03 | 2837.0 |
| 2015-02-01 23:00:00 | CL | Futures | 79.03 | 79.05 | 78.49 | 78.76 | 1669.0 |
| 2015-02-01 18:00:00 | GC | Futures | 1753.4 | 1753.7 | 1749.5 | 1751.1 | 2474.0 |
| 2015-02-01 19:00:00 | GC | Futures | 1751.1 | 1752.9 | 1750.1 | 1751.0 | 1463.0 |
| 2015-02-01 20:00:00 | GC | Futures | 1751.0 | 1754.7 | 1749.5 | 1749.7 | 3427.0 |
| 2015-02-01 21:00:00 | GC | Futures | 1749.7 | 1751.4 | 1748.1 | 1748.6 | 2781.0 |
| 2015-02-01 22:00:00 | GC | Futures | 1748.6 | 1751.1 | 1748.1 | 1749.6 | 1556.0 |
| 2015-02-01 23:00:00 | GC | Futures | 1749.7 | 1751.1 | 1749.6 | 1750.8 | 1102.0 |
| 2015-02-01 18:00:00 | ZN | Futures | 124.613809 | 124.673241 | 124.569235 | 124.584093 | 8914.0 |
| 2015-02-01 19:00:00 | ZN | Futures | 124.584093 | 124.643525 | 124.554377 | 124.554377 | 8825.0 |
| 2015-02-01 20:00:00 | ZN | Futures | 124.554377 | 124.569235 | 124.509804 | 124.524661 | 5134.0 |
| 2015-02-01 21:00:00 | ZN | Futures | 124.524661 | 124.554377 | 124.509804 | 124.539519 | 5352.0 |
| 2015-02-01 22:00:00 | ZN | Futures | 124.539519 | 124.554377 | 124.509804 | 124.524661 | 6191.0 |
| 2015-02-01 23:00:00 | ZN | Futures | 124.524661 | 124.524661 | 124.46523 | 124.480088 | 7408.0 |
> showing 36 of 275 rows — these rows as CSV