PREVIEW / futures_1hour / 2015-03-01
file: by_date/futures_1hour/2015/2015-03-01.parquet size: 14 KB rows: 272
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-03-01 18:00:00 | ES | Futures | 2214.69 | 2218.63 | 2214.42 | 2217.84 | 9075.0 |
| 2015-03-01 19:00:00 | ES | Futures | 2217.84 | 2218.37 | 2216.79 | 2216.79 | 3143.0 |
| 2015-03-01 20:00:00 | ES | Futures | 2217.05 | 2217.05 | 2214.95 | 2215.48 | 4231.0 |
| 2015-03-01 21:00:00 | ES | Futures | 2215.21 | 2216.79 | 2215.21 | 2215.48 | 1823.0 |
| 2015-03-01 22:00:00 | ES | Futures | 2215.48 | 2216.53 | 2215.21 | 2216.26 | 1087.0 |
| 2015-03-01 23:00:00 | ES | Futures | 2216.26 | 2216.53 | 2216.0 | 2216.26 | 662.0 |
| 2015-03-01 18:00:00 | NQ | Futures | 5224.13 | 5232.94 | 5223.25 | 5230.0 | 1676.0 |
| 2015-03-01 19:00:00 | NQ | Futures | 5230.3 | 5231.18 | 5228.53 | 5229.12 | 369.0 |
| 2015-03-01 20:00:00 | NQ | Futures | 5228.53 | 5229.12 | 5225.3 | 5225.89 | 568.0 |
| 2015-03-01 21:00:00 | NQ | Futures | 5226.19 | 5228.83 | 5225.6 | 5225.6 | 355.0 |
| 2015-03-01 22:00:00 | NQ | Futures | 5225.6 | 5227.65 | 5225.3 | 5227.07 | 217.0 |
| 2015-03-01 23:00:00 | NQ | Futures | 5227.07 | 5228.53 | 5226.77 | 5227.95 | 127.0 |
| 2015-03-01 18:00:00 | YM | Futures | 18940.1 | 18969.3 | 18930.7 | 18961.0 | 1053.0 |
| 2015-03-01 19:00:00 | YM | Futures | 18961.0 | 18965.2 | 18952.6 | 18954.7 | 364.0 |
| 2015-03-01 20:00:00 | YM | Futures | 18954.7 | 18955.8 | 18942.2 | 18943.2 | 554.0 |
| 2015-03-01 21:00:00 | YM | Futures | 18944.3 | 18953.7 | 18943.2 | 18943.2 | 417.0 |
| 2015-03-01 22:00:00 | YM | Futures | 18943.2 | 18950.5 | 18942.2 | 18947.4 | 136.0 |
| 2015-03-01 23:00:00 | YM | Futures | 18948.5 | 18950.5 | 18945.3 | 18948.5 | 67.0 |
| 2015-03-01 18:00:00 | CL | Futures | 81.68 | 81.97 | 81.3 | 81.59 | 2544.0 |
| 2015-03-01 19:00:00 | CL | Futures | 81.57 | 81.59 | 81.32 | 81.35 | 1288.0 |
| 2015-03-01 20:00:00 | CL | Futures | 81.34 | 81.68 | 81.32 | 81.57 | 2020.0 |
| 2015-03-01 21:00:00 | CL | Futures | 81.57 | 81.7 | 81.47 | 81.63 | 2108.0 |
| 2015-03-01 22:00:00 | CL | Futures | 81.63 | 81.68 | 81.54 | 81.54 | 818.0 |
| 2015-03-01 23:00:00 | CL | Futures | 81.55 | 81.63 | 81.49 | 81.62 | 717.0 |
| 2015-03-01 18:00:00 | GC | Futures | 1658.9 | 1660.9 | 1656.8 | 1659.0 | 1550.0 |
| 2015-03-01 19:00:00 | GC | Futures | 1658.9 | 1661.9 | 1658.6 | 1660.6 | 1337.0 |
| 2015-03-01 20:00:00 | GC | Futures | 1660.8 | 1668.6 | 1660.1 | 1667.5 | 7441.0 |
| 2015-03-01 21:00:00 | GC | Futures | 1667.5 | 1671.4 | 1667.2 | 1669.6 | 5280.0 |
| 2015-03-01 22:00:00 | GC | Futures | 1669.8 | 1670.9 | 1668.6 | 1668.8 | 2044.0 |
| 2015-03-01 23:00:00 | GC | Futures | 1668.7 | 1669.4 | 1667.3 | 1667.6 | 1626.0 |
| 2015-03-01 18:00:00 | ZN | Futures | 122.102812 | 122.102812 | 122.028522 | 122.04338 | 202.0 |
| 2015-03-01 19:00:00 | ZN | Futures | 122.073096 | 122.073096 | 121.998806 | 122.028522 | 124.0 |
| 2015-03-01 20:00:00 | ZN | Futures | 122.04338 | 122.073096 | 121.998806 | 122.013664 | 206.0 |
| 2015-03-01 21:00:00 | ZN | Futures | 121.998806 | 121.998806 | 121.924516 | 121.96909 | 111.0 |
| 2015-03-01 22:00:00 | ZN | Futures | 121.96909 | 122.013664 | 121.96909 | 122.013664 | 104.0 |
| 2015-03-01 23:00:00 | ZN | Futures | 122.013664 | 122.013664 | 121.983948 | 121.983948 | 180.0 |
> showing 36 of 272 rows — these rows as CSV