PREVIEW / futures_1hour / 2015-08-21
file: by_date/futures_1hour/2015/2015-08-21.parquet size: 46 KB rows: 1,301
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-08-21 00:00:00 | ES | Futures | 2148.36 | 2148.62 | 2144.9 | 2145.96 | 7441.0 |
| 2015-08-21 01:00:00 | ES | Futures | 2145.96 | 2147.82 | 2142.77 | 2146.23 | 18129.0 |
| 2015-08-21 02:00:00 | ES | Futures | 2145.96 | 2150.22 | 2145.43 | 2149.42 | 26397.0 |
| 2015-08-21 03:00:00 | ES | Futures | 2149.16 | 2158.74 | 2149.16 | 2154.75 | 69106.0 |
| 2015-08-21 04:00:00 | ES | Futures | 2154.75 | 2158.21 | 2153.95 | 2157.68 | 40199.0 |
| 2015-08-21 05:00:00 | ES | Futures | 2157.68 | 2160.6 | 2153.68 | 2155.01 | 44381.0 |
| 2015-08-21 06:00:00 | ES | Futures | 2155.01 | 2156.61 | 2149.69 | 2152.35 | 51762.0 |
| 2015-08-21 07:00:00 | ES | Futures | 2152.35 | 2155.55 | 2148.89 | 2151.55 | 51019.0 |
| 2015-08-21 08:00:00 | ES | Futures | 2151.55 | 2152.35 | 2146.49 | 2150.49 | 65490.0 |
| 2015-08-21 09:00:00 | ES | Futures | 2150.49 | 2151.55 | 2137.97 | 2146.23 | 516803.0 |
| 2015-08-21 10:00:00 | ES | Futures | 2146.23 | 2153.68 | 2132.38 | 2134.78 | 563689.0 |
| 2015-08-21 11:00:00 | ES | Futures | 2134.78 | 2135.58 | 2118.8 | 2129.45 | 600417.0 |
| 2015-08-21 12:00:00 | ES | Futures | 2129.45 | 2136.91 | 2117.74 | 2118.27 | 355033.0 |
| 2015-08-21 13:00:00 | ES | Futures | 2118.27 | 2129.99 | 2115.34 | 2129.72 | 369446.0 |
| 2015-08-21 14:00:00 | ES | Futures | 2129.72 | 2132.38 | 2110.28 | 2113.48 | 351187.0 |
| 2015-08-21 15:00:00 | ES | Futures | 2113.21 | 2115.61 | 2095.91 | 2095.91 | 662309.0 |
| 2015-08-21 16:00:00 | ES | Futures | 2096.17 | 2104.69 | 2095.91 | 2097.24 | 218088.0 |
| 2015-08-21 17:00:00 | ES | Futures | 2096.97 | 2097.5 | 2095.11 | 2096.17 | 7932.0 |
| 2015-08-21 00:00:00 | NQ | Futures | 5139.34 | 5139.34 | 5129.28 | 5131.95 | 1404.0 |
| 2015-08-21 01:00:00 | NQ | Futures | 5132.54 | 5136.68 | 5123.96 | 5132.24 | 1954.0 |
| 2015-08-21 02:00:00 | NQ | Futures | 5132.54 | 5144.96 | 5131.65 | 5142.59 | 2968.0 |
| 2015-08-21 03:00:00 | NQ | Futures | 5143.48 | 5162.71 | 5142.0 | 5157.38 | 8778.0 |
| 2015-08-21 04:00:00 | NQ | Futures | 5157.38 | 5161.82 | 5147.03 | 5155.31 | 4848.0 |
| 2015-08-21 05:00:00 | NQ | Futures | 5155.91 | 5163.6 | 5147.03 | 5150.58 | 6291.0 |
| 2015-08-21 06:00:00 | NQ | Futures | 5149.69 | 5154.43 | 5136.68 | 5144.07 | 6636.0 |
| 2015-08-21 07:00:00 | NQ | Futures | 5143.78 | 5150.88 | 5135.2 | 5143.48 | 7144.0 |
| 2015-08-21 08:00:00 | NQ | Futures | 5143.19 | 5146.44 | 5127.51 | 5135.2 | 9636.0 |
| 2015-08-21 09:00:00 | NQ | Futures | 5135.2 | 5142.59 | 5090.24 | 5137.27 | 97336.0 |
| 2015-08-21 10:00:00 | NQ | Futures | 5137.27 | 5157.98 | 5081.96 | 5092.61 | 81866.0 |
| 2015-08-21 11:00:00 | NQ | Futures | 5092.31 | 5094.68 | 5045.28 | 5074.86 | 79182.0 |
| 2015-08-21 12:00:00 | NQ | Futures | 5074.86 | 5094.38 | 5042.62 | 5043.21 | 43389.0 |
| 2015-08-21 13:00:00 | NQ | Futures | 5043.21 | 5071.9 | 5037.0 | 5070.72 | 45821.0 |
| 2015-08-21 14:00:00 | NQ | Futures | 5071.01 | 5079.89 | 5011.56 | 5023.69 | 48157.0 |
| 2015-08-21 15:00:00 | NQ | Futures | 5023.98 | 5029.01 | 4966.3 | 4966.6 | 103145.0 |
| 2015-08-21 16:00:00 | NQ | Futures | 4966.6 | 4982.57 | 4963.35 | 4963.64 | 30603.0 |
| 2015-08-21 17:00:00 | NQ | Futures | 4963.35 | 4963.35 | 4956.25 | 4959.5 | 1023.0 |
| 2015-08-21 00:00:00 | YM | Futures | 17737.1 | 17737.1 | 17708.7 | 17719.2 | 1188.0 |
| 2015-08-21 01:00:00 | YM | Futures | 17720.3 | 17732.9 | 17695.0 | 17713.9 | 2441.0 |
| 2015-08-21 02:00:00 | YM | Futures | 17715.0 | 17739.2 | 17708.7 | 17731.8 | 3624.0 |
| 2015-08-21 03:00:00 | YM | Futures | 17730.8 | 17802.4 | 17726.6 | 17778.2 | 9247.0 |
| 2015-08-21 04:00:00 | YM | Futures | 17777.1 | 17802.4 | 17769.8 | 17799.3 | 3866.0 |
| 2015-08-21 05:00:00 | YM | Futures | 17798.2 | 17821.4 | 17767.7 | 17780.3 | 4453.0 |
| 2015-08-21 06:00:00 | YM | Futures | 17778.2 | 17790.8 | 17731.8 | 17754.0 | 4856.0 |
| 2015-08-21 07:00:00 | YM | Futures | 17755.0 | 17778.2 | 17725.5 | 17745.5 | 5542.0 |
| 2015-08-21 08:00:00 | YM | Futures | 17745.5 | 17752.9 | 17699.2 | 17731.8 | 6932.0 |
| 2015-08-21 09:00:00 | YM | Futures | 17732.9 | 17741.3 | 17646.5 | 17713.9 | 48311.0 |
| 2015-08-21 10:00:00 | YM | Futures | 17712.9 | 17758.2 | 17614.9 | 17634.9 | 52376.0 |
| 2015-08-21 11:00:00 | YM | Futures | 17634.9 | 17639.1 | 17510.6 | 17591.7 | 52509.0 |
| 2015-08-21 12:00:00 | YM | Futures | 17591.7 | 17643.4 | 17489.5 | 17490.6 | 34121.0 |
| 2015-08-21 13:00:00 | YM | Futures | 17491.7 | 17571.7 | 17468.5 | 17567.5 | 37995.0 |
> showing 50 of 1,301 rows — these rows as CSV