PREVIEW / futures_1hour / 2015-02-03
file: by_date/futures_1hour/2015/2015-02-03.parquet size: 55 KB rows: 1,617
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-03 00:00:00 | ES | Futures | 2114.43 | 2115.48 | 2112.58 | 2114.69 | 4558.0 |
| 2015-02-03 01:00:00 | ES | Futures | 2114.69 | 2118.9 | 2114.16 | 2118.37 | 3488.0 |
| 2015-02-03 02:00:00 | ES | Futures | 2118.11 | 2121.79 | 2117.06 | 2119.95 | 9226.0 |
| 2015-02-03 03:00:00 | ES | Futures | 2119.95 | 2131.53 | 2118.9 | 2131.0 | 32241.0 |
| 2015-02-03 04:00:00 | ES | Futures | 2131.0 | 2131.27 | 2122.06 | 2123.37 | 20114.0 |
| 2015-02-03 05:00:00 | ES | Futures | 2123.37 | 2129.16 | 2122.58 | 2126.79 | 12919.0 |
| 2015-02-03 06:00:00 | ES | Futures | 2126.79 | 2134.69 | 2126.27 | 2131.53 | 19510.0 |
| 2015-02-03 07:00:00 | ES | Futures | 2131.53 | 2133.11 | 2127.06 | 2128.9 | 17052.0 |
| 2015-02-03 08:00:00 | ES | Futures | 2128.9 | 2131.53 | 2124.16 | 2130.21 | 47549.0 |
| 2015-02-03 09:00:00 | ES | Futures | 2130.48 | 2141.53 | 2129.69 | 2140.74 | 252349.0 |
| 2015-02-03 10:00:00 | ES | Futures | 2140.48 | 2141.27 | 2129.42 | 2129.42 | 293311.0 |
| 2015-02-03 11:00:00 | ES | Futures | 2129.42 | 2137.85 | 2128.64 | 2129.95 | 205026.0 |
| 2015-02-03 12:00:00 | ES | Futures | 2129.95 | 2136.53 | 2127.32 | 2134.16 | 136599.0 |
| 2015-02-03 13:00:00 | ES | Futures | 2134.16 | 2146.27 | 2133.11 | 2145.74 | 185379.0 |
| 2015-02-03 14:00:00 | ES | Futures | 2145.74 | 2147.85 | 2138.9 | 2144.95 | 156910.0 |
| 2015-02-03 15:00:00 | ES | Futures | 2145.21 | 2151.53 | 2143.11 | 2151.0 | 204367.0 |
| 2015-02-03 16:00:00 | ES | Futures | 2151.27 | 2151.53 | 2147.85 | 2148.9 | 68131.0 |
| 2015-02-03 17:00:00 | ES | Futures | 2148.9 | 2149.16 | 2147.85 | 2148.37 | 2197.0 |
| 2015-02-03 18:00:00 | ES | Futures | 2147.85 | 2149.16 | 2146.27 | 2146.53 | 5201.0 |
| 2015-02-03 19:00:00 | ES | Futures | 2146.27 | 2149.16 | 2146.27 | 2149.16 | 5441.0 |
| 2015-02-03 20:00:00 | ES | Futures | 2149.16 | 2150.21 | 2147.32 | 2147.85 | 3521.0 |
| 2015-02-03 21:00:00 | ES | Futures | 2147.58 | 2149.69 | 2147.58 | 2148.63 | 2830.0 |
| 2015-02-03 22:00:00 | ES | Futures | 2148.9 | 2149.42 | 2146.79 | 2147.85 | 2814.0 |
| 2015-02-03 23:00:00 | ES | Futures | 2147.85 | 2148.11 | 2147.06 | 2147.85 | 1118.0 |
| 2015-02-03 00:00:00 | NQ | Futures | 4897.55 | 4900.19 | 4893.73 | 4897.84 | 431.0 |
| 2015-02-03 01:00:00 | NQ | Futures | 4897.55 | 4905.77 | 4896.96 | 4905.18 | 568.0 |
| 2015-02-03 02:00:00 | NQ | Futures | 4904.6 | 4911.35 | 4901.95 | 4908.71 | 1128.0 |
| 2015-02-03 03:00:00 | NQ | Futures | 4907.83 | 4933.97 | 4904.6 | 4933.08 | 5486.0 |
| 2015-02-03 04:00:00 | NQ | Futures | 4932.5 | 4933.08 | 4910.76 | 4913.99 | 4029.0 |
| 2015-02-03 05:00:00 | NQ | Futures | 4913.99 | 4928.39 | 4911.94 | 4922.51 | 2344.0 |
| 2015-02-03 06:00:00 | NQ | Futures | 4922.51 | 4937.78 | 4920.75 | 4931.03 | 4157.0 |
| 2015-02-03 07:00:00 | NQ | Futures | 4930.73 | 4936.9 | 4922.51 | 4926.04 | 4175.0 |
| 2015-02-03 08:00:00 | NQ | Futures | 4926.04 | 4929.85 | 4915.17 | 4926.92 | 7632.0 |
| 2015-02-03 09:00:00 | NQ | Futures | 4927.21 | 4948.06 | 4921.92 | 4938.96 | 44162.0 |
| 2015-02-03 10:00:00 | NQ | Futures | 4938.66 | 4940.43 | 4902.83 | 4904.3 | 52855.0 |
| 2015-02-03 11:00:00 | NQ | Futures | 4904.01 | 4921.04 | 4898.43 | 4899.9 | 35319.0 |
| 2015-02-03 12:00:00 | NQ | Futures | 4899.9 | 4918.4 | 4894.02 | 4914.58 | 25134.0 |
| 2015-02-03 13:00:00 | NQ | Futures | 4914.58 | 4938.96 | 4911.35 | 4938.66 | 25741.0 |
| 2015-02-03 14:00:00 | NQ | Futures | 4938.37 | 4943.36 | 4924.86 | 4943.36 | 19736.0 |
| 2015-02-03 15:00:00 | NQ | Futures | 4943.36 | 4959.52 | 4937.49 | 4956.87 | 35676.0 |
| 2015-02-03 16:00:00 | NQ | Futures | 4956.87 | 4960.69 | 4948.36 | 4948.65 | 9539.0 |
| 2015-02-03 17:00:00 | NQ | Futures | 4948.65 | 4948.65 | 4946.59 | 4948.36 | 177.0 |
| 2015-02-03 18:00:00 | NQ | Futures | 4943.07 | 4945.71 | 4940.72 | 4941.6 | 696.0 |
| 2015-02-03 19:00:00 | NQ | Futures | 4941.89 | 4948.65 | 4941.6 | 4948.06 | 661.0 |
| 2015-02-03 20:00:00 | NQ | Futures | 4948.65 | 4951.29 | 4943.95 | 4946.59 | 736.0 |
| 2015-02-03 21:00:00 | NQ | Futures | 4946.3 | 4950.41 | 4945.71 | 4947.77 | 532.0 |
| 2015-02-03 22:00:00 | NQ | Futures | 4948.06 | 4949.24 | 4942.19 | 4945.13 | 503.0 |
| 2015-02-03 23:00:00 | NQ | Futures | 4945.13 | 4946.3 | 4942.78 | 4946.3 | 169.0 |
| 2015-02-03 00:00:00 | YM | Futures | 17986.0 | 17993.3 | 17969.3 | 17989.1 | 682.0 |
| 2015-02-03 01:00:00 | YM | Futures | 17988.1 | 18020.5 | 17983.9 | 18017.3 | 434.0 |
> showing 50 of 1,617 rows — these rows as CSV