PREVIEW / stock_1hour / 2009-10-14
file: by_date/stock_1hour/2009/2009-10-14.parquet size: 902 KB rows: 43,312 symbols: 3,403
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-10-14 04:00:00 | AAPL | Stock | 6.8168 | 6.8168 | 6.8168 | 6.8168 | 2800.0 |
| 2009-10-14 05:00:00 | AAPL | Stock | 6.8536 | 6.8536 | 6.8536 | 6.8536 | 2800.0 |
| 2009-10-14 06:00:00 | AAPL | Stock | 6.8479 | 6.8571 | 6.8479 | 6.8571 | 132244.0 |
| 2009-10-14 07:00:00 | AAPL | Stock | 6.8571 | 6.8646 | 6.8482 | 6.8643 | 930160.0 |
| 2009-10-14 08:00:00 | AAPL | Stock | 6.8639 | 6.9 | 6.8568 | 6.9 | 5211136.0 |
| 2009-10-14 09:00:00 | AAPL | Stock | 6.8964 | 6.9007 | 6.7939 | 6.8132 | 92914136.0 |
| 2009-10-14 10:00:00 | AAPL | Stock | 6.8129 | 6.8382 | 6.8057 | 6.8368 | 54419428.0 |
| 2009-10-14 11:00:00 | AAPL | Stock | 6.837 | 6.8486 | 6.8307 | 6.8311 | 36186388.0 |
| 2009-10-14 12:00:00 | AAPL | Stock | 6.8315 | 6.835 | 6.8225 | 6.83 | 28359632.0 |
| 2009-10-14 13:00:00 | AAPL | Stock | 6.829 | 6.8368 | 6.8214 | 6.8261 | 27178200.0 |
| 2009-10-14 14:00:00 | AAPL | Stock | 6.8261 | 6.8339 | 6.8039 | 6.8196 | 39465692.0 |
| 2009-10-14 15:00:00 | AAPL | Stock | 6.8193 | 6.8389 | 6.8157 | 6.8321 | 77886368.0 |
| 2009-10-14 16:00:00 | AAPL | Stock | 6.8325 | 6.8393 | 6.8293 | 6.835 | 11482128.0 |
| 2009-10-14 17:00:00 | AAPL | Stock | 6.7864 | 6.8411 | 6.7864 | 6.8389 | 441420.0 |
| 2009-10-14 18:00:00 | AAPL | Stock | 6.8386 | 6.84 | 6.8318 | 6.8375 | 164108.0 |
| 2009-10-14 19:00:00 | AAPL | Stock | 6.8386 | 6.8425 | 6.8386 | 6.8407 | 191604.0 |
| 2009-10-14 05:00:00 | MSFT | Stock | 26.2 | 26.2 | 26.2 | 26.2 | 160.0 |
| 2009-10-14 07:00:00 | MSFT | Stock | 26.25 | 26.25 | 26.2 | 26.2 | 1500.0 |
| 2009-10-14 08:00:00 | MSFT | Stock | 26.2 | 26.24 | 26.12 | 26.18 | 47098.0 |
| 2009-10-14 09:00:00 | MSFT | Stock | 26.19 | 26.29 | 25.81 | 26.042 | 6826666.0 |
| 2009-10-14 10:00:00 | MSFT | Stock | 26.04 | 26.08 | 25.9 | 26.0 | 6208948.0 |
| 2009-10-14 11:00:00 | MSFT | Stock | 25.99 | 26.07 | 25.97 | 25.99 | 3036554.0 |
| 2009-10-14 12:00:00 | MSFT | Stock | 25.99 | 26.0 | 25.87 | 25.9 | 4668474.0 |
| 2009-10-14 13:00:00 | MSFT | Stock | 25.9 | 25.95 | 25.82 | 25.842 | 4164011.0 |
| 2009-10-14 14:00:00 | MSFT | Stock | 25.85 | 25.9 | 25.82 | 25.863 | 4179212.0 |
| 2009-10-14 15:00:00 | MSFT | Stock | 25.87 | 26.0 | 25.86 | 25.97 | 9634735.0 |
| 2009-10-14 16:00:00 | MSFT | Stock | 25.97 | 26.0 | 25.941 | 26.0 | 5681777.0 |
| 2009-10-14 17:00:00 | MSFT | Stock | 25.96 | 26.0 | 25.92 | 25.92 | 44374.0 |
| 2009-10-14 18:00:00 | MSFT | Stock | 25.96 | 25.99 | 25.86 | 25.9 | 20203.0 |
| 2009-10-14 19:00:00 | MSFT | Stock | 25.9 | 26.01 | 25.9 | 26.01 | 10673.0 |
| 2009-10-14 07:00:00 | NVDA | Stock | 0.36 | 0.36 | 0.36 | 0.36 | 4000.0 |
| 2009-10-14 08:00:00 | NVDA | Stock | 0.3638 | 0.3638 | 0.3595 | 0.3612 | 2078480.0 |
| 2009-10-14 09:00:00 | NVDA | Stock | 0.3578 | 0.3625 | 0.3495 | 0.355 | 248844240.0 |
| 2009-10-14 10:00:00 | NVDA | Stock | 0.355 | 0.3555 | 0.3468 | 0.3473 | 229013960.0 |
| 2009-10-14 11:00:00 | NVDA | Stock | 0.3473 | 0.3533 | 0.347 | 0.35 | 149808320.0 |
| 2009-10-14 12:00:00 | NVDA | Stock | 0.35 | 0.3522 | 0.3478 | 0.349 | 68847680.0 |
| 2009-10-14 13:00:00 | NVDA | Stock | 0.3489 | 0.351 | 0.3485 | 0.349 | 60030400.0 |
| 2009-10-14 14:00:00 | NVDA | Stock | 0.349 | 0.3495 | 0.3475 | 0.3482 | 107315440.0 |
| 2009-10-14 15:00:00 | NVDA | Stock | 0.3482 | 0.3505 | 0.348 | 0.3482 | 179282720.0 |
| 2009-10-14 16:00:00 | NVDA | Stock | 0.3485 | 0.3514 | 0.348 | 0.3485 | 10099440.0 |
| 2009-10-14 17:00:00 | NVDA | Stock | 0.3485 | 0.3498 | 0.3482 | 0.3498 | 422400.0 |
| 2009-10-14 18:00:00 | NVDA | Stock | 0.3488 | 0.3518 | 0.3485 | 0.3513 | 1928000.0 |
| 2009-10-14 19:00:00 | NVDA | Stock | 0.3513 | 0.3518 | 0.3508 | 0.3518 | 388000.0 |
| 2009-10-14 05:00:00 | AMZN | Stock | 4.7925 | 4.7925 | 4.7925 | 4.7925 | 4000.0 |
| 2009-10-14 07:00:00 | AMZN | Stock | 4.782 | 4.782 | 4.782 | 4.782 | 4900.0 |
| 2009-10-14 08:00:00 | AMZN | Stock | 4.7915 | 4.7925 | 4.78 | 4.79 | 116000.0 |
| 2009-10-14 09:00:00 | AMZN | Stock | 4.7935 | 4.883 | 4.783 | 4.8535 | 23294300.0 |
| 2009-10-14 10:00:00 | AMZN | Stock | 4.8515 | 4.864 | 4.8375 | 4.855 | 16292420.0 |
| 2009-10-14 11:00:00 | AMZN | Stock | 4.857 | 4.8625 | 4.8295 | 4.8498 | 11571620.0 |
| 2009-10-14 12:00:00 | AMZN | Stock | 4.8498 | 4.8515 | 4.829 | 4.8515 | 7172140.0 |
> showing 50 of 43,312 rows — these rows as CSV