PREVIEW / futures_30min / 2008-08-05
file: by_date/futures_30min/2008/2008-08-05.parquet size: 68 KB rows: 2,349
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-05 00:00:00 | ES | Futures | 1162.31 | 1163.01 | 1162.31 | 1162.31 | 142.0 |
| 2008-08-05 00:30:00 | ES | Futures | 1162.54 | 1162.77 | 1162.08 | 1162.31 | 264.0 |
| 2008-08-05 01:00:00 | ES | Futures | 1162.08 | 1163.47 | 1162.08 | 1162.77 | 549.0 |
| 2008-08-05 01:30:00 | ES | Futures | 1163.01 | 1163.47 | 1159.75 | 1161.38 | 2472.0 |
| 2008-08-05 02:00:00 | ES | Futures | 1161.38 | 1162.77 | 1161.15 | 1162.54 | 2008.0 |
| 2008-08-05 02:30:00 | ES | Futures | 1162.77 | 1163.47 | 1162.31 | 1163.01 | 2038.0 |
| 2008-08-05 03:00:00 | ES | Futures | 1163.24 | 1163.47 | 1159.52 | 1163.01 | 6769.0 |
| 2008-08-05 03:30:00 | ES | Futures | 1163.01 | 1163.94 | 1161.84 | 1163.7 | 4612.0 |
| 2008-08-05 04:00:00 | ES | Futures | 1163.47 | 1168.12 | 1163.47 | 1167.65 | 12951.0 |
| 2008-08-05 04:30:00 | ES | Futures | 1167.65 | 1171.37 | 1167.42 | 1169.28 | 20405.0 |
| 2008-08-05 05:00:00 | ES | Futures | 1169.51 | 1171.84 | 1168.35 | 1168.82 | 10878.0 |
| 2008-08-05 05:30:00 | ES | Futures | 1168.82 | 1170.44 | 1168.58 | 1170.21 | 4189.0 |
| 2008-08-05 06:00:00 | ES | Futures | 1170.21 | 1171.14 | 1169.05 | 1170.68 | 6354.0 |
| 2008-08-05 06:30:00 | ES | Futures | 1170.44 | 1172.54 | 1169.51 | 1171.14 | 10075.0 |
| 2008-08-05 07:00:00 | ES | Futures | 1171.14 | 1171.14 | 1169.51 | 1170.44 | 9726.0 |
| 2008-08-05 07:30:00 | ES | Futures | 1170.21 | 1170.68 | 1168.12 | 1168.82 | 8544.0 |
| 2008-08-05 08:00:00 | ES | Futures | 1168.82 | 1169.51 | 1167.89 | 1168.12 | 7058.0 |
| 2008-08-05 08:30:00 | ES | Futures | 1168.35 | 1170.21 | 1167.89 | 1169.75 | 11149.0 |
| 2008-08-05 09:00:00 | ES | Futures | 1169.75 | 1171.14 | 1168.82 | 1170.21 | 25709.0 |
| 2008-08-05 09:30:00 | ES | Futures | 1170.44 | 1174.63 | 1169.05 | 1174.16 | 179844.0 |
| 2008-08-05 10:00:00 | ES | Futures | 1174.16 | 1177.65 | 1173.7 | 1176.02 | 207170.0 |
| 2008-08-05 10:30:00 | ES | Futures | 1176.02 | 1178.58 | 1175.09 | 1178.35 | 89343.0 |
| 2008-08-05 11:00:00 | ES | Futures | 1178.35 | 1179.74 | 1177.65 | 1178.81 | 94235.0 |
| 2008-08-05 11:30:00 | ES | Futures | 1178.81 | 1181.13 | 1177.88 | 1181.13 | 76537.0 |
| 2008-08-05 12:00:00 | ES | Futures | 1181.13 | 1182.99 | 1179.28 | 1181.83 | 81683.0 |
| 2008-08-05 12:30:00 | ES | Futures | 1181.83 | 1182.06 | 1180.21 | 1181.83 | 46552.0 |
| 2008-08-05 13:00:00 | ES | Futures | 1181.83 | 1182.3 | 1180.9 | 1182.06 | 39879.0 |
| 2008-08-05 13:30:00 | ES | Futures | 1181.83 | 1184.16 | 1181.83 | 1182.3 | 67293.0 |
| 2008-08-05 14:00:00 | ES | Futures | 1182.3 | 1188.34 | 1177.88 | 1183.46 | 240379.0 |
| 2008-08-05 14:30:00 | ES | Futures | 1183.69 | 1189.27 | 1182.76 | 1186.95 | 195215.0 |
| 2008-08-05 15:00:00 | ES | Futures | 1187.18 | 1188.57 | 1185.78 | 1187.41 | 118541.0 |
| 2008-08-05 15:30:00 | ES | Futures | 1187.41 | 1193.22 | 1186.25 | 1192.99 | 279656.0 |
| 2008-08-05 16:00:00 | ES | Futures | 1192.76 | 1194.15 | 1192.06 | 1192.29 | 124397.0 |
| 2008-08-05 16:30:00 | ES | Futures | 1192.52 | 1193.69 | 1191.83 | 1192.99 | 10576.0 |
| 2008-08-05 17:00:00 | ES | Futures | 1192.99 | 1194.61 | 1192.76 | 1193.69 | 4136.0 |
| 2008-08-05 18:00:00 | ES | Futures | 1194.38 | 1194.61 | 1192.76 | 1192.99 | 2477.0 |
| 2008-08-05 18:30:00 | ES | Futures | 1192.99 | 1193.45 | 1192.76 | 1193.45 | 162.0 |
| 2008-08-05 19:00:00 | ES | Futures | 1193.45 | 1193.92 | 1193.45 | 1193.45 | 321.0 |
| 2008-08-05 19:30:00 | ES | Futures | 1193.69 | 1194.15 | 1193.22 | 1193.69 | 603.0 |
| 2008-08-05 20:00:00 | ES | Futures | 1193.92 | 1194.15 | 1192.99 | 1193.45 | 900.0 |
| 2008-08-05 20:30:00 | ES | Futures | 1193.45 | 1193.92 | 1192.76 | 1192.76 | 544.0 |
| 2008-08-05 21:00:00 | ES | Futures | 1192.76 | 1192.99 | 1192.52 | 1192.99 | 544.0 |
| 2008-08-05 21:30:00 | ES | Futures | 1192.76 | 1193.22 | 1192.06 | 1193.22 | 1115.0 |
| 2008-08-05 22:00:00 | ES | Futures | 1193.22 | 1193.69 | 1192.99 | 1193.45 | 634.0 |
| 2008-08-05 22:30:00 | ES | Futures | 1193.22 | 1193.92 | 1193.22 | 1193.45 | 299.0 |
| 2008-08-05 23:00:00 | ES | Futures | 1193.69 | 1193.92 | 1193.22 | 1193.92 | 391.0 |
| 2008-08-05 23:30:00 | ES | Futures | 1193.92 | 1194.61 | 1193.92 | 1194.38 | 1150.0 |
| 2008-08-05 00:00:00 | NQ | Futures | 2041.59 | 2041.59 | 2041.31 | 2041.31 | 3.0 |
| 2008-08-05 00:30:00 | NQ | Futures | 2041.31 | 2041.31 | 2041.31 | 2041.31 | 3.0 |
| 2008-08-05 01:00:00 | NQ | Futures | 2041.59 | 2043.0 | 2041.31 | 2042.72 | 28.0 |
> showing 50 of 2,349 rows — these rows as CSV