PREVIEW / futures_1hour / 2015-03-22
file: by_date/futures_1hour/2015/2015-03-22.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-22 18:00:00 | ES | Futures | 2216.21 | 2224.93 | 2215.95 | 2221.76 | 9881.0 |
| 2015-03-22 19:00:00 | ES | Futures | 2222.02 | 2222.29 | 2220.97 | 2221.23 | 2008.0 |
| 2015-03-22 20:00:00 | ES | Futures | 2221.23 | 2221.23 | 2219.91 | 2220.44 | 3625.0 |
| 2015-03-22 21:00:00 | ES | Futures | 2220.7 | 2220.7 | 2219.38 | 2220.44 | 2229.0 |
| 2015-03-22 22:00:00 | ES | Futures | 2220.7 | 2222.02 | 2220.17 | 2221.76 | 2330.0 |
| 2015-03-22 23:00:00 | ES | Futures | 2221.76 | 2222.02 | 2221.23 | 2221.49 | 1176.0 |
| 2015-03-22 18:00:00 | NQ | Futures | 5232.57 | 5247.56 | 5227.86 | 5240.21 | 1440.0 |
| 2015-03-22 19:00:00 | NQ | Futures | 5240.21 | 5240.51 | 5239.33 | 5239.62 | 217.0 |
| 2015-03-22 20:00:00 | NQ | Futures | 5239.33 | 5239.62 | 5236.98 | 5238.45 | 644.0 |
| 2015-03-22 21:00:00 | NQ | Futures | 5238.45 | 5239.33 | 5234.62 | 5238.74 | 516.0 |
| 2015-03-22 22:00:00 | NQ | Futures | 5238.45 | 5241.39 | 5237.27 | 5240.21 | 761.0 |
| 2015-03-22 23:00:00 | NQ | Futures | 5240.21 | 5241.98 | 5239.33 | 5240.51 | 264.0 |
| 2015-03-22 18:00:00 | YM | Futures | 18909.6 | 18984.0 | 18904.3 | 18952.6 | 1371.0 |
| 2015-03-22 19:00:00 | YM | Futures | 18952.6 | 18956.7 | 18946.3 | 18949.4 | 213.0 |
| 2015-03-22 20:00:00 | YM | Futures | 18949.4 | 18949.4 | 18940.0 | 18945.2 | 471.0 |
| 2015-03-22 21:00:00 | YM | Futures | 18944.2 | 18947.3 | 18932.6 | 18945.2 | 297.0 |
| 2015-03-22 22:00:00 | YM | Futures | 18946.3 | 18956.7 | 18941.0 | 18954.6 | 409.0 |
| 2015-03-22 23:00:00 | YM | Futures | 18954.6 | 18955.7 | 18949.4 | 18952.6 | 182.0 |
| 2015-03-22 18:00:00 | CL | Futures | 73.23 | 73.28 | 72.68 | 72.76 | 1896.0 |
| 2015-03-22 19:00:00 | CL | Futures | 72.76 | 72.88 | 72.42 | 72.63 | 1510.0 |
| 2015-03-22 20:00:00 | CL | Futures | 72.61 | 72.71 | 72.46 | 72.71 | 1716.0 |
| 2015-03-22 21:00:00 | CL | Futures | 72.71 | 72.77 | 72.38 | 72.38 | 2408.0 |
| 2015-03-22 22:00:00 | CL | Futures | 72.38 | 72.55 | 72.38 | 72.55 | 1126.0 |
| 2015-03-22 23:00:00 | CL | Futures | 72.55 | 72.66 | 72.52 | 72.63 | 1007.0 |
| 2015-03-22 18:00:00 | GC | Futures | 1617.0 | 1621.4 | 1616.5 | 1620.2 | 2118.0 |
| 2015-03-22 19:00:00 | GC | Futures | 1620.0 | 1621.7 | 1619.5 | 1620.7 | 1004.0 |
| 2015-03-22 20:00:00 | GC | Futures | 1620.9 | 1621.3 | 1619.5 | 1619.9 | 1594.0 |
| 2015-03-22 21:00:00 | GC | Futures | 1619.9 | 1620.9 | 1615.1 | 1615.9 | 4338.0 |
| 2015-03-22 22:00:00 | GC | Futures | 1615.9 | 1616.1 | 1613.8 | 1614.7 | 2513.0 |
| 2015-03-22 23:00:00 | GC | Futures | 1614.6 | 1615.7 | 1613.2 | 1614.6 | 2368.0 |
| 2015-03-22 18:00:00 | ZN | Futures | 122.992042 | 123.066709 | 122.992042 | 123.021909 | 2538.0 |
| 2015-03-22 19:00:00 | ZN | Futures | 123.006975 | 123.051776 | 123.006975 | 123.051776 | 3128.0 |
| 2015-03-22 20:00:00 | ZN | Futures | 123.051776 | 123.066709 | 123.006975 | 123.036842 | 4422.0 |
| 2015-03-22 21:00:00 | ZN | Futures | 123.021909 | 123.051776 | 122.977108 | 123.006975 | 3330.0 |
| 2015-03-22 22:00:00 | ZN | Futures | 123.006975 | 123.021909 | 122.992042 | 122.992042 | 1545.0 |
| 2015-03-22 23:00:00 | ZN | Futures | 122.992042 | 123.021909 | 122.992042 | 123.006975 | 1488.0 |
> showing 36 of 272 rows — these rows as CSV