PREVIEW / futures_30min / 2008-07-24
file: by_date/futures_30min/2008/2008-07-24.parquet size: 67 KB rows: 2,255
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-24 00:00:00 | ES | Futures | 1190.9 | 1191.36 | 1190.66 | 1191.13 | 427.0 |
| 2008-07-24 00:30:00 | ES | Futures | 1191.13 | 1192.52 | 1190.9 | 1192.29 | 573.0 |
| 2008-07-24 01:00:00 | ES | Futures | 1192.06 | 1193.69 | 1191.36 | 1192.29 | 1905.0 |
| 2008-07-24 01:30:00 | ES | Futures | 1192.06 | 1193.69 | 1191.59 | 1192.06 | 973.0 |
| 2008-07-24 02:00:00 | ES | Futures | 1192.06 | 1193.92 | 1191.83 | 1193.22 | 1852.0 |
| 2008-07-24 02:30:00 | ES | Futures | 1193.22 | 1194.38 | 1191.59 | 1194.15 | 4684.0 |
| 2008-07-24 03:00:00 | ES | Futures | 1193.92 | 1194.61 | 1190.43 | 1191.36 | 7982.0 |
| 2008-07-24 03:30:00 | ES | Futures | 1191.36 | 1191.83 | 1190.2 | 1190.2 | 7234.0 |
| 2008-07-24 04:00:00 | ES | Futures | 1190.43 | 1190.66 | 1188.34 | 1189.97 | 7283.0 |
| 2008-07-24 04:30:00 | ES | Futures | 1189.73 | 1190.43 | 1188.34 | 1190.43 | 4712.0 |
| 2008-07-24 05:00:00 | ES | Futures | 1190.43 | 1190.9 | 1189.04 | 1190.43 | 3801.0 |
| 2008-07-24 05:30:00 | ES | Futures | 1190.43 | 1190.9 | 1187.41 | 1187.64 | 7099.0 |
| 2008-07-24 06:00:00 | ES | Futures | 1187.64 | 1189.5 | 1186.95 | 1189.04 | 6318.0 |
| 2008-07-24 06:30:00 | ES | Futures | 1189.27 | 1189.27 | 1187.41 | 1188.11 | 6438.0 |
| 2008-07-24 07:00:00 | ES | Futures | 1188.34 | 1188.8 | 1185.78 | 1186.25 | 16340.0 |
| 2008-07-24 07:30:00 | ES | Futures | 1186.25 | 1190.43 | 1186.25 | 1189.27 | 20498.0 |
| 2008-07-24 08:00:00 | ES | Futures | 1189.27 | 1190.9 | 1188.57 | 1189.5 | 12843.0 |
| 2008-07-24 08:30:00 | ES | Futures | 1189.97 | 1189.97 | 1186.95 | 1189.97 | 25957.0 |
| 2008-07-24 09:00:00 | ES | Futures | 1189.97 | 1193.45 | 1189.5 | 1192.76 | 34672.0 |
| 2008-07-24 09:30:00 | ES | Futures | 1192.76 | 1193.45 | 1185.55 | 1186.95 | 194574.0 |
| 2008-07-24 10:00:00 | ES | Futures | 1187.18 | 1187.18 | 1181.13 | 1183.46 | 176950.0 |
| 2008-07-24 10:30:00 | ES | Futures | 1183.46 | 1185.32 | 1181.83 | 1182.06 | 143204.0 |
| 2008-07-24 11:00:00 | ES | Futures | 1182.06 | 1183.23 | 1176.72 | 1176.72 | 175801.0 |
| 2008-07-24 11:30:00 | ES | Futures | 1176.95 | 1179.51 | 1176.02 | 1179.28 | 95196.0 |
| 2008-07-24 12:00:00 | ES | Futures | 1179.28 | 1180.21 | 1176.72 | 1176.95 | 55052.0 |
| 2008-07-24 12:30:00 | ES | Futures | 1176.72 | 1179.04 | 1174.86 | 1177.42 | 93565.0 |
| 2008-07-24 13:00:00 | ES | Futures | 1177.42 | 1178.35 | 1174.86 | 1177.18 | 73078.0 |
| 2008-07-24 13:30:00 | ES | Futures | 1176.95 | 1177.65 | 1174.63 | 1175.79 | 62362.0 |
| 2008-07-24 14:00:00 | ES | Futures | 1175.79 | 1176.49 | 1171.14 | 1172.54 | 139362.0 |
| 2008-07-24 14:30:00 | ES | Futures | 1172.54 | 1173.0 | 1169.28 | 1171.84 | 80998.0 |
| 2008-07-24 15:00:00 | ES | Futures | 1171.61 | 1174.39 | 1167.19 | 1168.12 | 142821.0 |
| 2008-07-24 15:30:00 | ES | Futures | 1167.89 | 1168.82 | 1163.01 | 1165.33 | 250961.0 |
| 2008-07-24 16:00:00 | ES | Futures | 1165.56 | 1165.8 | 1163.24 | 1165.56 | 110730.0 |
| 2008-07-24 16:30:00 | ES | Futures | 1165.1 | 1166.03 | 1164.63 | 1165.33 | 5756.0 |
| 2008-07-24 17:00:00 | ES | Futures | 1165.33 | 1167.19 | 1165.1 | 1166.96 | 2725.0 |
| 2008-07-24 18:00:00 | ES | Futures | 1166.73 | 1167.19 | 1166.49 | 1166.96 | 777.0 |
| 2008-07-24 18:30:00 | ES | Futures | 1166.96 | 1167.19 | 1166.26 | 1166.26 | 621.0 |
| 2008-07-24 19:00:00 | ES | Futures | 1166.26 | 1166.49 | 1165.33 | 1166.49 | 978.0 |
| 2008-07-24 19:30:00 | ES | Futures | 1166.49 | 1167.19 | 1165.56 | 1166.26 | 1591.0 |
| 2008-07-24 20:00:00 | ES | Futures | 1166.03 | 1166.73 | 1164.87 | 1165.1 | 1634.0 |
| 2008-07-24 20:30:00 | ES | Futures | 1164.87 | 1165.8 | 1164.87 | 1165.33 | 1164.0 |
| 2008-07-24 21:00:00 | ES | Futures | 1165.33 | 1165.56 | 1164.63 | 1164.87 | 922.0 |
| 2008-07-24 21:30:00 | ES | Futures | 1164.63 | 1164.87 | 1164.17 | 1164.63 | 1299.0 |
| 2008-07-24 22:00:00 | ES | Futures | 1164.63 | 1164.87 | 1164.17 | 1164.63 | 764.0 |
| 2008-07-24 22:30:00 | ES | Futures | 1164.87 | 1165.56 | 1164.4 | 1165.56 | 1031.0 |
| 2008-07-24 23:00:00 | ES | Futures | 1165.33 | 1166.03 | 1163.7 | 1163.94 | 1405.0 |
| 2008-07-24 23:30:00 | ES | Futures | 1164.17 | 1164.4 | 1163.24 | 1163.24 | 1558.0 |
| 2008-07-24 00:00:00 | NQ | Futures | 2089.41 | 2089.69 | 2087.73 | 2088.29 | 117.0 |
| 2008-07-24 00:30:00 | NQ | Futures | 2088.01 | 2091.94 | 2087.73 | 2091.1 | 139.0 |
| 2008-07-24 01:00:00 | NQ | Futures | 2089.69 | 2092.51 | 2089.13 | 2089.41 | 292.0 |
> showing 50 of 2,255 rows — these rows as CSV