PREVIEW / stock_1hour / 2002-01-10
file: by_date/stock_1hour/2002/2002-01-10.parquet size: 381 KB rows: 17,691 symbols: 1,359
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-01-10 08:00:00 | AAPL | Stock | 0.3839 | 0.3869 | 0.3777 | 0.3821 | 1752800.0 |
| 2002-01-10 09:00:00 | AAPL | Stock | 0.3818 | 0.3821 | 0.3741 | 0.3782 | 71254400.0 |
| 2002-01-10 10:00:00 | AAPL | Stock | 0.3784 | 0.382 | 0.3768 | 0.3796 | 44620800.0 |
| 2002-01-10 11:00:00 | AAPL | Stock | 0.3798 | 0.3834 | 0.3754 | 0.3768 | 41249600.0 |
| 2002-01-10 12:00:00 | AAPL | Stock | 0.3768 | 0.3779 | 0.3618 | 0.3639 | 84677600.0 |
| 2002-01-10 13:00:00 | AAPL | Stock | 0.3632 | 0.3745 | 0.3625 | 0.3714 | 63756000.0 |
| 2002-01-10 14:00:00 | AAPL | Stock | 0.3714 | 0.3768 | 0.3696 | 0.3766 | 48473600.0 |
| 2002-01-10 15:00:00 | AAPL | Stock | 0.3763 | 0.3798 | 0.3734 | 0.3791 | 73522400.0 |
| 2002-01-10 16:00:00 | AAPL | Stock | 0.3789 | 0.38 | 0.377 | 0.3791 | 6199200.0 |
| 2002-01-10 17:00:00 | AAPL | Stock | 0.3796 | 0.3796 | 0.3741 | 0.3741 | 588000.0 |
| 2002-01-10 18:00:00 | AAPL | Stock | 0.3791 | 0.3813 | 0.3791 | 0.3807 | 145600.0 |
| 2002-01-10 08:00:00 | MSFT | Stock | 34.3275 | 34.445 | 34.3 | 34.325 | 215600.0 |
| 2002-01-10 09:00:00 | MSFT | Stock | 34.325 | 34.39 | 34.065 | 34.3 | 6106600.0 |
| 2002-01-10 10:00:00 | MSFT | Stock | 34.325 | 34.555 | 34.1905 | 34.38 | 10823600.0 |
| 2002-01-10 11:00:00 | MSFT | Stock | 34.41 | 34.7055 | 34.335 | 34.6555 | 6564400.0 |
| 2002-01-10 12:00:00 | MSFT | Stock | 34.66 | 34.745 | 34.405 | 34.55 | 3958600.0 |
| 2002-01-10 13:00:00 | MSFT | Stock | 34.555 | 34.78 | 34.53 | 34.735 | 3966400.0 |
| 2002-01-10 14:00:00 | MSFT | Stock | 34.7395 | 34.9 | 34.69 | 34.8895 | 5188400.0 |
| 2002-01-10 15:00:00 | MSFT | Stock | 34.8845 | 34.89 | 34.53 | 34.645 | 9293400.0 |
| 2002-01-10 16:00:00 | MSFT | Stock | 34.655 | 34.785 | 34.521 | 34.675 | 1969200.0 |
| 2002-01-10 17:00:00 | MSFT | Stock | 34.69 | 34.69 | 34.64 | 34.64 | 6600.0 |
| 2002-01-10 18:00:00 | MSFT | Stock | 34.675 | 34.7 | 34.67 | 34.7 | 32400.0 |
| 2002-01-10 08:00:00 | NVDA | Stock | 0.5687 | 0.5702 | 0.5637 | 0.5667 | 1992000.0 |
| 2002-01-10 09:00:00 | NVDA | Stock | 0.5651 | 0.5667 | 0.5553 | 0.5621 | 132492000.0 |
| 2002-01-10 10:00:00 | NVDA | Stock | 0.562 | 0.5681 | 0.5569 | 0.5618 | 155736000.0 |
| 2002-01-10 11:00:00 | NVDA | Stock | 0.5618 | 0.5627 | 0.5572 | 0.5601 | 84756000.0 |
| 2002-01-10 12:00:00 | NVDA | Stock | 0.5601 | 0.5625 | 0.549 | 0.5528 | 117960000.0 |
| 2002-01-10 13:00:00 | NVDA | Stock | 0.5526 | 0.562 | 0.5506 | 0.5615 | 86208000.0 |
| 2002-01-10 14:00:00 | NVDA | Stock | 0.5617 | 0.5622 | 0.5527 | 0.5596 | 122652000.0 |
| 2002-01-10 15:00:00 | NVDA | Stock | 0.5596 | 0.5596 | 0.545 | 0.5495 | 234732000.0 |
| 2002-01-10 16:00:00 | NVDA | Stock | 0.5495 | 0.5563 | 0.5465 | 0.553 | 34872000.0 |
| 2002-01-10 17:00:00 | NVDA | Stock | 0.5519 | 0.553 | 0.5512 | 0.5529 | 180000.0 |
| 2002-01-10 18:00:00 | NVDA | Stock | 0.5529 | 0.5529 | 0.5529 | 0.5529 | 12000.0 |
| 2002-01-10 08:00:00 | AMZN | Stock | 0.575 | 0.585 | 0.5725 | 0.585 | 252000.0 |
| 2002-01-10 09:00:00 | AMZN | Stock | 0.585 | 0.5875 | 0.5555 | 0.5605 | 22694000.0 |
| 2002-01-10 10:00:00 | AMZN | Stock | 0.5605 | 0.565 | 0.55 | 0.553 | 23504000.0 |
| 2002-01-10 11:00:00 | AMZN | Stock | 0.553 | 0.559 | 0.5495 | 0.558 | 20548000.0 |
| 2002-01-10 12:00:00 | AMZN | Stock | 0.559 | 0.562 | 0.555 | 0.557 | 13206000.0 |
| 2002-01-10 13:00:00 | AMZN | Stock | 0.5565 | 0.569 | 0.5565 | 0.5678 | 12166000.0 |
| 2002-01-10 14:00:00 | AMZN | Stock | 0.568 | 0.5715 | 0.555 | 0.5605 | 22168000.0 |
| 2002-01-10 15:00:00 | AMZN | Stock | 0.5605 | 0.5625 | 0.5435 | 0.5525 | 34054000.0 |
| 2002-01-10 16:00:00 | AMZN | Stock | 0.552 | 0.556 | 0.5425 | 0.552 | 10430000.0 |
| 2002-01-10 17:00:00 | AMZN | Stock | 0.5525 | 0.556 | 0.5525 | 0.5555 | 86000.0 |
| 2002-01-10 18:00:00 | AMZN | Stock | 0.556 | 0.5575 | 0.5555 | 0.5575 | 66000.0 |
| 2002-01-10 09:00:00 | CL | Stock | 28.175 | 28.175 | 27.95 | 27.965 | 318400.0 |
| 2002-01-10 10:00:00 | CL | Stock | 27.975 | 28.04 | 27.9 | 27.925 | 471600.0 |
| 2002-01-10 11:00:00 | CL | Stock | 27.92 | 27.92 | 27.74 | 27.75 | 320200.0 |
| 2002-01-10 12:00:00 | CL | Stock | 27.75 | 27.825 | 27.715 | 27.775 | 219400.0 |
| 2002-01-10 13:00:00 | CL | Stock | 27.77 | 27.86 | 27.725 | 27.85 | 179000.0 |
| 2002-01-10 14:00:00 | CL | Stock | 27.83 | 27.85 | 27.69 | 27.775 | 389000.0 |
> showing 50 of 17,691 rows — these rows as CSV