PREVIEW / futures_1hour / 2008-10-01
file: by_date/futures_1hour/2008/2008-10-01.parquet size: 45 KB rows: 1,265
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-01 00:00:00 | ES | Futures | 1099.0 | 1100.89 | 1098.53 | 1099.71 | 2026.0 |
| 2008-10-01 01:00:00 | ES | Futures | 1099.47 | 1100.89 | 1099.24 | 1100.66 | 1426.0 |
| 2008-10-01 02:00:00 | ES | Futures | 1100.89 | 1101.84 | 1097.82 | 1100.42 | 11609.0 |
| 2008-10-01 03:00:00 | ES | Futures | 1100.18 | 1100.42 | 1095.69 | 1097.34 | 23263.0 |
| 2008-10-01 04:00:00 | ES | Futures | 1097.34 | 1099.24 | 1094.74 | 1099.24 | 15923.0 |
| 2008-10-01 05:00:00 | ES | Futures | 1099.47 | 1099.71 | 1091.9 | 1092.61 | 21638.0 |
| 2008-10-01 06:00:00 | ES | Futures | 1092.37 | 1097.82 | 1091.19 | 1097.34 | 16528.0 |
| 2008-10-01 07:00:00 | ES | Futures | 1097.11 | 1099.24 | 1094.74 | 1094.74 | 17961.0 |
| 2008-10-01 08:00:00 | ES | Futures | 1094.98 | 1099.71 | 1093.56 | 1096.4 | 43561.0 |
| 2008-10-01 09:00:00 | ES | Futures | 1096.4 | 1097.82 | 1088.35 | 1095.21 | 259287.0 |
| 2008-10-01 10:00:00 | ES | Futures | 1095.21 | 1095.45 | 1082.91 | 1086.22 | 377950.0 |
| 2008-10-01 11:00:00 | ES | Futures | 1086.46 | 1094.74 | 1082.67 | 1092.85 | 241434.0 |
| 2008-10-01 12:00:00 | ES | Futures | 1093.08 | 1110.12 | 1090.95 | 1105.86 | 339045.0 |
| 2008-10-01 13:00:00 | ES | Futures | 1105.86 | 1106.81 | 1091.43 | 1099.47 | 430492.0 |
| 2008-10-01 14:00:00 | ES | Futures | 1099.71 | 1110.36 | 1095.69 | 1103.5 | 328852.0 |
| 2008-10-01 15:00:00 | ES | Futures | 1103.5 | 1107.28 | 1099.47 | 1103.02 | 241688.0 |
| 2008-10-01 16:00:00 | ES | Futures | 1103.73 | 1109.18 | 1101.84 | 1105.39 | 84465.0 |
| 2008-10-01 17:00:00 | ES | Futures | 1105.15 | 1107.76 | 1105.15 | 1107.28 | 1972.0 |
| 2008-10-01 18:00:00 | ES | Futures | 1107.52 | 1110.6 | 1106.81 | 1108.47 | 4299.0 |
| 2008-10-01 19:00:00 | ES | Futures | 1108.7 | 1111.31 | 1107.28 | 1107.52 | 4749.0 |
| 2008-10-01 20:00:00 | ES | Futures | 1107.52 | 1110.12 | 1101.84 | 1105.15 | 8680.0 |
| 2008-10-01 21:00:00 | ES | Futures | 1105.15 | 1111.31 | 1093.56 | 1097.58 | 32194.0 |
| 2008-10-01 22:00:00 | ES | Futures | 1097.34 | 1099.47 | 1093.32 | 1094.03 | 9164.0 |
| 2008-10-01 23:00:00 | ES | Futures | 1094.27 | 1096.16 | 1094.03 | 1094.98 | 3095.0 |
| 2008-10-01 00:00:00 | NQ | Futures | 1800.78 | 1807.0 | 1800.78 | 1803.04 | 153.0 |
| 2008-10-01 01:00:00 | NQ | Futures | 1804.17 | 1804.17 | 1799.93 | 1802.76 | 80.0 |
| 2008-10-01 02:00:00 | NQ | Futures | 1803.04 | 1805.87 | 1799.65 | 1802.19 | 335.0 |
| 2008-10-01 03:00:00 | NQ | Futures | 1801.63 | 1801.63 | 1795.4 | 1797.95 | 884.0 |
| 2008-10-01 04:00:00 | NQ | Futures | 1797.1 | 1801.91 | 1795.12 | 1801.91 | 440.0 |
| 2008-10-01 05:00:00 | NQ | Futures | 1802.48 | 1803.04 | 1794.55 | 1795.69 | 1609.0 |
| 2008-10-01 06:00:00 | NQ | Futures | 1795.69 | 1808.14 | 1792.57 | 1806.44 | 1541.0 |
| 2008-10-01 07:00:00 | NQ | Futures | 1807.29 | 1809.27 | 1800.21 | 1800.21 | 2029.0 |
| 2008-10-01 08:00:00 | NQ | Futures | 1799.93 | 1802.19 | 1789.74 | 1794.84 | 7081.0 |
| 2008-10-01 09:00:00 | NQ | Futures | 1795.12 | 1801.34 | 1784.93 | 1796.25 | 39160.0 |
| 2008-10-01 10:00:00 | NQ | Futures | 1796.53 | 1796.82 | 1760.6 | 1764.84 | 62766.0 |
| 2008-10-01 11:00:00 | NQ | Futures | 1764.84 | 1775.03 | 1756.92 | 1771.07 | 39765.0 |
| 2008-10-01 12:00:00 | NQ | Futures | 1771.07 | 1798.52 | 1765.97 | 1791.72 | 43888.0 |
| 2008-10-01 13:00:00 | NQ | Futures | 1791.44 | 1791.72 | 1762.3 | 1775.6 | 55609.0 |
| 2008-10-01 14:00:00 | NQ | Futures | 1775.6 | 1793.42 | 1769.09 | 1778.71 | 42800.0 |
| 2008-10-01 15:00:00 | NQ | Futures | 1778.71 | 1782.67 | 1769.37 | 1779.27 | 44738.0 |
| 2008-10-01 16:00:00 | NQ | Futures | 1779.56 | 1788.89 | 1773.61 | 1787.76 | 13575.0 |
| 2008-10-01 17:00:00 | NQ | Futures | 1787.76 | 1790.59 | 1785.22 | 1787.48 | 177.0 |
| 2008-10-01 18:00:00 | NQ | Futures | 1788.05 | 1793.7 | 1787.76 | 1792.29 | 175.0 |
| 2008-10-01 19:00:00 | NQ | Futures | 1792.29 | 1797.1 | 1792.01 | 1792.01 | 265.0 |
| 2008-10-01 20:00:00 | NQ | Futures | 1793.42 | 1796.82 | 1780.12 | 1782.1 | 436.0 |
| 2008-10-01 21:00:00 | NQ | Futures | 1786.91 | 1797.38 | 1765.69 | 1771.35 | 1193.0 |
| 2008-10-01 22:00:00 | NQ | Futures | 1771.35 | 1775.6 | 1765.69 | 1771.35 | 442.0 |
| 2008-10-01 23:00:00 | NQ | Futures | 1770.78 | 1771.92 | 1765.69 | 1769.37 | 70.0 |
| 2008-10-01 00:00:00 | YM | Futures | 9809.2 | 9829.2 | 9808.3 | 9814.6 | 119.0 |
| 2008-10-01 01:00:00 | YM | Futures | 9817.3 | 9831.9 | 9817.3 | 9831.9 | 181.0 |
> showing 50 of 1,265 rows — these rows as CSV