PREVIEW / stock_1hour / 2024-12-26
file: by_date/stock_1hour/2024/2024-12-26.parquet size: 1.4 MB rows: 63,739 symbols: 613
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 |
|---|---|---|---|---|---|---|---|
| 2024-12-26 04:00:00 | AAPL | Stock | 258.06 | 258.38 | 257.75 | 257.85 | 5448.0 |
| 2024-12-26 05:00:00 | AAPL | Stock | 257.75 | 257.75 | 257.13 | 257.7 | 6045.0 |
| 2024-12-26 06:00:00 | AAPL | Stock | 257.61 | 257.73 | 257.6 | 257.73 | 3130.0 |
| 2024-12-26 07:00:00 | AAPL | Stock | 257.8 | 257.96 | 257.6 | 257.63 | 9650.0 |
| 2024-12-26 08:00:00 | AAPL | Stock | 257.95 | 259.19 | 257.5534 | 257.93 | 70988.0 |
| 2024-12-26 09:00:00 | AAPL | Stock | 257.88 | 260.1 | 257.71 | 258.7899 | 4628778.0 |
| 2024-12-26 10:00:00 | AAPL | Stock | 258.76 | 258.84 | 257.63 | 258.355 | 2969776.0 |
| 2024-12-26 11:00:00 | AAPL | Stock | 258.37 | 259.23 | 258.31 | 258.89 | 1943394.0 |
| 2024-12-26 12:00:00 | AAPL | Stock | 258.8904 | 259.34 | 258.57 | 258.85 | 1460304.0 |
| 2024-12-26 13:00:00 | AAPL | Stock | 258.844 | 259.06 | 258.46 | 258.65 | 1189238.0 |
| 2024-12-26 14:00:00 | AAPL | Stock | 258.62 | 259.1 | 258.41 | 259.09 | 1295559.0 |
| 2024-12-26 15:00:00 | AAPL | Stock | 259.1 | 259.51 | 259.01 | 259.1 | 3099451.0 |
| 2024-12-26 16:00:00 | AAPL | Stock | 259.08 | 259.36 | 258.9 | 258.97 | 4218610.0 |
| 2024-12-26 17:00:00 | AAPL | Stock | 259.01 | 259.04 | 258.9 | 259.02 | 14307.0 |
| 2024-12-26 18:00:00 | AAPL | Stock | 259.02 | 259.12 | 258.9 | 259.12 | 7538.0 |
| 2024-12-26 19:00:00 | AAPL | Stock | 259.12 | 259.12 | 258.81 | 259.06 | 10118.0 |
| 2024-12-26 04:00:00 | MSFT | Stock | 439.91 | 439.95 | 438.24 | 438.24 | 668.0 |
| 2024-12-26 05:00:00 | MSFT | Stock | 437.9 | 437.9 | 437.15 | 437.9 | 1244.0 |
| 2024-12-26 06:00:00 | MSFT | Stock | 437.51 | 438.19 | 437.51 | 438.19 | 3130.0 |
| 2024-12-26 07:00:00 | MSFT | Stock | 438.42 | 438.5 | 438.0 | 438.0 | 3302.0 |
| 2024-12-26 08:00:00 | MSFT | Stock | 438.4985 | 440.9 | 437.25 | 438.25 | 18497.0 |
| 2024-12-26 09:00:00 | MSFT | Stock | 438.163 | 440.94 | 436.63 | 438.2487 | 729898.0 |
| 2024-12-26 10:00:00 | MSFT | Stock | 438.38 | 438.65 | 437.14 | 438.03 | 657055.0 |
| 2024-12-26 11:00:00 | MSFT | Stock | 438.09 | 439.56 | 437.79 | 439.31 | 468367.0 |
| 2024-12-26 12:00:00 | MSFT | Stock | 439.29 | 439.9094 | 438.03 | 438.53 | 466997.0 |
| 2024-12-26 13:00:00 | MSFT | Stock | 438.48 | 439.34 | 438.36 | 438.995 | 324808.0 |
| 2024-12-26 14:00:00 | MSFT | Stock | 438.96 | 439.73 | 438.5614 | 439.6785 | 289406.0 |
| 2024-12-26 15:00:00 | MSFT | Stock | 439.67 | 439.97 | 438.05 | 438.11 | 693964.0 |
| 2024-12-26 16:00:00 | MSFT | Stock | 438.11 | 438.31 | 437.7 | 438.0 | 1802261.0 |
| 2024-12-26 17:00:00 | MSFT | Stock | 438.05 | 438.08 | 437.78 | 438.0 | 4647.0 |
| 2024-12-26 18:00:00 | MSFT | Stock | 437.7651 | 438.09 | 437.7 | 438.09 | 700.0 |
| 2024-12-26 19:00:00 | MSFT | Stock | 437.85 | 437.85 | 437.4596 | 437.4596 | 1204.0 |
| 2024-12-26 04:00:00 | NVDA | Stock | 140.3 | 140.89 | 138.18 | 138.49 | 542296.0 |
| 2024-12-26 05:00:00 | NVDA | Stock | 138.5 | 139.05 | 138.37 | 138.86 | 199033.0 |
| 2024-12-26 06:00:00 | NVDA | Stock | 138.83 | 139.18 | 138.4 | 138.95 | 243571.0 |
| 2024-12-26 07:00:00 | NVDA | Stock | 138.97 | 139.6 | 138.9 | 139.29 | 401783.0 |
| 2024-12-26 08:00:00 | NVDA | Stock | 138.89 | 140.94 | 138.4728 | 139.26 | 1102493.0 |
| 2024-12-26 09:00:00 | NVDA | Stock | 139.26 | 140.85 | 138.41 | 139.02 | 17682737.0 |
| 2024-12-26 10:00:00 | NVDA | Stock | 139.01 | 139.54 | 137.73 | 139.5025 | 20695441.0 |
| 2024-12-26 11:00:00 | NVDA | Stock | 139.5001 | 139.66 | 139.03 | 139.62 | 9952161.0 |
| 2024-12-26 12:00:00 | NVDA | Stock | 139.615 | 140.44 | 139.36 | 139.88 | 11949240.0 |
| 2024-12-26 13:00:00 | NVDA | Stock | 139.875 | 140.4 | 139.75 | 140.1491 | 9584884.0 |
| 2024-12-26 14:00:00 | NVDA | Stock | 140.15 | 140.27 | 139.85 | 140.19 | 7236095.0 |
| 2024-12-26 15:00:00 | NVDA | Stock | 140.195 | 140.29 | 139.8 | 139.91 | 11276490.0 |
| 2024-12-26 16:00:00 | NVDA | Stock | 139.91 | 139.93 | 139.57 | 139.66 | 7965361.0 |
| 2024-12-26 17:00:00 | NVDA | Stock | 139.64 | 139.93 | 139.61 | 139.8 | 106805.0 |
| 2024-12-26 18:00:00 | NVDA | Stock | 139.8 | 139.92 | 139.65 | 139.71 | 150549.0 |
| 2024-12-26 19:00:00 | NVDA | Stock | 139.75 | 139.88 | 139.58 | 139.58 | 173380.0 |
| 2024-12-26 04:00:00 | AMZN | Stock | 228.85 | 229.1 | 228.27 | 228.6 | 6340.0 |
| 2024-12-26 05:00:00 | AMZN | Stock | 228.5 | 228.67 | 228.4 | 228.49 | 1933.0 |
> showing 50 of 63,739 rows — these rows as CSV