PREVIEW / stock_1hour / 2009-10-08
file: by_date/stock_1hour/2009/2009-10-08.parquet size: 887 KB rows: 42,291 symbols: 3,386
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-08 06:00:00 | AAPL | Stock | 6.8393 | 6.8446 | 6.8393 | 6.8446 | 8400.0 |
| 2009-10-08 07:00:00 | AAPL | Stock | 6.8446 | 6.85 | 6.8221 | 6.8304 | 171276.0 |
| 2009-10-08 08:00:00 | AAPL | Stock | 6.8304 | 6.8375 | 6.8125 | 6.8229 | 4502512.0 |
| 2009-10-08 09:00:00 | AAPL | Stock | 6.8218 | 6.8375 | 6.7893 | 6.8071 | 78634752.0 |
| 2009-10-08 10:00:00 | AAPL | Stock | 6.8068 | 6.8204 | 6.7864 | 6.8132 | 62153308.0 |
| 2009-10-08 11:00:00 | AAPL | Stock | 6.8129 | 6.8346 | 6.8046 | 6.8204 | 46927636.0 |
| 2009-10-08 12:00:00 | AAPL | Stock | 6.8202 | 6.8287 | 6.8118 | 6.8241 | 27188784.0 |
| 2009-10-08 13:00:00 | AAPL | Stock | 6.8232 | 6.8243 | 6.7746 | 6.8047 | 52843112.0 |
| 2009-10-08 14:00:00 | AAPL | Stock | 6.805 | 6.8136 | 6.7571 | 6.7789 | 58719836.0 |
| 2009-10-08 15:00:00 | AAPL | Stock | 6.7793 | 6.8082 | 6.7461 | 6.7589 | 86512552.0 |
| 2009-10-08 16:00:00 | AAPL | Stock | 6.7589 | 6.7981 | 6.7532 | 6.7671 | 18715256.0 |
| 2009-10-08 17:00:00 | AAPL | Stock | 6.7679 | 6.7721 | 6.7618 | 6.7679 | 356748.0 |
| 2009-10-08 18:00:00 | AAPL | Stock | 6.7679 | 6.7711 | 6.7596 | 6.7704 | 336700.0 |
| 2009-10-08 19:00:00 | AAPL | Stock | 6.7682 | 6.7696 | 6.7636 | 6.7639 | 304500.0 |
| 2009-10-08 20:00:00 | AAPL | Stock | 6.8129 | 6.8129 | 6.8129 | 6.8129 | 64400.0 |
| 2009-10-08 04:00:00 | MSFT | Stock | 25.26 | 25.4 | 25.26 | 25.4 | 700.0 |
| 2009-10-08 07:00:00 | MSFT | Stock | 25.35 | 25.35 | 25.3 | 25.35 | 1150.0 |
| 2009-10-08 08:00:00 | MSFT | Stock | 25.3 | 25.42 | 25.23 | 25.4 | 59166.0 |
| 2009-10-08 09:00:00 | MSFT | Stock | 25.38 | 25.49 | 25.22 | 25.465 | 7747041.0 |
| 2009-10-08 10:00:00 | MSFT | Stock | 25.461 | 25.73 | 25.4 | 25.67 | 11197731.0 |
| 2009-10-08 11:00:00 | MSFT | Stock | 25.67 | 25.88 | 25.67 | 25.81 | 7684146.0 |
| 2009-10-08 12:00:00 | MSFT | Stock | 25.81 | 25.86 | 25.73 | 25.815 | 7307948.0 |
| 2009-10-08 13:00:00 | MSFT | Stock | 25.81 | 25.9 | 25.8 | 25.89 | 5385753.0 |
| 2009-10-08 14:00:00 | MSFT | Stock | 25.88 | 25.89 | 25.71 | 25.81 | 3985149.0 |
| 2009-10-08 15:00:00 | MSFT | Stock | 25.819 | 25.86 | 25.67 | 25.67 | 8219578.0 |
| 2009-10-08 16:00:00 | MSFT | Stock | 25.66 | 25.786 | 25.66 | 25.68 | 6178192.0 |
| 2009-10-08 17:00:00 | MSFT | Stock | 25.09 | 25.675 | 25.09 | 25.675 | 1202.0 |
| 2009-10-08 18:00:00 | MSFT | Stock | 25.67 | 25.67 | 25.67 | 25.67 | 22018.0 |
| 2009-10-08 19:00:00 | MSFT | Stock | 25.68 | 25.68 | 25.67 | 25.68 | 1894.0 |
| 2009-10-08 20:00:00 | MSFT | Stock | 25.74 | 25.74 | 25.74 | 25.74 | 2700.0 |
| 2009-10-08 08:00:00 | NVDA | Stock | 0.3475 | 0.3508 | 0.3475 | 0.3495 | 472400.0 |
| 2009-10-08 09:00:00 | NVDA | Stock | 0.35 | 0.35 | 0.34 | 0.3402 | 106347080.0 |
| 2009-10-08 10:00:00 | NVDA | Stock | 0.3405 | 0.3425 | 0.3373 | 0.338 | 137891680.0 |
| 2009-10-08 11:00:00 | NVDA | Stock | 0.3378 | 0.3453 | 0.3373 | 0.3453 | 211856640.0 |
| 2009-10-08 12:00:00 | NVDA | Stock | 0.3451 | 0.3493 | 0.3435 | 0.349 | 241836560.0 |
| 2009-10-08 13:00:00 | NVDA | Stock | 0.3493 | 0.35 | 0.3475 | 0.3488 | 118756000.0 |
| 2009-10-08 14:00:00 | NVDA | Stock | 0.3487 | 0.3493 | 0.3475 | 0.3488 | 88469440.0 |
| 2009-10-08 15:00:00 | NVDA | Stock | 0.349 | 0.3505 | 0.3488 | 0.3498 | 306259560.0 |
| 2009-10-08 16:00:00 | NVDA | Stock | 0.3498 | 0.3508 | 0.3448 | 0.3498 | 28593000.0 |
| 2009-10-08 17:00:00 | NVDA | Stock | 0.3475 | 0.3475 | 0.3475 | 0.3475 | 12000.0 |
| 2009-10-08 18:00:00 | NVDA | Stock | 0.3493 | 0.3493 | 0.3482 | 0.3493 | 188000.0 |
| 2009-10-08 19:00:00 | NVDA | Stock | 0.3493 | 0.3502 | 0.349 | 0.3502 | 78040.0 |
| 2009-10-08 07:00:00 | AMZN | Stock | 4.757 | 4.7605 | 4.733 | 4.7375 | 59000.0 |
| 2009-10-08 08:00:00 | AMZN | Stock | 4.7345 | 4.7595 | 4.7295 | 4.74 | 619940.0 |
| 2009-10-08 09:00:00 | AMZN | Stock | 4.74 | 4.804 | 4.7115 | 4.775 | 32318360.0 |
| 2009-10-08 10:00:00 | AMZN | Stock | 4.775 | 4.804 | 4.75 | 4.7845 | 29124660.0 |
| 2009-10-08 11:00:00 | AMZN | Stock | 4.784 | 4.836 | 4.778 | 4.811 | 22312180.0 |
| 2009-10-08 12:00:00 | AMZN | Stock | 4.8108 | 4.8325 | 4.8025 | 4.8245 | 14301260.0 |
| 2009-10-08 13:00:00 | AMZN | Stock | 4.8245 | 4.826 | 4.78 | 4.7945 | 14829400.0 |
| 2009-10-08 14:00:00 | AMZN | Stock | 4.795 | 4.7995 | 4.757 | 4.781 | 19579380.0 |
> showing 50 of 42,291 rows — these rows as CSV