PREVIEW / stock_1hour / 2009-12-03
file: by_date/stock_1hour/2009/2009-12-03.parquet size: 894 KB rows: 42,616 symbols: 3,423
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-12-03 04:00:00 | AAPL | Stock | 7.0664 | 7.085 | 7.0664 | 7.085 | 17920.0 |
| 2009-12-03 05:00:00 | AAPL | Stock | 7.0714 | 7.0836 | 7.0696 | 7.0832 | 57260.0 |
| 2009-12-03 06:00:00 | AAPL | Stock | 7.0725 | 7.0725 | 7.0582 | 7.0582 | 19656.0 |
| 2009-12-03 07:00:00 | AAPL | Stock | 7.0454 | 7.0732 | 7.0454 | 7.0575 | 237076.0 |
| 2009-12-03 08:00:00 | AAPL | Stock | 7.06 | 7.0718 | 7.0393 | 7.0414 | 3054632.0 |
| 2009-12-03 09:00:00 | AAPL | Stock | 7.0411 | 7.085 | 7.0393 | 7.0729 | 71306508.0 |
| 2009-12-03 10:00:00 | AAPL | Stock | 7.0718 | 7.0746 | 7.0096 | 7.0596 | 98992124.0 |
| 2009-12-03 11:00:00 | AAPL | Stock | 7.06 | 7.0714 | 7.0357 | 7.0483 | 38691772.0 |
| 2009-12-03 12:00:00 | AAPL | Stock | 7.0482 | 7.0971 | 7.0343 | 7.0917 | 49496972.0 |
| 2009-12-03 13:00:00 | AAPL | Stock | 7.0914 | 7.1064 | 7.0718 | 7.0996 | 42558068.0 |
| 2009-12-03 14:00:00 | AAPL | Stock | 7.0993 | 7.1039 | 7.0729 | 7.087 | 40218304.0 |
| 2009-12-03 15:00:00 | AAPL | Stock | 7.0864 | 7.0982 | 7.0179 | 7.0179 | 84350924.0 |
| 2009-12-03 16:00:00 | AAPL | Stock | 7.0179 | 7.0602 | 6.9893 | 6.9893 | 8712536.0 |
| 2009-12-03 17:00:00 | AAPL | Stock | 6.9929 | 6.9975 | 6.9732 | 6.9746 | 1546440.0 |
| 2009-12-03 18:00:00 | AAPL | Stock | 6.9743 | 7.0171 | 6.9732 | 6.9825 | 419440.0 |
| 2009-12-03 19:00:00 | AAPL | Stock | 6.9875 | 6.9893 | 6.9821 | 6.9864 | 384552.0 |
| 2009-12-03 07:00:00 | MSFT | Stock | 29.87 | 29.87 | 29.84 | 29.84 | 1180.0 |
| 2009-12-03 08:00:00 | MSFT | Stock | 29.85 | 29.9 | 29.85 | 29.86 | 16144.0 |
| 2009-12-03 09:00:00 | MSFT | Stock | 29.89 | 30.2 | 29.76 | 30.08 | 7864517.0 |
| 2009-12-03 10:00:00 | MSFT | Stock | 30.08 | 30.1 | 29.91 | 30.02 | 9561033.0 |
| 2009-12-03 11:00:00 | MSFT | Stock | 30.019 | 30.03 | 29.91 | 29.98 | 4032752.0 |
| 2009-12-03 12:00:00 | MSFT | Stock | 29.98 | 30.03 | 29.95 | 29.985 | 3014551.0 |
| 2009-12-03 13:00:00 | MSFT | Stock | 29.98 | 30.03 | 29.95 | 30.0 | 2324833.0 |
| 2009-12-03 14:00:00 | MSFT | Stock | 29.995 | 30.05 | 29.97 | 30.03 | 3242704.0 |
| 2009-12-03 15:00:00 | MSFT | Stock | 30.032 | 30.08 | 29.81 | 29.83 | 10633385.0 |
| 2009-12-03 16:00:00 | MSFT | Stock | 29.83 | 30.003 | 29.67 | 29.7 | 1258867.0 |
| 2009-12-03 17:00:00 | MSFT | Stock | 29.7 | 29.75 | 29.67 | 29.7 | 4884.0 |
| 2009-12-03 18:00:00 | MSFT | Stock | 29.71 | 29.8 | 29.71 | 29.8 | 600.0 |
| 2009-12-03 19:00:00 | MSFT | Stock | 29.81 | 29.81 | 29.8 | 29.8 | 725.0 |
| 2009-12-03 08:00:00 | NVDA | Stock | 0.3425 | 0.3475 | 0.3425 | 0.3448 | 535000.0 |
| 2009-12-03 09:00:00 | NVDA | Stock | 0.3462 | 0.3525 | 0.3462 | 0.3518 | 115320080.0 |
| 2009-12-03 10:00:00 | NVDA | Stock | 0.3515 | 0.352 | 0.3468 | 0.351 | 144477760.0 |
| 2009-12-03 11:00:00 | NVDA | Stock | 0.3513 | 0.3533 | 0.351 | 0.3518 | 101176000.0 |
| 2009-12-03 12:00:00 | NVDA | Stock | 0.3517 | 0.3518 | 0.3498 | 0.3515 | 43178960.0 |
| 2009-12-03 13:00:00 | NVDA | Stock | 0.3515 | 0.3526 | 0.3508 | 0.3522 | 56388080.0 |
| 2009-12-03 14:00:00 | NVDA | Stock | 0.352 | 0.3533 | 0.351 | 0.3513 | 85807120.0 |
| 2009-12-03 15:00:00 | NVDA | Stock | 0.3513 | 0.3515 | 0.3453 | 0.3458 | 94786960.0 |
| 2009-12-03 16:00:00 | NVDA | Stock | 0.3458 | 0.3504 | 0.344 | 0.3455 | 4126920.0 |
| 2009-12-03 17:00:00 | NVDA | Stock | 0.343 | 0.3455 | 0.3425 | 0.3455 | 303920.0 |
| 2009-12-03 18:00:00 | NVDA | Stock | 0.3455 | 0.3455 | 0.3455 | 0.3455 | 16000.0 |
| 2009-12-03 04:00:00 | AMZN | Stock | 7.157 | 7.167 | 7.157 | 7.167 | 22000.0 |
| 2009-12-03 06:00:00 | AMZN | Stock | 7.1725 | 7.1725 | 7.17 | 7.17 | 22740.0 |
| 2009-12-03 07:00:00 | AMZN | Stock | 7.175 | 7.1925 | 7.175 | 7.1925 | 57680.0 |
| 2009-12-03 08:00:00 | AMZN | Stock | 7.194 | 7.234 | 7.191 | 7.2035 | 2387500.0 |
| 2009-12-03 09:00:00 | AMZN | Stock | 7.2085 | 7.2785 | 7.161 | 7.265 | 58016520.0 |
| 2009-12-03 10:00:00 | AMZN | Stock | 7.263 | 7.2955 | 7.2295 | 7.28 | 66705220.0 |
| 2009-12-03 11:00:00 | AMZN | Stock | 7.279 | 7.2805 | 7.2375 | 7.24 | 24676400.0 |
| 2009-12-03 12:00:00 | AMZN | Stock | 7.239 | 7.25 | 7.1885 | 7.1975 | 34391840.0 |
| 2009-12-03 13:00:00 | AMZN | Stock | 7.1975 | 7.203 | 7.1255 | 7.1305 | 41317200.0 |
| 2009-12-03 14:00:00 | AMZN | Stock | 7.132 | 7.2362 | 7.088 | 7.116 | 39674300.0 |
> showing 50 of 42,616 rows — these rows as CSV