PREVIEW / stock_1hour / 2004-12-08
file: by_date/stock_1hour/2004/2004-12-08.parquet size: 534 KB rows: 24,983 symbols: 1,883
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-08 08:00:00 | AAPL | Stock | 1.1205 | 1.1334 | 1.1205 | 1.1295 | 1698480.0 |
| 2004-12-08 09:00:00 | AAPL | Stock | 1.1296 | 1.132 | 1.108 | 1.1225 | 128420544.0 |
| 2004-12-08 10:00:00 | AAPL | Stock | 1.1225 | 1.1455 | 1.122 | 1.1377 | 191365440.0 |
| 2004-12-08 11:00:00 | AAPL | Stock | 1.1375 | 1.1505 | 1.1325 | 1.1439 | 78955856.0 |
| 2004-12-08 12:00:00 | AAPL | Stock | 1.1445 | 1.1471 | 1.1416 | 1.1445 | 53855256.0 |
| 2004-12-08 13:00:00 | AAPL | Stock | 1.145 | 1.1464 | 1.1302 | 1.1375 | 59561600.0 |
| 2004-12-08 14:00:00 | AAPL | Stock | 1.1375 | 1.1389 | 1.1271 | 1.1279 | 65422000.0 |
| 2004-12-08 15:00:00 | AAPL | Stock | 1.1279 | 1.1318 | 1.1223 | 1.1295 | 89197192.0 |
| 2004-12-08 16:00:00 | AAPL | Stock | 1.1302 | 1.1336 | 1.1279 | 1.1279 | 4504696.0 |
| 2004-12-08 17:00:00 | AAPL | Stock | 1.1284 | 1.1321 | 1.1246 | 1.1321 | 394912.0 |
| 2004-12-08 18:00:00 | AAPL | Stock | 1.1313 | 1.1321 | 1.1288 | 1.1302 | 5717600.0 |
| 2004-12-08 08:00:00 | MSFT | Stock | 27.1 | 27.1 | 27.04 | 27.06 | 26213.0 |
| 2004-12-08 09:00:00 | MSFT | Stock | 27.06 | 27.15 | 26.98 | 27.07 | 6519995.0 |
| 2004-12-08 10:00:00 | MSFT | Stock | 27.062 | 27.071 | 26.95 | 26.96 | 15331175.0 |
| 2004-12-08 11:00:00 | MSFT | Stock | 26.96 | 27.04 | 26.93 | 27.03 | 10431329.0 |
| 2004-12-08 12:00:00 | MSFT | Stock | 27.03 | 27.09 | 27.0 | 27.02 | 8530535.0 |
| 2004-12-08 13:00:00 | MSFT | Stock | 27.021 | 27.27 | 27.01 | 27.23 | 15332624.0 |
| 2004-12-08 14:00:00 | MSFT | Stock | 27.24 | 27.35 | 27.21 | 27.27 | 12491440.0 |
| 2004-12-08 15:00:00 | MSFT | Stock | 27.271 | 27.35 | 27.22 | 27.35 | 15968983.0 |
| 2004-12-08 16:00:00 | MSFT | Stock | 27.35 | 27.37 | 27.26 | 27.3 | 6706375.0 |
| 2004-12-08 17:00:00 | MSFT | Stock | 27.27 | 27.36 | 27.26 | 27.29 | 22470.0 |
| 2004-12-08 18:00:00 | MSFT | Stock | 27.29 | 27.29 | 27.27 | 27.28 | 6900.0 |
| 2004-12-08 08:00:00 | NVDA | Stock | 0.1937 | 0.1967 | 0.19 | 0.1949 | 7641840.0 |
| 2004-12-08 09:00:00 | NVDA | Stock | 0.1938 | 0.1942 | 0.1907 | 0.1919 | 146461560.0 |
| 2004-12-08 10:00:00 | NVDA | Stock | 0.192 | 0.1958 | 0.1919 | 0.1945 | 201163800.0 |
| 2004-12-08 11:00:00 | NVDA | Stock | 0.1945 | 0.1954 | 0.1929 | 0.1933 | 121134120.0 |
| 2004-12-08 12:00:00 | NVDA | Stock | 0.1933 | 0.1949 | 0.1927 | 0.1943 | 89623680.0 |
| 2004-12-08 13:00:00 | NVDA | Stock | 0.1942 | 0.1947 | 0.1935 | 0.1942 | 58744560.0 |
| 2004-12-08 14:00:00 | NVDA | Stock | 0.1943 | 0.1944 | 0.1928 | 0.193 | 71455200.0 |
| 2004-12-08 15:00:00 | NVDA | Stock | 0.1931 | 0.1937 | 0.1913 | 0.1925 | 147372120.0 |
| 2004-12-08 16:00:00 | NVDA | Stock | 0.1925 | 0.1929 | 0.1908 | 0.1917 | 8347320.0 |
| 2004-12-08 17:00:00 | NVDA | Stock | 0.1904 | 0.1923 | 0.1892 | 0.1902 | 1319280.0 |
| 2004-12-08 18:00:00 | NVDA | Stock | 0.1902 | 0.1923 | 0.1892 | 0.1895 | 36628560.0 |
| 2004-12-08 08:00:00 | AMZN | Stock | 1.915 | 1.921 | 1.915 | 1.9175 | 51500.0 |
| 2004-12-08 09:00:00 | AMZN | Stock | 1.9175 | 1.932 | 1.8995 | 1.906 | 19839640.0 |
| 2004-12-08 10:00:00 | AMZN | Stock | 1.9055 | 1.934 | 1.9025 | 1.925 | 28469800.0 |
| 2004-12-08 11:00:00 | AMZN | Stock | 1.9235 | 1.9395 | 1.9165 | 1.9365 | 14393240.0 |
| 2004-12-08 12:00:00 | AMZN | Stock | 1.937 | 1.942 | 1.9305 | 1.9366 | 9748100.0 |
| 2004-12-08 13:00:00 | AMZN | Stock | 1.937 | 1.945 | 1.936 | 1.9405 | 9355520.0 |
| 2004-12-08 14:00:00 | AMZN | Stock | 1.941 | 1.955 | 1.9385 | 1.946 | 14316880.0 |
| 2004-12-08 15:00:00 | AMZN | Stock | 1.946 | 1.954 | 1.9325 | 1.9335 | 25311420.0 |
| 2004-12-08 16:00:00 | AMZN | Stock | 1.935 | 1.9375 | 1.9325 | 1.936 | 2020620.0 |
| 2004-12-08 17:00:00 | AMZN | Stock | 1.9325 | 1.936 | 1.9325 | 1.9325 | 130320.0 |
| 2004-12-08 18:00:00 | AMZN | Stock | 1.933 | 1.933 | 1.933 | 1.933 | 28000.0 |
| 2004-12-08 08:00:00 | CL | Stock | 25.1 | 25.15 | 25.1 | 25.125 | 3800.0 |
| 2004-12-08 09:00:00 | CL | Stock | 25.165 | 25.4 | 24.925 | 25.025 | 1727800.0 |
| 2004-12-08 10:00:00 | CL | Stock | 25.022 | 25.07 | 24.955 | 25.025 | 2902200.0 |
| 2004-12-08 11:00:00 | CL | Stock | 25.025 | 25.08 | 24.84 | 24.875 | 2350800.0 |
| 2004-12-08 12:00:00 | CL | Stock | 24.875 | 25.0 | 24.87 | 24.955 | 1205400.0 |
| 2004-12-08 13:00:00 | CL | Stock | 24.96 | 24.96 | 24.89 | 24.91 | 987400.0 |
> showing 50 of 24,983 rows — these rows as CSV