PREVIEW / stock_1hour / 2025-04-04
file: by_date/stock_1hour/2025/2025-04-04.parquet size: 1.5 MB rows: 67,386 symbols: 452
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-04-04 04:00:00 | AAPL | Stock | 203.11 | 203.46 | 201.79 | 201.9 | 59805.0 |
| 2025-04-04 05:00:00 | AAPL | Stock | 201.86 | 201.96 | 200.83 | 201.23 | 81292.0 |
| 2025-04-04 06:00:00 | AAPL | Stock | 201.23 | 201.4 | 192.82 | 192.82 | 701384.0 |
| 2025-04-04 07:00:00 | AAPL | Stock | 192.92 | 195.06 | 190.33 | 194.15 | 807937.0 |
| 2025-04-04 08:00:00 | AAPL | Stock | 193.57 | 203.15 | 190.3502 | 194.78 | 1256928.0 |
| 2025-04-04 09:00:00 | AAPL | Stock | 194.7235 | 199.88 | 192.77 | 199.235 | 14999961.0 |
| 2025-04-04 10:00:00 | AAPL | Stock | 199.27 | 199.31 | 191.06 | 193.48 | 14459594.0 |
| 2025-04-04 11:00:00 | AAPL | Stock | 193.45 | 197.2117 | 193.35 | 194.165 | 9379080.0 |
| 2025-04-04 12:00:00 | AAPL | Stock | 194.163 | 195.07 | 192.18 | 192.96 | 5861037.0 |
| 2025-04-04 13:00:00 | AAPL | Stock | 192.93 | 193.54 | 190.66 | 191.68 | 7723003.0 |
| 2025-04-04 14:00:00 | AAPL | Stock | 191.66 | 192.54 | 187.34 | 188.88 | 8065612.0 |
| 2025-04-04 15:00:00 | AAPL | Stock | 188.87 | 191.73 | 188.014 | 188.38 | 15634403.0 |
| 2025-04-04 16:00:00 | AAPL | Stock | 188.38 | 188.639 | 187.24 | 187.9 | 14574149.0 |
| 2025-04-04 17:00:00 | AAPL | Stock | 187.9 | 188.2 | 187.5 | 187.77 | 74211.0 |
| 2025-04-04 18:00:00 | AAPL | Stock | 187.8 | 187.87 | 187.2501 | 187.2501 | 69389.0 |
| 2025-04-04 19:00:00 | AAPL | Stock | 187.28 | 187.3334 | 186.44 | 186.6 | 132163.0 |
| 2025-04-04 04:00:00 | MSFT | Stock | 370.0 | 370.85 | 369.49 | 369.75 | 8056.0 |
| 2025-04-04 05:00:00 | MSFT | Stock | 369.49 | 370.25 | 369.1 | 369.32 | 5706.0 |
| 2025-04-04 06:00:00 | MSFT | Stock | 369.59 | 369.59 | 355.18 | 355.4 | 76718.0 |
| 2025-04-04 07:00:00 | MSFT | Stock | 356.18 | 359.84 | 355.0 | 359.46 | 122852.0 |
| 2025-04-04 08:00:00 | MSFT | Stock | 357.7 | 371.62 | 355.0 | 365.29 | 268609.0 |
| 2025-04-04 09:00:00 | MSFT | Stock | 366.0 | 373.11 | 362.86 | 372.47 | 4380960.0 |
| 2025-04-04 10:00:00 | MSFT | Stock | 372.52 | 374.59 | 365.511 | 367.9397 | 5052156.0 |
| 2025-04-04 11:00:00 | MSFT | Stock | 367.92 | 372.85 | 366.29 | 367.145 | 3238036.0 |
| 2025-04-04 12:00:00 | MSFT | Stock | 367.15 | 369.29 | 363.02 | 364.56 | 1921404.0 |
| 2025-04-04 13:00:00 | MSFT | Stock | 364.52 | 366.42 | 362.85 | 365.57 | 1784394.0 |
| 2025-04-04 14:00:00 | MSFT | Stock | 365.64 | 366.68 | 360.09 | 360.95 | 2147529.0 |
| 2025-04-04 15:00:00 | MSFT | Stock | 360.87 | 365.93 | 359.48 | 359.72 | 4913792.0 |
| 2025-04-04 16:00:00 | MSFT | Stock | 359.84 | 360.35 | 358.0 | 359.4 | 7795233.0 |
| 2025-04-04 17:00:00 | MSFT | Stock | 359.4 | 359.83 | 359.01 | 359.8 | 19867.0 |
| 2025-04-04 18:00:00 | MSFT | Stock | 359.8 | 360.0 | 359.27 | 359.27 | 12973.0 |
| 2025-04-04 19:00:00 | MSFT | Stock | 359.19 | 359.75 | 358.17 | 359.75 | 15410.0 |
| 2025-04-04 04:00:00 | NVDA | Stock | 101.6 | 102.65 | 101.25 | 102.3 | 670848.0 |
| 2025-04-04 05:00:00 | NVDA | Stock | 102.33 | 102.4 | 101.56 | 101.95 | 375574.0 |
| 2025-04-04 06:00:00 | NVDA | Stock | 101.98 | 102.25 | 96.88 | 97.77 | 4362388.0 |
| 2025-04-04 07:00:00 | NVDA | Stock | 97.78 | 98.55 | 95.36 | 97.42 | 4683418.0 |
| 2025-04-04 08:00:00 | NVDA | Stock | 97.0 | 102.513 | 95.36 | 98.56 | 8419569.0 |
| 2025-04-04 09:00:00 | NVDA | Stock | 98.54 | 100.13 | 96.21 | 97.635 | 63186284.0 |
| 2025-04-04 10:00:00 | NVDA | Stock | 97.65 | 97.86 | 92.11 | 94.18 | 85851722.0 |
| 2025-04-04 11:00:00 | NVDA | Stock | 94.18 | 96.57 | 93.63 | 94.6588 | 59345865.0 |
| 2025-04-04 12:00:00 | NVDA | Stock | 94.66 | 95.74 | 93.24 | 94.0876 | 35670055.0 |
| 2025-04-04 13:00:00 | NVDA | Stock | 94.08 | 95.74 | 93.3901 | 95.7291 | 33361483.0 |
| 2025-04-04 14:00:00 | NVDA | Stock | 95.73 | 96.1299 | 93.2649 | 93.93 | 39878391.0 |
| 2025-04-04 15:00:00 | NVDA | Stock | 93.93 | 96.38 | 93.6988 | 94.28 | 66619371.0 |
| 2025-04-04 16:00:00 | NVDA | Stock | 94.32 | 94.42 | 93.46 | 93.95 | 38059385.0 |
| 2025-04-04 17:00:00 | NVDA | Stock | 93.9501 | 94.05 | 93.7 | 93.81 | 1011021.0 |
| 2025-04-04 18:00:00 | NVDA | Stock | 93.82 | 93.82 | 93.12 | 93.15 | 738592.0 |
| 2025-04-04 19:00:00 | NVDA | Stock | 93.15 | 93.31 | 92.5498 | 92.6 | 1390321.0 |
| 2025-04-04 04:00:00 | AMZN | Stock | 177.73 | 178.32 | 176.65 | 176.65 | 53405.0 |
| 2025-04-04 05:00:00 | AMZN | Stock | 176.78 | 176.87 | 175.89 | 175.93 | 31774.0 |
> showing 50 of 67,386 rows — these rows as CSV