PREVIEW / futures_1hour / 2016-02-10
file: by_date/futures_1hour/2016/2016-02-10.parquet size: 55 KB rows: 1,609
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-10 00:00:00 | ES | Futures | 1978.77 | 1981.73 | 1977.16 | 1977.97 | 9637.0 |
| 2016-02-10 01:00:00 | ES | Futures | 1978.24 | 1982.27 | 1977.7 | 1981.46 | 8395.0 |
| 2016-02-10 02:00:00 | ES | Futures | 1981.19 | 1992.75 | 1981.19 | 1989.79 | 27759.0 |
| 2016-02-10 03:00:00 | ES | Futures | 1989.79 | 2002.15 | 1983.34 | 2000.81 | 57954.0 |
| 2016-02-10 04:00:00 | ES | Futures | 2000.81 | 2006.18 | 1998.39 | 2004.57 | 39271.0 |
| 2016-02-10 05:00:00 | ES | Futures | 2004.57 | 2010.48 | 2004.03 | 2007.53 | 40751.0 |
| 2016-02-10 06:00:00 | ES | Futures | 2007.53 | 2009.94 | 2004.03 | 2006.45 | 28086.0 |
| 2016-02-10 07:00:00 | ES | Futures | 2006.45 | 2012.09 | 2004.84 | 2010.21 | 27700.0 |
| 2016-02-10 08:00:00 | ES | Futures | 2010.21 | 2011.02 | 1998.12 | 2004.03 | 121901.0 |
| 2016-02-10 09:00:00 | ES | Futures | 2004.03 | 2005.91 | 1993.82 | 2004.57 | 297200.0 |
| 2016-02-10 10:00:00 | ES | Futures | 2004.84 | 2018.27 | 1998.66 | 2001.08 | 386068.0 |
| 2016-02-10 11:00:00 | ES | Futures | 2001.08 | 2005.64 | 1991.4 | 2000.27 | 326361.0 |
| 2016-02-10 12:00:00 | ES | Futures | 2000.27 | 2010.75 | 1995.7 | 2009.67 | 183325.0 |
| 2016-02-10 13:00:00 | ES | Futures | 2009.94 | 2011.56 | 1999.73 | 2001.34 | 133666.0 |
| 2016-02-10 14:00:00 | ES | Futures | 2001.34 | 2006.99 | 1995.16 | 1997.05 | 160528.0 |
| 2016-02-10 15:00:00 | ES | Futures | 1997.31 | 2004.84 | 1983.34 | 1985.22 | 338239.0 |
| 2016-02-10 16:00:00 | ES | Futures | 1985.49 | 1986.83 | 1979.85 | 1980.12 | 82481.0 |
| 2016-02-10 18:00:00 | ES | Futures | 1980.12 | 1985.49 | 1976.09 | 1976.62 | 15174.0 |
| 2016-02-10 19:00:00 | ES | Futures | 1976.35 | 1980.65 | 1969.91 | 1970.98 | 23195.0 |
| 2016-02-10 20:00:00 | ES | Futures | 1970.98 | 1975.01 | 1968.83 | 1973.94 | 17223.0 |
| 2016-02-10 21:00:00 | ES | Futures | 1973.67 | 1979.58 | 1972.86 | 1977.7 | 11720.0 |
| 2016-02-10 22:00:00 | ES | Futures | 1977.7 | 1978.77 | 1972.59 | 1973.4 | 8215.0 |
| 2016-02-10 23:00:00 | ES | Futures | 1973.4 | 1975.55 | 1971.52 | 1974.74 | 6600.0 |
| 2016-02-10 00:00:00 | NQ | Futures | 4667.17 | 4675.18 | 4664.2 | 4665.98 | 1078.0 |
| 2016-02-10 01:00:00 | NQ | Futures | 4665.39 | 4676.97 | 4665.39 | 4675.18 | 612.0 |
| 2016-02-10 02:00:00 | NQ | Futures | 4674.59 | 4708.44 | 4674.59 | 4698.05 | 3306.0 |
| 2016-02-10 03:00:00 | NQ | Futures | 4698.94 | 4729.82 | 4681.72 | 4725.37 | 8902.0 |
| 2016-02-10 04:00:00 | NQ | Futures | 4725.37 | 4747.93 | 4721.8 | 4744.37 | 8927.0 |
| 2016-02-10 05:00:00 | NQ | Futures | 4744.96 | 4762.78 | 4741.7 | 4752.09 | 7594.0 |
| 2016-02-10 06:00:00 | NQ | Futures | 4752.09 | 4758.92 | 4745.26 | 4749.12 | 5043.0 |
| 2016-02-10 07:00:00 | NQ | Futures | 4749.42 | 4762.48 | 4742.88 | 4761.59 | 6125.0 |
| 2016-02-10 08:00:00 | NQ | Futures | 4761.59 | 4767.53 | 4740.81 | 4748.23 | 23491.0 |
| 2016-02-10 09:00:00 | NQ | Futures | 4748.53 | 4765.45 | 4717.94 | 4763.08 | 60749.0 |
| 2016-02-10 10:00:00 | NQ | Futures | 4762.78 | 4799.6 | 4743.18 | 4747.04 | 75911.0 |
| 2016-02-10 11:00:00 | NQ | Futures | 4747.64 | 4766.04 | 4725.07 | 4747.34 | 51567.0 |
| 2016-02-10 12:00:00 | NQ | Futures | 4747.64 | 4780.0 | 4737.24 | 4777.63 | 28402.0 |
| 2016-02-10 13:00:00 | NQ | Futures | 4777.92 | 4786.24 | 4749.42 | 4756.54 | 22677.0 |
| 2016-02-10 14:00:00 | NQ | Futures | 4756.25 | 4773.47 | 4731.3 | 4737.54 | 28739.0 |
| 2016-02-10 15:00:00 | NQ | Futures | 4737.84 | 4761.89 | 4698.34 | 4702.5 | 61740.0 |
| 2016-02-10 16:00:00 | NQ | Futures | 4702.5 | 4716.16 | 4693.59 | 4706.96 | 14754.0 |
| 2016-02-10 18:00:00 | NQ | Futures | 4706.96 | 4717.35 | 4693.3 | 4694.19 | 2209.0 |
| 2016-02-10 19:00:00 | NQ | Futures | 4695.38 | 4705.17 | 4678.75 | 4681.12 | 3596.0 |
| 2016-02-10 20:00:00 | NQ | Futures | 4682.01 | 4692.11 | 4674.0 | 4688.84 | 2180.0 |
| 2016-02-10 21:00:00 | NQ | Futures | 4688.84 | 4702.2 | 4686.17 | 4697.45 | 1557.0 |
| 2016-02-10 22:00:00 | NQ | Futures | 4696.86 | 4700.42 | 4685.28 | 4686.76 | 1849.0 |
| 2016-02-10 23:00:00 | NQ | Futures | 4686.76 | 4691.52 | 4681.72 | 4688.55 | 885.0 |
| 2016-02-10 00:00:00 | YM | Futures | 16912.4 | 16932.7 | 16900.7 | 16908.2 | 1520.0 |
| 2016-02-10 01:00:00 | YM | Futures | 16908.2 | 16935.8 | 16902.9 | 16928.4 | 1627.0 |
| 2016-02-10 02:00:00 | YM | Futures | 16928.4 | 17025.3 | 16928.4 | 17000.8 | 3960.0 |
| 2016-02-10 03:00:00 | YM | Futures | 16999.7 | 17094.5 | 16952.9 | 17084.9 | 10542.0 |
> showing 50 of 1,609 rows — these rows as CSV