PREVIEW / stock_1hour / 2002-02-15
file: by_date/stock_1hour/2002/2002-02-15.parquet size: 383 KB rows: 18,131 symbols: 1,386
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-02-15 08:00:00 | AAPL | Stock | 0.4396 | 0.4396 | 0.437 | 0.4373 | 1680000.0 |
| 2002-02-15 09:00:00 | AAPL | Stock | 0.4375 | 0.4441 | 0.4339 | 0.4432 | 36248800.0 |
| 2002-02-15 10:00:00 | AAPL | Stock | 0.4432 | 0.4461 | 0.4318 | 0.4336 | 83417600.0 |
| 2002-02-15 11:00:00 | AAPL | Stock | 0.4339 | 0.4366 | 0.4329 | 0.4344 | 19280800.0 |
| 2002-02-15 12:00:00 | AAPL | Stock | 0.4341 | 0.435 | 0.433 | 0.4345 | 10718400.0 |
| 2002-02-15 13:00:00 | AAPL | Stock | 0.4345 | 0.4345 | 0.4259 | 0.4271 | 23682400.0 |
| 2002-02-15 14:00:00 | AAPL | Stock | 0.427 | 0.4316 | 0.4266 | 0.4284 | 19516000.0 |
| 2002-02-15 15:00:00 | AAPL | Stock | 0.4282 | 0.4325 | 0.4259 | 0.4271 | 35156800.0 |
| 2002-02-15 16:00:00 | AAPL | Stock | 0.4268 | 0.4432 | 0.4254 | 0.4286 | 11564000.0 |
| 2002-02-15 17:00:00 | AAPL | Stock | 0.4268 | 0.4268 | 0.4268 | 0.4268 | 78400.0 |
| 2002-02-15 18:00:00 | AAPL | Stock | 0.4288 | 0.4288 | 0.4288 | 0.4288 | 11200.0 |
| 2002-02-15 08:00:00 | MSFT | Stock | 30.835 | 30.84 | 30.75 | 30.835 | 235400.0 |
| 2002-02-15 09:00:00 | MSFT | Stock | 30.81 | 31.0 | 30.575 | 30.65 | 6251400.0 |
| 2002-02-15 10:00:00 | MSFT | Stock | 30.65 | 30.71 | 30.515 | 30.685 | 7897800.0 |
| 2002-02-15 11:00:00 | MSFT | Stock | 30.685 | 30.71 | 30.45 | 30.48 | 4934800.0 |
| 2002-02-15 12:00:00 | MSFT | Stock | 30.48 | 30.495 | 30.225 | 30.4 | 6192600.0 |
| 2002-02-15 13:00:00 | MSFT | Stock | 30.4 | 30.42 | 30.175 | 30.23 | 3977800.0 |
| 2002-02-15 14:00:00 | MSFT | Stock | 30.23 | 30.415 | 30.21 | 30.29 | 4307000.0 |
| 2002-02-15 15:00:00 | MSFT | Stock | 30.295 | 30.35 | 30.105 | 30.115 | 11373600.0 |
| 2002-02-15 16:00:00 | MSFT | Stock | 30.1 | 30.4532 | 30.09 | 30.235 | 3011400.0 |
| 2002-02-15 17:00:00 | MSFT | Stock | 30.24 | 30.25 | 30.115 | 30.24 | 411200.0 |
| 2002-02-15 18:00:00 | MSFT | Stock | 30.245 | 30.25 | 30.235 | 30.24 | 4400.0 |
| 2002-02-15 08:00:00 | NVDA | Stock | 0.4775 | 0.4907 | 0.45 | 0.4882 | 340044000.0 |
| 2002-02-15 09:00:00 | NVDA | Stock | 0.4872 | 0.5181 | 0.4567 | 0.4758 | 1321344000.0 |
| 2002-02-15 10:00:00 | NVDA | Stock | 0.4763 | 0.4917 | 0.4729 | 0.48 | 817404000.0 |
| 2002-02-15 11:00:00 | NVDA | Stock | 0.4799 | 0.4866 | 0.4775 | 0.4784 | 427596000.0 |
| 2002-02-15 12:00:00 | NVDA | Stock | 0.478 | 0.4822 | 0.4767 | 0.4786 | 185052000.0 |
| 2002-02-15 13:00:00 | NVDA | Stock | 0.4787 | 0.4823 | 0.4772 | 0.4772 | 170736000.0 |
| 2002-02-15 14:00:00 | NVDA | Stock | 0.4772 | 0.4818 | 0.4767 | 0.4795 | 224976000.0 |
| 2002-02-15 15:00:00 | NVDA | Stock | 0.4795 | 0.48 | 0.4744 | 0.4781 | 356700000.0 |
| 2002-02-15 16:00:00 | NVDA | Stock | 0.4779 | 0.4789 | 0.4747 | 0.4751 | 83364000.0 |
| 2002-02-15 17:00:00 | NVDA | Stock | 0.4753 | 0.4756 | 0.4633 | 0.4652 | 14604000.0 |
| 2002-02-15 18:00:00 | NVDA | Stock | 0.4651 | 0.4658 | 0.4625 | 0.465 | 4008000.0 |
| 2002-02-15 08:00:00 | AMZN | Stock | 0.6875 | 0.6965 | 0.6875 | 0.694 | 42000.0 |
| 2002-02-15 09:00:00 | AMZN | Stock | 0.6945 | 0.702 | 0.6805 | 0.681 | 22770000.0 |
| 2002-02-15 10:00:00 | AMZN | Stock | 0.6805 | 0.681 | 0.6635 | 0.6675 | 30598000.0 |
| 2002-02-15 11:00:00 | AMZN | Stock | 0.668 | 0.6825 | 0.666 | 0.675 | 13146000.0 |
| 2002-02-15 12:00:00 | AMZN | Stock | 0.6745 | 0.68 | 0.67 | 0.6775 | 9472000.0 |
| 2002-02-15 13:00:00 | AMZN | Stock | 0.679 | 0.68 | 0.6645 | 0.6675 | 13204000.0 |
| 2002-02-15 14:00:00 | AMZN | Stock | 0.6675 | 0.6765 | 0.666 | 0.675 | 21666000.0 |
| 2002-02-15 15:00:00 | AMZN | Stock | 0.675 | 0.6775 | 0.665 | 0.6705 | 29890000.0 |
| 2002-02-15 16:00:00 | AMZN | Stock | 0.6705 | 0.6955 | 0.6669 | 0.6695 | 1220000.0 |
| 2002-02-15 17:00:00 | AMZN | Stock | 0.6695 | 0.6705 | 0.6695 | 0.6705 | 54000.0 |
| 2002-02-15 18:00:00 | AMZN | Stock | 0.67 | 0.67 | 0.67 | 0.67 | 4000.0 |
| 2002-02-15 09:00:00 | CL | Stock | 27.52 | 27.635 | 27.475 | 27.525 | 291000.0 |
| 2002-02-15 10:00:00 | CL | Stock | 27.52 | 27.99 | 27.5 | 27.905 | 563600.0 |
| 2002-02-15 11:00:00 | CL | Stock | 27.925 | 27.95 | 27.84 | 27.925 | 467000.0 |
| 2002-02-15 12:00:00 | CL | Stock | 27.92 | 28.025 | 27.875 | 27.995 | 411800.0 |
| 2002-02-15 13:00:00 | CL | Stock | 27.975 | 27.99 | 27.855 | 27.855 | 176400.0 |
| 2002-02-15 14:00:00 | CL | Stock | 27.89 | 28.2 | 27.815 | 28.18 | 507400.0 |
> showing 50 of 18,131 rows — these rows as CSV