PREVIEW / stock_1hour / 2003-05-16
file: by_date/stock_1hour/2003/2003-05-16.parquet size: 449 KB rows: 21,541 symbols: 1,570
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 |
|---|---|---|---|---|---|---|---|
| 2003-05-16 08:00:00 | AAPL | Stock | 0.3329 | 0.3329 | 0.3271 | 0.3311 | 123200.0 |
| 2003-05-16 09:00:00 | AAPL | Stock | 0.3304 | 0.3345 | 0.3295 | 0.3304 | 35168784.0 |
| 2003-05-16 10:00:00 | AAPL | Stock | 0.3307 | 0.3307 | 0.3264 | 0.3295 | 45765496.0 |
| 2003-05-16 11:00:00 | AAPL | Stock | 0.3293 | 0.3318 | 0.3286 | 0.3309 | 47016760.0 |
| 2003-05-16 12:00:00 | AAPL | Stock | 0.3309 | 0.3345 | 0.3304 | 0.3336 | 26805632.0 |
| 2003-05-16 13:00:00 | AAPL | Stock | 0.3338 | 0.3348 | 0.3311 | 0.3346 | 19031320.0 |
| 2003-05-16 14:00:00 | AAPL | Stock | 0.3347 | 0.3364 | 0.3334 | 0.3348 | 25979352.0 |
| 2003-05-16 15:00:00 | AAPL | Stock | 0.3348 | 0.337 | 0.3348 | 0.3364 | 57122128.0 |
| 2003-05-16 16:00:00 | AAPL | Stock | 0.3366 | 0.3393 | 0.3279 | 0.3375 | 19778920.0 |
| 2003-05-16 17:00:00 | AAPL | Stock | 0.3375 | 0.3391 | 0.3354 | 0.3366 | 901600.0 |
| 2003-05-16 08:00:00 | MSFT | Stock | 25.6 | 25.82 | 25.595 | 25.69 | 27300.0 |
| 2003-05-16 09:00:00 | MSFT | Stock | 25.69 | 26.05 | 25.55 | 25.636 | 10131690.0 |
| 2003-05-16 10:00:00 | MSFT | Stock | 25.63 | 25.67 | 25.5 | 25.61 | 9899861.0 |
| 2003-05-16 11:00:00 | MSFT | Stock | 25.61 | 25.62 | 25.51 | 25.54 | 3634704.0 |
| 2003-05-16 12:00:00 | MSFT | Stock | 25.531 | 25.76 | 25.5 | 25.71 | 4262031.0 |
| 2003-05-16 13:00:00 | MSFT | Stock | 25.71 | 25.85 | 25.69 | 25.83 | 3688382.0 |
| 2003-05-16 14:00:00 | MSFT | Stock | 25.838 | 25.9 | 25.71 | 25.76 | 4530597.0 |
| 2003-05-16 15:00:00 | MSFT | Stock | 25.76 | 26.0 | 25.528 | 25.57 | 9305085.0 |
| 2003-05-16 16:00:00 | MSFT | Stock | 25.57 | 25.62 | 25.4 | 25.44 | 1452808.0 |
| 2003-05-16 17:00:00 | MSFT | Stock | 25.44 | 25.56 | 25.4 | 25.49 | 120733.0 |
| 2003-05-16 18:00:00 | MSFT | Stock | 25.468 | 25.49 | 25.46 | 25.47 | 26000.0 |
| 2003-05-16 08:00:00 | NVDA | Stock | 0.1746 | 0.1746 | 0.1727 | 0.1729 | 3037200.0 |
| 2003-05-16 09:00:00 | NVDA | Stock | 0.1733 | 0.1764 | 0.1727 | 0.1746 | 129551760.0 |
| 2003-05-16 10:00:00 | NVDA | Stock | 0.1746 | 0.1758 | 0.1736 | 0.1742 | 165186960.0 |
| 2003-05-16 11:00:00 | NVDA | Stock | 0.1742 | 0.1747 | 0.1737 | 0.1746 | 51233040.0 |
| 2003-05-16 12:00:00 | NVDA | Stock | 0.1747 | 0.1761 | 0.1743 | 0.1757 | 79165920.0 |
| 2003-05-16 13:00:00 | NVDA | Stock | 0.1756 | 0.1759 | 0.1745 | 0.1752 | 53671200.0 |
| 2003-05-16 14:00:00 | NVDA | Stock | 0.1752 | 0.1782 | 0.175 | 0.1775 | 122918520.0 |
| 2003-05-16 15:00:00 | NVDA | Stock | 0.1775 | 0.1779 | 0.1749 | 0.1751 | 190172040.0 |
| 2003-05-16 16:00:00 | NVDA | Stock | 0.1765 | 0.1802 | 0.1752 | 0.1762 | 20769600.0 |
| 2003-05-16 17:00:00 | NVDA | Stock | 0.1767 | 0.1802 | 0.1756 | 0.1757 | 4200000.0 |
| 2003-05-16 18:00:00 | NVDA | Stock | 0.1757 | 0.1758 | 0.1757 | 0.1758 | 1032000.0 |
| 2003-05-16 08:00:00 | AMZN | Stock | 1.6275 | 1.6276 | 1.62 | 1.621 | 78000.0 |
| 2003-05-16 09:00:00 | AMZN | Stock | 1.6305 | 1.6555 | 1.6215 | 1.6245 | 27895660.0 |
| 2003-05-16 10:00:00 | AMZN | Stock | 1.625 | 1.633 | 1.619 | 1.628 | 20218260.0 |
| 2003-05-16 11:00:00 | AMZN | Stock | 1.628 | 1.631 | 1.6255 | 1.6275 | 6012320.0 |
| 2003-05-16 12:00:00 | AMZN | Stock | 1.6275 | 1.64 | 1.626 | 1.6355 | 9175280.0 |
| 2003-05-16 13:00:00 | AMZN | Stock | 1.636 | 1.654 | 1.633 | 1.6524 | 12141660.0 |
| 2003-05-16 14:00:00 | AMZN | Stock | 1.6525 | 1.6545 | 1.644 | 1.6516 | 16135320.0 |
| 2003-05-16 15:00:00 | AMZN | Stock | 1.6515 | 1.6581 | 1.649 | 1.6515 | 32885380.0 |
| 2003-05-16 16:00:00 | AMZN | Stock | 1.6525 | 1.6595 | 1.6515 | 1.6525 | 1472220.0 |
| 2003-05-16 17:00:00 | AMZN | Stock | 1.655 | 1.658 | 1.6519 | 1.6525 | 294700.0 |
| 2003-05-16 09:00:00 | CL | Stock | 29.05 | 29.3 | 29.03 | 29.205 | 589400.0 |
| 2003-05-16 10:00:00 | CL | Stock | 29.2 | 29.265 | 29.1 | 29.25 | 469000.0 |
| 2003-05-16 11:00:00 | CL | Stock | 29.255 | 29.255 | 29.15 | 29.165 | 306200.0 |
| 2003-05-16 12:00:00 | CL | Stock | 29.16 | 29.265 | 29.12 | 29.265 | 320000.0 |
| 2003-05-16 13:00:00 | CL | Stock | 29.27 | 29.28 | 29.245 | 29.27 | 139000.0 |
| 2003-05-16 14:00:00 | CL | Stock | 29.27 | 29.3 | 29.245 | 29.27 | 192600.0 |
| 2003-05-16 15:00:00 | CL | Stock | 29.27 | 29.27 | 29.235 | 29.25 | 459000.0 |
| 2003-05-16 16:00:00 | CL | Stock | 29.25 | 29.285 | 29.245 | 29.285 | 138800.0 |
> showing 50 of 21,541 rows — these rows as CSV