PREVIEW / stock_1hour / 2000-05-11
file: by_date/stock_1hour/2000/2000-05-11.parquet size: 273 KB rows: 14,080 symbols: 1,155
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-05-11 09:00:00 | AAPL | Stock | 0.9051 | 0.9096 | 0.8884 | 0.8929 | 56044800.0 |
| 2000-05-11 10:00:00 | AAPL | Stock | 0.8926 | 0.8973 | 0.8839 | 0.894 | 101976000.0 |
| 2000-05-11 11:00:00 | AAPL | Stock | 0.894 | 0.9141 | 0.8906 | 0.9085 | 86889600.0 |
| 2000-05-11 12:00:00 | AAPL | Stock | 0.909 | 0.923 | 0.9057 | 0.9113 | 50724800.0 |
| 2000-05-11 13:00:00 | AAPL | Stock | 0.9113 | 0.9163 | 0.9096 | 0.9152 | 37318400.0 |
| 2000-05-11 14:00:00 | AAPL | Stock | 0.9157 | 0.9269 | 0.9063 | 0.9263 | 57019200.0 |
| 2000-05-11 15:00:00 | AAPL | Stock | 0.9266 | 0.9308 | 0.9129 | 0.918 | 80572800.0 |
| 2000-05-11 16:00:00 | AAPL | Stock | 0.918 | 0.918 | 0.9174 | 0.918 | 2273600.0 |
| 2000-05-11 09:00:00 | MSFT | Stock | 33.3125 | 33.4375 | 32.9375 | 33.0938 | 7928800.0 |
| 2000-05-11 10:00:00 | MSFT | Stock | 33.0312 | 33.75 | 33.0312 | 33.5 | 11573000.0 |
| 2000-05-11 11:00:00 | MSFT | Stock | 33.5312 | 33.625 | 33.2812 | 33.4375 | 10549600.0 |
| 2000-05-11 12:00:00 | MSFT | Stock | 33.5 | 33.5625 | 33.3438 | 33.4375 | 3618600.0 |
| 2000-05-11 13:00:00 | MSFT | Stock | 33.4375 | 33.75 | 33.4062 | 33.6562 | 5206800.0 |
| 2000-05-11 14:00:00 | MSFT | Stock | 33.625 | 34.0625 | 33.4375 | 34.0312 | 6830600.0 |
| 2000-05-11 15:00:00 | MSFT | Stock | 34.0312 | 34.0312 | 33.625 | 33.9375 | 9488800.0 |
| 2000-05-11 16:00:00 | MSFT | Stock | 33.9375 | 33.9688 | 33.9375 | 33.9375 | 84800.0 |
| 2000-05-11 09:00:00 | NVDA | Stock | 0.1667 | 0.1729 | 0.1654 | 0.166 | 41328000.0 |
| 2000-05-11 10:00:00 | NVDA | Stock | 0.1659 | 0.1686 | 0.1656 | 0.1667 | 96432000.0 |
| 2000-05-11 11:00:00 | NVDA | Stock | 0.1674 | 0.1698 | 0.1664 | 0.1682 | 24960000.0 |
| 2000-05-11 12:00:00 | NVDA | Stock | 0.1678 | 0.168 | 0.1645 | 0.1671 | 9264000.0 |
| 2000-05-11 13:00:00 | NVDA | Stock | 0.1671 | 0.168 | 0.1664 | 0.1678 | 3456000.0 |
| 2000-05-11 14:00:00 | NVDA | Stock | 0.168 | 0.1687 | 0.1656 | 0.1674 | 22848000.0 |
| 2000-05-11 15:00:00 | NVDA | Stock | 0.1685 | 0.1743 | 0.1677 | 0.1714 | 31392000.0 |
| 2000-05-11 16:00:00 | NVDA | Stock | 0.1714 | 0.1714 | 0.1714 | 0.1714 | 96000.0 |
| 2000-05-11 09:00:00 | AMZN | Stock | 2.6969 | 2.7 | 2.5469 | 2.5563 | 19374000.0 |
| 2000-05-11 10:00:00 | AMZN | Stock | 2.5578 | 2.75 | 2.5531 | 2.6922 | 26778000.0 |
| 2000-05-11 11:00:00 | AMZN | Stock | 2.6906 | 2.7875 | 2.6719 | 2.75 | 18508000.0 |
| 2000-05-11 12:00:00 | AMZN | Stock | 2.75 | 2.7688 | 2.7312 | 2.7469 | 7944000.0 |
| 2000-05-11 13:00:00 | AMZN | Stock | 2.75 | 2.7531 | 2.7125 | 2.7125 | 8484000.0 |
| 2000-05-11 14:00:00 | AMZN | Stock | 2.7219 | 2.7625 | 2.7156 | 2.7469 | 10400000.0 |
| 2000-05-11 15:00:00 | AMZN | Stock | 2.75 | 2.7625 | 2.725 | 2.7438 | 13892000.0 |
| 2000-05-11 09:00:00 | CL | Stock | 29.5 | 29.6875 | 29.3125 | 29.6875 | 256400.0 |
| 2000-05-11 10:00:00 | CL | Stock | 29.75 | 29.9375 | 29.5312 | 29.7188 | 774600.0 |
| 2000-05-11 11:00:00 | CL | Stock | 29.7188 | 29.7188 | 29.5938 | 29.6875 | 296000.0 |
| 2000-05-11 12:00:00 | CL | Stock | 29.7188 | 29.875 | 29.625 | 29.875 | 297200.0 |
| 2000-05-11 13:00:00 | CL | Stock | 29.875 | 30.25 | 29.8125 | 30.125 | 878000.0 |
| 2000-05-11 14:00:00 | CL | Stock | 30.0938 | 30.2812 | 30.0 | 30.1875 | 560800.0 |
| 2000-05-11 15:00:00 | CL | Stock | 30.2188 | 30.375 | 30.0625 | 30.0938 | 939600.0 |
| 2000-05-11 16:00:00 | CL | Stock | 30.0938 | 30.0938 | 30.0938 | 30.0938 | 40400.0 |
> showing 39 of 14,080 rows — these rows as CSV