PREVIEW / stock_1hour / 2000-11-30
file: by_date/stock_1hour/2000/2000-11-30.parquet size: 320 KB rows: 16,731 symbols: 1,261
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-11-30 08:00:00 | AAPL | Stock | 0.2857 | 0.2991 | 0.2824 | 0.2902 | 14940800.0 |
| 2000-11-30 09:00:00 | AAPL | Stock | 0.2924 | 0.3025 | 0.2891 | 0.2946 | 113769600.0 |
| 2000-11-30 10:00:00 | AAPL | Stock | 0.2946 | 0.3036 | 0.2946 | 0.2958 | 84352800.0 |
| 2000-11-30 11:00:00 | AAPL | Stock | 0.2958 | 0.2969 | 0.2913 | 0.2924 | 122561600.0 |
| 2000-11-30 12:00:00 | AAPL | Stock | 0.2913 | 0.2924 | 0.2891 | 0.2902 | 99528800.0 |
| 2000-11-30 13:00:00 | AAPL | Stock | 0.2902 | 0.2924 | 0.2879 | 0.2879 | 87035200.0 |
| 2000-11-30 14:00:00 | AAPL | Stock | 0.2879 | 0.2969 | 0.2879 | 0.2958 | 100889600.0 |
| 2000-11-30 15:00:00 | AAPL | Stock | 0.2946 | 0.3013 | 0.2924 | 0.2958 | 78909600.0 |
| 2000-11-30 16:00:00 | AAPL | Stock | 0.2958 | 0.2958 | 0.2919 | 0.2958 | 29965600.0 |
| 2000-11-30 17:00:00 | AAPL | Stock | 0.2952 | 0.3013 | 0.2941 | 0.3013 | 1971200.0 |
| 2000-11-30 18:00:00 | AAPL | Stock | 0.2958 | 0.3013 | 0.2958 | 0.2991 | 168000.0 |
| 2000-11-30 08:00:00 | MSFT | Stock | 31.4375 | 31.5 | 31.0 | 31.0625 | 1416000.0 |
| 2000-11-30 09:00:00 | MSFT | Stock | 31.0938 | 31.5 | 30.5625 | 30.6875 | 25647200.0 |
| 2000-11-30 10:00:00 | MSFT | Stock | 30.6875 | 30.8438 | 30.125 | 30.1562 | 21893200.0 |
| 2000-11-30 11:00:00 | MSFT | Stock | 30.1562 | 30.25 | 29.5938 | 29.75 | 19564400.0 |
| 2000-11-30 12:00:00 | MSFT | Stock | 29.75 | 30.0 | 29.3125 | 29.3125 | 20440600.0 |
| 2000-11-30 13:00:00 | MSFT | Stock | 29.3125 | 29.3438 | 28.8125 | 29.0 | 23324200.0 |
| 2000-11-30 14:00:00 | MSFT | Stock | 29.0156 | 29.2812 | 28.6875 | 28.9688 | 20520200.0 |
| 2000-11-30 15:00:00 | MSFT | Stock | 28.9688 | 29.3125 | 28.5 | 28.6875 | 36129800.0 |
| 2000-11-30 16:00:00 | MSFT | Stock | 28.6875 | 29.4688 | 28.1875 | 28.3125 | 12557400.0 |
| 2000-11-30 17:00:00 | MSFT | Stock | 28.1875 | 28.75 | 28.1875 | 28.625 | 336000.0 |
| 2000-11-30 18:00:00 | MSFT | Stock | 28.6562 | 28.75 | 28.625 | 28.75 | 13600.0 |
| 2000-11-30 08:00:00 | NVDA | Stock | 0.175 | 0.1802 | 0.1708 | 0.1802 | 1080000.0 |
| 2000-11-30 09:00:00 | NVDA | Stock | 0.1811 | 0.1875 | 0.1708 | 0.1732 | 121440000.0 |
| 2000-11-30 10:00:00 | NVDA | Stock | 0.1729 | 0.1794 | 0.1672 | 0.1697 | 137592000.0 |
| 2000-11-30 11:00:00 | NVDA | Stock | 0.1703 | 0.1703 | 0.1583 | 0.1589 | 133296000.0 |
| 2000-11-30 12:00:00 | NVDA | Stock | 0.1586 | 0.1633 | 0.1521 | 0.1609 | 91992000.0 |
| 2000-11-30 13:00:00 | NVDA | Stock | 0.1609 | 0.1708 | 0.1607 | 0.1693 | 97368000.0 |
| 2000-11-30 14:00:00 | NVDA | Stock | 0.168 | 0.1784 | 0.1661 | 0.1773 | 133440000.0 |
| 2000-11-30 15:00:00 | NVDA | Stock | 0.1768 | 0.1807 | 0.1667 | 0.1688 | 169656000.0 |
| 2000-11-30 16:00:00 | NVDA | Stock | 0.1685 | 0.1719 | 0.1682 | 0.1688 | 14088000.0 |
| 2000-11-30 18:00:00 | NVDA | Stock | 0.1707 | 0.175 | 0.1693 | 0.175 | 96000.0 |
| 2000-11-30 08:00:00 | AMZN | Stock | 1.2688 | 1.3188 | 1.2562 | 1.3 | 168000.0 |
| 2000-11-30 09:00:00 | AMZN | Stock | 1.2875 | 1.3094 | 1.2375 | 1.2531 | 28968000.0 |
| 2000-11-30 10:00:00 | AMZN | Stock | 1.2594 | 1.2594 | 1.2188 | 1.225 | 38586000.0 |
| 2000-11-30 11:00:00 | AMZN | Stock | 1.2281 | 1.2313 | 1.1469 | 1.1719 | 27050000.0 |
| 2000-11-30 12:00:00 | AMZN | Stock | 1.175 | 1.2125 | 1.15 | 1.1938 | 26272000.0 |
| 2000-11-30 13:00:00 | AMZN | Stock | 1.1906 | 1.2062 | 1.1781 | 1.1906 | 13990000.0 |
| 2000-11-30 14:00:00 | AMZN | Stock | 1.1969 | 1.2531 | 1.1875 | 1.2406 | 51602000.0 |
| 2000-11-30 15:00:00 | AMZN | Stock | 1.2406 | 1.2688 | 1.225 | 1.2281 | 41930000.0 |
| 2000-11-30 16:00:00 | AMZN | Stock | 1.2344 | 1.2594 | 1.2219 | 1.2594 | 12236000.0 |
| 2000-11-30 17:00:00 | AMZN | Stock | 1.2469 | 1.2625 | 1.2344 | 1.2625 | 348000.0 |
| 2000-11-30 18:00:00 | AMZN | Stock | 1.2625 | 1.2625 | 1.2562 | 1.2625 | 12000.0 |
| 2000-11-30 09:00:00 | CL | Stock | 29.875 | 30.28 | 29.86 | 30.21 | 292000.0 |
| 2000-11-30 10:00:00 | CL | Stock | 30.205 | 30.205 | 29.64 | 29.675 | 463000.0 |
| 2000-11-30 11:00:00 | CL | Stock | 29.675 | 29.795 | 29.54 | 29.625 | 294000.0 |
| 2000-11-30 12:00:00 | CL | Stock | 29.61 | 29.63 | 29.495 | 29.54 | 236600.0 |
| 2000-11-30 13:00:00 | CL | Stock | 29.545 | 29.545 | 29.425 | 29.445 | 177000.0 |
| 2000-11-30 14:00:00 | CL | Stock | 29.44 | 29.495 | 29.28 | 29.35 | 484400.0 |
| 2000-11-30 15:00:00 | CL | Stock | 29.33 | 29.59 | 29.29 | 29.325 | 730800.0 |
> showing 50 of 16,731 rows — these rows as CSV