PREVIEW / futures_30min / 2008-05-21
file: by_date/futures_30min/2008/2008-05-21.parquet size: 66 KB rows: 2,234
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-21 00:00:00 | ES | Futures | 1320.22 | 1320.46 | 1319.53 | 1320.22 | 955.0 |
| 2008-05-21 00:30:00 | ES | Futures | 1320.22 | 1320.22 | 1318.83 | 1319.29 | 773.0 |
| 2008-05-21 01:00:00 | ES | Futures | 1319.06 | 1319.53 | 1318.59 | 1318.83 | 699.0 |
| 2008-05-21 01:30:00 | ES | Futures | 1318.83 | 1319.76 | 1318.13 | 1318.13 | 1124.0 |
| 2008-05-21 02:00:00 | ES | Futures | 1318.13 | 1320.22 | 1318.13 | 1319.76 | 2663.0 |
| 2008-05-21 02:30:00 | ES | Futures | 1319.76 | 1322.55 | 1319.76 | 1321.85 | 7673.0 |
| 2008-05-21 03:00:00 | ES | Futures | 1321.85 | 1322.55 | 1319.29 | 1319.99 | 8709.0 |
| 2008-05-21 03:30:00 | ES | Futures | 1319.99 | 1321.85 | 1319.76 | 1321.62 | 4240.0 |
| 2008-05-21 04:00:00 | ES | Futures | 1321.39 | 1322.79 | 1321.16 | 1321.85 | 6680.0 |
| 2008-05-21 04:30:00 | ES | Futures | 1321.85 | 1322.79 | 1321.62 | 1322.79 | 2746.0 |
| 2008-05-21 05:00:00 | ES | Futures | 1322.79 | 1323.48 | 1322.32 | 1323.25 | 4096.0 |
| 2008-05-21 05:30:00 | ES | Futures | 1323.25 | 1323.48 | 1322.09 | 1322.09 | 1898.0 |
| 2008-05-21 06:00:00 | ES | Futures | 1322.09 | 1322.32 | 1318.36 | 1318.83 | 7992.0 |
| 2008-05-21 06:30:00 | ES | Futures | 1318.83 | 1319.29 | 1316.96 | 1319.06 | 13178.0 |
| 2008-05-21 07:00:00 | ES | Futures | 1319.06 | 1320.22 | 1316.03 | 1316.03 | 11128.0 |
| 2008-05-21 07:30:00 | ES | Futures | 1316.27 | 1317.9 | 1313.94 | 1317.66 | 19951.0 |
| 2008-05-21 08:00:00 | ES | Futures | 1317.66 | 1318.59 | 1316.03 | 1318.13 | 28485.0 |
| 2008-05-21 08:30:00 | ES | Futures | 1318.13 | 1318.59 | 1316.27 | 1318.13 | 27044.0 |
| 2008-05-21 09:00:00 | ES | Futures | 1317.9 | 1319.29 | 1317.43 | 1318.83 | 23845.0 |
| 2008-05-21 09:30:00 | ES | Futures | 1318.83 | 1321.85 | 1317.43 | 1317.9 | 199112.0 |
| 2008-05-21 10:00:00 | ES | Futures | 1317.9 | 1319.76 | 1316.03 | 1318.59 | 173802.0 |
| 2008-05-21 10:30:00 | ES | Futures | 1318.83 | 1319.06 | 1311.84 | 1312.31 | 221599.0 |
| 2008-05-21 11:00:00 | ES | Futures | 1312.31 | 1315.33 | 1311.38 | 1315.1 | 140137.0 |
| 2008-05-21 11:30:00 | ES | Futures | 1314.87 | 1316.5 | 1312.77 | 1315.8 | 87741.0 |
| 2008-05-21 12:00:00 | ES | Futures | 1315.57 | 1316.03 | 1314.17 | 1315.33 | 67889.0 |
| 2008-05-21 12:30:00 | ES | Futures | 1315.33 | 1318.36 | 1314.64 | 1316.5 | 78997.0 |
| 2008-05-21 13:00:00 | ES | Futures | 1316.73 | 1316.96 | 1311.61 | 1312.07 | 88755.0 |
| 2008-05-21 13:30:00 | ES | Futures | 1312.07 | 1314.64 | 1309.51 | 1310.68 | 100674.0 |
| 2008-05-21 14:00:00 | ES | Futures | 1310.44 | 1310.91 | 1299.5 | 1301.36 | 315343.0 |
| 2008-05-21 14:30:00 | ES | Futures | 1301.36 | 1301.83 | 1295.31 | 1299.73 | 226476.0 |
| 2008-05-21 15:00:00 | ES | Futures | 1299.73 | 1301.6 | 1296.94 | 1299.27 | 149241.0 |
| 2008-05-21 15:30:00 | ES | Futures | 1299.5 | 1301.13 | 1292.75 | 1295.31 | 245922.0 |
| 2008-05-21 16:00:00 | ES | Futures | 1295.31 | 1297.87 | 1294.61 | 1297.17 | 82944.0 |
| 2008-05-21 16:30:00 | ES | Futures | 1297.41 | 1297.64 | 1295.78 | 1296.94 | 5305.0 |
| 2008-05-21 17:00:00 | ES | Futures | 1296.94 | 1299.04 | 1296.47 | 1298.57 | 1858.0 |
| 2008-05-21 18:00:00 | ES | Futures | 1298.8 | 1298.8 | 1296.94 | 1297.64 | 1305.0 |
| 2008-05-21 18:30:00 | ES | Futures | 1297.64 | 1297.87 | 1297.41 | 1297.41 | 410.0 |
| 2008-05-21 19:00:00 | ES | Futures | 1297.41 | 1297.64 | 1296.24 | 1296.71 | 865.0 |
| 2008-05-21 19:30:00 | ES | Futures | 1296.71 | 1296.94 | 1296.24 | 1296.47 | 483.0 |
| 2008-05-21 20:00:00 | ES | Futures | 1296.94 | 1296.94 | 1296.47 | 1296.71 | 1179.0 |
| 2008-05-21 20:30:00 | ES | Futures | 1296.71 | 1297.17 | 1296.01 | 1296.47 | 1176.0 |
| 2008-05-21 21:00:00 | ES | Futures | 1296.71 | 1299.04 | 1296.47 | 1298.8 | 2115.0 |
| 2008-05-21 21:30:00 | ES | Futures | 1298.8 | 1299.73 | 1298.57 | 1299.04 | 1803.0 |
| 2008-05-21 22:00:00 | ES | Futures | 1299.04 | 1300.2 | 1298.8 | 1300.2 | 2083.0 |
| 2008-05-21 22:30:00 | ES | Futures | 1300.2 | 1300.43 | 1297.87 | 1298.34 | 1607.0 |
| 2008-05-21 23:00:00 | ES | Futures | 1298.34 | 1298.34 | 1297.41 | 1298.34 | 774.0 |
| 2008-05-21 23:30:00 | ES | Futures | 1298.34 | 1299.5 | 1298.1 | 1299.04 | 755.0 |
| 2008-05-21 00:00:00 | NQ | Futures | 2271.96 | 2273.09 | 2271.4 | 2271.4 | 108.0 |
| 2008-05-21 00:30:00 | NQ | Futures | 2271.11 | 2271.4 | 2270.55 | 2271.11 | 79.0 |
| 2008-05-21 01:00:00 | NQ | Futures | 2271.11 | 2271.68 | 2269.7 | 2271.4 | 80.0 |
> showing 50 of 2,234 rows — these rows as CSV