PREVIEW / stock_1hour / 2025-07-07
file: by_date/stock_1hour/2025/2025-07-07.parquet size: 1.4 MB rows: 64,182 symbols: 380
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-07-07 04:00:00 | AAPL | Stock | 213.57 | 213.57 | 211.59 | 211.7 | 35636.0 |
| 2025-07-07 05:00:00 | AAPL | Stock | 211.75 | 212.12 | 211.42 | 212.1 | 15548.0 |
| 2025-07-07 06:00:00 | AAPL | Stock | 212.02 | 212.59 | 212.02 | 212.36 | 28975.0 |
| 2025-07-07 07:00:00 | AAPL | Stock | 212.42 | 212.64 | 212.29 | 212.6 | 18530.0 |
| 2025-07-07 08:00:00 | AAPL | Stock | 212.45 | 213.17 | 211.5172 | 212.36 | 142707.0 |
| 2025-07-07 09:00:00 | AAPL | Stock | 212.3636 | 216.23 | 211.91 | 212.94 | 7138314.0 |
| 2025-07-07 10:00:00 | AAPL | Stock | 212.93 | 213.12 | 211.6 | 212.11 | 4748406.0 |
| 2025-07-07 11:00:00 | AAPL | Stock | 212.115 | 212.6 | 211.53 | 211.75 | 2932619.0 |
| 2025-07-07 12:00:00 | AAPL | Stock | 211.74 | 212.22 | 209.9 | 210.635 | 4396088.0 |
| 2025-07-07 13:00:00 | AAPL | Stock | 210.635 | 210.795 | 209.52 | 210.05 | 3156499.0 |
| 2025-07-07 14:00:00 | AAPL | Stock | 210.06 | 210.21 | 208.8 | 209.7623 | 3487974.0 |
| 2025-07-07 15:00:00 | AAPL | Stock | 209.765 | 210.25 | 209.19 | 209.94 | 5155361.0 |
| 2025-07-07 16:00:00 | AAPL | Stock | 209.93 | 210.26 | 209.2538 | 209.46 | 6967998.0 |
| 2025-07-07 17:00:00 | AAPL | Stock | 209.5 | 209.95 | 208.95 | 209.14 | 134665.0 |
| 2025-07-07 18:00:00 | AAPL | Stock | 209.2 | 209.34 | 209.0 | 209.2 | 30615.0 |
| 2025-07-07 19:00:00 | AAPL | Stock | 209.25 | 209.36 | 208.8617 | 208.9822 | 75219.0 |
| 2025-07-07 04:00:00 | MSFT | Stock | 497.0 | 498.73 | 496.76 | 498.49 | 11151.0 |
| 2025-07-07 05:00:00 | MSFT | Stock | 498.6 | 499.32 | 498.54 | 499.09 | 2651.0 |
| 2025-07-07 06:00:00 | MSFT | Stock | 499.69 | 499.94 | 499.4 | 499.7 | 2280.0 |
| 2025-07-07 07:00:00 | MSFT | Stock | 499.7 | 499.74 | 499.23 | 499.45 | 5635.0 |
| 2025-07-07 08:00:00 | MSFT | Stock | 499.73 | 500.0 | 496.29 | 498.68 | 26770.0 |
| 2025-07-07 09:00:00 | MSFT | Stock | 498.75 | 498.75 | 496.12 | 497.85 | 1078398.0 |
| 2025-07-07 10:00:00 | MSFT | Stock | 497.82 | 498.125 | 495.96 | 497.35 | 906628.0 |
| 2025-07-07 11:00:00 | MSFT | Stock | 497.34 | 498.59 | 497.34 | 498.095 | 569837.0 |
| 2025-07-07 12:00:00 | MSFT | Stock | 498.13 | 498.75 | 496.4512 | 497.02 | 706696.0 |
| 2025-07-07 13:00:00 | MSFT | Stock | 496.965 | 497.625 | 495.81 | 496.49 | 524014.0 |
| 2025-07-07 14:00:00 | MSFT | Stock | 496.46 | 497.1199 | 495.225 | 497.08 | 712555.0 |
| 2025-07-07 15:00:00 | MSFT | Stock | 497.07 | 497.97 | 496.425 | 497.83 | 1137601.0 |
| 2025-07-07 16:00:00 | MSFT | Stock | 497.83 | 498.3 | 497.0 | 497.47 | 3024364.0 |
| 2025-07-07 17:00:00 | MSFT | Stock | 497.6944 | 497.72 | 497.15 | 497.15 | 13913.0 |
| 2025-07-07 18:00:00 | MSFT | Stock | 497.24 | 497.64 | 496.1 | 497.2 | 2577.0 |
| 2025-07-07 19:00:00 | MSFT | Stock | 497.5 | 497.52 | 497.42 | 497.52 | 2065.0 |
| 2025-07-07 04:00:00 | NVDA | Stock | 158.4 | 159.34 | 157.51 | 157.61 | 408306.0 |
| 2025-07-07 05:00:00 | NVDA | Stock | 157.6 | 158.36 | 157.54 | 158.33 | 166912.0 |
| 2025-07-07 06:00:00 | NVDA | Stock | 158.34 | 158.56 | 158.15 | 158.2 | 218611.0 |
| 2025-07-07 07:00:00 | NVDA | Stock | 158.21 | 158.41 | 157.89 | 158.27 | 294878.0 |
| 2025-07-07 08:00:00 | NVDA | Stock | 158.11 | 159.0 | 157.54 | 157.86 | 1438063.0 |
| 2025-07-07 09:00:00 | NVDA | Stock | 157.8501 | 159.31 | 157.78 | 158.5 | 19700095.0 |
| 2025-07-07 10:00:00 | NVDA | Stock | 158.485 | 158.84 | 157.342 | 157.71 | 18578833.0 |
| 2025-07-07 11:00:00 | NVDA | Stock | 157.7 | 158.34 | 157.515 | 158.235 | 14046280.0 |
| 2025-07-07 12:00:00 | NVDA | Stock | 158.23 | 158.7 | 157.69 | 158.185 | 12807213.0 |
| 2025-07-07 13:00:00 | NVDA | Stock | 158.18 | 158.78 | 158.14 | 158.2852 | 8538853.0 |
| 2025-07-07 14:00:00 | NVDA | Stock | 158.285 | 158.63 | 157.73 | 158.4303 | 10706376.0 |
| 2025-07-07 15:00:00 | NVDA | Stock | 158.435 | 158.67 | 158.08 | 158.25 | 13412953.0 |
| 2025-07-07 16:00:00 | NVDA | Stock | 158.25 | 158.5 | 157.96 | 157.9857 | 11218184.0 |
| 2025-07-07 17:00:00 | NVDA | Stock | 158.0 | 158.24 | 157.86 | 157.97 | 176325.0 |
| 2025-07-07 18:00:00 | NVDA | Stock | 157.97 | 158.05 | 157.86 | 157.98 | 93963.0 |
| 2025-07-07 19:00:00 | NVDA | Stock | 157.98 | 158.2 | 157.96 | 158.0101 | 216198.0 |
| 2025-07-07 04:00:00 | AMZN | Stock | 223.02 | 223.21 | 222.34 | 222.75 | 29364.0 |
| 2025-07-07 05:00:00 | AMZN | Stock | 222.68 | 223.0 | 222.5 | 222.97 | 10630.0 |
> showing 50 of 64,182 rows — these rows as CSV