PREVIEW / futures_30min / 2008-06-02
file: by_date/futures_30min/2008/2008-06-02.parquet size: 64 KB rows: 2,174
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-06-02 00:00:00 | ES | Futures | 1302.06 | 1302.53 | 1301.83 | 1302.29 | 251.0 |
| 2008-06-02 00:30:00 | ES | Futures | 1302.06 | 1302.29 | 1301.6 | 1301.83 | 195.0 |
| 2008-06-02 01:00:00 | ES | Futures | 1301.83 | 1302.76 | 1301.6 | 1302.76 | 748.0 |
| 2008-06-02 01:30:00 | ES | Futures | 1302.29 | 1302.53 | 1301.6 | 1302.53 | 459.0 |
| 2008-06-02 02:00:00 | ES | Futures | 1302.29 | 1302.76 | 1302.06 | 1302.76 | 790.0 |
| 2008-06-02 02:30:00 | ES | Futures | 1302.76 | 1302.76 | 1300.9 | 1301.83 | 1383.0 |
| 2008-06-02 03:00:00 | ES | Futures | 1302.06 | 1302.29 | 1299.73 | 1299.73 | 6484.0 |
| 2008-06-02 03:30:00 | ES | Futures | 1299.73 | 1299.73 | 1297.87 | 1298.34 | 7950.0 |
| 2008-06-02 04:00:00 | ES | Futures | 1298.57 | 1298.8 | 1296.24 | 1296.94 | 8369.0 |
| 2008-06-02 04:30:00 | ES | Futures | 1296.71 | 1297.41 | 1295.54 | 1296.94 | 8434.0 |
| 2008-06-02 05:00:00 | ES | Futures | 1296.94 | 1297.17 | 1296.24 | 1296.47 | 2759.0 |
| 2008-06-02 05:30:00 | ES | Futures | 1296.47 | 1297.87 | 1296.47 | 1297.64 | 3420.0 |
| 2008-06-02 06:00:00 | ES | Futures | 1297.64 | 1298.57 | 1297.41 | 1298.1 | 2599.0 |
| 2008-06-02 06:30:00 | ES | Futures | 1298.1 | 1298.34 | 1297.41 | 1297.64 | 2985.0 |
| 2008-06-02 07:00:00 | ES | Futures | 1297.41 | 1298.8 | 1296.71 | 1298.57 | 5497.0 |
| 2008-06-02 07:30:00 | ES | Futures | 1298.57 | 1298.8 | 1297.64 | 1298.34 | 4678.0 |
| 2008-06-02 08:00:00 | ES | Futures | 1298.34 | 1299.04 | 1297.41 | 1297.64 | 8569.0 |
| 2008-06-02 08:30:00 | ES | Futures | 1297.64 | 1299.04 | 1297.41 | 1298.34 | 12747.0 |
| 2008-06-02 09:00:00 | ES | Futures | 1298.34 | 1299.97 | 1298.1 | 1299.97 | 13131.0 |
| 2008-06-02 09:30:00 | ES | Futures | 1299.97 | 1300.2 | 1293.68 | 1294.61 | 162087.0 |
| 2008-06-02 10:00:00 | ES | Futures | 1294.61 | 1296.47 | 1289.95 | 1291.12 | 199059.0 |
| 2008-06-02 10:30:00 | ES | Futures | 1290.89 | 1292.75 | 1289.02 | 1291.82 | 137550.0 |
| 2008-06-02 11:00:00 | ES | Futures | 1291.82 | 1292.98 | 1290.19 | 1290.89 | 115964.0 |
| 2008-06-02 11:30:00 | ES | Futures | 1290.65 | 1292.05 | 1288.56 | 1291.58 | 98239.0 |
| 2008-06-02 12:00:00 | ES | Futures | 1291.35 | 1292.28 | 1290.19 | 1290.19 | 50214.0 |
| 2008-06-02 12:30:00 | ES | Futures | 1290.19 | 1290.89 | 1283.2 | 1283.43 | 214012.0 |
| 2008-06-02 13:00:00 | ES | Futures | 1283.43 | 1286.0 | 1282.97 | 1285.53 | 82209.0 |
| 2008-06-02 13:30:00 | ES | Futures | 1285.53 | 1286.93 | 1284.6 | 1286.93 | 60089.0 |
| 2008-06-02 14:00:00 | ES | Futures | 1286.69 | 1288.09 | 1285.53 | 1287.63 | 69598.0 |
| 2008-06-02 14:30:00 | ES | Futures | 1287.63 | 1288.09 | 1285.76 | 1286.0 | 73242.0 |
| 2008-06-02 15:00:00 | ES | Futures | 1285.76 | 1289.72 | 1284.6 | 1288.56 | 109287.0 |
| 2008-06-02 15:30:00 | ES | Futures | 1288.79 | 1292.28 | 1288.09 | 1290.19 | 141469.0 |
| 2008-06-02 16:00:00 | ES | Futures | 1290.42 | 1291.58 | 1289.49 | 1290.65 | 68498.0 |
| 2008-06-02 16:30:00 | ES | Futures | 1290.65 | 1290.89 | 1290.19 | 1290.42 | 2970.0 |
| 2008-06-02 17:00:00 | ES | Futures | 1290.42 | 1290.89 | 1290.42 | 1290.89 | 712.0 |
| 2008-06-02 18:00:00 | ES | Futures | 1290.42 | 1290.65 | 1290.19 | 1290.19 | 628.0 |
| 2008-06-02 18:30:00 | ES | Futures | 1290.19 | 1290.42 | 1289.95 | 1290.42 | 271.0 |
| 2008-06-02 19:00:00 | ES | Futures | 1290.19 | 1290.65 | 1289.72 | 1290.19 | 1022.0 |
| 2008-06-02 19:30:00 | ES | Futures | 1289.72 | 1290.42 | 1289.72 | 1290.19 | 584.0 |
| 2008-06-02 20:00:00 | ES | Futures | 1290.19 | 1290.65 | 1289.95 | 1290.42 | 775.0 |
| 2008-06-02 20:30:00 | ES | Futures | 1290.42 | 1290.89 | 1290.42 | 1290.42 | 535.0 |
| 2008-06-02 21:00:00 | ES | Futures | 1290.42 | 1290.89 | 1290.19 | 1290.65 | 427.0 |
| 2008-06-02 21:30:00 | ES | Futures | 1290.89 | 1291.35 | 1290.65 | 1291.12 | 815.0 |
| 2008-06-02 22:00:00 | ES | Futures | 1291.35 | 1291.58 | 1290.65 | 1290.65 | 771.0 |
| 2008-06-02 22:30:00 | ES | Futures | 1290.89 | 1290.89 | 1290.19 | 1290.19 | 357.0 |
| 2008-06-02 23:00:00 | ES | Futures | 1290.19 | 1291.12 | 1290.19 | 1290.89 | 238.0 |
| 2008-06-02 23:30:00 | ES | Futures | 1290.89 | 1291.35 | 1290.19 | 1290.42 | 547.0 |
| 2008-06-02 00:00:00 | NQ | Futures | 2300.53 | 2300.53 | 2300.25 | 2300.25 | 21.0 |
| 2008-06-02 00:30:00 | NQ | Futures | 2300.53 | 2300.53 | 2300.53 | 2300.53 | 1.0 |
| 2008-06-02 01:00:00 | NQ | Futures | 2299.96 | 2301.09 | 2299.4 | 2301.09 | 46.0 |
> showing 50 of 2,174 rows — these rows as CSV