PREVIEW / stock_1hour / 2025-01-14
file: by_date/stock_1hour/2025/2025-01-14.parquet size: 1.4 MB rows: 63,270 symbols: 580
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-14 04:00:00 | AAPL | Stock | 235.69 | 236.42 | 235.39 | 235.6 | 15443.0 |
| 2025-01-14 05:00:00 | AAPL | Stock | 235.58 | 235.79 | 235.3 | 235.64 | 10803.0 |
| 2025-01-14 06:00:00 | AAPL | Stock | 235.59 | 235.64 | 234.98 | 234.98 | 9892.0 |
| 2025-01-14 07:00:00 | AAPL | Stock | 235.07 | 235.15 | 234.55 | 234.76 | 26456.0 |
| 2025-01-14 08:00:00 | AAPL | Stock | 234.71 | 236.0 | 234.001 | 234.81 | 170649.0 |
| 2025-01-14 09:00:00 | AAPL | Stock | 234.94 | 236.03 | 234.19 | 234.925 | 3364922.0 |
| 2025-01-14 10:00:00 | AAPL | Stock | 234.937 | 236.12 | 234.65 | 234.77 | 3342042.0 |
| 2025-01-14 11:00:00 | AAPL | Stock | 234.78 | 234.8822 | 233.12 | 233.1742 | 2443963.0 |
| 2025-01-14 12:00:00 | AAPL | Stock | 233.165 | 233.57 | 232.65 | 233.03 | 1821084.0 |
| 2025-01-14 13:00:00 | AAPL | Stock | 233.02 | 234.7731 | 232.97 | 234.695 | 1733941.0 |
| 2025-01-14 14:00:00 | AAPL | Stock | 234.71 | 234.92 | 233.05 | 233.15 | 2358754.0 |
| 2025-01-14 15:00:00 | AAPL | Stock | 233.135 | 233.44 | 232.472 | 233.28 | 4821934.0 |
| 2025-01-14 16:00:00 | AAPL | Stock | 233.33 | 234.1777 | 233.1 | 233.85 | 6547220.0 |
| 2025-01-14 17:00:00 | AAPL | Stock | 233.98 | 234.05 | 233.28 | 233.4368 | 30493.0 |
| 2025-01-14 18:00:00 | AAPL | Stock | 233.7 | 233.8 | 233.24 | 233.35 | 13574.0 |
| 2025-01-14 19:00:00 | AAPL | Stock | 233.4 | 233.82 | 233.4 | 233.78 | 21805.0 |
| 2025-01-14 04:00:00 | MSFT | Stock | 419.79 | 420.6 | 419.25 | 419.8 | 14491.0 |
| 2025-01-14 05:00:00 | MSFT | Stock | 419.53 | 419.53 | 419.49 | 419.49 | 300.0 |
| 2025-01-14 06:00:00 | MSFT | Stock | 419.53 | 419.65 | 418.6 | 418.65 | 2736.0 |
| 2025-01-14 07:00:00 | MSFT | Stock | 418.4 | 418.52 | 417.59 | 418.06 | 5876.0 |
| 2025-01-14 08:00:00 | MSFT | Stock | 418.45 | 420.8 | 417.0 | 418.17 | 49863.0 |
| 2025-01-14 09:00:00 | MSFT | Stock | 418.3 | 419.74 | 416.61 | 416.985 | 1125070.0 |
| 2025-01-14 10:00:00 | MSFT | Stock | 417.015 | 418.41 | 415.9 | 416.075 | 1410410.0 |
| 2025-01-14 11:00:00 | MSFT | Stock | 416.135 | 416.58 | 414.3 | 414.395 | 759804.0 |
| 2025-01-14 12:00:00 | MSFT | Stock | 414.395 | 415.6 | 413.91 | 415.0 | 556962.0 |
| 2025-01-14 13:00:00 | MSFT | Stock | 415.0 | 417.61 | 414.91 | 417.18 | 628098.0 |
| 2025-01-14 14:00:00 | MSFT | Stock | 417.1949 | 417.82 | 414.256 | 414.3 | 680546.0 |
| 2025-01-14 15:00:00 | MSFT | Stock | 414.3 | 415.75 | 410.72 | 415.68 | 2927843.0 |
| 2025-01-14 16:00:00 | MSFT | Stock | 415.648 | 416.9751 | 415.16 | 416.49 | 3334542.0 |
| 2025-01-14 17:00:00 | MSFT | Stock | 416.3 | 416.3 | 415.67 | 416.0 | 13736.0 |
| 2025-01-14 18:00:00 | MSFT | Stock | 416.15 | 416.15 | 415.81 | 416.0 | 9494.0 |
| 2025-01-14 19:00:00 | MSFT | Stock | 416.0 | 416.3 | 415.86 | 415.86 | 5904.0 |
| 2025-01-14 04:00:00 | NVDA | Stock | 136.0 | 136.33 | 135.5 | 135.86 | 385992.0 |
| 2025-01-14 05:00:00 | NVDA | Stock | 135.88 | 136.35 | 135.62 | 135.95 | 249924.0 |
| 2025-01-14 06:00:00 | NVDA | Stock | 135.9 | 135.92 | 135.11 | 135.36 | 393669.0 |
| 2025-01-14 07:00:00 | NVDA | Stock | 135.37 | 135.75 | 134.25 | 135.09 | 787627.0 |
| 2025-01-14 08:00:00 | NVDA | Stock | 135.37 | 136.74 | 134.24 | 135.889 | 3168476.0 |
| 2025-01-14 09:00:00 | NVDA | Stock | 135.85 | 136.38 | 133.35 | 133.5044 | 25322592.0 |
| 2025-01-14 10:00:00 | NVDA | Stock | 133.52 | 134.56 | 130.83 | 130.86 | 35191219.0 |
| 2025-01-14 11:00:00 | NVDA | Stock | 130.8501 | 131.59 | 130.32 | 130.5448 | 22112367.0 |
| 2025-01-14 12:00:00 | NVDA | Stock | 130.54 | 131.24 | 130.45 | 131.0199 | 11013064.0 |
| 2025-01-14 13:00:00 | NVDA | Stock | 131.01 | 132.3175 | 130.84 | 132.165 | 14363116.0 |
| 2025-01-14 14:00:00 | NVDA | Stock | 132.16 | 132.36 | 130.42 | 130.48 | 15147072.0 |
| 2025-01-14 15:00:00 | NVDA | Stock | 130.48 | 131.85 | 130.05 | 131.85 | 22092675.0 |
| 2025-01-14 16:00:00 | NVDA | Stock | 131.85 | 132.2 | 131.7401 | 131.9101 | 12496446.0 |
| 2025-01-14 17:00:00 | NVDA | Stock | 131.9497 | 131.9498 | 131.27 | 131.53 | 469933.0 |
| 2025-01-14 18:00:00 | NVDA | Stock | 131.53 | 131.58 | 131.2 | 131.3498 | 476161.0 |
| 2025-01-14 19:00:00 | NVDA | Stock | 131.35 | 131.39 | 131.2 | 131.29 | 302637.0 |
| 2025-01-14 04:00:00 | AMZN | Stock | 220.51 | 220.54 | 219.92 | 220.0 | 15390.0 |
| 2025-01-14 05:00:00 | AMZN | Stock | 219.9 | 220.17 | 219.88 | 219.96 | 2436.0 |
> showing 50 of 63,270 rows — these rows as CSV