PREVIEW / futures_1hour / 2008-08-11
file: by_date/futures_1hour/2008/2008-08-11.parquet size: 44 KB rows: 1,243
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-11 00:00:00 | ES | Futures | 1200.19 | 1201.12 | 1199.96 | 1201.12 | 992.0 |
| 2008-08-11 01:00:00 | ES | Futures | 1201.12 | 1201.35 | 1199.73 | 1200.19 | 834.0 |
| 2008-08-11 02:00:00 | ES | Futures | 1200.19 | 1201.59 | 1197.64 | 1198.1 | 4977.0 |
| 2008-08-11 03:00:00 | ES | Futures | 1198.1 | 1202.52 | 1197.4 | 1200.89 | 13604.0 |
| 2008-08-11 04:00:00 | ES | Futures | 1200.89 | 1201.12 | 1198.33 | 1199.73 | 10513.0 |
| 2008-08-11 05:00:00 | ES | Futures | 1199.73 | 1202.75 | 1199.5 | 1202.28 | 8354.0 |
| 2008-08-11 06:00:00 | ES | Futures | 1202.28 | 1203.68 | 1201.35 | 1202.28 | 8714.0 |
| 2008-08-11 07:00:00 | ES | Futures | 1202.28 | 1203.91 | 1202.05 | 1203.68 | 9952.0 |
| 2008-08-11 08:00:00 | ES | Futures | 1203.68 | 1204.84 | 1201.59 | 1203.21 | 24083.0 |
| 2008-08-11 09:00:00 | ES | Futures | 1203.21 | 1206.0 | 1199.96 | 1205.31 | 224314.0 |
| 2008-08-11 10:00:00 | ES | Futures | 1205.54 | 1207.4 | 1204.14 | 1206.7 | 246122.0 |
| 2008-08-11 11:00:00 | ES | Futures | 1206.7 | 1213.91 | 1206.0 | 1213.21 | 273543.0 |
| 2008-08-11 12:00:00 | ES | Futures | 1213.21 | 1218.55 | 1212.98 | 1216.23 | 280113.0 |
| 2008-08-11 13:00:00 | ES | Futures | 1216.23 | 1221.11 | 1215.3 | 1217.39 | 252800.0 |
| 2008-08-11 14:00:00 | ES | Futures | 1217.62 | 1217.86 | 1208.79 | 1210.65 | 344313.0 |
| 2008-08-11 15:00:00 | ES | Futures | 1210.88 | 1214.84 | 1206.47 | 1213.21 | 304811.0 |
| 2008-08-11 16:00:00 | ES | Futures | 1213.21 | 1214.84 | 1211.81 | 1212.51 | 79028.0 |
| 2008-08-11 17:00:00 | ES | Futures | 1212.51 | 1212.98 | 1212.28 | 1212.74 | 768.0 |
| 2008-08-11 18:00:00 | ES | Futures | 1212.51 | 1212.74 | 1211.81 | 1212.05 | 1210.0 |
| 2008-08-11 19:00:00 | ES | Futures | 1212.28 | 1212.51 | 1211.35 | 1211.58 | 1093.0 |
| 2008-08-11 20:00:00 | ES | Futures | 1211.35 | 1212.28 | 1210.88 | 1212.28 | 2597.0 |
| 2008-08-11 21:00:00 | ES | Futures | 1212.28 | 1212.51 | 1210.65 | 1211.12 | 1241.0 |
| 2008-08-11 22:00:00 | ES | Futures | 1211.12 | 1211.35 | 1210.65 | 1211.12 | 960.0 |
| 2008-08-11 23:00:00 | ES | Futures | 1211.35 | 1212.51 | 1211.12 | 1212.05 | 452.0 |
| 2008-08-11 00:00:00 | NQ | Futures | 2161.7 | 2163.39 | 2161.7 | 2161.99 | 101.0 |
| 2008-08-11 01:00:00 | NQ | Futures | 2161.99 | 2162.27 | 2159.45 | 2160.58 | 45.0 |
| 2008-08-11 02:00:00 | NQ | Futures | 2160.86 | 2164.52 | 2159.17 | 2159.45 | 986.0 |
| 2008-08-11 03:00:00 | NQ | Futures | 2160.02 | 2168.46 | 2158.89 | 2166.49 | 1992.0 |
| 2008-08-11 04:00:00 | NQ | Futures | 2166.49 | 2166.77 | 2161.99 | 2163.39 | 1376.0 |
| 2008-08-11 05:00:00 | NQ | Futures | 2163.67 | 2167.89 | 2163.11 | 2167.61 | 973.0 |
| 2008-08-11 06:00:00 | NQ | Futures | 2168.17 | 2169.86 | 2164.52 | 2167.33 | 1402.0 |
| 2008-08-11 07:00:00 | NQ | Futures | 2167.61 | 2173.52 | 2167.33 | 2172.11 | 2249.0 |
| 2008-08-11 08:00:00 | NQ | Futures | 2172.11 | 2172.96 | 2166.49 | 2168.46 | 4554.0 |
| 2008-08-11 09:00:00 | NQ | Futures | 2168.74 | 2179.14 | 2160.02 | 2176.89 | 52227.0 |
| 2008-08-11 10:00:00 | NQ | Futures | 2177.18 | 2184.21 | 2174.08 | 2180.55 | 52271.0 |
| 2008-08-11 11:00:00 | NQ | Futures | 2180.83 | 2194.05 | 2180.27 | 2192.65 | 56142.0 |
| 2008-08-11 12:00:00 | NQ | Futures | 2192.36 | 2203.34 | 2191.8 | 2198.83 | 58416.0 |
| 2008-08-11 13:00:00 | NQ | Futures | 2199.12 | 2212.06 | 2196.3 | 2205.02 | 54161.0 |
| 2008-08-11 14:00:00 | NQ | Futures | 2205.59 | 2206.15 | 2178.58 | 2183.08 | 71246.0 |
| 2008-08-11 15:00:00 | NQ | Futures | 2183.08 | 2191.24 | 2172.39 | 2186.74 | 59585.0 |
| 2008-08-11 16:00:00 | NQ | Futures | 2186.74 | 2188.99 | 2184.21 | 2185.05 | 13255.0 |
| 2008-08-11 17:00:00 | NQ | Futures | 2184.77 | 2185.05 | 2183.93 | 2184.21 | 86.0 |
| 2008-08-11 18:00:00 | NQ | Futures | 2185.05 | 2185.33 | 2184.21 | 2184.49 | 29.0 |
| 2008-08-11 19:00:00 | NQ | Futures | 2185.33 | 2185.33 | 2183.64 | 2184.21 | 128.0 |
| 2008-08-11 20:00:00 | NQ | Futures | 2184.21 | 2184.21 | 2182.8 | 2184.21 | 106.0 |
| 2008-08-11 21:00:00 | NQ | Futures | 2184.21 | 2185.05 | 2182.52 | 2182.8 | 53.0 |
| 2008-08-11 22:00:00 | NQ | Futures | 2183.08 | 2184.49 | 2181.96 | 2184.21 | 107.0 |
| 2008-08-11 23:00:00 | NQ | Futures | 2184.21 | 2186.74 | 2184.21 | 2185.33 | 46.0 |
| 2008-08-11 00:00:00 | YM | Futures | 10608.4 | 10621.1 | 10608.4 | 10618.4 | 86.0 |
| 2008-08-11 01:00:00 | YM | Futures | 10616.6 | 10619.3 | 10603.8 | 10607.5 | 73.0 |
> showing 50 of 1,243 rows — these rows as CSV