PREVIEW / stock_1hour / 2002-03-11
file: by_date/stock_1hour/2002/2002-03-11.parquet size: 390 KB rows: 18,117 symbols: 1,398
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-03-11 08:00:00 | AAPL | Stock | 0.4406 | 0.4406 | 0.4391 | 0.4391 | 179200.0 |
| 2002-03-11 09:00:00 | AAPL | Stock | 0.4395 | 0.4414 | 0.4304 | 0.4327 | 29993600.0 |
| 2002-03-11 10:00:00 | AAPL | Stock | 0.433 | 0.442 | 0.4318 | 0.44 | 40572000.0 |
| 2002-03-11 11:00:00 | AAPL | Stock | 0.44 | 0.4411 | 0.4362 | 0.4366 | 15842400.0 |
| 2002-03-11 12:00:00 | AAPL | Stock | 0.4366 | 0.4418 | 0.4366 | 0.4405 | 9609600.0 |
| 2002-03-11 13:00:00 | AAPL | Stock | 0.4405 | 0.4459 | 0.4388 | 0.4459 | 17046400.0 |
| 2002-03-11 14:00:00 | AAPL | Stock | 0.4457 | 0.4489 | 0.4443 | 0.4464 | 58878400.0 |
| 2002-03-11 15:00:00 | AAPL | Stock | 0.4464 | 0.4479 | 0.4438 | 0.4473 | 54409600.0 |
| 2002-03-11 16:00:00 | AAPL | Stock | 0.4473 | 0.4475 | 0.4418 | 0.4475 | 27361600.0 |
| 2002-03-11 17:00:00 | AAPL | Stock | 0.4475 | 0.4475 | 0.4475 | 0.4475 | 44800.0 |
| 2002-03-11 18:00:00 | AAPL | Stock | 0.4464 | 0.4464 | 0.4464 | 0.4464 | 5600.0 |
| 2002-03-11 08:00:00 | MSFT | Stock | 31.915 | 31.95 | 31.75 | 31.8 | 11200.0 |
| 2002-03-11 09:00:00 | MSFT | Stock | 31.7995 | 31.97 | 31.5545 | 31.645 | 5719800.0 |
| 2002-03-11 10:00:00 | MSFT | Stock | 31.645 | 32.1 | 31.5 | 32.08 | 9602200.0 |
| 2002-03-11 11:00:00 | MSFT | Stock | 32.0895 | 32.145 | 31.915 | 31.945 | 4211000.0 |
| 2002-03-11 12:00:00 | MSFT | Stock | 31.945 | 32.04 | 31.82 | 31.95 | 3051000.0 |
| 2002-03-11 13:00:00 | MSFT | Stock | 31.95 | 32.125 | 31.915 | 32.125 | 2700200.0 |
| 2002-03-11 14:00:00 | MSFT | Stock | 32.125 | 32.475 | 32.09 | 32.4251 | 7539600.0 |
| 2002-03-11 15:00:00 | MSFT | Stock | 32.43 | 32.5 | 32.15 | 32.165 | 7515200.0 |
| 2002-03-11 16:00:00 | MSFT | Stock | 32.165 | 32.205 | 31.6143 | 32.13 | 1500000.0 |
| 2002-03-11 17:00:00 | MSFT | Stock | 32.125 | 32.17 | 32.06 | 32.06 | 35600.0 |
| 2002-03-11 08:00:00 | NVDA | Stock | 0.4857 | 0.4857 | 0.4792 | 0.4805 | 336000.0 |
| 2002-03-11 09:00:00 | NVDA | Stock | 0.4806 | 0.4845 | 0.4721 | 0.4752 | 135588000.0 |
| 2002-03-11 10:00:00 | NVDA | Stock | 0.4753 | 0.4822 | 0.474 | 0.4767 | 175248000.0 |
| 2002-03-11 11:00:00 | NVDA | Stock | 0.4769 | 0.4774 | 0.4734 | 0.4745 | 76308000.0 |
| 2002-03-11 12:00:00 | NVDA | Stock | 0.4747 | 0.4772 | 0.4738 | 0.4767 | 53076000.0 |
| 2002-03-11 13:00:00 | NVDA | Stock | 0.4767 | 0.4786 | 0.475 | 0.4779 | 51744000.0 |
| 2002-03-11 14:00:00 | NVDA | Stock | 0.478 | 0.4845 | 0.4771 | 0.4833 | 124728000.0 |
| 2002-03-11 15:00:00 | NVDA | Stock | 0.4833 | 0.4857 | 0.4793 | 0.4801 | 91884000.0 |
| 2002-03-11 16:00:00 | NVDA | Stock | 0.4801 | 0.4805 | 0.4774 | 0.4792 | 8748000.0 |
| 2002-03-11 17:00:00 | NVDA | Stock | 0.4793 | 0.4801 | 0.4792 | 0.4792 | 312000.0 |
| 2002-03-11 18:00:00 | NVDA | Stock | 0.4783 | 0.4783 | 0.4783 | 0.4783 | 48000.0 |
| 2002-03-11 08:00:00 | AMZN | Stock | 0.812 | 0.812 | 0.812 | 0.812 | 36000.0 |
| 2002-03-11 09:00:00 | AMZN | Stock | 0.81 | 0.8195 | 0.793 | 0.7985 | 24734000.0 |
| 2002-03-11 10:00:00 | AMZN | Stock | 0.798 | 0.8285 | 0.794 | 0.825 | 26756000.0 |
| 2002-03-11 11:00:00 | AMZN | Stock | 0.826 | 0.83 | 0.816 | 0.8215 | 11572000.0 |
| 2002-03-11 12:00:00 | AMZN | Stock | 0.8205 | 0.8205 | 0.8125 | 0.817 | 10940000.0 |
| 2002-03-11 13:00:00 | AMZN | Stock | 0.817 | 0.825 | 0.8135 | 0.824 | 11764000.0 |
| 2002-03-11 14:00:00 | AMZN | Stock | 0.824 | 0.8415 | 0.8236 | 0.8375 | 19338000.0 |
| 2002-03-11 15:00:00 | AMZN | Stock | 0.8385 | 0.844 | 0.833 | 0.835 | 19032000.0 |
| 2002-03-11 16:00:00 | AMZN | Stock | 0.835 | 0.8375 | 0.8207 | 0.8355 | 1570000.0 |
| 2002-03-11 17:00:00 | AMZN | Stock | 0.834 | 0.835 | 0.833 | 0.833 | 52000.0 |
| 2002-03-11 18:00:00 | AMZN | Stock | 0.833 | 0.833 | 0.832 | 0.833 | 20000.0 |
| 2002-03-11 09:00:00 | CL | Stock | 27.1 | 27.125 | 26.725 | 26.79 | 625000.0 |
| 2002-03-11 10:00:00 | CL | Stock | 26.83 | 26.84 | 26.665 | 26.725 | 410800.0 |
| 2002-03-11 11:00:00 | CL | Stock | 26.725 | 26.85 | 26.7 | 26.835 | 418800.0 |
| 2002-03-11 12:00:00 | CL | Stock | 26.84 | 26.925 | 26.76 | 26.825 | 391200.0 |
| 2002-03-11 13:00:00 | CL | Stock | 26.81 | 26.825 | 26.775 | 26.8 | 156000.0 |
| 2002-03-11 14:00:00 | CL | Stock | 26.8 | 26.97 | 26.8 | 26.94 | 432000.0 |
| 2002-03-11 15:00:00 | CL | Stock | 26.94 | 27.04 | 26.885 | 27.0 | 883200.0 |
> showing 50 of 18,117 rows — these rows as CSV