PREVIEW / stock_1hour / 2000-05-31
file: by_date/stock_1hour/2000/2000-05-31.parquet size: 298 KB rows: 15,531 symbols: 1,170
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-31 08:00:00 | AAPL | Stock | 0.7723 | 0.8025 | 0.7623 | 0.7634 | 784000.0 |
| 2000-05-31 09:00:00 | AAPL | Stock | 0.7634 | 0.798 | 0.7623 | 0.7846 | 78265600.0 |
| 2000-05-31 10:00:00 | AAPL | Stock | 0.7846 | 0.8147 | 0.7824 | 0.8092 | 128172800.0 |
| 2000-05-31 11:00:00 | AAPL | Stock | 0.8086 | 0.8103 | 0.7807 | 0.7879 | 47846400.0 |
| 2000-05-31 12:00:00 | AAPL | Stock | 0.7868 | 0.808 | 0.7868 | 0.8013 | 29299200.0 |
| 2000-05-31 13:00:00 | AAPL | Stock | 0.8019 | 0.8036 | 0.7946 | 0.7997 | 22758400.0 |
| 2000-05-31 14:00:00 | AAPL | Stock | 0.7991 | 0.8072 | 0.7852 | 0.7902 | 35201600.0 |
| 2000-05-31 15:00:00 | AAPL | Stock | 0.7902 | 0.7902 | 0.7483 | 0.75 | 71568000.0 |
| 2000-05-31 16:00:00 | AAPL | Stock | 0.7503 | 0.7506 | 0.7455 | 0.75 | 10595200.0 |
| 2000-05-31 17:00:00 | AAPL | Stock | 0.75 | 0.7522 | 0.7455 | 0.7522 | 403200.0 |
| 2000-05-31 18:00:00 | AAPL | Stock | 0.7573 | 0.7573 | 0.7539 | 0.7539 | 33600.0 |
| 2000-05-31 08:00:00 | MSFT | Stock | 31.7031 | 31.7031 | 31.375 | 31.5 | 54600.0 |
| 2000-05-31 09:00:00 | MSFT | Stock | 31.5625 | 31.8125 | 31.125 | 31.2812 | 7897200.0 |
| 2000-05-31 10:00:00 | MSFT | Stock | 31.2812 | 31.75 | 31.25 | 31.5312 | 9657200.0 |
| 2000-05-31 11:00:00 | MSFT | Stock | 31.5 | 31.5625 | 31.1562 | 31.1562 | 6009600.0 |
| 2000-05-31 12:00:00 | MSFT | Stock | 31.1875 | 31.5312 | 31.1562 | 31.5312 | 7009600.0 |
| 2000-05-31 13:00:00 | MSFT | Stock | 31.5 | 31.5312 | 31.1562 | 31.2812 | 4183000.0 |
| 2000-05-31 14:00:00 | MSFT | Stock | 31.2812 | 31.5 | 31.25 | 31.4375 | 5699400.0 |
| 2000-05-31 15:00:00 | MSFT | Stock | 31.4375 | 31.625 | 31.0938 | 31.2188 | 10827200.0 |
| 2000-05-31 16:00:00 | MSFT | Stock | 31.2188 | 31.5 | 31.2188 | 31.4688 | 2694000.0 |
| 2000-05-31 17:00:00 | MSFT | Stock | 31.2812 | 31.4531 | 31.2656 | 31.4531 | 254800.0 |
| 2000-05-31 18:00:00 | MSFT | Stock | 31.4062 | 31.4375 | 31.4062 | 31.4375 | 1000.0 |
| 2000-05-31 08:00:00 | NVDA | Stock | 0.2271 | 0.2271 | 0.2271 | 0.2271 | 48000.0 |
| 2000-05-31 09:00:00 | NVDA | Stock | 0.2292 | 0.2414 | 0.2266 | 0.2365 | 112464000.0 |
| 2000-05-31 10:00:00 | NVDA | Stock | 0.2354 | 0.2417 | 0.2354 | 0.2391 | 122592000.0 |
| 2000-05-31 11:00:00 | NVDA | Stock | 0.2384 | 0.2395 | 0.2318 | 0.2328 | 76944000.0 |
| 2000-05-31 12:00:00 | NVDA | Stock | 0.2328 | 0.2385 | 0.2328 | 0.2375 | 21456000.0 |
| 2000-05-31 13:00:00 | NVDA | Stock | 0.2372 | 0.2397 | 0.237 | 0.2376 | 18000000.0 |
| 2000-05-31 14:00:00 | NVDA | Stock | 0.2375 | 0.2396 | 0.237 | 0.2376 | 31008000.0 |
| 2000-05-31 15:00:00 | NVDA | Stock | 0.2375 | 0.2417 | 0.232 | 0.2375 | 69744000.0 |
| 2000-05-31 16:00:00 | NVDA | Stock | 0.2378 | 0.2378 | 0.2354 | 0.2371 | 7392000.0 |
| 2000-05-31 08:00:00 | AMZN | Stock | 2.5438 | 2.5438 | 2.4656 | 2.5188 | 68000.0 |
| 2000-05-31 09:00:00 | AMZN | Stock | 2.525 | 2.5438 | 2.4812 | 2.4969 | 17066000.0 |
| 2000-05-31 10:00:00 | AMZN | Stock | 2.5 | 2.6125 | 2.4938 | 2.5563 | 16356000.0 |
| 2000-05-31 11:00:00 | AMZN | Stock | 2.5594 | 2.5594 | 2.4844 | 2.4969 | 14290000.0 |
| 2000-05-31 12:00:00 | AMZN | Stock | 2.4969 | 2.5875 | 2.4875 | 2.5563 | 13102000.0 |
| 2000-05-31 13:00:00 | AMZN | Stock | 2.5563 | 2.5656 | 2.5156 | 2.5531 | 11858000.0 |
| 2000-05-31 14:00:00 | AMZN | Stock | 2.5656 | 2.5688 | 2.4875 | 2.5188 | 14940000.0 |
| 2000-05-31 15:00:00 | AMZN | Stock | 2.5188 | 2.5219 | 2.4062 | 2.4188 | 28130000.0 |
| 2000-05-31 16:00:00 | AMZN | Stock | 2.4156 | 2.5766 | 2.4 | 2.5766 | 18342000.0 |
| 2000-05-31 17:00:00 | AMZN | Stock | 2.425 | 2.425 | 2.4062 | 2.4094 | 76000.0 |
| 2000-05-31 18:00:00 | AMZN | Stock | 2.425 | 2.425 | 2.425 | 2.425 | 8000.0 |
| 2000-05-31 09:00:00 | CL | Stock | 26.75 | 27.0 | 26.7188 | 26.9375 | 217800.0 |
| 2000-05-31 10:00:00 | CL | Stock | 26.9062 | 26.9375 | 25.875 | 25.9375 | 1262600.0 |
| 2000-05-31 11:00:00 | CL | Stock | 25.9688 | 26.0625 | 25.7812 | 25.9688 | 815800.0 |
| 2000-05-31 12:00:00 | CL | Stock | 25.9688 | 26.0938 | 25.9062 | 26.0938 | 1620800.0 |
| 2000-05-31 13:00:00 | CL | Stock | 26.0938 | 26.3438 | 26.0312 | 26.25 | 819600.0 |
| 2000-05-31 14:00:00 | CL | Stock | 26.25 | 26.3438 | 26.2188 | 26.3438 | 309400.0 |
| 2000-05-31 15:00:00 | CL | Stock | 26.3438 | 26.5625 | 26.2188 | 26.3438 | 2024200.0 |
| 2000-05-31 16:00:00 | CL | Stock | 26.3438 | 26.375 | 26.3125 | 26.3125 | 201800.0 |
> showing 50 of 15,531 rows — these rows as CSV