PREVIEW / stock_1hour / 2025-04-28
file: by_date/stock_1hour/2025/2025-04-28.parquet size: 1.4 MB rows: 61,700 symbols: 423
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-04-28 04:00:00 | AAPL | Stock | 208.76 | 208.76 | 207.74 | 208.71 | 15912.0 |
| 2025-04-28 05:00:00 | AAPL | Stock | 208.8 | 210.0 | 208.58 | 209.73 | 29984.0 |
| 2025-04-28 06:00:00 | AAPL | Stock | 209.65 | 209.68 | 209.28 | 209.32 | 14997.0 |
| 2025-04-28 07:00:00 | AAPL | Stock | 209.35 | 210.0 | 209.16 | 209.92 | 34505.0 |
| 2025-04-28 08:00:00 | AAPL | Stock | 209.3 | 210.08 | 207.57 | 210.05 | 160396.0 |
| 2025-04-28 09:00:00 | AAPL | Stock | 210.05 | 211.5 | 208.95 | 209.385 | 4192082.0 |
| 2025-04-28 10:00:00 | AAPL | Stock | 209.385 | 209.82 | 208.73 | 209.03 | 3198118.0 |
| 2025-04-28 11:00:00 | AAPL | Stock | 209.04 | 209.53 | 207.58 | 207.96 | 2474676.0 |
| 2025-04-28 12:00:00 | AAPL | Stock | 207.95 | 208.73 | 207.46 | 208.445 | 1703630.0 |
| 2025-04-28 13:00:00 | AAPL | Stock | 208.43 | 209.86 | 207.91 | 209.75 | 1836726.0 |
| 2025-04-28 14:00:00 | AAPL | Stock | 209.73 | 210.1 | 209.46 | 209.8407 | 1887764.0 |
| 2025-04-28 15:00:00 | AAPL | Stock | 209.87 | 211.5 | 209.8 | 210.09 | 3858763.0 |
| 2025-04-28 16:00:00 | AAPL | Stock | 210.14 | 210.2 | 209.7502 | 210.0899 | 7019315.0 |
| 2025-04-28 17:00:00 | AAPL | Stock | 210.09 | 210.09 | 209.65 | 209.7 | 23001.0 |
| 2025-04-28 18:00:00 | AAPL | Stock | 209.65 | 209.99 | 209.6 | 209.89 | 27488.0 |
| 2025-04-28 19:00:00 | AAPL | Stock | 210.0 | 210.95 | 209.84 | 210.3 | 21215.0 |
| 2025-04-28 04:00:00 | MSFT | Stock | 392.0 | 392.0 | 390.82 | 391.62 | 4313.0 |
| 2025-04-28 05:00:00 | MSFT | Stock | 391.86 | 392.35 | 391.0 | 392.06 | 7756.0 |
| 2025-04-28 06:00:00 | MSFT | Stock | 391.85 | 391.85 | 391.2 | 391.2 | 1577.0 |
| 2025-04-28 07:00:00 | MSFT | Stock | 391.33 | 391.53 | 390.94 | 391.25 | 5260.0 |
| 2025-04-28 08:00:00 | MSFT | Stock | 390.89 | 392.3978 | 389.63 | 392.1197 | 18376.0 |
| 2025-04-28 09:00:00 | MSFT | Stock | 392.05 | 393.0 | 387.65 | 389.85 | 1813216.0 |
| 2025-04-28 10:00:00 | MSFT | Stock | 389.93 | 390.89 | 388.99 | 390.4 | 1018633.0 |
| 2025-04-28 11:00:00 | MSFT | Stock | 390.46 | 390.71 | 387.5 | 387.91 | 655265.0 |
| 2025-04-28 12:00:00 | MSFT | Stock | 387.91 | 388.28 | 386.7085 | 387.49 | 527839.0 |
| 2025-04-28 13:00:00 | MSFT | Stock | 387.44 | 389.42 | 386.638 | 389.32 | 575576.0 |
| 2025-04-28 14:00:00 | MSFT | Stock | 389.34 | 391.095 | 389.16 | 390.83 | 976057.0 |
| 2025-04-28 15:00:00 | MSFT | Stock | 390.87 | 392.74 | 390.72 | 391.16 | 1703965.0 |
| 2025-04-28 16:00:00 | MSFT | Stock | 391.16 | 391.16 | 390.1 | 390.12 | 3228554.0 |
| 2025-04-28 17:00:00 | MSFT | Stock | 390.33 | 390.8675 | 390.0 | 390.0 | 3101.0 |
| 2025-04-28 18:00:00 | MSFT | Stock | 390.0 | 390.5 | 390.0 | 390.48 | 506.0 |
| 2025-04-28 19:00:00 | MSFT | Stock | 390.5361 | 391.0 | 390.4 | 391.0 | 1083.0 |
| 2025-04-28 04:00:00 | NVDA | Stock | 109.93 | 110.45 | 109.06 | 109.5 | 846356.0 |
| 2025-04-28 05:00:00 | NVDA | Stock | 109.5 | 110.11 | 109.38 | 109.87 | 479972.0 |
| 2025-04-28 06:00:00 | NVDA | Stock | 109.87 | 110.1 | 109.36 | 109.53 | 538908.0 |
| 2025-04-28 07:00:00 | NVDA | Stock | 109.55 | 109.73 | 109.11 | 109.26 | 801592.0 |
| 2025-04-28 08:00:00 | NVDA | Stock | 109.63 | 111.01 | 109.01 | 109.75 | 2102951.0 |
| 2025-04-28 09:00:00 | NVDA | Stock | 109.76 | 110.3699 | 108.1 | 108.45 | 31458301.0 |
| 2025-04-28 10:00:00 | NVDA | Stock | 108.45 | 108.92 | 107.73 | 107.79 | 28163899.0 |
| 2025-04-28 11:00:00 | NVDA | Stock | 107.8 | 108.0 | 106.3844 | 107.275 | 25317057.0 |
| 2025-04-28 12:00:00 | NVDA | Stock | 107.27 | 107.34 | 106.52 | 106.7 | 14742446.0 |
| 2025-04-28 13:00:00 | NVDA | Stock | 106.6916 | 107.04 | 106.02 | 106.9891 | 15086612.0 |
| 2025-04-28 14:00:00 | NVDA | Stock | 106.99 | 107.6 | 106.7 | 107.465 | 12975188.0 |
| 2025-04-28 15:00:00 | NVDA | Stock | 107.47 | 108.85 | 107.41 | 108.64 | 24448071.0 |
| 2025-04-28 16:00:00 | NVDA | Stock | 108.73 | 108.73 | 108.35 | 108.5 | 16508371.0 |
| 2025-04-28 17:00:00 | NVDA | Stock | 108.52 | 108.52 | 108.18 | 108.33 | 381553.0 |
| 2025-04-28 18:00:00 | NVDA | Stock | 108.33 | 108.33 | 108.01 | 108.15 | 328912.0 |
| 2025-04-28 19:00:00 | NVDA | Stock | 108.15 | 108.3 | 108.0712 | 108.13 | 257625.0 |
| 2025-04-28 04:00:00 | AMZN | Stock | 189.09 | 189.32 | 188.52 | 189.32 | 12560.0 |
| 2025-04-28 05:00:00 | AMZN | Stock | 189.31 | 189.67 | 189.31 | 189.36 | 8675.0 |
> showing 50 of 61,700 rows — these rows as CSV