PREVIEW / stock_1hour / 2000-04-25
file: by_date/stock_1hour/2000/2000-04-25.parquet size: 280 KB rows: 14,351 symbols: 1,158
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-04-25 09:00:00 | AAPL | Stock | 1.0904 | 1.1161 | 1.0898 | 1.115 | 71736000.0 |
| 2000-04-25 10:00:00 | AAPL | Stock | 1.115 | 1.1217 | 1.096 | 1.0977 | 76764800.0 |
| 2000-04-25 11:00:00 | AAPL | Stock | 1.1027 | 1.1094 | 1.0938 | 1.1049 | 39088000.0 |
| 2000-04-25 12:00:00 | AAPL | Stock | 1.1049 | 1.1071 | 1.0965 | 1.1021 | 18076800.0 |
| 2000-04-25 13:00:00 | AAPL | Stock | 1.1027 | 1.1049 | 1.0965 | 1.0993 | 32312000.0 |
| 2000-04-25 14:00:00 | AAPL | Stock | 1.0993 | 1.1094 | 1.0965 | 1.1027 | 33398400.0 |
| 2000-04-25 15:00:00 | AAPL | Stock | 1.1027 | 1.1496 | 1.1016 | 1.1456 | 98918400.0 |
| 2000-04-25 16:00:00 | AAPL | Stock | 1.1456 | 1.1462 | 1.1445 | 1.1456 | 3046400.0 |
| 2000-04-25 09:00:00 | MSFT | Stock | 34.375 | 34.4375 | 33.875 | 34.3438 | 26899600.0 |
| 2000-04-25 10:00:00 | MSFT | Stock | 34.3125 | 34.3438 | 33.8125 | 34.1562 | 31377800.0 |
| 2000-04-25 11:00:00 | MSFT | Stock | 34.1875 | 34.2812 | 34.0 | 34.2188 | 17988400.0 |
| 2000-04-25 12:00:00 | MSFT | Stock | 34.2188 | 34.75 | 34.0938 | 34.4375 | 17839800.0 |
| 2000-04-25 13:00:00 | MSFT | Stock | 34.4375 | 34.5625 | 34.3438 | 34.4688 | 15218600.0 |
| 2000-04-25 14:00:00 | MSFT | Stock | 34.4688 | 34.6875 | 34.375 | 34.4688 | 12053800.0 |
| 2000-04-25 15:00:00 | MSFT | Stock | 34.4688 | 34.75 | 34.0312 | 34.625 | 23421600.0 |
| 2000-04-25 16:00:00 | MSFT | Stock | 34.6562 | 34.7188 | 34.625 | 34.6875 | 604200.0 |
| 2000-04-25 09:00:00 | NVDA | Stock | 0.1668 | 0.1708 | 0.1664 | 0.168 | 37632000.0 |
| 2000-04-25 10:00:00 | NVDA | Stock | 0.1672 | 0.1707 | 0.1664 | 0.1691 | 37920000.0 |
| 2000-04-25 11:00:00 | NVDA | Stock | 0.1687 | 0.1708 | 0.1669 | 0.1684 | 17712000.0 |
| 2000-04-25 12:00:00 | NVDA | Stock | 0.1686 | 0.175 | 0.1669 | 0.1686 | 31296000.0 |
| 2000-04-25 13:00:00 | NVDA | Stock | 0.1687 | 0.1708 | 0.1682 | 0.1708 | 8208000.0 |
| 2000-04-25 14:00:00 | NVDA | Stock | 0.1708 | 0.1763 | 0.1703 | 0.1763 | 48192000.0 |
| 2000-04-25 15:00:00 | NVDA | Stock | 0.1763 | 0.1823 | 0.1755 | 0.1771 | 59376000.0 |
| 2000-04-25 09:00:00 | AMZN | Stock | 2.5906 | 2.6938 | 2.5781 | 2.6813 | 20894000.0 |
| 2000-04-25 10:00:00 | AMZN | Stock | 2.675 | 2.7063 | 2.5813 | 2.6312 | 21176000.0 |
| 2000-04-25 11:00:00 | AMZN | Stock | 2.6312 | 2.65 | 2.5969 | 2.6125 | 16766000.0 |
| 2000-04-25 12:00:00 | AMZN | Stock | 2.6188 | 2.6188 | 2.5625 | 2.5719 | 8974000.0 |
| 2000-04-25 13:00:00 | AMZN | Stock | 2.5719 | 2.5906 | 2.55 | 2.5719 | 13178000.0 |
| 2000-04-25 14:00:00 | AMZN | Stock | 2.5719 | 2.5844 | 2.5125 | 2.5219 | 20366000.0 |
| 2000-04-25 15:00:00 | AMZN | Stock | 2.5281 | 2.6469 | 2.525 | 2.6219 | 33178000.0 |
| 2000-04-25 16:00:00 | AMZN | Stock | 2.6188 | 2.6219 | 2.6188 | 2.6219 | 566000.0 |
| 2000-04-25 09:00:00 | CL | Stock | 29.2812 | 29.625 | 29.1875 | 29.4062 | 587000.0 |
| 2000-04-25 10:00:00 | CL | Stock | 29.4062 | 29.6875 | 29.0625 | 29.5938 | 1061400.0 |
| 2000-04-25 11:00:00 | CL | Stock | 29.5625 | 29.7812 | 29.4062 | 29.7812 | 731200.0 |
| 2000-04-25 12:00:00 | CL | Stock | 29.7812 | 29.9688 | 29.6875 | 29.875 | 414200.0 |
| 2000-04-25 13:00:00 | CL | Stock | 29.875 | 30.0 | 29.625 | 29.875 | 435000.0 |
| 2000-04-25 14:00:00 | CL | Stock | 29.875 | 30.0 | 29.75 | 29.9688 | 548400.0 |
| 2000-04-25 15:00:00 | CL | Stock | 29.9688 | 30.0 | 29.5938 | 29.6562 | 590400.0 |
| 2000-04-25 16:00:00 | CL | Stock | 29.6562 | 29.6562 | 29.5938 | 29.5938 | 706800.0 |
> showing 39 of 14,351 rows — these rows as CSV