PREVIEW / futures_1hour / 2016-02-08
file: by_date/futures_1hour/2016/2016-02-08.parquet size: 56 KB rows: 1,612
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-08 00:00:00 | ES | Futures | 2023.11 | 2025.26 | 2021.5 | 2022.57 | 7145.0 |
| 2016-02-08 01:00:00 | ES | Futures | 2022.84 | 2024.99 | 2021.77 | 2023.92 | 3401.0 |
| 2016-02-08 02:00:00 | ES | Futures | 2024.19 | 2025.53 | 2020.69 | 2021.5 | 15128.0 |
| 2016-02-08 03:00:00 | ES | Futures | 2021.77 | 2024.45 | 2014.24 | 2017.2 | 36665.0 |
| 2016-02-08 04:00:00 | ES | Futures | 2016.93 | 2016.93 | 1983.34 | 1987.1 | 88277.0 |
| 2016-02-08 05:00:00 | ES | Futures | 1987.1 | 1994.9 | 1984.15 | 1989.25 | 48300.0 |
| 2016-02-08 06:00:00 | ES | Futures | 1989.52 | 1995.7 | 1986.3 | 1993.01 | 27876.0 |
| 2016-02-08 07:00:00 | ES | Futures | 1993.01 | 1993.55 | 1983.34 | 1984.42 | 56592.0 |
| 2016-02-08 08:00:00 | ES | Futures | 1984.42 | 1993.82 | 1981.73 | 1993.01 | 70539.0 |
| 2016-02-08 09:00:00 | ES | Futures | 1993.01 | 1994.36 | 1973.67 | 1977.16 | 383066.0 |
| 2016-02-08 10:00:00 | ES | Futures | 1977.16 | 1982.8 | 1970.44 | 1973.67 | 389224.0 |
| 2016-02-08 11:00:00 | ES | Futures | 1973.67 | 1976.35 | 1963.46 | 1973.4 | 322768.0 |
| 2016-02-08 12:00:00 | ES | Futures | 1973.4 | 1980.39 | 1972.32 | 1974.47 | 186841.0 |
| 2016-02-08 13:00:00 | ES | Futures | 1974.74 | 1975.01 | 1960.77 | 1960.77 | 164769.0 |
| 2016-02-08 14:00:00 | ES | Futures | 1960.77 | 1968.02 | 1958.08 | 1963.99 | 228227.0 |
| 2016-02-08 15:00:00 | ES | Futures | 1963.99 | 1993.82 | 1963.19 | 1985.76 | 486669.0 |
| 2016-02-08 16:00:00 | ES | Futures | 1985.76 | 1992.48 | 1985.22 | 1989.52 | 99033.0 |
| 2016-02-08 18:00:00 | ES | Futures | 1988.18 | 1988.72 | 1980.92 | 1983.88 | 15477.0 |
| 2016-02-08 19:00:00 | ES | Futures | 1984.15 | 1985.76 | 1980.92 | 1981.46 | 10341.0 |
| 2016-02-08 20:00:00 | ES | Futures | 1981.46 | 1982.27 | 1975.55 | 1976.89 | 18470.0 |
| 2016-02-08 21:00:00 | ES | Futures | 1976.89 | 1978.5 | 1972.32 | 1974.74 | 17697.0 |
| 2016-02-08 22:00:00 | ES | Futures | 1975.01 | 1976.62 | 1972.32 | 1975.82 | 13563.0 |
| 2016-02-08 23:00:00 | ES | Futures | 1975.55 | 1975.82 | 1969.1 | 1972.06 | 11669.0 |
| 2016-02-08 00:00:00 | NQ | Futures | 4799.3 | 4804.35 | 4796.04 | 4799.3 | 1525.0 |
| 2016-02-08 01:00:00 | NQ | Futures | 4799.0 | 4804.35 | 4796.93 | 4802.57 | 875.0 |
| 2016-02-08 02:00:00 | NQ | Futures | 4802.57 | 4805.54 | 4792.17 | 4794.85 | 2674.0 |
| 2016-02-08 03:00:00 | NQ | Futures | 4794.85 | 4803.16 | 4771.98 | 4781.49 | 5933.0 |
| 2016-02-08 04:00:00 | NQ | Futures | 4780.89 | 4780.89 | 4691.22 | 4696.27 | 16172.0 |
| 2016-02-08 05:00:00 | NQ | Futures | 4695.97 | 4713.49 | 4678.45 | 4693.59 | 13241.0 |
| 2016-02-08 06:00:00 | NQ | Futures | 4694.19 | 4705.47 | 4683.79 | 4690.03 | 7596.0 |
| 2016-02-08 07:00:00 | NQ | Futures | 4690.33 | 4691.22 | 4657.67 | 4666.57 | 13401.0 |
| 2016-02-08 08:00:00 | NQ | Futures | 4665.98 | 4691.22 | 4659.45 | 4688.55 | 11548.0 |
| 2016-02-08 09:00:00 | NQ | Futures | 4688.55 | 4695.67 | 4658.56 | 4679.34 | 78527.0 |
| 2016-02-08 10:00:00 | NQ | Futures | 4679.34 | 4695.97 | 4649.35 | 4657.07 | 93571.0 |
| 2016-02-08 11:00:00 | NQ | Futures | 4657.37 | 4665.98 | 4626.49 | 4663.01 | 58386.0 |
| 2016-02-08 12:00:00 | NQ | Futures | 4663.31 | 4683.79 | 4654.1 | 4658.85 | 39522.0 |
| 2016-02-08 13:00:00 | NQ | Futures | 4659.15 | 4661.23 | 4622.63 | 4625.0 | 30262.0 |
| 2016-02-08 14:00:00 | NQ | Futures | 4624.71 | 4641.63 | 4611.94 | 4623.22 | 40769.0 |
| 2016-02-08 15:00:00 | NQ | Futures | 4623.52 | 4720.32 | 4620.55 | 4699.53 | 98502.0 |
| 2016-02-08 16:00:00 | NQ | Futures | 4699.53 | 4714.38 | 4698.64 | 4705.17 | 12596.0 |
| 2016-02-08 18:00:00 | NQ | Futures | 4701.61 | 4703.1 | 4688.55 | 4694.19 | 2080.0 |
| 2016-02-08 19:00:00 | NQ | Futures | 4694.78 | 4697.16 | 4685.28 | 4686.47 | 1438.0 |
| 2016-02-08 20:00:00 | NQ | Futures | 4687.36 | 4687.95 | 4673.11 | 4675.18 | 2532.0 |
| 2016-02-08 21:00:00 | NQ | Futures | 4675.48 | 4677.26 | 4660.34 | 4665.68 | 2838.0 |
| 2016-02-08 22:00:00 | NQ | Futures | 4665.09 | 4674.29 | 4658.56 | 4671.92 | 2158.0 |
| 2016-02-08 23:00:00 | NQ | Futures | 4671.62 | 4672.81 | 4655.88 | 4662.71 | 1964.0 |
| 2016-02-08 00:00:00 | YM | Futures | 17225.4 | 17241.4 | 17211.5 | 17217.9 | 1425.0 |
| 2016-02-08 01:00:00 | YM | Futures | 17223.3 | 17239.2 | 17212.6 | 17232.8 | 636.0 |
| 2016-02-08 02:00:00 | YM | Futures | 17237.1 | 17241.4 | 17209.4 | 17217.9 | 1708.0 |
| 2016-02-08 03:00:00 | YM | Futures | 17217.9 | 17238.2 | 17158.3 | 17175.4 | 5890.0 |
> showing 50 of 1,612 rows — these rows as CSV