PREVIEW / futures_30min / 2008-06-26
file: by_date/futures_30min/2008/2008-06-26.parquet size: 69 KB rows: 2,249
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-26 00:00:00 | ES | Futures | 1226.69 | 1227.15 | 1226.46 | 1226.92 | 356.0 |
| 2008-06-26 00:30:00 | ES | Futures | 1226.69 | 1227.39 | 1225.76 | 1226.92 | 683.0 |
| 2008-06-26 01:00:00 | ES | Futures | 1226.92 | 1227.39 | 1225.53 | 1225.99 | 673.0 |
| 2008-06-26 01:30:00 | ES | Futures | 1225.99 | 1226.69 | 1224.6 | 1225.29 | 1422.0 |
| 2008-06-26 02:00:00 | ES | Futures | 1225.06 | 1225.76 | 1224.13 | 1225.29 | 2390.0 |
| 2008-06-26 02:30:00 | ES | Futures | 1224.83 | 1225.53 | 1224.13 | 1225.06 | 2880.0 |
| 2008-06-26 03:00:00 | ES | Futures | 1225.06 | 1225.99 | 1223.2 | 1223.9 | 7988.0 |
| 2008-06-26 03:30:00 | ES | Futures | 1223.67 | 1225.99 | 1222.74 | 1225.53 | 6216.0 |
| 2008-06-26 04:00:00 | ES | Futures | 1225.29 | 1225.76 | 1222.74 | 1222.97 | 6261.0 |
| 2008-06-26 04:30:00 | ES | Futures | 1222.97 | 1223.9 | 1222.5 | 1223.2 | 5448.0 |
| 2008-06-26 05:00:00 | ES | Futures | 1223.43 | 1223.9 | 1222.04 | 1222.5 | 7363.0 |
| 2008-06-26 05:30:00 | ES | Futures | 1222.5 | 1222.97 | 1220.88 | 1222.04 | 7973.0 |
| 2008-06-26 06:00:00 | ES | Futures | 1222.04 | 1223.2 | 1221.58 | 1222.04 | 5018.0 |
| 2008-06-26 06:30:00 | ES | Futures | 1222.04 | 1224.83 | 1221.81 | 1223.9 | 9922.0 |
| 2008-06-26 07:00:00 | ES | Futures | 1224.13 | 1225.29 | 1223.43 | 1223.9 | 7423.0 |
| 2008-06-26 07:30:00 | ES | Futures | 1223.9 | 1224.13 | 1216.23 | 1217.62 | 50340.0 |
| 2008-06-26 08:00:00 | ES | Futures | 1217.86 | 1218.55 | 1216.69 | 1218.09 | 29762.0 |
| 2008-06-26 08:30:00 | ES | Futures | 1217.86 | 1218.09 | 1214.37 | 1216.23 | 47741.0 |
| 2008-06-26 09:00:00 | ES | Futures | 1216.0 | 1216.93 | 1213.44 | 1216.69 | 39616.0 |
| 2008-06-26 09:30:00 | ES | Futures | 1216.69 | 1217.62 | 1212.98 | 1215.76 | 216412.0 |
| 2008-06-26 10:00:00 | ES | Futures | 1215.76 | 1218.09 | 1211.81 | 1215.76 | 225745.0 |
| 2008-06-26 10:30:00 | ES | Futures | 1215.76 | 1216.0 | 1206.47 | 1206.7 | 265089.0 |
| 2008-06-26 11:00:00 | ES | Futures | 1206.7 | 1209.49 | 1205.07 | 1206.47 | 206055.0 |
| 2008-06-26 11:30:00 | ES | Futures | 1206.24 | 1210.19 | 1206.0 | 1209.02 | 120952.0 |
| 2008-06-26 12:00:00 | ES | Futures | 1209.02 | 1209.02 | 1203.91 | 1204.38 | 134939.0 |
| 2008-06-26 12:30:00 | ES | Futures | 1204.14 | 1204.61 | 1201.59 | 1203.68 | 131600.0 |
| 2008-06-26 13:00:00 | ES | Futures | 1203.45 | 1205.77 | 1200.43 | 1201.12 | 100416.0 |
| 2008-06-26 13:30:00 | ES | Futures | 1201.12 | 1206.0 | 1200.66 | 1204.84 | 86709.0 |
| 2008-06-26 14:00:00 | ES | Futures | 1204.84 | 1206.93 | 1199.73 | 1201.82 | 161852.0 |
| 2008-06-26 14:30:00 | ES | Futures | 1202.05 | 1202.75 | 1196.71 | 1197.64 | 157658.0 |
| 2008-06-26 15:00:00 | ES | Futures | 1197.64 | 1202.05 | 1197.17 | 1200.66 | 144163.0 |
| 2008-06-26 15:30:00 | ES | Futures | 1200.66 | 1202.28 | 1193.69 | 1194.15 | 283890.0 |
| 2008-06-26 16:00:00 | ES | Futures | 1194.15 | 1195.78 | 1192.76 | 1194.15 | 137660.0 |
| 2008-06-26 16:30:00 | ES | Futures | 1194.61 | 1195.31 | 1193.45 | 1194.38 | 7565.0 |
| 2008-06-26 17:00:00 | ES | Futures | 1194.38 | 1196.01 | 1194.15 | 1195.08 | 4735.0 |
| 2008-06-26 18:00:00 | ES | Futures | 1195.31 | 1195.78 | 1195.08 | 1195.78 | 2706.0 |
| 2008-06-26 18:30:00 | ES | Futures | 1195.54 | 1196.01 | 1195.31 | 1195.54 | 864.0 |
| 2008-06-26 19:00:00 | ES | Futures | 1195.54 | 1195.78 | 1195.31 | 1195.78 | 343.0 |
| 2008-06-26 19:30:00 | ES | Futures | 1195.78 | 1195.78 | 1194.38 | 1194.38 | 710.0 |
| 2008-06-26 20:00:00 | ES | Futures | 1194.38 | 1194.85 | 1193.92 | 1194.85 | 1064.0 |
| 2008-06-26 20:30:00 | ES | Futures | 1194.85 | 1195.54 | 1194.38 | 1194.85 | 824.0 |
| 2008-06-26 21:00:00 | ES | Futures | 1194.61 | 1195.78 | 1194.61 | 1195.31 | 949.0 |
| 2008-06-26 21:30:00 | ES | Futures | 1195.31 | 1196.47 | 1195.08 | 1196.47 | 1288.0 |
| 2008-06-26 22:00:00 | ES | Futures | 1196.47 | 1196.94 | 1196.01 | 1196.71 | 1609.0 |
| 2008-06-26 22:30:00 | ES | Futures | 1196.71 | 1197.4 | 1196.01 | 1196.24 | 582.0 |
| 2008-06-26 23:00:00 | ES | Futures | 1196.01 | 1196.94 | 1196.01 | 1196.47 | 280.0 |
| 2008-06-26 23:30:00 | ES | Futures | 1196.47 | 1197.17 | 1196.24 | 1196.71 | 388.0 |
| 2008-06-26 00:00:00 | NQ | Futures | 2165.92 | 2167.61 | 2165.64 | 2165.64 | 156.0 |
| 2008-06-26 00:30:00 | NQ | Futures | 2165.64 | 2167.61 | 2165.64 | 2167.61 | 15.0 |
| 2008-06-26 01:00:00 | NQ | Futures | 2167.33 | 2167.33 | 2163.67 | 2163.95 | 25.0 |
> showing 50 of 2,249 rows — these rows as CSV