PREVIEW / futures_1hour / 2015-06-26
file: by_date/futures_1hour/2015/2015-06-26.parquet size: 44 KB rows: 1,287
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-06-26 00:00:00 | ES | Futures | 2229.03 | 2230.1 | 2229.03 | 2229.83 | 1329.0 |
| 2015-06-26 01:00:00 | ES | Futures | 2230.1 | 2230.1 | 2227.7 | 2229.3 | 3134.0 |
| 2015-06-26 02:00:00 | ES | Futures | 2229.3 | 2231.43 | 2227.7 | 2229.3 | 11735.0 |
| 2015-06-26 03:00:00 | ES | Futures | 2229.3 | 2230.36 | 2226.37 | 2229.03 | 21056.0 |
| 2015-06-26 04:00:00 | ES | Futures | 2228.76 | 2230.36 | 2228.5 | 2229.83 | 11065.0 |
| 2015-06-26 05:00:00 | ES | Futures | 2229.56 | 2230.89 | 2227.97 | 2227.97 | 12634.0 |
| 2015-06-26 06:00:00 | ES | Futures | 2227.97 | 2233.56 | 2227.97 | 2233.29 | 15840.0 |
| 2015-06-26 07:00:00 | ES | Futures | 2233.29 | 2235.69 | 2231.69 | 2234.89 | 27197.0 |
| 2015-06-26 08:00:00 | ES | Futures | 2234.62 | 2235.15 | 2231.43 | 2234.09 | 28409.0 |
| 2015-06-26 09:00:00 | ES | Futures | 2234.36 | 2236.22 | 2227.17 | 2234.62 | 192916.0 |
| 2015-06-26 10:00:00 | ES | Futures | 2234.89 | 2237.28 | 2229.03 | 2229.83 | 183782.0 |
| 2015-06-26 11:00:00 | ES | Futures | 2229.83 | 2234.62 | 2229.03 | 2230.63 | 102793.0 |
| 2015-06-26 12:00:00 | ES | Futures | 2230.63 | 2233.02 | 2224.5 | 2224.77 | 107323.0 |
| 2015-06-26 13:00:00 | ES | Futures | 2224.77 | 2229.03 | 2221.84 | 2227.17 | 166578.0 |
| 2015-06-26 14:00:00 | ES | Futures | 2227.43 | 2228.76 | 2225.04 | 2226.9 | 89687.0 |
| 2015-06-26 15:00:00 | ES | Futures | 2226.9 | 2232.49 | 2226.9 | 2229.3 | 225444.0 |
| 2015-06-26 16:00:00 | ES | Futures | 2229.56 | 2233.02 | 2228.5 | 2232.49 | 96326.0 |
| 2015-06-26 17:00:00 | ES | Futures | 2232.23 | 2232.76 | 2231.69 | 2231.69 | 2296.0 |
| 2015-06-26 00:00:00 | NQ | Futures | 5329.53 | 5331.6 | 5328.65 | 5330.72 | 165.0 |
| 2015-06-26 01:00:00 | NQ | Futures | 5330.72 | 5330.72 | 5325.69 | 5328.35 | 372.0 |
| 2015-06-26 02:00:00 | NQ | Futures | 5328.35 | 5334.56 | 5325.39 | 5328.35 | 805.0 |
| 2015-06-26 03:00:00 | NQ | Futures | 5328.05 | 5332.2 | 5321.55 | 5328.94 | 2459.0 |
| 2015-06-26 04:00:00 | NQ | Futures | 5328.35 | 5331.31 | 5327.76 | 5330.72 | 1060.0 |
| 2015-06-26 05:00:00 | NQ | Futures | 5330.42 | 5333.97 | 5325.69 | 5325.69 | 1351.0 |
| 2015-06-26 06:00:00 | NQ | Futures | 5325.98 | 5338.41 | 5325.69 | 5338.11 | 1667.0 |
| 2015-06-26 07:00:00 | NQ | Futures | 5338.41 | 5342.84 | 5334.86 | 5339.59 | 3611.0 |
| 2015-06-26 08:00:00 | NQ | Futures | 5339.89 | 5339.89 | 5326.87 | 5331.6 | 5004.0 |
| 2015-06-26 09:00:00 | NQ | Futures | 5331.6 | 5338.7 | 5311.79 | 5336.34 | 33584.0 |
| 2015-06-26 10:00:00 | NQ | Futures | 5336.04 | 5344.32 | 5307.05 | 5307.65 | 32234.0 |
| 2015-06-26 11:00:00 | NQ | Futures | 5307.65 | 5322.14 | 5306.17 | 5308.83 | 21831.0 |
| 2015-06-26 12:00:00 | NQ | Futures | 5308.83 | 5313.27 | 5281.02 | 5282.21 | 25252.0 |
| 2015-06-26 13:00:00 | NQ | Futures | 5281.91 | 5297.0 | 5276.59 | 5291.08 | 25981.0 |
| 2015-06-26 14:00:00 | NQ | Futures | 5290.79 | 5294.04 | 5281.62 | 5291.08 | 16506.0 |
| 2015-06-26 15:00:00 | NQ | Futures | 5290.79 | 5308.24 | 5290.19 | 5297.29 | 36733.0 |
| 2015-06-26 16:00:00 | NQ | Futures | 5297.59 | 5303.21 | 5292.26 | 5302.32 | 9595.0 |
| 2015-06-26 17:00:00 | NQ | Futures | 5302.03 | 5302.91 | 5300.55 | 5300.55 | 149.0 |
| 2015-06-26 00:00:00 | YM | Futures | 18770.6 | 18781.1 | 18770.6 | 18780.0 | 279.0 |
| 2015-06-26 01:00:00 | YM | Futures | 18777.9 | 18779.0 | 18760.0 | 18768.4 | 573.0 |
| 2015-06-26 02:00:00 | YM | Futures | 18768.4 | 18781.1 | 18755.8 | 18764.2 | 1626.0 |
| 2015-06-26 03:00:00 | YM | Futures | 18765.3 | 18775.8 | 18737.9 | 18765.3 | 2861.0 |
| 2015-06-26 04:00:00 | YM | Futures | 18764.2 | 18775.8 | 18761.1 | 18771.6 | 1475.0 |
| 2015-06-26 05:00:00 | YM | Futures | 18770.6 | 18779.0 | 18755.8 | 18755.8 | 1368.0 |
| 2015-06-26 06:00:00 | YM | Futures | 18755.8 | 18799.0 | 18755.8 | 18799.0 | 2030.0 |
| 2015-06-26 07:00:00 | YM | Futures | 18799.0 | 18814.8 | 18785.3 | 18809.5 | 3341.0 |
| 2015-06-26 08:00:00 | YM | Futures | 18809.5 | 18812.7 | 18781.1 | 18805.3 | 2998.0 |
| 2015-06-26 09:00:00 | YM | Futures | 18806.4 | 18874.8 | 18783.2 | 18859.0 | 20346.0 |
| 2015-06-26 10:00:00 | YM | Futures | 18860.1 | 18882.2 | 18814.8 | 18821.1 | 20986.0 |
| 2015-06-26 11:00:00 | YM | Futures | 18822.2 | 18862.2 | 18818.0 | 18828.5 | 10349.0 |
| 2015-06-26 12:00:00 | YM | Futures | 18829.5 | 18844.3 | 18777.9 | 18780.0 | 9949.0 |
| 2015-06-26 13:00:00 | YM | Futures | 18780.0 | 18815.9 | 18757.9 | 18796.9 | 14060.0 |
> showing 50 of 1,287 rows — these rows as CSV