PREVIEW / stock_1hour / 2025-08-21
file: by_date/stock_1hour/2025/2025-08-21.parquet size: 1.4 MB rows: 60,768 symbols: 333
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-21 04:00:00 | AAPL | Stock | 225.99 | 226.11 | 225.4 | 225.44 | 6148.0 |
| 2025-08-21 05:00:00 | AAPL | Stock | 225.23 | 225.3 | 224.9 | 224.9 | 10822.0 |
| 2025-08-21 06:00:00 | AAPL | Stock | 224.82 | 225.0 | 224.62 | 225.0 | 11074.0 |
| 2025-08-21 07:00:00 | AAPL | Stock | 225.13 | 225.4 | 225.0 | 225.34 | 18212.0 |
| 2025-08-21 08:00:00 | AAPL | Stock | 225.2 | 226.2 | 224.8504 | 225.56 | 82104.0 |
| 2025-08-21 09:00:00 | AAPL | Stock | 225.38 | 226.52 | 224.68 | 225.2 | 3000889.0 |
| 2025-08-21 10:00:00 | AAPL | Stock | 225.2 | 226.02 | 225.01 | 225.29 | 2815796.0 |
| 2025-08-21 11:00:00 | AAPL | Stock | 225.29 | 225.8499 | 224.51 | 225.26 | 2859698.0 |
| 2025-08-21 12:00:00 | AAPL | Stock | 225.26 | 225.275 | 224.54 | 224.61 | 1844366.0 |
| 2025-08-21 13:00:00 | AAPL | Stock | 224.62 | 224.82 | 223.7804 | 224.56 | 2651997.0 |
| 2025-08-21 14:00:00 | AAPL | Stock | 224.55 | 224.59 | 224.0942 | 224.51 | 1741384.0 |
| 2025-08-21 15:00:00 | AAPL | Stock | 224.5 | 225.25 | 224.3884 | 224.91 | 4216063.0 |
| 2025-08-21 16:00:00 | AAPL | Stock | 224.9 | 225.2 | 224.6741 | 225.09 | 3320978.0 |
| 2025-08-21 17:00:00 | AAPL | Stock | 225.01 | 225.01 | 224.84 | 224.9208 | 13185.0 |
| 2025-08-21 18:00:00 | AAPL | Stock | 224.93 | 225.48 | 224.93 | 225.3 | 12558.0 |
| 2025-08-21 19:00:00 | AAPL | Stock | 225.2117 | 225.39 | 225.05 | 225.38 | 9611.0 |
| 2025-08-21 04:00:00 | MSFT | Stock | 505.88 | 506.21 | 505.6 | 505.6 | 3286.0 |
| 2025-08-21 05:00:00 | MSFT | Stock | 505.13 | 505.86 | 505.01 | 505.86 | 3260.0 |
| 2025-08-21 06:00:00 | MSFT | Stock | 505.25 | 505.59 | 504.8 | 505.27 | 2074.0 |
| 2025-08-21 07:00:00 | MSFT | Stock | 505.2 | 505.41 | 504.25 | 504.4 | 10213.0 |
| 2025-08-21 08:00:00 | MSFT | Stock | 504.75 | 506.2 | 503.33 | 504.25 | 24555.0 |
| 2025-08-21 09:00:00 | MSFT | Stock | 503.82 | 505.43 | 502.57 | 503.2 | 966014.0 |
| 2025-08-21 10:00:00 | MSFT | Stock | 503.175 | 507.63 | 502.9197 | 506.8288 | 1073069.0 |
| 2025-08-21 11:00:00 | MSFT | Stock | 506.755 | 507.41 | 505.45 | 506.525 | 585231.0 |
| 2025-08-21 12:00:00 | MSFT | Stock | 506.55 | 506.95 | 504.43 | 504.635 | 1201340.0 |
| 2025-08-21 13:00:00 | MSFT | Stock | 504.66 | 506.01 | 503.9 | 505.3 | 1399612.0 |
| 2025-08-21 14:00:00 | MSFT | Stock | 505.29 | 505.946 | 504.85 | 505.74 | 986329.0 |
| 2025-08-21 15:00:00 | MSFT | Stock | 505.73 | 506.46 | 504.11 | 504.15 | 1974422.0 |
| 2025-08-21 16:00:00 | MSFT | Stock | 504.24 | 504.29 | 503.49 | 504.25 | 2934593.0 |
| 2025-08-21 17:00:00 | MSFT | Stock | 504.25 | 504.32 | 503.04 | 503.6 | 4834.0 |
| 2025-08-21 18:00:00 | MSFT | Stock | 503.74 | 504.59 | 503.74 | 504.24 | 3398.0 |
| 2025-08-21 19:00:00 | MSFT | Stock | 504.15 | 504.58 | 503.76 | 504.55 | 12599.0 |
| 2025-08-21 04:00:00 | NVDA | Stock | 175.74 | 176.62 | 175.03 | 176.05 | 414243.0 |
| 2025-08-21 05:00:00 | NVDA | Stock | 176.07 | 177.0 | 175.9 | 176.62 | 305806.0 |
| 2025-08-21 06:00:00 | NVDA | Stock | 176.62 | 176.88 | 176.39 | 176.58 | 292567.0 |
| 2025-08-21 07:00:00 | NVDA | Stock | 176.56 | 176.78 | 175.73 | 175.76 | 370963.0 |
| 2025-08-21 08:00:00 | NVDA | Stock | 175.75 | 176.98 | 174.05 | 174.34 | 1840046.0 |
| 2025-08-21 09:00:00 | NVDA | Stock | 174.34 | 176.9 | 173.82 | 174.34 | 21362116.0 |
| 2025-08-21 10:00:00 | NVDA | Stock | 174.37 | 176.49 | 173.98 | 175.815 | 17495608.0 |
| 2025-08-21 11:00:00 | NVDA | Stock | 175.82 | 176.06 | 174.4801 | 174.7501 | 14980001.0 |
| 2025-08-21 12:00:00 | NVDA | Stock | 174.76 | 174.98 | 174.04 | 174.1618 | 11119433.0 |
| 2025-08-21 13:00:00 | NVDA | Stock | 174.165 | 175.0899 | 173.81 | 175.03 | 11333486.0 |
| 2025-08-21 14:00:00 | NVDA | Stock | 175.03 | 175.19 | 174.27 | 174.745 | 8440892.0 |
| 2025-08-21 15:00:00 | NVDA | Stock | 174.74 | 175.95 | 174.52 | 174.971 | 12482422.0 |
| 2025-08-21 16:00:00 | NVDA | Stock | 174.98 | 174.98 | 174.66 | 174.89 | 11139514.0 |
| 2025-08-21 17:00:00 | NVDA | Stock | 174.88 | 174.9 | 174.65 | 174.77 | 159803.0 |
| 2025-08-21 18:00:00 | NVDA | Stock | 174.78 | 174.99 | 174.78 | 174.95 | 163370.0 |
| 2025-08-21 19:00:00 | NVDA | Stock | 174.96 | 174.979 | 174.7 | 174.7998 | 175888.0 |
| 2025-08-21 04:00:00 | AMZN | Stock | 224.11 | 224.35 | 223.71 | 223.71 | 7047.0 |
| 2025-08-21 05:00:00 | AMZN | Stock | 223.5 | 223.7 | 223.2 | 223.2 | 7691.0 |
> showing 50 of 60,768 rows — these rows as CSV