PREVIEW / futures_1hour / 2008-09-10
file: by_date/futures_1hour/2008/2008-09-10.parquet size: 42 KB rows: 1,185
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-10 00:00:00 | ES | Futures | 1144.88 | 1145.11 | 1144.18 | 1144.65 | 1549.0 |
| 2008-09-10 01:00:00 | ES | Futures | 1144.65 | 1150.92 | 1143.95 | 1146.97 | 23176.0 |
| 2008-09-10 02:00:00 | ES | Futures | 1146.97 | 1153.71 | 1146.04 | 1151.39 | 22178.0 |
| 2008-09-10 03:00:00 | ES | Futures | 1151.15 | 1152.78 | 1144.65 | 1149.53 | 35289.0 |
| 2008-09-10 04:00:00 | ES | Futures | 1149.76 | 1152.32 | 1149.06 | 1149.99 | 11717.0 |
| 2008-09-10 05:00:00 | ES | Futures | 1150.22 | 1150.46 | 1145.11 | 1145.58 | 17067.0 |
| 2008-09-10 06:00:00 | ES | Futures | 1145.34 | 1149.76 | 1144.41 | 1146.97 | 19289.0 |
| 2008-09-10 07:00:00 | ES | Futures | 1146.74 | 1152.55 | 1135.35 | 1136.28 | 149363.0 |
| 2008-09-10 08:00:00 | ES | Futures | 1136.28 | 1147.67 | 1134.42 | 1147.2 | 123199.0 |
| 2008-09-10 09:00:00 | ES | Futures | 1147.43 | 1150.46 | 1140.69 | 1147.67 | 298865.0 |
| 2008-09-10 10:00:00 | ES | Futures | 1147.67 | 1149.53 | 1137.91 | 1139.3 | 443119.0 |
| 2008-09-10 11:00:00 | ES | Futures | 1139.3 | 1146.5 | 1135.58 | 1143.48 | 358451.0 |
| 2008-09-10 12:00:00 | ES | Futures | 1143.25 | 1148.6 | 1142.55 | 1145.11 | 220788.0 |
| 2008-09-10 13:00:00 | ES | Futures | 1144.88 | 1149.29 | 1142.79 | 1144.65 | 168075.0 |
| 2008-09-10 14:00:00 | ES | Futures | 1144.65 | 1156.5 | 1143.95 | 1151.15 | 367864.0 |
| 2008-09-10 15:00:00 | ES | Futures | 1151.15 | 1157.2 | 1143.25 | 1144.41 | 414180.0 |
| 2008-09-10 16:00:00 | ES | Futures | 1144.41 | 1147.67 | 1144.18 | 1147.2 | 101809.0 |
| 2008-09-10 17:00:00 | ES | Futures | 1147.2 | 1147.67 | 1146.5 | 1147.2 | 2502.0 |
| 2008-09-10 18:00:00 | ES | Futures | 1146.97 | 1147.67 | 1146.5 | 1147.2 | 1694.0 |
| 2008-09-10 19:00:00 | ES | Futures | 1146.97 | 1147.43 | 1143.95 | 1144.18 | 2671.0 |
| 2008-09-10 20:00:00 | ES | Futures | 1144.41 | 1144.88 | 1142.79 | 1143.02 | 3073.0 |
| 2008-09-10 21:00:00 | ES | Futures | 1143.02 | 1143.72 | 1142.32 | 1143.72 | 2028.0 |
| 2008-09-10 22:00:00 | ES | Futures | 1143.72 | 1144.18 | 1141.16 | 1141.39 | 3334.0 |
| 2008-09-10 23:00:00 | ES | Futures | 1141.39 | 1142.09 | 1140.93 | 1141.86 | 1307.0 |
| 2008-09-10 00:00:00 | NQ | Futures | 1955.52 | 1956.36 | 1954.39 | 1955.24 | 118.0 |
| 2008-09-10 01:00:00 | NQ | Futures | 1955.24 | 1965.93 | 1954.11 | 1958.33 | 2266.0 |
| 2008-09-10 02:00:00 | NQ | Futures | 1959.74 | 1967.9 | 1957.77 | 1964.24 | 2084.0 |
| 2008-09-10 03:00:00 | NQ | Futures | 1964.52 | 1966.77 | 1955.24 | 1963.4 | 4721.0 |
| 2008-09-10 04:00:00 | NQ | Futures | 1963.4 | 1969.58 | 1962.27 | 1967.9 | 3713.0 |
| 2008-09-10 05:00:00 | NQ | Futures | 1968.18 | 1969.3 | 1960.58 | 1961.15 | 3180.0 |
| 2008-09-10 06:00:00 | NQ | Futures | 1960.58 | 1967.9 | 1959.46 | 1960.58 | 1847.0 |
| 2008-09-10 07:00:00 | NQ | Futures | 1961.43 | 1965.65 | 1951.86 | 1952.71 | 10735.0 |
| 2008-09-10 08:00:00 | NQ | Futures | 1952.99 | 1964.8 | 1951.02 | 1964.24 | 13853.0 |
| 2008-09-10 09:00:00 | NQ | Futures | 1964.24 | 1965.08 | 1946.24 | 1953.27 | 57510.0 |
| 2008-09-10 10:00:00 | NQ | Futures | 1953.27 | 1961.71 | 1945.39 | 1947.08 | 58127.0 |
| 2008-09-10 11:00:00 | NQ | Futures | 1946.8 | 1962.27 | 1942.02 | 1957.49 | 52710.0 |
| 2008-09-10 12:00:00 | NQ | Futures | 1957.77 | 1967.62 | 1955.8 | 1962.55 | 36383.0 |
| 2008-09-10 13:00:00 | NQ | Futures | 1962.55 | 1965.65 | 1952.71 | 1953.27 | 25310.0 |
| 2008-09-10 14:00:00 | NQ | Futures | 1953.55 | 1975.49 | 1952.71 | 1965.93 | 47168.0 |
| 2008-09-10 15:00:00 | NQ | Futures | 1966.21 | 1974.37 | 1953.83 | 1954.96 | 54310.0 |
| 2008-09-10 16:00:00 | NQ | Futures | 1954.39 | 1955.8 | 1949.89 | 1954.96 | 16283.0 |
| 2008-09-10 17:00:00 | NQ | Futures | 1954.96 | 1956.08 | 1954.11 | 1955.52 | 177.0 |
| 2008-09-10 18:00:00 | NQ | Futures | 1954.96 | 1955.8 | 1953.83 | 1955.24 | 167.0 |
| 2008-09-10 19:00:00 | NQ | Futures | 1954.96 | 1955.52 | 1949.61 | 1950.18 | 329.0 |
| 2008-09-10 20:00:00 | NQ | Futures | 1950.46 | 1951.3 | 1948.21 | 1948.21 | 178.0 |
| 2008-09-10 21:00:00 | NQ | Futures | 1948.21 | 1948.77 | 1947.36 | 1947.92 | 499.0 |
| 2008-09-10 22:00:00 | NQ | Futures | 1948.21 | 1948.77 | 1943.99 | 1945.39 | 262.0 |
| 2008-09-10 23:00:00 | NQ | Futures | 1945.39 | 1946.24 | 1944.55 | 1946.24 | 62.0 |
| 2008-09-10 00:00:00 | YM | Futures | 10258.5 | 10258.5 | 10253.9 | 10253.9 | 6.0 |
| 2008-09-10 01:00:00 | YM | Futures | 10253.0 | 10300.3 | 10253.0 | 10276.7 | 90.0 |
> showing 50 of 1,185 rows — these rows as CSV