PREVIEW / futures_1hour / 2015-01-22
file: by_date/futures_1hour/2015/2015-01-22.parquet size: 54 KB rows: 1,592
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-01-22 00:00:00 | ES | Futures | 2136.53 | 2137.32 | 2135.74 | 2136.27 | 2035.0 |
| 2015-01-22 01:00:00 | ES | Futures | 2136.53 | 2139.42 | 2136.53 | 2138.37 | 3033.0 |
| 2015-01-22 02:00:00 | ES | Futures | 2138.11 | 2141.53 | 2136.0 | 2141.53 | 8099.0 |
| 2015-01-22 03:00:00 | ES | Futures | 2141.79 | 2141.79 | 2138.64 | 2141.0 | 14493.0 |
| 2015-01-22 04:00:00 | ES | Futures | 2140.74 | 2142.85 | 2138.64 | 2139.16 | 11936.0 |
| 2015-01-22 05:00:00 | ES | Futures | 2139.42 | 2140.48 | 2136.79 | 2136.79 | 11846.0 |
| 2015-01-22 06:00:00 | ES | Futures | 2136.79 | 2138.37 | 2134.69 | 2137.58 | 19553.0 |
| 2015-01-22 07:00:00 | ES | Futures | 2137.85 | 2146.0 | 2135.74 | 2143.9 | 35626.0 |
| 2015-01-22 08:00:00 | ES | Futures | 2143.9 | 2154.69 | 2136.79 | 2144.95 | 164090.0 |
| 2015-01-22 09:00:00 | ES | Futures | 2144.69 | 2149.42 | 2125.48 | 2131.79 | 357143.0 |
| 2015-01-22 10:00:00 | ES | Futures | 2132.06 | 2153.11 | 2131.27 | 2153.11 | 293614.0 |
| 2015-01-22 11:00:00 | ES | Futures | 2153.11 | 2153.63 | 2143.64 | 2147.06 | 198332.0 |
| 2015-01-22 12:00:00 | ES | Futures | 2147.06 | 2149.42 | 2143.9 | 2146.27 | 110804.0 |
| 2015-01-22 13:00:00 | ES | Futures | 2146.27 | 2151.0 | 2144.69 | 2150.48 | 95510.0 |
| 2015-01-22 14:00:00 | ES | Futures | 2150.48 | 2163.9 | 2149.16 | 2163.37 | 181970.0 |
| 2015-01-22 15:00:00 | ES | Futures | 2163.37 | 2167.58 | 2162.58 | 2165.21 | 225968.0 |
| 2015-01-22 16:00:00 | ES | Futures | 2165.48 | 2166.27 | 2162.58 | 2166.0 | 78935.0 |
| 2015-01-22 17:00:00 | ES | Futures | 2165.74 | 2166.0 | 2164.69 | 2164.95 | 1550.0 |
| 2015-01-22 18:00:00 | ES | Futures | 2164.69 | 2166.0 | 2163.11 | 2164.16 | 5972.0 |
| 2015-01-22 19:00:00 | ES | Futures | 2163.9 | 2164.16 | 2161.79 | 2162.58 | 7397.0 |
| 2015-01-22 20:00:00 | ES | Futures | 2162.58 | 2163.11 | 2161.27 | 2162.32 | 3335.0 |
| 2015-01-22 21:00:00 | ES | Futures | 2162.32 | 2162.58 | 2160.74 | 2161.53 | 3052.0 |
| 2015-01-22 22:00:00 | ES | Futures | 2161.79 | 2163.37 | 2161.0 | 2162.06 | 2810.0 |
| 2015-01-22 23:00:00 | ES | Futures | 2162.06 | 2162.58 | 2161.53 | 2161.79 | 1529.0 |
| 2015-01-22 00:00:00 | NQ | Futures | 4920.75 | 4922.22 | 4918.4 | 4918.4 | 762.0 |
| 2015-01-22 01:00:00 | NQ | Futures | 4918.69 | 4925.74 | 4918.69 | 4923.39 | 565.0 |
| 2015-01-22 02:00:00 | NQ | Futures | 4923.1 | 4931.91 | 4919.28 | 4931.91 | 1162.0 |
| 2015-01-22 03:00:00 | NQ | Futures | 4931.62 | 4931.62 | 4923.98 | 4929.27 | 3076.0 |
| 2015-01-22 04:00:00 | NQ | Futures | 4929.56 | 4933.08 | 4923.1 | 4925.45 | 1691.0 |
| 2015-01-22 05:00:00 | NQ | Futures | 4925.74 | 4927.8 | 4918.11 | 4919.28 | 1881.0 |
| 2015-01-22 06:00:00 | NQ | Futures | 4919.57 | 4921.92 | 4913.41 | 4918.11 | 3694.0 |
| 2015-01-22 07:00:00 | NQ | Futures | 4917.81 | 4937.49 | 4912.53 | 4933.38 | 6941.0 |
| 2015-01-22 08:00:00 | NQ | Futures | 4933.38 | 4958.05 | 4918.11 | 4938.96 | 22046.0 |
| 2015-01-22 09:00:00 | NQ | Futures | 4939.25 | 4955.99 | 4892.26 | 4911.06 | 73563.0 |
| 2015-01-22 10:00:00 | NQ | Futures | 4911.06 | 4967.15 | 4909.59 | 4966.86 | 58511.0 |
| 2015-01-22 11:00:00 | NQ | Futures | 4966.86 | 4975.96 | 4956.58 | 4967.15 | 39127.0 |
| 2015-01-22 12:00:00 | NQ | Futures | 4967.15 | 4972.14 | 4958.34 | 4962.75 | 20805.0 |
| 2015-01-22 13:00:00 | NQ | Futures | 4962.75 | 4971.56 | 4954.52 | 4965.1 | 18179.0 |
| 2015-01-22 14:00:00 | NQ | Futures | 4965.1 | 4999.16 | 4960.4 | 4996.81 | 32750.0 |
| 2015-01-22 15:00:00 | NQ | Futures | 4996.81 | 5014.14 | 4994.76 | 5008.56 | 39086.0 |
| 2015-01-22 16:00:00 | NQ | Futures | 5008.56 | 5015.02 | 5005.33 | 5015.02 | 9820.0 |
| 2015-01-22 17:00:00 | NQ | Futures | 5015.02 | 5015.02 | 5011.21 | 5011.5 | 495.0 |
| 2015-01-22 18:00:00 | NQ | Futures | 5010.91 | 5011.79 | 5006.8 | 5007.39 | 1190.0 |
| 2015-01-22 19:00:00 | NQ | Futures | 5007.97 | 5007.97 | 5002.69 | 5005.04 | 1988.0 |
| 2015-01-22 20:00:00 | NQ | Futures | 5005.33 | 5006.21 | 5002.39 | 5006.21 | 1238.0 |
| 2015-01-22 21:00:00 | NQ | Futures | 5006.21 | 5006.51 | 5002.1 | 5004.16 | 483.0 |
| 2015-01-22 22:00:00 | NQ | Futures | 5004.16 | 5006.8 | 5002.39 | 5004.45 | 398.0 |
| 2015-01-22 23:00:00 | NQ | Futures | 5004.74 | 5005.04 | 5002.39 | 5003.57 | 185.0 |
| 2015-01-22 00:00:00 | YM | Futures | 18283.5 | 18290.8 | 18279.3 | 18284.6 | 290.0 |
| 2015-01-22 01:00:00 | YM | Futures | 18286.6 | 18310.7 | 18285.6 | 18304.4 | 559.0 |
> showing 50 of 1,592 rows — these rows as CSV