PREVIEW / futures_30min / 2008-07-09
file: by_date/futures_30min/2008/2008-07-09.parquet size: 67 KB rows: 2,257
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-07-09 00:00:00 | ES | Futures | 1184.85 | 1185.32 | 1184.39 | 1184.39 | 1034.0 |
| 2008-07-09 00:30:00 | ES | Futures | 1184.16 | 1184.16 | 1181.83 | 1182.06 | 3177.0 |
| 2008-07-09 01:00:00 | ES | Futures | 1181.83 | 1182.06 | 1181.13 | 1181.37 | 2327.0 |
| 2008-07-09 01:30:00 | ES | Futures | 1181.37 | 1181.83 | 1181.13 | 1181.6 | 992.0 |
| 2008-07-09 02:00:00 | ES | Futures | 1181.6 | 1182.53 | 1180.9 | 1181.13 | 3503.0 |
| 2008-07-09 02:30:00 | ES | Futures | 1180.9 | 1181.83 | 1179.97 | 1180.44 | 5371.0 |
| 2008-07-09 03:00:00 | ES | Futures | 1180.21 | 1182.06 | 1179.04 | 1181.6 | 8322.0 |
| 2008-07-09 03:30:00 | ES | Futures | 1181.83 | 1182.53 | 1180.9 | 1180.9 | 5735.0 |
| 2008-07-09 04:00:00 | ES | Futures | 1180.9 | 1181.6 | 1179.97 | 1180.67 | 5934.0 |
| 2008-07-09 04:30:00 | ES | Futures | 1180.67 | 1183.23 | 1179.97 | 1182.3 | 6791.0 |
| 2008-07-09 05:00:00 | ES | Futures | 1182.3 | 1183.92 | 1180.9 | 1183.23 | 7993.0 |
| 2008-07-09 05:30:00 | ES | Futures | 1183.23 | 1183.23 | 1180.9 | 1182.53 | 6378.0 |
| 2008-07-09 06:00:00 | ES | Futures | 1182.3 | 1182.76 | 1180.9 | 1181.6 | 3196.0 |
| 2008-07-09 06:30:00 | ES | Futures | 1181.6 | 1182.06 | 1179.51 | 1181.13 | 8808.0 |
| 2008-07-09 07:00:00 | ES | Futures | 1181.13 | 1184.85 | 1179.97 | 1184.16 | 10727.0 |
| 2008-07-09 07:30:00 | ES | Futures | 1184.16 | 1186.95 | 1182.99 | 1186.71 | 20556.0 |
| 2008-07-09 08:00:00 | ES | Futures | 1186.48 | 1188.34 | 1185.78 | 1188.11 | 24259.0 |
| 2008-07-09 08:30:00 | ES | Futures | 1188.11 | 1188.8 | 1187.64 | 1187.64 | 24551.0 |
| 2008-07-09 09:00:00 | ES | Futures | 1187.64 | 1187.87 | 1185.78 | 1186.48 | 27261.0 |
| 2008-07-09 09:30:00 | ES | Futures | 1186.48 | 1188.8 | 1181.37 | 1183.69 | 268273.0 |
| 2008-07-09 10:00:00 | ES | Futures | 1183.46 | 1187.87 | 1179.97 | 1186.95 | 201864.0 |
| 2008-07-09 10:30:00 | ES | Futures | 1186.95 | 1187.64 | 1182.3 | 1186.02 | 191355.0 |
| 2008-07-09 11:00:00 | ES | Futures | 1186.02 | 1188.8 | 1183.69 | 1188.34 | 155867.0 |
| 2008-07-09 11:30:00 | ES | Futures | 1188.11 | 1188.57 | 1182.3 | 1183.92 | 132324.0 |
| 2008-07-09 12:00:00 | ES | Futures | 1183.92 | 1185.78 | 1181.37 | 1182.99 | 84305.0 |
| 2008-07-09 12:30:00 | ES | Futures | 1183.23 | 1183.69 | 1179.04 | 1179.97 | 84340.0 |
| 2008-07-09 13:00:00 | ES | Futures | 1179.97 | 1180.44 | 1176.02 | 1178.81 | 90099.0 |
| 2008-07-09 13:30:00 | ES | Futures | 1178.81 | 1180.9 | 1177.18 | 1178.35 | 87125.0 |
| 2008-07-09 14:00:00 | ES | Futures | 1178.11 | 1178.81 | 1173.93 | 1175.32 | 151282.0 |
| 2008-07-09 14:30:00 | ES | Futures | 1175.32 | 1176.25 | 1167.89 | 1169.28 | 160881.0 |
| 2008-07-09 15:00:00 | ES | Futures | 1169.05 | 1169.51 | 1165.33 | 1167.89 | 167455.0 |
| 2008-07-09 15:30:00 | ES | Futures | 1168.12 | 1169.51 | 1157.2 | 1157.89 | 316729.0 |
| 2008-07-09 16:00:00 | ES | Futures | 1157.89 | 1160.68 | 1157.66 | 1160.45 | 107355.0 |
| 2008-07-09 16:30:00 | ES | Futures | 1161.15 | 1161.38 | 1157.66 | 1158.13 | 11437.0 |
| 2008-07-09 17:00:00 | ES | Futures | 1158.13 | 1158.36 | 1157.66 | 1158.36 | 2440.0 |
| 2008-07-09 18:00:00 | ES | Futures | 1158.13 | 1158.36 | 1156.96 | 1157.66 | 3836.0 |
| 2008-07-09 18:30:00 | ES | Futures | 1157.66 | 1158.13 | 1156.96 | 1157.43 | 757.0 |
| 2008-07-09 19:00:00 | ES | Futures | 1157.66 | 1158.59 | 1157.2 | 1158.13 | 1098.0 |
| 2008-07-09 19:30:00 | ES | Futures | 1158.13 | 1158.36 | 1157.2 | 1157.89 | 1359.0 |
| 2008-07-09 20:00:00 | ES | Futures | 1157.89 | 1158.36 | 1157.43 | 1157.89 | 1041.0 |
| 2008-07-09 20:30:00 | ES | Futures | 1157.66 | 1158.36 | 1157.43 | 1158.36 | 1618.0 |
| 2008-07-09 21:00:00 | ES | Futures | 1158.13 | 1158.59 | 1157.89 | 1158.36 | 1700.0 |
| 2008-07-09 21:30:00 | ES | Futures | 1158.36 | 1158.36 | 1156.96 | 1158.13 | 825.0 |
| 2008-07-09 22:00:00 | ES | Futures | 1158.13 | 1159.06 | 1157.89 | 1159.06 | 2165.0 |
| 2008-07-09 22:30:00 | ES | Futures | 1158.82 | 1159.75 | 1158.36 | 1159.75 | 1635.0 |
| 2008-07-09 23:00:00 | ES | Futures | 1159.52 | 1160.22 | 1159.06 | 1159.99 | 1384.0 |
| 2008-07-09 23:30:00 | ES | Futures | 1159.75 | 1160.68 | 1159.29 | 1160.45 | 1339.0 |
| 2008-07-09 00:00:00 | NQ | Futures | 2101.51 | 2102.63 | 2100.1 | 2100.1 | 56.0 |
| 2008-07-09 00:30:00 | NQ | Futures | 2100.1 | 2100.38 | 2095.88 | 2096.16 | 143.0 |
| 2008-07-09 01:00:00 | NQ | Futures | 2096.16 | 2096.45 | 2093.91 | 2094.48 | 107.0 |
> showing 50 of 2,257 rows — these rows as CSV