PREVIEW / stock_1hour / 2025-08-01
file: by_date/stock_1hour/2025/2025-08-01.parquet size: 1.4 MB rows: 63,844 symbols: 349
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-01 04:00:00 | AAPL | Stock | 211.4 | 211.93 | 209.41 | 210.72 | 134019.0 |
| 2025-08-01 05:00:00 | AAPL | Stock | 210.69 | 212.09 | 210.64 | 211.66 | 77455.0 |
| 2025-08-01 06:00:00 | AAPL | Stock | 211.61 | 211.67 | 210.5 | 210.73 | 78210.0 |
| 2025-08-01 07:00:00 | AAPL | Stock | 210.73 | 211.5 | 210.51 | 211.081 | 121442.0 |
| 2025-08-01 08:00:00 | AAPL | Stock | 211.0 | 212.35 | 210.0 | 211.2055 | 620735.0 |
| 2025-08-01 09:00:00 | AAPL | Stock | 211.1 | 213.58 | 206.27 | 207.045 | 13810491.0 |
| 2025-08-01 10:00:00 | AAPL | Stock | 207.04 | 207.47 | 203.62 | 204.0399 | 12915972.0 |
| 2025-08-01 11:00:00 | AAPL | Stock | 204.03 | 204.6 | 203.07 | 203.73 | 7640980.0 |
| 2025-08-01 12:00:00 | AAPL | Stock | 203.71 | 204.01 | 201.9601 | 202.085 | 6824351.0 |
| 2025-08-01 13:00:00 | AAPL | Stock | 202.07 | 202.55 | 201.5 | 202.218 | 5983165.0 |
| 2025-08-01 14:00:00 | AAPL | Stock | 202.2171 | 204.3212 | 202.19 | 203.81 | 5666169.0 |
| 2025-08-01 15:00:00 | AAPL | Stock | 203.81 | 204.02 | 202.17 | 202.27 | 9223969.0 |
| 2025-08-01 16:00:00 | AAPL | Stock | 202.27 | 202.75 | 202.26 | 202.55 | 7328784.0 |
| 2025-08-01 17:00:00 | AAPL | Stock | 202.5 | 202.68 | 202.38 | 202.68 | 218002.0 |
| 2025-08-01 18:00:00 | AAPL | Stock | 202.6784 | 202.75 | 202.5 | 202.54 | 43058.0 |
| 2025-08-01 19:00:00 | AAPL | Stock | 202.51 | 202.51 | 202.25 | 202.25 | 62751.0 |
| 2025-08-01 04:00:00 | MSFT | Stock | 536.35 | 539.25 | 536.35 | 537.0 | 25498.0 |
| 2025-08-01 05:00:00 | MSFT | Stock | 538.38 | 538.5 | 537.1 | 538.01 | 5966.0 |
| 2025-08-01 06:00:00 | MSFT | Stock | 537.07 | 537.12 | 536.1 | 536.36 | 2073.0 |
| 2025-08-01 07:00:00 | MSFT | Stock | 536.67 | 538.35 | 536.1 | 538.34 | 14081.0 |
| 2025-08-01 08:00:00 | MSFT | Stock | 536.02 | 538.5 | 532.72 | 533.1 | 98003.0 |
| 2025-08-01 09:00:00 | MSFT | Stock | 533.5 | 536.0 | 528.31 | 529.475 | 2843985.0 |
| 2025-08-01 10:00:00 | MSFT | Stock | 529.45 | 530.4 | 525.163 | 525.46 | 2870746.0 |
| 2025-08-01 11:00:00 | MSFT | Stock | 525.585 | 525.64 | 522.64 | 524.27 | 2073301.0 |
| 2025-08-01 12:00:00 | MSFT | Stock | 524.27 | 524.85 | 520.89 | 521.045 | 1896487.0 |
| 2025-08-01 13:00:00 | MSFT | Stock | 521.03 | 524.02 | 520.86 | 523.415 | 1471748.0 |
| 2025-08-01 14:00:00 | MSFT | Stock | 523.405 | 524.99 | 522.4 | 524.51 | 1337725.0 |
| 2025-08-01 15:00:00 | MSFT | Stock | 524.51 | 526.26 | 523.16 | 524.0 | 2241215.0 |
| 2025-08-01 16:00:00 | MSFT | Stock | 524.0 | 524.48 | 523.0 | 523.9 | 3742093.0 |
| 2025-08-01 17:00:00 | MSFT | Stock | 523.9944 | 524.79 | 523.75 | 524.75 | 8811.0 |
| 2025-08-01 18:00:00 | MSFT | Stock | 524.75 | 524.75 | 524.0 | 524.0 | 3808.0 |
| 2025-08-01 19:00:00 | MSFT | Stock | 524.0001 | 524.3 | 523.5777 | 523.5777 | 7551.0 |
| 2025-08-01 04:00:00 | NVDA | Stock | 174.69 | 176.11 | 172.24 | 173.19 | 1133006.0 |
| 2025-08-01 05:00:00 | NVDA | Stock | 173.2 | 173.94 | 172.92 | 173.89 | 442423.0 |
| 2025-08-01 06:00:00 | NVDA | Stock | 173.86 | 173.94 | 173.08 | 173.52 | 312584.0 |
| 2025-08-01 07:00:00 | NVDA | Stock | 173.55 | 175.01 | 173.35 | 174.98 | 776058.0 |
| 2025-08-01 08:00:00 | NVDA | Stock | 173.5 | 177.19 | 172.29 | 173.9519 | 2945421.0 |
| 2025-08-01 09:00:00 | NVDA | Stock | 173.99 | 174.27 | 170.89 | 172.19 | 28748558.0 |
| 2025-08-01 10:00:00 | NVDA | Stock | 172.15 | 176.0 | 171.41 | 174.9188 | 32600153.0 |
| 2025-08-01 11:00:00 | NVDA | Stock | 174.93 | 176.34 | 174.34 | 176.305 | 17014037.0 |
| 2025-08-01 12:00:00 | NVDA | Stock | 176.3 | 176.54 | 174.03 | 174.16 | 13717430.0 |
| 2025-08-01 13:00:00 | NVDA | Stock | 174.14 | 174.42 | 172.665 | 173.04 | 16924386.0 |
| 2025-08-01 14:00:00 | NVDA | Stock | 173.03 | 174.15 | 171.7919 | 172.9548 | 17924531.0 |
| 2025-08-01 15:00:00 | NVDA | Stock | 172.95 | 174.88 | 172.83 | 173.58 | 19204814.0 |
| 2025-08-01 16:00:00 | NVDA | Stock | 173.585 | 173.8872 | 173.1 | 173.35 | 14653407.0 |
| 2025-08-01 17:00:00 | NVDA | Stock | 173.34 | 173.4 | 173.1 | 173.15 | 323579.0 |
| 2025-08-01 18:00:00 | NVDA | Stock | 173.15 | 173.15 | 172.56 | 172.64 | 314298.0 |
| 2025-08-01 19:00:00 | NVDA | Stock | 172.64 | 172.8388 | 172.5 | 172.5099 | 307725.0 |
| 2025-08-01 04:00:00 | AMZN | Stock | 217.88 | 218.6 | 213.65 | 215.13 | 380060.0 |
| 2025-08-01 05:00:00 | AMZN | Stock | 215.16 | 216.59 | 214.52 | 216.45 | 180706.0 |
> showing 50 of 63,844 rows — these rows as CSV