PREVIEW / stock_1hour / 2000-03-17
file: by_date/stock_1hour/2000/2000-03-17.parquet size: 287 KB rows: 14,621 symbols: 1,148
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-17 09:00:00 | AAPL | Stock | 1.0725 | 1.0926 | 1.0681 | 1.0904 | 50624000.0 |
| 2000-03-17 10:00:00 | AAPL | Stock | 1.0904 | 1.1088 | 1.0904 | 1.1032 | 41809600.0 |
| 2000-03-17 11:00:00 | AAPL | Stock | 1.1032 | 1.115 | 1.1016 | 1.111 | 65475200.0 |
| 2000-03-17 12:00:00 | AAPL | Stock | 1.1099 | 1.1127 | 1.0949 | 1.1116 | 25592000.0 |
| 2000-03-17 13:00:00 | AAPL | Stock | 1.1116 | 1.1138 | 1.1016 | 1.1049 | 13932800.0 |
| 2000-03-17 14:00:00 | AAPL | Stock | 1.1049 | 1.1138 | 1.0993 | 1.1083 | 18961600.0 |
| 2000-03-17 15:00:00 | AAPL | Stock | 1.1077 | 1.1161 | 1.1021 | 1.1155 | 44027200.0 |
| 2000-03-17 16:00:00 | AAPL | Stock | 1.1161 | 1.1161 | 1.1155 | 1.1161 | 1153600.0 |
| 2000-03-17 09:00:00 | MSFT | Stock | 47.625 | 48.6094 | 47.25 | 48.125 | 10049000.0 |
| 2000-03-17 10:00:00 | MSFT | Stock | 48.0938 | 48.8125 | 48.0 | 48.4062 | 10162000.0 |
| 2000-03-17 11:00:00 | MSFT | Stock | 48.4219 | 48.75 | 48.375 | 48.5 | 6102800.0 |
| 2000-03-17 12:00:00 | MSFT | Stock | 48.5 | 48.5312 | 48.0 | 48.4688 | 5249800.0 |
| 2000-03-17 13:00:00 | MSFT | Stock | 48.4688 | 48.5625 | 48.1875 | 48.4062 | 4113400.0 |
| 2000-03-17 14:00:00 | MSFT | Stock | 48.4375 | 48.7188 | 48.375 | 48.6562 | 4686600.0 |
| 2000-03-17 15:00:00 | MSFT | Stock | 48.625 | 49.75 | 48.5938 | 49.6562 | 16075400.0 |
| 2000-03-17 16:00:00 | MSFT | Stock | 49.6562 | 49.6875 | 49.5938 | 49.6875 | 644200.0 |
| 2000-03-17 09:00:00 | NVDA | Stock | 0.1917 | 0.2083 | 0.1916 | 0.2059 | 62016000.0 |
| 2000-03-17 10:00:00 | NVDA | Stock | 0.2059 | 0.2229 | 0.2059 | 0.2091 | 114384000.0 |
| 2000-03-17 11:00:00 | NVDA | Stock | 0.2099 | 0.2158 | 0.2021 | 0.2125 | 144144000.0 |
| 2000-03-17 12:00:00 | NVDA | Stock | 0.2109 | 0.2122 | 0.2042 | 0.2081 | 50016000.0 |
| 2000-03-17 13:00:00 | NVDA | Stock | 0.2081 | 0.2081 | 0.1987 | 0.2034 | 43920000.0 |
| 2000-03-17 14:00:00 | NVDA | Stock | 0.2026 | 0.206 | 0.1982 | 0.1987 | 33792000.0 |
| 2000-03-17 15:00:00 | NVDA | Stock | 0.2009 | 0.2096 | 0.2004 | 0.2079 | 63984000.0 |
| 2000-03-17 16:00:00 | NVDA | Stock | 0.2081 | 0.2081 | 0.2079 | 0.2081 | 5088000.0 |
| 2000-03-17 09:00:00 | AMZN | Stock | 3.3031 | 3.3188 | 3.225 | 3.275 | 12776000.0 |
| 2000-03-17 10:00:00 | AMZN | Stock | 3.275 | 3.3031 | 3.2562 | 3.2656 | 16040000.0 |
| 2000-03-17 11:00:00 | AMZN | Stock | 3.2656 | 3.2938 | 3.2656 | 3.2812 | 14118000.0 |
| 2000-03-17 12:00:00 | AMZN | Stock | 3.2812 | 3.2844 | 3.2375 | 3.2531 | 8650000.0 |
| 2000-03-17 13:00:00 | AMZN | Stock | 3.2562 | 3.275 | 3.2375 | 3.2625 | 6534000.0 |
| 2000-03-17 14:00:00 | AMZN | Stock | 3.2625 | 3.275 | 3.2438 | 3.2469 | 8682000.0 |
| 2000-03-17 15:00:00 | AMZN | Stock | 3.25 | 3.2812 | 3.2312 | 3.2406 | 16062000.0 |
| 2000-03-17 16:00:00 | AMZN | Stock | 3.2422 | 3.2438 | 3.2406 | 3.2406 | 214000.0 |
| 2000-03-17 09:00:00 | CL | Stock | 25.125 | 25.6562 | 24.9375 | 25.5 | 1281400.0 |
| 2000-03-17 10:00:00 | CL | Stock | 25.4375 | 25.8125 | 25.375 | 25.7188 | 619200.0 |
| 2000-03-17 11:00:00 | CL | Stock | 25.7188 | 25.9688 | 25.5938 | 25.875 | 502200.0 |
| 2000-03-17 12:00:00 | CL | Stock | 25.8438 | 25.875 | 25.4062 | 25.5 | 473000.0 |
| 2000-03-17 13:00:00 | CL | Stock | 25.4375 | 25.5938 | 25.25 | 25.3125 | 418600.0 |
| 2000-03-17 14:00:00 | CL | Stock | 25.3125 | 25.375 | 25.125 | 25.25 | 621000.0 |
| 2000-03-17 15:00:00 | CL | Stock | 25.25 | 25.25 | 24.9062 | 24.9375 | 892800.0 |
| 2000-03-17 16:00:00 | CL | Stock | 24.9375 | 24.9688 | 24.9375 | 24.9688 | 238600.0 |
> showing 40 of 14,621 rows — these rows as CSV