PREVIEW / futures_30min / 2008-09-08
file: by_date/futures_30min/2008/2008-09-08.parquet size: 70 KB rows: 2,231
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-09-08 00:00:00 | ES | Futures | 1187.64 | 1188.57 | 1187.64 | 1187.64 | 1171.0 |
| 2008-09-08 00:30:00 | ES | Futures | 1187.64 | 1188.8 | 1187.41 | 1188.11 | 1455.0 |
| 2008-09-08 01:00:00 | ES | Futures | 1188.11 | 1189.04 | 1187.64 | 1188.8 | 2434.0 |
| 2008-09-08 01:30:00 | ES | Futures | 1188.57 | 1189.04 | 1185.32 | 1185.78 | 6407.0 |
| 2008-09-08 02:00:00 | ES | Futures | 1185.55 | 1187.18 | 1185.32 | 1186.02 | 11557.0 |
| 2008-09-08 02:30:00 | ES | Futures | 1186.02 | 1186.02 | 1183.69 | 1183.92 | 13693.0 |
| 2008-09-08 03:00:00 | ES | Futures | 1183.92 | 1185.32 | 1181.83 | 1182.3 | 24282.0 |
| 2008-09-08 03:30:00 | ES | Futures | 1182.3 | 1186.25 | 1180.9 | 1186.25 | 20415.0 |
| 2008-09-08 04:00:00 | ES | Futures | 1186.25 | 1190.2 | 1186.25 | 1189.97 | 28757.0 |
| 2008-09-08 04:30:00 | ES | Futures | 1190.2 | 1190.9 | 1185.55 | 1185.78 | 12080.0 |
| 2008-09-08 05:00:00 | ES | Futures | 1185.78 | 1188.11 | 1185.55 | 1187.64 | 9477.0 |
| 2008-09-08 05:30:00 | ES | Futures | 1187.41 | 1187.64 | 1185.32 | 1185.55 | 5762.0 |
| 2008-09-08 06:00:00 | ES | Futures | 1185.55 | 1189.73 | 1185.55 | 1187.41 | 8582.0 |
| 2008-09-08 06:30:00 | ES | Futures | 1187.41 | 1189.5 | 1186.71 | 1188.57 | 10210.0 |
| 2008-09-08 07:00:00 | ES | Futures | 1188.8 | 1189.04 | 1183.46 | 1184.39 | 16441.0 |
| 2008-09-08 07:30:00 | ES | Futures | 1184.16 | 1186.25 | 1182.53 | 1186.02 | 23155.0 |
| 2008-09-08 08:00:00 | ES | Futures | 1185.78 | 1188.11 | 1185.55 | 1187.41 | 24881.0 |
| 2008-09-08 08:30:00 | ES | Futures | 1187.64 | 1191.83 | 1187.18 | 1187.87 | 49650.0 |
| 2008-09-08 09:00:00 | ES | Futures | 1187.87 | 1189.04 | 1185.32 | 1186.71 | 45511.0 |
| 2008-09-08 09:30:00 | ES | Futures | 1186.95 | 1188.57 | 1175.56 | 1175.79 | 374316.0 |
| 2008-09-08 10:00:00 | ES | Futures | 1175.79 | 1180.67 | 1173.7 | 1176.72 | 268139.0 |
| 2008-09-08 10:30:00 | ES | Futures | 1176.72 | 1182.53 | 1170.68 | 1170.91 | 255416.0 |
| 2008-09-08 11:00:00 | ES | Futures | 1170.68 | 1176.02 | 1162.54 | 1168.35 | 337079.0 |
| 2008-09-08 11:30:00 | ES | Futures | 1168.35 | 1173.0 | 1162.08 | 1166.03 | 203316.0 |
| 2008-09-08 12:00:00 | ES | Futures | 1166.03 | 1167.42 | 1159.06 | 1165.33 | 181176.0 |
| 2008-09-08 12:30:00 | ES | Futures | 1165.33 | 1171.37 | 1165.33 | 1169.98 | 113981.0 |
| 2008-09-08 13:00:00 | ES | Futures | 1170.21 | 1171.14 | 1164.63 | 1167.42 | 88242.0 |
| 2008-09-08 13:30:00 | ES | Futures | 1167.42 | 1168.35 | 1160.22 | 1161.38 | 99538.0 |
| 2008-09-08 14:00:00 | ES | Futures | 1161.15 | 1169.05 | 1159.99 | 1169.05 | 128409.0 |
| 2008-09-08 14:30:00 | ES | Futures | 1168.82 | 1171.84 | 1166.26 | 1167.65 | 113344.0 |
| 2008-09-08 15:00:00 | ES | Futures | 1167.89 | 1174.16 | 1163.7 | 1173.47 | 130397.0 |
| 2008-09-08 15:30:00 | ES | Futures | 1173.47 | 1179.51 | 1173.0 | 1179.51 | 265958.0 |
| 2008-09-08 16:00:00 | ES | Futures | 1179.28 | 1181.13 | 1176.95 | 1177.42 | 122307.0 |
| 2008-09-08 16:30:00 | ES | Futures | 1177.88 | 1178.35 | 1176.72 | 1176.72 | 4921.0 |
| 2008-09-08 17:00:00 | ES | Futures | 1177.18 | 1177.65 | 1176.95 | 1177.18 | 1104.0 |
| 2008-09-08 18:00:00 | ES | Futures | 1176.72 | 1178.11 | 1176.25 | 1178.11 | 1795.0 |
| 2008-09-08 18:30:00 | ES | Futures | 1178.11 | 1178.35 | 1177.18 | 1177.65 | 521.0 |
| 2008-09-08 19:00:00 | ES | Futures | 1177.65 | 1178.35 | 1177.65 | 1177.65 | 691.0 |
| 2008-09-08 19:30:00 | ES | Futures | 1177.88 | 1178.35 | 1176.72 | 1176.72 | 921.0 |
| 2008-09-08 20:00:00 | ES | Futures | 1176.72 | 1176.95 | 1175.56 | 1175.79 | 1817.0 |
| 2008-09-08 20:30:00 | ES | Futures | 1176.02 | 1176.02 | 1175.32 | 1175.56 | 983.0 |
| 2008-09-08 21:00:00 | ES | Futures | 1175.56 | 1175.79 | 1174.86 | 1174.86 | 2120.0 |
| 2008-09-08 21:30:00 | ES | Futures | 1175.09 | 1175.09 | 1174.63 | 1174.63 | 1169.0 |
| 2008-09-08 22:00:00 | ES | Futures | 1174.86 | 1175.56 | 1174.63 | 1174.86 | 1204.0 |
| 2008-09-08 22:30:00 | ES | Futures | 1175.09 | 1175.32 | 1174.39 | 1174.63 | 645.0 |
| 2008-09-08 23:00:00 | ES | Futures | 1174.63 | 1174.63 | 1173.47 | 1174.16 | 1381.0 |
| 2008-09-08 23:30:00 | ES | Futures | 1174.16 | 1174.63 | 1173.7 | 1174.39 | 729.0 |
| 2008-09-08 00:00:00 | NQ | Futures | 2040.47 | 2041.59 | 2039.34 | 2039.34 | 376.0 |
| 2008-09-08 00:30:00 | NQ | Futures | 2039.34 | 2039.34 | 2038.22 | 2038.22 | 201.0 |
| 2008-09-08 01:00:00 | NQ | Futures | 2039.06 | 2039.34 | 2038.22 | 2039.06 | 131.0 |
> showing 50 of 2,231 rows — these rows as CSV