PREVIEW / stock_1hour / 2000-10-24
file: by_date/stock_1hour/2000/2000-10-24.parquet size: 301 KB rows: 15,646 symbols: 1,234
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-24 08:00:00 | AAPL | Stock | 0.3622 | 0.3705 | 0.3571 | 0.3672 | 1764000.0 |
| 2000-10-24 09:00:00 | AAPL | Stock | 0.3672 | 0.375 | 0.3571 | 0.3571 | 75868800.0 |
| 2000-10-24 10:00:00 | AAPL | Stock | 0.3571 | 0.3594 | 0.3504 | 0.3504 | 86004800.0 |
| 2000-10-24 11:00:00 | AAPL | Stock | 0.3504 | 0.3527 | 0.346 | 0.3482 | 101757600.0 |
| 2000-10-24 12:00:00 | AAPL | Stock | 0.3493 | 0.3493 | 0.3404 | 0.3404 | 86212000.0 |
| 2000-10-24 13:00:00 | AAPL | Stock | 0.3404 | 0.3426 | 0.3359 | 0.3393 | 105554400.0 |
| 2000-10-24 14:00:00 | AAPL | Stock | 0.3393 | 0.3404 | 0.3359 | 0.3371 | 88603200.0 |
| 2000-10-24 15:00:00 | AAPL | Stock | 0.3382 | 0.3415 | 0.3359 | 0.3382 | 181675200.0 |
| 2000-10-24 16:00:00 | AAPL | Stock | 0.3371 | 0.3504 | 0.3348 | 0.3393 | 30284800.0 |
| 2000-10-24 17:00:00 | AAPL | Stock | 0.3393 | 0.3415 | 0.3348 | 0.3387 | 632800.0 |
| 2000-10-24 18:00:00 | AAPL | Stock | 0.3371 | 0.3393 | 0.3348 | 0.3354 | 593600.0 |
| 2000-10-24 08:00:00 | MSFT | Stock | 31.0469 | 31.5 | 31.0469 | 31.3438 | 230400.0 |
| 2000-10-24 09:00:00 | MSFT | Stock | 31.375 | 31.4688 | 31.0625 | 31.0938 | 8636000.0 |
| 2000-10-24 10:00:00 | MSFT | Stock | 31.0938 | 31.25 | 30.6562 | 31.0 | 13660000.0 |
| 2000-10-24 11:00:00 | MSFT | Stock | 31.0 | 31.125 | 30.75 | 30.8438 | 8118800.0 |
| 2000-10-24 12:00:00 | MSFT | Stock | 30.8438 | 31.0 | 30.7031 | 30.8438 | 11134200.0 |
| 2000-10-24 13:00:00 | MSFT | Stock | 30.8125 | 30.8438 | 30.25 | 30.3438 | 18245000.0 |
| 2000-10-24 14:00:00 | MSFT | Stock | 30.3438 | 30.5 | 30.0938 | 30.3438 | 10422600.0 |
| 2000-10-24 15:00:00 | MSFT | Stock | 30.3438 | 30.7812 | 30.3125 | 30.75 | 16753600.0 |
| 2000-10-24 16:00:00 | MSFT | Stock | 30.75 | 31.3438 | 30.4688 | 30.5312 | 1976600.0 |
| 2000-10-24 17:00:00 | MSFT | Stock | 30.5312 | 30.625 | 30.3125 | 30.4375 | 81600.0 |
| 2000-10-24 18:00:00 | MSFT | Stock | 30.4375 | 30.5 | 30.25 | 30.25 | 7200.0 |
| 2000-10-24 09:00:00 | NVDA | Stock | 0.2828 | 0.287 | 0.276 | 0.2823 | 7536000.0 |
| 2000-10-24 10:00:00 | NVDA | Stock | 0.2831 | 0.2844 | 0.2792 | 0.2823 | 24432000.0 |
| 2000-10-24 11:00:00 | NVDA | Stock | 0.2822 | 0.2826 | 0.2792 | 0.2794 | 17784000.0 |
| 2000-10-24 12:00:00 | NVDA | Stock | 0.2794 | 0.2813 | 0.2734 | 0.274 | 33696000.0 |
| 2000-10-24 13:00:00 | NVDA | Stock | 0.274 | 0.2789 | 0.274 | 0.2771 | 17232000.0 |
| 2000-10-24 14:00:00 | NVDA | Stock | 0.2772 | 0.2813 | 0.2766 | 0.2779 | 27000000.0 |
| 2000-10-24 15:00:00 | NVDA | Stock | 0.2781 | 0.2818 | 0.2734 | 0.2747 | 52944000.0 |
| 2000-10-24 16:00:00 | NVDA | Stock | 0.2745 | 0.2747 | 0.2729 | 0.2729 | 648000.0 |
| 2000-10-24 08:00:00 | AMZN | Stock | 1.475 | 1.5125 | 1.475 | 1.5094 | 232000.0 |
| 2000-10-24 09:00:00 | AMZN | Stock | 1.5 | 1.5125 | 1.45 | 1.4969 | 16470000.0 |
| 2000-10-24 10:00:00 | AMZN | Stock | 1.4938 | 1.6438 | 1.4938 | 1.6 | 52426000.0 |
| 2000-10-24 11:00:00 | AMZN | Stock | 1.6 | 1.6188 | 1.5719 | 1.5875 | 21690000.0 |
| 2000-10-24 12:00:00 | AMZN | Stock | 1.5844 | 1.5906 | 1.5438 | 1.5812 | 14886000.0 |
| 2000-10-24 13:00:00 | AMZN | Stock | 1.5781 | 1.6063 | 1.5281 | 1.5312 | 16432000.0 |
| 2000-10-24 14:00:00 | AMZN | Stock | 1.5312 | 1.5531 | 1.4625 | 1.4844 | 27688000.0 |
| 2000-10-24 15:00:00 | AMZN | Stock | 1.4844 | 1.5062 | 1.4406 | 1.475 | 50938000.0 |
| 2000-10-24 16:00:00 | AMZN | Stock | 1.475 | 1.7188 | 1.4438 | 1.6562 | 37916000.0 |
| 2000-10-24 17:00:00 | AMZN | Stock | 1.6531 | 1.7 | 1.575 | 1.6625 | 16584000.0 |
| 2000-10-24 18:00:00 | AMZN | Stock | 1.6734 | 1.6734 | 1.6219 | 1.6375 | 4920000.0 |
| 2000-10-24 09:00:00 | CL | Stock | 25.1 | 25.925 | 25.1 | 25.92 | 793200.0 |
| 2000-10-24 10:00:00 | CL | Stock | 25.905 | 26.5 | 25.905 | 26.5 | 1114400.0 |
| 2000-10-24 11:00:00 | CL | Stock | 26.5 | 26.515 | 26.25 | 26.3 | 926000.0 |
| 2000-10-24 12:00:00 | CL | Stock | 26.33 | 26.46 | 26.305 | 26.46 | 666200.0 |
| 2000-10-24 13:00:00 | CL | Stock | 26.46 | 26.975 | 26.45 | 26.725 | 611000.0 |
| 2000-10-24 14:00:00 | CL | Stock | 26.725 | 26.775 | 26.315 | 26.38 | 431800.0 |
| 2000-10-24 15:00:00 | CL | Stock | 26.38 | 26.575 | 26.225 | 26.565 | 907200.0 |
| 2000-10-24 16:00:00 | CL | Stock | 26.565 | 26.75 | 26.41 | 26.41 | 459000.0 |
| 2000-10-24 17:00:00 | CL | Stock | 26.525 | 26.525 | 26.525 | 26.525 | 34000.0 |
> showing 50 of 15,646 rows — these rows as CSV