PREVIEW / stock_1hour / 2003-11-14
file: by_date/stock_1hour/2003/2003-11-14.parquet size: 488 KB rows: 22,445 symbols: 1,663
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-14 08:00:00 | AAPL | Stock | 0.375 | 0.4004 | 0.375 | 0.4004 | 42896.0 |
| 2003-11-14 09:00:00 | AAPL | Stock | 0.4004 | 0.4038 | 0.3932 | 0.4011 | 16314144.0 |
| 2003-11-14 10:00:00 | AAPL | Stock | 0.4013 | 0.4029 | 0.3938 | 0.3948 | 41334160.0 |
| 2003-11-14 11:00:00 | AAPL | Stock | 0.395 | 0.3979 | 0.3946 | 0.3952 | 16249072.0 |
| 2003-11-14 12:00:00 | AAPL | Stock | 0.3952 | 0.397 | 0.3948 | 0.3948 | 10429104.0 |
| 2003-11-14 13:00:00 | AAPL | Stock | 0.3948 | 0.3955 | 0.3929 | 0.3934 | 23510928.0 |
| 2003-11-14 14:00:00 | AAPL | Stock | 0.3934 | 0.3939 | 0.3873 | 0.3882 | 28207424.0 |
| 2003-11-14 15:00:00 | AAPL | Stock | 0.3881 | 0.3882 | 0.3834 | 0.3839 | 82387200.0 |
| 2003-11-14 16:00:00 | AAPL | Stock | 0.3834 | 0.3863 | 0.3832 | 0.3857 | 3232936.0 |
| 2003-11-14 17:00:00 | AAPL | Stock | 0.3916 | 0.3916 | 0.3861 | 0.3863 | 121744.0 |
| 2003-11-14 08:00:00 | MSFT | Stock | 25.79 | 25.83 | 25.65 | 25.68 | 74240.0 |
| 2003-11-14 09:00:00 | MSFT | Stock | 25.66 | 25.99 | 25.65 | 25.979 | 11920646.0 |
| 2003-11-14 10:00:00 | MSFT | Stock | 25.98 | 26.02 | 25.7 | 25.71 | 15497188.0 |
| 2003-11-14 11:00:00 | MSFT | Stock | 25.71 | 25.84 | 25.71 | 25.79 | 6209441.0 |
| 2003-11-14 12:00:00 | MSFT | Stock | 25.79 | 25.83 | 25.75 | 25.78 | 5525663.0 |
| 2003-11-14 13:00:00 | MSFT | Stock | 25.78 | 25.8 | 25.66 | 25.67 | 5536596.0 |
| 2003-11-14 14:00:00 | MSFT | Stock | 25.67 | 25.68 | 25.54 | 25.57 | 12909298.0 |
| 2003-11-14 15:00:00 | MSFT | Stock | 25.56 | 25.62 | 25.45 | 25.45 | 16983574.0 |
| 2003-11-14 16:00:00 | MSFT | Stock | 25.46 | 25.57 | 25.4 | 25.46 | 949200.0 |
| 2003-11-14 17:00:00 | MSFT | Stock | 25.51 | 25.709 | 25.47 | 25.49 | 23370.0 |
| 2003-11-14 18:00:00 | MSFT | Stock | 25.49 | 25.5 | 25.47 | 25.47 | 8065.0 |
| 2003-11-14 08:00:00 | NVDA | Stock | 0.1792 | 0.1792 | 0.1792 | 0.1792 | 48000.0 |
| 2003-11-14 09:00:00 | NVDA | Stock | 0.1792 | 0.1795 | 0.1772 | 0.1785 | 53775600.0 |
| 2003-11-14 10:00:00 | NVDA | Stock | 0.1784 | 0.1784 | 0.1714 | 0.1714 | 219817080.0 |
| 2003-11-14 11:00:00 | NVDA | Stock | 0.1715 | 0.173 | 0.1712 | 0.172 | 103119480.0 |
| 2003-11-14 12:00:00 | NVDA | Stock | 0.1719 | 0.1727 | 0.1709 | 0.1712 | 52707360.0 |
| 2003-11-14 13:00:00 | NVDA | Stock | 0.1712 | 0.172 | 0.1694 | 0.1702 | 66618840.0 |
| 2003-11-14 14:00:00 | NVDA | Stock | 0.1702 | 0.1702 | 0.1677 | 0.1677 | 107770920.0 |
| 2003-11-14 15:00:00 | NVDA | Stock | 0.1678 | 0.1702 | 0.1676 | 0.1679 | 213853920.0 |
| 2003-11-14 16:00:00 | NVDA | Stock | 0.1679 | 0.1687 | 0.1679 | 0.1681 | 8370000.0 |
| 2003-11-14 17:00:00 | NVDA | Stock | 0.1685 | 0.1685 | 0.1685 | 0.1685 | 480000.0 |
| 2003-11-14 18:00:00 | NVDA | Stock | 0.1685 | 0.1687 | 0.1679 | 0.1687 | 745920.0 |
| 2003-11-14 08:00:00 | AMZN | Stock | 2.706 | 2.7325 | 2.706 | 2.7325 | 196000.0 |
| 2003-11-14 09:00:00 | AMZN | Stock | 2.7325 | 2.739 | 2.7045 | 2.705 | 21076480.0 |
| 2003-11-14 10:00:00 | AMZN | Stock | 2.7055 | 2.706 | 2.659 | 2.66 | 37599780.0 |
| 2003-11-14 11:00:00 | AMZN | Stock | 2.6605 | 2.6745 | 2.6585 | 2.6651 | 14212580.0 |
| 2003-11-14 12:00:00 | AMZN | Stock | 2.6655 | 2.672 | 2.6475 | 2.6606 | 12036040.0 |
| 2003-11-14 13:00:00 | AMZN | Stock | 2.6605 | 2.675 | 2.6555 | 2.66 | 14260320.0 |
| 2003-11-14 14:00:00 | AMZN | Stock | 2.66 | 2.6605 | 2.6225 | 2.623 | 18425620.0 |
| 2003-11-14 15:00:00 | AMZN | Stock | 2.6245 | 2.6275 | 2.6105 | 2.623 | 33049220.0 |
| 2003-11-14 16:00:00 | AMZN | Stock | 2.623 | 2.629 | 2.62 | 2.6245 | 2757100.0 |
| 2003-11-14 17:00:00 | AMZN | Stock | 2.6245 | 2.6245 | 2.6245 | 2.6245 | 76200.0 |
| 2003-11-14 18:00:00 | AMZN | Stock | 2.6215 | 2.6225 | 2.6215 | 2.6225 | 28000.0 |
| 2003-11-14 09:00:00 | CL | Stock | 26.42 | 26.45 | 26.255 | 26.33 | 249800.0 |
| 2003-11-14 10:00:00 | CL | Stock | 26.33 | 26.355 | 26.275 | 26.305 | 649600.0 |
| 2003-11-14 11:00:00 | CL | Stock | 26.325 | 26.365 | 26.26 | 26.345 | 518400.0 |
| 2003-11-14 12:00:00 | CL | Stock | 26.345 | 26.395 | 26.325 | 26.395 | 630400.0 |
| 2003-11-14 13:00:00 | CL | Stock | 26.385 | 26.42 | 26.25 | 26.28 | 554600.0 |
| 2003-11-14 14:00:00 | CL | Stock | 26.28 | 26.285 | 26.105 | 26.11 | 678200.0 |
| 2003-11-14 15:00:00 | CL | Stock | 26.11 | 26.155 | 26.0285 | 26.055 | 798600.0 |
> showing 50 of 22,445 rows — these rows as CSV