PREVIEW / futures_1hour / 2015-02-11
file: by_date/futures_1hour/2015/2015-02-11.parquet size: 51 KB rows: 1,563
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-11 00:00:00 | ES | Futures | 2168.9 | 2168.9 | 2167.84 | 2168.63 | 2349.0 |
| 2015-02-11 01:00:00 | ES | Futures | 2168.9 | 2169.69 | 2168.37 | 2169.16 | 1377.0 |
| 2015-02-11 02:00:00 | ES | Futures | 2169.42 | 2169.69 | 2167.32 | 2168.37 | 5953.0 |
| 2015-02-11 03:00:00 | ES | Futures | 2168.37 | 2170.48 | 2167.32 | 2168.9 | 14328.0 |
| 2015-02-11 04:00:00 | ES | Futures | 2168.63 | 2169.95 | 2167.84 | 2169.42 | 7895.0 |
| 2015-02-11 05:00:00 | ES | Futures | 2169.69 | 2170.21 | 2168.63 | 2168.9 | 6063.0 |
| 2015-02-11 06:00:00 | ES | Futures | 2168.63 | 2169.69 | 2166.0 | 2168.37 | 11803.0 |
| 2015-02-11 07:00:00 | ES | Futures | 2168.11 | 2169.16 | 2166.53 | 2167.58 | 10048.0 |
| 2015-02-11 08:00:00 | ES | Futures | 2167.32 | 2169.95 | 2166.0 | 2167.06 | 26324.0 |
| 2015-02-11 09:00:00 | ES | Futures | 2167.32 | 2172.84 | 2167.06 | 2172.58 | 143037.0 |
| 2015-02-11 10:00:00 | ES | Futures | 2172.58 | 2173.37 | 2167.32 | 2170.48 | 161342.0 |
| 2015-02-11 11:00:00 | ES | Futures | 2170.21 | 2174.16 | 2169.69 | 2171.53 | 158972.0 |
| 2015-02-11 12:00:00 | ES | Futures | 2171.53 | 2173.11 | 2166.27 | 2167.32 | 99301.0 |
| 2015-02-11 13:00:00 | ES | Futures | 2167.58 | 2170.21 | 2161.27 | 2167.84 | 167127.0 |
| 2015-02-11 14:00:00 | ES | Futures | 2168.11 | 2172.58 | 2165.21 | 2170.48 | 132120.0 |
| 2015-02-11 15:00:00 | ES | Futures | 2170.48 | 2178.63 | 2169.42 | 2173.11 | 226850.0 |
| 2015-02-11 16:00:00 | ES | Futures | 2173.11 | 2188.9 | 2172.06 | 2183.37 | 101022.0 |
| 2015-02-11 17:00:00 | ES | Futures | 2183.37 | 2184.42 | 2182.06 | 2182.32 | 4151.0 |
| 2015-02-11 18:00:00 | ES | Futures | 2180.48 | 2181.79 | 2174.69 | 2174.95 | 19507.0 |
| 2015-02-11 19:00:00 | ES | Futures | 2174.95 | 2177.58 | 2173.9 | 2174.95 | 10700.0 |
| 2015-02-11 20:00:00 | ES | Futures | 2175.21 | 2175.21 | 2166.79 | 2168.11 | 17156.0 |
| 2015-02-11 21:00:00 | ES | Futures | 2168.11 | 2170.21 | 2167.06 | 2169.95 | 4795.0 |
| 2015-02-11 22:00:00 | ES | Futures | 2169.95 | 2172.84 | 2169.95 | 2171.0 | 4393.0 |
| 2015-02-11 23:00:00 | ES | Futures | 2170.74 | 2174.42 | 2170.21 | 2171.79 | 5077.0 |
| 2015-02-11 00:00:00 | NQ | Futures | 5022.95 | 5022.95 | 5021.19 | 5022.66 | 412.0 |
| 2015-02-11 01:00:00 | NQ | Futures | 5022.66 | 5025.01 | 5021.78 | 5024.13 | 260.0 |
| 2015-02-11 02:00:00 | NQ | Futures | 5024.13 | 5026.18 | 5020.02 | 5021.48 | 809.0 |
| 2015-02-11 03:00:00 | NQ | Futures | 5021.78 | 5026.77 | 5018.25 | 5022.07 | 2136.0 |
| 2015-02-11 04:00:00 | NQ | Futures | 5022.66 | 5025.6 | 5020.6 | 5023.54 | 1013.0 |
| 2015-02-11 05:00:00 | NQ | Futures | 5023.54 | 5025.89 | 5022.07 | 5022.07 | 1164.0 |
| 2015-02-11 06:00:00 | NQ | Futures | 5022.07 | 5024.42 | 5018.55 | 5022.37 | 1850.0 |
| 2015-02-11 07:00:00 | NQ | Futures | 5022.37 | 5023.83 | 5018.55 | 5020.31 | 1711.0 |
| 2015-02-11 08:00:00 | NQ | Futures | 5020.02 | 5027.06 | 5017.37 | 5023.83 | 5259.0 |
| 2015-02-11 09:00:00 | NQ | Futures | 5023.83 | 5044.1 | 5023.25 | 5043.8 | 28282.0 |
| 2015-02-11 10:00:00 | NQ | Futures | 5043.22 | 5049.38 | 5034.41 | 5046.15 | 29486.0 |
| 2015-02-11 11:00:00 | NQ | Futures | 5045.57 | 5051.73 | 5040.28 | 5048.8 | 19587.0 |
| 2015-02-11 12:00:00 | NQ | Futures | 5048.5 | 5049.09 | 5032.06 | 5034.7 | 13168.0 |
| 2015-02-11 13:00:00 | NQ | Futures | 5034.41 | 5040.28 | 5021.19 | 5035.87 | 25721.0 |
| 2015-02-11 14:00:00 | NQ | Futures | 5036.17 | 5047.33 | 5032.64 | 5042.63 | 22482.0 |
| 2015-02-11 15:00:00 | NQ | Futures | 5042.63 | 5054.96 | 5037.64 | 5043.51 | 36400.0 |
| 2015-02-11 16:00:00 | NQ | Futures | 5043.22 | 5077.29 | 5042.04 | 5065.54 | 14337.0 |
| 2015-02-11 17:00:00 | NQ | Futures | 5066.71 | 5069.36 | 5064.07 | 5065.24 | 619.0 |
| 2015-02-11 18:00:00 | NQ | Futures | 5061.43 | 5061.43 | 5047.62 | 5049.38 | 1972.0 |
| 2015-02-11 19:00:00 | NQ | Futures | 5049.68 | 5055.55 | 5047.04 | 5049.38 | 1513.0 |
| 2015-02-11 20:00:00 | NQ | Futures | 5049.68 | 5049.68 | 5034.7 | 5037.64 | 2856.0 |
| 2015-02-11 21:00:00 | NQ | Futures | 5038.22 | 5044.69 | 5035.29 | 5044.1 | 923.0 |
| 2015-02-11 22:00:00 | NQ | Futures | 5044.39 | 5049.68 | 5043.8 | 5045.86 | 817.0 |
| 2015-02-11 23:00:00 | NQ | Futures | 5046.15 | 5053.2 | 5044.98 | 5048.21 | 622.0 |
| 2015-02-11 00:00:00 | YM | Futures | 18564.3 | 18565.4 | 18556.0 | 18559.1 | 270.0 |
| 2015-02-11 01:00:00 | YM | Futures | 18563.3 | 18569.5 | 18558.1 | 18568.5 | 267.0 |
> showing 50 of 1,563 rows — these rows as CSV