PREVIEW / stock_1hour / 2025-05-27
file: by_date/stock_1hour/2025/2025-05-27.parquet size: 1.4 MB rows: 63,085 symbols: 411
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 |
|---|---|---|---|---|---|---|---|
| 2025-05-27 04:00:00 | AAPL | Stock | 198.02 | 199.67 | 197.92 | 199.09 | 55405.0 |
| 2025-05-27 05:00:00 | AAPL | Stock | 199.05 | 199.38 | 199.05 | 199.06 | 12927.0 |
| 2025-05-27 06:00:00 | AAPL | Stock | 199.04 | 199.2 | 198.6 | 198.71 | 28520.0 |
| 2025-05-27 07:00:00 | AAPL | Stock | 198.67 | 198.74 | 198.02 | 198.54 | 66741.0 |
| 2025-05-27 08:00:00 | AAPL | Stock | 198.14 | 199.2 | 197.3 | 198.47 | 244538.0 |
| 2025-05-27 09:00:00 | AAPL | Stock | 198.5394 | 199.17 | 197.43 | 198.0676 | 5750973.0 |
| 2025-05-27 10:00:00 | AAPL | Stock | 198.08 | 198.8799 | 197.93 | 198.155 | 5946707.0 |
| 2025-05-27 11:00:00 | AAPL | Stock | 198.17 | 200.093 | 198.105 | 200.07 | 5183195.0 |
| 2025-05-27 12:00:00 | AAPL | Stock | 200.07 | 200.65 | 199.89 | 200.04 | 4298680.0 |
| 2025-05-27 13:00:00 | AAPL | Stock | 200.045 | 200.55 | 199.67 | 200.5407 | 3234193.0 |
| 2025-05-27 14:00:00 | AAPL | Stock | 200.54 | 200.74 | 200.22 | 200.4638 | 3076368.0 |
| 2025-05-27 15:00:00 | AAPL | Stock | 200.45 | 200.55 | 199.93 | 200.19 | 6289135.0 |
| 2025-05-27 16:00:00 | AAPL | Stock | 200.18 | 200.46 | 200.1 | 200.2654 | 7770337.0 |
| 2025-05-27 17:00:00 | AAPL | Stock | 200.2395 | 200.459 | 200.2395 | 200.45 | 18543.0 |
| 2025-05-27 18:00:00 | AAPL | Stock | 200.43 | 200.47 | 200.32 | 200.3589 | 16103.0 |
| 2025-05-27 19:00:00 | AAPL | Stock | 200.36 | 200.45 | 200.32 | 200.4 | 29372.0 |
| 2025-05-27 04:00:00 | MSFT | Stock | 453.3 | 457.16 | 452.5 | 455.77 | 11014.0 |
| 2025-05-27 05:00:00 | MSFT | Stock | 455.93 | 456.31 | 454.67 | 454.85 | 4640.0 |
| 2025-05-27 06:00:00 | MSFT | Stock | 454.8 | 455.0 | 454.0 | 454.71 | 8465.0 |
| 2025-05-27 07:00:00 | MSFT | Stock | 454.21 | 456.37 | 454.0 | 456.13 | 18297.0 |
| 2025-05-27 08:00:00 | MSFT | Stock | 456.0 | 457.0 | 449.055 | 455.3206 | 24197.0 |
| 2025-05-27 09:00:00 | MSFT | Stock | 455.38 | 460.2 | 455.0 | 457.36 | 2021640.0 |
| 2025-05-27 10:00:00 | MSFT | Stock | 457.44 | 459.1 | 456.9801 | 457.12 | 1393761.0 |
| 2025-05-27 11:00:00 | MSFT | Stock | 457.115 | 458.52 | 457.02 | 458.36 | 991222.0 |
| 2025-05-27 12:00:00 | MSFT | Stock | 458.34 | 459.39 | 458.2 | 458.76 | 944283.0 |
| 2025-05-27 13:00:00 | MSFT | Stock | 458.77 | 459.37 | 458.4045 | 459.345 | 877682.0 |
| 2025-05-27 14:00:00 | MSFT | Stock | 459.32 | 459.9294 | 459.04 | 459.47 | 793106.0 |
| 2025-05-27 15:00:00 | MSFT | Stock | 459.46 | 460.95 | 459.19 | 460.71 | 2917095.0 |
| 2025-05-27 16:00:00 | MSFT | Stock | 460.69 | 460.69 | 459.06 | 460.0 | 3581892.0 |
| 2025-05-27 17:00:00 | MSFT | Stock | 460.2484 | 460.5 | 459.6414 | 460.0 | 4733.0 |
| 2025-05-27 18:00:00 | MSFT | Stock | 460.2 | 460.5 | 459.3518 | 460.0069 | 8467.0 |
| 2025-05-27 19:00:00 | MSFT | Stock | 460.4778 | 460.49 | 460.0056 | 460.4899 | 5521.0 |
| 2025-05-27 04:00:00 | NVDA | Stock | 135.0 | 135.05 | 134.5 | 134.59 | 601833.0 |
| 2025-05-27 05:00:00 | NVDA | Stock | 134.6 | 135.16 | 134.53 | 134.83 | 487633.0 |
| 2025-05-27 06:00:00 | NVDA | Stock | 134.83 | 135.0 | 134.73 | 134.76 | 231729.0 |
| 2025-05-27 07:00:00 | NVDA | Stock | 134.75 | 134.76 | 134.3 | 134.55 | 664349.0 |
| 2025-05-27 08:00:00 | NVDA | Stock | 134.56 | 135.1 | 133.71 | 134.6201 | 2143308.0 |
| 2025-05-27 09:00:00 | NVDA | Stock | 134.6201 | 135.0 | 133.31 | 134.46 | 28061566.0 |
| 2025-05-27 10:00:00 | NVDA | Stock | 134.4581 | 135.56 | 134.4 | 135.225 | 32056297.0 |
| 2025-05-27 11:00:00 | NVDA | Stock | 135.21 | 135.3999 | 134.84 | 135.06 | 17779255.0 |
| 2025-05-27 12:00:00 | NVDA | Stock | 135.065 | 135.66 | 135.0238 | 135.21 | 14472780.0 |
| 2025-05-27 13:00:00 | NVDA | Stock | 135.2 | 135.65 | 135.2 | 135.515 | 12041574.0 |
| 2025-05-27 14:00:00 | NVDA | Stock | 135.515 | 135.63 | 135.0316 | 135.3718 | 13452599.0 |
| 2025-05-27 15:00:00 | NVDA | Stock | 135.375 | 135.5 | 134.72 | 135.49 | 24564208.0 |
| 2025-05-27 16:00:00 | NVDA | Stock | 135.49 | 135.76 | 135.07 | 135.28 | 16824051.0 |
| 2025-05-27 17:00:00 | NVDA | Stock | 135.26 | 135.42 | 135.25 | 135.32 | 407718.0 |
| 2025-05-27 18:00:00 | NVDA | Stock | 135.31 | 135.4798 | 135.2 | 135.4798 | 337612.0 |
| 2025-05-27 19:00:00 | NVDA | Stock | 135.48 | 135.6 | 135.42 | 135.6 | 462817.0 |
| 2025-05-27 04:00:00 | AMZN | Stock | 204.55 | 205.23 | 204.55 | 204.73 | 27390.0 |
| 2025-05-27 05:00:00 | AMZN | Stock | 204.81 | 205.33 | 204.8 | 205.16 | 22240.0 |
> showing 50 of 63,085 rows — these rows as CSV