PREVIEW / stock_1hour / 2001-03-29
file: by_date/stock_1hour/2001/2001-03-29.parquet size: 349 KB rows: 16,392 symbols: 1,271
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-03-29 08:00:00 | AAPL | Stock | 0.3929 | 0.3964 | 0.3929 | 0.3941 | 2581600.0 |
| 2001-03-29 09:00:00 | AAPL | Stock | 0.3941 | 0.3973 | 0.3816 | 0.3948 | 50523200.0 |
| 2001-03-29 10:00:00 | AAPL | Stock | 0.3946 | 0.4173 | 0.3941 | 0.4166 | 134551200.0 |
| 2001-03-29 11:00:00 | AAPL | Stock | 0.417 | 0.4188 | 0.4095 | 0.4121 | 88894400.0 |
| 2001-03-29 12:00:00 | AAPL | Stock | 0.4121 | 0.4186 | 0.4116 | 0.4177 | 50002400.0 |
| 2001-03-29 13:00:00 | AAPL | Stock | 0.4177 | 0.418 | 0.4059 | 0.4064 | 53116000.0 |
| 2001-03-29 14:00:00 | AAPL | Stock | 0.4063 | 0.4075 | 0.3954 | 0.3959 | 89622400.0 |
| 2001-03-29 15:00:00 | AAPL | Stock | 0.3957 | 0.4023 | 0.3955 | 0.4023 | 74233600.0 |
| 2001-03-29 16:00:00 | AAPL | Stock | 0.4005 | 0.41 | 0.3982 | 0.4023 | 28666400.0 |
| 2001-03-29 17:00:00 | AAPL | Stock | 0.4023 | 0.4036 | 0.4023 | 0.4036 | 44800.0 |
| 2001-03-29 18:00:00 | AAPL | Stock | 0.4029 | 0.4029 | 0.4027 | 0.4027 | 252000.0 |
| 2001-03-29 08:00:00 | MSFT | Stock | 27.7344 | 27.8125 | 27.625 | 27.6875 | 104400.0 |
| 2001-03-29 09:00:00 | MSFT | Stock | 27.75 | 27.7812 | 27.5312 | 27.6875 | 12572400.0 |
| 2001-03-29 10:00:00 | MSFT | Stock | 27.6719 | 28.5938 | 27.2812 | 28.4375 | 17776800.0 |
| 2001-03-29 11:00:00 | MSFT | Stock | 28.4375 | 28.5 | 28.0 | 28.0938 | 8617600.0 |
| 2001-03-29 12:00:00 | MSFT | Stock | 28.0938 | 28.5 | 28.0625 | 28.3594 | 5038000.0 |
| 2001-03-29 13:00:00 | MSFT | Stock | 28.3438 | 28.4062 | 27.8125 | 27.9375 | 6779200.0 |
| 2001-03-29 14:00:00 | MSFT | Stock | 27.9062 | 28.2812 | 27.7344 | 27.75 | 9012200.0 |
| 2001-03-29 15:00:00 | MSFT | Stock | 27.75 | 27.8125 | 27.375 | 27.6875 | 20619000.0 |
| 2001-03-29 16:00:00 | MSFT | Stock | 27.6875 | 28.0781 | 27.5938 | 27.6875 | 3570200.0 |
| 2001-03-29 17:00:00 | MSFT | Stock | 27.6875 | 27.8906 | 27.6875 | 27.75 | 447600.0 |
| 2001-03-29 18:00:00 | MSFT | Stock | 27.75 | 27.75 | 27.5625 | 27.5625 | 2400.0 |
| 2001-03-29 08:00:00 | NVDA | Stock | 0.2833 | 0.2841 | 0.2792 | 0.2792 | 1032000.0 |
| 2001-03-29 09:00:00 | NVDA | Stock | 0.2797 | 0.2875 | 0.2755 | 0.2823 | 228744000.0 |
| 2001-03-29 10:00:00 | NVDA | Stock | 0.2823 | 0.2979 | 0.2822 | 0.2948 | 304320000.0 |
| 2001-03-29 11:00:00 | NVDA | Stock | 0.2948 | 0.2951 | 0.2854 | 0.2885 | 164304000.0 |
| 2001-03-29 12:00:00 | NVDA | Stock | 0.2885 | 0.2896 | 0.2849 | 0.2872 | 93192000.0 |
| 2001-03-29 13:00:00 | NVDA | Stock | 0.287 | 0.2875 | 0.2784 | 0.2789 | 242088000.0 |
| 2001-03-29 14:00:00 | NVDA | Stock | 0.2792 | 0.2833 | 0.2771 | 0.2828 | 239544000.0 |
| 2001-03-29 15:00:00 | NVDA | Stock | 0.2827 | 0.2906 | 0.2818 | 0.288 | 269352000.0 |
| 2001-03-29 16:00:00 | NVDA | Stock | 0.2878 | 0.2896 | 0.287 | 0.2885 | 12480000.0 |
| 2001-03-29 17:00:00 | NVDA | Stock | 0.2891 | 0.2891 | 0.2875 | 0.2875 | 312000.0 |
| 2001-03-29 08:00:00 | AMZN | Stock | 0.54 | 0.54 | 0.5245 | 0.53 | 318000.0 |
| 2001-03-29 09:00:00 | AMZN | Stock | 0.53 | 0.5375 | 0.5155 | 0.5205 | 9630000.0 |
| 2001-03-29 10:00:00 | AMZN | Stock | 0.5205 | 0.5515 | 0.514 | 0.5435 | 12502000.0 |
| 2001-03-29 11:00:00 | AMZN | Stock | 0.544 | 0.544 | 0.525 | 0.5365 | 8576000.0 |
| 2001-03-29 12:00:00 | AMZN | Stock | 0.537 | 0.54 | 0.533 | 0.535 | 4682000.0 |
| 2001-03-29 13:00:00 | AMZN | Stock | 0.533 | 0.535 | 0.5205 | 0.5255 | 7900000.0 |
| 2001-03-29 14:00:00 | AMZN | Stock | 0.524 | 0.5265 | 0.5085 | 0.5095 | 13212000.0 |
| 2001-03-29 15:00:00 | AMZN | Stock | 0.5095 | 0.514 | 0.5 | 0.5 | 24912000.0 |
| 2001-03-29 16:00:00 | AMZN | Stock | 0.5 | 0.51 | 0.495 | 0.5025 | 8292000.0 |
| 2001-03-29 17:00:00 | AMZN | Stock | 0.5 | 0.5 | 0.5 | 0.5 | 4000.0 |
| 2001-03-29 18:00:00 | AMZN | Stock | 0.5055 | 0.5055 | 0.5055 | 0.5055 | 2000.0 |
| 2001-03-29 09:00:00 | CL | Stock | 27.625 | 27.625 | 27.295 | 27.3 | 354400.0 |
| 2001-03-29 10:00:00 | CL | Stock | 27.325 | 27.375 | 27.1 | 27.365 | 668400.0 |
| 2001-03-29 11:00:00 | CL | Stock | 27.35 | 27.37 | 26.95 | 26.955 | 485200.0 |
| 2001-03-29 12:00:00 | CL | Stock | 26.97 | 27.37 | 26.96 | 27.27 | 239800.0 |
| 2001-03-29 13:00:00 | CL | Stock | 27.27 | 27.27 | 27.2 | 27.205 | 273000.0 |
| 2001-03-29 14:00:00 | CL | Stock | 27.2 | 27.205 | 26.95 | 26.95 | 490600.0 |
| 2001-03-29 15:00:00 | CL | Stock | 26.95 | 27.075 | 26.8 | 27.065 | 821200.0 |
> showing 50 of 16,392 rows — these rows as CSV