PREVIEW / stock_1hour / 2000-10-11
file: by_date/stock_1hour/2000/2000-10-11.parquet size: 306 KB rows: 15,561 symbols: 1,236
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-10-11 08:00:00 | AAPL | Stock | 0.3594 | 0.3683 | 0.3571 | 0.3616 | 2531200.0 |
| 2000-10-11 09:00:00 | AAPL | Stock | 0.3616 | 0.3717 | 0.3527 | 0.3594 | 203263200.0 |
| 2000-10-11 10:00:00 | AAPL | Stock | 0.3594 | 0.3627 | 0.3482 | 0.3493 | 155596000.0 |
| 2000-10-11 11:00:00 | AAPL | Stock | 0.3493 | 0.3538 | 0.3426 | 0.3504 | 266162400.0 |
| 2000-10-11 12:00:00 | AAPL | Stock | 0.3516 | 0.3683 | 0.3493 | 0.3605 | 221698400.0 |
| 2000-10-11 13:00:00 | AAPL | Stock | 0.3605 | 0.3672 | 0.3549 | 0.3661 | 76580000.0 |
| 2000-10-11 14:00:00 | AAPL | Stock | 0.365 | 0.3661 | 0.356 | 0.3638 | 67088000.0 |
| 2000-10-11 15:00:00 | AAPL | Stock | 0.3638 | 0.365 | 0.3493 | 0.3516 | 107396800.0 |
| 2000-10-11 16:00:00 | AAPL | Stock | 0.3504 | 0.3605 | 0.3482 | 0.3493 | 18205600.0 |
| 2000-10-11 17:00:00 | AAPL | Stock | 0.3504 | 0.3549 | 0.3504 | 0.3504 | 588000.0 |
| 2000-10-11 18:00:00 | AAPL | Stock | 0.3504 | 0.3516 | 0.3504 | 0.3516 | 78400.0 |
| 2000-10-11 08:00:00 | MSFT | Stock | 26.5 | 27.2656 | 26.25 | 26.875 | 150202.0 |
| 2000-10-11 09:00:00 | MSFT | Stock | 26.875 | 27.75 | 26.375 | 27.6875 | 10444200.0 |
| 2000-10-11 10:00:00 | MSFT | Stock | 27.6562 | 27.8438 | 27.375 | 27.4062 | 10516600.0 |
| 2000-10-11 11:00:00 | MSFT | Stock | 27.375 | 27.8438 | 27.3125 | 27.5938 | 11664200.0 |
| 2000-10-11 12:00:00 | MSFT | Stock | 27.625 | 28.1562 | 27.5625 | 28.0312 | 10672200.0 |
| 2000-10-11 13:00:00 | MSFT | Stock | 28.0 | 28.25 | 27.9062 | 28.0625 | 9764000.0 |
| 2000-10-11 14:00:00 | MSFT | Stock | 28.0625 | 28.3125 | 27.9375 | 28.2188 | 14046000.0 |
| 2000-10-11 15:00:00 | MSFT | Stock | 28.25 | 28.4688 | 27.8125 | 27.875 | 27908600.0 |
| 2000-10-11 16:00:00 | MSFT | Stock | 27.875 | 28.25 | 27.375 | 28.125 | 2438200.0 |
| 2000-10-11 17:00:00 | MSFT | Stock | 27.875 | 28.2188 | 27.875 | 28.0625 | 98600.0 |
| 2000-10-11 18:00:00 | MSFT | Stock | 28.0625 | 28.2188 | 28.0312 | 28.0625 | 3600.0 |
| 2000-10-11 08:00:00 | NVDA | Stock | 0.2688 | 0.2688 | 0.2688 | 0.2688 | 48000.0 |
| 2000-10-11 09:00:00 | NVDA | Stock | 0.2688 | 0.2695 | 0.2427 | 0.2667 | 60816000.0 |
| 2000-10-11 10:00:00 | NVDA | Stock | 0.2672 | 0.2724 | 0.2542 | 0.257 | 42168000.0 |
| 2000-10-11 11:00:00 | NVDA | Stock | 0.2544 | 0.269 | 0.2505 | 0.2651 | 57600000.0 |
| 2000-10-11 12:00:00 | NVDA | Stock | 0.2641 | 0.2823 | 0.2625 | 0.2732 | 68880000.0 |
| 2000-10-11 13:00:00 | NVDA | Stock | 0.2724 | 0.2844 | 0.2714 | 0.2844 | 60456000.0 |
| 2000-10-11 14:00:00 | NVDA | Stock | 0.2833 | 0.2865 | 0.2771 | 0.282 | 109896000.0 |
| 2000-10-11 15:00:00 | NVDA | Stock | 0.2828 | 0.2828 | 0.2708 | 0.2716 | 63120000.0 |
| 2000-10-11 16:00:00 | NVDA | Stock | 0.2714 | 0.2716 | 0.2691 | 0.2691 | 6648000.0 |
| 2000-10-11 08:00:00 | AMZN | Stock | 1.4562 | 1.4875 | 1.4344 | 1.475 | 446000.0 |
| 2000-10-11 09:00:00 | AMZN | Stock | 1.4719 | 1.5062 | 1.3969 | 1.4969 | 28230000.0 |
| 2000-10-11 10:00:00 | AMZN | Stock | 1.5094 | 1.5125 | 1.4313 | 1.4344 | 24020000.0 |
| 2000-10-11 11:00:00 | AMZN | Stock | 1.4313 | 1.4594 | 1.4062 | 1.45 | 22244000.0 |
| 2000-10-11 12:00:00 | AMZN | Stock | 1.4469 | 1.5031 | 1.4438 | 1.4688 | 16818000.0 |
| 2000-10-11 13:00:00 | AMZN | Stock | 1.4688 | 1.4719 | 1.4313 | 1.4562 | 8280000.0 |
| 2000-10-11 14:00:00 | AMZN | Stock | 1.4562 | 1.4594 | 1.3938 | 1.4062 | 13742000.0 |
| 2000-10-11 15:00:00 | AMZN | Stock | 1.4062 | 1.4438 | 1.3812 | 1.3938 | 27982000.0 |
| 2000-10-11 16:00:00 | AMZN | Stock | 1.3906 | 1.4656 | 1.3594 | 1.3875 | 3664000.0 |
| 2000-10-11 17:00:00 | AMZN | Stock | 1.3875 | 1.4875 | 1.3875 | 1.3875 | 24000.0 |
| 2000-10-11 18:00:00 | AMZN | Stock | 1.3875 | 1.3938 | 1.3875 | 1.3875 | 28000.0 |
| 2000-10-11 09:00:00 | CL | Stock | 25.375 | 25.475 | 25.3 | 25.455 | 375800.0 |
| 2000-10-11 10:00:00 | CL | Stock | 25.455 | 25.46 | 25.15 | 25.295 | 565200.0 |
| 2000-10-11 11:00:00 | CL | Stock | 25.275 | 25.395 | 25.125 | 25.22 | 422400.0 |
| 2000-10-11 12:00:00 | CL | Stock | 25.215 | 25.425 | 25.205 | 25.265 | 229200.0 |
| 2000-10-11 13:00:00 | CL | Stock | 25.25 | 25.4 | 25.2 | 25.255 | 210400.0 |
| 2000-10-11 14:00:00 | CL | Stock | 25.255 | 25.325 | 25.15 | 25.15 | 269200.0 |
| 2000-10-11 15:00:00 | CL | Stock | 25.15 | 25.25 | 25.075 | 25.08 | 337600.0 |
| 2000-10-11 16:00:00 | CL | Stock | 25.085 | 25.255 | 25.08 | 25.255 | 66600.0 |
> showing 50 of 15,561 rows — these rows as CSV