PREVIEW / stock_1hour / 2004-12-14
file: by_date/stock_1hour/2004/2004-12-14.parquet size: 527 KB rows: 25,042 symbols: 1,898
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-14 08:00:00 | AAPL | Stock | 1.1588 | 1.1764 | 1.1571 | 1.1688 | 2911888.0 |
| 2004-12-14 09:00:00 | AAPL | Stock | 1.1688 | 1.1688 | 1.1609 | 1.1639 | 43350440.0 |
| 2004-12-14 10:00:00 | AAPL | Stock | 1.1645 | 1.1764 | 1.1611 | 1.1725 | 116291952.0 |
| 2004-12-14 11:00:00 | AAPL | Stock | 1.1727 | 1.1741 | 1.1654 | 1.1655 | 39563664.0 |
| 2004-12-14 12:00:00 | AAPL | Stock | 1.1661 | 1.1705 | 1.1646 | 1.1679 | 36871576.0 |
| 2004-12-14 13:00:00 | AAPL | Stock | 1.1679 | 1.1691 | 1.1666 | 1.1691 | 16952768.0 |
| 2004-12-14 14:00:00 | AAPL | Stock | 1.1693 | 1.1748 | 1.1645 | 1.1673 | 82462296.0 |
| 2004-12-14 15:00:00 | AAPL | Stock | 1.1673 | 1.1702 | 1.1616 | 1.1654 | 67965576.0 |
| 2004-12-14 16:00:00 | AAPL | Stock | 1.1648 | 1.1679 | 1.1605 | 1.1673 | 4104688.0 |
| 2004-12-14 17:00:00 | AAPL | Stock | 1.167 | 1.1704 | 1.1659 | 1.17 | 573944.0 |
| 2004-12-14 18:00:00 | AAPL | Stock | 1.1695 | 1.1713 | 1.1695 | 1.1713 | 98616.0 |
| 2004-12-14 08:00:00 | MSFT | Stock | 27.2 | 27.22 | 27.13 | 27.18 | 20490.0 |
| 2004-12-14 09:00:00 | MSFT | Stock | 27.13 | 27.32 | 27.04 | 27.3101 | 9644656.0 |
| 2004-12-14 10:00:00 | MSFT | Stock | 27.32 | 27.33 | 27.14 | 27.15 | 18764739.0 |
| 2004-12-14 11:00:00 | MSFT | Stock | 27.15 | 27.21 | 27.14 | 27.19 | 18519430.0 |
| 2004-12-14 12:00:00 | MSFT | Stock | 27.19 | 27.27 | 27.179 | 27.19 | 13285532.0 |
| 2004-12-14 13:00:00 | MSFT | Stock | 27.19 | 27.32 | 27.19 | 27.27 | 15780357.0 |
| 2004-12-14 14:00:00 | MSFT | Stock | 27.26 | 27.33 | 27.17 | 27.23 | 15551290.0 |
| 2004-12-14 15:00:00 | MSFT | Stock | 27.231 | 27.3 | 27.11 | 27.25 | 21789196.0 |
| 2004-12-14 16:00:00 | MSFT | Stock | 27.25 | 27.37 | 27.05 | 27.31 | 12895061.0 |
| 2004-12-14 17:00:00 | MSFT | Stock | 27.32 | 27.34 | 27.23 | 27.32 | 58951.0 |
| 2004-12-14 18:00:00 | MSFT | Stock | 27.31 | 27.31 | 27.3 | 27.3 | 5890.0 |
| 2004-12-14 08:00:00 | NVDA | Stock | 0.1902 | 0.1904 | 0.1902 | 0.1904 | 48000.0 |
| 2004-12-14 09:00:00 | NVDA | Stock | 0.1902 | 0.1914 | 0.1887 | 0.1906 | 95056800.0 |
| 2004-12-14 10:00:00 | NVDA | Stock | 0.1906 | 0.1912 | 0.19 | 0.1907 | 98014440.0 |
| 2004-12-14 11:00:00 | NVDA | Stock | 0.1907 | 0.1912 | 0.1904 | 0.1907 | 36605280.0 |
| 2004-12-14 12:00:00 | NVDA | Stock | 0.1907 | 0.1917 | 0.1901 | 0.1912 | 57186840.0 |
| 2004-12-14 13:00:00 | NVDA | Stock | 0.1912 | 0.1922 | 0.191 | 0.1919 | 37404720.0 |
| 2004-12-14 14:00:00 | NVDA | Stock | 0.1919 | 0.1927 | 0.1915 | 0.1924 | 68724720.0 |
| 2004-12-14 15:00:00 | NVDA | Stock | 0.1924 | 0.1929 | 0.191 | 0.1927 | 89722440.0 |
| 2004-12-14 16:00:00 | NVDA | Stock | 0.1926 | 0.1937 | 0.1921 | 0.1927 | 21979920.0 |
| 2004-12-14 17:00:00 | NVDA | Stock | 0.1939 | 0.1939 | 0.1927 | 0.1932 | 281040.0 |
| 2004-12-14 18:00:00 | NVDA | Stock | 0.1938 | 0.1939 | 0.1938 | 0.1939 | 156000.0 |
| 2004-12-14 08:00:00 | AMZN | Stock | 1.987 | 2.005 | 1.987 | 1.9915 | 66400.0 |
| 2004-12-14 09:00:00 | AMZN | Stock | 2.0 | 2.0175 | 1.987 | 2.01 | 19329320.0 |
| 2004-12-14 10:00:00 | AMZN | Stock | 2.01 | 2.015 | 1.997 | 2.0036 | 17195020.0 |
| 2004-12-14 11:00:00 | AMZN | Stock | 2.0035 | 2.01 | 1.9995 | 2.007 | 9309600.0 |
| 2004-12-14 12:00:00 | AMZN | Stock | 2.0065 | 2.0115 | 2.002 | 2.0095 | 7842740.0 |
| 2004-12-14 13:00:00 | AMZN | Stock | 2.0095 | 2.015 | 2.0095 | 2.0135 | 8463440.0 |
| 2004-12-14 14:00:00 | AMZN | Stock | 2.013 | 2.0235 | 2.01 | 2.0195 | 19783600.0 |
| 2004-12-14 15:00:00 | AMZN | Stock | 2.019 | 2.0225 | 2.0145 | 2.022 | 17911780.0 |
| 2004-12-14 16:00:00 | AMZN | Stock | 2.0205 | 2.022 | 1.9915 | 2.0218 | 1587600.0 |
| 2004-12-14 17:00:00 | AMZN | Stock | 2.019 | 2.019 | 2.019 | 2.019 | 4000.0 |
| 2004-12-14 09:00:00 | CL | Stock | 24.975 | 25.14 | 24.96 | 25.14 | 484600.0 |
| 2004-12-14 10:00:00 | CL | Stock | 25.13 | 25.16 | 25.075 | 25.12 | 655200.0 |
| 2004-12-14 11:00:00 | CL | Stock | 25.12 | 25.14 | 25.075 | 25.09 | 446000.0 |
| 2004-12-14 12:00:00 | CL | Stock | 25.085 | 25.125 | 25.075 | 25.105 | 441600.0 |
| 2004-12-14 13:00:00 | CL | Stock | 25.11 | 25.145 | 25.105 | 25.115 | 234000.0 |
| 2004-12-14 14:00:00 | CL | Stock | 25.115 | 25.175 | 25.095 | 25.165 | 463000.0 |
| 2004-12-14 15:00:00 | CL | Stock | 25.165 | 25.275 | 25.16 | 25.25 | 953000.0 |
> showing 50 of 25,042 rows — these rows as CSV