PREVIEW / stock_1hour / 2000-11-27
file: by_date/stock_1hour/2000/2000-11-27.parquet size: 304 KB rows: 15,909 symbols: 1,254
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-27 08:00:00 | AAPL | Stock | 0.3482 | 0.3616 | 0.3482 | 0.3527 | 722400.0 |
| 2000-11-27 09:00:00 | AAPL | Stock | 0.3527 | 0.3571 | 0.3449 | 0.3516 | 50405600.0 |
| 2000-11-27 10:00:00 | AAPL | Stock | 0.3504 | 0.3516 | 0.3393 | 0.3449 | 39905600.0 |
| 2000-11-27 11:00:00 | AAPL | Stock | 0.3438 | 0.3449 | 0.3404 | 0.3426 | 20064800.0 |
| 2000-11-27 12:00:00 | AAPL | Stock | 0.3426 | 0.3443 | 0.3393 | 0.3404 | 14733600.0 |
| 2000-11-27 13:00:00 | AAPL | Stock | 0.3393 | 0.3404 | 0.3348 | 0.3348 | 50618400.0 |
| 2000-11-27 14:00:00 | AAPL | Stock | 0.3348 | 0.3371 | 0.3304 | 0.3371 | 29730400.0 |
| 2000-11-27 15:00:00 | AAPL | Stock | 0.3382 | 0.3404 | 0.3326 | 0.3326 | 30861600.0 |
| 2000-11-27 16:00:00 | AAPL | Stock | 0.3326 | 0.3382 | 0.332 | 0.3337 | 5196800.0 |
| 2000-11-27 17:00:00 | AAPL | Stock | 0.3354 | 0.3354 | 0.3331 | 0.3348 | 1271200.0 |
| 2000-11-27 08:00:00 | MSFT | Stock | 35.625 | 36.0 | 35.0938 | 35.5 | 190600.0 |
| 2000-11-27 09:00:00 | MSFT | Stock | 35.5 | 36.0312 | 35.1875 | 36.0 | 18036600.0 |
| 2000-11-27 10:00:00 | MSFT | Stock | 35.9688 | 36.125 | 35.75 | 35.9375 | 12388400.0 |
| 2000-11-27 11:00:00 | MSFT | Stock | 35.9375 | 36.0312 | 35.7188 | 35.875 | 9175200.0 |
| 2000-11-27 12:00:00 | MSFT | Stock | 35.9062 | 36.0 | 35.8438 | 35.9688 | 8074800.0 |
| 2000-11-27 13:00:00 | MSFT | Stock | 35.9375 | 36.0312 | 35.7812 | 35.8125 | 7425000.0 |
| 2000-11-27 14:00:00 | MSFT | Stock | 35.8125 | 35.875 | 35.625 | 35.75 | 8377800.0 |
| 2000-11-27 15:00:00 | MSFT | Stock | 35.75 | 35.9844 | 35.3125 | 35.375 | 12016400.0 |
| 2000-11-27 16:00:00 | MSFT | Stock | 35.3125 | 36.0 | 35.25 | 35.3125 | 2244800.0 |
| 2000-11-27 17:00:00 | MSFT | Stock | 35.3438 | 35.4375 | 35.3438 | 35.4375 | 71800.0 |
| 2000-11-27 18:00:00 | MSFT | Stock | 35.375 | 35.4375 | 35.375 | 35.4375 | 1200.0 |
| 2000-11-27 08:00:00 | NVDA | Stock | 0.2438 | 0.2438 | 0.2438 | 0.2438 | 24000.0 |
| 2000-11-27 09:00:00 | NVDA | Stock | 0.25 | 0.2583 | 0.2484 | 0.25 | 51840000.0 |
| 2000-11-27 10:00:00 | NVDA | Stock | 0.2497 | 0.2499 | 0.2401 | 0.2411 | 59784000.0 |
| 2000-11-27 11:00:00 | NVDA | Stock | 0.2411 | 0.2417 | 0.2292 | 0.2352 | 57816000.0 |
| 2000-11-27 12:00:00 | NVDA | Stock | 0.2339 | 0.2401 | 0.2302 | 0.237 | 30504000.0 |
| 2000-11-27 13:00:00 | NVDA | Stock | 0.2384 | 0.2419 | 0.2344 | 0.2365 | 24432000.0 |
| 2000-11-27 14:00:00 | NVDA | Stock | 0.2359 | 0.2365 | 0.2313 | 0.2339 | 51240000.0 |
| 2000-11-27 15:00:00 | NVDA | Stock | 0.2339 | 0.2391 | 0.2219 | 0.2313 | 57168000.0 |
| 2000-11-27 16:00:00 | NVDA | Stock | 0.2313 | 0.2315 | 0.2286 | 0.2313 | 12264000.0 |
| 2000-11-27 08:00:00 | AMZN | Stock | 1.4594 | 1.5031 | 1.4594 | 1.4875 | 868000.0 |
| 2000-11-27 09:00:00 | AMZN | Stock | 1.4875 | 1.5375 | 1.4469 | 1.5312 | 24020000.0 |
| 2000-11-27 10:00:00 | AMZN | Stock | 1.5312 | 1.5375 | 1.425 | 1.4344 | 23322000.0 |
| 2000-11-27 11:00:00 | AMZN | Stock | 1.4344 | 1.4375 | 1.3531 | 1.3781 | 17796000.0 |
| 2000-11-27 12:00:00 | AMZN | Stock | 1.3781 | 1.4125 | 1.3625 | 1.3812 | 8214000.0 |
| 2000-11-27 13:00:00 | AMZN | Stock | 1.3812 | 1.4156 | 1.3781 | 1.4062 | 10610000.0 |
| 2000-11-27 14:00:00 | AMZN | Stock | 1.4062 | 1.4313 | 1.3781 | 1.3938 | 11248000.0 |
| 2000-11-27 15:00:00 | AMZN | Stock | 1.3953 | 1.45 | 1.3938 | 1.4 | 19784000.0 |
| 2000-11-27 16:00:00 | AMZN | Stock | 1.4031 | 1.4062 | 1.3906 | 1.4 | 1110000.0 |
| 2000-11-27 17:00:00 | AMZN | Stock | 1.4 | 1.4 | 1.3875 | 1.3906 | 202000.0 |
| 2000-11-27 18:00:00 | AMZN | Stock | 1.3875 | 1.3875 | 1.3875 | 1.3875 | 18000.0 |
| 2000-11-27 09:00:00 | CL | Stock | 28.8 | 28.875 | 28.55 | 28.7 | 286600.0 |
| 2000-11-27 10:00:00 | CL | Stock | 28.7 | 28.9 | 28.7 | 28.9 | 314400.0 |
| 2000-11-27 11:00:00 | CL | Stock | 28.925 | 28.995 | 28.775 | 28.79 | 268200.0 |
| 2000-11-27 12:00:00 | CL | Stock | 28.785 | 28.785 | 28.575 | 28.72 | 197000.0 |
| 2000-11-27 13:00:00 | CL | Stock | 28.725 | 28.8 | 28.4 | 28.475 | 216600.0 |
| 2000-11-27 14:00:00 | CL | Stock | 28.45 | 28.7 | 28.245 | 28.395 | 468400.0 |
| 2000-11-27 15:00:00 | CL | Stock | 28.4 | 28.68 | 28.4 | 28.5 | 596800.0 |
| 2000-11-27 16:00:00 | CL | Stock | 28.5 | 28.64 | 28.48 | 28.64 | 149800.0 |
| 2000-11-27 17:00:00 | CL | Stock | 28.48 | 28.48 | 28.48 | 28.48 | 30000.0 |
> showing 50 of 15,909 rows — these rows as CSV