PREVIEW / futures_30min / 2008-08-07
file: by_date/futures_30min/2008/2008-08-07.parquet size: 69 KB rows: 2,296
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-07 00:00:00 | ES | Futures | 1191.13 | 1192.29 | 1191.13 | 1192.06 | 961.0 |
| 2008-08-07 00:30:00 | ES | Futures | 1192.29 | 1192.76 | 1191.83 | 1192.52 | 522.0 |
| 2008-08-07 01:00:00 | ES | Futures | 1192.29 | 1194.85 | 1191.83 | 1194.61 | 1893.0 |
| 2008-08-07 01:30:00 | ES | Futures | 1194.38 | 1194.61 | 1193.22 | 1193.45 | 1744.0 |
| 2008-08-07 02:00:00 | ES | Futures | 1193.22 | 1194.15 | 1191.83 | 1193.45 | 2590.0 |
| 2008-08-07 02:30:00 | ES | Futures | 1193.45 | 1193.69 | 1191.59 | 1192.76 | 2011.0 |
| 2008-08-07 03:00:00 | ES | Futures | 1192.76 | 1193.45 | 1191.13 | 1192.29 | 6529.0 |
| 2008-08-07 03:30:00 | ES | Futures | 1192.29 | 1194.15 | 1192.06 | 1193.92 | 4903.0 |
| 2008-08-07 04:00:00 | ES | Futures | 1193.69 | 1196.24 | 1193.22 | 1195.78 | 8451.0 |
| 2008-08-07 04:30:00 | ES | Futures | 1195.78 | 1197.17 | 1195.31 | 1196.01 | 6533.0 |
| 2008-08-07 05:00:00 | ES | Futures | 1196.01 | 1198.33 | 1195.31 | 1198.1 | 6854.0 |
| 2008-08-07 05:30:00 | ES | Futures | 1198.1 | 1198.1 | 1195.08 | 1195.31 | 7680.0 |
| 2008-08-07 06:00:00 | ES | Futures | 1195.08 | 1196.24 | 1193.92 | 1194.61 | 4778.0 |
| 2008-08-07 06:30:00 | ES | Futures | 1194.61 | 1194.85 | 1193.22 | 1193.69 | 4590.0 |
| 2008-08-07 07:00:00 | ES | Futures | 1193.45 | 1195.08 | 1190.66 | 1192.06 | 12822.0 |
| 2008-08-07 07:30:00 | ES | Futures | 1191.83 | 1193.45 | 1190.9 | 1192.29 | 9639.0 |
| 2008-08-07 08:00:00 | ES | Futures | 1192.06 | 1192.29 | 1190.66 | 1191.83 | 12859.0 |
| 2008-08-07 08:30:00 | ES | Futures | 1191.83 | 1191.83 | 1187.18 | 1189.27 | 55445.0 |
| 2008-08-07 09:00:00 | ES | Futures | 1189.27 | 1189.73 | 1187.64 | 1187.87 | 24195.0 |
| 2008-08-07 09:30:00 | ES | Futures | 1187.87 | 1189.27 | 1181.83 | 1188.34 | 221857.0 |
| 2008-08-07 10:00:00 | ES | Futures | 1188.34 | 1192.06 | 1186.71 | 1189.73 | 198157.0 |
| 2008-08-07 10:30:00 | ES | Futures | 1189.73 | 1191.36 | 1186.95 | 1190.2 | 117225.0 |
| 2008-08-07 11:00:00 | ES | Futures | 1190.2 | 1191.13 | 1186.48 | 1188.34 | 97215.0 |
| 2008-08-07 11:30:00 | ES | Futures | 1188.34 | 1189.5 | 1186.71 | 1187.18 | 65535.0 |
| 2008-08-07 12:00:00 | ES | Futures | 1187.18 | 1188.8 | 1185.55 | 1188.57 | 57989.0 |
| 2008-08-07 12:30:00 | ES | Futures | 1188.34 | 1192.52 | 1187.41 | 1191.36 | 87695.0 |
| 2008-08-07 13:00:00 | ES | Futures | 1191.36 | 1191.59 | 1188.8 | 1190.43 | 61872.0 |
| 2008-08-07 13:30:00 | ES | Futures | 1190.43 | 1192.06 | 1187.64 | 1187.87 | 84222.0 |
| 2008-08-07 14:00:00 | ES | Futures | 1188.11 | 1188.8 | 1186.25 | 1187.41 | 82101.0 |
| 2008-08-07 14:30:00 | ES | Futures | 1187.41 | 1189.27 | 1182.76 | 1182.99 | 116689.0 |
| 2008-08-07 15:00:00 | ES | Futures | 1182.99 | 1184.39 | 1179.97 | 1181.37 | 176013.0 |
| 2008-08-07 15:30:00 | ES | Futures | 1181.37 | 1181.6 | 1174.63 | 1177.88 | 329399.0 |
| 2008-08-07 16:00:00 | ES | Futures | 1177.88 | 1179.04 | 1176.72 | 1178.58 | 90841.0 |
| 2008-08-07 16:30:00 | ES | Futures | 1178.81 | 1179.74 | 1178.35 | 1179.51 | 4587.0 |
| 2008-08-07 17:00:00 | ES | Futures | 1179.51 | 1179.97 | 1179.28 | 1179.51 | 1676.0 |
| 2008-08-07 18:00:00 | ES | Futures | 1179.28 | 1179.74 | 1178.58 | 1178.81 | 1255.0 |
| 2008-08-07 18:30:00 | ES | Futures | 1178.81 | 1179.28 | 1178.58 | 1178.81 | 496.0 |
| 2008-08-07 19:00:00 | ES | Futures | 1178.81 | 1178.81 | 1178.11 | 1178.35 | 285.0 |
| 2008-08-07 19:30:00 | ES | Futures | 1178.35 | 1179.04 | 1178.11 | 1178.35 | 600.0 |
| 2008-08-07 20:00:00 | ES | Futures | 1178.35 | 1179.28 | 1178.35 | 1179.04 | 849.0 |
| 2008-08-07 20:30:00 | ES | Futures | 1179.04 | 1179.97 | 1179.04 | 1179.74 | 1063.0 |
| 2008-08-07 21:00:00 | ES | Futures | 1179.74 | 1181.37 | 1179.74 | 1181.13 | 2115.0 |
| 2008-08-07 21:30:00 | ES | Futures | 1181.13 | 1181.37 | 1179.97 | 1181.13 | 1161.0 |
| 2008-08-07 22:00:00 | ES | Futures | 1181.37 | 1181.6 | 1181.13 | 1181.6 | 900.0 |
| 2008-08-07 22:30:00 | ES | Futures | 1181.6 | 1182.06 | 1181.13 | 1181.37 | 1538.0 |
| 2008-08-07 23:00:00 | ES | Futures | 1181.6 | 1181.6 | 1180.9 | 1181.13 | 655.0 |
| 2008-08-07 23:30:00 | ES | Futures | 1181.13 | 1181.6 | 1180.9 | 1181.37 | 745.0 |
| 2008-08-07 00:00:00 | NQ | Futures | 2123.45 | 2125.98 | 2123.17 | 2124.01 | 62.0 |
| 2008-08-07 00:30:00 | NQ | Futures | 2124.86 | 2127.39 | 2123.73 | 2125.14 | 168.0 |
| 2008-08-07 01:00:00 | NQ | Futures | 2125.14 | 2128.79 | 2125.14 | 2127.39 | 84.0 |
> showing 50 of 2,296 rows — these rows as CSV