PREVIEW / futures_30min / 2008-08-19
file: by_date/futures_30min/2008/2008-08-19.parquet size: 65 KB rows: 2,179
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-19 00:00:00 | ES | Futures | 1192.06 | 1192.29 | 1191.59 | 1191.83 | 310.0 |
| 2008-08-19 00:30:00 | ES | Futures | 1191.83 | 1192.06 | 1191.59 | 1191.83 | 176.0 |
| 2008-08-19 01:00:00 | ES | Futures | 1191.83 | 1191.83 | 1191.13 | 1191.36 | 346.0 |
| 2008-08-19 01:30:00 | ES | Futures | 1191.36 | 1191.59 | 1190.43 | 1190.43 | 876.0 |
| 2008-08-19 02:00:00 | ES | Futures | 1190.43 | 1190.66 | 1189.5 | 1189.5 | 2582.0 |
| 2008-08-19 02:30:00 | ES | Futures | 1189.5 | 1189.5 | 1188.34 | 1188.8 | 4188.0 |
| 2008-08-19 03:00:00 | ES | Futures | 1188.8 | 1188.8 | 1186.48 | 1187.87 | 9148.0 |
| 2008-08-19 03:30:00 | ES | Futures | 1187.64 | 1188.34 | 1185.78 | 1186.25 | 9074.0 |
| 2008-08-19 04:00:00 | ES | Futures | 1186.25 | 1189.04 | 1186.25 | 1188.57 | 5046.0 |
| 2008-08-19 04:30:00 | ES | Futures | 1188.8 | 1189.5 | 1187.87 | 1189.04 | 4016.0 |
| 2008-08-19 05:00:00 | ES | Futures | 1189.04 | 1190.2 | 1188.11 | 1189.04 | 6061.0 |
| 2008-08-19 05:30:00 | ES | Futures | 1189.04 | 1189.73 | 1188.57 | 1188.8 | 1894.0 |
| 2008-08-19 06:00:00 | ES | Futures | 1188.8 | 1190.9 | 1187.87 | 1188.57 | 5567.0 |
| 2008-08-19 06:30:00 | ES | Futures | 1188.57 | 1188.8 | 1186.48 | 1187.41 | 3778.0 |
| 2008-08-19 07:00:00 | ES | Futures | 1187.41 | 1188.11 | 1186.02 | 1186.02 | 5973.0 |
| 2008-08-19 07:30:00 | ES | Futures | 1186.02 | 1186.48 | 1184.62 | 1184.85 | 13635.0 |
| 2008-08-19 08:00:00 | ES | Futures | 1184.85 | 1185.78 | 1183.69 | 1185.55 | 20081.0 |
| 2008-08-19 08:30:00 | ES | Futures | 1185.32 | 1185.32 | 1178.81 | 1180.21 | 66524.0 |
| 2008-08-19 09:00:00 | ES | Futures | 1179.97 | 1182.3 | 1179.97 | 1182.3 | 21965.0 |
| 2008-08-19 09:30:00 | ES | Futures | 1182.06 | 1184.85 | 1178.11 | 1180.9 | 267269.0 |
| 2008-08-19 10:00:00 | ES | Futures | 1180.67 | 1181.6 | 1176.49 | 1177.42 | 153955.0 |
| 2008-08-19 10:30:00 | ES | Futures | 1177.42 | 1181.6 | 1176.49 | 1178.35 | 120779.0 |
| 2008-08-19 11:00:00 | ES | Futures | 1178.35 | 1178.58 | 1175.56 | 1177.88 | 105175.0 |
| 2008-08-19 11:30:00 | ES | Futures | 1177.65 | 1178.58 | 1174.16 | 1174.86 | 103361.0 |
| 2008-08-19 12:00:00 | ES | Futures | 1174.86 | 1178.11 | 1174.39 | 1177.42 | 95795.0 |
| 2008-08-19 12:30:00 | ES | Futures | 1177.42 | 1179.97 | 1176.72 | 1178.58 | 60336.0 |
| 2008-08-19 13:00:00 | ES | Futures | 1178.58 | 1180.9 | 1177.65 | 1179.51 | 56318.0 |
| 2008-08-19 13:30:00 | ES | Futures | 1179.51 | 1182.3 | 1177.65 | 1177.88 | 78922.0 |
| 2008-08-19 14:00:00 | ES | Futures | 1177.88 | 1179.51 | 1176.02 | 1176.49 | 84413.0 |
| 2008-08-19 14:30:00 | ES | Futures | 1176.25 | 1178.58 | 1174.86 | 1177.65 | 69547.0 |
| 2008-08-19 15:00:00 | ES | Futures | 1177.65 | 1179.97 | 1173.93 | 1177.42 | 125111.0 |
| 2008-08-19 15:30:00 | ES | Futures | 1177.42 | 1178.58 | 1174.86 | 1178.58 | 119346.0 |
| 2008-08-19 16:00:00 | ES | Futures | 1178.58 | 1180.21 | 1177.42 | 1179.04 | 80067.0 |
| 2008-08-19 16:30:00 | ES | Futures | 1178.81 | 1179.51 | 1178.35 | 1178.35 | 5354.0 |
| 2008-08-19 17:00:00 | ES | Futures | 1178.58 | 1179.51 | 1178.35 | 1179.04 | 954.0 |
| 2008-08-19 18:00:00 | ES | Futures | 1179.04 | 1179.28 | 1178.58 | 1178.58 | 395.0 |
| 2008-08-19 18:30:00 | ES | Futures | 1178.81 | 1179.51 | 1178.35 | 1179.28 | 489.0 |
| 2008-08-19 19:00:00 | ES | Futures | 1179.28 | 1179.28 | 1178.81 | 1178.81 | 317.0 |
| 2008-08-19 19:30:00 | ES | Futures | 1179.04 | 1179.97 | 1178.58 | 1179.97 | 827.0 |
| 2008-08-19 20:00:00 | ES | Futures | 1179.97 | 1180.9 | 1179.74 | 1180.21 | 1596.0 |
| 2008-08-19 20:30:00 | ES | Futures | 1180.21 | 1180.21 | 1179.74 | 1180.21 | 253.0 |
| 2008-08-19 21:00:00 | ES | Futures | 1180.21 | 1180.21 | 1179.97 | 1180.21 | 231.0 |
| 2008-08-19 21:30:00 | ES | Futures | 1180.21 | 1180.44 | 1179.28 | 1180.21 | 609.0 |
| 2008-08-19 22:00:00 | ES | Futures | 1180.21 | 1181.13 | 1179.97 | 1181.13 | 629.0 |
| 2008-08-19 22:30:00 | ES | Futures | 1181.13 | 1182.99 | 1180.9 | 1182.53 | 2076.0 |
| 2008-08-19 23:00:00 | ES | Futures | 1182.53 | 1182.99 | 1182.3 | 1182.53 | 1013.0 |
| 2008-08-19 23:30:00 | ES | Futures | 1182.53 | 1182.76 | 1182.3 | 1182.53 | 711.0 |
| 2008-08-19 00:00:00 | NQ | Futures | 2187.3 | 2187.3 | 2187.3 | 2187.3 | 1.0 |
| 2008-08-19 00:30:00 | NQ | Futures | 2187.3 | 2187.58 | 2186.74 | 2186.74 | 9.0 |
| 2008-08-19 01:00:00 | NQ | Futures | 2187.02 | 2187.02 | 2185.9 | 2186.18 | 69.0 |
> showing 50 of 2,179 rows — these rows as CSV