PREVIEW / futures_1hour / 2008-08-13
file: by_date/futures_1hour/2008/2008-08-13.parquet size: 44 KB rows: 1,252
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-13 00:00:00 | ES | Futures | 1200.66 | 1201.59 | 1199.96 | 1200.89 | 1136.0 |
| 2008-08-13 01:00:00 | ES | Futures | 1200.89 | 1201.12 | 1199.26 | 1199.73 | 1838.0 |
| 2008-08-13 02:00:00 | ES | Futures | 1199.96 | 1200.66 | 1199.03 | 1199.73 | 5649.0 |
| 2008-08-13 03:00:00 | ES | Futures | 1199.5 | 1201.35 | 1198.57 | 1198.8 | 9268.0 |
| 2008-08-13 04:00:00 | ES | Futures | 1198.57 | 1201.35 | 1198.1 | 1200.19 | 8088.0 |
| 2008-08-13 05:00:00 | ES | Futures | 1200.19 | 1200.43 | 1197.64 | 1198.57 | 7087.0 |
| 2008-08-13 06:00:00 | ES | Futures | 1198.33 | 1200.19 | 1198.1 | 1198.57 | 7651.0 |
| 2008-08-13 07:00:00 | ES | Futures | 1198.57 | 1199.26 | 1195.78 | 1196.01 | 17798.0 |
| 2008-08-13 08:00:00 | ES | Futures | 1196.01 | 1197.64 | 1192.29 | 1194.15 | 66305.0 |
| 2008-08-13 09:00:00 | ES | Futures | 1194.38 | 1196.71 | 1190.2 | 1192.76 | 230858.0 |
| 2008-08-13 10:00:00 | ES | Futures | 1192.52 | 1195.31 | 1188.11 | 1191.59 | 358645.0 |
| 2008-08-13 11:00:00 | ES | Futures | 1191.59 | 1191.59 | 1185.32 | 1186.71 | 269012.0 |
| 2008-08-13 12:00:00 | ES | Futures | 1186.71 | 1190.2 | 1184.85 | 1189.73 | 172468.0 |
| 2008-08-13 13:00:00 | ES | Futures | 1189.73 | 1197.87 | 1187.64 | 1196.94 | 282128.0 |
| 2008-08-13 14:00:00 | ES | Futures | 1196.94 | 1202.98 | 1193.45 | 1201.82 | 279975.0 |
| 2008-08-13 15:00:00 | ES | Futures | 1202.05 | 1203.45 | 1190.9 | 1195.78 | 379237.0 |
| 2008-08-13 16:00:00 | ES | Futures | 1195.54 | 1196.01 | 1193.45 | 1194.38 | 73250.0 |
| 2008-08-13 17:00:00 | ES | Futures | 1194.15 | 1194.61 | 1193.69 | 1194.15 | 692.0 |
| 2008-08-13 18:00:00 | ES | Futures | 1194.15 | 1195.31 | 1193.92 | 1195.08 | 1296.0 |
| 2008-08-13 19:00:00 | ES | Futures | 1195.08 | 1195.31 | 1194.15 | 1195.08 | 1561.0 |
| 2008-08-13 20:00:00 | ES | Futures | 1194.85 | 1196.47 | 1193.69 | 1196.01 | 2328.0 |
| 2008-08-13 21:00:00 | ES | Futures | 1196.24 | 1196.47 | 1194.85 | 1196.01 | 1629.0 |
| 2008-08-13 22:00:00 | ES | Futures | 1196.01 | 1196.94 | 1196.01 | 1196.47 | 1335.0 |
| 2008-08-13 23:00:00 | ES | Futures | 1196.71 | 1196.94 | 1195.78 | 1196.24 | 922.0 |
| 2008-08-13 00:00:00 | NQ | Futures | 2190.68 | 2190.68 | 2188.43 | 2190.11 | 122.0 |
| 2008-08-13 01:00:00 | NQ | Futures | 2190.11 | 2190.68 | 2187.3 | 2188.43 | 209.0 |
| 2008-08-13 02:00:00 | NQ | Futures | 2188.43 | 2188.71 | 2185.9 | 2185.9 | 477.0 |
| 2008-08-13 03:00:00 | NQ | Futures | 2185.9 | 2190.4 | 2185.9 | 2185.9 | 904.0 |
| 2008-08-13 04:00:00 | NQ | Futures | 2185.61 | 2191.24 | 2184.49 | 2189.83 | 1073.0 |
| 2008-08-13 05:00:00 | NQ | Futures | 2189.55 | 2189.55 | 2183.64 | 2185.33 | 912.0 |
| 2008-08-13 06:00:00 | NQ | Futures | 2185.33 | 2189.83 | 2185.05 | 2189.27 | 862.0 |
| 2008-08-13 07:00:00 | NQ | Futures | 2188.43 | 2191.24 | 2185.9 | 2186.74 | 3135.0 |
| 2008-08-13 08:00:00 | NQ | Futures | 2187.02 | 2189.55 | 2182.52 | 2183.64 | 9772.0 |
| 2008-08-13 09:00:00 | NQ | Futures | 2183.93 | 2194.62 | 2181.11 | 2185.05 | 44728.0 |
| 2008-08-13 10:00:00 | NQ | Futures | 2185.05 | 2195.74 | 2176.89 | 2185.9 | 70135.0 |
| 2008-08-13 11:00:00 | NQ | Futures | 2186.18 | 2186.46 | 2164.8 | 2166.77 | 66386.0 |
| 2008-08-13 12:00:00 | NQ | Futures | 2166.49 | 2173.24 | 2164.52 | 2171.55 | 37417.0 |
| 2008-08-13 13:00:00 | NQ | Futures | 2171.55 | 2187.3 | 2167.33 | 2186.46 | 58997.0 |
| 2008-08-13 14:00:00 | NQ | Futures | 2186.46 | 2202.21 | 2182.24 | 2201.65 | 63938.0 |
| 2008-08-13 15:00:00 | NQ | Futures | 2201.37 | 2204.46 | 2179.71 | 2189.55 | 73736.0 |
| 2008-08-13 16:00:00 | NQ | Futures | 2189.27 | 2191.52 | 2181.96 | 2185.61 | 10227.0 |
| 2008-08-13 17:00:00 | NQ | Futures | 2185.33 | 2185.9 | 2185.05 | 2185.9 | 29.0 |
| 2008-08-13 18:00:00 | NQ | Futures | 2186.18 | 2187.3 | 2185.61 | 2187.02 | 87.0 |
| 2008-08-13 19:00:00 | NQ | Futures | 2186.46 | 2188.15 | 2185.61 | 2186.74 | 123.0 |
| 2008-08-13 20:00:00 | NQ | Futures | 2186.74 | 2190.4 | 2186.46 | 2189.55 | 113.0 |
| 2008-08-13 21:00:00 | NQ | Futures | 2189.55 | 2189.55 | 2188.15 | 2189.27 | 80.0 |
| 2008-08-13 22:00:00 | NQ | Futures | 2189.27 | 2190.4 | 2188.71 | 2189.83 | 182.0 |
| 2008-08-13 23:00:00 | NQ | Futures | 2189.55 | 2189.83 | 2188.15 | 2188.43 | 119.0 |
| 2008-08-13 00:00:00 | YM | Futures | 10584.7 | 10588.4 | 10575.7 | 10582.0 | 113.0 |
| 2008-08-13 01:00:00 | YM | Futures | 10582.0 | 10585.7 | 10578.4 | 10582.9 | 83.0 |
> showing 50 of 1,252 rows — these rows as CSV