PREVIEW / futures_1hour / 2015-05-29
file: by_date/futures_1hour/2015/2015-05-29.parquet size: 43 KB rows: 1,293
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-29 00:00:00 | ES | Futures | 2241.04 | 2241.83 | 2240.78 | 2241.57 | 1108.0 |
| 2015-05-29 01:00:00 | ES | Futures | 2241.3 | 2241.83 | 2239.45 | 2239.45 | 3441.0 |
| 2015-05-29 02:00:00 | ES | Futures | 2239.45 | 2240.25 | 2236.81 | 2237.08 | 7538.0 |
| 2015-05-29 03:00:00 | ES | Futures | 2236.81 | 2237.34 | 2231.53 | 2235.23 | 28055.0 |
| 2015-05-29 04:00:00 | ES | Futures | 2235.23 | 2235.23 | 2231.27 | 2234.44 | 17745.0 |
| 2015-05-29 05:00:00 | ES | Futures | 2234.17 | 2235.49 | 2232.06 | 2235.49 | 12224.0 |
| 2015-05-29 06:00:00 | ES | Futures | 2235.23 | 2241.83 | 2234.7 | 2239.98 | 25915.0 |
| 2015-05-29 07:00:00 | ES | Futures | 2239.98 | 2240.25 | 2237.34 | 2238.13 | 13011.0 |
| 2015-05-29 08:00:00 | ES | Futures | 2238.4 | 2239.45 | 2234.96 | 2235.76 | 27353.0 |
| 2015-05-29 09:00:00 | ES | Futures | 2235.76 | 2238.4 | 2231.8 | 2234.44 | 163048.0 |
| 2015-05-29 10:00:00 | ES | Futures | 2234.17 | 2235.23 | 2220.97 | 2223.87 | 308003.0 |
| 2015-05-29 11:00:00 | ES | Futures | 2223.87 | 2228.89 | 2221.23 | 2227.83 | 216748.0 |
| 2015-05-29 12:00:00 | ES | Futures | 2227.83 | 2233.12 | 2227.04 | 2230.47 | 119979.0 |
| 2015-05-29 13:00:00 | ES | Futures | 2230.47 | 2234.44 | 2229.42 | 2231.27 | 86607.0 |
| 2015-05-29 14:00:00 | ES | Futures | 2231.0 | 2231.53 | 2221.76 | 2224.4 | 159304.0 |
| 2015-05-29 15:00:00 | ES | Futures | 2224.66 | 2229.95 | 2223.61 | 2223.87 | 337906.0 |
| 2015-05-29 16:00:00 | ES | Futures | 2224.14 | 2227.04 | 2222.02 | 2226.51 | 139202.0 |
| 2015-05-29 17:00:00 | ES | Futures | 2226.51 | 2226.78 | 2224.4 | 2224.93 | 2651.0 |
| 2015-05-29 00:00:00 | NQ | Futures | 5343.72 | 5345.19 | 5343.72 | 5344.6 | 137.0 |
| 2015-05-29 01:00:00 | NQ | Futures | 5344.9 | 5345.78 | 5340.49 | 5340.49 | 313.0 |
| 2015-05-29 02:00:00 | NQ | Futures | 5340.19 | 5340.78 | 5334.02 | 5334.02 | 856.0 |
| 2015-05-29 03:00:00 | NQ | Futures | 5334.02 | 5335.78 | 5316.08 | 5321.96 | 4707.0 |
| 2015-05-29 04:00:00 | NQ | Futures | 5321.96 | 5321.96 | 5309.61 | 5318.43 | 3868.0 |
| 2015-05-29 05:00:00 | NQ | Futures | 5318.14 | 5321.96 | 5311.96 | 5321.96 | 1892.0 |
| 2015-05-29 06:00:00 | NQ | Futures | 5321.67 | 5343.43 | 5320.49 | 5335.49 | 4785.0 |
| 2015-05-29 07:00:00 | NQ | Futures | 5335.49 | 5336.67 | 5330.49 | 5332.25 | 1827.0 |
| 2015-05-29 08:00:00 | NQ | Futures | 5332.55 | 5333.43 | 5322.55 | 5326.08 | 4454.0 |
| 2015-05-29 09:00:00 | NQ | Futures | 5326.08 | 5339.02 | 5322.84 | 5330.78 | 23916.0 |
| 2015-05-29 10:00:00 | NQ | Futures | 5331.08 | 5334.61 | 5289.91 | 5299.32 | 39775.0 |
| 2015-05-29 11:00:00 | NQ | Futures | 5299.32 | 5316.37 | 5296.67 | 5313.14 | 23112.0 |
| 2015-05-29 12:00:00 | NQ | Futures | 5313.43 | 5329.31 | 5313.14 | 5323.73 | 16713.0 |
| 2015-05-29 13:00:00 | NQ | Futures | 5324.02 | 5331.67 | 5319.9 | 5320.79 | 9294.0 |
| 2015-05-29 14:00:00 | NQ | Futures | 5320.79 | 5321.08 | 5294.03 | 5301.97 | 20460.0 |
| 2015-05-29 15:00:00 | NQ | Futures | 5301.67 | 5314.9 | 5300.2 | 5303.73 | 31279.0 |
| 2015-05-29 16:00:00 | NQ | Futures | 5304.02 | 5313.14 | 5298.14 | 5311.96 | 8550.0 |
| 2015-05-29 17:00:00 | NQ | Futures | 5312.26 | 5312.85 | 5308.14 | 5308.14 | 250.0 |
| 2015-05-29 00:00:00 | YM | Futures | 19016.5 | 19023.9 | 19016.5 | 19019.7 | 167.0 |
| 2015-05-29 01:00:00 | YM | Futures | 19020.7 | 19022.8 | 19006.0 | 19007.1 | 447.0 |
| 2015-05-29 02:00:00 | YM | Futures | 19005.0 | 19008.1 | 18986.1 | 18986.1 | 979.0 |
| 2015-05-29 03:00:00 | YM | Futures | 18986.1 | 18993.4 | 18941.0 | 18958.8 | 4955.0 |
| 2015-05-29 04:00:00 | YM | Futures | 18956.7 | 18958.8 | 18923.2 | 18946.3 | 4411.0 |
| 2015-05-29 05:00:00 | YM | Futures | 18945.2 | 18954.6 | 18927.4 | 18954.6 | 2108.0 |
| 2015-05-29 06:00:00 | YM | Futures | 18953.6 | 19016.5 | 18949.4 | 19008.1 | 5483.0 |
| 2015-05-29 07:00:00 | YM | Futures | 19009.2 | 19012.3 | 18993.4 | 19001.8 | 1964.0 |
| 2015-05-29 08:00:00 | YM | Futures | 19002.9 | 19006.0 | 18962.0 | 18966.2 | 5077.0 |
| 2015-05-29 09:00:00 | YM | Futures | 18966.2 | 18989.3 | 18914.8 | 18941.0 | 17823.0 |
| 2015-05-29 10:00:00 | YM | Futures | 18941.0 | 18952.6 | 18827.8 | 18852.9 | 29883.0 |
| 2015-05-29 11:00:00 | YM | Futures | 18854.0 | 18894.9 | 18824.6 | 18887.5 | 20230.0 |
| 2015-05-29 12:00:00 | YM | Futures | 18888.6 | 18934.7 | 18878.1 | 18915.8 | 12510.0 |
| 2015-05-29 13:00:00 | YM | Futures | 18916.9 | 18943.1 | 18904.3 | 18912.7 | 7663.0 |
> showing 50 of 1,293 rows — these rows as CSV