PREVIEW / stock_1hour / 2004-03-10
file: by_date/stock_1hour/2004/2004-03-10.parquet size: 507 KB rows: 23,133 symbols: 1,729
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-03-10 08:00:00 | AAPL | Stock | 0.4848 | 0.4888 | 0.482 | 0.4841 | 1892800.0 |
| 2004-03-10 09:00:00 | AAPL | Stock | 0.4821 | 0.4911 | 0.4811 | 0.4902 | 84638344.0 |
| 2004-03-10 10:00:00 | AAPL | Stock | 0.4902 | 0.5025 | 0.4884 | 0.4998 | 247807560.0 |
| 2004-03-10 11:00:00 | AAPL | Stock | 0.4998 | 0.5025 | 0.4973 | 0.4982 | 137426016.0 |
| 2004-03-10 12:00:00 | AAPL | Stock | 0.4982 | 0.4988 | 0.4961 | 0.4961 | 76434736.0 |
| 2004-03-10 13:00:00 | AAPL | Stock | 0.4961 | 0.4963 | 0.4875 | 0.4936 | 108597048.0 |
| 2004-03-10 14:00:00 | AAPL | Stock | 0.4936 | 0.4959 | 0.4904 | 0.4916 | 72803080.0 |
| 2004-03-10 15:00:00 | AAPL | Stock | 0.4916 | 0.4946 | 0.4889 | 0.4946 | 119143248.0 |
| 2004-03-10 16:00:00 | AAPL | Stock | 0.4943 | 0.4954 | 0.4928 | 0.4939 | 7708568.0 |
| 2004-03-10 17:00:00 | AAPL | Stock | 0.4943 | 0.4943 | 0.4933 | 0.4938 | 284032.0 |
| 2004-03-10 08:00:00 | MSFT | Stock | 25.76 | 25.76 | 25.71 | 25.75 | 16695.0 |
| 2004-03-10 09:00:00 | MSFT | Stock | 25.74 | 25.8 | 25.56 | 25.62 | 5028842.0 |
| 2004-03-10 10:00:00 | MSFT | Stock | 25.62 | 25.7 | 25.54 | 25.64 | 9144185.0 |
| 2004-03-10 11:00:00 | MSFT | Stock | 25.639 | 25.68 | 25.57 | 25.64 | 6091782.0 |
| 2004-03-10 12:00:00 | MSFT | Stock | 25.64 | 25.7 | 25.59 | 25.69 | 6569107.0 |
| 2004-03-10 13:00:00 | MSFT | Stock | 25.68 | 25.7 | 25.569 | 25.64 | 8065831.0 |
| 2004-03-10 14:00:00 | MSFT | Stock | 25.64 | 25.67 | 25.56 | 25.57 | 8679418.0 |
| 2004-03-10 15:00:00 | MSFT | Stock | 25.57 | 25.6 | 25.36 | 25.37 | 17201299.0 |
| 2004-03-10 16:00:00 | MSFT | Stock | 25.36 | 25.4 | 25.28 | 25.31 | 798342.0 |
| 2004-03-10 17:00:00 | MSFT | Stock | 25.36 | 25.36 | 25.3 | 25.33 | 67177.0 |
| 2004-03-10 18:00:00 | MSFT | Stock | 25.33 | 25.33 | 25.31 | 25.32 | 2490.0 |
| 2004-03-10 08:00:00 | NVDA | Stock | 0.1772 | 0.1773 | 0.1772 | 0.1773 | 2556000.0 |
| 2004-03-10 09:00:00 | NVDA | Stock | 0.1775 | 0.1803 | 0.1771 | 0.1785 | 33920280.0 |
| 2004-03-10 10:00:00 | NVDA | Stock | 0.1785 | 0.1801 | 0.1772 | 0.1793 | 45495600.0 |
| 2004-03-10 11:00:00 | NVDA | Stock | 0.1792 | 0.1797 | 0.1771 | 0.1779 | 53610720.0 |
| 2004-03-10 12:00:00 | NVDA | Stock | 0.178 | 0.1781 | 0.1765 | 0.1776 | 27456600.0 |
| 2004-03-10 13:00:00 | NVDA | Stock | 0.1777 | 0.1777 | 0.1734 | 0.1743 | 61603200.0 |
| 2004-03-10 14:00:00 | NVDA | Stock | 0.1743 | 0.1766 | 0.1737 | 0.1756 | 75433680.0 |
| 2004-03-10 15:00:00 | NVDA | Stock | 0.1758 | 0.1762 | 0.1736 | 0.1746 | 94772760.0 |
| 2004-03-10 16:00:00 | NVDA | Stock | 0.1742 | 0.175 | 0.1742 | 0.1743 | 1381920.0 |
| 2004-03-10 17:00:00 | NVDA | Stock | 0.1743 | 0.175 | 0.1743 | 0.1747 | 333720.0 |
| 2004-03-10 18:00:00 | NVDA | Stock | 0.1747 | 0.1748 | 0.1747 | 0.1748 | 36960.0 |
| 2004-03-10 08:00:00 | AMZN | Stock | 2.1355 | 2.1355 | 2.1355 | 2.1355 | 9180.0 |
| 2004-03-10 09:00:00 | AMZN | Stock | 2.1375 | 2.1565 | 2.128 | 2.15 | 10274680.0 |
| 2004-03-10 10:00:00 | AMZN | Stock | 2.148 | 2.16 | 2.137 | 2.1525 | 11377280.0 |
| 2004-03-10 11:00:00 | AMZN | Stock | 2.1525 | 2.154 | 2.1155 | 2.124 | 18073860.0 |
| 2004-03-10 12:00:00 | AMZN | Stock | 2.124 | 2.1285 | 2.1155 | 2.127 | 8227720.0 |
| 2004-03-10 13:00:00 | AMZN | Stock | 2.127 | 2.1275 | 2.0785 | 2.094 | 23412200.0 |
| 2004-03-10 14:00:00 | AMZN | Stock | 2.0935 | 2.1055 | 2.087 | 2.0895 | 14033940.0 |
| 2004-03-10 15:00:00 | AMZN | Stock | 2.0895 | 2.091 | 2.073 | 2.0775 | 30459600.0 |
| 2004-03-10 16:00:00 | AMZN | Stock | 2.0775 | 2.0795 | 2.075 | 2.075 | 618380.0 |
| 2004-03-10 17:00:00 | AMZN | Stock | 2.0775 | 2.0775 | 2.075 | 2.075 | 57200.0 |
| 2004-03-10 09:00:00 | CL | Stock | 28.275 | 28.475 | 28.275 | 28.355 | 476600.0 |
| 2004-03-10 10:00:00 | CL | Stock | 28.36 | 28.535 | 28.3 | 28.415 | 1272400.0 |
| 2004-03-10 11:00:00 | CL | Stock | 28.425 | 28.625 | 28.42 | 28.58 | 658800.0 |
| 2004-03-10 12:00:00 | CL | Stock | 28.59 | 28.61 | 28.445 | 28.485 | 421800.0 |
| 2004-03-10 13:00:00 | CL | Stock | 28.49 | 28.49 | 28.305 | 28.45 | 415000.0 |
| 2004-03-10 14:00:00 | CL | Stock | 28.445 | 28.57 | 28.445 | 28.495 | 260200.0 |
| 2004-03-10 15:00:00 | CL | Stock | 28.495 | 28.515 | 28.225 | 28.285 | 962400.0 |
| 2004-03-10 16:00:00 | CL | Stock | 28.285 | 28.4435 | 28.275 | 28.277 | 407400.0 |
> showing 50 of 23,133 rows — these rows as CSV