PREVIEW / futures_1hour / 2008-09-12
file: by_date/futures_1hour/2008/2008-09-12.parquet size: 38 KB rows: 1,019
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-12 00:00:00 | ES | Futures | 1159.75 | 1160.68 | 1159.29 | 1160.68 | 672.0 |
| 2008-09-12 01:00:00 | ES | Futures | 1160.68 | 1162.08 | 1159.99 | 1161.38 | 1884.0 |
| 2008-09-12 02:00:00 | ES | Futures | 1161.38 | 1161.61 | 1159.99 | 1161.38 | 3298.0 |
| 2008-09-12 03:00:00 | ES | Futures | 1161.15 | 1161.38 | 1159.06 | 1160.91 | 10421.0 |
| 2008-09-12 04:00:00 | ES | Futures | 1160.91 | 1165.33 | 1160.22 | 1164.87 | 10812.0 |
| 2008-09-12 05:00:00 | ES | Futures | 1164.87 | 1165.33 | 1162.77 | 1163.47 | 6397.0 |
| 2008-09-12 06:00:00 | ES | Futures | 1163.47 | 1163.94 | 1158.82 | 1162.08 | 8531.0 |
| 2008-09-12 07:00:00 | ES | Futures | 1162.08 | 1162.54 | 1157.43 | 1158.13 | 14021.0 |
| 2008-09-12 08:00:00 | ES | Futures | 1158.13 | 1158.13 | 1152.78 | 1153.48 | 40735.0 |
| 2008-09-12 09:00:00 | ES | Futures | 1153.25 | 1154.17 | 1146.74 | 1149.53 | 95272.0 |
| 2008-09-12 10:00:00 | ES | Futures | 1149.53 | 1158.59 | 1148.13 | 1158.36 | 107675.0 |
| 2008-09-12 11:00:00 | ES | Futures | 1158.13 | 1166.96 | 1156.73 | 1161.15 | 102200.0 |
| 2008-09-12 12:00:00 | ES | Futures | 1160.91 | 1163.24 | 1153.71 | 1154.17 | 39526.0 |
| 2008-09-12 13:00:00 | ES | Futures | 1153.94 | 1161.61 | 1152.55 | 1161.61 | 59013.0 |
| 2008-09-12 14:00:00 | ES | Futures | 1161.61 | 1166.49 | 1155.57 | 1165.56 | 49255.0 |
| 2008-09-12 15:00:00 | ES | Futures | 1165.8 | 1166.73 | 1157.43 | 1164.63 | 75652.0 |
| 2008-09-12 16:00:00 | ES | Futures | 1164.63 | 1169.28 | 1164.17 | 1169.05 | 27386.0 |
| 2008-09-12 00:00:00 | NQ | Futures | 1992.37 | 1993.49 | 1991.24 | 1993.49 | 10.0 |
| 2008-09-12 01:00:00 | NQ | Futures | 1993.77 | 1996.03 | 1992.65 | 1995.74 | 83.0 |
| 2008-09-12 02:00:00 | NQ | Futures | 1994.9 | 1996.03 | 1992.93 | 1994.06 | 294.0 |
| 2008-09-12 03:00:00 | NQ | Futures | 1994.06 | 1994.06 | 1988.15 | 1989.56 | 1708.0 |
| 2008-09-12 04:00:00 | NQ | Futures | 1989.27 | 1999.4 | 1989.27 | 1998.28 | 505.0 |
| 2008-09-12 05:00:00 | NQ | Futures | 1997.99 | 1998.28 | 1994.34 | 1994.34 | 169.0 |
| 2008-09-12 06:00:00 | NQ | Futures | 1995.18 | 1996.31 | 1991.24 | 1996.03 | 305.0 |
| 2008-09-12 07:00:00 | NQ | Futures | 1996.03 | 1999.96 | 1990.96 | 1996.03 | 4072.0 |
| 2008-09-12 08:00:00 | NQ | Futures | 1995.46 | 1997.15 | 1981.68 | 1981.96 | 3045.0 |
| 2008-09-12 09:00:00 | NQ | Futures | 1981.96 | 1983.37 | 1962.83 | 1965.93 | 18406.0 |
| 2008-09-12 10:00:00 | NQ | Futures | 1966.21 | 1978.87 | 1961.99 | 1972.96 | 16565.0 |
| 2008-09-12 11:00:00 | NQ | Futures | 1972.68 | 1998.84 | 1969.02 | 1985.9 | 19493.0 |
| 2008-09-12 12:00:00 | NQ | Futures | 1986.18 | 1990.4 | 1969.58 | 1971.55 | 8235.0 |
| 2008-09-12 13:00:00 | NQ | Futures | 1971.27 | 1983.93 | 1967.33 | 1982.52 | 9986.0 |
| 2008-09-12 14:00:00 | NQ | Futures | 1983.09 | 1995.46 | 1972.96 | 1994.06 | 10291.0 |
| 2008-09-12 15:00:00 | NQ | Futures | 1994.34 | 1996.59 | 1980.84 | 1990.12 | 11910.0 |
| 2008-09-12 16:00:00 | NQ | Futures | 1989.84 | 1996.31 | 1987.31 | 1996.31 | 2930.0 |
| 2008-09-12 00:00:00 | YM | Futures | 10384.9 | 10394.9 | 10379.4 | 10393.1 | 89.0 |
| 2008-09-12 01:00:00 | YM | Futures | 10395.8 | 10408.5 | 10393.1 | 10404.0 | 92.0 |
| 2008-09-12 02:00:00 | YM | Futures | 10398.5 | 10405.8 | 10393.1 | 10405.8 | 149.0 |
| 2008-09-12 03:00:00 | YM | Futures | 10398.5 | 10404.0 | 10385.8 | 10398.5 | 510.0 |
| 2008-09-12 04:00:00 | YM | Futures | 10396.7 | 10446.7 | 10396.7 | 10442.2 | 1023.0 |
| 2008-09-12 05:00:00 | YM | Futures | 10442.2 | 10442.2 | 10418.5 | 10422.2 | 678.0 |
| 2008-09-12 06:00:00 | YM | Futures | 10421.3 | 10422.2 | 10384.9 | 10407.6 | 927.0 |
| 2008-09-12 07:00:00 | YM | Futures | 10408.5 | 10412.2 | 10369.4 | 10374.0 | 792.0 |
| 2008-09-12 08:00:00 | YM | Futures | 10373.1 | 10374.9 | 10321.2 | 10324.9 | 3709.0 |
| 2008-09-12 09:00:00 | YM | Futures | 10325.8 | 10333.0 | 10253.0 | 10274.8 | 24703.0 |
| 2008-09-12 10:00:00 | YM | Futures | 10274.8 | 10344.9 | 10259.4 | 10337.6 | 40304.0 |
| 2008-09-12 11:00:00 | YM | Futures | 10337.6 | 10422.2 | 10333.0 | 10372.2 | 32553.0 |
| 2008-09-12 12:00:00 | YM | Futures | 10373.1 | 10391.3 | 10298.5 | 10300.3 | 19306.0 |
| 2008-09-12 13:00:00 | YM | Futures | 10301.2 | 10362.1 | 10280.3 | 10362.1 | 31668.0 |
| 2008-09-12 14:00:00 | YM | Futures | 10362.1 | 10408.5 | 10301.2 | 10399.4 | 27615.0 |
| 2008-09-12 15:00:00 | YM | Futures | 10400.3 | 10407.6 | 10323.9 | 10402.2 | 29593.0 |
> showing 50 of 1,019 rows — these rows as CSV