PREVIEW / futures_30min / 2008-08-28
file: by_date/futures_30min/2008/2008-08-28.parquet size: 66 KB rows: 2,210
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-08-28 00:00:00 | ES | Futures | 1189.97 | 1189.97 | 1189.73 | 1189.97 | 296.0 |
| 2008-08-28 00:30:00 | ES | Futures | 1189.73 | 1189.97 | 1189.04 | 1189.5 | 1058.0 |
| 2008-08-28 01:00:00 | ES | Futures | 1189.5 | 1189.73 | 1189.04 | 1189.27 | 296.0 |
| 2008-08-28 01:30:00 | ES | Futures | 1189.5 | 1189.73 | 1189.04 | 1189.27 | 519.0 |
| 2008-08-28 02:00:00 | ES | Futures | 1189.27 | 1189.5 | 1188.11 | 1188.11 | 1654.0 |
| 2008-08-28 02:30:00 | ES | Futures | 1188.11 | 1188.57 | 1187.18 | 1187.41 | 2691.0 |
| 2008-08-28 03:00:00 | ES | Futures | 1187.41 | 1188.34 | 1186.25 | 1186.25 | 6091.0 |
| 2008-08-28 03:30:00 | ES | Futures | 1186.25 | 1187.64 | 1185.78 | 1186.95 | 5808.0 |
| 2008-08-28 04:00:00 | ES | Futures | 1186.71 | 1187.41 | 1186.02 | 1187.41 | 3431.0 |
| 2008-08-28 04:30:00 | ES | Futures | 1187.18 | 1189.04 | 1186.71 | 1188.34 | 5621.0 |
| 2008-08-28 05:00:00 | ES | Futures | 1188.11 | 1190.43 | 1188.11 | 1190.2 | 4621.0 |
| 2008-08-28 05:30:00 | ES | Futures | 1190.2 | 1191.36 | 1190.2 | 1191.13 | 5051.0 |
| 2008-08-28 06:00:00 | ES | Futures | 1191.36 | 1193.22 | 1190.9 | 1191.83 | 7069.0 |
| 2008-08-28 06:30:00 | ES | Futures | 1191.83 | 1192.52 | 1190.66 | 1191.13 | 3224.0 |
| 2008-08-28 07:00:00 | ES | Futures | 1191.13 | 1192.29 | 1190.66 | 1191.83 | 3298.0 |
| 2008-08-28 07:30:00 | ES | Futures | 1191.83 | 1192.76 | 1190.9 | 1191.59 | 4549.0 |
| 2008-08-28 08:00:00 | ES | Futures | 1191.59 | 1196.47 | 1190.66 | 1195.54 | 19017.0 |
| 2008-08-28 08:30:00 | ES | Futures | 1195.54 | 1201.12 | 1195.08 | 1200.19 | 67859.0 |
| 2008-08-28 09:00:00 | ES | Futures | 1200.19 | 1200.43 | 1197.87 | 1198.1 | 26939.0 |
| 2008-08-28 09:30:00 | ES | Futures | 1197.87 | 1201.12 | 1197.4 | 1199.5 | 181962.0 |
| 2008-08-28 10:00:00 | ES | Futures | 1199.5 | 1200.89 | 1197.64 | 1199.26 | 125335.0 |
| 2008-08-28 10:30:00 | ES | Futures | 1199.03 | 1202.52 | 1198.1 | 1201.35 | 139372.0 |
| 2008-08-28 11:00:00 | ES | Futures | 1201.59 | 1201.59 | 1199.5 | 1200.19 | 85689.0 |
| 2008-08-28 11:30:00 | ES | Futures | 1200.43 | 1205.54 | 1198.1 | 1204.84 | 146745.0 |
| 2008-08-28 12:00:00 | ES | Futures | 1204.61 | 1205.77 | 1203.68 | 1205.31 | 72875.0 |
| 2008-08-28 12:30:00 | ES | Futures | 1205.31 | 1205.77 | 1202.28 | 1203.91 | 62514.0 |
| 2008-08-28 13:00:00 | ES | Futures | 1204.14 | 1204.84 | 1202.75 | 1204.61 | 37448.0 |
| 2008-08-28 13:30:00 | ES | Futures | 1204.38 | 1206.7 | 1204.14 | 1205.31 | 58385.0 |
| 2008-08-28 14:00:00 | ES | Futures | 1205.07 | 1206.24 | 1202.52 | 1205.77 | 62646.0 |
| 2008-08-28 14:30:00 | ES | Futures | 1205.54 | 1207.63 | 1205.54 | 1206.0 | 61444.0 |
| 2008-08-28 15:00:00 | ES | Futures | 1206.0 | 1207.17 | 1204.38 | 1206.24 | 50213.0 |
| 2008-08-28 15:30:00 | ES | Futures | 1206.47 | 1208.56 | 1204.84 | 1208.1 | 126302.0 |
| 2008-08-28 16:00:00 | ES | Futures | 1207.86 | 1208.33 | 1206.24 | 1206.7 | 110427.0 |
| 2008-08-28 16:30:00 | ES | Futures | 1205.77 | 1206.7 | 1205.54 | 1206.47 | 3855.0 |
| 2008-08-28 17:00:00 | ES | Futures | 1206.47 | 1206.7 | 1206.0 | 1206.0 | 1049.0 |
| 2008-08-28 18:00:00 | ES | Futures | 1206.24 | 1206.7 | 1205.77 | 1206.47 | 749.0 |
| 2008-08-28 18:30:00 | ES | Futures | 1206.24 | 1206.47 | 1205.77 | 1205.77 | 361.0 |
| 2008-08-28 19:00:00 | ES | Futures | 1206.0 | 1206.0 | 1205.54 | 1205.77 | 144.0 |
| 2008-08-28 19:30:00 | ES | Futures | 1205.77 | 1205.77 | 1205.07 | 1205.31 | 741.0 |
| 2008-08-28 20:00:00 | ES | Futures | 1205.07 | 1205.31 | 1204.84 | 1204.84 | 1186.0 |
| 2008-08-28 20:30:00 | ES | Futures | 1204.84 | 1205.07 | 1204.14 | 1204.38 | 1859.0 |
| 2008-08-28 21:00:00 | ES | Futures | 1204.38 | 1204.84 | 1203.91 | 1204.38 | 1644.0 |
| 2008-08-28 21:30:00 | ES | Futures | 1204.38 | 1204.61 | 1203.91 | 1204.38 | 2105.0 |
| 2008-08-28 22:00:00 | ES | Futures | 1204.38 | 1204.84 | 1203.91 | 1204.61 | 1857.0 |
| 2008-08-28 22:30:00 | ES | Futures | 1204.38 | 1204.38 | 1203.45 | 1203.68 | 814.0 |
| 2008-08-28 23:00:00 | ES | Futures | 1203.68 | 1204.38 | 1203.68 | 1204.14 | 345.0 |
| 2008-08-28 23:30:00 | ES | Futures | 1204.14 | 1204.14 | 1203.68 | 1203.91 | 353.0 |
| 2008-08-28 00:00:00 | NQ | Futures | 2136.39 | 2136.39 | 2136.11 | 2136.11 | 24.0 |
| 2008-08-28 00:30:00 | NQ | Futures | 2135.54 | 2135.54 | 2133.86 | 2133.86 | 54.0 |
| 2008-08-28 01:00:00 | NQ | Futures | 2134.42 | 2134.98 | 2134.14 | 2134.7 | 18.0 |
> showing 50 of 2,210 rows — these rows as CSV