PREVIEW / stock_1hour / 2000-03-08
file: by_date/stock_1hour/2000/2000-03-08.parquet size: 281 KB rows: 14,627 symbols: 1,140
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 |
|---|---|---|---|---|---|---|---|
| 2000-03-08 09:00:00 | AAPL | Stock | 1.0971 | 1.0982 | 1.0781 | 1.0898 | 25838400.0 |
| 2000-03-08 10:00:00 | AAPL | Stock | 1.0882 | 1.1066 | 1.067 | 1.0681 | 53032000.0 |
| 2000-03-08 11:00:00 | AAPL | Stock | 1.067 | 1.0831 | 1.067 | 1.0703 | 34137600.0 |
| 2000-03-08 12:00:00 | AAPL | Stock | 1.0681 | 1.0831 | 1.0586 | 1.0667 | 29377600.0 |
| 2000-03-08 13:00:00 | AAPL | Stock | 1.0658 | 1.0675 | 1.0592 | 1.067 | 35000000.0 |
| 2000-03-08 14:00:00 | AAPL | Stock | 1.067 | 1.0915 | 1.0658 | 1.0887 | 40073600.0 |
| 2000-03-08 15:00:00 | AAPL | Stock | 1.0887 | 1.0929 | 1.0737 | 1.0887 | 40521600.0 |
| 2000-03-08 16:00:00 | AAPL | Stock | 1.0893 | 1.0893 | 1.0893 | 1.0893 | 1590400.0 |
| 2000-03-08 09:00:00 | MSFT | Stock | 46.9062 | 47.6875 | 46.5625 | 47.5938 | 14752000.0 |
| 2000-03-08 10:00:00 | MSFT | Stock | 47.625 | 47.9375 | 45.9375 | 46.0312 | 18493000.0 |
| 2000-03-08 11:00:00 | MSFT | Stock | 46.0625 | 47.25 | 45.5 | 47.0781 | 15770800.0 |
| 2000-03-08 12:00:00 | MSFT | Stock | 47.0781 | 47.7812 | 46.7812 | 47.0625 | 9935000.0 |
| 2000-03-08 13:00:00 | MSFT | Stock | 47.0625 | 47.5469 | 46.9688 | 47.4688 | 4966800.0 |
| 2000-03-08 14:00:00 | MSFT | Stock | 47.4375 | 47.875 | 47.25 | 47.6562 | 8945200.0 |
| 2000-03-08 15:00:00 | MSFT | Stock | 47.6562 | 48.0938 | 46.875 | 47.7812 | 14650600.0 |
| 2000-03-08 16:00:00 | MSFT | Stock | 47.7812 | 47.8438 | 47.7812 | 47.7812 | 368800.0 |
| 2000-03-08 09:00:00 | NVDA | Stock | 0.1734 | 0.174 | 0.1609 | 0.1625 | 110880000.0 |
| 2000-03-08 10:00:00 | NVDA | Stock | 0.1624 | 0.1687 | 0.162 | 0.1641 | 109152000.0 |
| 2000-03-08 11:00:00 | NVDA | Stock | 0.1641 | 0.169 | 0.1641 | 0.1679 | 140928000.0 |
| 2000-03-08 12:00:00 | NVDA | Stock | 0.1677 | 0.1747 | 0.1677 | 0.1704 | 81744000.0 |
| 2000-03-08 13:00:00 | NVDA | Stock | 0.1704 | 0.1721 | 0.1698 | 0.1708 | 37728000.0 |
| 2000-03-08 14:00:00 | NVDA | Stock | 0.1708 | 0.171 | 0.1674 | 0.169 | 31152000.0 |
| 2000-03-08 15:00:00 | NVDA | Stock | 0.1697 | 0.1766 | 0.169 | 0.1746 | 76992000.0 |
| 2000-03-08 16:00:00 | NVDA | Stock | 0.175 | 0.175 | 0.175 | 0.175 | 3072000.0 |
| 2000-03-08 09:00:00 | AMZN | Stock | 3.1625 | 3.1625 | 3.1062 | 3.1219 | 10494000.0 |
| 2000-03-08 10:00:00 | AMZN | Stock | 3.1219 | 3.125 | 3.0438 | 3.05 | 23456000.0 |
| 2000-03-08 11:00:00 | AMZN | Stock | 3.0469 | 3.1438 | 3.0281 | 3.1312 | 26140000.0 |
| 2000-03-08 12:00:00 | AMZN | Stock | 3.1281 | 3.1656 | 3.0875 | 3.0906 | 11156000.0 |
| 2000-03-08 13:00:00 | AMZN | Stock | 3.0875 | 3.1781 | 3.0875 | 3.175 | 9834000.0 |
| 2000-03-08 14:00:00 | AMZN | Stock | 3.1781 | 3.2375 | 3.1562 | 3.1969 | 19002000.0 |
| 2000-03-08 15:00:00 | AMZN | Stock | 3.2 | 3.2125 | 3.1062 | 3.1797 | 13126000.0 |
| 2000-03-08 16:00:00 | AMZN | Stock | 3.1844 | 3.1844 | 3.1781 | 3.1813 | 292000.0 |
| 2000-03-08 09:00:00 | CL | Stock | 23.5625 | 23.9375 | 23.2812 | 23.3438 | 1297600.0 |
| 2000-03-08 10:00:00 | CL | Stock | 23.25 | 23.375 | 22.0625 | 22.1875 | 3188000.0 |
| 2000-03-08 11:00:00 | CL | Stock | 22.1875 | 22.3125 | 21.6875 | 22.3125 | 2725600.0 |
| 2000-03-08 12:00:00 | CL | Stock | 22.25 | 22.4688 | 21.6875 | 21.75 | 1664600.0 |
| 2000-03-08 13:00:00 | CL | Stock | 21.7812 | 21.9688 | 21.3125 | 21.5 | 1992400.0 |
| 2000-03-08 14:00:00 | CL | Stock | 21.4688 | 21.5 | 21.1875 | 21.3438 | 1155200.0 |
| 2000-03-08 15:00:00 | CL | Stock | 21.3125 | 22.125 | 21.3125 | 21.9062 | 2300400.0 |
| 2000-03-08 16:00:00 | CL | Stock | 21.9062 | 22.0 | 21.9062 | 22.0 | 374800.0 |
| 2000-03-08 17:00:00 | CL | Stock | 21.9688 | 21.9688 | 21.9688 | 21.9688 | 200.0 |
> showing 41 of 14,627 rows — these rows as CSV