PREVIEW / stock_1hour / 2009-05-22
file: by_date/stock_1hour/2009/2009-05-22.parquet size: 815 KB rows: 40,087 symbols: 3,321
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-05-22 04:00:00 | AAPL | Stock | 4.4496 | 4.4529 | 4.4496 | 4.4529 | 5600.0 |
| 2009-05-22 06:00:00 | AAPL | Stock | 4.4768 | 4.4871 | 4.4768 | 4.4871 | 8400.0 |
| 2009-05-22 07:00:00 | AAPL | Stock | 4.4714 | 4.4732 | 4.4286 | 4.4571 | 68040.0 |
| 2009-05-22 08:00:00 | AAPL | Stock | 4.4525 | 4.4543 | 4.4464 | 4.4536 | 632492.0 |
| 2009-05-22 09:00:00 | AAPL | Stock | 4.4539 | 4.4539 | 4.3482 | 4.3846 | 62968192.0 |
| 2009-05-22 10:00:00 | AAPL | Stock | 4.3846 | 4.4107 | 4.3643 | 4.3967 | 61505360.0 |
| 2009-05-22 11:00:00 | AAPL | Stock | 4.3968 | 4.4143 | 4.3811 | 4.3904 | 30703064.0 |
| 2009-05-22 12:00:00 | AAPL | Stock | 4.3893 | 4.4029 | 4.3807 | 4.3932 | 23915304.0 |
| 2009-05-22 13:00:00 | AAPL | Stock | 4.3932 | 4.4004 | 4.3764 | 4.3893 | 19903296.0 |
| 2009-05-22 14:00:00 | AAPL | Stock | 4.3889 | 4.4161 | 4.3843 | 4.4139 | 24007928.0 |
| 2009-05-22 15:00:00 | AAPL | Stock | 4.4136 | 4.4246 | 4.375 | 4.375 | 52274012.0 |
| 2009-05-22 16:00:00 | AAPL | Stock | 4.375 | 4.3937 | 4.3686 | 4.3754 | 7060900.0 |
| 2009-05-22 17:00:00 | AAPL | Stock | 4.375 | 4.375 | 4.3679 | 4.3679 | 172648.0 |
| 2009-05-22 18:00:00 | AAPL | Stock | 4.3736 | 4.375 | 4.3736 | 4.375 | 25200.0 |
| 2009-05-22 19:00:00 | AAPL | Stock | 4.3732 | 4.375 | 4.3732 | 4.3743 | 63280.0 |
| 2009-05-22 07:00:00 | MSFT | Stock | 19.95 | 20.0 | 19.95 | 19.99 | 2700.0 |
| 2009-05-22 08:00:00 | MSFT | Stock | 19.99 | 20.0 | 19.92 | 19.97 | 20305.0 |
| 2009-05-22 09:00:00 | MSFT | Stock | 19.95 | 19.95 | 19.47 | 19.61 | 5493080.0 |
| 2009-05-22 10:00:00 | MSFT | Stock | 19.62 | 19.77 | 19.53 | 19.69 | 5528530.0 |
| 2009-05-22 11:00:00 | MSFT | Stock | 19.693 | 19.85 | 19.65 | 19.74 | 4646046.0 |
| 2009-05-22 12:00:00 | MSFT | Stock | 19.74 | 19.95 | 19.739 | 19.94 | 2922485.0 |
| 2009-05-22 13:00:00 | MSFT | Stock | 19.94 | 20.0 | 19.91 | 19.98 | 3568885.0 |
| 2009-05-22 14:00:00 | MSFT | Stock | 19.99 | 20.14 | 19.94 | 20.122 | 4880586.0 |
| 2009-05-22 15:00:00 | MSFT | Stock | 20.13 | 20.17 | 19.76 | 19.76 | 8613241.0 |
| 2009-05-22 16:00:00 | MSFT | Stock | 19.76 | 19.838 | 19.708 | 19.75 | 1239752.0 |
| 2009-05-22 17:00:00 | MSFT | Stock | 19.78 | 19.82 | 19.75 | 19.78 | 3400.0 |
| 2009-05-22 18:00:00 | MSFT | Stock | 19.77 | 19.8 | 19.77 | 19.8 | 3550.0 |
| 2009-05-22 19:00:00 | MSFT | Stock | 19.81 | 19.84 | 19.8 | 19.84 | 3630.0 |
| 2009-05-22 08:00:00 | NVDA | Stock | 0.2425 | 0.2513 | 0.2422 | 0.245 | 1044000.0 |
| 2009-05-22 09:00:00 | NVDA | Stock | 0.2453 | 0.2462 | 0.2372 | 0.2406 | 78448720.0 |
| 2009-05-22 10:00:00 | NVDA | Stock | 0.2408 | 0.246 | 0.2392 | 0.2458 | 120862720.0 |
| 2009-05-22 11:00:00 | NVDA | Stock | 0.246 | 0.249 | 0.2448 | 0.2462 | 117730600.0 |
| 2009-05-22 12:00:00 | NVDA | Stock | 0.2465 | 0.2475 | 0.245 | 0.2465 | 66522160.0 |
| 2009-05-22 13:00:00 | NVDA | Stock | 0.2467 | 0.2473 | 0.2448 | 0.2465 | 94532360.0 |
| 2009-05-22 14:00:00 | NVDA | Stock | 0.2465 | 0.2482 | 0.2455 | 0.248 | 88492200.0 |
| 2009-05-22 15:00:00 | NVDA | Stock | 0.248 | 0.2488 | 0.2453 | 0.2455 | 135513720.0 |
| 2009-05-22 16:00:00 | NVDA | Stock | 0.2455 | 0.2468 | 0.244 | 0.2462 | 7825320.0 |
| 2009-05-22 17:00:00 | NVDA | Stock | 0.2448 | 0.245 | 0.2448 | 0.245 | 112000.0 |
| 2009-05-22 18:00:00 | NVDA | Stock | 0.2453 | 0.2453 | 0.2453 | 0.2453 | 8480.0 |
| 2009-05-22 19:00:00 | NVDA | Stock | 0.245 | 0.245 | 0.245 | 0.245 | 8000.0 |
| 2009-05-22 07:00:00 | AMZN | Stock | 3.8525 | 3.8525 | 3.8525 | 3.8525 | 6000.0 |
| 2009-05-22 09:00:00 | AMZN | Stock | 3.845 | 3.845 | 3.751 | 3.779 | 10898960.0 |
| 2009-05-22 10:00:00 | AMZN | Stock | 3.7795 | 3.8215 | 3.7725 | 3.815 | 16172540.0 |
| 2009-05-22 11:00:00 | AMZN | Stock | 3.8145 | 3.852 | 3.8055 | 3.812 | 10379880.0 |
| 2009-05-22 12:00:00 | AMZN | Stock | 3.813 | 3.8375 | 3.8015 | 3.8355 | 5436120.0 |
| 2009-05-22 13:00:00 | AMZN | Stock | 3.8355 | 3.843 | 3.798 | 3.813 | 7183680.0 |
| 2009-05-22 14:00:00 | AMZN | Stock | 3.8135 | 3.83 | 3.807 | 3.83 | 5431360.0 |
| 2009-05-22 15:00:00 | AMZN | Stock | 3.8285 | 3.835 | 3.7805 | 3.782 | 10012120.0 |
| 2009-05-22 16:00:00 | AMZN | Stock | 3.782 | 3.8487 | 3.77 | 3.782 | 1641960.0 |
| 2009-05-22 17:00:00 | AMZN | Stock | 3.7765 | 3.7775 | 3.77 | 3.77 | 39440.0 |
> showing 50 of 40,087 rows — these rows as CSV