PREVIEW / futures_1hour / 2015-05-26
file: by_date/futures_1hour/2015/2015-05-26.parquet size: 51 KB rows: 1,547
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-26 00:00:00 | ES | Futures | 2241.04 | 2241.04 | 2239.19 | 2239.45 | 2315.0 |
| 2015-05-26 01:00:00 | ES | Futures | 2239.45 | 2240.78 | 2239.19 | 2240.78 | 1070.0 |
| 2015-05-26 02:00:00 | ES | Futures | 2240.51 | 2243.68 | 2240.25 | 2241.83 | 11131.0 |
| 2015-05-26 03:00:00 | ES | Futures | 2242.1 | 2244.47 | 2234.96 | 2235.49 | 35541.0 |
| 2015-05-26 04:00:00 | ES | Futures | 2235.23 | 2236.81 | 2234.7 | 2236.55 | 15958.0 |
| 2015-05-26 05:00:00 | ES | Futures | 2236.81 | 2237.34 | 2234.96 | 2236.29 | 9169.0 |
| 2015-05-26 06:00:00 | ES | Futures | 2236.02 | 2241.3 | 2236.02 | 2239.98 | 16563.0 |
| 2015-05-26 07:00:00 | ES | Futures | 2239.72 | 2242.36 | 2239.45 | 2240.78 | 15984.0 |
| 2015-05-26 08:00:00 | ES | Futures | 2241.04 | 2241.57 | 2236.55 | 2237.87 | 36057.0 |
| 2015-05-26 09:00:00 | ES | Futures | 2237.87 | 2238.93 | 2227.83 | 2228.89 | 226267.0 |
| 2015-05-26 10:00:00 | ES | Futures | 2229.15 | 2230.21 | 2221.23 | 2222.02 | 255058.0 |
| 2015-05-26 11:00:00 | ES | Futures | 2222.02 | 2225.72 | 2218.85 | 2221.76 | 183979.0 |
| 2015-05-26 12:00:00 | ES | Futures | 2222.02 | 2224.14 | 2219.38 | 2219.65 | 80731.0 |
| 2015-05-26 13:00:00 | ES | Futures | 2219.65 | 2221.76 | 2214.89 | 2215.95 | 160403.0 |
| 2015-05-26 14:00:00 | ES | Futures | 2215.95 | 2218.85 | 2214.36 | 2214.63 | 132505.0 |
| 2015-05-26 15:00:00 | ES | Futures | 2214.63 | 2222.02 | 2214.36 | 2220.17 | 258163.0 |
| 2015-05-26 16:00:00 | ES | Futures | 2219.91 | 2224.93 | 2219.65 | 2224.4 | 89262.0 |
| 2015-05-26 17:00:00 | ES | Futures | 2224.4 | 2225.19 | 2224.14 | 2224.93 | 2376.0 |
| 2015-05-26 18:00:00 | ES | Futures | 2224.66 | 2224.93 | 2222.82 | 2223.34 | 4305.0 |
| 2015-05-26 19:00:00 | ES | Futures | 2223.61 | 2224.14 | 2221.76 | 2222.55 | 2946.0 |
| 2015-05-26 20:00:00 | ES | Futures | 2222.55 | 2223.87 | 2221.76 | 2223.61 | 5352.0 |
| 2015-05-26 21:00:00 | ES | Futures | 2223.61 | 2224.14 | 2222.02 | 2222.29 | 3130.0 |
| 2015-05-26 22:00:00 | ES | Futures | 2222.02 | 2222.82 | 2220.97 | 2221.49 | 3456.0 |
| 2015-05-26 23:00:00 | ES | Futures | 2221.49 | 2222.55 | 2221.49 | 2222.02 | 2677.0 |
| 2015-05-26 00:00:00 | NQ | Futures | 5319.9 | 5319.9 | 5315.2 | 5316.37 | 374.0 |
| 2015-05-26 01:00:00 | NQ | Futures | 5316.67 | 5318.73 | 5316.08 | 5318.14 | 153.0 |
| 2015-05-26 02:00:00 | NQ | Futures | 5318.73 | 5324.02 | 5317.84 | 5319.9 | 1293.0 |
| 2015-05-26 03:00:00 | NQ | Futures | 5320.49 | 5326.37 | 5299.02 | 5300.2 | 5582.0 |
| 2015-05-26 04:00:00 | NQ | Futures | 5299.91 | 5302.26 | 5296.97 | 5301.08 | 3005.0 |
| 2015-05-26 05:00:00 | NQ | Futures | 5301.38 | 5302.55 | 5296.97 | 5299.61 | 1506.0 |
| 2015-05-26 06:00:00 | NQ | Futures | 5299.32 | 5318.14 | 5299.32 | 5316.08 | 3110.0 |
| 2015-05-26 07:00:00 | NQ | Futures | 5315.79 | 5322.55 | 5315.79 | 5319.9 | 2386.0 |
| 2015-05-26 08:00:00 | NQ | Futures | 5320.2 | 5322.26 | 5306.96 | 5309.02 | 5631.0 |
| 2015-05-26 09:00:00 | NQ | Futures | 5309.32 | 5318.73 | 5277.56 | 5278.73 | 39037.0 |
| 2015-05-26 10:00:00 | NQ | Futures | 5278.44 | 5283.15 | 5258.74 | 5261.38 | 41360.0 |
| 2015-05-26 11:00:00 | NQ | Futures | 5261.38 | 5266.97 | 5250.8 | 5261.97 | 28085.0 |
| 2015-05-26 12:00:00 | NQ | Futures | 5261.97 | 5267.85 | 5254.92 | 5256.68 | 12574.0 |
| 2015-05-26 13:00:00 | NQ | Futures | 5256.39 | 5261.38 | 5244.04 | 5245.8 | 19710.0 |
| 2015-05-26 14:00:00 | NQ | Futures | 5245.8 | 5252.86 | 5240.21 | 5240.8 | 16337.0 |
| 2015-05-26 15:00:00 | NQ | Futures | 5241.09 | 5264.03 | 5240.21 | 5261.09 | 30881.0 |
| 2015-05-26 16:00:00 | NQ | Futures | 5260.8 | 5271.09 | 5260.8 | 5270.21 | 6165.0 |
| 2015-05-26 17:00:00 | NQ | Futures | 5270.21 | 5272.27 | 5269.91 | 5270.21 | 174.0 |
| 2015-05-26 18:00:00 | NQ | Futures | 5271.38 | 5273.15 | 5266.38 | 5266.68 | 404.0 |
| 2015-05-26 19:00:00 | NQ | Futures | 5266.68 | 5268.44 | 5264.33 | 5265.8 | 345.0 |
| 2015-05-26 20:00:00 | NQ | Futures | 5266.09 | 5268.15 | 5262.56 | 5266.68 | 484.0 |
| 2015-05-26 21:00:00 | NQ | Futures | 5266.97 | 5268.44 | 5263.44 | 5264.33 | 243.0 |
| 2015-05-26 22:00:00 | NQ | Futures | 5264.03 | 5266.97 | 5261.38 | 5263.44 | 415.0 |
| 2015-05-26 23:00:00 | NQ | Futures | 5263.74 | 5266.38 | 5263.44 | 5264.62 | 308.0 |
| 2015-05-26 00:00:00 | YM | Futures | 19087.8 | 19094.1 | 19077.3 | 19080.5 | 629.0 |
| 2015-05-26 01:00:00 | YM | Futures | 19079.4 | 19088.9 | 19078.4 | 19088.9 | 257.0 |
> showing 50 of 1,547 rows — these rows as CSV