PREVIEW / stock_1hour / 2002-04-26
file: by_date/stock_1hour/2002/2002-04-26.parquet size: 401 KB rows: 18,816 symbols: 1,392
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-04-26 08:00:00 | AAPL | Stock | 0.4306 | 0.432 | 0.4306 | 0.432 | 1472800.0 |
| 2002-04-26 09:00:00 | AAPL | Stock | 0.433 | 0.4352 | 0.43 | 0.4334 | 20031200.0 |
| 2002-04-26 10:00:00 | AAPL | Stock | 0.4332 | 0.4336 | 0.4264 | 0.4291 | 28599200.0 |
| 2002-04-26 11:00:00 | AAPL | Stock | 0.4296 | 0.4296 | 0.425 | 0.4266 | 47796000.0 |
| 2002-04-26 12:00:00 | AAPL | Stock | 0.4268 | 0.4268 | 0.4182 | 0.4184 | 24113600.0 |
| 2002-04-26 13:00:00 | AAPL | Stock | 0.4186 | 0.4196 | 0.4145 | 0.4173 | 38063200.0 |
| 2002-04-26 14:00:00 | AAPL | Stock | 0.4177 | 0.4211 | 0.4168 | 0.418 | 37324000.0 |
| 2002-04-26 15:00:00 | AAPL | Stock | 0.418 | 0.4196 | 0.4107 | 0.4107 | 63649600.0 |
| 2002-04-26 16:00:00 | AAPL | Stock | 0.4111 | 0.4143 | 0.4107 | 0.4109 | 16419200.0 |
| 2002-04-26 17:00:00 | AAPL | Stock | 0.4109 | 0.4109 | 0.4109 | 0.4109 | 946400.0 |
| 2002-04-26 18:00:00 | AAPL | Stock | 0.4123 | 0.4123 | 0.4123 | 0.4123 | 5600.0 |
| 2002-04-26 08:00:00 | MSFT | Stock | 26.94 | 27.15 | 26.825 | 27.0 | 104600.0 |
| 2002-04-26 09:00:00 | MSFT | Stock | 26.995 | 27.225 | 26.8 | 26.8785 | 6558600.0 |
| 2002-04-26 10:00:00 | MSFT | Stock | 26.88 | 26.89 | 26.535 | 26.585 | 9614200.0 |
| 2002-04-26 11:00:00 | MSFT | Stock | 26.59 | 26.645 | 26.3905 | 26.52 | 8099200.0 |
| 2002-04-26 12:00:00 | MSFT | Stock | 26.54 | 26.56 | 26.255 | 26.306 | 5863600.0 |
| 2002-04-26 13:00:00 | MSFT | Stock | 26.31 | 26.385 | 26.11 | 26.281 | 5941800.0 |
| 2002-04-26 14:00:00 | MSFT | Stock | 26.29 | 26.475 | 26.145 | 26.175 | 6785800.0 |
| 2002-04-26 15:00:00 | MSFT | Stock | 26.18 | 26.23 | 25.73 | 25.735 | 14117200.0 |
| 2002-04-26 16:00:00 | MSFT | Stock | 25.74 | 26.463 | 25.625 | 25.85 | 2853400.0 |
| 2002-04-26 17:00:00 | MSFT | Stock | 25.675 | 25.75 | 25.625 | 25.675 | 145600.0 |
| 2002-04-26 18:00:00 | MSFT | Stock | 25.69 | 25.7 | 25.65 | 25.69 | 8800.0 |
| 2002-04-26 08:00:00 | NVDA | Stock | 0.2792 | 0.2869 | 0.2792 | 0.2849 | 2748000.0 |
| 2002-04-26 09:00:00 | NVDA | Stock | 0.285 | 0.285 | 0.2721 | 0.2757 | 115728000.0 |
| 2002-04-26 10:00:00 | NVDA | Stock | 0.2756 | 0.2757 | 0.2679 | 0.2703 | 185244000.0 |
| 2002-04-26 11:00:00 | NVDA | Stock | 0.2703 | 0.2709 | 0.2601 | 0.261 | 179784000.0 |
| 2002-04-26 12:00:00 | NVDA | Stock | 0.2611 | 0.2617 | 0.255 | 0.2594 | 217188000.0 |
| 2002-04-26 13:00:00 | NVDA | Stock | 0.2592 | 0.2648 | 0.2562 | 0.2641 | 132648000.0 |
| 2002-04-26 14:00:00 | NVDA | Stock | 0.2641 | 0.2667 | 0.2608 | 0.2618 | 115608000.0 |
| 2002-04-26 15:00:00 | NVDA | Stock | 0.262 | 0.2625 | 0.2531 | 0.2542 | 174852000.0 |
| 2002-04-26 16:00:00 | NVDA | Stock | 0.2532 | 0.2672 | 0.25 | 0.2522 | 14148000.0 |
| 2002-04-26 17:00:00 | NVDA | Stock | 0.2531 | 0.2532 | 0.2525 | 0.2532 | 864000.0 |
| 2002-04-26 18:00:00 | NVDA | Stock | 0.2525 | 0.2525 | 0.2525 | 0.2525 | 108000.0 |
| 2002-04-26 08:00:00 | AMZN | Stock | 0.845 | 0.8455 | 0.84 | 0.84 | 64000.0 |
| 2002-04-26 09:00:00 | AMZN | Stock | 0.84 | 0.844 | 0.829 | 0.837 | 22594000.0 |
| 2002-04-26 10:00:00 | AMZN | Stock | 0.8365 | 0.8405 | 0.8265 | 0.84 | 28958000.0 |
| 2002-04-26 11:00:00 | AMZN | Stock | 0.838 | 0.84 | 0.8295 | 0.83 | 15116000.0 |
| 2002-04-26 12:00:00 | AMZN | Stock | 0.8305 | 0.8305 | 0.816 | 0.82 | 15154000.0 |
| 2002-04-26 13:00:00 | AMZN | Stock | 0.82 | 0.835 | 0.8175 | 0.832 | 14402000.0 |
| 2002-04-26 14:00:00 | AMZN | Stock | 0.8315 | 0.84 | 0.8315 | 0.835 | 16376000.0 |
| 2002-04-26 15:00:00 | AMZN | Stock | 0.8345 | 0.8475 | 0.8295 | 0.8475 | 29882000.0 |
| 2002-04-26 16:00:00 | AMZN | Stock | 0.848 | 0.85 | 0.8319 | 0.848 | 7352000.0 |
| 2002-04-26 17:00:00 | AMZN | Stock | 0.8485 | 0.8485 | 0.845 | 0.845 | 808000.0 |
| 2002-04-26 18:00:00 | AMZN | Stock | 0.846 | 0.846 | 0.846 | 0.846 | 56000.0 |
| 2002-04-26 09:00:00 | CL | Stock | 27.775 | 27.78 | 27.685 | 27.715 | 342400.0 |
| 2002-04-26 10:00:00 | CL | Stock | 27.715 | 27.81 | 27.715 | 27.715 | 740800.0 |
| 2002-04-26 11:00:00 | CL | Stock | 27.715 | 27.795 | 27.65 | 27.76 | 496000.0 |
| 2002-04-26 12:00:00 | CL | Stock | 27.76 | 27.76 | 27.65 | 27.66 | 499600.0 |
| 2002-04-26 13:00:00 | CL | Stock | 27.66 | 27.785 | 27.655 | 27.685 | 336800.0 |
| 2002-04-26 14:00:00 | CL | Stock | 27.685 | 27.75 | 27.63 | 27.64 | 616400.0 |
> showing 50 of 18,816 rows — these rows as CSV