PREVIEW / stock_1hour / 2025-01-08
file: by_date/stock_1hour/2025/2025-01-08.parquet size: 1.5 MB rows: 64,753 symbols: 602
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-08 04:00:00 | AAPL | Stock | 242.0 | 242.75 | 242.0 | 242.69 | 8648.0 |
| 2025-01-08 05:00:00 | AAPL | Stock | 242.82 | 242.92 | 242.71 | 242.89 | 2755.0 |
| 2025-01-08 06:00:00 | AAPL | Stock | 242.91 | 242.91 | 241.09 | 241.88 | 18806.0 |
| 2025-01-08 07:00:00 | AAPL | Stock | 241.68 | 241.86 | 240.73 | 240.79 | 55917.0 |
| 2025-01-08 08:00:00 | AAPL | Stock | 241.56 | 243.04 | 240.5 | 242.0 | 109904.0 |
| 2025-01-08 09:00:00 | AAPL | Stock | 242.1 | 242.12 | 240.05 | 240.9286 | 3373281.0 |
| 2025-01-08 10:00:00 | AAPL | Stock | 240.945 | 243.7123 | 240.87 | 243.47 | 3936579.0 |
| 2025-01-08 11:00:00 | AAPL | Stock | 243.48 | 243.67 | 242.64 | 243.275 | 2268518.0 |
| 2025-01-08 12:00:00 | AAPL | Stock | 243.28 | 243.2828 | 241.2 | 241.4 | 2357377.0 |
| 2025-01-08 13:00:00 | AAPL | Stock | 241.39 | 242.52 | 241.125 | 241.422 | 1841926.0 |
| 2025-01-08 14:00:00 | AAPL | Stock | 241.425 | 242.98 | 241.04 | 241.87 | 1912340.0 |
| 2025-01-08 15:00:00 | AAPL | Stock | 241.89 | 242.987 | 241.69 | 242.72 | 3581668.0 |
| 2025-01-08 16:00:00 | AAPL | Stock | 242.72 | 242.92 | 242.0795 | 242.48 | 6567915.0 |
| 2025-01-08 17:00:00 | AAPL | Stock | 242.43 | 242.4799 | 242.3 | 242.4 | 7206.0 |
| 2025-01-08 18:00:00 | AAPL | Stock | 242.43 | 242.59 | 242.16 | 242.16 | 10470.0 |
| 2025-01-08 19:00:00 | AAPL | Stock | 242.31 | 242.51 | 242.19 | 242.4 | 32805.0 |
| 2025-01-08 04:00:00 | MSFT | Stock | 424.0 | 424.83 | 423.63 | 424.35 | 2749.0 |
| 2025-01-08 05:00:00 | MSFT | Stock | 424.66 | 424.73 | 424.51 | 424.73 | 1000.0 |
| 2025-01-08 06:00:00 | MSFT | Stock | 424.84 | 424.95 | 422.33 | 423.96 | 4715.0 |
| 2025-01-08 07:00:00 | MSFT | Stock | 423.73 | 423.73 | 421.41 | 422.23 | 15480.0 |
| 2025-01-08 08:00:00 | MSFT | Stock | 423.1 | 424.45 | 421.41 | 423.87 | 36269.0 |
| 2025-01-08 09:00:00 | MSFT | Stock | 423.81 | 425.86 | 422.79 | 425.72 | 1165957.0 |
| 2025-01-08 10:00:00 | MSFT | Stock | 425.72 | 426.97 | 424.63 | 426.09 | 1204902.0 |
| 2025-01-08 11:00:00 | MSFT | Stock | 426.165 | 426.32 | 424.34 | 424.867 | 652331.0 |
| 2025-01-08 12:00:00 | MSFT | Stock | 424.83 | 424.97 | 421.54 | 422.605 | 724974.0 |
| 2025-01-08 13:00:00 | MSFT | Stock | 422.53 | 424.62 | 422.42 | 423.63 | 474382.0 |
| 2025-01-08 14:00:00 | MSFT | Stock | 423.72 | 425.33 | 423.0201 | 423.48 | 638060.0 |
| 2025-01-08 15:00:00 | MSFT | Stock | 423.51 | 425.14 | 423.05 | 424.7 | 1344380.0 |
| 2025-01-08 16:00:00 | MSFT | Stock | 424.48 | 424.99 | 423.95 | 424.01 | 3263917.0 |
| 2025-01-08 17:00:00 | MSFT | Stock | 424.0001 | 424.25 | 423.9999 | 424.0 | 3460.0 |
| 2025-01-08 18:00:00 | MSFT | Stock | 424.0 | 424.324 | 423.82 | 424.0 | 1100.0 |
| 2025-01-08 19:00:00 | MSFT | Stock | 423.85 | 423.99 | 423.02 | 423.99 | 2730.0 |
| 2025-01-08 04:00:00 | NVDA | Stock | 142.25 | 142.79 | 141.75 | 142.65 | 560754.0 |
| 2025-01-08 05:00:00 | NVDA | Stock | 142.65 | 142.81 | 142.5 | 142.72 | 251277.0 |
| 2025-01-08 06:00:00 | NVDA | Stock | 142.74 | 142.75 | 141.01 | 141.7 | 776155.0 |
| 2025-01-08 07:00:00 | NVDA | Stock | 141.71 | 141.93 | 140.0 | 140.58 | 1570944.0 |
| 2025-01-08 08:00:00 | NVDA | Stock | 141.8 | 142.772 | 140.0415 | 142.14 | 3734900.0 |
| 2025-01-08 09:00:00 | NVDA | Stock | 142.1 | 143.31 | 140.58 | 143.078 | 33157166.0 |
| 2025-01-08 10:00:00 | NVDA | Stock | 143.07 | 143.95 | 137.56 | 140.54 | 38475055.0 |
| 2025-01-08 11:00:00 | NVDA | Stock | 140.54 | 140.92 | 139.43 | 140.385 | 18333941.0 |
| 2025-01-08 12:00:00 | NVDA | Stock | 140.39 | 140.42 | 137.89 | 139.43 | 21320113.0 |
| 2025-01-08 13:00:00 | NVDA | Stock | 139.44 | 140.85 | 139.4 | 140.025 | 17363200.0 |
| 2025-01-08 14:00:00 | NVDA | Stock | 140.03 | 141.02 | 139.56 | 140.14 | 18249755.0 |
| 2025-01-08 15:00:00 | NVDA | Stock | 140.14 | 140.3 | 139.7001 | 140.06 | 16529798.0 |
| 2025-01-08 16:00:00 | NVDA | Stock | 140.11 | 140.6421 | 137.5901 | 138.65 | 15297279.0 |
| 2025-01-08 17:00:00 | NVDA | Stock | 138.65 | 139.16 | 138.5001 | 138.93 | 956309.0 |
| 2025-01-08 18:00:00 | NVDA | Stock | 138.91 | 139.16 | 138.36 | 138.36 | 535283.0 |
| 2025-01-08 19:00:00 | NVDA | Stock | 138.39 | 138.7 | 138.3 | 138.54 | 571083.0 |
| 2025-01-08 04:00:00 | AMZN | Stock | 222.95 | 223.22 | 222.87 | 223.22 | 10477.0 |
| 2025-01-08 05:00:00 | AMZN | Stock | 223.27 | 223.41 | 223.05 | 223.19 | 3451.0 |
> showing 50 of 64,753 rows — these rows as CSV