PREVIEW / futures_30min / 2008-02-19
file: by_date/futures_30min/2008/2008-02-19.parquet size: 50 KB rows: 1,664
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-02-19 00:00:00 | ES | Futures | 1272.33 | 1273.27 | 1272.1 | 1272.8 | 787.0 |
| 2008-02-19 00:30:00 | ES | Futures | 1272.8 | 1272.8 | 1271.63 | 1271.87 | 662.0 |
| 2008-02-19 01:00:00 | ES | Futures | 1271.63 | 1272.1 | 1271.4 | 1271.87 | 618.0 |
| 2008-02-19 01:30:00 | ES | Futures | 1272.1 | 1273.03 | 1271.87 | 1272.1 | 608.0 |
| 2008-02-19 02:00:00 | ES | Futures | 1271.87 | 1272.57 | 1269.77 | 1270.0 | 4292.0 |
| 2008-02-19 02:30:00 | ES | Futures | 1270.23 | 1271.4 | 1269.54 | 1271.17 | 1943.0 |
| 2008-02-19 03:00:00 | ES | Futures | 1271.4 | 1273.73 | 1269.07 | 1270.47 | 10656.0 |
| 2008-02-19 03:30:00 | ES | Futures | 1270.47 | 1270.47 | 1267.44 | 1268.6 | 8594.0 |
| 2008-02-19 04:00:00 | ES | Futures | 1268.6 | 1268.6 | 1265.57 | 1266.27 | 11893.0 |
| 2008-02-19 04:30:00 | ES | Futures | 1266.27 | 1267.67 | 1264.17 | 1265.8 | 8553.0 |
| 2008-02-19 05:00:00 | ES | Futures | 1265.57 | 1268.14 | 1265.57 | 1266.97 | 5079.0 |
| 2008-02-19 05:30:00 | ES | Futures | 1266.97 | 1267.9 | 1265.11 | 1267.67 | 7195.0 |
| 2008-02-19 06:00:00 | ES | Futures | 1267.44 | 1270.23 | 1265.57 | 1266.5 | 11856.0 |
| 2008-02-19 06:30:00 | ES | Futures | 1266.5 | 1271.63 | 1266.5 | 1270.93 | 13215.0 |
| 2008-02-19 07:00:00 | ES | Futures | 1270.7 | 1271.87 | 1268.6 | 1270.47 | 11948.0 |
| 2008-02-19 07:30:00 | ES | Futures | 1270.47 | 1273.73 | 1270.0 | 1272.8 | 18432.0 |
| 2008-02-19 08:00:00 | ES | Futures | 1272.8 | 1277.46 | 1272.57 | 1276.76 | 33340.0 |
| 2008-02-19 08:30:00 | ES | Futures | 1276.53 | 1277.23 | 1273.03 | 1273.97 | 20095.0 |
| 2008-02-19 09:00:00 | ES | Futures | 1273.97 | 1275.13 | 1273.27 | 1274.2 | 14864.0 |
| 2008-02-19 09:30:00 | ES | Futures | 1273.97 | 1276.3 | 1269.54 | 1270.0 | 157232.0 |
| 2008-02-19 10:00:00 | ES | Futures | 1270.0 | 1272.57 | 1268.6 | 1269.77 | 110277.0 |
| 2008-02-19 10:30:00 | ES | Futures | 1269.77 | 1270.23 | 1265.34 | 1267.44 | 118679.0 |
| 2008-02-19 11:00:00 | ES | Futures | 1267.67 | 1268.6 | 1262.54 | 1263.94 | 104303.0 |
| 2008-02-19 11:30:00 | ES | Futures | 1264.17 | 1267.67 | 1263.71 | 1267.44 | 59043.0 |
| 2008-02-19 12:00:00 | ES | Futures | 1267.44 | 1270.0 | 1266.04 | 1269.3 | 58103.0 |
| 2008-02-19 12:30:00 | ES | Futures | 1269.07 | 1269.3 | 1265.11 | 1265.57 | 49723.0 |
| 2008-02-19 13:00:00 | ES | Futures | 1265.57 | 1272.33 | 1265.57 | 1271.17 | 87052.0 |
| 2008-02-19 13:30:00 | ES | Futures | 1271.17 | 1271.4 | 1267.44 | 1267.9 | 57137.0 |
| 2008-02-19 14:00:00 | ES | Futures | 1267.9 | 1270.93 | 1266.27 | 1267.9 | 70464.0 |
| 2008-02-19 14:30:00 | ES | Futures | 1267.67 | 1267.9 | 1257.64 | 1258.11 | 142905.0 |
| 2008-02-19 15:00:00 | ES | Futures | 1257.88 | 1259.28 | 1255.08 | 1256.71 | 143313.0 |
| 2008-02-19 15:30:00 | ES | Futures | 1256.71 | 1261.84 | 1254.61 | 1258.58 | 147279.0 |
| 2008-02-19 16:00:00 | ES | Futures | 1258.34 | 1264.41 | 1258.34 | 1264.17 | 78655.0 |
| 2008-02-19 16:30:00 | ES | Futures | 1263.71 | 1264.17 | 1262.07 | 1262.07 | 5261.0 |
| 2008-02-19 17:00:00 | ES | Futures | 1262.31 | 1262.54 | 1261.61 | 1261.84 | 2464.0 |
| 2008-02-19 18:00:00 | ES | Futures | 1261.84 | 1261.84 | 1260.68 | 1261.14 | 2918.0 |
| 2008-02-19 18:30:00 | ES | Futures | 1261.14 | 1262.31 | 1260.68 | 1261.84 | 1283.0 |
| 2008-02-19 19:00:00 | ES | Futures | 1261.84 | 1262.07 | 1260.91 | 1261.14 | 748.0 |
| 2008-02-19 19:30:00 | ES | Futures | 1260.91 | 1261.37 | 1259.98 | 1260.44 | 2016.0 |
| 2008-02-19 20:00:00 | ES | Futures | 1260.68 | 1260.91 | 1259.28 | 1259.98 | 1421.0 |
| 2008-02-19 20:30:00 | ES | Futures | 1259.98 | 1261.14 | 1259.51 | 1259.98 | 1163.0 |
| 2008-02-19 21:00:00 | ES | Futures | 1259.74 | 1259.74 | 1259.04 | 1259.28 | 1179.0 |
| 2008-02-19 21:30:00 | ES | Futures | 1259.04 | 1260.91 | 1259.04 | 1260.44 | 903.0 |
| 2008-02-19 22:00:00 | ES | Futures | 1260.21 | 1260.91 | 1259.51 | 1259.74 | 504.0 |
| 2008-02-19 22:30:00 | ES | Futures | 1259.98 | 1259.98 | 1257.64 | 1258.34 | 1766.0 |
| 2008-02-19 23:00:00 | ES | Futures | 1258.58 | 1258.58 | 1256.71 | 1256.94 | 3159.0 |
| 2008-02-19 23:30:00 | ES | Futures | 1257.18 | 1257.88 | 1256.25 | 1256.71 | 2403.0 |
| 2008-02-19 00:00:00 | NQ | Futures | 2058.15 | 2059.57 | 2057.87 | 2059.57 | 63.0 |
| 2008-02-19 00:30:00 | NQ | Futures | 2058.15 | 2059.0 | 2056.16 | 2056.16 | 69.0 |
| 2008-02-19 01:00:00 | NQ | Futures | 2056.16 | 2057.02 | 2055.88 | 2057.02 | 42.0 |
> showing 50 of 1,664 rows — these rows as CSV