PREVIEW / stock_30min / 2004-11-22
file: by_date/stock_30min/2004/2004-11-22.parquet size: 808 KB rows: 43,421 symbols: 1,877
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-11-22 08:00:00 | AAPL | Stock | 1.027 | 1.0446 | 0.9839 | 1.0268 | 15513680.0 |
| 2004-11-22 08:30:00 | AAPL | Stock | 1.0268 | 1.0445 | 1.025 | 1.0384 | 13217176.0 |
| 2004-11-22 09:00:00 | AAPL | Stock | 1.0375 | 1.0482 | 0.9884 | 1.0355 | 31099600.0 |
| 2004-11-22 09:30:00 | AAPL | Stock | 1.0361 | 1.0945 | 1.0339 | 1.0929 | 524552784.0 |
| 2004-11-22 10:00:00 | AAPL | Stock | 1.093 | 1.1295 | 1.0923 | 1.1095 | 486976840.0 |
| 2004-11-22 10:30:00 | AAPL | Stock | 1.1091 | 1.1107 | 1.095 | 1.1038 | 233287656.0 |
| 2004-11-22 11:00:00 | AAPL | Stock | 1.1039 | 1.1039 | 1.0861 | 1.0914 | 162785336.0 |
| 2004-11-22 11:30:00 | AAPL | Stock | 1.0904 | 1.0971 | 1.0863 | 1.094 | 108012632.0 |
| 2004-11-22 12:00:00 | AAPL | Stock | 1.0934 | 1.0938 | 1.0786 | 1.0825 | 91012824.0 |
| 2004-11-22 12:30:00 | AAPL | Stock | 1.0829 | 1.0946 | 1.0748 | 1.0889 | 115626560.0 |
| 2004-11-22 13:00:00 | AAPL | Stock | 1.0891 | 1.0988 | 1.088 | 1.0948 | 87937248.0 |
| 2004-11-22 13:30:00 | AAPL | Stock | 1.095 | 1.0988 | 1.0896 | 1.0916 | 81766944.0 |
| 2004-11-22 14:00:00 | AAPL | Stock | 1.0918 | 1.0988 | 1.0879 | 1.0988 | 85154496.0 |
| 2004-11-22 14:30:00 | AAPL | Stock | 1.0986 | 1.1034 | 1.0916 | 1.0979 | 97103608.0 |
| 2004-11-22 15:00:00 | AAPL | Stock | 1.0982 | 1.0991 | 1.0868 | 1.0975 | 145074552.0 |
| 2004-11-22 15:30:00 | AAPL | Stock | 1.0975 | 1.102 | 1.0939 | 1.0966 | 217438256.0 |
| 2004-11-22 16:00:00 | AAPL | Stock | 1.0957 | 1.0973 | 1.0895 | 1.0945 | 17692808.0 |
| 2004-11-22 16:30:00 | AAPL | Stock | 1.0973 | 1.0982 | 1.0948 | 1.0963 | 1936816.0 |
| 2004-11-22 17:00:00 | AAPL | Stock | 1.0959 | 1.098 | 1.0957 | 1.0968 | 695296.0 |
| 2004-11-22 17:30:00 | AAPL | Stock | 1.0977 | 1.098 | 1.0973 | 1.0973 | 786016.0 |
| 2004-11-22 18:00:00 | AAPL | Stock | 1.097 | 1.0979 | 1.0959 | 1.0971 | 1305416.0 |
| 2004-11-22 08:00:00 | MSFT | Stock | 26.87 | 26.87 | 26.76 | 26.76 | 91806.0 |
| 2004-11-22 08:30:00 | MSFT | Stock | 26.76 | 26.8 | 26.75 | 26.79 | 25670.0 |
| 2004-11-22 09:00:00 | MSFT | Stock | 26.79 | 26.85 | 26.7 | 26.77 | 153676.0 |
| 2004-11-22 09:30:00 | MSFT | Stock | 26.76 | 26.82 | 26.74 | 26.78 | 8161919.0 |
| 2004-11-22 10:00:00 | MSFT | Stock | 26.77 | 26.78 | 26.62 | 26.65 | 10765188.0 |
| 2004-11-22 10:30:00 | MSFT | Stock | 26.65 | 26.66 | 26.38 | 26.45 | 12458611.0 |
| 2004-11-22 11:00:00 | MSFT | Stock | 26.46 | 26.48 | 26.41 | 26.42 | 6158169.0 |
| 2004-11-22 11:30:00 | MSFT | Stock | 26.41 | 26.45 | 24.87 | 26.34 | 8248207.0 |
| 2004-11-22 12:00:00 | MSFT | Stock | 26.34 | 26.39 | 26.26 | 26.37 | 5264586.0 |
| 2004-11-22 12:30:00 | MSFT | Stock | 26.37 | 26.5 | 26.35 | 26.48 | 5139333.0 |
| 2004-11-22 13:00:00 | MSFT | Stock | 26.48 | 26.53 | 26.47 | 26.5 | 5350537.0 |
| 2004-11-22 13:30:00 | MSFT | Stock | 26.5 | 26.6 | 26.47 | 26.6 | 4748188.0 |
| 2004-11-22 14:00:00 | MSFT | Stock | 26.6 | 26.68 | 26.56 | 26.66 | 6341656.0 |
| 2004-11-22 14:30:00 | MSFT | Stock | 26.66 | 26.67 | 26.53 | 26.56 | 4381160.0 |
| 2004-11-22 15:00:00 | MSFT | Stock | 26.56 | 26.63 | 26.52 | 26.59 | 3763418.0 |
| 2004-11-22 15:30:00 | MSFT | Stock | 26.6 | 26.65 | 26.54 | 26.64 | 5661582.0 |
| 2004-11-22 16:00:00 | MSFT | Stock | 26.64 | 26.65 | 26.32 | 26.61 | 1271676.0 |
| 2004-11-22 16:30:00 | MSFT | Stock | 26.62 | 26.68 | 26.59 | 26.62 | 446973.0 |
| 2004-11-22 17:00:00 | MSFT | Stock | 26.63 | 26.65 | 26.59 | 26.61 | 7990.0 |
| 2004-11-22 17:30:00 | MSFT | Stock | 26.65 | 26.65 | 26.58 | 26.6 | 71890.0 |
| 2004-11-22 18:00:00 | MSFT | Stock | 26.6 | 26.61 | 26.58 | 26.61 | 8572.0 |
| 2004-11-22 08:00:00 | NVDA | Stock | 0.1584 | 0.1604 | 0.1583 | 0.1592 | 2580000.0 |
| 2004-11-22 08:30:00 | NVDA | Stock | 0.1592 | 0.1597 | 0.1592 | 0.1592 | 1065600.0 |
| 2004-11-22 09:00:00 | NVDA | Stock | 0.1592 | 0.1592 | 0.1581 | 0.1583 | 1680480.0 |
| 2004-11-22 09:30:00 | NVDA | Stock | 0.1586 | 0.1608 | 0.1571 | 0.1598 | 158393280.0 |
| 2004-11-22 10:00:00 | NVDA | Stock | 0.16 | 0.1602 | 0.159 | 0.1599 | 99101160.0 |
| 2004-11-22 10:30:00 | NVDA | Stock | 0.1599 | 0.16 | 0.1587 | 0.1593 | 42449760.0 |
| 2004-11-22 11:00:00 | NVDA | Stock | 0.1594 | 0.1594 | 0.1588 | 0.1592 | 17814000.0 |
| 2004-11-22 11:30:00 | NVDA | Stock | 0.1592 | 0.1597 | 0.1591 | 0.1595 | 25274040.0 |
> showing 50 of 43,421 rows — these rows as CSV