PREVIEW / futures_30min / 2008-01-17
file: by_date/futures_30min/2008/2008-01-17.parquet size: 47 KB rows: 1,447
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-17 00:00:00 | ES | Futures | 1288.42 | 1289.59 | 1288.19 | 1289.59 | 1028.0 |
| 2008-01-17 00:30:00 | ES | Futures | 1289.59 | 1290.99 | 1289.35 | 1290.75 | 3623.0 |
| 2008-01-17 01:00:00 | ES | Futures | 1290.75 | 1291.45 | 1290.29 | 1290.52 | 1747.0 |
| 2008-01-17 01:30:00 | ES | Futures | 1290.52 | 1291.69 | 1290.29 | 1291.45 | 1336.0 |
| 2008-01-17 02:00:00 | ES | Futures | 1291.45 | 1293.32 | 1291.22 | 1292.62 | 4491.0 |
| 2008-01-17 02:30:00 | ES | Futures | 1292.62 | 1294.48 | 1292.62 | 1294.02 | 6670.0 |
| 2008-01-17 03:00:00 | ES | Futures | 1294.25 | 1295.65 | 1293.08 | 1294.72 | 8322.0 |
| 2008-01-17 03:30:00 | ES | Futures | 1294.72 | 1295.18 | 1290.52 | 1290.99 | 9086.0 |
| 2008-01-17 04:00:00 | ES | Futures | 1290.99 | 1293.32 | 1290.05 | 1290.99 | 7604.0 |
| 2008-01-17 04:30:00 | ES | Futures | 1290.99 | 1290.99 | 1288.89 | 1290.05 | 8685.0 |
| 2008-01-17 05:00:00 | ES | Futures | 1290.05 | 1290.52 | 1288.89 | 1289.59 | 4691.0 |
| 2008-01-17 05:30:00 | ES | Futures | 1289.82 | 1290.75 | 1287.49 | 1288.89 | 6478.0 |
| 2008-01-17 06:00:00 | ES | Futures | 1288.65 | 1289.59 | 1287.02 | 1288.89 | 7232.0 |
| 2008-01-17 06:30:00 | ES | Futures | 1289.12 | 1289.82 | 1287.95 | 1287.95 | 6185.0 |
| 2008-01-17 07:00:00 | ES | Futures | 1287.95 | 1289.35 | 1276.76 | 1279.09 | 54853.0 |
| 2008-01-17 07:30:00 | ES | Futures | 1278.86 | 1283.06 | 1277.23 | 1281.89 | 27318.0 |
| 2008-01-17 08:00:00 | ES | Futures | 1282.13 | 1282.59 | 1278.4 | 1279.56 | 26275.0 |
| 2008-01-17 08:30:00 | ES | Futures | 1279.56 | 1291.69 | 1277.93 | 1290.99 | 92356.0 |
| 2008-01-17 09:00:00 | ES | Futures | 1290.99 | 1292.38 | 1288.19 | 1288.19 | 40164.0 |
| 2008-01-17 09:30:00 | ES | Futures | 1288.42 | 1289.35 | 1283.52 | 1287.72 | 189395.0 |
| 2008-01-17 10:00:00 | ES | Futures | 1287.72 | 1288.19 | 1270.47 | 1273.73 | 403467.0 |
| 2008-01-17 10:30:00 | ES | Futures | 1273.5 | 1276.53 | 1266.97 | 1273.27 | 282048.0 |
| 2008-01-17 11:00:00 | ES | Futures | 1273.27 | 1277.23 | 1269.07 | 1270.93 | 156927.0 |
| 2008-01-17 11:30:00 | ES | Futures | 1270.7 | 1272.33 | 1263.71 | 1264.41 | 179324.0 |
| 2008-01-17 12:00:00 | ES | Futures | 1264.41 | 1265.11 | 1259.28 | 1264.17 | 195647.0 |
| 2008-01-17 12:30:00 | ES | Futures | 1264.41 | 1267.67 | 1263.71 | 1264.64 | 135527.0 |
| 2008-01-17 13:00:00 | ES | Futures | 1264.64 | 1270.0 | 1261.37 | 1266.97 | 123161.0 |
| 2008-01-17 13:30:00 | ES | Futures | 1266.97 | 1270.93 | 1263.71 | 1265.34 | 114523.0 |
| 2008-01-17 14:00:00 | ES | Futures | 1265.34 | 1266.74 | 1257.18 | 1257.64 | 168154.0 |
| 2008-01-17 14:30:00 | ES | Futures | 1257.41 | 1262.31 | 1253.91 | 1259.74 | 247540.0 |
| 2008-01-17 15:00:00 | ES | Futures | 1259.51 | 1264.17 | 1250.65 | 1250.88 | 251224.0 |
| 2008-01-17 15:30:00 | ES | Futures | 1250.88 | 1252.28 | 1244.12 | 1246.92 | 420570.0 |
| 2008-01-17 16:00:00 | ES | Futures | 1246.92 | 1250.42 | 1246.45 | 1249.48 | 160640.0 |
| 2008-01-17 16:30:00 | ES | Futures | 1250.42 | 1252.28 | 1250.42 | 1252.05 | 13702.0 |
| 2008-01-17 17:00:00 | ES | Futures | 1252.05 | 1252.51 | 1251.82 | 1251.82 | 3559.0 |
| 2008-01-17 18:00:00 | ES | Futures | 1251.82 | 1255.31 | 1251.35 | 1254.38 | 9046.0 |
| 2008-01-17 18:30:00 | ES | Futures | 1254.38 | 1255.78 | 1253.91 | 1254.61 | 3606.0 |
| 2008-01-17 19:00:00 | ES | Futures | 1254.61 | 1255.08 | 1253.21 | 1253.68 | 2967.0 |
| 2008-01-17 19:30:00 | ES | Futures | 1253.91 | 1255.78 | 1253.45 | 1254.85 | 2891.0 |
| 2008-01-17 20:00:00 | ES | Futures | 1254.85 | 1254.85 | 1253.91 | 1254.38 | 1055.0 |
| 2008-01-17 20:30:00 | ES | Futures | 1254.38 | 1255.08 | 1254.15 | 1254.61 | 953.0 |
| 2008-01-17 21:00:00 | ES | Futures | 1254.61 | 1255.78 | 1254.38 | 1255.31 | 1311.0 |
| 2008-01-17 21:30:00 | ES | Futures | 1255.08 | 1255.55 | 1253.91 | 1254.85 | 2135.0 |
| 2008-01-17 22:00:00 | ES | Futures | 1254.85 | 1255.31 | 1254.61 | 1254.85 | 952.0 |
| 2008-01-17 22:30:00 | ES | Futures | 1255.31 | 1257.18 | 1254.85 | 1256.71 | 2387.0 |
| 2008-01-17 23:00:00 | ES | Futures | 1256.71 | 1258.11 | 1256.71 | 1258.11 | 1685.0 |
| 2008-01-17 23:30:00 | ES | Futures | 1258.11 | 1258.11 | 1257.18 | 1257.88 | 1719.0 |
| 2008-01-17 00:00:00 | NQ | Futures | 2141.88 | 2144.72 | 2141.88 | 2144.44 | 117.0 |
| 2008-01-17 00:30:00 | NQ | Futures | 2144.44 | 2146.71 | 2143.87 | 2146.43 | 120.0 |
| 2008-01-17 01:00:00 | NQ | Futures | 2146.14 | 2148.13 | 2146.14 | 2147.85 | 63.0 |
> showing 50 of 1,447 rows — these rows as CSV