PREVIEW / stock_1hour / 2009-09-29
file: by_date/stock_1hour/2009/2009-09-29.parquet size: 893 KB rows: 42,802 symbols: 3,413
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-29 07:00:00 | AAPL | Stock | 6.6568 | 6.6643 | 6.6446 | 6.6482 | 76720.0 |
| 2009-09-29 08:00:00 | AAPL | Stock | 6.6482 | 6.6643 | 6.6461 | 6.6461 | 707364.0 |
| 2009-09-29 09:00:00 | AAPL | Stock | 6.6504 | 6.6929 | 6.6407 | 6.6593 | 67388524.0 |
| 2009-09-29 10:00:00 | AAPL | Stock | 6.6561 | 6.6593 | 6.5893 | 6.5921 | 86918860.0 |
| 2009-09-29 11:00:00 | AAPL | Stock | 6.5907 | 6.6161 | 6.5825 | 6.5964 | 41922916.0 |
| 2009-09-29 12:00:00 | AAPL | Stock | 6.5965 | 6.6232 | 6.5918 | 6.6193 | 25114656.0 |
| 2009-09-29 13:00:00 | AAPL | Stock | 6.6196 | 6.6429 | 6.6107 | 6.6218 | 35480368.0 |
| 2009-09-29 14:00:00 | AAPL | Stock | 6.6218 | 6.6246 | 6.6096 | 6.6175 | 20837964.0 |
| 2009-09-29 15:00:00 | AAPL | Stock | 6.6179 | 6.6336 | 6.6036 | 6.6221 | 45723216.0 |
| 2009-09-29 16:00:00 | AAPL | Stock | 6.6218 | 6.6279 | 6.6166 | 6.6196 | 6500424.0 |
| 2009-09-29 17:00:00 | AAPL | Stock | 6.6243 | 6.6243 | 6.6096 | 6.6143 | 6843872.0 |
| 2009-09-29 18:00:00 | AAPL | Stock | 6.6204 | 6.6236 | 6.6179 | 6.6221 | 289632.0 |
| 2009-09-29 19:00:00 | AAPL | Stock | 6.6239 | 6.625 | 6.6189 | 6.6196 | 97076.0 |
| 2009-09-29 04:00:00 | MSFT | Stock | 25.68 | 25.68 | 25.68 | 25.68 | 400.0 |
| 2009-09-29 07:00:00 | MSFT | Stock | 25.9 | 25.9 | 25.8 | 25.85 | 1120.0 |
| 2009-09-29 08:00:00 | MSFT | Stock | 25.8 | 25.89 | 25.76 | 25.87 | 4290.0 |
| 2009-09-29 09:00:00 | MSFT | Stock | 25.88 | 25.96 | 25.78 | 25.92 | 4662909.0 |
| 2009-09-29 10:00:00 | MSFT | Stock | 25.92 | 25.95 | 25.7 | 25.759 | 7568737.0 |
| 2009-09-29 11:00:00 | MSFT | Stock | 25.75 | 25.78 | 25.72 | 25.72 | 4294064.0 |
| 2009-09-29 12:00:00 | MSFT | Stock | 25.72 | 25.83 | 25.72 | 25.8 | 2700376.0 |
| 2009-09-29 13:00:00 | MSFT | Stock | 25.8 | 25.83 | 25.74 | 25.751 | 3524402.0 |
| 2009-09-29 14:00:00 | MSFT | Stock | 25.752 | 25.82 | 25.74 | 25.77 | 3372018.0 |
| 2009-09-29 15:00:00 | MSFT | Stock | 25.77 | 25.79 | 25.69 | 25.76 | 6915423.0 |
| 2009-09-29 16:00:00 | MSFT | Stock | 25.76 | 25.788 | 25.679 | 25.75 | 1942672.0 |
| 2009-09-29 17:00:00 | MSFT | Stock | 25.75 | 25.75 | 25.68 | 25.71 | 32202.0 |
| 2009-09-29 18:00:00 | MSFT | Stock | 25.75 | 25.75 | 25.67 | 25.71 | 21793.0 |
| 2009-09-29 19:00:00 | MSFT | Stock | 25.7 | 25.7 | 25.7 | 25.7 | 148.0 |
| 2009-09-29 08:00:00 | NVDA | Stock | 0.3718 | 0.3738 | 0.3718 | 0.3738 | 60000.0 |
| 2009-09-29 09:00:00 | NVDA | Stock | 0.3738 | 0.3775 | 0.371 | 0.3748 | 47832600.0 |
| 2009-09-29 10:00:00 | NVDA | Stock | 0.3745 | 0.3745 | 0.367 | 0.3671 | 57552800.0 |
| 2009-09-29 11:00:00 | NVDA | Stock | 0.3672 | 0.368 | 0.3638 | 0.3648 | 39575720.0 |
| 2009-09-29 12:00:00 | NVDA | Stock | 0.3645 | 0.3675 | 0.364 | 0.3668 | 45256280.0 |
| 2009-09-29 13:00:00 | NVDA | Stock | 0.367 | 0.3682 | 0.3645 | 0.3655 | 74480360.0 |
| 2009-09-29 14:00:00 | NVDA | Stock | 0.3655 | 0.3655 | 0.364 | 0.3648 | 50802520.0 |
| 2009-09-29 15:00:00 | NVDA | Stock | 0.3648 | 0.366 | 0.3632 | 0.3638 | 136054360.0 |
| 2009-09-29 16:00:00 | NVDA | Stock | 0.3638 | 0.3678 | 0.3625 | 0.364 | 11025120.0 |
| 2009-09-29 17:00:00 | NVDA | Stock | 0.364 | 0.3642 | 0.364 | 0.3642 | 29720.0 |
| 2009-09-29 18:00:00 | NVDA | Stock | 0.365 | 0.3668 | 0.365 | 0.3668 | 80000.0 |
| 2009-09-29 08:00:00 | AMZN | Stock | 4.6 | 4.6005 | 4.6 | 4.6 | 26000.0 |
| 2009-09-29 09:00:00 | AMZN | Stock | 4.6 | 4.6165 | 4.569 | 4.578 | 10710860.0 |
| 2009-09-29 10:00:00 | AMZN | Stock | 4.578 | 4.585 | 4.505 | 4.5295 | 26162820.0 |
| 2009-09-29 11:00:00 | AMZN | Stock | 4.53 | 4.565 | 4.5165 | 4.5615 | 8353980.0 |
| 2009-09-29 12:00:00 | AMZN | Stock | 4.5615 | 4.595 | 4.549 | 4.583 | 8760260.0 |
| 2009-09-29 13:00:00 | AMZN | Stock | 4.583 | 4.6125 | 4.583 | 4.594 | 8435600.0 |
| 2009-09-29 14:00:00 | AMZN | Stock | 4.594 | 4.5965 | 4.5655 | 4.5865 | 7505040.0 |
| 2009-09-29 15:00:00 | AMZN | Stock | 4.5885 | 4.606 | 4.5795 | 4.586 | 13267200.0 |
| 2009-09-29 16:00:00 | AMZN | Stock | 4.591 | 4.595 | 4.5698 | 4.5885 | 2219720.0 |
| 2009-09-29 17:00:00 | AMZN | Stock | 4.5885 | 4.5885 | 4.5885 | 4.5885 | 2000.0 |
| 2009-09-29 19:00:00 | AMZN | Stock | 4.589 | 4.595 | 4.5885 | 4.595 | 26080.0 |
| 2009-09-29 08:00:00 | TLT | Stock | 98.63 | 98.65 | 98.41 | 98.41 | 8200.0 |
> showing 50 of 42,802 rows — these rows as CSV