PREVIEW / stock_1hour / 2025-07-08
file: by_date/stock_1hour/2025/2025-07-08.parquet size: 1.4 MB rows: 62,304 symbols: 373
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-08 04:00:00 | AAPL | Stock | 210.35 | 210.49 | 209.9 | 210.44 | 22688.0 |
| 2025-07-08 05:00:00 | AAPL | Stock | 210.44 | 210.44 | 210.03 | 210.03 | 8863.0 |
| 2025-07-08 06:00:00 | AAPL | Stock | 210.03 | 210.03 | 209.63 | 209.85 | 11250.0 |
| 2025-07-08 07:00:00 | AAPL | Stock | 209.95 | 210.13 | 209.8 | 210.05 | 16732.0 |
| 2025-07-08 08:00:00 | AAPL | Stock | 210.07 | 210.6 | 209.64 | 210.1988 | 151114.0 |
| 2025-07-08 09:00:00 | AAPL | Stock | 210.2 | 210.49 | 208.48 | 208.66 | 4588668.0 |
| 2025-07-08 10:00:00 | AAPL | Stock | 208.645 | 210.83 | 208.45 | 210.725 | 4709029.0 |
| 2025-07-08 11:00:00 | AAPL | Stock | 210.73 | 211.43 | 209.78 | 210.55 | 3855184.0 |
| 2025-07-08 12:00:00 | AAPL | Stock | 210.56 | 211.185 | 210.2603 | 210.38 | 2592242.0 |
| 2025-07-08 13:00:00 | AAPL | Stock | 210.37 | 210.435 | 209.32 | 209.85 | 2627481.0 |
| 2025-07-08 14:00:00 | AAPL | Stock | 209.81 | 210.26 | 209.56 | 209.7 | 1790721.0 |
| 2025-07-08 15:00:00 | AAPL | Stock | 209.7 | 210.81 | 209.3 | 210.035 | 4564880.0 |
| 2025-07-08 16:00:00 | AAPL | Stock | 210.01 | 210.2 | 208.8 | 210.04 | 5827460.0 |
| 2025-07-08 17:00:00 | AAPL | Stock | 209.8964 | 210.09 | 209.82 | 210.0 | 21156.0 |
| 2025-07-08 18:00:00 | AAPL | Stock | 209.9725 | 210.15 | 209.9725 | 210.15 | 11711.0 |
| 2025-07-08 19:00:00 | AAPL | Stock | 210.14 | 210.2917 | 210.02 | 210.1606 | 27678.0 |
| 2025-07-08 04:00:00 | MSFT | Stock | 498.8 | 498.8 | 498.05 | 498.05 | 1415.0 |
| 2025-07-08 05:00:00 | MSFT | Stock | 497.9 | 498.02 | 497.68 | 497.68 | 914.0 |
| 2025-07-08 06:00:00 | MSFT | Stock | 497.25 | 497.25 | 497.25 | 497.25 | 500.0 |
| 2025-07-08 07:00:00 | MSFT | Stock | 497.76 | 498.15 | 497.58 | 498.15 | 1632.0 |
| 2025-07-08 08:00:00 | MSFT | Stock | 497.9 | 499.0 | 496.476 | 497.631 | 11636.0 |
| 2025-07-08 09:00:00 | MSFT | Stock | 498.12 | 498.3 | 496.36 | 496.47 | 854493.0 |
| 2025-07-08 10:00:00 | MSFT | Stock | 496.55 | 497.14 | 494.54 | 495.14 | 810223.0 |
| 2025-07-08 11:00:00 | MSFT | Stock | 495.16 | 496.0 | 494.11 | 495.29 | 778154.0 |
| 2025-07-08 12:00:00 | MSFT | Stock | 495.295 | 496.25 | 494.69 | 495.6 | 404627.0 |
| 2025-07-08 13:00:00 | MSFT | Stock | 495.5701 | 496.65 | 495.18 | 496.59 | 405631.0 |
| 2025-07-08 14:00:00 | MSFT | Stock | 496.54 | 496.63 | 495.64 | 496.1368 | 376739.0 |
| 2025-07-08 15:00:00 | MSFT | Stock | 496.12 | 496.9 | 495.605 | 496.66 | 994724.0 |
| 2025-07-08 16:00:00 | MSFT | Stock | 496.62 | 496.9 | 496.62 | 496.65 | 2503766.0 |
| 2025-07-08 17:00:00 | MSFT | Stock | 496.94 | 496.99 | 496.93 | 496.981 | 2782.0 |
| 2025-07-08 18:00:00 | MSFT | Stock | 497.0 | 497.23 | 496.6563 | 497.1019 | 1559.0 |
| 2025-07-08 19:00:00 | MSFT | Stock | 496.89 | 497.0 | 496.6385 | 497.0 | 2319.0 |
| 2025-07-08 04:00:00 | NVDA | Stock | 159.0 | 159.76 | 158.25 | 159.7 | 275104.0 |
| 2025-07-08 05:00:00 | NVDA | Stock | 159.67 | 159.85 | 159.35 | 159.42 | 182544.0 |
| 2025-07-08 06:00:00 | NVDA | Stock | 159.45 | 159.75 | 159.3 | 159.58 | 113271.0 |
| 2025-07-08 07:00:00 | NVDA | Stock | 159.55 | 159.63 | 159.37 | 159.42 | 419157.0 |
| 2025-07-08 08:00:00 | NVDA | Stock | 159.4 | 159.83 | 158.41 | 159.3199 | 1063569.0 |
| 2025-07-08 09:00:00 | NVDA | Stock | 159.32 | 159.74 | 158.39 | 158.83 | 16198927.0 |
| 2025-07-08 10:00:00 | NVDA | Stock | 158.82 | 159.54 | 158.58 | 159.14 | 21422413.0 |
| 2025-07-08 11:00:00 | NVDA | Stock | 159.13 | 159.29 | 158.83 | 159.135 | 10640577.0 |
| 2025-07-08 12:00:00 | NVDA | Stock | 159.135 | 159.87 | 159.09 | 159.54 | 12029813.0 |
| 2025-07-08 13:00:00 | NVDA | Stock | 159.545 | 160.05 | 159.3 | 159.945 | 11075307.0 |
| 2025-07-08 14:00:00 | NVDA | Stock | 159.94 | 160.22 | 159.25 | 159.675 | 11883469.0 |
| 2025-07-08 15:00:00 | NVDA | Stock | 159.675 | 160.08 | 159.365 | 160.0001 | 14945170.0 |
| 2025-07-08 16:00:00 | NVDA | Stock | 160.0 | 160.11 | 159.93 | 160.0898 | 12709600.0 |
| 2025-07-08 17:00:00 | NVDA | Stock | 160.0899 | 160.27 | 160.02 | 160.17 | 365516.0 |
| 2025-07-08 18:00:00 | NVDA | Stock | 160.17 | 160.24 | 160.11 | 160.19 | 131332.0 |
| 2025-07-08 19:00:00 | NVDA | Stock | 160.19 | 160.3 | 160.17 | 160.2999 | 290802.0 |
| 2025-07-08 04:00:00 | AMZN | Stock | 224.21 | 224.41 | 224.16 | 224.33 | 10355.0 |
| 2025-07-08 05:00:00 | AMZN | Stock | 224.27 | 224.5 | 224.16 | 224.46 | 7603.0 |
> showing 50 of 62,304 rows — these rows as CSV