PREVIEW / futures_1hour / 2015-06-30
file: by_date/futures_1hour/2015/2015-06-30.parquet size: 50 KB rows: 1,490
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-30 00:00:00 | ES | Futures | 2188.83 | 2189.36 | 2188.29 | 2188.56 | 4093.0 |
| 2015-06-30 01:00:00 | ES | Futures | 2188.56 | 2189.89 | 2188.29 | 2189.09 | 6285.0 |
| 2015-06-30 02:00:00 | ES | Futures | 2189.09 | 2191.76 | 2188.03 | 2190.42 | 20369.0 |
| 2015-06-30 03:00:00 | ES | Futures | 2190.42 | 2192.55 | 2186.96 | 2192.02 | 35696.0 |
| 2015-06-30 04:00:00 | ES | Futures | 2192.02 | 2192.29 | 2186.43 | 2190.96 | 34768.0 |
| 2015-06-30 05:00:00 | ES | Futures | 2190.96 | 2203.47 | 2190.16 | 2198.68 | 77200.0 |
| 2015-06-30 06:00:00 | ES | Futures | 2198.41 | 2201.61 | 2193.09 | 2195.75 | 52117.0 |
| 2015-06-30 07:00:00 | ES | Futures | 2196.02 | 2198.41 | 2193.35 | 2197.08 | 34908.0 |
| 2015-06-30 08:00:00 | ES | Futures | 2197.35 | 2201.87 | 2197.08 | 2200.01 | 55588.0 |
| 2015-06-30 09:00:00 | ES | Futures | 2200.01 | 2202.94 | 2189.36 | 2189.36 | 263146.0 |
| 2015-06-30 10:00:00 | ES | Futures | 2189.36 | 2192.55 | 2184.03 | 2189.63 | 287242.0 |
| 2015-06-30 11:00:00 | ES | Futures | 2189.63 | 2193.35 | 2184.83 | 2185.37 | 240018.0 |
| 2015-06-30 12:00:00 | ES | Futures | 2185.1 | 2188.56 | 2179.77 | 2185.1 | 209822.0 |
| 2015-06-30 13:00:00 | ES | Futures | 2185.1 | 2195.48 | 2183.77 | 2192.82 | 198730.0 |
| 2015-06-30 14:00:00 | ES | Futures | 2192.55 | 2200.28 | 2189.89 | 2190.16 | 227286.0 |
| 2015-06-30 15:00:00 | ES | Futures | 2190.16 | 2193.62 | 2185.9 | 2186.7 | 403001.0 |
| 2015-06-30 16:00:00 | ES | Futures | 2186.7 | 2190.69 | 2182.97 | 2190.42 | 164848.0 |
| 2015-06-30 17:00:00 | ES | Futures | 2190.42 | 2190.42 | 2187.76 | 2188.56 | 4201.0 |
| 2015-06-30 20:00:00 | ES | Futures | 2188.03 | 2191.76 | 2188.03 | 2190.16 | 6312.0 |
| 2015-06-30 21:00:00 | ES | Futures | 2190.16 | 2196.55 | 2189.89 | 2194.68 | 11727.0 |
| 2015-06-30 22:00:00 | ES | Futures | 2194.68 | 2197.35 | 2194.42 | 2195.48 | 5852.0 |
| 2015-06-30 23:00:00 | ES | Futures | 2195.48 | 2196.28 | 2194.15 | 2195.22 | 2757.0 |
| 2015-06-30 00:00:00 | NQ | Futures | 5193.47 | 5194.06 | 5191.99 | 5192.29 | 518.0 |
| 2015-06-30 01:00:00 | NQ | Futures | 5191.99 | 5193.47 | 5191.1 | 5192.58 | 554.0 |
| 2015-06-30 02:00:00 | NQ | Futures | 5191.99 | 5196.13 | 5189.92 | 5191.99 | 1764.0 |
| 2015-06-30 03:00:00 | NQ | Futures | 5192.29 | 5195.54 | 5184.89 | 5194.65 | 4393.0 |
| 2015-06-30 04:00:00 | NQ | Futures | 5194.65 | 5194.95 | 5179.86 | 5190.51 | 4144.0 |
| 2015-06-30 05:00:00 | NQ | Futures | 5190.51 | 5213.88 | 5189.03 | 5206.49 | 12535.0 |
| 2015-06-30 06:00:00 | NQ | Futures | 5206.49 | 5212.4 | 5193.77 | 5199.98 | 7937.0 |
| 2015-06-30 07:00:00 | NQ | Futures | 5199.98 | 5205.6 | 5194.95 | 5202.94 | 4398.0 |
| 2015-06-30 08:00:00 | NQ | Futures | 5203.23 | 5213.58 | 5203.23 | 5209.74 | 8748.0 |
| 2015-06-30 09:00:00 | NQ | Futures | 5209.44 | 5214.77 | 5188.44 | 5188.44 | 45056.0 |
| 2015-06-30 10:00:00 | NQ | Futures | 5188.44 | 5199.09 | 5176.31 | 5191.4 | 42689.0 |
| 2015-06-30 11:00:00 | NQ | Futures | 5191.4 | 5204.12 | 5184.89 | 5185.78 | 31677.0 |
| 2015-06-30 12:00:00 | NQ | Futures | 5185.78 | 5193.47 | 5172.77 | 5183.12 | 23932.0 |
| 2015-06-30 13:00:00 | NQ | Futures | 5183.12 | 5210.63 | 5177.5 | 5204.71 | 26537.0 |
| 2015-06-30 14:00:00 | NQ | Futures | 5204.41 | 5220.39 | 5197.02 | 5197.91 | 31425.0 |
| 2015-06-30 15:00:00 | NQ | Futures | 5197.91 | 5206.19 | 5189.03 | 5191.1 | 37604.0 |
| 2015-06-30 16:00:00 | NQ | Futures | 5191.4 | 5199.68 | 5184.3 | 5198.79 | 10925.0 |
| 2015-06-30 17:00:00 | NQ | Futures | 5198.5 | 5198.79 | 5193.17 | 5193.77 | 117.0 |
| 2015-06-30 20:00:00 | NQ | Futures | 5197.32 | 5203.82 | 5196.43 | 5199.98 | 595.0 |
| 2015-06-30 21:00:00 | NQ | Futures | 5199.68 | 5212.7 | 5199.68 | 5209.74 | 1313.0 |
| 2015-06-30 22:00:00 | NQ | Futures | 5209.74 | 5213.88 | 5208.56 | 5211.22 | 916.0 |
| 2015-06-30 23:00:00 | NQ | Futures | 5210.63 | 5211.81 | 5207.96 | 5210.33 | 449.0 |
| 2015-06-30 00:00:00 | YM | Futures | 18503.0 | 18503.0 | 18497.7 | 18498.8 | 359.0 |
| 2015-06-30 01:00:00 | YM | Futures | 18497.7 | 18509.3 | 18496.7 | 18505.1 | 478.0 |
| 2015-06-30 02:00:00 | YM | Futures | 18505.1 | 18520.9 | 18496.7 | 18510.3 | 1799.0 |
| 2015-06-30 03:00:00 | YM | Futures | 18510.3 | 18520.9 | 18480.9 | 18516.7 | 3497.0 |
| 2015-06-30 04:00:00 | YM | Futures | 18516.7 | 18517.7 | 18468.2 | 18501.9 | 4622.0 |
| 2015-06-30 05:00:00 | YM | Futures | 18503.0 | 18589.4 | 18497.7 | 18558.8 | 11889.0 |
> showing 50 of 1,490 rows — these rows as CSV