PREVIEW / stock_1hour / 2025-07-09
file: by_date/stock_1hour/2025/2025-07-09.parquet size: 1.4 MB rows: 62,067 symbols: 379
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-09 04:00:00 | AAPL | Stock | 210.05 | 210.15 | 209.9 | 210.01 | 2148.0 |
| 2025-07-09 05:00:00 | AAPL | Stock | 210.17 | 210.68 | 210.17 | 210.24 | 6038.0 |
| 2025-07-09 06:00:00 | AAPL | Stock | 210.25 | 210.3 | 209.87 | 209.91 | 11288.0 |
| 2025-07-09 07:00:00 | AAPL | Stock | 209.91 | 210.2 | 209.82 | 209.9 | 26773.0 |
| 2025-07-09 08:00:00 | AAPL | Stock | 209.94 | 210.61 | 208.95 | 209.3 | 178073.0 |
| 2025-07-09 09:00:00 | AAPL | Stock | 209.31 | 210.9 | 209.0 | 209.86 | 4485140.0 |
| 2025-07-09 10:00:00 | AAPL | Stock | 209.88 | 210.495 | 207.45 | 207.6481 | 5767707.0 |
| 2025-07-09 11:00:00 | AAPL | Stock | 207.64 | 207.9707 | 207.22 | 207.73 | 5005593.0 |
| 2025-07-09 12:00:00 | AAPL | Stock | 207.739 | 208.4401 | 207.539 | 208.21 | 3046138.0 |
| 2025-07-09 13:00:00 | AAPL | Stock | 208.21 | 209.3796 | 207.97 | 209.24 | 3053681.0 |
| 2025-07-09 14:00:00 | AAPL | Stock | 209.21 | 210.06 | 209.15 | 209.9361 | 2978891.0 |
| 2025-07-09 15:00:00 | AAPL | Stock | 209.94 | 211.33 | 209.6401 | 211.1 | 6440480.0 |
| 2025-07-09 16:00:00 | AAPL | Stock | 211.09 | 211.21 | 209.6317 | 210.7552 | 8076087.0 |
| 2025-07-09 17:00:00 | AAPL | Stock | 210.78 | 210.89 | 210.6001 | 210.8 | 29261.0 |
| 2025-07-09 18:00:00 | AAPL | Stock | 210.71 | 210.89 | 210.7 | 210.8 | 33574.0 |
| 2025-07-09 19:00:00 | AAPL | Stock | 210.75 | 210.87 | 210.71 | 210.72 | 24930.0 |
| 2025-07-09 04:00:00 | MSFT | Stock | 496.21 | 496.27 | 496.0 | 496.23 | 1037.0 |
| 2025-07-09 05:00:00 | MSFT | Stock | 496.8 | 497.55 | 496.8 | 497.55 | 719.0 |
| 2025-07-09 06:00:00 | MSFT | Stock | 497.43 | 503.0 | 497.43 | 501.49 | 38899.0 |
| 2025-07-09 07:00:00 | MSFT | Stock | 501.31 | 501.31 | 500.34 | 500.92 | 16324.0 |
| 2025-07-09 08:00:00 | MSFT | Stock | 500.85 | 501.4875 | 495.17 | 499.9512 | 36493.0 |
| 2025-07-09 09:00:00 | MSFT | Stock | 499.6 | 505.745 | 498.75 | 505.54 | 2498703.0 |
| 2025-07-09 10:00:00 | MSFT | Stock | 505.53 | 506.78 | 501.5625 | 502.03 | 2169922.0 |
| 2025-07-09 11:00:00 | MSFT | Stock | 502.01 | 502.245 | 500.0 | 500.03 | 1084492.0 |
| 2025-07-09 12:00:00 | MSFT | Stock | 500.01 | 501.28 | 499.74 | 500.5 | 815670.0 |
| 2025-07-09 13:00:00 | MSFT | Stock | 500.51 | 501.9512 | 500.0 | 501.66 | 659956.0 |
| 2025-07-09 14:00:00 | MSFT | Stock | 501.64 | 503.1 | 501.62 | 502.64 | 526922.0 |
| 2025-07-09 15:00:00 | MSFT | Stock | 502.62 | 503.65 | 502.16 | 503.48 | 1432519.0 |
| 2025-07-09 16:00:00 | MSFT | Stock | 503.51 | 503.52 | 502.8 | 503.0 | 2367307.0 |
| 2025-07-09 17:00:00 | MSFT | Stock | 503.0 | 503.0988 | 502.8 | 503.05 | 3308.0 |
| 2025-07-09 18:00:00 | MSFT | Stock | 503.05 | 503.45 | 503.01 | 503.01 | 8200.0 |
| 2025-07-09 19:00:00 | MSFT | Stock | 503.3 | 503.3 | 502.3826 | 503.04 | 2845.0 |
| 2025-07-09 04:00:00 | NVDA | Stock | 160.0 | 160.21 | 159.7 | 159.84 | 144843.0 |
| 2025-07-09 05:00:00 | NVDA | Stock | 159.87 | 160.33 | 159.82 | 160.17 | 126460.0 |
| 2025-07-09 06:00:00 | NVDA | Stock | 160.18 | 160.32 | 160.03 | 160.14 | 100758.0 |
| 2025-07-09 07:00:00 | NVDA | Stock | 160.15 | 160.73 | 160.15 | 160.68 | 277185.0 |
| 2025-07-09 08:00:00 | NVDA | Stock | 160.16 | 161.11 | 159.67 | 160.87 | 1557268.0 |
| 2025-07-09 09:00:00 | NVDA | Stock | 160.8795 | 164.42 | 160.85 | 164.14 | 35709236.0 |
| 2025-07-09 10:00:00 | NVDA | Stock | 164.14 | 164.32 | 162.44 | 163.12 | 28494841.0 |
| 2025-07-09 11:00:00 | NVDA | Stock | 163.11 | 163.45 | 162.82 | 163.23 | 15315401.0 |
| 2025-07-09 12:00:00 | NVDA | Stock | 163.23 | 163.38 | 162.9 | 163.105 | 11400708.0 |
| 2025-07-09 13:00:00 | NVDA | Stock | 163.105 | 163.37 | 162.49 | 162.71 | 12780806.0 |
| 2025-07-09 14:00:00 | NVDA | Stock | 162.7 | 163.0384 | 162.51 | 162.88 | 8605680.0 |
| 2025-07-09 15:00:00 | NVDA | Stock | 162.88 | 163.21 | 162.5701 | 162.83 | 15829290.0 |
| 2025-07-09 16:00:00 | NVDA | Stock | 162.88 | 163.1185 | 162.72 | 162.86 | 12258975.0 |
| 2025-07-09 17:00:00 | NVDA | Stock | 162.86 | 163.12 | 162.84 | 163.04 | 292269.0 |
| 2025-07-09 18:00:00 | NVDA | Stock | 163.04 | 163.3725 | 163.0111 | 163.35 | 319946.0 |
| 2025-07-09 19:00:00 | NVDA | Stock | 163.31 | 163.36 | 163.18 | 163.36 | 244594.0 |
| 2025-07-09 04:00:00 | AMZN | Stock | 219.62 | 220.0 | 219.62 | 219.98 | 8381.0 |
| 2025-07-09 05:00:00 | AMZN | Stock | 219.97 | 220.44 | 219.97 | 220.25 | 14667.0 |
> showing 50 of 62,067 rows — these rows as CSV