PREVIEW / futures_1hour / 2008-09-15
file: by_date/futures_1hour/2008/2008-09-15.parquet size: 46 KB rows: 1,260
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-15 00:00:00 | ES | Futures | 1147.99 | 1156.51 | 1147.28 | 1147.28 | 15034.0 |
| 2008-09-15 01:00:00 | ES | Futures | 1147.51 | 1153.67 | 1147.28 | 1150.35 | 5126.0 |
| 2008-09-15 02:00:00 | ES | Futures | 1150.35 | 1154.61 | 1149.41 | 1154.14 | 11367.0 |
| 2008-09-15 03:00:00 | ES | Futures | 1154.14 | 1158.64 | 1152.96 | 1156.27 | 25835.0 |
| 2008-09-15 04:00:00 | ES | Futures | 1156.27 | 1157.22 | 1147.51 | 1147.99 | 29955.0 |
| 2008-09-15 05:00:00 | ES | Futures | 1147.99 | 1154.85 | 1147.04 | 1150.83 | 23391.0 |
| 2008-09-15 06:00:00 | ES | Futures | 1150.83 | 1150.83 | 1143.49 | 1143.49 | 38983.0 |
| 2008-09-15 07:00:00 | ES | Futures | 1143.49 | 1146.8 | 1138.99 | 1144.44 | 75879.0 |
| 2008-09-15 08:00:00 | ES | Futures | 1144.44 | 1152.01 | 1142.31 | 1148.7 | 87891.0 |
| 2008-09-15 09:00:00 | ES | Futures | 1148.7 | 1160.06 | 1144.44 | 1152.96 | 377591.0 |
| 2008-09-15 10:00:00 | ES | Futures | 1152.96 | 1173.07 | 1151.3 | 1169.29 | 476917.0 |
| 2008-09-15 11:00:00 | ES | Futures | 1169.29 | 1170.23 | 1153.9 | 1155.09 | 347180.0 |
| 2008-09-15 12:00:00 | ES | Futures | 1154.85 | 1167.63 | 1154.14 | 1162.19 | 366375.0 |
| 2008-09-15 13:00:00 | ES | Futures | 1162.19 | 1166.21 | 1150.35 | 1154.38 | 263585.0 |
| 2008-09-15 14:00:00 | ES | Futures | 1154.61 | 1161.0 | 1146.57 | 1149.41 | 285906.0 |
| 2008-09-15 15:00:00 | ES | Futures | 1149.17 | 1150.83 | 1133.55 | 1135.92 | 741019.0 |
| 2008-09-15 16:00:00 | ES | Futures | 1135.68 | 1136.63 | 1130.71 | 1132.37 | 191312.0 |
| 2008-09-15 17:00:00 | ES | Futures | 1132.13 | 1134.97 | 1132.13 | 1132.37 | 4025.0 |
| 2008-09-15 18:00:00 | ES | Futures | 1132.13 | 1132.13 | 1126.45 | 1127.16 | 11033.0 |
| 2008-09-15 19:00:00 | ES | Futures | 1126.93 | 1128.58 | 1125.51 | 1126.45 | 9568.0 |
| 2008-09-15 20:00:00 | ES | Futures | 1126.69 | 1126.93 | 1116.28 | 1116.99 | 28833.0 |
| 2008-09-15 21:00:00 | ES | Futures | 1116.99 | 1122.19 | 1113.2 | 1116.28 | 19767.0 |
| 2008-09-15 22:00:00 | ES | Futures | 1116.28 | 1118.17 | 1112.96 | 1114.86 | 14983.0 |
| 2008-09-15 23:00:00 | ES | Futures | 1115.09 | 1118.17 | 1113.91 | 1114.38 | 4700.0 |
| 2008-09-15 00:00:00 | NQ | Futures | 1957.82 | 1967.16 | 1955.84 | 1955.84 | 690.0 |
| 2008-09-15 01:00:00 | NQ | Futures | 1955.84 | 1963.77 | 1954.99 | 1960.65 | 314.0 |
| 2008-09-15 02:00:00 | NQ | Futures | 1959.52 | 1966.03 | 1958.39 | 1964.33 | 609.0 |
| 2008-09-15 03:00:00 | NQ | Futures | 1964.9 | 1969.71 | 1962.63 | 1966.31 | 1557.0 |
| 2008-09-15 04:00:00 | NQ | Futures | 1966.6 | 1968.29 | 1954.71 | 1954.99 | 1301.0 |
| 2008-09-15 05:00:00 | NQ | Futures | 1954.99 | 1961.79 | 1954.71 | 1959.52 | 2504.0 |
| 2008-09-15 06:00:00 | NQ | Futures | 1959.24 | 1960.94 | 1952.16 | 1954.71 | 4354.0 |
| 2008-09-15 07:00:00 | NQ | Futures | 1954.43 | 1963.77 | 1947.35 | 1954.71 | 7387.0 |
| 2008-09-15 08:00:00 | NQ | Futures | 1954.71 | 1965.75 | 1953.58 | 1958.67 | 8936.0 |
| 2008-09-15 09:00:00 | NQ | Futures | 1958.67 | 1980.46 | 1951.32 | 1967.73 | 68731.0 |
| 2008-09-15 10:00:00 | NQ | Futures | 1967.44 | 1999.14 | 1966.6 | 1990.65 | 70540.0 |
| 2008-09-15 11:00:00 | NQ | Futures | 1990.93 | 1992.06 | 1973.1 | 1973.95 | 44581.0 |
| 2008-09-15 12:00:00 | NQ | Futures | 1974.8 | 1993.19 | 1972.54 | 1984.42 | 47725.0 |
| 2008-09-15 13:00:00 | NQ | Futures | 1984.42 | 1990.08 | 1960.37 | 1966.88 | 39243.0 |
| 2008-09-15 14:00:00 | NQ | Futures | 1966.88 | 1975.93 | 1958.39 | 1961.5 | 43205.0 |
| 2008-09-15 15:00:00 | NQ | Futures | 1961.5 | 1966.6 | 1939.71 | 1942.83 | 110424.0 |
| 2008-09-15 16:00:00 | NQ | Futures | 1942.83 | 1952.45 | 1937.17 | 1945.94 | 34948.0 |
| 2008-09-15 17:00:00 | NQ | Futures | 1948.2 | 1950.47 | 1946.51 | 1947.35 | 189.0 |
| 2008-09-15 18:00:00 | NQ | Futures | 1947.92 | 1947.92 | 1937.73 | 1938.86 | 465.0 |
| 2008-09-15 19:00:00 | NQ | Futures | 1937.73 | 1942.26 | 1937.17 | 1937.73 | 400.0 |
| 2008-09-15 20:00:00 | NQ | Futures | 1937.73 | 1939.15 | 1926.7 | 1928.11 | 1081.0 |
| 2008-09-15 21:00:00 | NQ | Futures | 1928.11 | 1936.88 | 1927.55 | 1930.38 | 807.0 |
| 2008-09-15 22:00:00 | NQ | Futures | 1929.81 | 1932.36 | 1924.43 | 1926.13 | 1104.0 |
| 2008-09-15 23:00:00 | NQ | Futures | 1926.41 | 1931.22 | 1926.41 | 1927.55 | 287.0 |
| 2008-09-15 00:00:00 | YM | Futures | 10110.2 | 10167.5 | 10100.2 | 10100.2 | 1016.0 |
| 2008-09-15 01:00:00 | YM | Futures | 10102.9 | 10146.6 | 10099.3 | 10128.4 | 423.0 |
> showing 50 of 1,260 rows — these rows as CSV