PREVIEW / stock_1hour / 2004-03-11
file: by_date/stock_1hour/2004/2004-03-11.parquet size: 511 KB rows: 24,109 symbols: 1,729
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 |
|---|---|---|---|---|---|---|---|
| 2004-03-11 08:00:00 | AAPL | Stock | 0.4911 | 0.4911 | 0.483 | 0.4848 | 268800.0 |
| 2004-03-11 09:00:00 | AAPL | Stock | 0.4848 | 0.5007 | 0.4839 | 0.4975 | 76087368.0 |
| 2004-03-11 10:00:00 | AAPL | Stock | 0.4975 | 0.5 | 0.4939 | 0.4973 | 80382456.0 |
| 2004-03-11 11:00:00 | AAPL | Stock | 0.4973 | 0.4982 | 0.4927 | 0.4945 | 47356176.0 |
| 2004-03-11 12:00:00 | AAPL | Stock | 0.4945 | 0.4973 | 0.4938 | 0.4971 | 38054744.0 |
| 2004-03-11 13:00:00 | AAPL | Stock | 0.4971 | 0.4993 | 0.4939 | 0.4946 | 33993960.0 |
| 2004-03-11 14:00:00 | AAPL | Stock | 0.4946 | 0.4991 | 0.49 | 0.492 | 74666424.0 |
| 2004-03-11 15:00:00 | AAPL | Stock | 0.492 | 0.4943 | 0.4838 | 0.4857 | 108913392.0 |
| 2004-03-11 16:00:00 | AAPL | Stock | 0.4861 | 0.4895 | 0.4842 | 0.4848 | 2750664.0 |
| 2004-03-11 17:00:00 | AAPL | Stock | 0.4843 | 0.5 | 0.4843 | 0.4864 | 4956168.0 |
| 2004-03-11 18:00:00 | AAPL | Stock | 0.485 | 0.485 | 0.4848 | 0.4848 | 179200.0 |
| 2004-03-11 08:00:00 | MSFT | Stock | 25.36 | 25.37 | 25.1 | 25.2 | 198289.0 |
| 2004-03-11 09:00:00 | MSFT | Stock | 25.19 | 25.55 | 25.15 | 25.42 | 9945674.0 |
| 2004-03-11 10:00:00 | MSFT | Stock | 25.41 | 25.6 | 25.35 | 25.45 | 10494630.0 |
| 2004-03-11 11:00:00 | MSFT | Stock | 25.45 | 25.55 | 25.39 | 25.54 | 6576379.0 |
| 2004-03-11 12:00:00 | MSFT | Stock | 25.54 | 25.78 | 25.5 | 25.68 | 9280538.0 |
| 2004-03-11 13:00:00 | MSFT | Stock | 25.68 | 25.71 | 25.46 | 25.51 | 7366773.0 |
| 2004-03-11 14:00:00 | MSFT | Stock | 25.51 | 25.69 | 25.4183 | 25.46 | 9456578.0 |
| 2004-03-11 15:00:00 | MSFT | Stock | 25.45 | 25.5 | 25.08 | 25.09 | 18370929.0 |
| 2004-03-11 16:00:00 | MSFT | Stock | 25.1 | 25.76 | 25.05 | 25.11 | 798852.0 |
| 2004-03-11 17:00:00 | MSFT | Stock | 25.11 | 25.77 | 25.07 | 25.11 | 97000.0 |
| 2004-03-11 18:00:00 | MSFT | Stock | 25.12 | 25.12 | 25.1 | 25.11 | 2900.0 |
| 2004-03-11 08:00:00 | NVDA | Stock | 0.173 | 0.173 | 0.1728 | 0.1728 | 264000.0 |
| 2004-03-11 09:00:00 | NVDA | Stock | 0.1728 | 0.1771 | 0.1723 | 0.1751 | 52684320.0 |
| 2004-03-11 10:00:00 | NVDA | Stock | 0.1751 | 0.1767 | 0.1737 | 0.1745 | 55587840.0 |
| 2004-03-11 11:00:00 | NVDA | Stock | 0.1745 | 0.1761 | 0.1729 | 0.1755 | 43500480.0 |
| 2004-03-11 12:00:00 | NVDA | Stock | 0.1754 | 0.1781 | 0.1746 | 0.1778 | 45390240.0 |
| 2004-03-11 13:00:00 | NVDA | Stock | 0.1778 | 0.1785 | 0.1762 | 0.1768 | 98310960.0 |
| 2004-03-11 14:00:00 | NVDA | Stock | 0.1768 | 0.1781 | 0.1758 | 0.1762 | 48428400.0 |
| 2004-03-11 15:00:00 | NVDA | Stock | 0.1762 | 0.1768 | 0.1732 | 0.1732 | 72493080.0 |
| 2004-03-11 16:00:00 | NVDA | Stock | 0.1732 | 0.1735 | 0.1727 | 0.1735 | 1458720.0 |
| 2004-03-11 17:00:00 | NVDA | Stock | 0.173 | 0.1778 | 0.173 | 0.1759 | 3370800.0 |
| 2004-03-11 08:00:00 | AMZN | Stock | 2.073 | 2.073 | 2.0305 | 2.04 | 72760.0 |
| 2004-03-11 09:00:00 | AMZN | Stock | 2.0565 | 2.1 | 2.048 | 2.089 | 15669000.0 |
| 2004-03-11 10:00:00 | AMZN | Stock | 2.0875 | 2.118 | 2.085 | 2.0935 | 20807600.0 |
| 2004-03-11 11:00:00 | AMZN | Stock | 2.093 | 2.096 | 2.085 | 2.09 | 10237740.0 |
| 2004-03-11 12:00:00 | AMZN | Stock | 2.0905 | 2.109 | 2.087 | 2.102 | 12992460.0 |
| 2004-03-11 13:00:00 | AMZN | Stock | 2.102 | 2.107 | 2.0925 | 2.0975 | 7027480.0 |
| 2004-03-11 14:00:00 | AMZN | Stock | 2.0975 | 2.1095 | 2.0775 | 2.08 | 17850460.0 |
| 2004-03-11 15:00:00 | AMZN | Stock | 2.08 | 2.085 | 2.056 | 2.0585 | 28480560.0 |
| 2004-03-11 16:00:00 | AMZN | Stock | 2.0585 | 2.066 | 2.0515 | 2.0585 | 731120.0 |
| 2004-03-11 17:00:00 | AMZN | Stock | 2.0625 | 2.1175 | 2.055 | 2.1175 | 1398080.0 |
| 2004-03-11 18:00:00 | AMZN | Stock | 2.0655 | 2.0655 | 2.06 | 2.06 | 20000.0 |
| 2004-03-11 09:00:00 | CL | Stock | 28.05 | 28.15 | 28.005 | 28.005 | 463400.0 |
| 2004-03-11 10:00:00 | CL | Stock | 28.005 | 28.005 | 27.73 | 27.89 | 724200.0 |
| 2004-03-11 11:00:00 | CL | Stock | 27.87 | 27.95 | 27.805 | 27.885 | 711000.0 |
| 2004-03-11 12:00:00 | CL | Stock | 27.895 | 27.96 | 27.85 | 27.88 | 560200.0 |
| 2004-03-11 13:00:00 | CL | Stock | 27.88 | 27.89 | 27.79 | 27.8 | 1032200.0 |
| 2004-03-11 14:00:00 | CL | Stock | 27.8 | 27.89 | 27.655 | 27.68 | 546400.0 |
| 2004-03-11 15:00:00 | CL | Stock | 27.68 | 27.745 | 27.375 | 27.45 | 1450000.0 |
> showing 50 of 24,109 rows — these rows as CSV