PREVIEW / stock_1hour / 2025-01-31
file: by_date/stock_1hour/2025/2025-01-31.parquet size: 1.4 MB rows: 63,603 symbols: 556
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-31 04:00:00 | AAPL | Stock | 244.75 | 245.89 | 244.28 | 245.61 | 99522.0 |
| 2025-01-31 05:00:00 | AAPL | Stock | 245.59 | 245.97 | 245.1 | 245.31 | 34851.0 |
| 2025-01-31 06:00:00 | AAPL | Stock | 245.17 | 246.44 | 245.17 | 245.91 | 105909.0 |
| 2025-01-31 07:00:00 | AAPL | Stock | 245.92 | 247.49 | 245.92 | 247.16 | 324701.0 |
| 2025-01-31 08:00:00 | AAPL | Stock | 246.28 | 248.2299 | 244.01 | 246.79 | 943946.0 |
| 2025-01-31 09:00:00 | AAPL | Stock | 246.79 | 247.87 | 241.35 | 241.605 | 13250156.0 |
| 2025-01-31 10:00:00 | AAPL | Stock | 241.58 | 243.245 | 240.01 | 240.925 | 9592572.0 |
| 2025-01-31 11:00:00 | AAPL | Stock | 240.93 | 241.11 | 238.59 | 238.93 | 6670403.0 |
| 2025-01-31 12:00:00 | AAPL | Stock | 238.945 | 239.82 | 238.3 | 238.31 | 4271128.0 |
| 2025-01-31 13:00:00 | AAPL | Stock | 238.32 | 238.5399 | 235.11 | 235.26 | 6638169.0 |
| 2025-01-31 14:00:00 | AAPL | Stock | 235.28 | 235.93 | 233.44 | 234.11 | 6178269.0 |
| 2025-01-31 15:00:00 | AAPL | Stock | 234.115 | 236.5 | 233.55 | 235.84 | 9189748.0 |
| 2025-01-31 16:00:00 | AAPL | Stock | 235.89 | 236.1 | 234.95 | 235.25 | 12538336.0 |
| 2025-01-31 17:00:00 | AAPL | Stock | 235.27 | 236.0 | 235.03 | 235.2 | 343440.0 |
| 2025-01-31 18:00:00 | AAPL | Stock | 235.2015 | 235.2095 | 234.8 | 234.9202 | 44769.0 |
| 2025-01-31 19:00:00 | AAPL | Stock | 234.92 | 235.0695 | 233.92 | 233.92 | 54485.0 |
| 2025-01-31 04:00:00 | MSFT | Stock | 419.48 | 420.0 | 418.93 | 419.9 | 34171.0 |
| 2025-01-31 05:00:00 | MSFT | Stock | 419.8 | 420.14 | 419.29 | 420.14 | 29676.0 |
| 2025-01-31 06:00:00 | MSFT | Stock | 420.14 | 420.25 | 419.62 | 419.9 | 14096.0 |
| 2025-01-31 07:00:00 | MSFT | Stock | 419.98 | 419.98 | 418.56 | 419.2 | 41540.0 |
| 2025-01-31 08:00:00 | MSFT | Stock | 419.35 | 420.04 | 418.01 | 418.65 | 231899.0 |
| 2025-01-31 09:00:00 | MSFT | Stock | 418.52 | 419.78 | 416.55 | 418.96 | 3336747.0 |
| 2025-01-31 10:00:00 | MSFT | Stock | 419.015 | 420.69 | 416.27 | 417.229 | 3580962.0 |
| 2025-01-31 11:00:00 | MSFT | Stock | 417.18 | 417.68 | 415.23 | 416.6892 | 2322896.0 |
| 2025-01-31 12:00:00 | MSFT | Stock | 416.73 | 418.9088 | 416.6481 | 418.3282 | 1619632.0 |
| 2025-01-31 13:00:00 | MSFT | Stock | 418.34 | 419.17 | 416.22 | 417.0 | 1600596.0 |
| 2025-01-31 14:00:00 | MSFT | Stock | 417.025 | 417.2 | 415.06 | 416.505 | 1685505.0 |
| 2025-01-31 15:00:00 | MSFT | Stock | 416.46 | 417.25 | 414.91 | 415.02 | 3166993.0 |
| 2025-01-31 16:00:00 | MSFT | Stock | 415.06 | 415.5 | 414.6127 | 414.97 | 5565941.0 |
| 2025-01-31 17:00:00 | MSFT | Stock | 414.96 | 415.06 | 414.53 | 414.55 | 33563.0 |
| 2025-01-31 18:00:00 | MSFT | Stock | 414.57 | 414.73 | 414.5 | 414.59 | 15809.0 |
| 2025-01-31 19:00:00 | MSFT | Stock | 414.5944 | 414.66 | 414.09 | 414.1 | 22095.0 |
| 2025-01-31 04:00:00 | NVDA | Stock | 123.09 | 123.89 | 122.8 | 123.5 | 572356.0 |
| 2025-01-31 05:00:00 | NVDA | Stock | 123.52 | 123.65 | 122.75 | 123.02 | 395868.0 |
| 2025-01-31 06:00:00 | NVDA | Stock | 123.02 | 123.66 | 122.83 | 123.16 | 403323.0 |
| 2025-01-31 07:00:00 | NVDA | Stock | 123.19 | 123.2 | 122.59 | 122.96 | 810424.0 |
| 2025-01-31 08:00:00 | NVDA | Stock | 123.12 | 124.92 | 122.35 | 124.58 | 5985016.0 |
| 2025-01-31 09:00:00 | NVDA | Stock | 124.56 | 125.15 | 123.21 | 124.994 | 34738676.0 |
| 2025-01-31 10:00:00 | NVDA | Stock | 124.9999 | 127.14 | 124.9824 | 126.8 | 50526789.0 |
| 2025-01-31 11:00:00 | NVDA | Stock | 126.79 | 127.85 | 124.83 | 125.42 | 42756599.0 |
| 2025-01-31 12:00:00 | NVDA | Stock | 125.43 | 125.96 | 124.06 | 125.8701 | 29722485.0 |
| 2025-01-31 13:00:00 | NVDA | Stock | 125.88 | 125.885 | 123.29 | 123.79 | 28189352.0 |
| 2025-01-31 14:00:00 | NVDA | Stock | 123.825 | 124.01 | 121.25 | 121.86 | 33321994.0 |
| 2025-01-31 15:00:00 | NVDA | Stock | 121.87 | 121.87 | 119.19 | 120.0 | 54317373.0 |
| 2025-01-31 16:00:00 | NVDA | Stock | 120.0 | 120.65 | 119.91 | 120.07 | 21808854.0 |
| 2025-01-31 17:00:00 | NVDA | Stock | 120.0509 | 120.19 | 119.6 | 119.8 | 1195557.0 |
| 2025-01-31 18:00:00 | NVDA | Stock | 119.8 | 120.08 | 119.61 | 119.7196 | 903760.0 |
| 2025-01-31 19:00:00 | NVDA | Stock | 119.7198 | 119.75 | 119.2 | 119.23 | 1055681.0 |
| 2025-01-31 04:00:00 | AMZN | Stock | 235.93 | 236.91 | 235.73 | 236.49 | 25572.0 |
| 2025-01-31 05:00:00 | AMZN | Stock | 236.49 | 236.8 | 236.42 | 236.56 | 7555.0 |
> showing 50 of 63,603 rows — these rows as CSV