PREVIEW / stock_1hour / 2024-04-11
file: by_date/stock_1hour/2024/2024-04-11.parquet size: 1.3 MB rows: 58,743 symbols: 1,021
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 |
|---|---|---|---|---|---|---|---|
| 2024-04-11 04:00:00 | AAPL | Stock | 167.96 | 168.26 | 167.78 | 168.09 | 22027.0 |
| 2024-04-11 05:00:00 | AAPL | Stock | 168.01 | 168.36 | 167.92 | 168.08 | 16956.0 |
| 2024-04-11 06:00:00 | AAPL | Stock | 168.12 | 168.3 | 168.0 | 168.16 | 5148.0 |
| 2024-04-11 07:00:00 | AAPL | Stock | 168.09 | 168.25 | 167.78 | 167.83 | 32502.0 |
| 2024-04-11 08:00:00 | AAPL | Stock | 168.1008 | 168.88 | 167.7 | 168.52 | 307798.0 |
| 2024-04-11 09:00:00 | AAPL | Stock | 168.59 | 169.17 | 168.16 | 168.97 | 4826914.0 |
| 2024-04-11 10:00:00 | AAPL | Stock | 168.97 | 169.33 | 168.31 | 169.15 | 5457466.0 |
| 2024-04-11 11:00:00 | AAPL | Stock | 169.155 | 169.9403 | 168.945 | 169.9088 | 3913266.0 |
| 2024-04-11 12:00:00 | AAPL | Stock | 169.92 | 170.44 | 169.83 | 170.395 | 5152655.0 |
| 2024-04-11 13:00:00 | AAPL | Stock | 170.3916 | 173.25 | 170.3 | 173.02 | 12409983.0 |
| 2024-04-11 14:00:00 | AAPL | Stock | 173.02 | 174.5 | 172.94 | 173.57 | 12864263.0 |
| 2024-04-11 15:00:00 | AAPL | Stock | 173.565 | 175.46 | 173.55 | 175.04 | 18484686.0 |
| 2024-04-11 16:00:00 | AAPL | Stock | 175.04 | 175.47 | 174.68 | 174.85 | 11195379.0 |
| 2024-04-11 17:00:00 | AAPL | Stock | 174.8799 | 175.04 | 174.81 | 174.87 | 81853.0 |
| 2024-04-11 18:00:00 | AAPL | Stock | 174.86 | 175.0 | 174.86 | 174.9 | 61921.0 |
| 2024-04-11 19:00:00 | AAPL | Stock | 174.96 | 175.6 | 174.89 | 175.5999 | 108880.0 |
| 2024-04-11 04:00:00 | MSFT | Stock | 423.35 | 426.36 | 423.35 | 425.55 | 14505.0 |
| 2024-04-11 05:00:00 | MSFT | Stock | 425.35 | 426.65 | 425.27 | 426.03 | 8466.0 |
| 2024-04-11 06:00:00 | MSFT | Stock | 425.75 | 426.79 | 425.47 | 426.79 | 4267.0 |
| 2024-04-11 07:00:00 | MSFT | Stock | 426.05 | 426.23 | 424.0 | 424.58 | 31711.0 |
| 2024-04-11 08:00:00 | MSFT | Stock | 425.99 | 427.74 | 423.0 | 427.03 | 176228.0 |
| 2024-04-11 09:00:00 | MSFT | Stock | 427.05 | 427.5 | 424.03 | 424.415 | 1568474.0 |
| 2024-04-11 10:00:00 | MSFT | Stock | 424.425 | 424.64 | 422.36 | 423.88 | 1406202.0 |
| 2024-04-11 11:00:00 | MSFT | Stock | 423.9 | 426.05 | 423.71 | 425.965 | 961387.0 |
| 2024-04-11 12:00:00 | MSFT | Stock | 425.99 | 426.43 | 424.92 | 424.96 | 834115.0 |
| 2024-04-11 13:00:00 | MSFT | Stock | 424.99 | 428.22 | 424.61 | 428.08 | 1155870.0 |
| 2024-04-11 14:00:00 | MSFT | Stock | 428.12 | 429.37 | 428.0501 | 428.81 | 1117323.0 |
| 2024-04-11 15:00:00 | MSFT | Stock | 428.835 | 429.3 | 427.79 | 427.84 | 1543033.0 |
| 2024-04-11 16:00:00 | MSFT | Stock | 427.93 | 428.5864 | 427.3 | 427.92 | 2954139.0 |
| 2024-04-11 17:00:00 | MSFT | Stock | 427.86 | 427.86 | 427.16 | 427.7 | 7328.0 |
| 2024-04-11 18:00:00 | MSFT | Stock | 427.67 | 428.49 | 427.67 | 428.16 | 4408.0 |
| 2024-04-11 19:00:00 | MSFT | Stock | 428.35 | 428.37 | 427.71 | 427.71 | 5943.0 |
| 2024-04-11 04:00:00 | NVDA | Stock | 87.231 | 87.386 | 87.0 | 87.0 | 130650.0 |
| 2024-04-11 05:00:00 | NVDA | Stock | 87.0 | 87.2 | 86.6 | 86.84 | 40460.0 |
| 2024-04-11 06:00:00 | NVDA | Stock | 86.744 | 86.932 | 86.621 | 86.8 | 93200.0 |
| 2024-04-11 07:00:00 | NVDA | Stock | 86.752 | 86.823 | 86.56 | 86.611 | 574250.0 |
| 2024-04-11 08:00:00 | NVDA | Stock | 86.669 | 87.884 | 86.441 | 87.3 | 5286780.0 |
| 2024-04-11 09:00:00 | NVDA | Stock | 87.3541 | 88.496 | 86.926 | 88.052 | 47743270.0 |
| 2024-04-11 10:00:00 | NVDA | Stock | 88.054 | 88.864 | 87.313 | 88.6235 | 54369540.0 |
| 2024-04-11 11:00:00 | NVDA | Stock | 88.6235 | 89.0621 | 88.525 | 89.0621 | 33803380.0 |
| 2024-04-11 12:00:00 | NVDA | Stock | 89.0618 | 89.729 | 88.9 | 89.44 | 34227860.0 |
| 2024-04-11 13:00:00 | NVDA | Stock | 89.449 | 89.87 | 89.353 | 89.7926 | 29962330.0 |
| 2024-04-11 14:00:00 | NVDA | Stock | 89.794 | 90.24 | 89.6577 | 89.93 | 33505120.0 |
| 2024-04-11 15:00:00 | NVDA | Stock | 89.9379 | 90.739 | 89.76 | 90.587 | 43518790.0 |
| 2024-04-11 16:00:00 | NVDA | Stock | 90.616 | 90.7816 | 90.505 | 90.55 | 15932840.0 |
| 2024-04-11 17:00:00 | NVDA | Stock | 90.56 | 90.616 | 90.3362 | 90.48 | 686750.0 |
| 2024-04-11 18:00:00 | NVDA | Stock | 90.465 | 90.647 | 90.465 | 90.62 | 469450.0 |
| 2024-04-11 19:00:00 | NVDA | Stock | 90.649 | 90.846 | 90.62 | 90.74 | 835900.0 |
| 2024-04-11 04:00:00 | AMZN | Stock | 185.65 | 185.8 | 185.25 | 185.25 | 11283.0 |
| 2024-04-11 05:00:00 | AMZN | Stock | 185.13 | 185.13 | 184.65 | 184.94 | 10172.0 |
> showing 50 of 58,743 rows — these rows as CSV