PREVIEW / stock_1hour / 2003-11-13
file: by_date/stock_1hour/2003/2003-11-13.parquet size: 493 KB rows: 22,833 symbols: 1,659
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-13 08:00:00 | AAPL | Stock | 0.3998 | 0.3998 | 0.3966 | 0.3966 | 162400.0 |
| 2003-11-13 09:00:00 | AAPL | Stock | 0.3964 | 0.3996 | 0.3914 | 0.3982 | 24648792.0 |
| 2003-11-13 10:00:00 | AAPL | Stock | 0.3982 | 0.4029 | 0.3946 | 0.3993 | 47413352.0 |
| 2003-11-13 11:00:00 | AAPL | Stock | 0.3993 | 0.3995 | 0.3954 | 0.3988 | 15409800.0 |
| 2003-11-13 12:00:00 | AAPL | Stock | 0.3986 | 0.4 | 0.397 | 0.3986 | 21090664.0 |
| 2003-11-13 13:00:00 | AAPL | Stock | 0.3986 | 0.3986 | 0.3952 | 0.3982 | 14970088.0 |
| 2003-11-13 14:00:00 | AAPL | Stock | 0.3982 | 0.4005 | 0.3961 | 0.4004 | 20453216.0 |
| 2003-11-13 15:00:00 | AAPL | Stock | 0.4004 | 0.4021 | 0.3966 | 0.4005 | 50913408.0 |
| 2003-11-13 16:00:00 | AAPL | Stock | 0.4005 | 0.4007 | 0.3986 | 0.4007 | 1454544.0 |
| 2003-11-13 17:00:00 | AAPL | Stock | 0.3996 | 0.3996 | 0.3996 | 0.3996 | 341600.0 |
| 2003-11-13 08:00:00 | MSFT | Stock | 26.1 | 26.1 | 25.859 | 25.87 | 171070.0 |
| 2003-11-13 09:00:00 | MSFT | Stock | 25.87 | 26.04 | 25.63 | 25.7 | 11240387.0 |
| 2003-11-13 10:00:00 | MSFT | Stock | 25.701 | 25.75 | 25.45 | 25.55 | 14337424.0 |
| 2003-11-13 11:00:00 | MSFT | Stock | 25.56 | 25.62 | 25.51 | 25.589 | 7780550.0 |
| 2003-11-13 12:00:00 | MSFT | Stock | 25.589 | 25.64 | 25.53 | 25.63 | 5760132.0 |
| 2003-11-13 13:00:00 | MSFT | Stock | 25.63 | 25.64 | 25.52 | 25.58 | 7450978.0 |
| 2003-11-13 14:00:00 | MSFT | Stock | 25.57 | 25.63 | 25.51 | 25.58 | 8496723.0 |
| 2003-11-13 15:00:00 | MSFT | Stock | 25.58 | 25.72 | 25.53 | 25.68 | 18165025.0 |
| 2003-11-13 16:00:00 | MSFT | Stock | 25.69 | 25.711 | 25.61 | 25.64 | 507498.0 |
| 2003-11-13 17:00:00 | MSFT | Stock | 25.63 | 25.68 | 25.6027 | 25.62 | 210524.0 |
| 2003-11-13 18:00:00 | MSFT | Stock | 25.64 | 25.64 | 25.61 | 25.63 | 12090.0 |
| 2003-11-13 08:00:00 | NVDA | Stock | 0.1792 | 0.1792 | 0.1782 | 0.1782 | 2472000.0 |
| 2003-11-13 09:00:00 | NVDA | Stock | 0.178 | 0.1799 | 0.1775 | 0.1799 | 80000160.0 |
| 2003-11-13 10:00:00 | NVDA | Stock | 0.1799 | 0.1812 | 0.1776 | 0.1784 | 97064400.0 |
| 2003-11-13 11:00:00 | NVDA | Stock | 0.1784 | 0.1798 | 0.1779 | 0.1797 | 53072400.0 |
| 2003-11-13 12:00:00 | NVDA | Stock | 0.1797 | 0.1804 | 0.1792 | 0.1796 | 55173360.0 |
| 2003-11-13 13:00:00 | NVDA | Stock | 0.1796 | 0.1796 | 0.1779 | 0.1782 | 62751000.0 |
| 2003-11-13 14:00:00 | NVDA | Stock | 0.1782 | 0.1792 | 0.1777 | 0.179 | 55157280.0 |
| 2003-11-13 15:00:00 | NVDA | Stock | 0.179 | 0.18 | 0.1786 | 0.1788 | 98275200.0 |
| 2003-11-13 16:00:00 | NVDA | Stock | 0.1787 | 0.1788 | 0.1778 | 0.1782 | 10963080.0 |
| 2003-11-13 17:00:00 | NVDA | Stock | 0.1782 | 0.1784 | 0.1782 | 0.1782 | 1701240.0 |
| 2003-11-13 18:00:00 | NVDA | Stock | 0.1783 | 0.1786 | 0.1783 | 0.1783 | 1286760.0 |
| 2003-11-13 08:00:00 | AMZN | Stock | 2.7195 | 2.7195 | 2.7 | 2.704 | 263500.0 |
| 2003-11-13 09:00:00 | AMZN | Stock | 2.704 | 2.7115 | 2.6785 | 2.6884 | 16659000.0 |
| 2003-11-13 10:00:00 | AMZN | Stock | 2.6885 | 2.7235 | 2.685 | 2.707 | 25898040.0 |
| 2003-11-13 11:00:00 | AMZN | Stock | 2.7075 | 2.7305 | 2.707 | 2.725 | 16207140.0 |
| 2003-11-13 12:00:00 | AMZN | Stock | 2.725 | 2.7375 | 2.721 | 2.727 | 12567000.0 |
| 2003-11-13 13:00:00 | AMZN | Stock | 2.727 | 2.742 | 2.72 | 2.7335 | 12305200.0 |
| 2003-11-13 14:00:00 | AMZN | Stock | 2.734 | 2.737 | 2.7215 | 2.729 | 14418040.0 |
| 2003-11-13 15:00:00 | AMZN | Stock | 2.729 | 2.7565 | 2.728 | 2.7405 | 32575400.0 |
| 2003-11-13 16:00:00 | AMZN | Stock | 2.7405 | 2.7405 | 2.7335 | 2.7398 | 564340.0 |
| 2003-11-13 17:00:00 | AMZN | Stock | 2.7286 | 2.74 | 2.7286 | 2.74 | 491200.0 |
| 2003-11-13 18:00:00 | AMZN | Stock | 2.7285 | 2.7286 | 2.7285 | 2.7286 | 6000.0 |
| 2003-11-13 09:00:00 | CL | Stock | 26.325 | 26.325 | 26.2 | 26.22 | 450800.0 |
| 2003-11-13 10:00:00 | CL | Stock | 26.215 | 26.27 | 26.165 | 26.2 | 525200.0 |
| 2003-11-13 11:00:00 | CL | Stock | 26.195 | 26.28 | 26.175 | 26.255 | 638200.0 |
| 2003-11-13 12:00:00 | CL | Stock | 26.26 | 26.31 | 26.23 | 26.295 | 237800.0 |
| 2003-11-13 13:00:00 | CL | Stock | 26.295 | 26.33 | 26.22 | 26.33 | 675600.0 |
| 2003-11-13 14:00:00 | CL | Stock | 26.335 | 26.455 | 26.255 | 26.45 | 420200.0 |
| 2003-11-13 15:00:00 | CL | Stock | 26.45 | 26.5 | 26.395 | 26.4 | 835000.0 |
> showing 50 of 22,833 rows — these rows as CSV