PREVIEW / stock_1hour / 2004-05-10
file: by_date/stock_1hour/2004/2004-05-10.parquet size: 527 KB rows: 24,948 symbols: 1,779
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-05-10 08:00:00 | AAPL | Stock | 0.4734 | 0.4734 | 0.4688 | 0.4688 | 187600.0 |
| 2004-05-10 09:00:00 | AAPL | Stock | 0.4689 | 0.4761 | 0.465 | 0.467 | 26228608.0 |
| 2004-05-10 10:00:00 | AAPL | Stock | 0.467 | 0.4702 | 0.4646 | 0.4666 | 34261416.0 |
| 2004-05-10 11:00:00 | AAPL | Stock | 0.4666 | 0.4671 | 0.4643 | 0.4655 | 23246384.0 |
| 2004-05-10 12:00:00 | AAPL | Stock | 0.4655 | 0.472 | 0.4652 | 0.472 | 20527864.0 |
| 2004-05-10 13:00:00 | AAPL | Stock | 0.472 | 0.475 | 0.4663 | 0.4673 | 31807608.0 |
| 2004-05-10 14:00:00 | AAPL | Stock | 0.4673 | 0.468 | 0.4643 | 0.4673 | 28890232.0 |
| 2004-05-10 15:00:00 | AAPL | Stock | 0.4671 | 0.4686 | 0.4634 | 0.4682 | 40108768.0 |
| 2004-05-10 16:00:00 | AAPL | Stock | 0.4677 | 0.4693 | 0.4664 | 0.4693 | 4136384.0 |
| 2004-05-10 17:00:00 | AAPL | Stock | 0.4693 | 0.4695 | 0.4693 | 0.4695 | 2849168.0 |
| 2004-05-10 08:00:00 | MSFT | Stock | 25.64 | 25.66 | 25.55 | 25.61 | 57271.0 |
| 2004-05-10 09:00:00 | MSFT | Stock | 25.62 | 25.86 | 25.57 | 25.81 | 7245813.0 |
| 2004-05-10 10:00:00 | MSFT | Stock | 25.82 | 25.88 | 25.71 | 25.85 | 9188400.0 |
| 2004-05-10 11:00:00 | MSFT | Stock | 25.84 | 25.96 | 25.78 | 25.87 | 9980732.0 |
| 2004-05-10 12:00:00 | MSFT | Stock | 25.869 | 26.0 | 25.81 | 25.99 | 5343414.0 |
| 2004-05-10 13:00:00 | MSFT | Stock | 25.99 | 26.05 | 25.83 | 25.85 | 5226457.0 |
| 2004-05-10 14:00:00 | MSFT | Stock | 25.85 | 25.93 | 25.8 | 25.88 | 6154310.0 |
| 2004-05-10 15:00:00 | MSFT | Stock | 25.88 | 25.97 | 25.8 | 25.93 | 11016678.0 |
| 2004-05-10 16:00:00 | MSFT | Stock | 25.93 | 25.99 | 25.85 | 25.93 | 1707120.0 |
| 2004-05-10 17:00:00 | MSFT | Stock | 25.96 | 25.96 | 25.9416 | 25.95 | 349150.0 |
| 2004-05-10 18:00:00 | MSFT | Stock | 25.92 | 25.92 | 25.92 | 25.92 | 5000.0 |
| 2004-05-10 08:00:00 | NVDA | Stock | 0.1671 | 0.1783 | 0.1671 | 0.1772 | 312000.0 |
| 2004-05-10 09:00:00 | NVDA | Stock | 0.1791 | 0.1813 | 0.1777 | 0.1788 | 70721400.0 |
| 2004-05-10 10:00:00 | NVDA | Stock | 0.1785 | 0.1789 | 0.175 | 0.1769 | 129433680.0 |
| 2004-05-10 11:00:00 | NVDA | Stock | 0.1769 | 0.1772 | 0.1729 | 0.1748 | 99207600.0 |
| 2004-05-10 12:00:00 | NVDA | Stock | 0.1747 | 0.1779 | 0.1747 | 0.1778 | 44889120.0 |
| 2004-05-10 13:00:00 | NVDA | Stock | 0.1778 | 0.1791 | 0.1762 | 0.1767 | 65360880.0 |
| 2004-05-10 14:00:00 | NVDA | Stock | 0.1767 | 0.1777 | 0.1756 | 0.1772 | 49159800.0 |
| 2004-05-10 15:00:00 | NVDA | Stock | 0.1769 | 0.1775 | 0.175 | 0.1767 | 83502720.0 |
| 2004-05-10 16:00:00 | NVDA | Stock | 0.1769 | 0.1779 | 0.1767 | 0.1779 | 1752000.0 |
| 2004-05-10 17:00:00 | NVDA | Stock | 0.1771 | 0.1775 | 0.1771 | 0.1775 | 2068560.0 |
| 2004-05-10 18:00:00 | NVDA | Stock | 0.1775 | 0.1775 | 0.1775 | 0.1775 | 24000.0 |
| 2004-05-10 08:00:00 | AMZN | Stock | 2.08 | 2.0895 | 2.0605 | 2.0635 | 183420.0 |
| 2004-05-10 09:00:00 | AMZN | Stock | 2.0675 | 2.095 | 2.051 | 2.068 | 29186200.0 |
| 2004-05-10 10:00:00 | AMZN | Stock | 2.0685 | 2.077 | 2.0415 | 2.05 | 28508340.0 |
| 2004-05-10 11:00:00 | AMZN | Stock | 2.051 | 2.0555 | 2.0295 | 2.047 | 22167240.0 |
| 2004-05-10 12:00:00 | AMZN | Stock | 2.046 | 2.075 | 2.0455 | 2.0705 | 13836240.0 |
| 2004-05-10 13:00:00 | AMZN | Stock | 2.0705 | 2.1074 | 2.068 | 2.0775 | 29626320.0 |
| 2004-05-10 14:00:00 | AMZN | Stock | 2.078 | 2.083 | 2.0475 | 2.054 | 16891340.0 |
| 2004-05-10 15:00:00 | AMZN | Stock | 2.054 | 2.0635 | 2.041 | 2.0615 | 27080940.0 |
| 2004-05-10 16:00:00 | AMZN | Stock | 2.063 | 2.0695 | 2.055 | 2.06 | 9058920.0 |
| 2004-05-10 17:00:00 | AMZN | Stock | 2.0609 | 2.067 | 2.06 | 2.06 | 798760.0 |
| 2004-05-10 09:00:00 | CL | Stock | 28.725 | 28.94 | 28.69 | 28.72 | 261200.0 |
| 2004-05-10 10:00:00 | CL | Stock | 28.72 | 28.785 | 28.49 | 28.655 | 723400.0 |
| 2004-05-10 11:00:00 | CL | Stock | 28.65 | 28.71 | 28.575 | 28.635 | 444000.0 |
| 2004-05-10 12:00:00 | CL | Stock | 28.63 | 28.715 | 28.595 | 28.695 | 245800.0 |
| 2004-05-10 13:00:00 | CL | Stock | 28.725 | 28.725 | 28.565 | 28.585 | 390000.0 |
| 2004-05-10 14:00:00 | CL | Stock | 28.585 | 28.595 | 28.44 | 28.54 | 418600.0 |
| 2004-05-10 15:00:00 | CL | Stock | 28.54 | 28.575 | 28.435 | 28.52 | 689400.0 |
| 2004-05-10 16:00:00 | CL | Stock | 28.52 | 28.52 | 28.505 | 28.505 | 3400.0 |
> showing 50 of 24,948 rows — these rows as CSV