PREVIEW / stock_1hour / 2004-12-10
file: by_date/stock_1hour/2004/2004-12-10.parquet size: 531 KB rows: 24,715 symbols: 1,890
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-10 08:00:00 | AAPL | Stock | 1.15 | 1.1741 | 1.1427 | 1.1652 | 8976016.0 |
| 2004-12-10 09:00:00 | AAPL | Stock | 1.1652 | 1.1795 | 1.1455 | 1.1736 | 222508664.0 |
| 2004-12-10 10:00:00 | AAPL | Stock | 1.1732 | 1.1768 | 1.1616 | 1.1641 | 168083776.0 |
| 2004-12-10 11:00:00 | AAPL | Stock | 1.1641 | 1.1738 | 1.1634 | 1.1657 | 94010616.0 |
| 2004-12-10 12:00:00 | AAPL | Stock | 1.1659 | 1.1711 | 1.1652 | 1.1702 | 43610672.0 |
| 2004-12-10 13:00:00 | AAPL | Stock | 1.1698 | 1.1704 | 1.1643 | 1.1675 | 68542432.0 |
| 2004-12-10 14:00:00 | AAPL | Stock | 1.1679 | 1.1686 | 1.1577 | 1.1613 | 80073000.0 |
| 2004-12-10 15:00:00 | AAPL | Stock | 1.1611 | 1.1646 | 1.1596 | 1.1634 | 74118576.0 |
| 2004-12-10 16:00:00 | AAPL | Stock | 1.1634 | 1.1645 | 1.1616 | 1.1634 | 5905088.0 |
| 2004-12-10 17:00:00 | AAPL | Stock | 1.1634 | 1.1639 | 1.1625 | 1.1625 | 146160.0 |
| 2004-12-10 18:00:00 | AAPL | Stock | 1.1629 | 1.1629 | 1.1627 | 1.1629 | 61600.0 |
| 2004-12-10 08:00:00 | MSFT | Stock | 27.21 | 27.23 | 27.15 | 27.2 | 96442.0 |
| 2004-12-10 09:00:00 | MSFT | Stock | 27.19 | 27.2 | 27.05 | 27.151 | 6052268.0 |
| 2004-12-10 10:00:00 | MSFT | Stock | 27.15 | 27.17 | 27.09 | 27.1 | 11312370.0 |
| 2004-12-10 11:00:00 | MSFT | Stock | 27.1 | 27.14 | 27.05 | 27.08 | 10201296.0 |
| 2004-12-10 12:00:00 | MSFT | Stock | 27.08 | 27.12 | 27.06 | 27.07 | 7044676.0 |
| 2004-12-10 13:00:00 | MSFT | Stock | 27.07 | 27.16 | 27.06 | 27.15 | 8165724.0 |
| 2004-12-10 14:00:00 | MSFT | Stock | 27.15 | 27.16 | 27.07 | 27.11 | 8305309.0 |
| 2004-12-10 15:00:00 | MSFT | Stock | 27.11 | 27.16 | 27.05 | 27.07 | 12910027.0 |
| 2004-12-10 16:00:00 | MSFT | Stock | 27.07 | 27.11 | 27.07 | 27.09 | 5728709.0 |
| 2004-12-10 17:00:00 | MSFT | Stock | 27.09 | 27.09 | 27.07 | 27.07 | 600.0 |
| 2004-12-10 08:00:00 | NVDA | Stock | 0.1942 | 0.1962 | 0.1937 | 0.1946 | 2696400.0 |
| 2004-12-10 09:00:00 | NVDA | Stock | 0.1943 | 0.1959 | 0.192 | 0.195 | 132591960.0 |
| 2004-12-10 10:00:00 | NVDA | Stock | 0.1948 | 0.1952 | 0.1937 | 0.195 | 94543320.0 |
| 2004-12-10 11:00:00 | NVDA | Stock | 0.195 | 0.1957 | 0.1945 | 0.1952 | 79351560.0 |
| 2004-12-10 12:00:00 | NVDA | Stock | 0.1952 | 0.1958 | 0.1947 | 0.1952 | 46908120.0 |
| 2004-12-10 13:00:00 | NVDA | Stock | 0.1952 | 0.1963 | 0.195 | 0.1959 | 65905920.0 |
| 2004-12-10 14:00:00 | NVDA | Stock | 0.1959 | 0.1962 | 0.1942 | 0.1942 | 90007800.0 |
| 2004-12-10 15:00:00 | NVDA | Stock | 0.1942 | 0.1948 | 0.1931 | 0.1942 | 131225640.0 |
| 2004-12-10 16:00:00 | NVDA | Stock | 0.1942 | 0.1944 | 0.1925 | 0.1942 | 3483600.0 |
| 2004-12-10 17:00:00 | NVDA | Stock | 0.1942 | 0.1942 | 0.1942 | 0.1942 | 597840.0 |
| 2004-12-10 08:00:00 | AMZN | Stock | 1.9915 | 1.994 | 1.99 | 1.99 | 1245200.0 |
| 2004-12-10 09:00:00 | AMZN | Stock | 1.9895 | 2.005 | 1.9745 | 1.985 | 15740280.0 |
| 2004-12-10 10:00:00 | AMZN | Stock | 1.9845 | 1.9905 | 1.964 | 1.9665 | 24799420.0 |
| 2004-12-10 11:00:00 | AMZN | Stock | 1.9665 | 1.97 | 1.958 | 1.9595 | 16476100.0 |
| 2004-12-10 12:00:00 | AMZN | Stock | 1.9595 | 1.9645 | 1.952 | 1.9635 | 8100420.0 |
| 2004-12-10 13:00:00 | AMZN | Stock | 1.9635 | 1.965 | 1.9565 | 1.965 | 10272860.0 |
| 2004-12-10 14:00:00 | AMZN | Stock | 1.965 | 1.9655 | 1.954 | 1.954 | 8555660.0 |
| 2004-12-10 15:00:00 | AMZN | Stock | 1.9545 | 1.9595 | 1.95 | 1.9505 | 20967140.0 |
| 2004-12-10 16:00:00 | AMZN | Stock | 1.9515 | 1.9525 | 1.9475 | 1.9519 | 2418880.0 |
| 2004-12-10 17:00:00 | AMZN | Stock | 1.9475 | 1.9475 | 1.94 | 1.9425 | 70000.0 |
| 2004-12-10 18:00:00 | AMZN | Stock | 1.946 | 1.946 | 1.946 | 1.946 | 7000.0 |
| 2004-12-10 09:00:00 | CL | Stock | 25.025 | 25.14 | 24.9 | 25.08 | 651400.0 |
| 2004-12-10 10:00:00 | CL | Stock | 25.085 | 25.1 | 24.925 | 25.0 | 887800.0 |
| 2004-12-10 11:00:00 | CL | Stock | 24.995 | 25.125 | 24.97 | 25.07 | 745400.0 |
| 2004-12-10 12:00:00 | CL | Stock | 25.065 | 25.24 | 25.05 | 25.235 | 485800.0 |
| 2004-12-10 13:00:00 | CL | Stock | 25.23 | 25.34 | 25.135 | 25.335 | 625200.0 |
| 2004-12-10 14:00:00 | CL | Stock | 25.3255 | 25.36 | 25.22 | 25.27 | 510600.0 |
| 2004-12-10 15:00:00 | CL | Stock | 25.275 | 25.295 | 25.175 | 25.24 | 840400.0 |
| 2004-12-10 16:00:00 | CL | Stock | 25.21 | 25.23 | 25.21 | 25.23 | 600.0 |
> showing 50 of 24,715 rows — these rows as CSV