PREVIEW / stock_1hour / 2025-08-12
file: by_date/stock_1hour/2025/2025-08-12.parquet size: 1.4 MB rows: 63,520 symbols: 340
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-08-12 04:00:00 | AAPL | Stock | 226.27 | 226.68 | 226.01 | 226.02 | 9973.0 |
| 2025-08-12 05:00:00 | AAPL | Stock | 226.02 | 226.16 | 225.85 | 226.16 | 5156.0 |
| 2025-08-12 06:00:00 | AAPL | Stock | 226.0 | 226.1 | 225.91 | 226.01 | 11425.0 |
| 2025-08-12 07:00:00 | AAPL | Stock | 226.0 | 226.18 | 225.77 | 225.88 | 25749.0 |
| 2025-08-12 08:00:00 | AAPL | Stock | 225.98 | 228.47 | 225.8001 | 227.953 | 445492.0 |
| 2025-08-12 09:00:00 | AAPL | Stock | 227.98 | 229.9399 | 226.97 | 227.875 | 6355505.0 |
| 2025-08-12 10:00:00 | AAPL | Stock | 227.875 | 229.72 | 227.32 | 229.5003 | 5451793.0 |
| 2025-08-12 11:00:00 | AAPL | Stock | 229.5273 | 230.5865 | 228.32 | 229.7 | 6385353.0 |
| 2025-08-12 12:00:00 | AAPL | Stock | 229.71 | 230.8 | 229.45 | 230.39 | 3321190.0 |
| 2025-08-12 13:00:00 | AAPL | Stock | 230.4 | 230.71 | 229.52 | 229.945 | 2967036.0 |
| 2025-08-12 14:00:00 | AAPL | Stock | 229.9462 | 230.1097 | 229.01 | 229.2901 | 2427491.0 |
| 2025-08-12 15:00:00 | AAPL | Stock | 229.305 | 230.1 | 228.92 | 229.64 | 4984637.0 |
| 2025-08-12 16:00:00 | AAPL | Stock | 229.63 | 229.66 | 229.19 | 229.65 | 7352398.0 |
| 2025-08-12 17:00:00 | AAPL | Stock | 229.65 | 229.6791 | 229.43 | 229.502 | 21859.0 |
| 2025-08-12 18:00:00 | AAPL | Stock | 229.46 | 229.5428 | 229.3001 | 229.34 | 9880.0 |
| 2025-08-12 19:00:00 | AAPL | Stock | 229.31 | 229.65 | 229.3 | 229.65 | 24956.0 |
| 2025-08-12 04:00:00 | MSFT | Stock | 522.88 | 523.9 | 522.88 | 523.21 | 4492.0 |
| 2025-08-12 05:00:00 | MSFT | Stock | 523.46 | 523.5 | 523.46 | 523.5 | 226.0 |
| 2025-08-12 06:00:00 | MSFT | Stock | 523.21 | 523.21 | 522.4 | 522.49 | 1357.0 |
| 2025-08-12 07:00:00 | MSFT | Stock | 522.62 | 522.62 | 522.08 | 522.34 | 2811.0 |
| 2025-08-12 08:00:00 | MSFT | Stock | 522.54 | 524.95 | 521.8118 | 524.1 | 59551.0 |
| 2025-08-12 09:00:00 | MSFT | Stock | 524.3 | 527.59 | 523.64 | 524.73 | 1431530.0 |
| 2025-08-12 10:00:00 | MSFT | Stock | 524.6331 | 526.8698 | 522.7 | 525.0 | 1513700.0 |
| 2025-08-12 11:00:00 | MSFT | Stock | 525.01 | 527.27 | 524.7101 | 526.96 | 890609.0 |
| 2025-08-12 12:00:00 | MSFT | Stock | 526.945 | 528.772 | 526.27 | 528.28 | 917244.0 |
| 2025-08-12 13:00:00 | MSFT | Stock | 528.265 | 529.3 | 527.65 | 529.19 | 715660.0 |
| 2025-08-12 14:00:00 | MSFT | Stock | 529.19 | 530.98 | 529.1 | 529.71 | 1035041.0 |
| 2025-08-12 15:00:00 | MSFT | Stock | 529.71 | 530.8 | 528.87 | 529.46 | 1257211.0 |
| 2025-08-12 16:00:00 | MSFT | Stock | 529.24 | 529.9 | 527.2702 | 529.5004 | 3502279.0 |
| 2025-08-12 17:00:00 | MSFT | Stock | 529.87 | 529.87 | 529.346 | 529.4 | 3410.0 |
| 2025-08-12 18:00:00 | MSFT | Stock | 529.34 | 529.3966 | 529.14 | 529.25 | 4396.0 |
| 2025-08-12 19:00:00 | MSFT | Stock | 529.25 | 531.0 | 529.24 | 531.0 | 7497.0 |
| 2025-08-12 04:00:00 | NVDA | Stock | 181.84 | 181.95 | 181.23 | 181.38 | 203391.0 |
| 2025-08-12 05:00:00 | NVDA | Stock | 181.36 | 181.61 | 181.3 | 181.5 | 91307.0 |
| 2025-08-12 06:00:00 | NVDA | Stock | 181.5 | 182.97 | 181.25 | 182.08 | 502231.0 |
| 2025-08-12 07:00:00 | NVDA | Stock | 182.08 | 182.11 | 181.63 | 182.07 | 206064.0 |
| 2025-08-12 08:00:00 | NVDA | Stock | 182.08 | 183.8699 | 180.51 | 183.33 | 3260070.0 |
| 2025-08-12 09:00:00 | NVDA | Stock | 183.34 | 183.65 | 179.86 | 180.055 | 25867150.0 |
| 2025-08-12 10:00:00 | NVDA | Stock | 180.07 | 181.61 | 179.46 | 181.5445 | 21969062.0 |
| 2025-08-12 11:00:00 | NVDA | Stock | 181.54 | 182.75 | 181.41 | 182.4186 | 14025580.0 |
| 2025-08-12 12:00:00 | NVDA | Stock | 182.415 | 182.49 | 181.75 | 182.4284 | 8706895.0 |
| 2025-08-12 13:00:00 | NVDA | Stock | 182.425 | 182.86 | 182.175 | 182.8249 | 7803875.0 |
| 2025-08-12 14:00:00 | NVDA | Stock | 182.83 | 183.335 | 182.76 | 182.945 | 9589546.0 |
| 2025-08-12 15:00:00 | NVDA | Stock | 182.94 | 184.48 | 182.26 | 183.1 | 14527079.0 |
| 2025-08-12 16:00:00 | NVDA | Stock | 183.12 | 183.22 | 182.08 | 182.89 | 10630615.0 |
| 2025-08-12 17:00:00 | NVDA | Stock | 182.89 | 182.97 | 182.76 | 182.84 | 149842.0 |
| 2025-08-12 18:00:00 | NVDA | Stock | 182.84 | 182.85 | 182.77 | 182.78 | 70886.0 |
| 2025-08-12 19:00:00 | NVDA | Stock | 182.7707 | 182.94 | 182.75 | 182.93 | 132743.0 |
| 2025-08-12 04:00:00 | AMZN | Stock | 221.67 | 221.78 | 221.44 | 221.44 | 3779.0 |
| 2025-08-12 05:00:00 | AMZN | Stock | 221.38 | 221.5 | 221.3 | 221.46 | 2938.0 |
> showing 50 of 63,520 rows — these rows as CSV