PREVIEW / stock_1hour / 2025-01-06
file: by_date/stock_1hour/2025/2025-01-06.parquet size: 1.5 MB rows: 66,968 symbols: 592
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-01-06 04:00:00 | AAPL | Stock | 243.89 | 245.33 | 243.89 | 245.0 | 50324.0 |
| 2025-01-06 05:00:00 | AAPL | Stock | 245.0 | 245.09 | 244.915 | 245.01 | 7879.0 |
| 2025-01-06 06:00:00 | AAPL | Stock | 245.0 | 245.3 | 244.85 | 245.06 | 27762.0 |
| 2025-01-06 07:00:00 | AAPL | Stock | 245.05 | 245.06 | 244.11 | 244.11 | 75394.0 |
| 2025-01-06 08:00:00 | AAPL | Stock | 244.965 | 245.13 | 243.74 | 245.05 | 212858.0 |
| 2025-01-06 09:00:00 | AAPL | Stock | 245.03 | 246.1827 | 243.2 | 244.4256 | 4752384.0 |
| 2025-01-06 10:00:00 | AAPL | Stock | 244.45 | 246.46 | 244.44 | 246.34 | 4144330.0 |
| 2025-01-06 11:00:00 | AAPL | Stock | 246.35 | 247.33 | 245.89 | 246.25 | 3334149.0 |
| 2025-01-06 12:00:00 | AAPL | Stock | 246.25 | 246.49 | 244.73 | 244.95 | 2214905.0 |
| 2025-01-06 13:00:00 | AAPL | Stock | 244.98 | 245.13 | 244.47 | 244.87 | 1844888.0 |
| 2025-01-06 14:00:00 | AAPL | Stock | 244.87 | 245.18 | 244.5 | 244.59 | 1545817.0 |
| 2025-01-06 15:00:00 | AAPL | Stock | 244.585 | 245.34 | 244.41 | 245.0 | 3701899.0 |
| 2025-01-06 16:00:00 | AAPL | Stock | 245.0 | 245.02 | 244.65 | 244.69 | 9202420.0 |
| 2025-01-06 17:00:00 | AAPL | Stock | 244.67 | 244.7 | 244.5 | 244.554 | 12933.0 |
| 2025-01-06 18:00:00 | AAPL | Stock | 244.6 | 244.78 | 244.6 | 244.7006 | 9492.0 |
| 2025-01-06 19:00:00 | AAPL | Stock | 244.72 | 245.0 | 244.6 | 244.99 | 18664.0 |
| 2025-01-06 04:00:00 | MSFT | Stock | 427.15 | 428.14 | 426.18 | 428.14 | 9178.0 |
| 2025-01-06 05:00:00 | MSFT | Stock | 428.1 | 429.2 | 427.82 | 427.82 | 8955.0 |
| 2025-01-06 06:00:00 | MSFT | Stock | 427.88 | 427.94 | 427.05 | 427.75 | 19184.0 |
| 2025-01-06 07:00:00 | MSFT | Stock | 427.7 | 427.85 | 426.83 | 427.5 | 21861.0 |
| 2025-01-06 08:00:00 | MSFT | Stock | 427.59 | 428.41 | 425.6 | 427.87 | 74540.0 |
| 2025-01-06 09:00:00 | MSFT | Stock | 427.99 | 431.98 | 426.1 | 430.96 | 2271939.0 |
| 2025-01-06 10:00:00 | MSFT | Stock | 430.98 | 434.32 | 430.465 | 432.1925 | 1929916.0 |
| 2025-01-06 11:00:00 | MSFT | Stock | 432.22 | 432.34 | 430.95 | 431.255 | 962011.0 |
| 2025-01-06 12:00:00 | MSFT | Stock | 431.23 | 432.01 | 428.56 | 428.76 | 874074.0 |
| 2025-01-06 13:00:00 | MSFT | Stock | 428.69 | 428.78 | 425.77 | 426.04 | 950319.0 |
| 2025-01-06 14:00:00 | MSFT | Stock | 426.0675 | 427.2 | 425.4774 | 426.07 | 642961.0 |
| 2025-01-06 15:00:00 | MSFT | Stock | 425.99 | 428.08 | 425.84 | 428.07 | 1244712.0 |
| 2025-01-06 16:00:00 | MSFT | Stock | 428.07 | 428.79 | 427.26 | 428.79 | 4516103.0 |
| 2025-01-06 17:00:00 | MSFT | Stock | 428.5 | 428.6 | 428.25 | 428.35 | 5518.0 |
| 2025-01-06 18:00:00 | MSFT | Stock | 428.35 | 428.66 | 428.35 | 428.55 | 4252.0 |
| 2025-01-06 19:00:00 | MSFT | Stock | 428.7531 | 428.7531 | 428.3477 | 428.55 | 7220.0 |
| 2025-01-06 04:00:00 | NVDA | Stock | 146.0 | 147.69 | 144.87 | 147.5 | 1243367.0 |
| 2025-01-06 05:00:00 | NVDA | Stock | 147.55 | 147.61 | 146.99 | 147.17 | 353415.0 |
| 2025-01-06 06:00:00 | NVDA | Stock | 147.18 | 147.84 | 147.03 | 147.32 | 469541.0 |
| 2025-01-06 07:00:00 | NVDA | Stock | 147.32 | 148.74 | 147.02 | 148.23 | 1804069.0 |
| 2025-01-06 08:00:00 | NVDA | Stock | 148.225 | 148.7299 | 145.7 | 148.59 | 3060210.0 |
| 2025-01-06 09:00:00 | NVDA | Stock | 148.58 | 150.33 | 147.8201 | 149.86 | 45371072.0 |
| 2025-01-06 10:00:00 | NVDA | Stock | 149.8513 | 151.99 | 149.66 | 151.55 | 40142951.0 |
| 2025-01-06 11:00:00 | NVDA | Stock | 151.57 | 152.156 | 151.035 | 151.095 | 21859184.0 |
| 2025-01-06 12:00:00 | NVDA | Stock | 151.1 | 151.57 | 150.89 | 151.465 | 16544354.0 |
| 2025-01-06 13:00:00 | NVDA | Stock | 151.465 | 151.85 | 150.4501 | 150.52 | 17854695.0 |
| 2025-01-06 14:00:00 | NVDA | Stock | 150.52 | 150.83 | 149.66 | 149.75 | 18379196.0 |
| 2025-01-06 15:00:00 | NVDA | Stock | 149.74 | 150.83 | 148.255 | 149.5101 | 29720879.0 |
| 2025-01-06 16:00:00 | NVDA | Stock | 149.43 | 149.9197 | 149.2565 | 149.43 | 24722955.0 |
| 2025-01-06 17:00:00 | NVDA | Stock | 149.46 | 150.45 | 149.3 | 150.1 | 1012440.0 |
| 2025-01-06 18:00:00 | NVDA | Stock | 150.11 | 150.39 | 150.05 | 150.27 | 526548.0 |
| 2025-01-06 19:00:00 | NVDA | Stock | 150.28 | 150.48 | 150.15 | 150.2802 | 567249.0 |
| 2025-01-06 04:00:00 | AMZN | Stock | 225.9 | 226.0 | 225.3 | 225.7 | 33120.0 |
| 2025-01-06 05:00:00 | AMZN | Stock | 225.75 | 226.47 | 225.7 | 226.26 | 16452.0 |
> showing 50 of 66,968 rows — these rows as CSV