PREVIEW / futures_1hour / 2015-05-11
file: by_date/futures_1hour/2015/2015-05-11.parquet size: 51 KB rows: 1,561
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-05-11 00:00:00 | ES | Futures | 2226.51 | 2226.78 | 2226.25 | 2226.78 | 1030.0 |
| 2015-05-11 01:00:00 | ES | Futures | 2226.78 | 2228.63 | 2226.78 | 2227.57 | 2637.0 |
| 2015-05-11 02:00:00 | ES | Futures | 2227.57 | 2228.36 | 2226.25 | 2227.31 | 7336.0 |
| 2015-05-11 03:00:00 | ES | Futures | 2227.57 | 2227.83 | 2225.46 | 2225.72 | 15811.0 |
| 2015-05-11 04:00:00 | ES | Futures | 2225.72 | 2227.57 | 2224.14 | 2225.19 | 14229.0 |
| 2015-05-11 05:00:00 | ES | Futures | 2225.19 | 2226.51 | 2224.4 | 2224.66 | 11572.0 |
| 2015-05-11 06:00:00 | ES | Futures | 2224.66 | 2227.04 | 2224.4 | 2226.51 | 7020.0 |
| 2015-05-11 07:00:00 | ES | Futures | 2226.78 | 2229.42 | 2225.46 | 2228.89 | 15449.0 |
| 2015-05-11 08:00:00 | ES | Futures | 2228.63 | 2229.15 | 2227.04 | 2228.36 | 14350.0 |
| 2015-05-11 09:00:00 | ES | Futures | 2228.36 | 2232.59 | 2226.25 | 2230.47 | 216943.0 |
| 2015-05-11 10:00:00 | ES | Futures | 2230.47 | 2232.85 | 2224.4 | 2228.89 | 202686.0 |
| 2015-05-11 11:00:00 | ES | Futures | 2228.89 | 2230.47 | 2225.98 | 2228.89 | 115657.0 |
| 2015-05-11 12:00:00 | ES | Futures | 2229.15 | 2229.42 | 2223.61 | 2225.19 | 87922.0 |
| 2015-05-11 13:00:00 | ES | Futures | 2225.19 | 2227.83 | 2224.66 | 2224.66 | 49133.0 |
| 2015-05-11 14:00:00 | ES | Futures | 2224.66 | 2225.98 | 2219.65 | 2220.44 | 90300.0 |
| 2015-05-11 15:00:00 | ES | Futures | 2220.17 | 2224.14 | 2218.06 | 2218.85 | 187251.0 |
| 2015-05-11 16:00:00 | ES | Futures | 2218.85 | 2220.17 | 2214.1 | 2215.16 | 82142.0 |
| 2015-05-11 17:00:00 | ES | Futures | 2215.16 | 2215.68 | 2215.16 | 2215.16 | 1249.0 |
| 2015-05-11 18:00:00 | ES | Futures | 2216.21 | 2217.27 | 2215.42 | 2216.48 | 5214.0 |
| 2015-05-11 19:00:00 | ES | Futures | 2216.21 | 2216.74 | 2215.16 | 2215.16 | 3426.0 |
| 2015-05-11 20:00:00 | ES | Futures | 2215.16 | 2217.27 | 2214.89 | 2216.74 | 4689.0 |
| 2015-05-11 21:00:00 | ES | Futures | 2216.74 | 2217.53 | 2215.42 | 2216.21 | 3357.0 |
| 2015-05-11 22:00:00 | ES | Futures | 2216.21 | 2216.21 | 2214.63 | 2215.16 | 3334.0 |
| 2015-05-11 23:00:00 | ES | Futures | 2215.16 | 2215.42 | 2214.63 | 2215.16 | 1566.0 |
| 2015-05-11 00:00:00 | NQ | Futures | 5232.86 | 5233.45 | 5232.27 | 5233.15 | 151.0 |
| 2015-05-11 01:00:00 | NQ | Futures | 5233.45 | 5236.98 | 5233.45 | 5235.51 | 224.0 |
| 2015-05-11 02:00:00 | NQ | Futures | 5235.21 | 5235.8 | 5231.1 | 5233.45 | 616.0 |
| 2015-05-11 03:00:00 | NQ | Futures | 5234.04 | 5234.62 | 5228.74 | 5230.21 | 1825.0 |
| 2015-05-11 04:00:00 | NQ | Futures | 5230.21 | 5233.74 | 5226.1 | 5229.33 | 1751.0 |
| 2015-05-11 05:00:00 | NQ | Futures | 5229.33 | 5233.45 | 5226.98 | 5227.57 | 1332.0 |
| 2015-05-11 06:00:00 | NQ | Futures | 5227.27 | 5234.04 | 5226.98 | 5233.45 | 1115.0 |
| 2015-05-11 07:00:00 | NQ | Futures | 5233.15 | 5239.04 | 5230.51 | 5238.15 | 1721.0 |
| 2015-05-11 08:00:00 | NQ | Futures | 5237.86 | 5239.04 | 5234.62 | 5238.15 | 2725.0 |
| 2015-05-11 09:00:00 | NQ | Futures | 5238.45 | 5251.39 | 5228.16 | 5240.8 | 39062.0 |
| 2015-05-11 10:00:00 | NQ | Futures | 5241.09 | 5247.86 | 5220.8 | 5231.1 | 26719.0 |
| 2015-05-11 11:00:00 | NQ | Futures | 5231.39 | 5238.74 | 5222.86 | 5238.45 | 18650.0 |
| 2015-05-11 12:00:00 | NQ | Futures | 5238.15 | 5240.21 | 5225.21 | 5229.33 | 14004.0 |
| 2015-05-11 13:00:00 | NQ | Futures | 5229.04 | 5238.74 | 5228.16 | 5230.21 | 8664.0 |
| 2015-05-11 14:00:00 | NQ | Futures | 5230.51 | 5234.33 | 5222.27 | 5222.57 | 15991.0 |
| 2015-05-11 15:00:00 | NQ | Futures | 5222.57 | 5227.27 | 5213.45 | 5216.1 | 25860.0 |
| 2015-05-11 16:00:00 | NQ | Futures | 5216.1 | 5220.22 | 5206.98 | 5210.22 | 6961.0 |
| 2015-05-11 17:00:00 | NQ | Futures | 5210.22 | 5211.1 | 5209.63 | 5210.22 | 91.0 |
| 2015-05-11 18:00:00 | NQ | Futures | 5212.57 | 5213.75 | 5210.22 | 5212.86 | 656.0 |
| 2015-05-11 19:00:00 | NQ | Futures | 5213.16 | 5213.16 | 5209.34 | 5209.92 | 396.0 |
| 2015-05-11 20:00:00 | NQ | Futures | 5209.34 | 5214.04 | 5209.04 | 5212.57 | 740.0 |
| 2015-05-11 21:00:00 | NQ | Futures | 5212.28 | 5213.75 | 5209.34 | 5209.92 | 522.0 |
| 2015-05-11 22:00:00 | NQ | Futures | 5210.22 | 5210.22 | 5206.1 | 5208.16 | 597.0 |
| 2015-05-11 23:00:00 | NQ | Futures | 5208.16 | 5208.16 | 5206.69 | 5208.16 | 273.0 |
| 2015-05-11 00:00:00 | YM | Futures | 18996.6 | 18998.7 | 18993.4 | 18996.6 | 137.0 |
| 2015-05-11 01:00:00 | YM | Futures | 18998.7 | 19010.2 | 18996.6 | 19002.9 | 371.0 |
> showing 50 of 1,561 rows — these rows as CSV