PREVIEW / futures_1hour / 2008-08-07
file: by_date/futures_1hour/2008/2008-08-07.parquet size: 44 KB rows: 1,262
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-08-07 00:00:00 | ES | Futures | 1191.13 | 1192.76 | 1191.13 | 1192.52 | 1483.0 |
| 2008-08-07 01:00:00 | ES | Futures | 1192.29 | 1194.85 | 1191.83 | 1193.45 | 3637.0 |
| 2008-08-07 02:00:00 | ES | Futures | 1193.22 | 1194.15 | 1191.59 | 1192.76 | 4601.0 |
| 2008-08-07 03:00:00 | ES | Futures | 1192.76 | 1194.15 | 1191.13 | 1193.92 | 11432.0 |
| 2008-08-07 04:00:00 | ES | Futures | 1193.69 | 1197.17 | 1193.22 | 1196.01 | 14984.0 |
| 2008-08-07 05:00:00 | ES | Futures | 1196.01 | 1198.33 | 1195.08 | 1195.31 | 14534.0 |
| 2008-08-07 06:00:00 | ES | Futures | 1195.08 | 1196.24 | 1193.22 | 1193.69 | 9368.0 |
| 2008-08-07 07:00:00 | ES | Futures | 1193.45 | 1195.08 | 1190.66 | 1192.29 | 22461.0 |
| 2008-08-07 08:00:00 | ES | Futures | 1192.06 | 1192.29 | 1187.18 | 1189.27 | 68304.0 |
| 2008-08-07 09:00:00 | ES | Futures | 1189.27 | 1189.73 | 1181.83 | 1188.34 | 246052.0 |
| 2008-08-07 10:00:00 | ES | Futures | 1188.34 | 1192.06 | 1186.71 | 1190.2 | 315382.0 |
| 2008-08-07 11:00:00 | ES | Futures | 1190.2 | 1191.13 | 1186.48 | 1187.18 | 162750.0 |
| 2008-08-07 12:00:00 | ES | Futures | 1187.18 | 1192.52 | 1185.55 | 1191.36 | 145684.0 |
| 2008-08-07 13:00:00 | ES | Futures | 1191.36 | 1192.06 | 1187.64 | 1187.87 | 146094.0 |
| 2008-08-07 14:00:00 | ES | Futures | 1188.11 | 1189.27 | 1182.76 | 1182.99 | 198790.0 |
| 2008-08-07 15:00:00 | ES | Futures | 1182.99 | 1184.39 | 1174.63 | 1177.88 | 505412.0 |
| 2008-08-07 16:00:00 | ES | Futures | 1177.88 | 1179.74 | 1176.72 | 1179.51 | 95428.0 |
| 2008-08-07 17:00:00 | ES | Futures | 1179.51 | 1179.97 | 1179.28 | 1179.51 | 1676.0 |
| 2008-08-07 18:00:00 | ES | Futures | 1179.28 | 1179.74 | 1178.58 | 1178.81 | 1751.0 |
| 2008-08-07 19:00:00 | ES | Futures | 1178.81 | 1179.04 | 1178.11 | 1178.35 | 885.0 |
| 2008-08-07 20:00:00 | ES | Futures | 1178.35 | 1179.97 | 1178.35 | 1179.74 | 1912.0 |
| 2008-08-07 21:00:00 | ES | Futures | 1179.74 | 1181.37 | 1179.74 | 1181.13 | 3276.0 |
| 2008-08-07 22:00:00 | ES | Futures | 1181.37 | 1182.06 | 1181.13 | 1181.37 | 2438.0 |
| 2008-08-07 23:00:00 | ES | Futures | 1181.6 | 1181.6 | 1180.9 | 1181.37 | 1400.0 |
| 2008-08-07 00:00:00 | NQ | Futures | 2123.45 | 2127.39 | 2123.17 | 2125.14 | 230.0 |
| 2008-08-07 01:00:00 | NQ | Futures | 2125.14 | 2128.79 | 2125.14 | 2126.54 | 133.0 |
| 2008-08-07 02:00:00 | NQ | Futures | 2125.98 | 2127.11 | 2123.73 | 2125.7 | 652.0 |
| 2008-08-07 03:00:00 | NQ | Futures | 2125.98 | 2129.92 | 2123.45 | 2129.36 | 1812.0 |
| 2008-08-07 04:00:00 | NQ | Futures | 2129.36 | 2137.51 | 2128.79 | 2136.39 | 2840.0 |
| 2008-08-07 05:00:00 | NQ | Futures | 2136.11 | 2141.17 | 2135.26 | 2135.54 | 2546.0 |
| 2008-08-07 06:00:00 | NQ | Futures | 2135.54 | 2136.67 | 2130.48 | 2131.61 | 1426.0 |
| 2008-08-07 07:00:00 | NQ | Futures | 2131.04 | 2133.29 | 2126.26 | 2129.92 | 2844.0 |
| 2008-08-07 08:00:00 | NQ | Futures | 2129.92 | 2129.92 | 2119.51 | 2122.32 | 10392.0 |
| 2008-08-07 09:00:00 | NQ | Futures | 2122.32 | 2127.39 | 2111.35 | 2126.54 | 51596.0 |
| 2008-08-07 10:00:00 | NQ | Futures | 2126.26 | 2134.98 | 2122.32 | 2131.33 | 55979.0 |
| 2008-08-07 11:00:00 | NQ | Futures | 2131.33 | 2137.23 | 2125.14 | 2132.17 | 38082.0 |
| 2008-08-07 12:00:00 | NQ | Futures | 2132.17 | 2146.51 | 2128.23 | 2144.55 | 37819.0 |
| 2008-08-07 13:00:00 | NQ | Futures | 2144.55 | 2144.83 | 2133.86 | 2133.86 | 35395.0 |
| 2008-08-07 14:00:00 | NQ | Futures | 2134.14 | 2135.54 | 2122.61 | 2123.73 | 40944.0 |
| 2008-08-07 15:00:00 | NQ | Futures | 2123.73 | 2125.98 | 2112.76 | 2119.51 | 66718.0 |
| 2008-08-07 16:00:00 | NQ | Futures | 2119.23 | 2125.98 | 2117.82 | 2125.42 | 9953.0 |
| 2008-08-07 17:00:00 | NQ | Futures | 2125.14 | 2125.42 | 2122.61 | 2124.29 | 86.0 |
| 2008-08-07 18:00:00 | NQ | Futures | 2124.86 | 2125.7 | 2123.45 | 2124.01 | 90.0 |
| 2008-08-07 19:00:00 | NQ | Futures | 2124.86 | 2124.86 | 2123.45 | 2124.86 | 60.0 |
| 2008-08-07 20:00:00 | NQ | Futures | 2124.86 | 2126.26 | 2124.57 | 2126.26 | 69.0 |
| 2008-08-07 21:00:00 | NQ | Futures | 2126.54 | 2128.79 | 2126.26 | 2128.23 | 141.0 |
| 2008-08-07 22:00:00 | NQ | Futures | 2128.51 | 2128.79 | 2126.82 | 2127.67 | 86.0 |
| 2008-08-07 23:00:00 | NQ | Futures | 2127.95 | 2128.79 | 2123.17 | 2127.95 | 283.0 |
| 2008-08-07 00:00:00 | YM | Futures | 10508.4 | 10521.1 | 10507.5 | 10521.1 | 185.0 |
| 2008-08-07 01:00:00 | YM | Futures | 10520.2 | 10537.5 | 10518.4 | 10527.5 | 198.0 |
> showing 50 of 1,262 rows — these rows as CSV