PREVIEW / futures_1hour / 2008-09-08
file: by_date/futures_1hour/2008/2008-09-08.parquet size: 44 KB rows: 1,207
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-08 00:00:00 | ES | Futures | 1187.64 | 1188.8 | 1187.41 | 1188.11 | 2626.0 |
| 2008-09-08 01:00:00 | ES | Futures | 1188.11 | 1189.04 | 1185.32 | 1185.78 | 8841.0 |
| 2008-09-08 02:00:00 | ES | Futures | 1185.55 | 1187.18 | 1183.69 | 1183.92 | 25250.0 |
| 2008-09-08 03:00:00 | ES | Futures | 1183.92 | 1186.25 | 1180.9 | 1186.25 | 44697.0 |
| 2008-09-08 04:00:00 | ES | Futures | 1186.25 | 1190.9 | 1185.55 | 1185.78 | 40837.0 |
| 2008-09-08 05:00:00 | ES | Futures | 1185.78 | 1188.11 | 1185.32 | 1185.55 | 15239.0 |
| 2008-09-08 06:00:00 | ES | Futures | 1185.55 | 1189.73 | 1185.55 | 1188.57 | 18792.0 |
| 2008-09-08 07:00:00 | ES | Futures | 1188.8 | 1189.04 | 1182.53 | 1186.02 | 39596.0 |
| 2008-09-08 08:00:00 | ES | Futures | 1185.78 | 1191.83 | 1185.55 | 1187.87 | 74531.0 |
| 2008-09-08 09:00:00 | ES | Futures | 1187.87 | 1189.04 | 1175.56 | 1175.79 | 419827.0 |
| 2008-09-08 10:00:00 | ES | Futures | 1175.79 | 1182.53 | 1170.68 | 1170.91 | 523555.0 |
| 2008-09-08 11:00:00 | ES | Futures | 1170.68 | 1176.02 | 1162.08 | 1166.03 | 540395.0 |
| 2008-09-08 12:00:00 | ES | Futures | 1166.03 | 1171.37 | 1159.06 | 1169.98 | 295157.0 |
| 2008-09-08 13:00:00 | ES | Futures | 1170.21 | 1171.14 | 1160.22 | 1161.38 | 187780.0 |
| 2008-09-08 14:00:00 | ES | Futures | 1161.15 | 1171.84 | 1159.99 | 1167.65 | 241753.0 |
| 2008-09-08 15:00:00 | ES | Futures | 1167.89 | 1179.51 | 1163.7 | 1179.51 | 396355.0 |
| 2008-09-08 16:00:00 | ES | Futures | 1179.28 | 1181.13 | 1176.72 | 1176.72 | 127228.0 |
| 2008-09-08 17:00:00 | ES | Futures | 1177.18 | 1177.65 | 1176.95 | 1177.18 | 1104.0 |
| 2008-09-08 18:00:00 | ES | Futures | 1176.72 | 1178.35 | 1176.25 | 1177.65 | 2316.0 |
| 2008-09-08 19:00:00 | ES | Futures | 1177.65 | 1178.35 | 1176.72 | 1176.72 | 1612.0 |
| 2008-09-08 20:00:00 | ES | Futures | 1176.72 | 1176.95 | 1175.32 | 1175.56 | 2800.0 |
| 2008-09-08 21:00:00 | ES | Futures | 1175.56 | 1175.79 | 1174.63 | 1174.63 | 3289.0 |
| 2008-09-08 22:00:00 | ES | Futures | 1174.86 | 1175.56 | 1174.39 | 1174.63 | 1849.0 |
| 2008-09-08 23:00:00 | ES | Futures | 1174.63 | 1174.63 | 1173.47 | 1174.39 | 2110.0 |
| 2008-09-08 00:00:00 | NQ | Futures | 2040.47 | 2041.59 | 2038.22 | 2038.22 | 577.0 |
| 2008-09-08 01:00:00 | NQ | Futures | 2039.06 | 2041.03 | 2034.28 | 2035.97 | 1178.0 |
| 2008-09-08 02:00:00 | NQ | Futures | 2035.12 | 2037.66 | 2031.19 | 2032.31 | 1211.0 |
| 2008-09-08 03:00:00 | NQ | Futures | 2032.03 | 2035.41 | 2026.97 | 2035.41 | 3408.0 |
| 2008-09-08 04:00:00 | NQ | Futures | 2035.69 | 2042.44 | 2031.19 | 2031.47 | 2962.0 |
| 2008-09-08 05:00:00 | NQ | Futures | 2031.75 | 2036.25 | 2031.19 | 2031.19 | 926.0 |
| 2008-09-08 06:00:00 | NQ | Futures | 2031.19 | 2037.37 | 2031.19 | 2035.97 | 948.0 |
| 2008-09-08 07:00:00 | NQ | Futures | 2035.69 | 2036.25 | 2026.4 | 2032.31 | 3844.0 |
| 2008-09-08 08:00:00 | NQ | Futures | 2032.03 | 2037.66 | 2028.09 | 2028.37 | 10791.0 |
| 2008-09-08 09:00:00 | NQ | Futures | 2028.37 | 2028.65 | 1991.52 | 1992.09 | 113087.0 |
| 2008-09-08 10:00:00 | NQ | Futures | 1991.81 | 2007.84 | 1981.12 | 1981.4 | 93336.0 |
| 2008-09-08 11:00:00 | NQ | Futures | 1981.68 | 1989.56 | 1961.71 | 1966.21 | 92232.0 |
| 2008-09-08 12:00:00 | NQ | Futures | 1966.49 | 1980.27 | 1952.43 | 1976.9 | 59873.0 |
| 2008-09-08 13:00:00 | NQ | Futures | 1977.46 | 1978.3 | 1956.93 | 1958.33 | 42282.0 |
| 2008-09-08 14:00:00 | NQ | Futures | 1958.05 | 1980.84 | 1955.8 | 1973.52 | 48660.0 |
| 2008-09-08 15:00:00 | NQ | Futures | 1973.24 | 1990.96 | 1964.52 | 1984.77 | 68705.0 |
| 2008-09-08 16:00:00 | NQ | Futures | 1984.49 | 1985.05 | 1979.15 | 1979.43 | 14194.0 |
| 2008-09-08 17:00:00 | NQ | Futures | 1979.43 | 1981.68 | 1979.43 | 1980.84 | 309.0 |
| 2008-09-08 18:00:00 | NQ | Futures | 1980.84 | 1982.52 | 1979.43 | 1981.68 | 143.0 |
| 2008-09-08 19:00:00 | NQ | Futures | 1981.4 | 1983.09 | 1981.12 | 1982.24 | 135.0 |
| 2008-09-08 20:00:00 | NQ | Futures | 1980.84 | 1980.84 | 1974.65 | 1975.49 | 556.0 |
| 2008-09-08 21:00:00 | NQ | Futures | 1975.49 | 1975.49 | 1973.8 | 1974.08 | 178.0 |
| 2008-09-08 22:00:00 | NQ | Futures | 1973.8 | 1974.93 | 1972.96 | 1972.96 | 158.0 |
| 2008-09-08 23:00:00 | NQ | Futures | 1973.8 | 1973.8 | 1971.27 | 1972.68 | 197.0 |
| 2008-09-08 00:00:00 | YM | Futures | 10450.2 | 10460.2 | 10448.4 | 10456.6 | 310.0 |
| 2008-09-08 01:00:00 | YM | Futures | 10455.7 | 10470.2 | 10435.7 | 10439.3 | 471.0 |
> showing 50 of 1,207 rows — these rows as CSV