PREVIEW / futures_1hour / 2015-02-06
file: by_date/futures_1hour/2015/2015-02-06.parquet size: 45 KB rows: 1,303
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-06 00:00:00 | ES | Futures | 2161.79 | 2163.11 | 2161.53 | 2162.85 | 1371.0 |
| 2015-02-06 01:00:00 | ES | Futures | 2162.58 | 2163.37 | 2162.06 | 2162.06 | 1607.0 |
| 2015-02-06 02:00:00 | ES | Futures | 2162.32 | 2165.74 | 2161.53 | 2164.95 | 5419.0 |
| 2015-02-06 03:00:00 | ES | Futures | 2164.95 | 2167.06 | 2163.11 | 2164.95 | 16565.0 |
| 2015-02-06 04:00:00 | ES | Futures | 2164.95 | 2166.0 | 2163.11 | 2163.63 | 6847.0 |
| 2015-02-06 05:00:00 | ES | Futures | 2163.63 | 2164.69 | 2163.11 | 2163.11 | 5467.0 |
| 2015-02-06 06:00:00 | ES | Futures | 2163.37 | 2165.21 | 2163.37 | 2164.69 | 6169.0 |
| 2015-02-06 07:00:00 | ES | Futures | 2164.95 | 2167.06 | 2163.9 | 2163.9 | 11720.0 |
| 2015-02-06 08:00:00 | ES | Futures | 2163.63 | 2174.16 | 2162.85 | 2169.69 | 116575.0 |
| 2015-02-06 09:00:00 | ES | Futures | 2169.69 | 2171.79 | 2164.16 | 2168.9 | 235742.0 |
| 2015-02-06 10:00:00 | ES | Futures | 2168.9 | 2176.79 | 2168.63 | 2174.16 | 214010.0 |
| 2015-02-06 11:00:00 | ES | Futures | 2174.16 | 2176.27 | 2171.53 | 2174.42 | 173367.0 |
| 2015-02-06 12:00:00 | ES | Futures | 2174.69 | 2175.74 | 2167.32 | 2172.32 | 146511.0 |
| 2015-02-06 13:00:00 | ES | Futures | 2172.32 | 2173.11 | 2160.48 | 2166.27 | 222186.0 |
| 2015-02-06 14:00:00 | ES | Futures | 2166.0 | 2169.95 | 2161.27 | 2161.79 | 148116.0 |
| 2015-02-06 15:00:00 | ES | Futures | 2161.79 | 2161.79 | 2152.06 | 2158.37 | 302450.0 |
| 2015-02-06 16:00:00 | ES | Futures | 2158.11 | 2163.63 | 2157.06 | 2163.11 | 84386.0 |
| 2015-02-06 17:00:00 | ES | Futures | 2162.85 | 2164.42 | 2161.53 | 2164.16 | 3045.0 |
| 2015-02-06 00:00:00 | NQ | Futures | 4989.18 | 4992.7 | 4988.59 | 4992.12 | 511.0 |
| 2015-02-06 01:00:00 | NQ | Futures | 4992.12 | 4992.7 | 4990.35 | 4990.35 | 256.0 |
| 2015-02-06 02:00:00 | NQ | Futures | 4990.35 | 4998.28 | 4988.88 | 4996.81 | 1020.0 |
| 2015-02-06 03:00:00 | NQ | Futures | 4996.52 | 4999.46 | 4991.23 | 4995.35 | 3297.0 |
| 2015-02-06 04:00:00 | NQ | Futures | 4995.64 | 4997.11 | 4990.06 | 4991.23 | 1162.0 |
| 2015-02-06 05:00:00 | NQ | Futures | 4991.53 | 4994.17 | 4990.94 | 4991.23 | 1366.0 |
| 2015-02-06 06:00:00 | NQ | Futures | 4991.23 | 4995.05 | 4991.23 | 4993.58 | 932.0 |
| 2015-02-06 07:00:00 | NQ | Futures | 4993.58 | 4997.4 | 4991.23 | 4991.23 | 2055.0 |
| 2015-02-06 08:00:00 | NQ | Futures | 4990.94 | 5008.56 | 4988.59 | 5002.1 | 15824.0 |
| 2015-02-06 09:00:00 | NQ | Futures | 5001.81 | 5006.21 | 4978.31 | 4991.82 | 42661.0 |
| 2015-02-06 10:00:00 | NQ | Futures | 4991.53 | 5014.14 | 4988.59 | 5007.97 | 28580.0 |
| 2015-02-06 11:00:00 | NQ | Futures | 5007.97 | 5013.55 | 5004.16 | 5008.86 | 17319.0 |
| 2015-02-06 12:00:00 | NQ | Futures | 5009.15 | 5011.5 | 4987.71 | 4999.46 | 21639.0 |
| 2015-02-06 13:00:00 | NQ | Futures | 4999.75 | 5001.51 | 4969.5 | 4983.6 | 34357.0 |
| 2015-02-06 14:00:00 | NQ | Futures | 4983.3 | 4994.76 | 4974.49 | 4975.08 | 18416.0 |
| 2015-02-06 15:00:00 | NQ | Futures | 4975.08 | 4975.38 | 4945.42 | 4963.33 | 53593.0 |
| 2015-02-06 16:00:00 | NQ | Futures | 4963.04 | 4972.14 | 4961.28 | 4970.97 | 7427.0 |
| 2015-02-06 17:00:00 | NQ | Futures | 4970.97 | 4976.26 | 4968.33 | 4976.26 | 550.0 |
| 2015-02-06 00:00:00 | YM | Futures | 18550.7 | 18567.4 | 18550.7 | 18562.2 | 623.0 |
| 2015-02-06 01:00:00 | YM | Futures | 18564.3 | 18570.6 | 18560.1 | 18562.2 | 391.0 |
| 2015-02-06 02:00:00 | YM | Futures | 18560.1 | 18592.5 | 18558.1 | 18583.1 | 1017.0 |
| 2015-02-06 03:00:00 | YM | Futures | 18584.1 | 18597.7 | 18568.5 | 18586.2 | 3143.0 |
| 2015-02-06 04:00:00 | YM | Futures | 18585.2 | 18591.5 | 18565.4 | 18570.6 | 1136.0 |
| 2015-02-06 05:00:00 | YM | Futures | 18568.5 | 18583.1 | 18568.5 | 18572.7 | 894.0 |
| 2015-02-06 06:00:00 | YM | Futures | 18572.7 | 18586.2 | 18572.7 | 18583.1 | 832.0 |
| 2015-02-06 07:00:00 | YM | Futures | 18584.1 | 18600.8 | 18574.8 | 18574.8 | 1378.0 |
| 2015-02-06 08:00:00 | YM | Futures | 18574.8 | 18662.4 | 18563.3 | 18628.0 | 12818.0 |
| 2015-02-06 09:00:00 | YM | Futures | 18626.9 | 18648.9 | 18586.2 | 18624.9 | 20246.0 |
| 2015-02-06 10:00:00 | YM | Futures | 18624.9 | 18678.1 | 18619.6 | 18654.1 | 15511.0 |
| 2015-02-06 11:00:00 | YM | Futures | 18653.0 | 18664.5 | 18630.1 | 18647.8 | 10506.0 |
| 2015-02-06 12:00:00 | YM | Futures | 18648.9 | 18661.4 | 18600.8 | 18635.3 | 11139.0 |
| 2015-02-06 13:00:00 | YM | Futures | 18636.3 | 18643.6 | 18541.3 | 18586.2 | 18232.0 |
> showing 50 of 1,303 rows — these rows as CSV