PREVIEW / futures_30min / 2008-01-24
file: by_date/futures_30min/2008/2008-01-24.parquet size: 49 KB rows: 1,467
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-24 00:00:00 | ES | Futures | 1257.41 | 1257.41 | 1256.01 | 1256.48 | 1166.0 |
| 2008-01-24 00:30:00 | ES | Futures | 1256.48 | 1256.48 | 1252.98 | 1253.91 | 1344.0 |
| 2008-01-24 01:00:00 | ES | Futures | 1253.68 | 1254.85 | 1251.35 | 1251.58 | 1472.0 |
| 2008-01-24 01:30:00 | ES | Futures | 1252.05 | 1256.94 | 1250.65 | 1256.25 | 2548.0 |
| 2008-01-24 02:00:00 | ES | Futures | 1256.48 | 1258.81 | 1250.18 | 1258.11 | 12373.0 |
| 2008-01-24 02:30:00 | ES | Futures | 1257.88 | 1258.11 | 1249.72 | 1249.95 | 12686.0 |
| 2008-01-24 03:00:00 | ES | Futures | 1249.72 | 1255.08 | 1245.52 | 1249.95 | 29033.0 |
| 2008-01-24 03:30:00 | ES | Futures | 1249.72 | 1254.61 | 1248.09 | 1252.28 | 15498.0 |
| 2008-01-24 04:00:00 | ES | Futures | 1252.28 | 1255.08 | 1243.66 | 1244.82 | 27396.0 |
| 2008-01-24 04:30:00 | ES | Futures | 1244.82 | 1246.45 | 1243.66 | 1245.05 | 7504.0 |
| 2008-01-24 05:00:00 | ES | Futures | 1245.29 | 1246.69 | 1243.42 | 1244.59 | 6960.0 |
| 2008-01-24 05:30:00 | ES | Futures | 1244.59 | 1254.15 | 1243.66 | 1253.21 | 16672.0 |
| 2008-01-24 06:00:00 | ES | Futures | 1253.21 | 1262.77 | 1252.75 | 1258.34 | 31288.0 |
| 2008-01-24 06:30:00 | ES | Futures | 1258.58 | 1261.37 | 1256.48 | 1259.04 | 14547.0 |
| 2008-01-24 07:00:00 | ES | Futures | 1259.28 | 1259.74 | 1253.68 | 1255.31 | 23375.0 |
| 2008-01-24 07:30:00 | ES | Futures | 1255.31 | 1257.64 | 1253.45 | 1254.15 | 20704.0 |
| 2008-01-24 08:00:00 | ES | Futures | 1253.91 | 1254.15 | 1249.95 | 1250.88 | 24127.0 |
| 2008-01-24 08:30:00 | ES | Futures | 1250.88 | 1258.34 | 1250.88 | 1257.41 | 39179.0 |
| 2008-01-24 09:00:00 | ES | Futures | 1257.18 | 1257.64 | 1253.91 | 1253.91 | 35066.0 |
| 2008-01-24 09:30:00 | ES | Futures | 1254.15 | 1261.61 | 1250.88 | 1256.71 | 234767.0 |
| 2008-01-24 10:00:00 | ES | Futures | 1256.48 | 1263.71 | 1245.29 | 1252.28 | 322748.0 |
| 2008-01-24 10:30:00 | ES | Futures | 1252.28 | 1257.88 | 1248.32 | 1251.58 | 185287.0 |
| 2008-01-24 11:00:00 | ES | Futures | 1251.58 | 1258.81 | 1248.09 | 1258.34 | 153271.0 |
| 2008-01-24 11:30:00 | ES | Futures | 1258.58 | 1261.14 | 1255.08 | 1256.48 | 125334.0 |
| 2008-01-24 12:00:00 | ES | Futures | 1256.48 | 1258.81 | 1252.05 | 1253.21 | 87186.0 |
| 2008-01-24 12:30:00 | ES | Futures | 1253.45 | 1256.71 | 1247.85 | 1256.48 | 88275.0 |
| 2008-01-24 13:00:00 | ES | Futures | 1256.48 | 1256.48 | 1249.25 | 1252.05 | 110212.0 |
| 2008-01-24 13:30:00 | ES | Futures | 1252.05 | 1260.68 | 1250.18 | 1257.64 | 88844.0 |
| 2008-01-24 14:00:00 | ES | Futures | 1257.41 | 1264.41 | 1255.55 | 1262.77 | 110364.0 |
| 2008-01-24 14:30:00 | ES | Futures | 1262.77 | 1265.8 | 1252.05 | 1255.31 | 166006.0 |
| 2008-01-24 15:00:00 | ES | Futures | 1255.31 | 1258.34 | 1253.68 | 1256.25 | 101798.0 |
| 2008-01-24 15:30:00 | ES | Futures | 1256.48 | 1262.77 | 1256.25 | 1261.61 | 169925.0 |
| 2008-01-24 16:00:00 | ES | Futures | 1261.61 | 1263.47 | 1259.74 | 1260.91 | 76878.0 |
| 2008-01-24 16:30:00 | ES | Futures | 1264.64 | 1268.84 | 1262.07 | 1268.6 | 21251.0 |
| 2008-01-24 17:00:00 | ES | Futures | 1268.37 | 1270.47 | 1267.44 | 1269.07 | 12065.0 |
| 2008-01-24 18:00:00 | ES | Futures | 1268.37 | 1269.07 | 1267.2 | 1267.67 | 2955.0 |
| 2008-01-24 18:30:00 | ES | Futures | 1267.67 | 1268.6 | 1266.97 | 1267.9 | 1870.0 |
| 2008-01-24 19:00:00 | ES | Futures | 1267.9 | 1267.9 | 1265.57 | 1266.74 | 2048.0 |
| 2008-01-24 19:30:00 | ES | Futures | 1266.5 | 1267.2 | 1266.04 | 1266.74 | 1159.0 |
| 2008-01-24 20:00:00 | ES | Futures | 1266.5 | 1267.2 | 1266.04 | 1266.97 | 701.0 |
| 2008-01-24 20:30:00 | ES | Futures | 1266.74 | 1268.6 | 1266.74 | 1267.44 | 1825.0 |
| 2008-01-24 21:00:00 | ES | Futures | 1267.2 | 1267.2 | 1266.5 | 1267.2 | 1110.0 |
| 2008-01-24 21:30:00 | ES | Futures | 1266.97 | 1267.2 | 1266.5 | 1266.74 | 494.0 |
| 2008-01-24 22:00:00 | ES | Futures | 1266.74 | 1266.97 | 1264.64 | 1265.11 | 1420.0 |
| 2008-01-24 22:30:00 | ES | Futures | 1265.11 | 1266.97 | 1264.87 | 1265.57 | 792.0 |
| 2008-01-24 23:00:00 | ES | Futures | 1265.34 | 1265.57 | 1263.71 | 1264.17 | 1235.0 |
| 2008-01-24 23:30:00 | ES | Futures | 1264.17 | 1265.34 | 1263.24 | 1263.94 | 2680.0 |
| 2008-01-24 00:00:00 | NQ | Futures | 2063.83 | 2064.96 | 2060.99 | 2063.54 | 185.0 |
| 2008-01-24 00:30:00 | NQ | Futures | 2064.11 | 2065.81 | 2061.84 | 2062.41 | 297.0 |
| 2008-01-24 01:00:00 | NQ | Futures | 2062.41 | 2062.98 | 2057.3 | 2059.0 | 233.0 |
> showing 50 of 1,467 rows — these rows as CSV