PREVIEW / stock_1hour / 2025-08-08
file: by_date/stock_1hour/2025/2025-08-08.parquet size: 1.4 MB rows: 62,103 symbols: 352
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-08 04:00:00 | AAPL | Stock | 221.38 | 221.5 | 220.94 | 220.96 | 34587.0 |
| 2025-08-08 05:00:00 | AAPL | Stock | 220.9 | 221.17 | 220.8 | 221.0 | 13671.0 |
| 2025-08-08 06:00:00 | AAPL | Stock | 221.05 | 221.05 | 220.89 | 220.99 | 6887.0 |
| 2025-08-08 07:00:00 | AAPL | Stock | 220.99 | 221.47 | 220.98 | 221.36 | 55631.0 |
| 2025-08-08 08:00:00 | AAPL | Stock | 221.16 | 221.89 | 220.8 | 221.02 | 266308.0 |
| 2025-08-08 09:00:00 | AAPL | Stock | 221.02 | 222.2998 | 219.25 | 222.175 | 6704149.0 |
| 2025-08-08 10:00:00 | AAPL | Stock | 222.19 | 223.57 | 221.82 | 222.955 | 10049440.0 |
| 2025-08-08 11:00:00 | AAPL | Stock | 222.94 | 226.3299 | 222.9 | 225.99 | 10685784.0 |
| 2025-08-08 12:00:00 | AAPL | Stock | 226.0006 | 230.56 | 225.89 | 229.79 | 21626976.0 |
| 2025-08-08 13:00:00 | AAPL | Stock | 229.7846 | 230.93 | 228.55 | 230.25 | 13077638.0 |
| 2025-08-08 14:00:00 | AAPL | Stock | 230.245 | 231.0 | 229.07 | 229.11 | 8035685.0 |
| 2025-08-08 15:00:00 | AAPL | Stock | 229.12 | 229.69 | 228.46 | 229.365 | 12234312.0 |
| 2025-08-08 16:00:00 | AAPL | Stock | 229.35 | 229.99 | 229.2302 | 229.98 | 6505651.0 |
| 2025-08-08 17:00:00 | AAPL | Stock | 229.99 | 230.07 | 229.85 | 229.9 | 115455.0 |
| 2025-08-08 18:00:00 | AAPL | Stock | 229.9 | 229.94 | 229.55 | 229.7303 | 53746.0 |
| 2025-08-08 19:00:00 | AAPL | Stock | 229.67 | 230.0 | 229.5799 | 229.9578 | 75943.0 |
| 2025-08-08 04:00:00 | MSFT | Stock | 522.78 | 522.78 | 521.02 | 521.5 | 4427.0 |
| 2025-08-08 05:00:00 | MSFT | Stock | 521.6 | 522.59 | 521.6 | 522.54 | 2501.0 |
| 2025-08-08 06:00:00 | MSFT | Stock | 522.5 | 522.58 | 522.5 | 522.58 | 900.0 |
| 2025-08-08 07:00:00 | MSFT | Stock | 522.5 | 522.61 | 522.2 | 522.2 | 3424.0 |
| 2025-08-08 08:00:00 | MSFT | Stock | 522.92 | 522.92 | 520.04 | 520.65 | 37597.0 |
| 2025-08-08 09:00:00 | MSFT | Stock | 520.85 | 524.66 | 520.8 | 523.245 | 1128819.0 |
| 2025-08-08 10:00:00 | MSFT | Stock | 523.195 | 523.5 | 520.8 | 520.9092 | 1200727.0 |
| 2025-08-08 11:00:00 | MSFT | Stock | 520.9 | 521.82 | 519.41 | 521.31 | 1279151.0 |
| 2025-08-08 12:00:00 | MSFT | Stock | 521.29 | 521.89 | 520.94 | 521.63 | 625072.0 |
| 2025-08-08 13:00:00 | MSFT | Stock | 521.625 | 522.8794 | 521.17 | 522.68 | 826150.0 |
| 2025-08-08 14:00:00 | MSFT | Stock | 522.7 | 523.25 | 522.3214 | 522.6 | 826848.0 |
| 2025-08-08 15:00:00 | MSFT | Stock | 522.6 | 522.69 | 520.13 | 522.12 | 2042862.0 |
| 2025-08-08 16:00:00 | MSFT | Stock | 522.04 | 522.9 | 521.9 | 522.61 | 2247157.0 |
| 2025-08-08 17:00:00 | MSFT | Stock | 522.45 | 522.9 | 522.45 | 522.87 | 8168.0 |
| 2025-08-08 18:00:00 | MSFT | Stock | 522.5526 | 522.95 | 522.5 | 522.9 | 5738.0 |
| 2025-08-08 19:00:00 | MSFT | Stock | 522.73 | 523.0 | 522.7 | 523.0 | 2808.0 |
| 2025-08-08 04:00:00 | NVDA | Stock | 181.62 | 182.16 | 181.61 | 182.14 | 153706.0 |
| 2025-08-08 05:00:00 | NVDA | Stock | 182.14 | 182.2 | 181.98 | 182.11 | 95068.0 |
| 2025-08-08 06:00:00 | NVDA | Stock | 182.11 | 182.25 | 181.8 | 181.83 | 113990.0 |
| 2025-08-08 07:00:00 | NVDA | Stock | 181.86 | 182.17 | 181.85 | 182.12 | 210763.0 |
| 2025-08-08 08:00:00 | NVDA | Stock | 182.11 | 182.2 | 181.33 | 181.75 | 1185272.0 |
| 2025-08-08 09:00:00 | NVDA | Stock | 181.75 | 182.77 | 180.4 | 182.1 | 17030820.0 |
| 2025-08-08 10:00:00 | NVDA | Stock | 182.11 | 182.65 | 181.5347 | 182.385 | 16096221.0 |
| 2025-08-08 11:00:00 | NVDA | Stock | 182.38 | 183.3 | 182.25 | 183.1586 | 16124145.0 |
| 2025-08-08 12:00:00 | NVDA | Stock | 183.15 | 183.29 | 182.15 | 182.255 | 9709445.0 |
| 2025-08-08 13:00:00 | NVDA | Stock | 182.255 | 182.61 | 181.61 | 182.53 | 10699505.0 |
| 2025-08-08 14:00:00 | NVDA | Stock | 182.53 | 183.06 | 182.36 | 182.8818 | 8438532.0 |
| 2025-08-08 15:00:00 | NVDA | Stock | 182.88 | 183.06 | 182.165 | 182.75 | 13187977.0 |
| 2025-08-08 16:00:00 | NVDA | Stock | 182.77 | 182.799 | 182.5499 | 182.7392 | 8203189.0 |
| 2025-08-08 17:00:00 | NVDA | Stock | 182.7 | 182.75 | 182.63 | 182.6911 | 157324.0 |
| 2025-08-08 18:00:00 | NVDA | Stock | 182.7 | 183.2 | 182.68 | 182.7999 | 403292.0 |
| 2025-08-08 19:00:00 | NVDA | Stock | 182.8 | 183.05 | 182.7197 | 182.8306 | 207647.0 |
| 2025-08-08 04:00:00 | AMZN | Stock | 223.96 | 223.96 | 223.73 | 223.89 | 6436.0 |
| 2025-08-08 05:00:00 | AMZN | Stock | 223.9 | 224.01 | 223.9 | 223.95 | 6377.0 |
> showing 50 of 62,103 rows — these rows as CSV