PREVIEW / stock_1hour / 2004-12-07
file: by_date/stock_1hour/2004/2004-12-07.parquet size: 556 KB rows: 25,651 symbols: 1,888
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-07 08:00:00 | AAPL | Stock | 1.175 | 1.175 | 1.1468 | 1.1686 | 4246368.0 |
| 2004-12-07 09:00:00 | AAPL | Stock | 1.1686 | 1.1793 | 1.1539 | 1.1679 | 142463216.0 |
| 2004-12-07 10:00:00 | AAPL | Stock | 1.1679 | 1.1916 | 1.1638 | 1.1705 | 217432936.0 |
| 2004-12-07 11:00:00 | AAPL | Stock | 1.1705 | 1.1738 | 1.1625 | 1.1661 | 65569896.0 |
| 2004-12-07 12:00:00 | AAPL | Stock | 1.1655 | 1.1705 | 1.1568 | 1.1582 | 73662176.0 |
| 2004-12-07 13:00:00 | AAPL | Stock | 1.158 | 1.1591 | 1.1439 | 1.1491 | 139691048.0 |
| 2004-12-07 14:00:00 | AAPL | Stock | 1.1491 | 1.1532 | 1.1286 | 1.1315 | 145426008.0 |
| 2004-12-07 15:00:00 | AAPL | Stock | 1.1315 | 1.1332 | 1.1179 | 1.1218 | 183345680.0 |
| 2004-12-07 16:00:00 | AAPL | Stock | 1.1216 | 1.1548 | 1.1179 | 1.1179 | 5728296.0 |
| 2004-12-07 17:00:00 | AAPL | Stock | 1.1184 | 1.1759 | 1.1179 | 1.1205 | 3790136.0 |
| 2004-12-07 18:00:00 | AAPL | Stock | 1.1198 | 1.1198 | 1.1179 | 1.1188 | 528080.0 |
| 2004-12-07 08:00:00 | MSFT | Stock | 27.4 | 27.4 | 27.34 | 27.36 | 10357.0 |
| 2004-12-07 09:00:00 | MSFT | Stock | 27.35 | 27.37 | 27.18 | 27.31 | 9013873.0 |
| 2004-12-07 10:00:00 | MSFT | Stock | 27.32 | 27.38 | 27.29 | 27.305 | 11426574.0 |
| 2004-12-07 11:00:00 | MSFT | Stock | 27.31 | 27.33 | 27.25 | 27.29 | 11087591.0 |
| 2004-12-07 12:00:00 | MSFT | Stock | 27.3 | 27.33 | 27.27 | 27.27 | 9134907.0 |
| 2004-12-07 13:00:00 | MSFT | Stock | 27.28 | 27.29 | 27.2 | 27.24 | 18151260.0 |
| 2004-12-07 14:00:00 | MSFT | Stock | 27.24 | 27.25 | 27.19 | 27.22 | 20189490.0 |
| 2004-12-07 15:00:00 | MSFT | Stock | 27.221 | 27.24 | 27.0 | 27.02 | 18259571.0 |
| 2004-12-07 16:00:00 | MSFT | Stock | 27.02 | 27.08 | 27.01 | 27.07 | 1820593.0 |
| 2004-12-07 17:00:00 | MSFT | Stock | 27.05 | 27.2624 | 27.01 | 27.08 | 19924634.0 |
| 2004-12-07 18:00:00 | MSFT | Stock | 27.07 | 27.08 | 27.06 | 27.07 | 3600.0 |
| 2004-12-07 08:00:00 | NVDA | Stock | 0.1865 | 0.1916 | 0.1817 | 0.1892 | 12857400.0 |
| 2004-12-07 09:00:00 | NVDA | Stock | 0.1892 | 0.208 | 0.182 | 0.2042 | 885900960.0 |
| 2004-12-07 10:00:00 | NVDA | Stock | 0.2041 | 0.2047 | 0.1943 | 0.1957 | 556976160.0 |
| 2004-12-07 11:00:00 | NVDA | Stock | 0.1957 | 0.1981 | 0.1937 | 0.1969 | 301605000.0 |
| 2004-12-07 12:00:00 | NVDA | Stock | 0.1969 | 0.1973 | 0.1946 | 0.1951 | 162182880.0 |
| 2004-12-07 13:00:00 | NVDA | Stock | 0.1951 | 0.1956 | 0.1921 | 0.1926 | 192412800.0 |
| 2004-12-07 14:00:00 | NVDA | Stock | 0.1926 | 0.1945 | 0.1878 | 0.1885 | 276521040.0 |
| 2004-12-07 15:00:00 | NVDA | Stock | 0.1885 | 0.1905 | 0.1882 | 0.19 | 297899520.0 |
| 2004-12-07 16:00:00 | NVDA | Stock | 0.19 | 0.1911 | 0.189 | 0.1909 | 7453200.0 |
| 2004-12-07 17:00:00 | NVDA | Stock | 0.19 | 0.1908 | 0.19 | 0.1907 | 1560600.0 |
| 2004-12-07 18:00:00 | NVDA | Stock | 0.1907 | 0.1908 | 0.1907 | 0.1907 | 404400.0 |
| 2004-12-07 08:00:00 | AMZN | Stock | 1.97 | 1.989 | 1.97 | 1.9855 | 30000.0 |
| 2004-12-07 09:00:00 | AMZN | Stock | 1.985 | 1.985 | 1.954 | 1.981 | 11889360.0 |
| 2004-12-07 10:00:00 | AMZN | Stock | 1.981 | 1.9875 | 1.9685 | 1.974 | 11564180.0 |
| 2004-12-07 11:00:00 | AMZN | Stock | 1.974 | 1.983 | 1.973 | 1.98 | 8614080.0 |
| 2004-12-07 12:00:00 | AMZN | Stock | 1.98 | 1.985 | 1.974 | 1.975 | 5608200.0 |
| 2004-12-07 13:00:00 | AMZN | Stock | 1.9755 | 1.9755 | 1.9424 | 1.949 | 15458140.0 |
| 2004-12-07 14:00:00 | AMZN | Stock | 1.949 | 1.949 | 1.912 | 1.912 | 27094040.0 |
| 2004-12-07 15:00:00 | AMZN | Stock | 1.912 | 1.9165 | 1.9025 | 1.9105 | 40116560.0 |
| 2004-12-07 16:00:00 | AMZN | Stock | 1.9105 | 1.9375 | 1.91 | 1.9145 | 7937760.0 |
| 2004-12-07 17:00:00 | AMZN | Stock | 1.9112 | 1.917 | 1.9112 | 1.917 | 567840.0 |
| 2004-12-07 18:00:00 | AMZN | Stock | 1.917 | 1.917 | 1.917 | 1.917 | 4000.0 |
| 2004-12-07 08:00:00 | CL | Stock | 23.625 | 23.68 | 23.505 | 23.625 | 23000.0 |
| 2004-12-07 09:00:00 | CL | Stock | 23.72 | 24.345 | 23.72 | 24.175 | 3690000.0 |
| 2004-12-07 10:00:00 | CL | Stock | 24.17 | 24.6 | 24.165 | 24.565 | 5537600.0 |
| 2004-12-07 11:00:00 | CL | Stock | 24.575 | 24.59 | 24.42 | 24.475 | 2621400.0 |
| 2004-12-07 12:00:00 | CL | Stock | 24.48 | 24.545 | 24.45 | 24.48 | 3023200.0 |
| 2004-12-07 13:00:00 | CL | Stock | 24.48 | 24.75 | 24.44 | 24.705 | 4241800.0 |
> showing 50 of 25,651 rows — these rows as CSV