PREVIEW / stock_1hour / 2005-01-11
file: by_date/stock_1hour/2005/2005-01-11.parquet size: 558 KB rows: 26,155 symbols: 1,906
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-11 08:00:00 | AAPL | Stock | 1.2375 | 1.2375 | 1.2277 | 1.2313 | 3445848.0 |
| 2005-01-11 09:00:00 | AAPL | Stock | 1.2313 | 1.2348 | 1.2148 | 1.2223 | 161288176.0 |
| 2005-01-11 10:00:00 | AAPL | Stock | 1.2223 | 1.2268 | 1.2173 | 1.2241 | 138267584.0 |
| 2005-01-11 11:00:00 | AAPL | Stock | 1.2241 | 1.2339 | 1.2232 | 1.2246 | 99501584.0 |
| 2005-01-11 12:00:00 | AAPL | Stock | 1.2246 | 1.2277 | 1.1557 | 1.1829 | 553312536.0 |
| 2005-01-11 13:00:00 | AAPL | Stock | 1.1825 | 1.227 | 1.157 | 1.182 | 768969152.0 |
| 2005-01-11 14:00:00 | AAPL | Stock | 1.182 | 1.1957 | 1.1661 | 1.1773 | 335541192.0 |
| 2005-01-11 15:00:00 | AAPL | Stock | 1.1773 | 1.1821 | 1.1454 | 1.1523 | 526252272.0 |
| 2005-01-11 16:00:00 | AAPL | Stock | 1.1523 | 1.1677 | 1.1489 | 1.1607 | 17856440.0 |
| 2005-01-11 17:00:00 | AAPL | Stock | 1.1632 | 1.1652 | 1.1518 | 1.1634 | 4016544.0 |
| 2005-01-11 18:00:00 | AAPL | Stock | 1.1634 | 1.1661 | 1.1518 | 1.1659 | 1275568.0 |
| 2005-01-11 08:00:00 | MSFT | Stock | 26.72 | 27.22 | 26.71 | 26.71 | 104205.0 |
| 2005-01-11 09:00:00 | MSFT | Stock | 26.73 | 26.79 | 26.64 | 26.76 | 6232124.0 |
| 2005-01-11 10:00:00 | MSFT | Stock | 26.76 | 26.82 | 26.69 | 26.78 | 10659602.0 |
| 2005-01-11 11:00:00 | MSFT | Stock | 26.79 | 26.82 | 26.73 | 26.75 | 7926274.0 |
| 2005-01-11 12:00:00 | MSFT | Stock | 26.75 | 26.8 | 26.65 | 26.65 | 10285846.0 |
| 2005-01-11 13:00:00 | MSFT | Stock | 26.65 | 26.76 | 26.61 | 26.73 | 7854743.0 |
| 2005-01-11 14:00:00 | MSFT | Stock | 26.73 | 26.78 | 26.69 | 26.72 | 7768022.0 |
| 2005-01-11 15:00:00 | MSFT | Stock | 26.73 | 26.81 | 26.7 | 26.74 | 9540861.0 |
| 2005-01-11 16:00:00 | MSFT | Stock | 26.74 | 26.9 | 26.68 | 26.9 | 2139621.0 |
| 2005-01-11 17:00:00 | MSFT | Stock | 26.82 | 26.89 | 26.728 | 26.82 | 1165172.0 |
| 2005-01-11 18:00:00 | MSFT | Stock | 26.82 | 26.85 | 26.73 | 26.73 | 15280.0 |
| 2005-01-11 08:00:00 | NVDA | Stock | 0.1808 | 0.1817 | 0.1808 | 0.1817 | 1002000.0 |
| 2005-01-11 09:00:00 | NVDA | Stock | 0.1816 | 0.1836 | 0.177 | 0.1777 | 175501320.0 |
| 2005-01-11 10:00:00 | NVDA | Stock | 0.1776 | 0.1798 | 0.1771 | 0.1787 | 143287440.0 |
| 2005-01-11 11:00:00 | NVDA | Stock | 0.1787 | 0.1831 | 0.1782 | 0.1789 | 65574840.0 |
| 2005-01-11 12:00:00 | NVDA | Stock | 0.1789 | 0.1792 | 0.1762 | 0.1762 | 105904800.0 |
| 2005-01-11 13:00:00 | NVDA | Stock | 0.1762 | 0.1768 | 0.1756 | 0.1762 | 196503720.0 |
| 2005-01-11 14:00:00 | NVDA | Stock | 0.1763 | 0.1792 | 0.1762 | 0.1778 | 137424480.0 |
| 2005-01-11 15:00:00 | NVDA | Stock | 0.1778 | 0.1785 | 0.1771 | 0.178 | 183299760.0 |
| 2005-01-11 16:00:00 | NVDA | Stock | 0.178 | 0.1808 | 0.1775 | 0.1807 | 58276680.0 |
| 2005-01-11 17:00:00 | NVDA | Stock | 0.1783 | 0.1805 | 0.1783 | 0.1804 | 2280240.0 |
| 2005-01-11 18:00:00 | NVDA | Stock | 0.1805 | 0.1805 | 0.1805 | 0.1805 | 12000.0 |
| 2005-01-11 08:00:00 | AMZN | Stock | 2.0855 | 2.0855 | 2.085 | 2.085 | 22000.0 |
| 2005-01-11 09:00:00 | AMZN | Stock | 2.0825 | 2.0975 | 2.0605 | 2.087 | 21664440.0 |
| 2005-01-11 10:00:00 | AMZN | Stock | 2.088 | 2.1025 | 2.0505 | 2.102 | 35931980.0 |
| 2005-01-11 11:00:00 | AMZN | Stock | 2.102 | 2.108 | 2.09 | 2.0935 | 25571240.0 |
| 2005-01-11 12:00:00 | AMZN | Stock | 2.0945 | 2.095 | 2.071 | 2.0745 | 20002200.0 |
| 2005-01-11 13:00:00 | AMZN | Stock | 2.075 | 2.101 | 2.074 | 2.1 | 16513020.0 |
| 2005-01-11 14:00:00 | AMZN | Stock | 2.1 | 2.103 | 2.08 | 2.081 | 14138000.0 |
| 2005-01-11 15:00:00 | AMZN | Stock | 2.081 | 2.101 | 2.07 | 2.082 | 21805820.0 |
| 2005-01-11 16:00:00 | AMZN | Stock | 2.083 | 2.089 | 2.075 | 2.075 | 821220.0 |
| 2005-01-11 17:00:00 | AMZN | Stock | 2.0819 | 2.091 | 2.0819 | 2.085 | 553200.0 |
| 2005-01-11 18:00:00 | AMZN | Stock | 2.082 | 2.085 | 2.082 | 2.082 | 26060.0 |
| 2005-01-11 09:00:00 | CL | Stock | 25.18 | 25.22 | 25.0 | 25.035 | 378800.0 |
| 2005-01-11 10:00:00 | CL | Stock | 25.04 | 25.22 | 25.0 | 25.21 | 559800.0 |
| 2005-01-11 11:00:00 | CL | Stock | 25.21 | 25.24 | 25.16 | 25.205 | 384800.0 |
| 2005-01-11 12:00:00 | CL | Stock | 25.21 | 25.24 | 25.155 | 25.17 | 360800.0 |
| 2005-01-11 13:00:00 | CL | Stock | 25.15 | 25.19 | 25.1 | 25.185 | 738800.0 |
| 2005-01-11 14:00:00 | CL | Stock | 25.19 | 25.315 | 25.18 | 25.27 | 493400.0 |
> showing 50 of 26,155 rows — these rows as CSV