PREVIEW / futures_1hour / 2015-02-26
file: by_date/futures_1hour/2015/2015-02-26.parquet size: 51 KB rows: 1,538
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-26 00:00:00 | ES | Futures | 2222.58 | 2223.63 | 2222.32 | 2222.58 | 1602.0 |
| 2015-02-26 01:00:00 | ES | Futures | 2222.58 | 2225.74 | 2222.58 | 2224.16 | 2657.0 |
| 2015-02-26 02:00:00 | ES | Futures | 2224.69 | 2224.95 | 2221.79 | 2222.05 | 4781.0 |
| 2015-02-26 03:00:00 | ES | Futures | 2222.05 | 2224.69 | 2221.0 | 2222.05 | 13687.0 |
| 2015-02-26 04:00:00 | ES | Futures | 2221.79 | 2226.0 | 2221.79 | 2225.21 | 11108.0 |
| 2015-02-26 05:00:00 | ES | Futures | 2224.95 | 2225.74 | 2223.63 | 2225.21 | 8970.0 |
| 2015-02-26 06:00:00 | ES | Futures | 2225.21 | 2226.0 | 2224.42 | 2225.48 | 7550.0 |
| 2015-02-26 07:00:00 | ES | Futures | 2225.48 | 2225.48 | 2222.84 | 2223.63 | 12837.0 |
| 2015-02-26 08:00:00 | ES | Futures | 2223.63 | 2224.95 | 2219.16 | 2220.74 | 33307.0 |
| 2015-02-26 09:00:00 | ES | Futures | 2220.48 | 2222.84 | 2214.42 | 2214.95 | 164219.0 |
| 2015-02-26 10:00:00 | ES | Futures | 2215.21 | 2221.0 | 2214.42 | 2220.21 | 154222.0 |
| 2015-02-26 11:00:00 | ES | Futures | 2220.48 | 2223.37 | 2220.21 | 2221.0 | 141878.0 |
| 2015-02-26 12:00:00 | ES | Futures | 2221.26 | 2222.84 | 2217.05 | 2222.05 | 125545.0 |
| 2015-02-26 13:00:00 | ES | Futures | 2222.05 | 2222.32 | 2217.84 | 2219.69 | 65071.0 |
| 2015-02-26 14:00:00 | ES | Futures | 2219.69 | 2221.0 | 2213.9 | 2215.48 | 124056.0 |
| 2015-02-26 15:00:00 | ES | Futures | 2215.74 | 2221.0 | 2212.05 | 2219.95 | 207321.0 |
| 2015-02-26 16:00:00 | ES | Futures | 2219.95 | 2221.79 | 2219.16 | 2221.26 | 62890.0 |
| 2015-02-26 17:00:00 | ES | Futures | 2221.0 | 2221.26 | 2220.21 | 2220.74 | 1772.0 |
| 2015-02-26 18:00:00 | ES | Futures | 2220.48 | 2220.48 | 2218.37 | 2218.63 | 4372.0 |
| 2015-02-26 19:00:00 | ES | Futures | 2218.9 | 2218.9 | 2217.05 | 2217.32 | 6912.0 |
| 2015-02-26 20:00:00 | ES | Futures | 2217.58 | 2217.84 | 2216.53 | 2217.05 | 4700.0 |
| 2015-02-26 21:00:00 | ES | Futures | 2217.05 | 2217.84 | 2216.79 | 2217.58 | 1605.0 |
| 2015-02-26 22:00:00 | ES | Futures | 2217.58 | 2218.63 | 2217.32 | 2218.37 | 1822.0 |
| 2015-02-26 23:00:00 | ES | Futures | 2218.37 | 2218.63 | 2217.84 | 2218.11 | 1494.0 |
| 2015-02-26 00:00:00 | NQ | Futures | 5215.02 | 5216.79 | 5214.44 | 5215.32 | 213.0 |
| 2015-02-26 01:00:00 | NQ | Futures | 5215.02 | 5222.66 | 5215.02 | 5218.84 | 604.0 |
| 2015-02-26 02:00:00 | NQ | Futures | 5218.84 | 5220.31 | 5213.26 | 5213.85 | 1017.0 |
| 2015-02-26 03:00:00 | NQ | Futures | 5214.14 | 5221.78 | 5212.68 | 5216.49 | 2427.0 |
| 2015-02-26 04:00:00 | NQ | Futures | 5216.49 | 5224.13 | 5216.2 | 5221.49 | 1973.0 |
| 2015-02-26 05:00:00 | NQ | Futures | 5221.78 | 5223.25 | 5218.55 | 5222.95 | 1297.0 |
| 2015-02-26 06:00:00 | NQ | Futures | 5222.37 | 5226.19 | 5221.19 | 5223.84 | 2431.0 |
| 2015-02-26 07:00:00 | NQ | Futures | 5223.84 | 5223.84 | 5217.37 | 5219.43 | 3355.0 |
| 2015-02-26 08:00:00 | NQ | Futures | 5219.43 | 5221.49 | 5213.56 | 5218.26 | 5138.0 |
| 2015-02-26 09:00:00 | NQ | Futures | 5217.96 | 5227.36 | 5205.33 | 5207.98 | 34080.0 |
| 2015-02-26 10:00:00 | NQ | Futures | 5207.68 | 5231.18 | 5206.8 | 5227.95 | 29081.0 |
| 2015-02-26 11:00:00 | NQ | Futures | 5227.95 | 5238.23 | 5227.95 | 5235.29 | 21648.0 |
| 2015-02-26 12:00:00 | NQ | Futures | 5235.29 | 5241.16 | 5221.19 | 5237.93 | 18066.0 |
| 2015-02-26 13:00:00 | NQ | Futures | 5237.93 | 5239.99 | 5230.3 | 5234.7 | 11061.0 |
| 2015-02-26 14:00:00 | NQ | Futures | 5235.0 | 5237.64 | 5216.2 | 5227.07 | 21653.0 |
| 2015-02-26 15:00:00 | NQ | Futures | 5227.07 | 5244.1 | 5217.37 | 5240.87 | 31472.0 |
| 2015-02-26 16:00:00 | NQ | Futures | 5241.16 | 5244.98 | 5239.4 | 5242.34 | 5639.0 |
| 2015-02-26 17:00:00 | NQ | Futures | 5242.63 | 5242.63 | 5240.58 | 5241.75 | 133.0 |
| 2015-02-26 18:00:00 | NQ | Futures | 5239.99 | 5241.16 | 5237.64 | 5237.64 | 661.0 |
| 2015-02-26 19:00:00 | NQ | Futures | 5237.35 | 5237.35 | 5234.7 | 5234.7 | 734.0 |
| 2015-02-26 20:00:00 | NQ | Futures | 5234.7 | 5235.58 | 5233.82 | 5234.7 | 588.0 |
| 2015-02-26 21:00:00 | NQ | Futures | 5234.7 | 5236.76 | 5234.41 | 5236.17 | 191.0 |
| 2015-02-26 22:00:00 | NQ | Futures | 5236.17 | 5237.93 | 5235.88 | 5237.93 | 212.0 |
| 2015-02-26 23:00:00 | NQ | Futures | 5237.64 | 5238.23 | 5235.88 | 5236.76 | 253.0 |
| 2015-02-26 00:00:00 | YM | Futures | 19000.7 | 19006.9 | 18996.5 | 19000.7 | 254.0 |
| 2015-02-26 01:00:00 | YM | Futures | 18999.6 | 19022.6 | 18998.6 | 19013.2 | 662.0 |
> showing 50 of 1,538 rows — these rows as CSV