PREVIEW / stock_1hour / 2001-05-29
file: by_date/stock_1hour/2001/2001-05-29.parquet size: 364 KB rows: 17,315 symbols: 1,303
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-05-29 08:00:00 | AAPL | Stock | 0.4018 | 0.4018 | 0.4 | 0.4 | 11200.0 |
| 2001-05-29 09:00:00 | AAPL | Stock | 0.4 | 0.4036 | 0.383 | 0.385 | 65318400.0 |
| 2001-05-29 10:00:00 | AAPL | Stock | 0.385 | 0.385 | 0.3716 | 0.3807 | 117527200.0 |
| 2001-05-29 11:00:00 | AAPL | Stock | 0.3807 | 0.3839 | 0.3795 | 0.3795 | 57215200.0 |
| 2001-05-29 12:00:00 | AAPL | Stock | 0.3802 | 0.3821 | 0.3784 | 0.3821 | 38264800.0 |
| 2001-05-29 13:00:00 | AAPL | Stock | 0.3821 | 0.383 | 0.3757 | 0.38 | 39995200.0 |
| 2001-05-29 14:00:00 | AAPL | Stock | 0.38 | 0.3804 | 0.3773 | 0.3796 | 44447200.0 |
| 2001-05-29 15:00:00 | AAPL | Stock | 0.3791 | 0.3909 | 0.3748 | 0.3829 | 88608800.0 |
| 2001-05-29 16:00:00 | AAPL | Stock | 0.3834 | 0.3836 | 0.3752 | 0.3813 | 28240800.0 |
| 2001-05-29 17:00:00 | AAPL | Stock | 0.3834 | 0.3834 | 0.3795 | 0.3795 | 89600.0 |
| 2001-05-29 08:00:00 | MSFT | Stock | 35.675 | 35.675 | 35.25 | 35.25 | 97000.0 |
| 2001-05-29 09:00:00 | MSFT | Stock | 35.35 | 35.44 | 35.025 | 35.135 | 7723600.0 |
| 2001-05-29 10:00:00 | MSFT | Stock | 35.135 | 35.5 | 35.085 | 35.495 | 13591600.0 |
| 2001-05-29 11:00:00 | MSFT | Stock | 35.47 | 35.875 | 35.405 | 35.715 | 10200200.0 |
| 2001-05-29 12:00:00 | MSFT | Stock | 35.72 | 35.82 | 35.35 | 35.425 | 6955200.0 |
| 2001-05-29 13:00:00 | MSFT | Stock | 35.41 | 35.475 | 35.175 | 35.24 | 5015400.0 |
| 2001-05-29 14:00:00 | MSFT | Stock | 35.24 | 35.35 | 35.055 | 35.22 | 5922000.0 |
| 2001-05-29 15:00:00 | MSFT | Stock | 35.215 | 35.355 | 35.09 | 35.16 | 10318000.0 |
| 2001-05-29 16:00:00 | MSFT | Stock | 35.155 | 35.635 | 34.9 | 35.0 | 3307600.0 |
| 2001-05-29 17:00:00 | MSFT | Stock | 34.975 | 35.17 | 34.875 | 34.965 | 101400.0 |
| 2001-05-29 18:00:00 | MSFT | Stock | 34.925 | 34.925 | 34.925 | 34.925 | 200.0 |
| 2001-05-29 08:00:00 | NVDA | Stock | 0.3813 | 0.3825 | 0.3708 | 0.3805 | 5400000.0 |
| 2001-05-29 09:00:00 | NVDA | Stock | 0.3792 | 0.3812 | 0.3678 | 0.3729 | 157440000.0 |
| 2001-05-29 10:00:00 | NVDA | Stock | 0.3729 | 0.3785 | 0.37 | 0.3758 | 185736000.0 |
| 2001-05-29 11:00:00 | NVDA | Stock | 0.3759 | 0.3767 | 0.3707 | 0.371 | 96624000.0 |
| 2001-05-29 12:00:00 | NVDA | Stock | 0.3715 | 0.3718 | 0.3648 | 0.3676 | 103224000.0 |
| 2001-05-29 13:00:00 | NVDA | Stock | 0.3673 | 0.3675 | 0.3625 | 0.3644 | 101976000.0 |
| 2001-05-29 14:00:00 | NVDA | Stock | 0.3642 | 0.3663 | 0.3627 | 0.3635 | 77304000.0 |
| 2001-05-29 15:00:00 | NVDA | Stock | 0.3634 | 0.376 | 0.3613 | 0.3663 | 128064000.0 |
| 2001-05-29 16:00:00 | NVDA | Stock | 0.3667 | 0.3687 | 0.3609 | 0.3617 | 25416000.0 |
| 2001-05-29 17:00:00 | NVDA | Stock | 0.3636 | 0.3664 | 0.3615 | 0.3615 | 912000.0 |
| 2001-05-29 18:00:00 | NVDA | Stock | 0.3615 | 0.3644 | 0.3602 | 0.3644 | 264000.0 |
| 2001-05-29 08:00:00 | AMZN | Stock | 0.8525 | 0.8555 | 0.85 | 0.8555 | 36000.0 |
| 2001-05-29 09:00:00 | AMZN | Stock | 0.8525 | 0.8645 | 0.845 | 0.847 | 22730000.0 |
| 2001-05-29 10:00:00 | AMZN | Stock | 0.8475 | 0.864 | 0.835 | 0.859 | 29864000.0 |
| 2001-05-29 11:00:00 | AMZN | Stock | 0.8595 | 0.875 | 0.8465 | 0.867 | 26134000.0 |
| 2001-05-29 12:00:00 | AMZN | Stock | 0.8675 | 0.877 | 0.8565 | 0.8585 | 25120000.0 |
| 2001-05-29 13:00:00 | AMZN | Stock | 0.859 | 0.865 | 0.855 | 0.8625 | 13738000.0 |
| 2001-05-29 14:00:00 | AMZN | Stock | 0.865 | 0.8725 | 0.86 | 0.8645 | 20044000.0 |
| 2001-05-29 15:00:00 | AMZN | Stock | 0.864 | 0.8745 | 0.846 | 0.861 | 32622000.0 |
| 2001-05-29 16:00:00 | AMZN | Stock | 0.8605 | 0.866 | 0.855 | 0.8605 | 4044000.0 |
| 2001-05-29 17:00:00 | AMZN | Stock | 0.86 | 0.864 | 0.8575 | 0.864 | 50000.0 |
| 2001-05-29 18:00:00 | AMZN | Stock | 0.8625 | 0.864 | 0.8625 | 0.864 | 22000.0 |
| 2001-05-29 09:00:00 | CL | Stock | 28.39 | 28.715 | 28.355 | 28.715 | 212800.0 |
| 2001-05-29 10:00:00 | CL | Stock | 28.715 | 28.875 | 28.53 | 28.675 | 445400.0 |
| 2001-05-29 11:00:00 | CL | Stock | 28.675 | 28.74 | 28.6 | 28.685 | 159200.0 |
| 2001-05-29 12:00:00 | CL | Stock | 28.69 | 28.9 | 28.67 | 28.755 | 155800.0 |
| 2001-05-29 13:00:00 | CL | Stock | 28.735 | 28.875 | 28.71 | 28.875 | 228200.0 |
| 2001-05-29 14:00:00 | CL | Stock | 28.87 | 28.97 | 28.835 | 28.95 | 280000.0 |
| 2001-05-29 15:00:00 | CL | Stock | 28.95 | 29.1 | 28.905 | 29.0 | 739400.0 |
> showing 50 of 17,315 rows — these rows as CSV