PREVIEW / futures_30min / 2008-01-31
file: by_date/futures_30min/2008/2008-01-31.parquet size: 47 KB rows: 1,517
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-31 00:00:00 | ES | Futures | 1252.98 | 1253.68 | 1250.42 | 1253.45 | 2259.0 |
| 2008-01-31 00:30:00 | ES | Futures | 1253.68 | 1255.31 | 1253.45 | 1254.61 | 1214.0 |
| 2008-01-31 01:00:00 | ES | Futures | 1254.38 | 1256.01 | 1253.21 | 1255.78 | 1784.0 |
| 2008-01-31 01:30:00 | ES | Futures | 1255.78 | 1256.48 | 1254.38 | 1255.31 | 1715.0 |
| 2008-01-31 02:00:00 | ES | Futures | 1255.55 | 1260.91 | 1255.31 | 1260.44 | 11119.0 |
| 2008-01-31 02:30:00 | ES | Futures | 1260.44 | 1261.37 | 1256.71 | 1259.51 | 9738.0 |
| 2008-01-31 03:00:00 | ES | Futures | 1259.74 | 1263.71 | 1259.51 | 1260.68 | 14062.0 |
| 2008-01-31 03:30:00 | ES | Futures | 1260.91 | 1261.61 | 1253.91 | 1255.31 | 17568.0 |
| 2008-01-31 04:00:00 | ES | Futures | 1255.55 | 1255.55 | 1250.65 | 1253.68 | 21200.0 |
| 2008-01-31 04:30:00 | ES | Futures | 1253.68 | 1257.18 | 1252.98 | 1256.94 | 9189.0 |
| 2008-01-31 05:00:00 | ES | Futures | 1256.94 | 1259.04 | 1254.61 | 1258.34 | 11281.0 |
| 2008-01-31 05:30:00 | ES | Futures | 1258.34 | 1259.98 | 1254.38 | 1255.78 | 11705.0 |
| 2008-01-31 06:00:00 | ES | Futures | 1255.78 | 1256.01 | 1251.82 | 1253.21 | 10260.0 |
| 2008-01-31 06:30:00 | ES | Futures | 1253.21 | 1256.94 | 1253.21 | 1256.25 | 16396.0 |
| 2008-01-31 07:00:00 | ES | Futures | 1256.25 | 1257.41 | 1253.68 | 1254.85 | 18267.0 |
| 2008-01-31 07:30:00 | ES | Futures | 1255.08 | 1256.94 | 1253.45 | 1256.01 | 16248.0 |
| 2008-01-31 08:00:00 | ES | Futures | 1256.01 | 1256.48 | 1253.45 | 1253.68 | 15578.0 |
| 2008-01-31 08:30:00 | ES | Futures | 1253.68 | 1253.91 | 1241.79 | 1243.42 | 105756.0 |
| 2008-01-31 09:00:00 | ES | Futures | 1243.42 | 1247.62 | 1243.19 | 1245.29 | 33365.0 |
| 2008-01-31 09:30:00 | ES | Futures | 1245.52 | 1255.78 | 1243.19 | 1254.61 | 244473.0 |
| 2008-01-31 10:00:00 | ES | Futures | 1254.61 | 1259.28 | 1250.88 | 1259.04 | 240943.0 |
| 2008-01-31 10:30:00 | ES | Futures | 1259.04 | 1262.54 | 1253.91 | 1262.07 | 177579.0 |
| 2008-01-31 11:00:00 | ES | Futures | 1262.07 | 1271.63 | 1258.11 | 1270.0 | 221653.0 |
| 2008-01-31 11:30:00 | ES | Futures | 1270.23 | 1283.76 | 1266.5 | 1277.46 | 303881.0 |
| 2008-01-31 12:00:00 | ES | Futures | 1277.46 | 1278.4 | 1270.23 | 1273.73 | 168313.0 |
| 2008-01-31 12:30:00 | ES | Futures | 1273.73 | 1275.83 | 1268.14 | 1271.17 | 104921.0 |
| 2008-01-31 13:00:00 | ES | Futures | 1271.17 | 1274.2 | 1268.84 | 1273.03 | 95457.0 |
| 2008-01-31 13:30:00 | ES | Futures | 1273.27 | 1279.79 | 1272.57 | 1276.06 | 115424.0 |
| 2008-01-31 14:00:00 | ES | Futures | 1276.3 | 1282.13 | 1274.43 | 1279.09 | 121120.0 |
| 2008-01-31 14:30:00 | ES | Futures | 1278.86 | 1284.46 | 1275.6 | 1284.22 | 157558.0 |
| 2008-01-31 15:00:00 | ES | Futures | 1284.22 | 1289.35 | 1280.73 | 1287.72 | 192514.0 |
| 2008-01-31 15:30:00 | ES | Futures | 1287.95 | 1293.78 | 1278.4 | 1281.66 | 421212.0 |
| 2008-01-31 16:00:00 | ES | Futures | 1281.66 | 1283.76 | 1269.3 | 1282.36 | 192948.0 |
| 2008-01-31 16:30:00 | ES | Futures | 1280.49 | 1282.83 | 1279.09 | 1281.66 | 7746.0 |
| 2008-01-31 17:00:00 | ES | Futures | 1281.43 | 1283.76 | 1280.26 | 1281.43 | 4254.0 |
| 2008-01-31 18:00:00 | ES | Futures | 1281.43 | 1284.69 | 1281.19 | 1284.22 | 3588.0 |
| 2008-01-31 18:30:00 | ES | Futures | 1284.22 | 1284.92 | 1282.13 | 1282.59 | 1422.0 |
| 2008-01-31 19:00:00 | ES | Futures | 1282.36 | 1284.46 | 1282.13 | 1283.99 | 1713.0 |
| 2008-01-31 19:30:00 | ES | Futures | 1283.99 | 1284.92 | 1282.13 | 1282.36 | 1314.0 |
| 2008-01-31 20:00:00 | ES | Futures | 1282.13 | 1282.59 | 1280.73 | 1280.73 | 1009.0 |
| 2008-01-31 20:30:00 | ES | Futures | 1280.73 | 1284.22 | 1280.73 | 1282.13 | 1450.0 |
| 2008-01-31 21:00:00 | ES | Futures | 1282.13 | 1282.83 | 1280.73 | 1281.66 | 1061.0 |
| 2008-01-31 21:30:00 | ES | Futures | 1281.89 | 1282.13 | 1280.73 | 1280.96 | 659.0 |
| 2008-01-31 22:00:00 | ES | Futures | 1281.19 | 1282.13 | 1280.96 | 1281.43 | 419.0 |
| 2008-01-31 22:30:00 | ES | Futures | 1281.43 | 1282.13 | 1280.26 | 1281.89 | 740.0 |
| 2008-01-31 23:00:00 | ES | Futures | 1281.66 | 1283.99 | 1281.43 | 1283.52 | 814.0 |
| 2008-01-31 23:30:00 | ES | Futures | 1283.29 | 1283.29 | 1282.83 | 1283.06 | 292.0 |
| 2008-01-31 00:00:00 | NQ | Futures | 2036.29 | 2041.12 | 2031.19 | 2040.84 | 184.0 |
| 2008-01-31 00:30:00 | NQ | Futures | 2041.12 | 2042.26 | 2039.98 | 2041.12 | 99.0 |
| 2008-01-31 01:00:00 | NQ | Futures | 2041.12 | 2042.26 | 2038.28 | 2041.97 | 71.0 |
> showing 50 of 1,517 rows — these rows as CSV