PREVIEW / futures_30min / 2008-08-26
file: by_date/futures_30min/2008/2008-08-26.parquet size: 66 KB rows: 2,227
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-26 00:00:00 | ES | Futures | 1179.04 | 1179.97 | 1178.81 | 1179.97 | 379.0 |
| 2008-08-26 00:30:00 | ES | Futures | 1179.74 | 1180.21 | 1179.28 | 1179.51 | 361.0 |
| 2008-08-26 01:00:00 | ES | Futures | 1179.28 | 1179.97 | 1179.04 | 1179.74 | 264.0 |
| 2008-08-26 01:30:00 | ES | Futures | 1179.74 | 1180.21 | 1179.51 | 1179.97 | 446.0 |
| 2008-08-26 02:00:00 | ES | Futures | 1180.21 | 1180.21 | 1178.58 | 1179.28 | 1149.0 |
| 2008-08-26 02:30:00 | ES | Futures | 1179.04 | 1179.51 | 1177.88 | 1179.04 | 2099.0 |
| 2008-08-26 03:00:00 | ES | Futures | 1179.04 | 1181.6 | 1178.81 | 1179.97 | 7853.0 |
| 2008-08-26 03:30:00 | ES | Futures | 1179.97 | 1179.97 | 1177.65 | 1177.65 | 6758.0 |
| 2008-08-26 04:00:00 | ES | Futures | 1177.88 | 1177.88 | 1174.63 | 1176.02 | 12946.0 |
| 2008-08-26 04:30:00 | ES | Futures | 1176.25 | 1177.88 | 1176.25 | 1177.88 | 5265.0 |
| 2008-08-26 05:00:00 | ES | Futures | 1177.65 | 1178.81 | 1176.02 | 1178.81 | 4249.0 |
| 2008-08-26 05:30:00 | ES | Futures | 1179.04 | 1181.37 | 1178.81 | 1179.51 | 6917.0 |
| 2008-08-26 06:00:00 | ES | Futures | 1179.51 | 1180.21 | 1177.65 | 1179.74 | 4838.0 |
| 2008-08-26 06:30:00 | ES | Futures | 1179.74 | 1180.9 | 1179.04 | 1180.44 | 4390.0 |
| 2008-08-26 07:00:00 | ES | Futures | 1180.44 | 1181.37 | 1179.51 | 1180.44 | 6931.0 |
| 2008-08-26 07:30:00 | ES | Futures | 1180.44 | 1181.13 | 1176.95 | 1177.42 | 13238.0 |
| 2008-08-26 08:00:00 | ES | Futures | 1177.42 | 1177.88 | 1173.7 | 1176.72 | 20322.0 |
| 2008-08-26 08:30:00 | ES | Futures | 1176.72 | 1178.81 | 1175.56 | 1178.58 | 22425.0 |
| 2008-08-26 09:00:00 | ES | Futures | 1178.58 | 1178.81 | 1175.79 | 1177.65 | 27609.0 |
| 2008-08-26 09:30:00 | ES | Futures | 1177.88 | 1180.9 | 1174.39 | 1179.28 | 182218.0 |
| 2008-08-26 10:00:00 | ES | Futures | 1179.28 | 1182.3 | 1178.81 | 1181.83 | 148975.0 |
| 2008-08-26 10:30:00 | ES | Futures | 1181.83 | 1186.02 | 1181.6 | 1184.39 | 123418.0 |
| 2008-08-26 11:00:00 | ES | Futures | 1184.39 | 1184.85 | 1181.6 | 1182.3 | 63212.0 |
| 2008-08-26 11:30:00 | ES | Futures | 1182.3 | 1182.3 | 1178.11 | 1180.44 | 86742.0 |
| 2008-08-26 12:00:00 | ES | Futures | 1180.67 | 1182.53 | 1179.51 | 1179.97 | 44766.0 |
| 2008-08-26 12:30:00 | ES | Futures | 1179.97 | 1182.53 | 1179.28 | 1179.74 | 60593.0 |
| 2008-08-26 13:00:00 | ES | Futures | 1179.74 | 1180.21 | 1178.58 | 1178.81 | 45521.0 |
| 2008-08-26 13:30:00 | ES | Futures | 1178.81 | 1179.28 | 1176.25 | 1178.35 | 63046.0 |
| 2008-08-26 14:00:00 | ES | Futures | 1178.11 | 1179.51 | 1174.39 | 1175.09 | 116833.0 |
| 2008-08-26 14:30:00 | ES | Futures | 1175.32 | 1176.49 | 1173.7 | 1175.09 | 78921.0 |
| 2008-08-26 15:00:00 | ES | Futures | 1175.09 | 1179.04 | 1174.16 | 1178.11 | 75859.0 |
| 2008-08-26 15:30:00 | ES | Futures | 1178.11 | 1182.3 | 1178.11 | 1182.06 | 112980.0 |
| 2008-08-26 16:00:00 | ES | Futures | 1182.06 | 1182.53 | 1180.9 | 1182.06 | 60076.0 |
| 2008-08-26 16:30:00 | ES | Futures | 1182.06 | 1182.53 | 1181.83 | 1182.06 | 1357.0 |
| 2008-08-26 17:00:00 | ES | Futures | 1182.3 | 1182.53 | 1181.83 | 1182.06 | 664.0 |
| 2008-08-26 18:00:00 | ES | Futures | 1181.6 | 1182.53 | 1181.6 | 1182.06 | 867.0 |
| 2008-08-26 18:30:00 | ES | Futures | 1182.06 | 1182.3 | 1181.83 | 1182.06 | 204.0 |
| 2008-08-26 19:00:00 | ES | Futures | 1182.06 | 1182.06 | 1181.83 | 1181.83 | 182.0 |
| 2008-08-26 19:30:00 | ES | Futures | 1182.06 | 1182.3 | 1181.83 | 1181.83 | 326.0 |
| 2008-08-26 20:00:00 | ES | Futures | 1181.83 | 1182.06 | 1181.37 | 1181.6 | 520.0 |
| 2008-08-26 20:30:00 | ES | Futures | 1181.6 | 1181.6 | 1180.21 | 1180.44 | 1125.0 |
| 2008-08-26 21:00:00 | ES | Futures | 1180.44 | 1180.9 | 1179.51 | 1180.67 | 864.0 |
| 2008-08-26 21:30:00 | ES | Futures | 1180.44 | 1181.83 | 1180.21 | 1181.6 | 646.0 |
| 2008-08-26 22:00:00 | ES | Futures | 1181.6 | 1182.76 | 1181.6 | 1182.76 | 766.0 |
| 2008-08-26 22:30:00 | ES | Futures | 1182.53 | 1183.69 | 1182.53 | 1183.46 | 1578.0 |
| 2008-08-26 23:00:00 | ES | Futures | 1183.23 | 1183.46 | 1182.06 | 1182.3 | 477.0 |
| 2008-08-26 23:30:00 | ES | Futures | 1182.3 | 1182.99 | 1182.06 | 1182.3 | 395.0 |
| 2008-08-26 00:00:00 | NQ | Futures | 2135.54 | 2136.67 | 2135.26 | 2135.54 | 32.0 |
| 2008-08-26 00:30:00 | NQ | Futures | 2135.83 | 2136.67 | 2135.83 | 2136.67 | 17.0 |
| 2008-08-26 01:00:00 | NQ | Futures | 2135.54 | 2136.11 | 2134.98 | 2136.11 | 28.0 |
> showing 50 of 2,227 rows — these rows as CSV