PREVIEW / stock_1hour / 2004-12-02
file: by_date/stock_1hour/2004/2004-12-02.parquet size: 556 KB rows: 25,827 symbols: 1,889
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-02 08:00:00 | AAPL | Stock | 1.1857 | 1.1946 | 1.1829 | 1.1855 | 8476216.0 |
| 2004-12-02 09:00:00 | AAPL | Stock | 1.1854 | 1.1946 | 1.1746 | 1.1871 | 179656904.0 |
| 2004-12-02 10:00:00 | AAPL | Stock | 1.1879 | 1.1905 | 1.1793 | 1.1868 | 179798472.0 |
| 2004-12-02 11:00:00 | AAPL | Stock | 1.1868 | 1.1934 | 1.1805 | 1.1811 | 106110704.0 |
| 2004-12-02 12:00:00 | AAPL | Stock | 1.1811 | 1.1829 | 1.1714 | 1.1721 | 97632416.0 |
| 2004-12-02 13:00:00 | AAPL | Stock | 1.1722 | 1.1773 | 1.162 | 1.1684 | 123830896.0 |
| 2004-12-02 14:00:00 | AAPL | Stock | 1.1686 | 1.1711 | 1.1646 | 1.1679 | 78876448.0 |
| 2004-12-02 15:00:00 | AAPL | Stock | 1.168 | 1.1682 | 1.1546 | 1.1636 | 168967792.0 |
| 2004-12-02 16:00:00 | AAPL | Stock | 1.1643 | 1.1766 | 1.1611 | 1.1734 | 12094208.0 |
| 2004-12-02 17:00:00 | AAPL | Stock | 1.1644 | 1.1759 | 1.1609 | 1.1752 | 2164848.0 |
| 2004-12-02 18:00:00 | AAPL | Stock | 1.1752 | 1.1897 | 1.1732 | 1.1732 | 602000.0 |
| 2004-12-02 08:00:00 | MSFT | Stock | 27.3 | 27.3 | 27.18 | 27.2 | 71676.0 |
| 2004-12-02 09:00:00 | MSFT | Stock | 27.2 | 27.4 | 27.17 | 27.35 | 13710333.0 |
| 2004-12-02 10:00:00 | MSFT | Stock | 27.35 | 27.4 | 27.08 | 27.17 | 20594707.0 |
| 2004-12-02 11:00:00 | MSFT | Stock | 27.17 | 27.29 | 27.12 | 27.16 | 11874092.0 |
| 2004-12-02 12:00:00 | MSFT | Stock | 27.17 | 27.17 | 26.92 | 27.03 | 11699617.0 |
| 2004-12-02 13:00:00 | MSFT | Stock | 27.03 | 27.14 | 27.02 | 27.13 | 6896990.0 |
| 2004-12-02 14:00:00 | MSFT | Stock | 27.13 | 27.24 | 27.1 | 27.23 | 8827571.0 |
| 2004-12-02 15:00:00 | MSFT | Stock | 27.22 | 27.24 | 27.03 | 27.1 | 16333957.0 |
| 2004-12-02 16:00:00 | MSFT | Stock | 27.1 | 27.38 | 27.09 | 27.24 | 1449554.0 |
| 2004-12-02 17:00:00 | MSFT | Stock | 27.134 | 27.32 | 27.134 | 27.3 | 124801.0 |
| 2004-12-02 18:00:00 | MSFT | Stock | 27.3 | 27.385 | 27.09 | 27.35 | 176011.0 |
| 2004-12-02 08:00:00 | NVDA | Stock | 0.1632 | 0.1632 | 0.1632 | 0.1632 | 156000.0 |
| 2004-12-02 09:00:00 | NVDA | Stock | 0.1625 | 0.1633 | 0.1606 | 0.1621 | 59438040.0 |
| 2004-12-02 10:00:00 | NVDA | Stock | 0.162 | 0.1643 | 0.162 | 0.1636 | 89711160.0 |
| 2004-12-02 11:00:00 | NVDA | Stock | 0.1637 | 0.1661 | 0.1637 | 0.1659 | 114918840.0 |
| 2004-12-02 12:00:00 | NVDA | Stock | 0.1659 | 0.1662 | 0.1639 | 0.164 | 76194960.0 |
| 2004-12-02 13:00:00 | NVDA | Stock | 0.164 | 0.1649 | 0.1636 | 0.1639 | 46935600.0 |
| 2004-12-02 14:00:00 | NVDA | Stock | 0.1639 | 0.1668 | 0.1638 | 0.1661 | 130017840.0 |
| 2004-12-02 15:00:00 | NVDA | Stock | 0.166 | 0.1662 | 0.1645 | 0.1657 | 201670560.0 |
| 2004-12-02 16:00:00 | NVDA | Stock | 0.1657 | 0.1696 | 0.1654 | 0.1696 | 17195160.0 |
| 2004-12-02 17:00:00 | NVDA | Stock | 0.1704 | 0.1713 | 0.1655 | 0.1712 | 6044040.0 |
| 2004-12-02 18:00:00 | NVDA | Stock | 0.1712 | 0.1712 | 0.1699 | 0.1712 | 2875800.0 |
| 2004-12-02 08:00:00 | AMZN | Stock | 1.991 | 1.991 | 1.9875 | 1.9875 | 41920.0 |
| 2004-12-02 09:00:00 | AMZN | Stock | 1.9815 | 2.0 | 1.973 | 2.0 | 13536980.0 |
| 2004-12-02 10:00:00 | AMZN | Stock | 2.0 | 2.0335 | 1.971 | 2.026 | 39523520.0 |
| 2004-12-02 11:00:00 | AMZN | Stock | 2.026 | 2.037 | 2.0225 | 2.0325 | 22125720.0 |
| 2004-12-02 12:00:00 | AMZN | Stock | 2.032 | 2.035 | 2.015 | 2.0205 | 13925780.0 |
| 2004-12-02 13:00:00 | AMZN | Stock | 2.0205 | 2.025 | 2.015 | 2.0195 | 8782640.0 |
| 2004-12-02 14:00:00 | AMZN | Stock | 2.02 | 2.029 | 2.0175 | 2.0255 | 8665480.0 |
| 2004-12-02 15:00:00 | AMZN | Stock | 2.0255 | 2.0255 | 2.0025 | 2.0085 | 20553660.0 |
| 2004-12-02 16:00:00 | AMZN | Stock | 2.0085 | 2.0205 | 2.008 | 2.0205 | 2414240.0 |
| 2004-12-02 17:00:00 | AMZN | Stock | 2.0082 | 2.02 | 1.985 | 2.0155 | 820640.0 |
| 2004-12-02 18:00:00 | AMZN | Stock | 1.9985 | 2.0175 | 1.9985 | 2.0175 | 31520.0 |
| 2004-12-02 09:00:00 | CL | Stock | 23.4 | 23.415 | 23.35 | 23.365 | 371400.0 |
| 2004-12-02 10:00:00 | CL | Stock | 23.365 | 23.65 | 23.355 | 23.65 | 977400.0 |
| 2004-12-02 11:00:00 | CL | Stock | 23.65 | 23.755 | 23.64 | 23.68 | 1023400.0 |
| 2004-12-02 12:00:00 | CL | Stock | 23.68 | 23.735 | 23.645 | 23.67 | 519800.0 |
| 2004-12-02 13:00:00 | CL | Stock | 23.675 | 23.69 | 23.55 | 23.565 | 570000.0 |
| 2004-12-02 14:00:00 | CL | Stock | 23.565 | 23.68 | 23.56 | 23.68 | 588400.0 |
> showing 50 of 25,827 rows — these rows as CSV