PREVIEW / stock_1hour / 2025-07-25
file: by_date/stock_1hour/2025/2025-07-25.parquet size: 1.4 MB rows: 61,820 symbols: 362
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-25 04:00:00 | AAPL | Stock | 213.72 | 214.19 | 213.72 | 214.16 | 9985.0 |
| 2025-07-25 05:00:00 | AAPL | Stock | 214.13 | 214.42 | 214.11 | 214.42 | 5333.0 |
| 2025-07-25 06:00:00 | AAPL | Stock | 214.46 | 214.57 | 214.3 | 214.5 | 6854.0 |
| 2025-07-25 07:00:00 | AAPL | Stock | 214.38 | 214.4 | 214.14 | 214.15 | 12416.0 |
| 2025-07-25 08:00:00 | AAPL | Stock | 214.34 | 214.57 | 213.8 | 214.47 | 84168.0 |
| 2025-07-25 09:00:00 | AAPL | Stock | 214.41 | 214.86 | 213.8 | 214.0918 | 3673648.0 |
| 2025-07-25 10:00:00 | AAPL | Stock | 214.09 | 215.24 | 213.73 | 214.7302 | 5092550.0 |
| 2025-07-25 11:00:00 | AAPL | Stock | 214.73 | 214.78 | 214.09 | 214.2365 | 2721141.0 |
| 2025-07-25 12:00:00 | AAPL | Stock | 214.23 | 214.615 | 214.05 | 214.405 | 2017355.0 |
| 2025-07-25 13:00:00 | AAPL | Stock | 214.4049 | 214.51 | 213.92 | 213.9901 | 2514054.0 |
| 2025-07-25 14:00:00 | AAPL | Stock | 213.995 | 214.1699 | 213.7 | 213.7935 | 1905502.0 |
| 2025-07-25 15:00:00 | AAPL | Stock | 213.79 | 214.0 | 213.4 | 213.96 | 4608570.0 |
| 2025-07-25 16:00:00 | AAPL | Stock | 213.96 | 214.01 | 213.7 | 214.0 | 3759038.0 |
| 2025-07-25 17:00:00 | AAPL | Stock | 214.02 | 214.03 | 213.81 | 213.9 | 40353.0 |
| 2025-07-25 18:00:00 | AAPL | Stock | 213.881 | 214.0 | 213.85 | 213.92 | 27677.0 |
| 2025-07-25 19:00:00 | AAPL | Stock | 213.95 | 214.05 | 213.91 | 214.0 | 18168.0 |
| 2025-07-25 04:00:00 | MSFT | Stock | 511.7 | 512.01 | 511.5 | 512.01 | 743.0 |
| 2025-07-25 05:00:00 | MSFT | Stock | 511.9 | 511.95 | 511.62 | 511.87 | 2172.0 |
| 2025-07-25 06:00:00 | MSFT | Stock | 511.9 | 512.39 | 511.74 | 512.39 | 1398.0 |
| 2025-07-25 07:00:00 | MSFT | Stock | 512.5 | 512.77 | 512.4 | 512.72 | 6511.0 |
| 2025-07-25 08:00:00 | MSFT | Stock | 512.4 | 513.38 | 511.0 | 513.15 | 13675.0 |
| 2025-07-25 09:00:00 | MSFT | Stock | 513.01 | 513.01 | 510.3592 | 512.08 | 852704.0 |
| 2025-07-25 10:00:00 | MSFT | Stock | 512.2035 | 513.14 | 511.45 | 512.6236 | 995804.0 |
| 2025-07-25 11:00:00 | MSFT | Stock | 512.6 | 514.15 | 512.1101 | 513.5832 | 1040818.0 |
| 2025-07-25 12:00:00 | MSFT | Stock | 513.61 | 514.59 | 513.06 | 513.93 | 895777.0 |
| 2025-07-25 13:00:00 | MSFT | Stock | 513.925 | 517.16 | 513.67 | 516.9 | 1215009.0 |
| 2025-07-25 14:00:00 | MSFT | Stock | 516.93 | 518.29 | 516.2 | 517.36 | 1374680.0 |
| 2025-07-25 15:00:00 | MSFT | Stock | 517.37 | 517.39 | 513.125 | 513.79 | 2164089.0 |
| 2025-07-25 16:00:00 | MSFT | Stock | 513.71 | 514.58 | 513.25 | 514.58 | 2406880.0 |
| 2025-07-25 17:00:00 | MSFT | Stock | 514.69 | 514.69 | 514.0 | 514.49 | 4425.0 |
| 2025-07-25 18:00:00 | MSFT | Stock | 514.48 | 514.97 | 514.34 | 514.72 | 4663.0 |
| 2025-07-25 19:00:00 | MSFT | Stock | 514.76 | 514.76 | 514.05 | 514.05 | 9208.0 |
| 2025-07-25 04:00:00 | NVDA | Stock | 173.09 | 173.74 | 173.09 | 173.5 | 174016.0 |
| 2025-07-25 05:00:00 | NVDA | Stock | 173.51 | 173.53 | 173.05 | 173.38 | 123187.0 |
| 2025-07-25 06:00:00 | NVDA | Stock | 173.4 | 173.52 | 173.3 | 173.44 | 106397.0 |
| 2025-07-25 07:00:00 | NVDA | Stock | 173.41 | 173.46 | 173.13 | 173.18 | 150560.0 |
| 2025-07-25 08:00:00 | NVDA | Stock | 173.3 | 173.86 | 172.94 | 173.17 | 798715.0 |
| 2025-07-25 09:00:00 | NVDA | Stock | 173.15 | 174.55 | 172.96 | 174.285 | 17111360.0 |
| 2025-07-25 10:00:00 | NVDA | Stock | 174.28 | 174.72 | 173.79 | 174.045 | 18855511.0 |
| 2025-07-25 11:00:00 | NVDA | Stock | 174.05 | 174.18 | 173.64 | 174.0101 | 11338736.0 |
| 2025-07-25 12:00:00 | NVDA | Stock | 174.01 | 174.53 | 173.9801 | 174.195 | 8830181.0 |
| 2025-07-25 13:00:00 | NVDA | Stock | 174.19 | 174.2 | 173.3 | 173.435 | 7552222.0 |
| 2025-07-25 14:00:00 | NVDA | Stock | 173.4352 | 173.9 | 173.01 | 173.645 | 9167669.0 |
| 2025-07-25 15:00:00 | NVDA | Stock | 173.645 | 174.06 | 173.0 | 173.48 | 14538430.0 |
| 2025-07-25 16:00:00 | NVDA | Stock | 173.5 | 173.68 | 173.15 | 173.4689 | 8678005.0 |
| 2025-07-25 17:00:00 | NVDA | Stock | 173.41 | 173.57 | 173.35 | 173.48 | 146553.0 |
| 2025-07-25 18:00:00 | NVDA | Stock | 173.4701 | 173.55 | 173.4001 | 173.49 | 76060.0 |
| 2025-07-25 19:00:00 | NVDA | Stock | 173.49 | 173.5 | 173.2901 | 173.45 | 143434.0 |
| 2025-07-25 04:00:00 | AMZN | Stock | 232.26 | 232.45 | 232.03 | 232.34 | 5711.0 |
| 2025-07-25 05:00:00 | AMZN | Stock | 232.26 | 232.37 | 232.01 | 232.27 | 6871.0 |
> showing 50 of 61,820 rows — these rows as CSV