PREVIEW / stock_30min / 2005-11-29
file: by_date/stock_30min/2005/2005-11-29.parquet size: 860 KB rows: 46,147 symbols: 2,123
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-29 07:00:00 | AAPL | Stock | 2.4996 | 2.5014 | 2.4996 | 2.5014 | 19600.0 |
| 2005-11-29 07:30:00 | AAPL | Stock | 2.4964 | 2.5014 | 2.4964 | 2.4986 | 28000.0 |
| 2005-11-29 08:00:00 | AAPL | Stock | 2.4986 | 2.5157 | 2.4964 | 2.5082 | 2341780.0 |
| 2005-11-29 08:30:00 | AAPL | Stock | 2.5089 | 2.5107 | 2.5 | 2.5021 | 1447348.0 |
| 2005-11-29 09:00:00 | AAPL | Stock | 2.5018 | 2.5018 | 2.4836 | 2.4996 | 8488816.0 |
| 2005-11-29 09:30:00 | AAPL | Stock | 2.4996 | 2.5107 | 2.4732 | 2.4814 | 125900964.0 |
| 2005-11-29 10:00:00 | AAPL | Stock | 2.4814 | 2.5032 | 2.45 | 2.4625 | 127085028.0 |
| 2005-11-29 10:30:00 | AAPL | Stock | 2.4625 | 2.5 | 2.4536 | 2.465 | 87094476.0 |
| 2005-11-29 11:00:00 | AAPL | Stock | 2.465 | 2.5068 | 2.4596 | 2.4675 | 38818976.0 |
| 2005-11-29 11:30:00 | AAPL | Stock | 2.4675 | 2.4821 | 2.4675 | 2.4778 | 39761932.0 |
| 2005-11-29 12:00:00 | AAPL | Stock | 2.4779 | 2.4804 | 2.4457 | 2.4471 | 51818648.0 |
| 2005-11-29 12:30:00 | AAPL | Stock | 2.4471 | 2.4539 | 2.425 | 2.4261 | 71028776.0 |
| 2005-11-29 13:00:00 | AAPL | Stock | 2.4264 | 2.4339 | 2.4157 | 2.4182 | 52819060.0 |
| 2005-11-29 13:30:00 | AAPL | Stock | 2.4185 | 2.4271 | 2.4054 | 2.4232 | 67820228.0 |
| 2005-11-29 14:00:00 | AAPL | Stock | 2.4232 | 2.4382 | 2.4218 | 2.4218 | 51193800.0 |
| 2005-11-29 14:30:00 | AAPL | Stock | 2.4221 | 2.4496 | 2.4214 | 2.4432 | 53628288.0 |
| 2005-11-29 15:00:00 | AAPL | Stock | 2.4436 | 2.4532 | 2.4357 | 2.4518 | 37240252.0 |
| 2005-11-29 15:30:00 | AAPL | Stock | 2.4521 | 2.4528 | 2.4275 | 2.4329 | 58108288.0 |
| 2005-11-29 16:00:00 | AAPL | Stock | 2.4321 | 2.4346 | 2.425 | 2.425 | 1668072.0 |
| 2005-11-29 16:30:00 | AAPL | Stock | 2.4268 | 2.4286 | 2.4218 | 2.4268 | 360080.0 |
| 2005-11-29 17:00:00 | AAPL | Stock | 2.4268 | 2.4321 | 2.4254 | 2.4268 | 241360.0 |
| 2005-11-29 17:30:00 | AAPL | Stock | 2.4314 | 2.4314 | 2.4214 | 2.425 | 469924.0 |
| 2005-11-29 18:00:00 | AAPL | Stock | 2.425 | 2.4264 | 2.4232 | 2.4232 | 191352.0 |
| 2005-11-29 08:00:00 | MSFT | Stock | 27.8 | 27.83 | 27.75 | 27.76 | 19204.0 |
| 2005-11-29 08:30:00 | MSFT | Stock | 27.75 | 27.79 | 27.73 | 27.75 | 26163.0 |
| 2005-11-29 09:00:00 | MSFT | Stock | 27.71 | 27.82 | 27.71 | 27.76 | 3177656.0 |
| 2005-11-29 09:30:00 | MSFT | Stock | 27.79 | 27.79 | 27.62 | 27.65 | 7184405.0 |
| 2005-11-29 10:00:00 | MSFT | Stock | 27.66 | 27.769 | 27.6 | 27.68 | 5154737.0 |
| 2005-11-29 10:30:00 | MSFT | Stock | 27.68 | 27.69 | 27.62 | 27.65 | 3666041.0 |
| 2005-11-29 11:00:00 | MSFT | Stock | 27.65 | 27.73 | 27.64 | 27.71 | 3683855.0 |
| 2005-11-29 11:30:00 | MSFT | Stock | 27.7 | 27.74 | 27.7 | 27.72 | 3198235.0 |
| 2005-11-29 12:00:00 | MSFT | Stock | 27.72 | 27.77 | 27.69 | 27.741 | 5972251.0 |
| 2005-11-29 12:30:00 | MSFT | Stock | 27.74 | 27.79 | 27.74 | 27.75 | 1612961.0 |
| 2005-11-29 13:00:00 | MSFT | Stock | 27.76 | 27.76 | 27.69 | 27.69 | 3538247.0 |
| 2005-11-29 13:30:00 | MSFT | Stock | 27.69 | 27.72 | 27.66 | 27.7 | 5508546.0 |
| 2005-11-29 14:00:00 | MSFT | Stock | 27.71 | 27.73 | 27.66 | 27.7 | 3480407.0 |
| 2005-11-29 14:30:00 | MSFT | Stock | 27.7 | 27.78 | 27.69 | 27.73 | 4347375.0 |
| 2005-11-29 15:00:00 | MSFT | Stock | 27.74 | 27.74 | 27.69 | 27.72 | 2669008.0 |
| 2005-11-29 15:30:00 | MSFT | Stock | 27.73 | 27.78 | 27.68 | 27.68 | 6170553.0 |
| 2005-11-29 16:00:00 | MSFT | Stock | 27.68 | 27.75 | 27.55 | 27.63 | 428666.0 |
| 2005-11-29 16:30:00 | MSFT | Stock | 27.65 | 27.66 | 27.63 | 27.64 | 1460.0 |
| 2005-11-29 17:00:00 | MSFT | Stock | 27.64 | 27.687 | 27.64 | 27.64 | 15760.0 |
| 2005-11-29 17:30:00 | MSFT | Stock | 27.64 | 27.64 | 27.64 | 27.64 | 696.0 |
| 2005-11-29 18:00:00 | MSFT | Stock | 27.64 | 27.68 | 27.64 | 27.65 | 1930.0 |
| 2005-11-29 07:00:00 | NVDA | Stock | 0.3029 | 0.3032 | 0.3015 | 0.3015 | 433320.0 |
| 2005-11-29 07:30:00 | NVDA | Stock | 0.3015 | 0.3015 | 0.3 | 0.3 | 196800.0 |
| 2005-11-29 08:00:00 | NVDA | Stock | 0.2997 | 0.3008 | 0.2967 | 0.2982 | 7164120.0 |
| 2005-11-29 08:30:00 | NVDA | Stock | 0.2989 | 0.2995 | 0.2979 | 0.2986 | 4114080.0 |
| 2005-11-29 09:00:00 | NVDA | Stock | 0.2984 | 0.2992 | 0.2967 | 0.2973 | 7068240.0 |
| 2005-11-29 09:30:00 | NVDA | Stock | 0.297 | 0.3038 | 0.2943 | 0.3023 | 253828680.0 |
> showing 50 of 46,147 rows — these rows as CSV