PREVIEW / stock_1hour / 2025-08-05
file: by_date/stock_1hour/2025/2025-08-05.parquet size: 1.4 MB rows: 62,343 symbols: 356
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-08-05 04:00:00 | AAPL | Stock | 203.5 | 203.99 | 203.5 | 203.85 | 14944.0 |
| 2025-08-05 05:00:00 | AAPL | Stock | 203.85 | 203.94 | 203.8 | 203.88 | 10389.0 |
| 2025-08-05 06:00:00 | AAPL | Stock | 203.93 | 204.26 | 203.93 | 204.26 | 14498.0 |
| 2025-08-05 07:00:00 | AAPL | Stock | 204.25 | 204.32 | 203.98 | 204.03 | 28642.0 |
| 2025-08-05 08:00:00 | AAPL | Stock | 204.1 | 204.344 | 203.0 | 203.7501 | 212167.0 |
| 2025-08-05 09:00:00 | AAPL | Stock | 203.7511 | 204.26 | 202.16 | 203.37 | 4366111.0 |
| 2025-08-05 10:00:00 | AAPL | Stock | 203.35 | 204.7904 | 202.89 | 204.23 | 5531283.0 |
| 2025-08-05 11:00:00 | AAPL | Stock | 204.23 | 205.34 | 203.6779 | 203.92 | 4349538.0 |
| 2025-08-05 12:00:00 | AAPL | Stock | 203.91 | 203.9319 | 203.08 | 203.8316 | 2868973.0 |
| 2025-08-05 13:00:00 | AAPL | Stock | 203.83 | 204.17 | 203.75 | 204.03 | 2288638.0 |
| 2025-08-05 14:00:00 | AAPL | Stock | 204.035 | 204.3 | 203.1901 | 203.58 | 2572329.0 |
| 2025-08-05 15:00:00 | AAPL | Stock | 203.6 | 203.68 | 202.67 | 202.93 | 4147562.0 |
| 2025-08-05 16:00:00 | AAPL | Stock | 202.92 | 203.1 | 202.7 | 202.75 | 5632215.0 |
| 2025-08-05 17:00:00 | AAPL | Stock | 202.82 | 202.9 | 202.5 | 202.81 | 56544.0 |
| 2025-08-05 18:00:00 | AAPL | Stock | 202.9 | 202.94 | 202.61 | 202.79 | 19817.0 |
| 2025-08-05 19:00:00 | AAPL | Stock | 202.79 | 202.86 | 202.7 | 202.8 | 21555.0 |
| 2025-08-05 04:00:00 | MSFT | Stock | 536.81 | 537.48 | 536.46 | 537.04 | 3340.0 |
| 2025-08-05 05:00:00 | MSFT | Stock | 537.35 | 537.52 | 537.2 | 537.5 | 576.0 |
| 2025-08-05 06:00:00 | MSFT | Stock | 537.69 | 538.95 | 537.69 | 538.95 | 2814.0 |
| 2025-08-05 07:00:00 | MSFT | Stock | 538.61 | 539.0 | 538.14 | 538.4 | 6467.0 |
| 2025-08-05 08:00:00 | MSFT | Stock | 538.59 | 538.9 | 536.9 | 538.0 | 28409.0 |
| 2025-08-05 09:00:00 | MSFT | Stock | 537.93 | 538.31 | 534.73 | 535.28 | 1712059.0 |
| 2025-08-05 10:00:00 | MSFT | Stock | 535.15 | 535.215 | 531.8101 | 531.91 | 1972992.0 |
| 2025-08-05 11:00:00 | MSFT | Stock | 531.885 | 532.96 | 530.7 | 532.14 | 1160867.0 |
| 2025-08-05 12:00:00 | MSFT | Stock | 532.11 | 533.2 | 531.55 | 531.93 | 859233.0 |
| 2025-08-05 13:00:00 | MSFT | Stock | 531.92 | 532.555 | 531.0501 | 532.38 | 775593.0 |
| 2025-08-05 14:00:00 | MSFT | Stock | 532.38 | 532.47 | 528.39 | 528.96 | 1311836.0 |
| 2025-08-05 15:00:00 | MSFT | Stock | 528.99 | 534.0 | 527.24 | 527.72 | 2060532.0 |
| 2025-08-05 16:00:00 | MSFT | Stock | 527.69 | 528.5 | 527.5 | 528.0 | 2755488.0 |
| 2025-08-05 17:00:00 | MSFT | Stock | 527.8 | 528.45 | 527.5091 | 528.0588 | 3065.0 |
| 2025-08-05 18:00:00 | MSFT | Stock | 528.14 | 528.47 | 528.0 | 528.2 | 9642.0 |
| 2025-08-05 19:00:00 | MSFT | Stock | 528.25 | 529.0 | 528.0318 | 528.21 | 8832.0 |
| 2025-08-05 04:00:00 | NVDA | Stock | 181.0 | 181.1 | 180.09 | 180.61 | 335281.0 |
| 2025-08-05 05:00:00 | NVDA | Stock | 180.63 | 180.76 | 180.39 | 180.66 | 112054.0 |
| 2025-08-05 06:00:00 | NVDA | Stock | 180.73 | 181.1 | 180.66 | 180.83 | 152604.0 |
| 2025-08-05 07:00:00 | NVDA | Stock | 180.85 | 181.47 | 180.8 | 181.15 | 335460.0 |
| 2025-08-05 08:00:00 | NVDA | Stock | 181.3 | 181.56 | 180.11 | 180.54 | 1567033.0 |
| 2025-08-05 09:00:00 | NVDA | Stock | 180.54 | 180.6819 | 178.58 | 179.94 | 19419358.0 |
| 2025-08-05 10:00:00 | NVDA | Stock | 179.92 | 179.935 | 175.9 | 177.345 | 27799199.0 |
| 2025-08-05 11:00:00 | NVDA | Stock | 177.345 | 177.96 | 176.215 | 177.09 | 17843739.0 |
| 2025-08-05 12:00:00 | NVDA | Stock | 177.09 | 178.265 | 177.01 | 177.5199 | 13459131.0 |
| 2025-08-05 13:00:00 | NVDA | Stock | 177.51 | 179.06 | 177.02 | 178.915 | 10286190.0 |
| 2025-08-05 14:00:00 | NVDA | Stock | 178.91 | 179.12 | 177.65 | 178.2 | 12480670.0 |
| 2025-08-05 15:00:00 | NVDA | Stock | 178.19 | 179.17 | 178.0201 | 178.26 | 14912175.0 |
| 2025-08-05 16:00:00 | NVDA | Stock | 178.26 | 178.76 | 176.69 | 177.1 | 10172873.0 |
| 2025-08-05 17:00:00 | NVDA | Stock | 177.06 | 178.5995 | 176.96 | 177.2 | 607459.0 |
| 2025-08-05 18:00:00 | NVDA | Stock | 177.17 | 177.4 | 176.75 | 177.15 | 337535.0 |
| 2025-08-05 19:00:00 | NVDA | Stock | 177.1594 | 177.16 | 176.55 | 176.81 | 276496.0 |
| 2025-08-05 04:00:00 | AMZN | Stock | 213.25 | 213.25 | 212.62 | 212.87 | 29047.0 |
| 2025-08-05 05:00:00 | AMZN | Stock | 212.88 | 213.22 | 212.87 | 213.15 | 16876.0 |
> showing 50 of 62,343 rows — these rows as CSV