PREVIEW / stock_1hour / 2003-11-11
file: by_date/stock_1hour/2003/2003-11-11.parquet size: 485 KB rows: 22,681 symbols: 1,660
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 |
|---|---|---|---|---|---|---|---|
| 2003-11-11 08:00:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3929 | 0.3929 | 16800.0 |
| 2003-11-11 09:00:00 | AAPL | Stock | 0.3909 | 0.3932 | 0.3884 | 0.3916 | 33847184.0 |
| 2003-11-11 10:00:00 | AAPL | Stock | 0.3914 | 0.3916 | 0.3857 | 0.3859 | 43957480.0 |
| 2003-11-11 11:00:00 | AAPL | Stock | 0.3859 | 0.3911 | 0.3857 | 0.3871 | 12337472.0 |
| 2003-11-11 12:00:00 | AAPL | Stock | 0.387 | 0.3899 | 0.3861 | 0.3889 | 20845832.0 |
| 2003-11-11 13:00:00 | AAPL | Stock | 0.3888 | 0.3893 | 0.3871 | 0.3877 | 11970168.0 |
| 2003-11-11 14:00:00 | AAPL | Stock | 0.3877 | 0.3877 | 0.3836 | 0.385 | 31654056.0 |
| 2003-11-11 15:00:00 | AAPL | Stock | 0.385 | 0.3855 | 0.3836 | 0.3845 | 42829472.0 |
| 2003-11-11 16:00:00 | AAPL | Stock | 0.3852 | 0.3886 | 0.3841 | 0.3848 | 1517600.0 |
| 2003-11-11 17:00:00 | AAPL | Stock | 0.3861 | 0.3861 | 0.3861 | 0.3861 | 5600.0 |
| 2003-11-11 08:00:00 | MSFT | Stock | 25.95 | 26.02 | 25.94 | 26.0 | 330600.0 |
| 2003-11-11 09:00:00 | MSFT | Stock | 26.0 | 26.076 | 25.98 | 26.04 | 5513517.0 |
| 2003-11-11 10:00:00 | MSFT | Stock | 26.03 | 26.05 | 25.81 | 25.89 | 14358383.0 |
| 2003-11-11 11:00:00 | MSFT | Stock | 25.89 | 26.0 | 25.85 | 25.88 | 6759313.0 |
| 2003-11-11 12:00:00 | MSFT | Stock | 25.88 | 25.9 | 25.8 | 25.88 | 5959582.0 |
| 2003-11-11 13:00:00 | MSFT | Stock | 25.89 | 25.9 | 25.8 | 25.82 | 4948731.0 |
| 2003-11-11 14:00:00 | MSFT | Stock | 25.82 | 25.85 | 25.75 | 25.774 | 8754227.0 |
| 2003-11-11 15:00:00 | MSFT | Stock | 25.77 | 25.81 | 25.67 | 25.81 | 12481030.0 |
| 2003-11-11 16:00:00 | MSFT | Stock | 25.8 | 25.87 | 25.7527 | 25.85 | 1097965.0 |
| 2003-11-11 17:00:00 | MSFT | Stock | 25.84 | 25.84 | 25.82 | 25.82 | 6770.0 |
| 2003-11-11 18:00:00 | MSFT | Stock | 25.825 | 25.825 | 25.81 | 25.81 | 2705.0 |
| 2003-11-11 08:00:00 | NVDA | Stock | 0.1804 | 0.1808 | 0.1796 | 0.18 | 1095000.0 |
| 2003-11-11 09:00:00 | NVDA | Stock | 0.18 | 0.18 | 0.1761 | 0.1773 | 178908240.0 |
| 2003-11-11 10:00:00 | NVDA | Stock | 0.1773 | 0.1777 | 0.1731 | 0.1757 | 184183320.0 |
| 2003-11-11 11:00:00 | NVDA | Stock | 0.1757 | 0.1776 | 0.1752 | 0.1756 | 98766840.0 |
| 2003-11-11 12:00:00 | NVDA | Stock | 0.1756 | 0.1767 | 0.1751 | 0.1762 | 56646480.0 |
| 2003-11-11 13:00:00 | NVDA | Stock | 0.1762 | 0.1771 | 0.1758 | 0.1759 | 41648160.0 |
| 2003-11-11 14:00:00 | NVDA | Stock | 0.1758 | 0.176 | 0.1748 | 0.175 | 61044600.0 |
| 2003-11-11 15:00:00 | NVDA | Stock | 0.175 | 0.1763 | 0.1735 | 0.1761 | 119862120.0 |
| 2003-11-11 16:00:00 | NVDA | Stock | 0.1763 | 0.1767 | 0.1747 | 0.1759 | 3559320.0 |
| 2003-11-11 17:00:00 | NVDA | Stock | 0.1757 | 0.1757 | 0.175 | 0.175 | 600000.0 |
| 2003-11-11 18:00:00 | NVDA | Stock | 0.1755 | 0.1755 | 0.1752 | 0.1752 | 672000.0 |
| 2003-11-11 08:00:00 | AMZN | Stock | 2.595 | 2.595 | 2.576 | 2.5875 | 190460.0 |
| 2003-11-11 09:00:00 | AMZN | Stock | 2.587 | 2.6375 | 2.584 | 2.6295 | 29475680.0 |
| 2003-11-11 10:00:00 | AMZN | Stock | 2.6295 | 2.631 | 2.538 | 2.5585 | 47631920.0 |
| 2003-11-11 11:00:00 | AMZN | Stock | 2.5575 | 2.5755 | 2.5475 | 2.5515 | 27766380.0 |
| 2003-11-11 12:00:00 | AMZN | Stock | 2.5525 | 2.5675 | 2.5405 | 2.562 | 16406400.0 |
| 2003-11-11 13:00:00 | AMZN | Stock | 2.562 | 2.572 | 2.5605 | 2.569 | 11448020.0 |
| 2003-11-11 14:00:00 | AMZN | Stock | 2.5685 | 2.6085 | 2.5685 | 2.5985 | 28238880.0 |
| 2003-11-11 15:00:00 | AMZN | Stock | 2.5985 | 2.6295 | 2.5885 | 2.611 | 41522900.0 |
| 2003-11-11 16:00:00 | AMZN | Stock | 2.614 | 2.616 | 2.5889 | 2.615 | 1178420.0 |
| 2003-11-11 17:00:00 | AMZN | Stock | 2.6115 | 2.6175 | 2.6115 | 2.617 | 1137560.0 |
| 2003-11-11 18:00:00 | AMZN | Stock | 2.6175 | 2.622 | 2.6175 | 2.622 | 14000.0 |
| 2003-11-11 09:00:00 | CL | Stock | 25.97 | 26.115 | 25.97 | 26.065 | 317400.0 |
| 2003-11-11 10:00:00 | CL | Stock | 26.06 | 26.155 | 26.055 | 26.14 | 700200.0 |
| 2003-11-11 11:00:00 | CL | Stock | 26.14 | 26.15 | 26.03 | 26.09 | 772400.0 |
| 2003-11-11 12:00:00 | CL | Stock | 26.085 | 26.11 | 26.05 | 26.07 | 735200.0 |
| 2003-11-11 13:00:00 | CL | Stock | 26.07 | 26.095 | 26.02 | 26.085 | 447600.0 |
| 2003-11-11 14:00:00 | CL | Stock | 26.08 | 26.085 | 26.025 | 26.05 | 343200.0 |
| 2003-11-11 15:00:00 | CL | Stock | 26.055 | 26.15 | 26.05 | 26.15 | 608600.0 |
> showing 50 of 22,681 rows — these rows as CSV