PREVIEW / stock_1hour / 2025-01-10
file: by_date/stock_1hour/2025/2025-01-10.parquet size: 1.5 MB rows: 66,038 symbols: 594
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-10 04:00:00 | AAPL | Stock | 243.44 | 244.0 | 241.7 | 242.53 | 12455.0 |
| 2025-01-10 05:00:00 | AAPL | Stock | 242.55 | 242.55 | 242.4 | 242.44 | 5036.0 |
| 2025-01-10 06:00:00 | AAPL | Stock | 242.42 | 242.7 | 242.4 | 242.47 | 10199.0 |
| 2025-01-10 07:00:00 | AAPL | Stock | 242.44 | 242.44 | 242.02 | 242.2 | 24955.0 |
| 2025-01-10 08:00:00 | AAPL | Stock | 242.41 | 242.7 | 240.1 | 241.05 | 139577.0 |
| 2025-01-10 09:00:00 | AAPL | Stock | 240.85 | 241.54 | 237.47 | 237.95 | 6542126.0 |
| 2025-01-10 10:00:00 | AAPL | Stock | 237.88 | 237.915 | 235.47 | 235.91 | 6386252.0 |
| 2025-01-10 11:00:00 | AAPL | Stock | 235.92 | 236.58 | 233.0 | 234.89 | 7460304.0 |
| 2025-01-10 12:00:00 | AAPL | Stock | 234.9 | 235.9 | 234.82 | 235.715 | 3210326.0 |
| 2025-01-10 13:00:00 | AAPL | Stock | 235.715 | 237.59 | 235.64 | 237.44 | 2987046.0 |
| 2025-01-10 14:00:00 | AAPL | Stock | 237.43 | 237.48 | 235.94 | 236.3599 | 2059689.0 |
| 2025-01-10 15:00:00 | AAPL | Stock | 236.35 | 237.29 | 235.75 | 236.93 | 5491300.0 |
| 2025-01-10 16:00:00 | AAPL | Stock | 236.85 | 237.45 | 236.85 | 237.2 | 11407016.0 |
| 2025-01-10 17:00:00 | AAPL | Stock | 237.2 | 237.24 | 237.0 | 237.05 | 14351.0 |
| 2025-01-10 18:00:00 | AAPL | Stock | 237.05 | 237.13 | 237.0 | 237.01 | 6570.0 |
| 2025-01-10 19:00:00 | AAPL | Stock | 236.96 | 237.0399 | 236.95 | 237.02 | 14619.0 |
| 2025-01-10 04:00:00 | MSFT | Stock | 423.6 | 423.6 | 423.08 | 423.5 | 6101.0 |
| 2025-01-10 05:00:00 | MSFT | Stock | 423.56 | 424.06 | 423.56 | 424.0 | 2327.0 |
| 2025-01-10 06:00:00 | MSFT | Stock | 424.12 | 424.59 | 424.11 | 424.25 | 3800.0 |
| 2025-01-10 07:00:00 | MSFT | Stock | 424.36 | 424.6 | 423.9 | 424.13 | 9119.0 |
| 2025-01-10 08:00:00 | MSFT | Stock | 423.62 | 425.0 | 420.33 | 420.8805 | 36406.0 |
| 2025-01-10 09:00:00 | MSFT | Stock | 420.85 | 424.88 | 418.63 | 419.69 | 1846046.0 |
| 2025-01-10 10:00:00 | MSFT | Stock | 419.73 | 419.8899 | 415.02 | 417.96 | 2425498.0 |
| 2025-01-10 11:00:00 | MSFT | Stock | 418.03 | 418.32 | 416.1201 | 416.53 | 1075676.0 |
| 2025-01-10 12:00:00 | MSFT | Stock | 416.55 | 420.39 | 416.15 | 419.84 | 828039.0 |
| 2025-01-10 13:00:00 | MSFT | Stock | 419.84 | 423.32 | 419.32 | 423.12 | 833108.0 |
| 2025-01-10 14:00:00 | MSFT | Stock | 423.12 | 423.24 | 420.37 | 421.15 | 728788.0 |
| 2025-01-10 15:00:00 | MSFT | Stock | 421.08 | 421.73 | 418.8 | 418.91 | 1605029.0 |
| 2025-01-10 16:00:00 | MSFT | Stock | 418.95 | 419.5 | 418.7501 | 418.87 | 4791682.0 |
| 2025-01-10 17:00:00 | MSFT | Stock | 418.8997 | 419.18 | 418.7501 | 418.9 | 7548.0 |
| 2025-01-10 18:00:00 | MSFT | Stock | 418.89 | 419.0 | 418.69 | 418.825 | 4688.0 |
| 2025-01-10 19:00:00 | MSFT | Stock | 419.0 | 419.45 | 418.92 | 419.45 | 3300.0 |
| 2025-01-10 04:00:00 | NVDA | Stock | 139.0 | 139.0 | 138.0 | 138.15 | 453829.0 |
| 2025-01-10 05:00:00 | NVDA | Stock | 138.17 | 139.18 | 137.91 | 138.77 | 447107.0 |
| 2025-01-10 06:00:00 | NVDA | Stock | 138.76 | 139.6 | 138.3 | 139.11 | 295151.0 |
| 2025-01-10 07:00:00 | NVDA | Stock | 139.06 | 139.11 | 137.5 | 138.0 | 1214427.0 |
| 2025-01-10 08:00:00 | NVDA | Stock | 138.96 | 139.49 | 135.33 | 136.4894 | 4895890.0 |
| 2025-01-10 09:00:00 | NVDA | Stock | 136.45 | 138.07 | 134.61 | 135.38 | 33056218.0 |
| 2025-01-10 10:00:00 | NVDA | Stock | 135.4 | 139.92 | 134.22 | 135.62 | 35223965.0 |
| 2025-01-10 11:00:00 | NVDA | Stock | 135.61 | 136.13 | 135.0 | 135.08 | 18520690.0 |
| 2025-01-10 12:00:00 | NVDA | Stock | 135.09 | 136.73 | 135.03 | 136.6538 | 13762311.0 |
| 2025-01-10 13:00:00 | NVDA | Stock | 136.655 | 137.1099 | 136.27 | 137.06 | 13072116.0 |
| 2025-01-10 14:00:00 | NVDA | Stock | 137.07 | 137.0816 | 135.77 | 136.22 | 12273095.0 |
| 2025-01-10 15:00:00 | NVDA | Stock | 136.22 | 136.4667 | 135.42 | 135.86 | 18242384.0 |
| 2025-01-10 16:00:00 | NVDA | Stock | 135.86 | 136.09 | 135.82 | 135.9999 | 20935531.0 |
| 2025-01-10 17:00:00 | NVDA | Stock | 135.99 | 136.05 | 135.81 | 135.81 | 224009.0 |
| 2025-01-10 18:00:00 | NVDA | Stock | 135.8 | 135.83 | 135.72 | 135.77 | 160532.0 |
| 2025-01-10 19:00:00 | NVDA | Stock | 135.8 | 135.8 | 135.6 | 135.61 | 237549.0 |
| 2025-01-10 04:00:00 | AMZN | Stock | 221.4 | 221.4 | 220.99 | 221.24 | 10389.0 |
| 2025-01-10 05:00:00 | AMZN | Stock | 221.28 | 221.55 | 221.27 | 221.45 | 4462.0 |
> showing 50 of 66,038 rows — these rows as CSV