PREVIEW / stock_1hour / 2004-12-16
file: by_date/stock_1hour/2004/2004-12-16.parquet size: 552 KB rows: 25,430 symbols: 1,901
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-16 08:00:00 | AAPL | Stock | 1.1696 | 1.183 | 1.1696 | 1.1816 | 5035968.0 |
| 2004-12-16 09:00:00 | AAPL | Stock | 1.1816 | 1.2041 | 1.1654 | 1.1863 | 325729488.0 |
| 2004-12-16 10:00:00 | AAPL | Stock | 1.1861 | 1.1905 | 1.1804 | 1.1904 | 171307920.0 |
| 2004-12-16 11:00:00 | AAPL | Stock | 1.1902 | 1.1991 | 1.1868 | 1.1938 | 119779464.0 |
| 2004-12-16 12:00:00 | AAPL | Stock | 1.1938 | 1.2054 | 1.1934 | 1.2032 | 119884744.0 |
| 2004-12-16 13:00:00 | AAPL | Stock | 1.203 | 1.2034 | 1.1946 | 1.1964 | 85943648.0 |
| 2004-12-16 14:00:00 | AAPL | Stock | 1.1968 | 1.2013 | 1.1893 | 1.192 | 135464504.0 |
| 2004-12-16 15:00:00 | AAPL | Stock | 1.192 | 1.1973 | 1.188 | 1.1884 | 123590488.0 |
| 2004-12-16 16:00:00 | AAPL | Stock | 1.1893 | 1.1902 | 1.1848 | 1.1884 | 11442480.0 |
| 2004-12-16 17:00:00 | AAPL | Stock | 1.1884 | 1.1902 | 1.1857 | 1.1857 | 257768.0 |
| 2004-12-16 18:00:00 | AAPL | Stock | 1.1854 | 1.1855 | 1.1832 | 1.1848 | 850080.0 |
| 2004-12-16 08:00:00 | MSFT | Stock | 27.17 | 27.25 | 27.17 | 27.2 | 108663.0 |
| 2004-12-16 09:00:00 | MSFT | Stock | 27.11 | 27.27 | 27.11 | 27.18 | 6523410.0 |
| 2004-12-16 10:00:00 | MSFT | Stock | 27.18 | 27.21 | 27.11 | 27.19 | 13746057.0 |
| 2004-12-16 11:00:00 | MSFT | Stock | 27.19 | 27.28 | 27.19 | 27.23 | 13441481.0 |
| 2004-12-16 12:00:00 | MSFT | Stock | 27.23 | 27.27 | 27.16 | 27.16 | 7681824.0 |
| 2004-12-16 13:00:00 | MSFT | Stock | 27.169 | 27.18 | 27.08 | 27.09 | 8199965.0 |
| 2004-12-16 14:00:00 | MSFT | Stock | 27.09 | 27.15 | 27.01 | 27.02 | 17591988.0 |
| 2004-12-16 15:00:00 | MSFT | Stock | 27.02 | 27.19 | 27.01 | 27.16 | 17440503.0 |
| 2004-12-16 16:00:00 | MSFT | Stock | 27.16 | 27.21 | 27.148 | 27.16 | 3101464.0 |
| 2004-12-16 17:00:00 | MSFT | Stock | 27.16 | 27.18 | 27.1276 | 27.17 | 869517.0 |
| 2004-12-16 18:00:00 | MSFT | Stock | 27.16 | 27.16 | 27.16 | 27.16 | 100.0 |
| 2004-12-16 08:00:00 | NVDA | Stock | 0.1983 | 0.2058 | 0.1983 | 0.2042 | 14777160.0 |
| 2004-12-16 09:00:00 | NVDA | Stock | 0.2042 | 0.2042 | 0.1951 | 0.202 | 201899640.0 |
| 2004-12-16 10:00:00 | NVDA | Stock | 0.2021 | 0.2041 | 0.201 | 0.2035 | 175510680.0 |
| 2004-12-16 11:00:00 | NVDA | Stock | 0.2036 | 0.2071 | 0.2031 | 0.2061 | 276763080.0 |
| 2004-12-16 12:00:00 | NVDA | Stock | 0.2062 | 0.2072 | 0.2052 | 0.2058 | 138223320.0 |
| 2004-12-16 13:00:00 | NVDA | Stock | 0.2058 | 0.206 | 0.2042 | 0.2046 | 120719160.0 |
| 2004-12-16 14:00:00 | NVDA | Stock | 0.2045 | 0.2048 | 0.1973 | 0.1977 | 338166720.0 |
| 2004-12-16 15:00:00 | NVDA | Stock | 0.1977 | 0.1997 | 0.1967 | 0.1973 | 213967680.0 |
| 2004-12-16 16:00:00 | NVDA | Stock | 0.1973 | 0.1996 | 0.1971 | 0.1971 | 9188280.0 |
| 2004-12-16 17:00:00 | NVDA | Stock | 0.2 | 0.2018 | 0.1992 | 0.1992 | 348000.0 |
| 2004-12-16 08:00:00 | AMZN | Stock | 2.05 | 2.05 | 2.0495 | 2.0495 | 6000.0 |
| 2004-12-16 09:00:00 | AMZN | Stock | 2.0435 | 2.05 | 2.031 | 2.034 | 9622360.0 |
| 2004-12-16 10:00:00 | AMZN | Stock | 2.0345 | 2.039 | 2.0275 | 2.039 | 12080480.0 |
| 2004-12-16 11:00:00 | AMZN | Stock | 2.0385 | 2.0445 | 2.035 | 2.039 | 7113960.0 |
| 2004-12-16 12:00:00 | AMZN | Stock | 2.0385 | 2.043 | 2.0375 | 2.0375 | 4575900.0 |
| 2004-12-16 13:00:00 | AMZN | Stock | 2.0375 | 2.0375 | 2.015 | 2.015 | 12526320.0 |
| 2004-12-16 14:00:00 | AMZN | Stock | 2.014 | 2.0175 | 1.988 | 1.988 | 24282980.0 |
| 2004-12-16 15:00:00 | AMZN | Stock | 1.9885 | 2.004 | 1.9855 | 2.003 | 32494080.0 |
| 2004-12-16 16:00:00 | AMZN | Stock | 2.0025 | 2.0045 | 2.0 | 2.0025 | 2602720.0 |
| 2004-12-16 17:00:00 | AMZN | Stock | 2.0015 | 2.0045 | 2.0 | 2.0 | 156940.0 |
| 2004-12-16 18:00:00 | AMZN | Stock | 2.0045 | 2.0045 | 2.0 | 2.0045 | 9100.0 |
| 2004-12-16 09:00:00 | CL | Stock | 24.925 | 24.99 | 24.84 | 24.85 | 666600.0 |
| 2004-12-16 10:00:00 | CL | Stock | 24.85 | 24.86 | 24.625 | 24.695 | 1275800.0 |
| 2004-12-16 11:00:00 | CL | Stock | 24.695 | 24.975 | 24.65 | 24.955 | 1039800.0 |
| 2004-12-16 12:00:00 | CL | Stock | 24.95 | 24.995 | 24.92 | 24.95 | 631000.0 |
| 2004-12-16 13:00:00 | CL | Stock | 24.96 | 24.98 | 24.885 | 24.95 | 568200.0 |
| 2004-12-16 14:00:00 | CL | Stock | 24.945 | 24.945 | 24.83 | 24.835 | 674400.0 |
| 2004-12-16 15:00:00 | CL | Stock | 24.835 | 25.03 | 24.82 | 24.955 | 760400.0 |
> showing 50 of 25,430 rows — these rows as CSV