PREVIEW / stock_1hour / 2002-05-08
file: by_date/stock_1hour/2002/2002-05-08.parquet size: 418 KB rows: 19,434 symbols: 1,410
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 |
|---|---|---|---|---|---|---|---|
| 2002-05-08 08:00:00 | AAPL | Stock | 0.4105 | 0.4125 | 0.4084 | 0.4114 | 912800.0 |
| 2002-05-08 09:00:00 | AAPL | Stock | 0.4118 | 0.4196 | 0.4113 | 0.4179 | 67816000.0 |
| 2002-05-08 10:00:00 | AAPL | Stock | 0.4184 | 0.4248 | 0.4166 | 0.4214 | 74401600.0 |
| 2002-05-08 11:00:00 | AAPL | Stock | 0.4214 | 0.4288 | 0.4214 | 0.4279 | 35728000.0 |
| 2002-05-08 12:00:00 | AAPL | Stock | 0.4277 | 0.4375 | 0.4277 | 0.4348 | 50484000.0 |
| 2002-05-08 13:00:00 | AAPL | Stock | 0.4348 | 0.4373 | 0.4327 | 0.4332 | 33756800.0 |
| 2002-05-08 14:00:00 | AAPL | Stock | 0.4333 | 0.4366 | 0.4268 | 0.4338 | 50584800.0 |
| 2002-05-08 15:00:00 | AAPL | Stock | 0.4338 | 0.4379 | 0.4309 | 0.435 | 76053600.0 |
| 2002-05-08 16:00:00 | AAPL | Stock | 0.4352 | 0.4371 | 0.4143 | 0.4355 | 17785600.0 |
| 2002-05-08 17:00:00 | AAPL | Stock | 0.4354 | 0.4354 | 0.435 | 0.4352 | 263200.0 |
| 2002-05-08 08:00:00 | MSFT | Stock | 25.43 | 25.5 | 25.27 | 25.395 | 206000.0 |
| 2002-05-08 09:00:00 | MSFT | Stock | 25.395 | 25.99 | 25.395 | 25.91 | 16303200.0 |
| 2002-05-08 10:00:00 | MSFT | Stock | 25.905 | 26.37 | 25.905 | 26.175 | 14052200.0 |
| 2002-05-08 11:00:00 | MSFT | Stock | 26.175 | 26.65 | 26.15 | 26.55 | 10778600.0 |
| 2002-05-08 12:00:00 | MSFT | Stock | 26.55 | 26.845 | 26.47 | 26.68 | 10985800.0 |
| 2002-05-08 13:00:00 | MSFT | Stock | 26.685 | 26.79 | 26.625 | 26.725 | 7207600.0 |
| 2002-05-08 14:00:00 | MSFT | Stock | 26.73 | 27.15 | 26.565 | 27.005 | 13550000.0 |
| 2002-05-08 15:00:00 | MSFT | Stock | 27.005 | 27.485 | 26.935 | 27.48 | 21730000.0 |
| 2002-05-08 16:00:00 | MSFT | Stock | 27.485 | 27.485 | 26.06 | 27.405 | 4284800.0 |
| 2002-05-08 17:00:00 | MSFT | Stock | 27.4 | 27.485 | 27.375 | 27.38 | 136000.0 |
| 2002-05-08 18:00:00 | MSFT | Stock | 27.38 | 27.47 | 27.375 | 27.45 | 20000.0 |
| 2002-05-08 08:00:00 | NVDA | Stock | 0.2833 | 0.2875 | 0.279 | 0.285 | 4836000.0 |
| 2002-05-08 09:00:00 | NVDA | Stock | 0.2858 | 0.2896 | 0.2783 | 0.2819 | 174672000.0 |
| 2002-05-08 10:00:00 | NVDA | Stock | 0.282 | 0.2873 | 0.2817 | 0.2844 | 219576000.0 |
| 2002-05-08 11:00:00 | NVDA | Stock | 0.2846 | 0.2915 | 0.2839 | 0.2898 | 127716000.0 |
| 2002-05-08 12:00:00 | NVDA | Stock | 0.2899 | 0.3047 | 0.2897 | 0.2966 | 422412000.0 |
| 2002-05-08 13:00:00 | NVDA | Stock | 0.2966 | 0.2995 | 0.2937 | 0.299 | 195756000.0 |
| 2002-05-08 14:00:00 | NVDA | Stock | 0.299 | 0.302 | 0.2949 | 0.2987 | 179184000.0 |
| 2002-05-08 15:00:00 | NVDA | Stock | 0.2987 | 0.3009 | 0.2942 | 0.3 | 244476000.0 |
| 2002-05-08 16:00:00 | NVDA | Stock | 0.3 | 0.3 | 0.2937 | 0.2987 | 77616000.0 |
| 2002-05-08 17:00:00 | NVDA | Stock | 0.2985 | 0.3 | 0.2979 | 0.2979 | 1188000.0 |
| 2002-05-08 18:00:00 | NVDA | Stock | 0.2979 | 0.2991 | 0.2979 | 0.299 | 552000.0 |
| 2002-05-08 08:00:00 | AMZN | Stock | 0.825 | 0.8375 | 0.8125 | 0.827 | 242000.0 |
| 2002-05-08 09:00:00 | AMZN | Stock | 0.827 | 0.8385 | 0.82 | 0.832 | 20790000.0 |
| 2002-05-08 10:00:00 | AMZN | Stock | 0.832 | 0.842 | 0.832 | 0.84 | 22188000.0 |
| 2002-05-08 11:00:00 | AMZN | Stock | 0.84 | 0.8455 | 0.8385 | 0.8445 | 17388000.0 |
| 2002-05-08 12:00:00 | AMZN | Stock | 0.8445 | 0.8466 | 0.839 | 0.8395 | 12466000.0 |
| 2002-05-08 13:00:00 | AMZN | Stock | 0.84 | 0.847 | 0.839 | 0.845 | 11416000.0 |
| 2002-05-08 14:00:00 | AMZN | Stock | 0.8445 | 0.867 | 0.841 | 0.8625 | 33368000.0 |
| 2002-05-08 15:00:00 | AMZN | Stock | 0.862 | 0.873 | 0.861 | 0.8655 | 31970000.0 |
| 2002-05-08 16:00:00 | AMZN | Stock | 0.866 | 0.8685 | 0.8525 | 0.865 | 6404000.0 |
| 2002-05-08 17:00:00 | AMZN | Stock | 0.865 | 0.8665 | 0.863 | 0.863 | 198000.0 |
| 2002-05-08 18:00:00 | AMZN | Stock | 0.863 | 0.865 | 0.8625 | 0.865 | 24000.0 |
| 2002-05-08 09:00:00 | CL | Stock | 27.675 | 27.675 | 27.4 | 27.56 | 511800.0 |
| 2002-05-08 10:00:00 | CL | Stock | 27.535 | 27.6 | 27.34 | 27.4 | 1055800.0 |
| 2002-05-08 11:00:00 | CL | Stock | 27.4 | 27.575 | 27.395 | 27.475 | 445800.0 |
| 2002-05-08 12:00:00 | CL | Stock | 27.475 | 27.6 | 27.47 | 27.53 | 388000.0 |
| 2002-05-08 13:00:00 | CL | Stock | 27.53 | 27.645 | 27.51 | 27.595 | 363800.0 |
| 2002-05-08 14:00:00 | CL | Stock | 27.595 | 27.65 | 27.55 | 27.61 | 459400.0 |
| 2002-05-08 15:00:00 | CL | Stock | 27.605 | 27.685 | 27.53 | 27.64 | 1195600.0 |
> showing 50 of 19,434 rows — these rows as CSV