PREVIEW / futures_1hour / 2015-08-25
file: by_date/futures_1hour/2015/2015-08-25.parquet size: 55 KB rows: 1,572
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-25 00:00:00 | ES | Futures | 2039.99 | 2044.52 | 2033.34 | 2043.19 | 13944.0 |
| 2015-08-25 01:00:00 | ES | Futures | 2042.92 | 2045.32 | 2008.04 | 2016.03 | 26819.0 |
| 2015-08-25 02:00:00 | ES | Futures | 2016.03 | 2035.2 | 2010.17 | 2022.95 | 45825.0 |
| 2015-08-25 03:00:00 | ES | Futures | 2022.95 | 2053.31 | 2022.95 | 2050.64 | 66907.0 |
| 2015-08-25 04:00:00 | ES | Futures | 2051.18 | 2062.63 | 2047.18 | 2053.04 | 63490.0 |
| 2015-08-25 05:00:00 | ES | Futures | 2053.04 | 2062.09 | 2047.98 | 2056.5 | 41035.0 |
| 2015-08-25 06:00:00 | ES | Futures | 2056.77 | 2075.14 | 2046.12 | 2058.63 | 119859.0 |
| 2015-08-25 07:00:00 | ES | Futures | 2058.9 | 2074.07 | 2054.9 | 2069.55 | 78756.0 |
| 2015-08-25 08:00:00 | ES | Futures | 2069.81 | 2070.08 | 2056.24 | 2057.3 | 91321.0 |
| 2015-08-25 09:00:00 | ES | Futures | 2057.3 | 2074.07 | 2051.44 | 2056.24 | 486811.0 |
| 2015-08-25 10:00:00 | ES | Futures | 2055.97 | 2063.96 | 2046.92 | 2053.31 | 420326.0 |
| 2015-08-25 11:00:00 | ES | Futures | 2053.31 | 2071.15 | 2053.31 | 2057.57 | 316863.0 |
| 2015-08-25 12:00:00 | ES | Futures | 2057.3 | 2062.36 | 2052.77 | 2053.84 | 205085.0 |
| 2015-08-25 13:00:00 | ES | Futures | 2053.84 | 2056.77 | 2034.14 | 2042.39 | 286171.0 |
| 2015-08-25 14:00:00 | ES | Futures | 2042.39 | 2051.71 | 2035.73 | 2047.45 | 259299.0 |
| 2015-08-25 15:00:00 | ES | Futures | 2047.45 | 2050.11 | 1983.82 | 1985.95 | 760714.0 |
| 2015-08-25 16:00:00 | ES | Futures | 1985.95 | 1996.33 | 1980.89 | 1991.0 | 198762.0 |
| 2015-08-25 17:00:00 | ES | Futures | 1991.0 | 1996.06 | 1990.47 | 1995.8 | 6130.0 |
| 2015-08-25 18:00:00 | ES | Futures | 1997.93 | 2001.39 | 1977.16 | 1987.28 | 27105.0 |
| 2015-08-25 19:00:00 | ES | Futures | 1987.28 | 1990.21 | 1970.77 | 1971.04 | 27764.0 |
| 2015-08-25 20:00:00 | ES | Futures | 1971.04 | 1997.66 | 1971.04 | 1989.41 | 40588.0 |
| 2015-08-25 21:00:00 | ES | Futures | 1989.14 | 1999.79 | 1981.69 | 1995.26 | 33313.0 |
| 2015-08-25 22:00:00 | ES | Futures | 1995.26 | 1997.93 | 1982.48 | 1990.74 | 23008.0 |
| 2015-08-25 23:00:00 | ES | Futures | 1991.0 | 2004.05 | 1989.14 | 2003.52 | 16645.0 |
| 2015-08-25 00:00:00 | NQ | Futures | 4837.34 | 4844.44 | 4813.38 | 4841.78 | 1929.0 |
| 2015-08-25 01:00:00 | NQ | Futures | 4842.37 | 4849.47 | 4751.56 | 4773.45 | 4066.0 |
| 2015-08-25 02:00:00 | NQ | Futures | 4773.75 | 4819.0 | 4759.25 | 4796.52 | 5550.0 |
| 2015-08-25 03:00:00 | NQ | Futures | 4795.63 | 4887.33 | 4795.34 | 4881.71 | 8911.0 |
| 2015-08-25 04:00:00 | NQ | Futures | 4881.71 | 4916.02 | 4876.98 | 4890.88 | 10542.0 |
| 2015-08-25 05:00:00 | NQ | Futures | 4890.58 | 4913.95 | 4877.57 | 4900.93 | 6503.0 |
| 2015-08-25 06:00:00 | NQ | Futures | 4901.82 | 4964.83 | 4881.41 | 4929.03 | 18781.0 |
| 2015-08-25 07:00:00 | NQ | Futures | 4929.03 | 4954.18 | 4915.43 | 4945.89 | 14572.0 |
| 2015-08-25 08:00:00 | NQ | Futures | 4946.19 | 4946.19 | 4903.6 | 4905.08 | 18136.0 |
| 2015-08-25 09:00:00 | NQ | Futures | 4904.78 | 4950.04 | 4891.77 | 4918.09 | 87906.0 |
| 2015-08-25 10:00:00 | NQ | Futures | 4917.79 | 4948.26 | 4903.6 | 4928.74 | 76408.0 |
| 2015-08-25 11:00:00 | NQ | Futures | 4928.15 | 4974.29 | 4928.15 | 4947.97 | 53874.0 |
| 2015-08-25 12:00:00 | NQ | Futures | 4947.67 | 4957.43 | 4934.65 | 4936.73 | 36502.0 |
| 2015-08-25 13:00:00 | NQ | Futures | 4936.73 | 4943.23 | 4870.47 | 4900.05 | 60402.0 |
| 2015-08-25 14:00:00 | NQ | Futures | 4899.75 | 4922.82 | 4874.02 | 4910.99 | 50989.0 |
| 2015-08-25 15:00:00 | NQ | Futures | 4911.29 | 4918.98 | 4745.35 | 4748.6 | 110563.0 |
| 2015-08-25 16:00:00 | NQ | Futures | 4748.31 | 4771.67 | 4740.62 | 4753.34 | 22510.0 |
| 2015-08-25 17:00:00 | NQ | Futures | 4754.81 | 4765.46 | 4753.34 | 4763.39 | 347.0 |
| 2015-08-25 18:00:00 | NQ | Futures | 4776.11 | 4777.59 | 4709.26 | 4736.18 | 4387.0 |
| 2015-08-25 19:00:00 | NQ | Futures | 4736.18 | 4742.1 | 4683.83 | 4685.3 | 4039.0 |
| 2015-08-25 20:00:00 | NQ | Futures | 4686.78 | 4755.7 | 4686.49 | 4734.41 | 6150.0 |
| 2015-08-25 21:00:00 | NQ | Futures | 4734.11 | 4764.58 | 4712.22 | 4754.52 | 6002.0 |
| 2015-08-25 22:00:00 | NQ | Futures | 4754.52 | 4762.8 | 4723.76 | 4746.24 | 3486.0 |
| 2015-08-25 23:00:00 | NQ | Futures | 4746.83 | 4776.7 | 4743.28 | 4774.63 | 2761.0 |
| 2015-08-25 00:00:00 | YM | Futures | 16940.7 | 16978.6 | 16887.0 | 16957.5 | 1006.0 |
| 2015-08-25 01:00:00 | YM | Futures | 16957.5 | 16974.4 | 16681.5 | 16741.6 | 3091.0 |
> showing 50 of 1,572 rows — these rows as CSV