PREVIEW / futures_1hour / 2008-10-02
file: by_date/futures_1hour/2008/2008-10-02.parquet size: 47 KB rows: 1,290
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-10-02 00:00:00 | ES | Futures | 1094.98 | 1095.45 | 1092.14 | 1093.08 | 3520.0 |
| 2008-10-02 01:00:00 | ES | Futures | 1093.08 | 1096.63 | 1090.01 | 1090.48 | 5397.0 |
| 2008-10-02 02:00:00 | ES | Futures | 1090.24 | 1092.37 | 1089.53 | 1091.9 | 6963.0 |
| 2008-10-02 03:00:00 | ES | Futures | 1091.9 | 1099.71 | 1091.19 | 1096.87 | 25038.0 |
| 2008-10-02 04:00:00 | ES | Futures | 1097.11 | 1103.97 | 1096.87 | 1103.26 | 18574.0 |
| 2008-10-02 05:00:00 | ES | Futures | 1103.26 | 1104.68 | 1100.66 | 1101.6 | 12343.0 |
| 2008-10-02 06:00:00 | ES | Futures | 1101.6 | 1103.73 | 1098.05 | 1099.71 | 12066.0 |
| 2008-10-02 07:00:00 | ES | Futures | 1099.95 | 1101.6 | 1093.79 | 1094.5 | 24331.0 |
| 2008-10-02 08:00:00 | ES | Futures | 1094.5 | 1097.11 | 1089.3 | 1092.37 | 54017.0 |
| 2008-10-02 09:00:00 | ES | Futures | 1092.37 | 1095.45 | 1081.02 | 1082.2 | 266833.0 |
| 2008-10-02 10:00:00 | ES | Futures | 1081.96 | 1082.2 | 1072.73 | 1075.34 | 433299.0 |
| 2008-10-02 11:00:00 | ES | Futures | 1075.34 | 1076.76 | 1065.4 | 1076.05 | 334837.0 |
| 2008-10-02 12:00:00 | ES | Futures | 1076.05 | 1078.89 | 1070.13 | 1073.44 | 183981.0 |
| 2008-10-02 13:00:00 | ES | Futures | 1073.21 | 1075.81 | 1063.5 | 1070.13 | 334172.0 |
| 2008-10-02 14:00:00 | ES | Futures | 1070.37 | 1073.92 | 1059.72 | 1068.24 | 319504.0 |
| 2008-10-02 15:00:00 | ES | Futures | 1068.24 | 1069.18 | 1055.69 | 1058.77 | 478993.0 |
| 2008-10-02 16:00:00 | ES | Futures | 1058.77 | 1066.34 | 1058.3 | 1064.45 | 135125.0 |
| 2008-10-02 17:00:00 | ES | Futures | 1064.21 | 1064.92 | 1063.03 | 1064.21 | 4702.0 |
| 2008-10-02 18:00:00 | ES | Futures | 1063.98 | 1065.4 | 1059.48 | 1064.45 | 7712.0 |
| 2008-10-02 19:00:00 | ES | Futures | 1064.45 | 1066.58 | 1063.98 | 1065.4 | 2024.0 |
| 2008-10-02 20:00:00 | ES | Futures | 1065.4 | 1067.53 | 1061.85 | 1066.58 | 6655.0 |
| 2008-10-02 21:00:00 | ES | Futures | 1066.58 | 1071.79 | 1065.16 | 1069.66 | 6014.0 |
| 2008-10-02 22:00:00 | ES | Futures | 1069.66 | 1071.31 | 1067.76 | 1070.6 | 2831.0 |
| 2008-10-02 23:00:00 | ES | Futures | 1070.6 | 1070.84 | 1068.47 | 1070.13 | 3136.0 |
| 2008-10-02 00:00:00 | NQ | Futures | 1768.24 | 1769.94 | 1765.69 | 1768.24 | 237.0 |
| 2008-10-02 01:00:00 | NQ | Futures | 1767.67 | 1771.35 | 1767.11 | 1767.11 | 282.0 |
| 2008-10-02 02:00:00 | NQ | Futures | 1766.54 | 1772.2 | 1766.26 | 1771.07 | 272.0 |
| 2008-10-02 03:00:00 | NQ | Futures | 1771.35 | 1786.06 | 1771.35 | 1784.08 | 2349.0 |
| 2008-10-02 04:00:00 | NQ | Futures | 1784.65 | 1795.4 | 1782.39 | 1794.84 | 1128.0 |
| 2008-10-02 05:00:00 | NQ | Futures | 1795.12 | 1800.5 | 1792.86 | 1794.27 | 1161.0 |
| 2008-10-02 06:00:00 | NQ | Futures | 1794.55 | 1796.53 | 1785.22 | 1787.48 | 922.0 |
| 2008-10-02 07:00:00 | NQ | Futures | 1788.05 | 1789.18 | 1771.07 | 1772.77 | 3318.0 |
| 2008-10-02 08:00:00 | NQ | Futures | 1772.77 | 1777.58 | 1758.9 | 1765.97 | 7793.0 |
| 2008-10-02 09:00:00 | NQ | Futures | 1766.26 | 1769.94 | 1738.81 | 1739.09 | 39381.0 |
| 2008-10-02 10:00:00 | NQ | Futures | 1739.09 | 1739.94 | 1713.91 | 1720.42 | 62367.0 |
| 2008-10-02 11:00:00 | NQ | Futures | 1720.42 | 1730.89 | 1709.66 | 1729.19 | 44302.0 |
| 2008-10-02 12:00:00 | NQ | Futures | 1729.19 | 1731.45 | 1716.74 | 1723.25 | 24897.0 |
| 2008-10-02 13:00:00 | NQ | Futures | 1723.25 | 1723.25 | 1706.27 | 1719.29 | 50341.0 |
| 2008-10-02 14:00:00 | NQ | Futures | 1719.29 | 1724.1 | 1697.21 | 1711.93 | 48179.0 |
| 2008-10-02 15:00:00 | NQ | Futures | 1711.65 | 1713.06 | 1692.97 | 1694.1 | 69396.0 |
| 2008-10-02 16:00:00 | NQ | Futures | 1694.1 | 1712.49 | 1693.25 | 1708.82 | 17567.0 |
| 2008-10-02 17:00:00 | NQ | Futures | 1709.1 | 1709.1 | 1706.27 | 1706.27 | 111.0 |
| 2008-10-02 18:00:00 | NQ | Futures | 1708.53 | 1710.23 | 1702.31 | 1709.1 | 328.0 |
| 2008-10-02 19:00:00 | NQ | Futures | 1709.95 | 1713.91 | 1708.25 | 1712.21 | 283.0 |
| 2008-10-02 20:00:00 | NQ | Futures | 1713.06 | 1718.15 | 1709.95 | 1717.59 | 509.0 |
| 2008-10-02 21:00:00 | NQ | Futures | 1717.02 | 1719.57 | 1714.48 | 1719.57 | 355.0 |
| 2008-10-02 22:00:00 | NQ | Futures | 1718.44 | 1719.57 | 1716.46 | 1718.15 | 111.0 |
| 2008-10-02 23:00:00 | NQ | Futures | 1719.29 | 1719.57 | 1717.3 | 1718.44 | 114.0 |
| 2008-10-02 00:00:00 | YM | Futures | 9816.4 | 9821.0 | 9790.1 | 9802.8 | 204.0 |
| 2008-10-02 01:00:00 | YM | Futures | 9804.6 | 9814.6 | 9764.6 | 9775.5 | 415.0 |
> showing 50 of 1,290 rows — these rows as CSV