PREVIEW / futures_30min / 2008-05-22
file: by_date/futures_30min/2008/2008-05-22.parquet size: 65 KB rows: 2,199
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-05-22 00:00:00 | ES | Futures | 1299.27 | 1300.2 | 1298.1 | 1299.97 | 1294.0 |
| 2008-05-22 00:30:00 | ES | Futures | 1299.97 | 1300.43 | 1299.73 | 1300.2 | 867.0 |
| 2008-05-22 01:00:00 | ES | Futures | 1300.2 | 1300.9 | 1300.2 | 1300.43 | 968.0 |
| 2008-05-22 01:30:00 | ES | Futures | 1300.43 | 1300.9 | 1299.5 | 1300.66 | 1656.0 |
| 2008-05-22 02:00:00 | ES | Futures | 1300.9 | 1301.36 | 1299.97 | 1301.36 | 3959.0 |
| 2008-05-22 02:30:00 | ES | Futures | 1301.13 | 1301.13 | 1298.57 | 1299.73 | 3591.0 |
| 2008-05-22 03:00:00 | ES | Futures | 1299.97 | 1302.29 | 1299.73 | 1300.2 | 11370.0 |
| 2008-05-22 03:30:00 | ES | Futures | 1300.43 | 1302.99 | 1299.5 | 1301.6 | 8863.0 |
| 2008-05-22 04:00:00 | ES | Futures | 1301.36 | 1303.23 | 1299.97 | 1302.76 | 7439.0 |
| 2008-05-22 04:30:00 | ES | Futures | 1302.76 | 1303.23 | 1300.2 | 1300.66 | 8409.0 |
| 2008-05-22 05:00:00 | ES | Futures | 1300.9 | 1301.6 | 1299.97 | 1300.43 | 3571.0 |
| 2008-05-22 05:30:00 | ES | Futures | 1300.43 | 1302.06 | 1299.97 | 1300.2 | 5470.0 |
| 2008-05-22 06:00:00 | ES | Futures | 1300.2 | 1300.9 | 1298.8 | 1299.04 | 5418.0 |
| 2008-05-22 06:30:00 | ES | Futures | 1299.27 | 1299.97 | 1297.87 | 1299.73 | 4759.0 |
| 2008-05-22 07:00:00 | ES | Futures | 1299.73 | 1299.97 | 1297.87 | 1298.34 | 8640.0 |
| 2008-05-22 07:30:00 | ES | Futures | 1298.34 | 1298.34 | 1295.08 | 1295.54 | 25394.0 |
| 2008-05-22 08:00:00 | ES | Futures | 1295.78 | 1297.17 | 1294.84 | 1296.24 | 26936.0 |
| 2008-05-22 08:30:00 | ES | Futures | 1297.17 | 1299.73 | 1295.78 | 1298.8 | 51591.0 |
| 2008-05-22 09:00:00 | ES | Futures | 1299.04 | 1299.27 | 1296.47 | 1296.47 | 32504.0 |
| 2008-05-22 09:30:00 | ES | Futures | 1296.47 | 1299.27 | 1295.31 | 1297.17 | 176894.0 |
| 2008-05-22 10:00:00 | ES | Futures | 1296.94 | 1301.6 | 1296.94 | 1301.36 | 179390.0 |
| 2008-05-22 10:30:00 | ES | Futures | 1301.13 | 1303.69 | 1298.34 | 1300.66 | 176214.0 |
| 2008-05-22 11:00:00 | ES | Futures | 1300.9 | 1302.53 | 1299.73 | 1300.43 | 104369.0 |
| 2008-05-22 11:30:00 | ES | Futures | 1300.43 | 1300.9 | 1295.54 | 1297.17 | 130776.0 |
| 2008-05-22 12:00:00 | ES | Futures | 1297.17 | 1298.1 | 1295.08 | 1297.64 | 65505.0 |
| 2008-05-22 12:30:00 | ES | Futures | 1297.64 | 1300.43 | 1296.71 | 1299.73 | 67773.0 |
| 2008-05-22 13:00:00 | ES | Futures | 1299.73 | 1300.66 | 1298.34 | 1298.57 | 57512.0 |
| 2008-05-22 13:30:00 | ES | Futures | 1298.8 | 1303.46 | 1297.87 | 1301.13 | 86845.0 |
| 2008-05-22 14:00:00 | ES | Futures | 1301.36 | 1302.76 | 1296.24 | 1297.17 | 121089.0 |
| 2008-05-22 14:30:00 | ES | Futures | 1297.17 | 1301.13 | 1296.47 | 1300.2 | 95514.0 |
| 2008-05-22 15:00:00 | ES | Futures | 1300.2 | 1301.36 | 1296.01 | 1296.47 | 63325.0 |
| 2008-05-22 15:30:00 | ES | Futures | 1296.24 | 1299.5 | 1295.78 | 1298.1 | 114002.0 |
| 2008-05-22 16:00:00 | ES | Futures | 1298.1 | 1298.57 | 1297.41 | 1297.87 | 51537.0 |
| 2008-05-22 16:30:00 | ES | Futures | 1298.1 | 1298.1 | 1296.01 | 1297.17 | 2698.0 |
| 2008-05-22 17:00:00 | ES | Futures | 1297.41 | 1297.87 | 1297.17 | 1297.64 | 497.0 |
| 2008-05-22 18:00:00 | ES | Futures | 1297.64 | 1297.87 | 1297.17 | 1297.41 | 397.0 |
| 2008-05-22 18:30:00 | ES | Futures | 1297.41 | 1297.87 | 1297.41 | 1297.64 | 135.0 |
| 2008-05-22 19:00:00 | ES | Futures | 1297.87 | 1298.34 | 1297.17 | 1298.34 | 598.0 |
| 2008-05-22 19:30:00 | ES | Futures | 1298.1 | 1298.34 | 1296.71 | 1296.94 | 607.0 |
| 2008-05-22 20:00:00 | ES | Futures | 1296.94 | 1297.64 | 1296.47 | 1297.64 | 639.0 |
| 2008-05-22 20:30:00 | ES | Futures | 1297.87 | 1297.87 | 1297.41 | 1297.64 | 297.0 |
| 2008-05-22 21:00:00 | ES | Futures | 1297.64 | 1298.57 | 1297.64 | 1298.34 | 418.0 |
| 2008-05-22 21:30:00 | ES | Futures | 1298.34 | 1299.27 | 1298.1 | 1298.8 | 423.0 |
| 2008-05-22 22:00:00 | ES | Futures | 1298.8 | 1299.27 | 1298.34 | 1298.57 | 361.0 |
| 2008-05-22 22:30:00 | ES | Futures | 1298.57 | 1298.8 | 1298.34 | 1298.8 | 212.0 |
| 2008-05-22 23:00:00 | ES | Futures | 1298.57 | 1299.04 | 1298.34 | 1298.8 | 465.0 |
| 2008-05-22 23:30:00 | ES | Futures | 1298.8 | 1299.04 | 1297.64 | 1298.34 | 598.0 |
| 2008-05-22 00:00:00 | NQ | Futures | 2225.3 | 2226.99 | 2222.75 | 2226.99 | 132.0 |
| 2008-05-22 00:30:00 | NQ | Futures | 2226.71 | 2228.41 | 2226.14 | 2228.12 | 110.0 |
| 2008-05-22 01:00:00 | NQ | Futures | 2228.12 | 2229.54 | 2227.28 | 2228.69 | 85.0 |
> showing 50 of 2,199 rows — these rows as CSV