PREVIEW / futures_30min / 2008-06-30
file: by_date/futures_30min/2008/2008-06-30.parquet size: 66 KB rows: 2,175
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-06-30 00:00:00 | ES | Futures | 1192.06 | 1192.52 | 1191.83 | 1192.06 | 317.0 |
| 2008-06-30 00:30:00 | ES | Futures | 1192.29 | 1192.76 | 1191.59 | 1191.83 | 757.0 |
| 2008-06-30 01:00:00 | ES | Futures | 1191.83 | 1192.29 | 1191.83 | 1192.06 | 379.0 |
| 2008-06-30 01:30:00 | ES | Futures | 1192.06 | 1192.29 | 1191.59 | 1192.06 | 1699.0 |
| 2008-06-30 02:00:00 | ES | Futures | 1192.29 | 1193.92 | 1191.59 | 1193.92 | 3227.0 |
| 2008-06-30 02:30:00 | ES | Futures | 1193.92 | 1194.61 | 1193.22 | 1193.69 | 2766.0 |
| 2008-06-30 03:00:00 | ES | Futures | 1193.69 | 1196.71 | 1193.45 | 1193.92 | 11387.0 |
| 2008-06-30 03:30:00 | ES | Futures | 1194.15 | 1194.85 | 1191.13 | 1192.06 | 9317.0 |
| 2008-06-30 04:00:00 | ES | Futures | 1192.06 | 1192.29 | 1190.2 | 1190.66 | 6081.0 |
| 2008-06-30 04:30:00 | ES | Futures | 1190.66 | 1192.06 | 1185.78 | 1187.41 | 20235.0 |
| 2008-06-30 05:00:00 | ES | Futures | 1187.18 | 1189.5 | 1186.25 | 1187.87 | 9489.0 |
| 2008-06-30 05:30:00 | ES | Futures | 1187.64 | 1189.5 | 1185.55 | 1189.27 | 8274.0 |
| 2008-06-30 06:00:00 | ES | Futures | 1189.27 | 1191.36 | 1188.57 | 1188.8 | 10105.0 |
| 2008-06-30 06:30:00 | ES | Futures | 1188.57 | 1190.43 | 1186.95 | 1189.27 | 12143.0 |
| 2008-06-30 07:00:00 | ES | Futures | 1189.27 | 1190.66 | 1188.8 | 1190.2 | 8662.0 |
| 2008-06-30 07:30:00 | ES | Futures | 1190.2 | 1190.66 | 1186.25 | 1186.71 | 12218.0 |
| 2008-06-30 08:00:00 | ES | Futures | 1186.71 | 1191.83 | 1186.25 | 1190.9 | 19483.0 |
| 2008-06-30 08:30:00 | ES | Futures | 1190.66 | 1191.83 | 1189.5 | 1191.83 | 24312.0 |
| 2008-06-30 09:00:00 | ES | Futures | 1191.83 | 1191.83 | 1189.73 | 1191.36 | 19501.0 |
| 2008-06-30 09:30:00 | ES | Futures | 1191.36 | 1195.31 | 1188.34 | 1188.34 | 211937.0 |
| 2008-06-30 10:00:00 | ES | Futures | 1188.34 | 1194.38 | 1185.55 | 1193.69 | 212265.0 |
| 2008-06-30 10:30:00 | ES | Futures | 1193.69 | 1197.64 | 1191.59 | 1197.4 | 163589.0 |
| 2008-06-30 11:00:00 | ES | Futures | 1197.4 | 1200.43 | 1194.85 | 1200.19 | 170701.0 |
| 2008-06-30 11:30:00 | ES | Futures | 1199.96 | 1200.43 | 1195.78 | 1197.87 | 119428.0 |
| 2008-06-30 12:00:00 | ES | Futures | 1198.1 | 1200.43 | 1196.47 | 1199.73 | 101219.0 |
| 2008-06-30 12:30:00 | ES | Futures | 1199.5 | 1201.12 | 1197.17 | 1197.87 | 81379.0 |
| 2008-06-30 13:00:00 | ES | Futures | 1197.87 | 1198.8 | 1196.01 | 1196.24 | 83208.0 |
| 2008-06-30 13:30:00 | ES | Futures | 1196.24 | 1196.71 | 1191.13 | 1193.69 | 123927.0 |
| 2008-06-30 14:00:00 | ES | Futures | 1193.69 | 1196.71 | 1192.29 | 1196.01 | 102678.0 |
| 2008-06-30 14:30:00 | ES | Futures | 1196.01 | 1196.24 | 1192.76 | 1194.15 | 80202.0 |
| 2008-06-30 15:00:00 | ES | Futures | 1194.38 | 1198.1 | 1194.15 | 1196.94 | 78872.0 |
| 2008-06-30 15:30:00 | ES | Futures | 1196.94 | 1198.33 | 1189.27 | 1190.66 | 293805.0 |
| 2008-06-30 16:00:00 | ES | Futures | 1190.66 | 1192.99 | 1189.04 | 1192.76 | 142447.0 |
| 2008-06-30 16:30:00 | ES | Futures | 1192.76 | 1195.31 | 1192.76 | 1194.15 | 5609.0 |
| 2008-06-30 17:00:00 | ES | Futures | 1193.92 | 1194.38 | 1192.99 | 1193.22 | 1688.0 |
| 2008-06-30 18:00:00 | ES | Futures | 1193.22 | 1193.69 | 1192.06 | 1193.22 | 3434.0 |
| 2008-06-30 18:30:00 | ES | Futures | 1193.22 | 1193.22 | 1192.76 | 1193.22 | 480.0 |
| 2008-06-30 19:00:00 | ES | Futures | 1193.22 | 1193.45 | 1192.76 | 1193.45 | 460.0 |
| 2008-06-30 19:30:00 | ES | Futures | 1193.69 | 1195.08 | 1193.45 | 1194.38 | 1480.0 |
| 2008-06-30 20:00:00 | ES | Futures | 1194.38 | 1195.08 | 1193.69 | 1194.38 | 1448.0 |
| 2008-06-30 20:30:00 | ES | Futures | 1194.38 | 1195.31 | 1194.38 | 1195.31 | 1414.0 |
| 2008-06-30 21:00:00 | ES | Futures | 1195.31 | 1195.54 | 1194.85 | 1195.31 | 253.0 |
| 2008-06-30 21:30:00 | ES | Futures | 1195.31 | 1195.54 | 1193.92 | 1195.54 | 1184.0 |
| 2008-06-30 22:00:00 | ES | Futures | 1195.54 | 1196.01 | 1195.08 | 1195.54 | 711.0 |
| 2008-06-30 22:30:00 | ES | Futures | 1195.78 | 1196.01 | 1193.92 | 1193.92 | 714.0 |
| 2008-06-30 23:00:00 | ES | Futures | 1194.15 | 1194.38 | 1193.22 | 1193.69 | 533.0 |
| 2008-06-30 23:30:00 | ES | Futures | 1193.69 | 1194.85 | 1193.22 | 1194.61 | 392.0 |
| 2008-06-30 00:00:00 | NQ | Futures | 2100.66 | 2102.07 | 2100.1 | 2100.1 | 42.0 |
| 2008-06-30 00:30:00 | NQ | Futures | 2101.23 | 2102.07 | 2100.1 | 2100.1 | 13.0 |
| 2008-06-30 01:00:00 | NQ | Futures | 2100.38 | 2100.38 | 2100.38 | 2100.38 | 3.0 |
> showing 50 of 2,175 rows — these rows as CSV