PREVIEW / stock_1hour / 2001-12-04
file: by_date/stock_1hour/2001/2001-12-04.parquet size: 374 KB rows: 18,125 symbols: 1,354
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 |
|---|---|---|---|---|---|---|---|
| 2001-12-04 08:00:00 | AAPL | Stock | 0.3771 | 0.3779 | 0.3761 | 0.3763 | 453600.0 |
| 2001-12-04 09:00:00 | AAPL | Stock | 0.3777 | 0.3777 | 0.37 | 0.3748 | 30973600.0 |
| 2001-12-04 10:00:00 | AAPL | Stock | 0.3747 | 0.383 | 0.3746 | 0.3782 | 35420000.0 |
| 2001-12-04 11:00:00 | AAPL | Stock | 0.3782 | 0.38 | 0.3759 | 0.3793 | 24432800.0 |
| 2001-12-04 12:00:00 | AAPL | Stock | 0.3793 | 0.3863 | 0.3788 | 0.3832 | 46866400.0 |
| 2001-12-04 13:00:00 | AAPL | Stock | 0.3832 | 0.3895 | 0.3832 | 0.3888 | 43030400.0 |
| 2001-12-04 14:00:00 | AAPL | Stock | 0.3879 | 0.4029 | 0.3877 | 0.4011 | 109306400.0 |
| 2001-12-04 15:00:00 | AAPL | Stock | 0.4007 | 0.402 | 0.3975 | 0.4002 | 69238400.0 |
| 2001-12-04 16:00:00 | AAPL | Stock | 0.4 | 0.4018 | 0.3984 | 0.4 | 6098400.0 |
| 2001-12-04 17:00:00 | AAPL | Stock | 0.4 | 0.4 | 0.3964 | 0.3964 | 1736000.0 |
| 2001-12-04 08:00:00 | MSFT | Stock | 32.3825 | 32.55 | 32.375 | 32.5 | 65200.0 |
| 2001-12-04 09:00:00 | MSFT | Stock | 32.5 | 32.51 | 32.1 | 32.2895 | 6762800.0 |
| 2001-12-04 10:00:00 | MSFT | Stock | 32.2895 | 32.48 | 32.125 | 32.3 | 8930800.0 |
| 2001-12-04 11:00:00 | MSFT | Stock | 32.285 | 32.39 | 32.165 | 32.19 | 4743800.0 |
| 2001-12-04 12:00:00 | MSFT | Stock | 32.19 | 32.3 | 32.105 | 32.11 | 3419400.0 |
| 2001-12-04 13:00:00 | MSFT | Stock | 32.105 | 32.3 | 32.05 | 32.265 | 3626400.0 |
| 2001-12-04 14:00:00 | MSFT | Stock | 32.265 | 32.77 | 32.195 | 32.74 | 7000000.0 |
| 2001-12-04 15:00:00 | MSFT | Stock | 32.7405 | 33.04 | 32.72 | 33.0 | 12806200.0 |
| 2001-12-04 16:00:00 | MSFT | Stock | 33.0 | 33.06 | 32.09 | 32.98 | 2652000.0 |
| 2001-12-04 17:00:00 | MSFT | Stock | 33.0 | 33.0 | 32.975 | 32.975 | 237000.0 |
| 2001-12-04 18:00:00 | MSFT | Stock | 33.0 | 33.0 | 32.95 | 33.0 | 4400.0 |
| 2001-12-04 08:00:00 | NVDA | Stock | 0.4492 | 0.4542 | 0.4492 | 0.4518 | 924000.0 |
| 2001-12-04 09:00:00 | NVDA | Stock | 0.4514 | 0.4631 | 0.4504 | 0.463 | 133536000.0 |
| 2001-12-04 10:00:00 | NVDA | Stock | 0.463 | 0.4729 | 0.46 | 0.469 | 314592000.0 |
| 2001-12-04 11:00:00 | NVDA | Stock | 0.4689 | 0.4697 | 0.4639 | 0.4683 | 146880000.0 |
| 2001-12-04 12:00:00 | NVDA | Stock | 0.4686 | 0.4716 | 0.4671 | 0.4677 | 81036000.0 |
| 2001-12-04 13:00:00 | NVDA | Stock | 0.4678 | 0.4708 | 0.4667 | 0.4707 | 78840000.0 |
| 2001-12-04 14:00:00 | NVDA | Stock | 0.4706 | 0.4791 | 0.4706 | 0.4752 | 256704000.0 |
| 2001-12-04 15:00:00 | NVDA | Stock | 0.4775 | 0.485 | 0.4742 | 0.4846 | 321960000.0 |
| 2001-12-04 16:00:00 | NVDA | Stock | 0.4845 | 0.485 | 0.481 | 0.4845 | 36216000.0 |
| 2001-12-04 17:00:00 | NVDA | Stock | 0.4842 | 0.4854 | 0.4837 | 0.4842 | 1752000.0 |
| 2001-12-04 18:00:00 | NVDA | Stock | 0.4842 | 0.485 | 0.4837 | 0.485 | 444000.0 |
| 2001-12-04 08:00:00 | AMZN | Stock | 0.538 | 0.5495 | 0.5247 | 0.539 | 1134000.0 |
| 2001-12-04 09:00:00 | AMZN | Stock | 0.539 | 0.55 | 0.5355 | 0.5485 | 32088000.0 |
| 2001-12-04 10:00:00 | AMZN | Stock | 0.548 | 0.565 | 0.5475 | 0.56 | 57480000.0 |
| 2001-12-04 11:00:00 | AMZN | Stock | 0.56 | 0.57 | 0.557 | 0.569 | 20452000.0 |
| 2001-12-04 12:00:00 | AMZN | Stock | 0.569 | 0.571 | 0.5535 | 0.554 | 15268000.0 |
| 2001-12-04 13:00:00 | AMZN | Stock | 0.554 | 0.569 | 0.549 | 0.5675 | 30582000.0 |
| 2001-12-04 14:00:00 | AMZN | Stock | 0.5675 | 0.579 | 0.565 | 0.5775 | 35610000.0 |
| 2001-12-04 15:00:00 | AMZN | Stock | 0.5765 | 0.6025 | 0.5745 | 0.599 | 75090000.0 |
| 2001-12-04 16:00:00 | AMZN | Stock | 0.5965 | 0.602 | 0.59 | 0.5945 | 4142000.0 |
| 2001-12-04 17:00:00 | AMZN | Stock | 0.5945 | 0.5965 | 0.5945 | 0.596 | 420000.0 |
| 2001-12-04 18:00:00 | AMZN | Stock | 0.595 | 0.5985 | 0.595 | 0.5985 | 192000.0 |
| 2001-12-04 09:00:00 | CL | Stock | 28.95 | 29.06 | 28.915 | 28.995 | 182400.0 |
| 2001-12-04 10:00:00 | CL | Stock | 28.95 | 29.0 | 28.925 | 28.995 | 215400.0 |
| 2001-12-04 11:00:00 | CL | Stock | 28.99 | 29.025 | 28.875 | 28.98 | 235600.0 |
| 2001-12-04 12:00:00 | CL | Stock | 28.95 | 29.04 | 28.895 | 29.0 | 195000.0 |
| 2001-12-04 13:00:00 | CL | Stock | 29.015 | 29.06 | 28.925 | 29.0 | 176000.0 |
| 2001-12-04 14:00:00 | CL | Stock | 29.01 | 29.125 | 28.95 | 29.05 | 306200.0 |
| 2001-12-04 15:00:00 | CL | Stock | 29.055 | 29.175 | 29.055 | 29.13 | 318600.0 |
> showing 50 of 18,125 rows — these rows as CSV