PREVIEW / stock_1hour / 2000-03-16
file: by_date/stock_1hour/2000/2000-03-16.parquet size: 292 KB rows: 14,815 symbols: 1,150
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-16 09:00:00 | AAPL | Stock | 1.0474 | 1.0569 | 1.0446 | 1.0502 | 37732800.0 |
| 2000-03-16 10:00:00 | AAPL | Stock | 1.0497 | 1.0497 | 1.0234 | 1.0237 | 53009600.0 |
| 2000-03-16 11:00:00 | AAPL | Stock | 1.024 | 1.048 | 1.0223 | 1.0363 | 48854400.0 |
| 2000-03-16 12:00:00 | AAPL | Stock | 1.0357 | 1.0569 | 1.0346 | 1.0497 | 45516800.0 |
| 2000-03-16 13:00:00 | AAPL | Stock | 1.0497 | 1.0513 | 1.0282 | 1.0379 | 35100800.0 |
| 2000-03-16 14:00:00 | AAPL | Stock | 1.0374 | 1.0625 | 1.0324 | 1.0625 | 26084800.0 |
| 2000-03-16 15:00:00 | AAPL | Stock | 1.0569 | 1.0893 | 1.0525 | 1.0854 | 109827200.0 |
| 2000-03-16 16:00:00 | AAPL | Stock | 1.0854 | 1.0854 | 1.0848 | 1.0854 | 2833600.0 |
| 2000-03-16 09:00:00 | MSFT | Stock | 47.9688 | 48.3438 | 47.75 | 47.9375 | 7080400.0 |
| 2000-03-16 10:00:00 | MSFT | Stock | 47.9375 | 48.0 | 47.4375 | 47.5 | 8956600.0 |
| 2000-03-16 11:00:00 | MSFT | Stock | 47.5156 | 47.8438 | 47.3438 | 47.6562 | 11042600.0 |
| 2000-03-16 12:00:00 | MSFT | Stock | 47.6562 | 47.7812 | 47.4062 | 47.5312 | 7767000.0 |
| 2000-03-16 13:00:00 | MSFT | Stock | 47.5312 | 47.5625 | 46.8125 | 46.9688 | 10000400.0 |
| 2000-03-16 14:00:00 | MSFT | Stock | 46.9375 | 47.4062 | 46.625 | 47.3125 | 9110000.0 |
| 2000-03-16 15:00:00 | MSFT | Stock | 47.3438 | 47.75 | 46.9531 | 47.7188 | 19349800.0 |
| 2000-03-16 16:00:00 | MSFT | Stock | 47.7031 | 47.75 | 47.625 | 47.6875 | 116000.0 |
| 2000-03-16 09:00:00 | NVDA | Stock | 0.2271 | 0.2349 | 0.2062 | 0.2125 | 81744000.0 |
| 2000-03-16 10:00:00 | NVDA | Stock | 0.2104 | 0.2135 | 0.1995 | 0.2057 | 109440000.0 |
| 2000-03-16 11:00:00 | NVDA | Stock | 0.2057 | 0.2091 | 0.197 | 0.2083 | 160128000.0 |
| 2000-03-16 12:00:00 | NVDA | Stock | 0.2065 | 0.2135 | 0.2021 | 0.206 | 84288000.0 |
| 2000-03-16 13:00:00 | NVDA | Stock | 0.2062 | 0.2083 | 0.2021 | 0.2062 | 32208000.0 |
| 2000-03-16 14:00:00 | NVDA | Stock | 0.2056 | 0.2151 | 0.2021 | 0.2052 | 80880000.0 |
| 2000-03-16 15:00:00 | NVDA | Stock | 0.2068 | 0.2117 | 0.193 | 0.1961 | 150960000.0 |
| 2000-03-16 16:00:00 | NVDA | Stock | 0.1962 | 0.1962 | 0.1962 | 0.1962 | 2496000.0 |
| 2000-03-16 09:00:00 | AMZN | Stock | 3.1125 | 3.1125 | 3.0 | 3.0281 | 28012000.0 |
| 2000-03-16 10:00:00 | AMZN | Stock | 3.0281 | 3.075 | 3.0 | 3.0375 | 37922000.0 |
| 2000-03-16 11:00:00 | AMZN | Stock | 3.0406 | 3.15 | 3.0188 | 3.1125 | 29638000.0 |
| 2000-03-16 12:00:00 | AMZN | Stock | 3.1125 | 3.2 | 3.0938 | 3.1375 | 17788000.0 |
| 2000-03-16 13:00:00 | AMZN | Stock | 3.1375 | 3.1531 | 3.0969 | 3.1281 | 10696000.0 |
| 2000-03-16 14:00:00 | AMZN | Stock | 3.1281 | 3.2125 | 3.1062 | 3.2063 | 15026000.0 |
| 2000-03-16 15:00:00 | AMZN | Stock | 3.2063 | 3.3188 | 3.1875 | 3.3062 | 44934000.0 |
| 2000-03-16 16:00:00 | AMZN | Stock | 3.3094 | 3.3125 | 3.3062 | 3.3125 | 528000.0 |
| 2000-03-16 09:00:00 | CL | Stock | 25.9062 | 25.9688 | 25.5 | 25.5 | 1466800.0 |
| 2000-03-16 10:00:00 | CL | Stock | 25.5312 | 25.9375 | 24.875 | 25.8438 | 1763800.0 |
| 2000-03-16 11:00:00 | CL | Stock | 25.9375 | 26.0 | 25.75 | 25.9062 | 1350600.0 |
| 2000-03-16 12:00:00 | CL | Stock | 25.9062 | 26.0 | 25.625 | 26.0 | 1135200.0 |
| 2000-03-16 13:00:00 | CL | Stock | 25.9688 | 26.1562 | 25.375 | 25.4375 | 1528000.0 |
| 2000-03-16 14:00:00 | CL | Stock | 25.4375 | 25.5938 | 25.3125 | 25.5625 | 752200.0 |
| 2000-03-16 15:00:00 | CL | Stock | 25.5312 | 25.75 | 25.3125 | 25.6562 | 1371400.0 |
| 2000-03-16 16:00:00 | CL | Stock | 25.625 | 25.625 | 25.625 | 25.625 | 132200.0 |
> showing 40 of 14,815 rows — these rows as CSV