PREVIEW / futures_1hour / 2016-02-05
file: by_date/futures_1hour/2016/2016-02-05.parquet size: 46 KB rows: 1,320
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-05 00:00:00 | ES | Futures | 2047.29 | 2050.52 | 2045.95 | 2048.1 | 4883.0 |
| 2016-02-05 01:00:00 | ES | Futures | 2048.1 | 2048.64 | 2044.88 | 2047.29 | 4798.0 |
| 2016-02-05 02:00:00 | ES | Futures | 2047.29 | 2049.18 | 2044.61 | 2048.1 | 9911.0 |
| 2016-02-05 03:00:00 | ES | Futures | 2048.37 | 2054.55 | 2043.53 | 2049.18 | 34585.0 |
| 2016-02-05 04:00:00 | ES | Futures | 2048.91 | 2057.77 | 2048.64 | 2055.89 | 23554.0 |
| 2016-02-05 05:00:00 | ES | Futures | 2055.89 | 2057.51 | 2052.94 | 2054.55 | 12651.0 |
| 2016-02-05 06:00:00 | ES | Futures | 2054.55 | 2055.62 | 2049.44 | 2051.59 | 14558.0 |
| 2016-02-05 07:00:00 | ES | Futures | 2051.59 | 2054.55 | 2050.52 | 2052.67 | 19577.0 |
| 2016-02-05 08:00:00 | ES | Futures | 2052.67 | 2053.47 | 2037.35 | 2041.11 | 185560.0 |
| 2016-02-05 09:00:00 | ES | Futures | 2041.11 | 2053.74 | 2032.52 | 2036.81 | 307010.0 |
| 2016-02-05 10:00:00 | ES | Futures | 2036.55 | 2042.19 | 2023.65 | 2024.72 | 385866.0 |
| 2016-02-05 11:00:00 | ES | Futures | 2024.72 | 2026.87 | 2014.24 | 2022.3 | 303541.0 |
| 2016-02-05 12:00:00 | ES | Futures | 2022.04 | 2027.14 | 2016.66 | 2020.15 | 163439.0 |
| 2016-02-05 13:00:00 | ES | Futures | 2020.15 | 2024.72 | 2012.63 | 2016.12 | 180728.0 |
| 2016-02-05 14:00:00 | ES | Futures | 2016.12 | 2018.0 | 2008.06 | 2010.48 | 188164.0 |
| 2016-02-05 15:00:00 | ES | Futures | 2010.21 | 2014.51 | 2005.38 | 2013.44 | 309397.0 |
| 2016-02-05 16:00:00 | ES | Futures | 2013.44 | 2017.47 | 2011.29 | 2013.97 | 109152.0 |
| 2016-02-05 00:00:00 | NQ | Futures | 4924.9 | 4935.3 | 4921.34 | 4929.06 | 790.0 |
| 2016-02-05 01:00:00 | NQ | Futures | 4928.47 | 4929.95 | 4921.64 | 4927.87 | 896.0 |
| 2016-02-05 02:00:00 | NQ | Futures | 4928.17 | 4932.33 | 4920.15 | 4930.54 | 1519.0 |
| 2016-02-05 03:00:00 | NQ | Futures | 4930.54 | 4948.06 | 4918.67 | 4932.92 | 6110.0 |
| 2016-02-05 04:00:00 | NQ | Futures | 4932.03 | 4956.67 | 4931.14 | 4951.63 | 3100.0 |
| 2016-02-05 05:00:00 | NQ | Futures | 4951.33 | 4956.97 | 4943.91 | 4947.77 | 2153.0 |
| 2016-02-05 06:00:00 | NQ | Futures | 4948.36 | 4951.03 | 4935.0 | 4941.53 | 2418.0 |
| 2016-02-05 07:00:00 | NQ | Futures | 4940.94 | 4948.66 | 4937.67 | 4942.72 | 2789.0 |
| 2016-02-05 08:00:00 | NQ | Futures | 4942.72 | 4944.8 | 4900.26 | 4911.84 | 30493.0 |
| 2016-02-05 09:00:00 | NQ | Futures | 4912.73 | 4945.09 | 4865.52 | 4871.75 | 57225.0 |
| 2016-02-05 10:00:00 | NQ | Futures | 4871.46 | 4885.41 | 4823.95 | 4826.32 | 80494.0 |
| 2016-02-05 11:00:00 | NQ | Futures | 4826.92 | 4831.96 | 4785.35 | 4810.58 | 63915.0 |
| 2016-02-05 12:00:00 | NQ | Futures | 4810.29 | 4820.68 | 4792.47 | 4803.16 | 39072.0 |
| 2016-02-05 13:00:00 | NQ | Futures | 4802.86 | 4808.8 | 4769.61 | 4779.11 | 38323.0 |
| 2016-02-05 14:00:00 | NQ | Futures | 4779.11 | 4785.05 | 4755.36 | 4767.23 | 37087.0 |
| 2016-02-05 15:00:00 | NQ | Futures | 4767.83 | 4781.49 | 4752.09 | 4771.09 | 51395.0 |
| 2016-02-05 16:00:00 | NQ | Futures | 4771.09 | 4783.27 | 4769.31 | 4774.36 | 12842.0 |
| 2016-02-05 00:00:00 | YM | Futures | 17359.5 | 17387.2 | 17349.9 | 17367.0 | 875.0 |
| 2016-02-05 01:00:00 | YM | Futures | 17367.0 | 17370.2 | 17341.4 | 17360.6 | 951.0 |
| 2016-02-05 02:00:00 | YM | Futures | 17360.6 | 17372.3 | 17338.2 | 17361.6 | 1130.0 |
| 2016-02-05 03:00:00 | YM | Futures | 17362.7 | 17420.2 | 17331.8 | 17374.4 | 7616.0 |
| 2016-02-05 04:00:00 | YM | Futures | 17373.4 | 17439.3 | 17370.2 | 17423.4 | 3998.0 |
| 2016-02-05 05:00:00 | YM | Futures | 17423.4 | 17439.3 | 17406.3 | 17413.8 | 2276.0 |
| 2016-02-05 06:00:00 | YM | Futures | 17415.9 | 17425.5 | 17377.6 | 17396.8 | 2188.0 |
| 2016-02-05 07:00:00 | YM | Futures | 17394.6 | 17420.2 | 17386.1 | 17404.2 | 2509.0 |
| 2016-02-05 08:00:00 | YM | Futures | 17403.2 | 17411.7 | 17289.3 | 17320.1 | 23161.0 |
| 2016-02-05 09:00:00 | YM | Futures | 17321.2 | 17414.9 | 17280.7 | 17302.0 | 32093.0 |
| 2016-02-05 10:00:00 | YM | Futures | 17302.0 | 17345.7 | 17189.2 | 17196.6 | 43913.0 |
| 2016-02-05 11:00:00 | YM | Futures | 17196.6 | 17217.9 | 17133.8 | 17209.4 | 33561.0 |
| 2016-02-05 12:00:00 | YM | Futures | 17209.4 | 17253.1 | 17169.0 | 17188.1 | 20162.0 |
| 2016-02-05 13:00:00 | YM | Futures | 17188.1 | 17221.1 | 17127.5 | 17153.0 | 20624.0 |
| 2016-02-05 14:00:00 | YM | Futures | 17153.0 | 17166.8 | 17096.6 | 17115.7 | 19451.0 |
| 2016-02-05 15:00:00 | YM | Futures | 17116.8 | 17161.5 | 17081.7 | 17158.3 | 25596.0 |
> showing 50 of 1,320 rows — these rows as CSV