PREVIEW / stock_1hour / 2024-05-17
file: by_date/stock_1hour/2024/2024-05-17.parquet size: 1.3 MB rows: 59,059 symbols: 964
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-05-17 04:00:00 | AAPL | Stock | 189.78 | 189.78 | 189.5 | 189.58 | 6310.0 |
| 2024-05-17 05:00:00 | AAPL | Stock | 189.65 | 189.75 | 189.63 | 189.75 | 1210.0 |
| 2024-05-17 06:00:00 | AAPL | Stock | 189.75 | 189.8 | 189.72 | 189.72 | 1189.0 |
| 2024-05-17 07:00:00 | AAPL | Stock | 189.74 | 189.91 | 189.7 | 189.82 | 11939.0 |
| 2024-05-17 08:00:00 | AAPL | Stock | 189.78 | 190.25 | 189.7077 | 189.9573 | 42075.0 |
| 2024-05-17 09:00:00 | AAPL | Stock | 189.94 | 190.81 | 189.18 | 190.4 | 6624211.0 |
| 2024-05-17 10:00:00 | AAPL | Stock | 190.4 | 190.52 | 189.83 | 189.965 | 3560126.0 |
| 2024-05-17 11:00:00 | AAPL | Stock | 189.98 | 189.98 | 189.4201 | 189.58 | 2681173.0 |
| 2024-05-17 12:00:00 | AAPL | Stock | 189.5787 | 189.99 | 189.5501 | 189.9489 | 2372654.0 |
| 2024-05-17 13:00:00 | AAPL | Stock | 189.95 | 189.95 | 189.58 | 189.81 | 1649527.0 |
| 2024-05-17 14:00:00 | AAPL | Stock | 189.8187 | 190.05 | 189.38 | 189.9738 | 2214346.0 |
| 2024-05-17 15:00:00 | AAPL | Stock | 189.9781 | 190.15 | 189.75 | 189.93 | 6740825.0 |
| 2024-05-17 16:00:00 | AAPL | Stock | 189.91 | 190.07 | 189.82 | 190.04 | 6231733.0 |
| 2024-05-17 17:00:00 | AAPL | Stock | 190.03 | 190.04 | 189.87 | 190.0 | 23356.0 |
| 2024-05-17 18:00:00 | AAPL | Stock | 190.0 | 190.0 | 189.99 | 190.0 | 2725.0 |
| 2024-05-17 19:00:00 | AAPL | Stock | 189.99 | 190.05 | 189.9 | 189.92 | 12470.0 |
| 2024-05-17 04:00:00 | MSFT | Stock | 422.0 | 422.17 | 421.0 | 421.83 | 6414.0 |
| 2024-05-17 05:00:00 | MSFT | Stock | 421.84 | 422.85 | 421.84 | 422.85 | 554.0 |
| 2024-05-17 06:00:00 | MSFT | Stock | 422.63 | 422.81 | 421.95 | 422.53 | 4527.0 |
| 2024-05-17 07:00:00 | MSFT | Stock | 422.51 | 422.81 | 422.49 | 422.81 | 2459.0 |
| 2024-05-17 08:00:00 | MSFT | Stock | 422.71 | 423.0 | 421.44 | 422.95 | 17853.0 |
| 2024-05-17 09:00:00 | MSFT | Stock | 422.6657 | 423.3 | 418.025 | 418.75 | 2364555.0 |
| 2024-05-17 10:00:00 | MSFT | Stock | 418.72 | 420.48 | 418.49 | 419.517 | 935634.0 |
| 2024-05-17 11:00:00 | MSFT | Stock | 419.5 | 419.72 | 418.405 | 419.66 | 588103.0 |
| 2024-05-17 12:00:00 | MSFT | Stock | 419.64 | 419.695 | 418.33 | 419.24 | 465694.0 |
| 2024-05-17 13:00:00 | MSFT | Stock | 419.24 | 419.62 | 418.87 | 419.45 | 344863.0 |
| 2024-05-17 14:00:00 | MSFT | Stock | 419.4799 | 419.98 | 418.12 | 419.8334 | 530943.0 |
| 2024-05-17 15:00:00 | MSFT | Stock | 419.84 | 420.42 | 419.45 | 420.24 | 1208230.0 |
| 2024-05-17 16:00:00 | MSFT | Stock | 420.21 | 420.24 | 419.96 | 420.01 | 2697197.0 |
| 2024-05-17 17:00:00 | MSFT | Stock | 420.0 | 420.09 | 419.9 | 419.95 | 14538.0 |
| 2024-05-17 18:00:00 | MSFT | Stock | 419.9267 | 419.97 | 419.9267 | 419.97 | 428.0 |
| 2024-05-17 19:00:00 | MSFT | Stock | 420.0 | 420.21 | 419.74 | 420.21 | 2341.0 |
| 2024-05-17 04:00:00 | NVDA | Stock | 94.326 | 94.326 | 93.777 | 94.145 | 57480.0 |
| 2024-05-17 05:00:00 | NVDA | Stock | 94.195 | 94.27 | 94.129 | 94.129 | 23710.0 |
| 2024-05-17 06:00:00 | NVDA | Stock | 94.11 | 94.15 | 93.732 | 93.894 | 128430.0 |
| 2024-05-17 07:00:00 | NVDA | Stock | 93.96 | 94.23 | 93.84 | 94.088 | 441500.0 |
| 2024-05-17 08:00:00 | NVDA | Stock | 93.943 | 94.894 | 93.83 | 94.868 | 1575080.0 |
| 2024-05-17 09:00:00 | NVDA | Stock | 94.8 | 94.8 | 93.351 | 93.757 | 40528700.0 |
| 2024-05-17 10:00:00 | NVDA | Stock | 93.769 | 94.115 | 92.9031 | 93.865 | 45847070.0 |
| 2024-05-17 11:00:00 | NVDA | Stock | 93.8732 | 93.89 | 93.1 | 93.457 | 27523190.0 |
| 2024-05-17 12:00:00 | NVDA | Stock | 93.447 | 93.545 | 93.0404 | 93.3266 | 17746310.0 |
| 2024-05-17 13:00:00 | NVDA | Stock | 93.326 | 93.456 | 93.018 | 93.05 | 15862200.0 |
| 2024-05-17 14:00:00 | NVDA | Stock | 93.0585 | 93.077 | 91.806 | 92.52 | 47121960.0 |
| 2024-05-17 15:00:00 | NVDA | Stock | 92.5176 | 92.823 | 92.303 | 92.494 | 36149400.0 |
| 2024-05-17 16:00:00 | NVDA | Stock | 92.496 | 92.544 | 92.333 | 92.54 | 15940010.0 |
| 2024-05-17 17:00:00 | NVDA | Stock | 92.545 | 92.556 | 92.4563 | 92.48 | 704790.0 |
| 2024-05-17 18:00:00 | NVDA | Stock | 92.4827 | 92.514 | 92.44 | 92.44 | 168860.0 |
| 2024-05-17 19:00:00 | NVDA | Stock | 92.452 | 92.58 | 92.419 | 92.576 | 236530.0 |
| 2024-05-17 04:00:00 | AMZN | Stock | 184.05 | 184.18 | 183.72 | 183.92 | 11828.0 |
| 2024-05-17 05:00:00 | AMZN | Stock | 183.99 | 184.2 | 183.99 | 184.0 | 4488.0 |
> showing 50 of 59,059 rows — these rows as CSV