PREVIEW / futures_30min / 2008-06-24
file: by_date/futures_30min/2008/2008-06-24.parquet size: 64 KB rows: 2,180
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-24 00:00:00 | ES | Futures | 1225.29 | 1225.53 | 1224.83 | 1224.83 | 185.0 |
| 2008-06-24 00:30:00 | ES | Futures | 1225.06 | 1227.39 | 1225.06 | 1227.15 | 1581.0 |
| 2008-06-24 01:00:00 | ES | Futures | 1227.39 | 1227.85 | 1226.92 | 1227.62 | 1360.0 |
| 2008-06-24 01:30:00 | ES | Futures | 1227.85 | 1227.85 | 1226.92 | 1227.62 | 570.0 |
| 2008-06-24 02:00:00 | ES | Futures | 1227.62 | 1229.01 | 1227.15 | 1227.62 | 2802.0 |
| 2008-06-24 02:30:00 | ES | Futures | 1227.62 | 1228.08 | 1226.46 | 1227.15 | 1356.0 |
| 2008-06-24 03:00:00 | ES | Futures | 1227.15 | 1229.48 | 1226.69 | 1229.01 | 6739.0 |
| 2008-06-24 03:30:00 | ES | Futures | 1229.01 | 1229.24 | 1226.92 | 1227.39 | 4770.0 |
| 2008-06-24 04:00:00 | ES | Futures | 1227.62 | 1228.08 | 1225.76 | 1226.46 | 3843.0 |
| 2008-06-24 04:30:00 | ES | Futures | 1226.22 | 1226.69 | 1225.06 | 1225.99 | 3163.0 |
| 2008-06-24 05:00:00 | ES | Futures | 1226.22 | 1226.22 | 1221.11 | 1221.11 | 12425.0 |
| 2008-06-24 05:30:00 | ES | Futures | 1221.11 | 1221.34 | 1215.3 | 1218.55 | 28635.0 |
| 2008-06-24 06:00:00 | ES | Futures | 1218.79 | 1219.72 | 1217.62 | 1219.25 | 7937.0 |
| 2008-06-24 06:30:00 | ES | Futures | 1219.48 | 1219.95 | 1218.32 | 1219.02 | 7162.0 |
| 2008-06-24 07:00:00 | ES | Futures | 1219.02 | 1219.25 | 1216.69 | 1216.69 | 15191.0 |
| 2008-06-24 07:30:00 | ES | Futures | 1216.93 | 1219.48 | 1216.46 | 1218.55 | 12150.0 |
| 2008-06-24 08:00:00 | ES | Futures | 1218.55 | 1219.72 | 1217.39 | 1218.09 | 12738.0 |
| 2008-06-24 08:30:00 | ES | Futures | 1218.09 | 1220.18 | 1218.09 | 1219.48 | 13856.0 |
| 2008-06-24 09:00:00 | ES | Futures | 1219.48 | 1222.27 | 1219.48 | 1221.58 | 33223.0 |
| 2008-06-24 09:30:00 | ES | Futures | 1221.58 | 1224.36 | 1216.46 | 1216.46 | 218714.0 |
| 2008-06-24 10:00:00 | ES | Futures | 1216.46 | 1218.55 | 1213.44 | 1217.16 | 210326.0 |
| 2008-06-24 10:30:00 | ES | Futures | 1217.39 | 1223.9 | 1214.84 | 1223.43 | 210201.0 |
| 2008-06-24 11:00:00 | ES | Futures | 1223.43 | 1228.78 | 1222.97 | 1226.46 | 197027.0 |
| 2008-06-24 11:30:00 | ES | Futures | 1226.46 | 1231.1 | 1225.06 | 1229.71 | 156813.0 |
| 2008-06-24 12:00:00 | ES | Futures | 1229.71 | 1233.66 | 1228.55 | 1233.2 | 135928.0 |
| 2008-06-24 12:30:00 | ES | Futures | 1232.96 | 1233.89 | 1229.71 | 1229.94 | 75127.0 |
| 2008-06-24 13:00:00 | ES | Futures | 1230.17 | 1232.5 | 1229.48 | 1230.41 | 85336.0 |
| 2008-06-24 13:30:00 | ES | Futures | 1230.41 | 1231.8 | 1228.08 | 1231.1 | 85743.0 |
| 2008-06-24 14:00:00 | ES | Futures | 1231.1 | 1234.59 | 1230.41 | 1230.87 | 106510.0 |
| 2008-06-24 14:30:00 | ES | Futures | 1231.1 | 1231.34 | 1225.53 | 1227.39 | 103480.0 |
| 2008-06-24 15:00:00 | ES | Futures | 1227.15 | 1228.55 | 1222.5 | 1223.67 | 125593.0 |
| 2008-06-24 15:30:00 | ES | Futures | 1223.9 | 1224.83 | 1220.65 | 1223.43 | 138898.0 |
| 2008-06-24 16:00:00 | ES | Futures | 1223.43 | 1223.9 | 1221.81 | 1222.27 | 68244.0 |
| 2008-06-24 16:30:00 | ES | Futures | 1222.5 | 1223.67 | 1222.04 | 1223.43 | 3948.0 |
| 2008-06-24 17:00:00 | ES | Futures | 1223.43 | 1223.43 | 1222.27 | 1223.43 | 1168.0 |
| 2008-06-24 18:00:00 | ES | Futures | 1223.2 | 1223.67 | 1222.97 | 1223.43 | 723.0 |
| 2008-06-24 18:30:00 | ES | Futures | 1223.43 | 1223.9 | 1223.2 | 1223.2 | 412.0 |
| 2008-06-24 19:00:00 | ES | Futures | 1223.2 | 1223.43 | 1222.97 | 1223.2 | 154.0 |
| 2008-06-24 19:30:00 | ES | Futures | 1223.2 | 1223.67 | 1222.97 | 1223.67 | 435.0 |
| 2008-06-24 20:00:00 | ES | Futures | 1223.43 | 1224.6 | 1223.2 | 1224.36 | 787.0 |
| 2008-06-24 20:30:00 | ES | Futures | 1224.6 | 1224.6 | 1223.67 | 1224.13 | 387.0 |
| 2008-06-24 21:00:00 | ES | Futures | 1224.36 | 1224.36 | 1223.9 | 1224.13 | 94.0 |
| 2008-06-24 21:30:00 | ES | Futures | 1224.13 | 1224.13 | 1222.27 | 1222.74 | 805.0 |
| 2008-06-24 22:00:00 | ES | Futures | 1222.97 | 1223.43 | 1222.97 | 1223.2 | 500.0 |
| 2008-06-24 22:30:00 | ES | Futures | 1223.43 | 1223.43 | 1222.74 | 1223.43 | 258.0 |
| 2008-06-24 23:00:00 | ES | Futures | 1223.43 | 1224.13 | 1223.2 | 1223.2 | 344.0 |
| 2008-06-24 23:30:00 | ES | Futures | 1223.43 | 1224.13 | 1223.2 | 1223.43 | 295.0 |
| 2008-06-24 00:00:00 | NQ | Futures | 2156.92 | 2158.33 | 2156.92 | 2157.77 | 14.0 |
| 2008-06-24 00:30:00 | NQ | Futures | 2158.33 | 2160.3 | 2157.77 | 2160.02 | 289.0 |
| 2008-06-24 01:00:00 | NQ | Futures | 2160.02 | 2160.02 | 2159.74 | 2160.02 | 271.0 |
> showing 50 of 2,180 rows — these rows as CSV