PREVIEW / futures_30min / 2008-01-23
file: by_date/futures_30min/2008/2008-01-23.parquet size: 50 KB rows: 1,477
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-01-23 00:00:00 | ES | Futures | 1205.88 | 1209.38 | 1205.42 | 1209.38 | 1654.0 |
| 2008-01-23 00:30:00 | ES | Futures | 1209.38 | 1210.31 | 1208.22 | 1209.85 | 758.0 |
| 2008-01-23 01:00:00 | ES | Futures | 1209.61 | 1211.25 | 1207.52 | 1210.55 | 1138.0 |
| 2008-01-23 01:30:00 | ES | Futures | 1210.78 | 1216.14 | 1210.31 | 1214.98 | 3991.0 |
| 2008-01-23 02:00:00 | ES | Futures | 1214.98 | 1218.01 | 1211.71 | 1217.31 | 6997.0 |
| 2008-01-23 02:30:00 | ES | Futures | 1217.08 | 1224.54 | 1216.14 | 1224.07 | 11589.0 |
| 2008-01-23 03:00:00 | ES | Futures | 1224.07 | 1229.9 | 1220.81 | 1220.81 | 23493.0 |
| 2008-01-23 03:30:00 | ES | Futures | 1220.81 | 1224.3 | 1218.01 | 1219.87 | 14522.0 |
| 2008-01-23 04:00:00 | ES | Futures | 1219.87 | 1220.34 | 1212.41 | 1212.41 | 23604.0 |
| 2008-01-23 04:30:00 | ES | Futures | 1212.88 | 1214.51 | 1208.22 | 1214.04 | 21428.0 |
| 2008-01-23 05:00:00 | ES | Futures | 1214.04 | 1216.84 | 1209.61 | 1211.01 | 13243.0 |
| 2008-01-23 05:30:00 | ES | Futures | 1210.78 | 1214.04 | 1204.48 | 1208.45 | 18938.0 |
| 2008-01-23 06:00:00 | ES | Futures | 1208.68 | 1210.78 | 1197.26 | 1198.19 | 34924.0 |
| 2008-01-23 06:30:00 | ES | Futures | 1198.19 | 1203.55 | 1196.32 | 1202.39 | 28795.0 |
| 2008-01-23 07:00:00 | ES | Futures | 1202.62 | 1207.52 | 1200.29 | 1205.65 | 22983.0 |
| 2008-01-23 07:30:00 | ES | Futures | 1205.42 | 1207.52 | 1196.56 | 1198.66 | 30741.0 |
| 2008-01-23 08:00:00 | ES | Futures | 1198.66 | 1202.85 | 1185.37 | 1189.56 | 85663.0 |
| 2008-01-23 08:30:00 | ES | Futures | 1189.33 | 1191.89 | 1176.04 | 1186.53 | 110939.0 |
| 2008-01-23 09:00:00 | ES | Futures | 1186.76 | 1193.53 | 1185.13 | 1188.16 | 68723.0 |
| 2008-01-23 09:30:00 | ES | Futures | 1188.16 | 1209.15 | 1186.3 | 1206.82 | 386927.0 |
| 2008-01-23 10:00:00 | ES | Futures | 1207.05 | 1222.67 | 1205.88 | 1214.28 | 385076.0 |
| 2008-01-23 10:30:00 | ES | Futures | 1214.28 | 1215.68 | 1204.25 | 1210.78 | 267046.0 |
| 2008-01-23 11:00:00 | ES | Futures | 1210.78 | 1214.28 | 1206.35 | 1207.52 | 172312.0 |
| 2008-01-23 11:30:00 | ES | Futures | 1207.75 | 1207.75 | 1197.96 | 1200.29 | 213334.0 |
| 2008-01-23 12:00:00 | ES | Futures | 1200.05 | 1205.42 | 1196.09 | 1202.85 | 175030.0 |
| 2008-01-23 12:30:00 | ES | Futures | 1202.62 | 1203.09 | 1184.43 | 1192.13 | 209419.0 |
| 2008-01-23 13:00:00 | ES | Futures | 1192.13 | 1202.62 | 1188.63 | 1199.59 | 182154.0 |
| 2008-01-23 13:30:00 | ES | Futures | 1199.59 | 1210.31 | 1194.23 | 1206.82 | 208061.0 |
| 2008-01-23 14:00:00 | ES | Futures | 1207.05 | 1221.04 | 1203.55 | 1219.41 | 215048.0 |
| 2008-01-23 14:30:00 | ES | Futures | 1219.41 | 1219.87 | 1206.82 | 1215.68 | 203840.0 |
| 2008-01-23 15:00:00 | ES | Futures | 1215.68 | 1241.79 | 1214.04 | 1239.92 | 370026.0 |
| 2008-01-23 15:30:00 | ES | Futures | 1239.92 | 1251.58 | 1239.23 | 1250.42 | 388131.0 |
| 2008-01-23 16:00:00 | ES | Futures | 1250.42 | 1253.91 | 1249.25 | 1251.58 | 128066.0 |
| 2008-01-23 16:30:00 | ES | Futures | 1251.82 | 1259.98 | 1250.65 | 1252.75 | 18795.0 |
| 2008-01-23 17:00:00 | ES | Futures | 1252.98 | 1255.31 | 1252.98 | 1254.38 | 3159.0 |
| 2008-01-23 18:00:00 | ES | Futures | 1255.78 | 1258.34 | 1255.31 | 1256.01 | 4923.0 |
| 2008-01-23 18:30:00 | ES | Futures | 1256.01 | 1256.01 | 1252.51 | 1253.21 | 4663.0 |
| 2008-01-23 19:00:00 | ES | Futures | 1253.21 | 1254.15 | 1252.51 | 1253.68 | 3181.0 |
| 2008-01-23 19:30:00 | ES | Futures | 1253.68 | 1254.38 | 1252.51 | 1253.68 | 3602.0 |
| 2008-01-23 20:00:00 | ES | Futures | 1253.91 | 1254.61 | 1253.21 | 1253.45 | 816.0 |
| 2008-01-23 20:30:00 | ES | Futures | 1253.68 | 1254.38 | 1252.51 | 1252.75 | 1658.0 |
| 2008-01-23 21:00:00 | ES | Futures | 1252.51 | 1252.75 | 1249.25 | 1251.58 | 3805.0 |
| 2008-01-23 21:30:00 | ES | Futures | 1251.35 | 1253.21 | 1249.02 | 1249.48 | 3109.0 |
| 2008-01-23 22:00:00 | ES | Futures | 1249.25 | 1250.65 | 1248.78 | 1250.18 | 1767.0 |
| 2008-01-23 22:30:00 | ES | Futures | 1250.42 | 1254.15 | 1250.18 | 1253.45 | 1738.0 |
| 2008-01-23 23:00:00 | ES | Futures | 1253.45 | 1256.94 | 1253.45 | 1256.25 | 3291.0 |
| 2008-01-23 23:30:00 | ES | Futures | 1256.25 | 1257.64 | 1255.08 | 1257.41 | 1760.0 |
| 2008-01-23 00:00:00 | NQ | Futures | 2002.8 | 2011.6 | 2002.8 | 2008.19 | 385.0 |
| 2008-01-23 00:30:00 | NQ | Futures | 2007.63 | 2009.05 | 2005.64 | 2006.49 | 222.0 |
| 2008-01-23 01:00:00 | NQ | Futures | 2007.06 | 2008.48 | 2004.5 | 2007.91 | 199.0 |
> showing 50 of 1,477 rows — these rows as CSV