PREVIEW / stock_1hour / 2024-05-16
file: by_date/stock_1hour/2024/2024-05-16.parquet size: 1.4 MB rows: 59,289 symbols: 972
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-16 04:00:00 | AAPL | Stock | 190.12 | 190.58 | 190.12 | 190.28 | 11873.0 |
| 2024-05-16 05:00:00 | AAPL | Stock | 190.3 | 190.3 | 189.5 | 189.67 | 25419.0 |
| 2024-05-16 06:00:00 | AAPL | Stock | 189.69 | 189.95 | 189.68 | 189.95 | 38967.0 |
| 2024-05-16 07:00:00 | AAPL | Stock | 189.99 | 190.15 | 189.99 | 190.09 | 12776.0 |
| 2024-05-16 08:00:00 | AAPL | Stock | 189.95 | 190.76 | 189.9 | 190.0 | 124041.0 |
| 2024-05-16 09:00:00 | AAPL | Stock | 190.02 | 191.095 | 189.97 | 190.4999 | 6356747.0 |
| 2024-05-16 10:00:00 | AAPL | Stock | 190.5 | 190.78 | 190.03 | 190.335 | 5775924.0 |
| 2024-05-16 11:00:00 | AAPL | Stock | 190.34 | 190.59 | 189.725 | 190.0186 | 4961586.0 |
| 2024-05-16 12:00:00 | AAPL | Stock | 190.01 | 190.4881 | 189.82 | 190.329 | 3516072.0 |
| 2024-05-16 13:00:00 | AAPL | Stock | 190.32 | 190.45 | 189.89 | 190.19 | 2833645.0 |
| 2024-05-16 14:00:00 | AAPL | Stock | 190.185 | 190.1874 | 189.76 | 189.94 | 2939499.0 |
| 2024-05-16 15:00:00 | AAPL | Stock | 189.94 | 190.22 | 189.6601 | 189.91 | 6431973.0 |
| 2024-05-16 16:00:00 | AAPL | Stock | 189.92 | 189.92 | 189.71 | 189.74 | 8194468.0 |
| 2024-05-16 17:00:00 | AAPL | Stock | 189.74 | 189.84 | 189.72 | 189.78 | 11530.0 |
| 2024-05-16 18:00:00 | AAPL | Stock | 189.78 | 190.0 | 189.73 | 189.9378 | 21281.0 |
| 2024-05-16 19:00:00 | AAPL | Stock | 189.9 | 190.0 | 189.86 | 190.0 | 13617.0 |
| 2024-05-16 04:00:00 | MSFT | Stock | 423.83 | 424.0 | 423.5 | 424.0 | 2071.0 |
| 2024-05-16 05:00:00 | MSFT | Stock | 423.81 | 424.0 | 423.81 | 424.0 | 1155.0 |
| 2024-05-16 06:00:00 | MSFT | Stock | 424.0 | 424.06 | 423.92 | 424.0 | 3881.0 |
| 2024-05-16 07:00:00 | MSFT | Stock | 423.9 | 423.9 | 423.15 | 423.34 | 2938.0 |
| 2024-05-16 08:00:00 | MSFT | Stock | 423.9009 | 424.33 | 422.64 | 422.98 | 17784.0 |
| 2024-05-16 09:00:00 | MSFT | Stock | 423.08 | 425.42 | 421.6201 | 423.93 | 1310881.0 |
| 2024-05-16 10:00:00 | MSFT | Stock | 423.95 | 424.76 | 422.64 | 424.435 | 821212.0 |
| 2024-05-16 11:00:00 | MSFT | Stock | 424.49 | 424.81 | 422.75 | 422.97 | 1002560.0 |
| 2024-05-16 12:00:00 | MSFT | Stock | 422.94 | 422.965 | 422.02 | 422.59 | 693438.0 |
| 2024-05-16 13:00:00 | MSFT | Stock | 422.6 | 422.805 | 421.55 | 422.17 | 717280.0 |
| 2024-05-16 14:00:00 | MSFT | Stock | 422.175 | 422.335 | 421.4 | 422.22 | 751890.0 |
| 2024-05-16 15:00:00 | MSFT | Stock | 422.23 | 422.31 | 420.35 | 420.93 | 1921081.0 |
| 2024-05-16 16:00:00 | MSFT | Stock | 420.92 | 420.99 | 420.7 | 420.7 | 3218446.0 |
| 2024-05-16 17:00:00 | MSFT | Stock | 420.8006 | 420.99 | 420.8006 | 420.8096 | 5564.0 |
| 2024-05-16 18:00:00 | MSFT | Stock | 421.0 | 422.02 | 420.9201 | 421.4755 | 12170.0 |
| 2024-05-16 19:00:00 | MSFT | Stock | 421.78 | 421.79 | 421.61 | 421.79 | 1403.0 |
| 2024-05-16 04:00:00 | NVDA | Stock | 95.198 | 95.43 | 94.98 | 95.364 | 263270.0 |
| 2024-05-16 05:00:00 | NVDA | Stock | 95.389 | 95.5 | 94.955 | 95.0 | 173320.0 |
| 2024-05-16 06:00:00 | NVDA | Stock | 95.004 | 95.2 | 95.0 | 95.135 | 128430.0 |
| 2024-05-16 07:00:00 | NVDA | Stock | 95.175 | 95.399 | 95.021 | 95.31 | 565610.0 |
| 2024-05-16 08:00:00 | NVDA | Stock | 95.2 | 95.398 | 94.8 | 94.96 | 2088670.0 |
| 2024-05-16 09:00:00 | NVDA | Stock | 94.975 | 95.819 | 94.402 | 95.455 | 46790290.0 |
| 2024-05-16 10:00:00 | NVDA | Stock | 95.453 | 95.479 | 94.42 | 95.3705 | 41095120.0 |
| 2024-05-16 11:00:00 | NVDA | Stock | 95.379 | 95.632 | 95.203 | 95.294 | 21941180.0 |
| 2024-05-16 12:00:00 | NVDA | Stock | 95.292 | 95.2985 | 94.674 | 94.9841 | 25475490.0 |
| 2024-05-16 13:00:00 | NVDA | Stock | 94.98 | 95.046 | 94.103 | 94.56 | 24415500.0 |
| 2024-05-16 14:00:00 | NVDA | Stock | 94.5565 | 94.838 | 94.264 | 94.8145 | 17245360.0 |
| 2024-05-16 15:00:00 | NVDA | Stock | 94.825 | 95.172 | 94.282 | 94.371 | 29432080.0 |
| 2024-05-16 16:00:00 | NVDA | Stock | 94.359 | 94.45 | 94.063 | 94.063 | 15763210.0 |
| 2024-05-16 17:00:00 | NVDA | Stock | 94.062 | 94.1 | 94.017 | 94.03 | 432140.0 |
| 2024-05-16 18:00:00 | NVDA | Stock | 94.035 | 94.359 | 94.035 | 94.152 | 201630.0 |
| 2024-05-16 19:00:00 | NVDA | Stock | 94.151 | 94.167 | 94.075 | 94.079 | 341010.0 |
| 2024-05-16 04:00:00 | AMZN | Stock | 186.4 | 186.77 | 186.34 | 186.51 | 8220.0 |
| 2024-05-16 05:00:00 | AMZN | Stock | 186.5 | 186.5 | 186.38 | 186.4 | 4106.0 |
> showing 50 of 59,289 rows — these rows as CSV