PREVIEW / stock_1hour / 2002-02-07
file: by_date/stock_1hour/2002/2002-02-07.parquet size: 377 KB rows: 17,962 symbols: 1,391
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-07 08:00:00 | AAPL | Stock | 0.4405 | 0.4438 | 0.4343 | 0.4423 | 308000.0 |
| 2002-02-07 09:00:00 | AAPL | Stock | 0.4411 | 0.4509 | 0.4321 | 0.4498 | 62748000.0 |
| 2002-02-07 10:00:00 | AAPL | Stock | 0.4495 | 0.4516 | 0.4423 | 0.4491 | 85943200.0 |
| 2002-02-07 11:00:00 | AAPL | Stock | 0.4484 | 0.45 | 0.4459 | 0.4473 | 37492000.0 |
| 2002-02-07 12:00:00 | AAPL | Stock | 0.447 | 0.4486 | 0.4427 | 0.4441 | 28991200.0 |
| 2002-02-07 13:00:00 | AAPL | Stock | 0.4443 | 0.4482 | 0.4429 | 0.4466 | 19527200.0 |
| 2002-02-07 14:00:00 | AAPL | Stock | 0.4473 | 0.4475 | 0.4438 | 0.4452 | 19224800.0 |
| 2002-02-07 15:00:00 | AAPL | Stock | 0.4454 | 0.4463 | 0.4336 | 0.4336 | 62417600.0 |
| 2002-02-07 16:00:00 | AAPL | Stock | 0.4339 | 0.4454 | 0.4304 | 0.4339 | 16312800.0 |
| 2002-02-07 17:00:00 | AAPL | Stock | 0.4339 | 0.4348 | 0.4339 | 0.4341 | 968800.0 |
| 2002-02-07 18:00:00 | AAPL | Stock | 0.4363 | 0.4364 | 0.4363 | 0.4364 | 16800.0 |
| 2002-02-07 08:00:00 | MSFT | Stock | 30.2 | 30.35 | 30.05 | 30.275 | 136600.0 |
| 2002-02-07 09:00:00 | MSFT | Stock | 30.265 | 30.53 | 30.125 | 30.465 | 7304400.0 |
| 2002-02-07 10:00:00 | MSFT | Stock | 30.4695 | 30.745 | 30.045 | 30.4945 | 13550800.0 |
| 2002-02-07 11:00:00 | MSFT | Stock | 30.4945 | 30.805 | 30.455 | 30.65 | 9343600.0 |
| 2002-02-07 12:00:00 | MSFT | Stock | 30.655 | 30.76 | 30.4995 | 30.585 | 4614600.0 |
| 2002-02-07 13:00:00 | MSFT | Stock | 30.585 | 30.65 | 30.405 | 30.6145 | 5695800.0 |
| 2002-02-07 14:00:00 | MSFT | Stock | 30.615 | 30.63 | 30.3 | 30.36 | 6921000.0 |
| 2002-02-07 15:00:00 | MSFT | Stock | 30.3645 | 30.41 | 29.88 | 29.895 | 11017600.0 |
| 2002-02-07 16:00:00 | MSFT | Stock | 29.9 | 30.444 | 29.75 | 29.84 | 2288000.0 |
| 2002-02-07 17:00:00 | MSFT | Stock | 29.84 | 29.924 | 29.84 | 29.905 | 365000.0 |
| 2002-02-07 18:00:00 | MSFT | Stock | 29.935 | 29.95 | 29.925 | 29.925 | 5200.0 |
| 2002-02-07 08:00:00 | NVDA | Stock | 0.5125 | 0.5175 | 0.5125 | 0.5172 | 492000.0 |
| 2002-02-07 09:00:00 | NVDA | Stock | 0.5171 | 0.5213 | 0.5052 | 0.5069 | 162948000.0 |
| 2002-02-07 10:00:00 | NVDA | Stock | 0.5069 | 0.5112 | 0.4983 | 0.5075 | 243348000.0 |
| 2002-02-07 11:00:00 | NVDA | Stock | 0.5075 | 0.5175 | 0.5075 | 0.5154 | 171312000.0 |
| 2002-02-07 12:00:00 | NVDA | Stock | 0.5154 | 0.5167 | 0.5083 | 0.5096 | 55728000.0 |
| 2002-02-07 13:00:00 | NVDA | Stock | 0.5093 | 0.5167 | 0.5077 | 0.516 | 61776000.0 |
| 2002-02-07 14:00:00 | NVDA | Stock | 0.516 | 0.5165 | 0.5098 | 0.5099 | 64908000.0 |
| 2002-02-07 15:00:00 | NVDA | Stock | 0.5102 | 0.5117 | 0.4977 | 0.4998 | 160128000.0 |
| 2002-02-07 16:00:00 | NVDA | Stock | 0.4999 | 0.5093 | 0.4961 | 0.5001 | 30588000.0 |
| 2002-02-07 17:00:00 | NVDA | Stock | 0.4966 | 0.5001 | 0.4963 | 0.4992 | 936000.0 |
| 2002-02-07 18:00:00 | NVDA | Stock | 0.4975 | 0.4983 | 0.4964 | 0.4964 | 96000.0 |
| 2002-02-07 08:00:00 | AMZN | Stock | 0.53 | 0.575 | 0.525 | 0.56 | 124000.0 |
| 2002-02-07 09:00:00 | AMZN | Stock | 0.5615 | 0.564 | 0.553 | 0.562 | 19076000.0 |
| 2002-02-07 10:00:00 | AMZN | Stock | 0.5615 | 0.5825 | 0.5605 | 0.582 | 31832000.0 |
| 2002-02-07 11:00:00 | AMZN | Stock | 0.5825 | 0.5885 | 0.5715 | 0.5866 | 23400000.0 |
| 2002-02-07 12:00:00 | AMZN | Stock | 0.5865 | 0.5925 | 0.577 | 0.58 | 14800000.0 |
| 2002-02-07 13:00:00 | AMZN | Stock | 0.5796 | 0.5915 | 0.579 | 0.5915 | 10082000.0 |
| 2002-02-07 14:00:00 | AMZN | Stock | 0.592 | 0.5925 | 0.5835 | 0.5895 | 9700000.0 |
| 2002-02-07 15:00:00 | AMZN | Stock | 0.5895 | 0.59 | 0.5615 | 0.5615 | 19076000.0 |
| 2002-02-07 16:00:00 | AMZN | Stock | 0.5605 | 0.5793 | 0.5605 | 0.562 | 9980000.0 |
| 2002-02-07 17:00:00 | AMZN | Stock | 0.562 | 0.564 | 0.562 | 0.5625 | 152000.0 |
| 2002-02-07 18:00:00 | AMZN | Stock | 0.56 | 0.56 | 0.56 | 0.56 | 24000.0 |
| 2002-02-07 09:00:00 | CL | Stock | 27.625 | 27.625 | 27.51 | 27.58 | 490200.0 |
| 2002-02-07 10:00:00 | CL | Stock | 27.6 | 27.605 | 27.475 | 27.56 | 647200.0 |
| 2002-02-07 11:00:00 | CL | Stock | 27.57 | 27.605 | 27.35 | 27.375 | 1084400.0 |
| 2002-02-07 12:00:00 | CL | Stock | 27.36 | 27.365 | 27.085 | 27.24 | 1015200.0 |
| 2002-02-07 13:00:00 | CL | Stock | 27.24 | 27.25 | 27.14 | 27.23 | 861800.0 |
| 2002-02-07 14:00:00 | CL | Stock | 27.235 | 27.24 | 27.15 | 27.165 | 843000.0 |
> showing 50 of 17,962 rows — these rows as CSV