PREVIEW / stock_1hour / 2025-09-05
file: by_date/stock_1hour/2025/2025-09-05.parquet size: 1.4 MB rows: 62,409 symbols: 316
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-09-05 04:00:00 | AAPL | Stock | 239.36 | 239.56 | 239.25 | 239.35 | 11457.0 |
| 2025-09-05 05:00:00 | AAPL | Stock | 239.38 | 239.48 | 239.25 | 239.43 | 7537.0 |
| 2025-09-05 06:00:00 | AAPL | Stock | 239.36 | 239.4 | 239.15 | 239.3 | 7302.0 |
| 2025-09-05 07:00:00 | AAPL | Stock | 239.3 | 239.45 | 239.15 | 239.27 | 20045.0 |
| 2025-09-05 08:00:00 | AAPL | Stock | 239.34 | 240.02 | 238.76 | 239.85 | 202123.0 |
| 2025-09-05 09:00:00 | AAPL | Stock | 239.85 | 240.66 | 239.18 | 240.0742 | 6802614.0 |
| 2025-09-05 10:00:00 | AAPL | Stock | 240.085 | 241.32 | 238.63 | 238.99 | 7421434.0 |
| 2025-09-05 11:00:00 | AAPL | Stock | 238.99 | 240.33 | 238.79 | 238.9946 | 4450127.0 |
| 2025-09-05 12:00:00 | AAPL | Stock | 238.99 | 239.72 | 238.4901 | 239.33 | 3143705.0 |
| 2025-09-05 13:00:00 | AAPL | Stock | 239.3 | 239.73 | 238.73 | 238.87 | 2425432.0 |
| 2025-09-05 14:00:00 | AAPL | Stock | 238.86 | 239.98 | 238.85 | 239.955 | 2660846.0 |
| 2025-09-05 15:00:00 | AAPL | Stock | 239.95 | 240.13 | 239.05 | 239.67 | 5812388.0 |
| 2025-09-05 16:00:00 | AAPL | Stock | 239.68 | 239.86 | 239.51 | 239.69 | 6559577.0 |
| 2025-09-05 17:00:00 | AAPL | Stock | 239.55 | 239.78 | 239.52 | 239.6001 | 17143.0 |
| 2025-09-05 18:00:00 | AAPL | Stock | 239.6 | 239.6 | 239.2 | 239.2 | 14934.0 |
| 2025-09-05 19:00:00 | AAPL | Stock | 239.21 | 239.38 | 239.01 | 239.23 | 14385.0 |
| 2025-09-05 04:00:00 | MSFT | Stock | 508.99 | 510.2 | 508.99 | 509.34 | 5078.0 |
| 2025-09-05 05:00:00 | MSFT | Stock | 509.7 | 509.76 | 509.24 | 509.76 | 886.0 |
| 2025-09-05 06:00:00 | MSFT | Stock | 509.55 | 509.64 | 509.55 | 509.6 | 535.0 |
| 2025-09-05 07:00:00 | MSFT | Stock | 509.04 | 509.04 | 508.7 | 508.7 | 2678.0 |
| 2025-09-05 08:00:00 | MSFT | Stock | 509.66 | 511.9 | 508.25 | 511.9 | 50323.0 |
| 2025-09-05 09:00:00 | MSFT | Stock | 511.71 | 512.3 | 499.91 | 502.465 | 3316545.0 |
| 2025-09-05 10:00:00 | MSFT | Stock | 502.4614 | 502.5256 | 495.06 | 495.31 | 2918476.0 |
| 2025-09-05 11:00:00 | MSFT | Stock | 495.32 | 497.74 | 494.5 | 496.31 | 2210354.0 |
| 2025-09-05 12:00:00 | MSFT | Stock | 496.3 | 497.2 | 494.0 | 495.15 | 1412045.0 |
| 2025-09-05 13:00:00 | MSFT | Stock | 495.12 | 495.315 | 493.35 | 493.515 | 1394563.0 |
| 2025-09-05 14:00:00 | MSFT | Stock | 493.54 | 494.74 | 492.37 | 493.13 | 2021771.0 |
| 2025-09-05 15:00:00 | MSFT | Stock | 493.16 | 495.29 | 492.37 | 495.0153 | 3588918.0 |
| 2025-09-05 16:00:00 | MSFT | Stock | 495.02 | 495.22 | 494.51 | 495.03 | 3225370.0 |
| 2025-09-05 17:00:00 | MSFT | Stock | 495.04 | 495.0984 | 494.8999 | 494.9 | 11782.0 |
| 2025-09-05 18:00:00 | MSFT | Stock | 494.87 | 495.0 | 494.65 | 494.9998 | 7853.0 |
| 2025-09-05 19:00:00 | MSFT | Stock | 495.0 | 495.25 | 494.86 | 495.25 | 5586.0 |
| 2025-09-05 04:00:00 | NVDA | Stock | 170.88 | 171.49 | 170.88 | 171.11 | 292518.0 |
| 2025-09-05 05:00:00 | NVDA | Stock | 171.14 | 171.14 | 170.57 | 170.77 | 256380.0 |
| 2025-09-05 06:00:00 | NVDA | Stock | 170.8 | 170.88 | 169.92 | 170.28 | 433954.0 |
| 2025-09-05 07:00:00 | NVDA | Stock | 170.3 | 170.32 | 169.77 | 169.79 | 517253.0 |
| 2025-09-05 08:00:00 | NVDA | Stock | 169.78 | 171.4401 | 168.3 | 168.7 | 4400788.0 |
| 2025-09-05 09:00:00 | NVDA | Stock | 168.7 | 169.77 | 165.99 | 167.6403 | 33178849.0 |
| 2025-09-05 10:00:00 | NVDA | Stock | 167.65 | 167.66 | 164.2248 | 164.575 | 44169794.0 |
| 2025-09-05 11:00:00 | NVDA | Stock | 164.56 | 166.925 | 164.07 | 166.4001 | 24780170.0 |
| 2025-09-05 12:00:00 | NVDA | Stock | 166.4 | 167.14 | 166.01 | 166.88 | 14228037.0 |
| 2025-09-05 13:00:00 | NVDA | Stock | 166.88 | 166.96 | 165.87 | 166.1228 | 11851831.0 |
| 2025-09-05 14:00:00 | NVDA | Stock | 166.12 | 166.91 | 165.94 | 166.34 | 10934265.0 |
| 2025-09-05 15:00:00 | NVDA | Stock | 166.335 | 167.195 | 166.12 | 167.04 | 20602118.0 |
| 2025-09-05 16:00:00 | NVDA | Stock | 167.03 | 167.05 | 166.6 | 166.8006 | 11919519.0 |
| 2025-09-05 17:00:00 | NVDA | Stock | 166.8018 | 167.0 | 166.6 | 166.6001 | 221462.0 |
| 2025-09-05 18:00:00 | NVDA | Stock | 166.6 | 166.64 | 166.5 | 166.54 | 171820.0 |
| 2025-09-05 19:00:00 | NVDA | Stock | 166.54 | 166.55 | 166.05 | 166.09 | 229134.0 |
| 2025-09-05 04:00:00 | AMZN | Stock | 235.82 | 235.82 | 235.2 | 235.29 | 18180.0 |
| 2025-09-05 05:00:00 | AMZN | Stock | 235.2 | 235.2 | 234.8 | 235.02 | 11998.0 |
> showing 50 of 62,409 rows — these rows as CSV