PREVIEW / futures_30min / 2008-08-27
file: by_date/futures_30min/2008/2008-08-27.parquet size: 66 KB rows: 2,211
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-27 00:00:00 | ES | Futures | 1182.53 | 1183.23 | 1181.83 | 1182.53 | 282.0 |
| 2008-08-27 00:30:00 | ES | Futures | 1182.53 | 1184.39 | 1182.53 | 1183.46 | 803.0 |
| 2008-08-27 01:00:00 | ES | Futures | 1183.69 | 1184.16 | 1182.99 | 1183.69 | 298.0 |
| 2008-08-27 01:30:00 | ES | Futures | 1183.69 | 1184.16 | 1183.23 | 1183.69 | 471.0 |
| 2008-08-27 02:00:00 | ES | Futures | 1183.46 | 1184.62 | 1182.99 | 1182.99 | 2470.0 |
| 2008-08-27 02:30:00 | ES | Futures | 1182.76 | 1183.23 | 1182.3 | 1182.53 | 1753.0 |
| 2008-08-27 03:00:00 | ES | Futures | 1182.53 | 1182.76 | 1181.13 | 1181.13 | 5047.0 |
| 2008-08-27 03:30:00 | ES | Futures | 1181.37 | 1181.83 | 1180.67 | 1181.83 | 4343.0 |
| 2008-08-27 04:00:00 | ES | Futures | 1181.6 | 1181.83 | 1179.97 | 1180.67 | 3858.0 |
| 2008-08-27 04:30:00 | ES | Futures | 1180.67 | 1181.37 | 1178.58 | 1179.04 | 4584.0 |
| 2008-08-27 05:00:00 | ES | Futures | 1178.81 | 1179.51 | 1177.42 | 1177.88 | 7198.0 |
| 2008-08-27 05:30:00 | ES | Futures | 1177.88 | 1178.35 | 1176.49 | 1178.11 | 7201.0 |
| 2008-08-27 06:00:00 | ES | Futures | 1178.11 | 1179.04 | 1177.88 | 1178.58 | 4126.0 |
| 2008-08-27 06:30:00 | ES | Futures | 1178.58 | 1178.81 | 1176.95 | 1178.35 | 4795.0 |
| 2008-08-27 07:00:00 | ES | Futures | 1178.11 | 1180.67 | 1177.65 | 1179.28 | 7142.0 |
| 2008-08-27 07:30:00 | ES | Futures | 1179.28 | 1179.74 | 1178.35 | 1179.74 | 9039.0 |
| 2008-08-27 08:00:00 | ES | Futures | 1179.51 | 1180.21 | 1178.11 | 1179.74 | 9382.0 |
| 2008-08-27 08:30:00 | ES | Futures | 1179.74 | 1186.71 | 1179.74 | 1184.85 | 63034.0 |
| 2008-08-27 09:00:00 | ES | Futures | 1184.85 | 1184.85 | 1182.53 | 1182.76 | 28469.0 |
| 2008-08-27 09:30:00 | ES | Futures | 1182.53 | 1185.09 | 1180.21 | 1181.83 | 126426.0 |
| 2008-08-27 10:00:00 | ES | Futures | 1181.6 | 1187.64 | 1181.13 | 1186.95 | 120419.0 |
| 2008-08-27 10:30:00 | ES | Futures | 1186.71 | 1189.73 | 1186.02 | 1187.64 | 138362.0 |
| 2008-08-27 11:00:00 | ES | Futures | 1187.41 | 1187.64 | 1184.85 | 1184.85 | 74837.0 |
| 2008-08-27 11:30:00 | ES | Futures | 1184.85 | 1186.25 | 1183.69 | 1186.25 | 64169.0 |
| 2008-08-27 12:00:00 | ES | Futures | 1186.25 | 1191.83 | 1184.85 | 1191.13 | 122463.0 |
| 2008-08-27 12:30:00 | ES | Futures | 1191.13 | 1194.85 | 1190.43 | 1193.69 | 110427.0 |
| 2008-08-27 13:00:00 | ES | Futures | 1193.69 | 1193.92 | 1190.66 | 1191.83 | 47657.0 |
| 2008-08-27 13:30:00 | ES | Futures | 1192.06 | 1193.45 | 1190.9 | 1191.13 | 37374.0 |
| 2008-08-27 14:00:00 | ES | Futures | 1191.36 | 1192.99 | 1189.73 | 1191.83 | 47819.0 |
| 2008-08-27 14:30:00 | ES | Futures | 1192.06 | 1194.61 | 1190.66 | 1191.36 | 52136.0 |
| 2008-08-27 15:00:00 | ES | Futures | 1191.36 | 1192.99 | 1187.41 | 1188.11 | 85648.0 |
| 2008-08-27 15:30:00 | ES | Futures | 1187.87 | 1191.59 | 1186.48 | 1191.13 | 135220.0 |
| 2008-08-27 16:00:00 | ES | Futures | 1190.9 | 1192.76 | 1188.8 | 1192.52 | 83081.0 |
| 2008-08-27 16:30:00 | ES | Futures | 1191.59 | 1191.83 | 1190.43 | 1190.9 | 6063.0 |
| 2008-08-27 17:00:00 | ES | Futures | 1190.66 | 1191.36 | 1190.43 | 1190.9 | 3404.0 |
| 2008-08-27 18:00:00 | ES | Futures | 1191.13 | 1191.59 | 1190.43 | 1191.36 | 1181.0 |
| 2008-08-27 18:30:00 | ES | Futures | 1191.36 | 1192.06 | 1190.9 | 1191.36 | 1530.0 |
| 2008-08-27 19:00:00 | ES | Futures | 1191.13 | 1191.36 | 1190.9 | 1190.9 | 180.0 |
| 2008-08-27 19:30:00 | ES | Futures | 1191.13 | 1191.13 | 1190.43 | 1190.66 | 411.0 |
| 2008-08-27 20:00:00 | ES | Futures | 1190.43 | 1190.9 | 1190.43 | 1190.66 | 378.0 |
| 2008-08-27 20:30:00 | ES | Futures | 1190.9 | 1190.9 | 1190.2 | 1190.66 | 507.0 |
| 2008-08-27 21:00:00 | ES | Futures | 1190.66 | 1190.9 | 1189.73 | 1190.2 | 1103.0 |
| 2008-08-27 21:30:00 | ES | Futures | 1190.43 | 1190.9 | 1189.97 | 1190.2 | 665.0 |
| 2008-08-27 22:00:00 | ES | Futures | 1190.2 | 1190.2 | 1189.5 | 1189.97 | 570.0 |
| 2008-08-27 22:30:00 | ES | Futures | 1189.97 | 1189.97 | 1189.73 | 1189.73 | 189.0 |
| 2008-08-27 23:00:00 | ES | Futures | 1189.97 | 1189.97 | 1189.5 | 1189.97 | 155.0 |
| 2008-08-27 23:30:00 | ES | Futures | 1189.73 | 1190.2 | 1189.73 | 1189.73 | 134.0 |
| 2008-08-27 00:00:00 | NQ | Futures | 2129.07 | 2129.36 | 2127.67 | 2129.07 | 14.0 |
| 2008-08-27 00:30:00 | NQ | Futures | 2129.36 | 2131.89 | 2129.36 | 2129.36 | 138.0 |
| 2008-08-27 01:00:00 | NQ | Futures | 2131.33 | 2131.33 | 2129.36 | 2131.04 | 14.0 |
> showing 50 of 2,211 rows — these rows as CSV