PREVIEW / stock_1hour / 2025-04-08
file: by_date/stock_1hour/2025/2025-04-08.parquet size: 1.4 MB rows: 64,494 symbols: 453
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-08 04:00:00 | AAPL | Stock | 183.88 | 184.85 | 182.71 | 184.26 | 77534.0 |
| 2025-04-08 05:00:00 | AAPL | Stock | 184.22 | 184.99 | 183.83 | 183.85 | 89545.0 |
| 2025-04-08 06:00:00 | AAPL | Stock | 183.9 | 184.32 | 183.26 | 183.73 | 42275.0 |
| 2025-04-08 07:00:00 | AAPL | Stock | 183.75 | 185.75 | 182.67 | 185.52 | 202219.0 |
| 2025-04-08 08:00:00 | AAPL | Stock | 183.5 | 186.34 | 181.6 | 185.45 | 573229.0 |
| 2025-04-08 09:00:00 | AAPL | Stock | 185.32 | 188.56 | 185.09 | 188.0 | 11799164.0 |
| 2025-04-08 10:00:00 | AAPL | Stock | 188.0 | 190.335 | 186.18 | 186.2 | 10338044.0 |
| 2025-04-08 11:00:00 | AAPL | Stock | 186.215 | 186.94 | 183.03 | 184.47 | 7236575.0 |
| 2025-04-08 12:00:00 | AAPL | Stock | 184.48 | 184.8682 | 178.9409 | 179.1685 | 8471901.0 |
| 2025-04-08 13:00:00 | AAPL | Stock | 179.15 | 179.6 | 174.82 | 178.15 | 10857467.0 |
| 2025-04-08 14:00:00 | AAPL | Stock | 178.16 | 178.21 | 174.52 | 174.59 | 7727322.0 |
| 2025-04-08 15:00:00 | AAPL | Stock | 174.58 | 174.888 | 169.2101 | 172.77 | 18527900.0 |
| 2025-04-08 16:00:00 | AAPL | Stock | 172.868 | 175.0 | 171.6032 | 175.0 | 11390898.0 |
| 2025-04-08 17:00:00 | AAPL | Stock | 175.0 | 175.49 | 172.51 | 172.9 | 205309.0 |
| 2025-04-08 18:00:00 | AAPL | Stock | 172.88 | 172.9 | 170.0 | 170.85 | 232748.0 |
| 2025-04-08 19:00:00 | AAPL | Stock | 170.95 | 171.01 | 169.1 | 169.45 | 207483.0 |
| 2025-04-08 04:00:00 | MSFT | Stock | 364.37 | 364.88 | 360.67 | 361.24 | 37572.0 |
| 2025-04-08 05:00:00 | MSFT | Stock | 361.29 | 361.3 | 357.73 | 357.73 | 22791.0 |
| 2025-04-08 06:00:00 | MSFT | Stock | 357.5 | 359.48 | 356.6 | 359.1 | 29376.0 |
| 2025-04-08 07:00:00 | MSFT | Stock | 359.35 | 363.01 | 358.76 | 363.0 | 47072.0 |
| 2025-04-08 08:00:00 | MSFT | Stock | 359.0 | 364.9 | 350.88 | 364.89 | 152959.0 |
| 2025-04-08 09:00:00 | MSFT | Stock | 364.38 | 372.39 | 364.0034 | 371.73 | 3687526.0 |
| 2025-04-08 10:00:00 | MSFT | Stock | 371.76 | 373.65 | 368.92 | 369.41 | 2884412.0 |
| 2025-04-08 11:00:00 | MSFT | Stock | 369.405 | 370.1319 | 365.71 | 366.96 | 1613735.0 |
| 2025-04-08 12:00:00 | MSFT | Stock | 366.87 | 366.87 | 360.115 | 360.82 | 1728803.0 |
| 2025-04-08 13:00:00 | MSFT | Stock | 360.82 | 362.64 | 358.14 | 361.13 | 1853312.0 |
| 2025-04-08 14:00:00 | MSFT | Stock | 361.145 | 361.71 | 357.41 | 358.87 | 1567546.0 |
| 2025-04-08 15:00:00 | MSFT | Stock | 358.82 | 359.1125 | 350.25 | 355.57 | 4342063.0 |
| 2025-04-08 16:00:00 | MSFT | Stock | 354.56 | 370.05 | 352.0481 | 354.6505 | 4561267.0 |
| 2025-04-08 17:00:00 | MSFT | Stock | 354.75 | 355.59 | 354.28 | 355.59 | 28877.0 |
| 2025-04-08 18:00:00 | MSFT | Stock | 352.028 | 352.91 | 350.6 | 351.9888 | 13064.0 |
| 2025-04-08 19:00:00 | MSFT | Stock | 351.5629 | 351.9828 | 349.1 | 351.43 | 10633.0 |
| 2025-04-08 04:00:00 | NVDA | Stock | 100.6 | 101.22 | 98.93 | 100.52 | 1613724.0 |
| 2025-04-08 05:00:00 | NVDA | Stock | 100.51 | 100.58 | 99.9 | 100.04 | 705274.0 |
| 2025-04-08 06:00:00 | NVDA | Stock | 100.01 | 100.47 | 99.55 | 100.0 | 839693.0 |
| 2025-04-08 07:00:00 | NVDA | Stock | 100.0 | 102.12 | 99.97 | 101.9 | 3281313.0 |
| 2025-04-08 08:00:00 | NVDA | Stock | 101.88 | 102.33 | 97.84 | 102.17 | 5795591.0 |
| 2025-04-08 09:00:00 | NVDA | Stock | 102.15 | 105.1 | 102.1 | 104.57 | 66379245.0 |
| 2025-04-08 10:00:00 | NVDA | Stock | 104.56 | 105.85 | 103.28 | 103.32 | 61265353.0 |
| 2025-04-08 11:00:00 | NVDA | Stock | 103.32 | 104.3657 | 101.36 | 102.675 | 52046988.0 |
| 2025-04-08 12:00:00 | NVDA | Stock | 102.675 | 102.72 | 99.38 | 99.62 | 45003407.0 |
| 2025-04-08 13:00:00 | NVDA | Stock | 99.62 | 101.0 | 98.58 | 100.3398 | 36948498.0 |
| 2025-04-08 14:00:00 | NVDA | Stock | 100.33 | 101.0 | 98.3 | 98.455 | 31948174.0 |
| 2025-04-08 15:00:00 | NVDA | Stock | 98.455 | 98.66 | 94.46 | 96.71 | 65685852.0 |
| 2025-04-08 16:00:00 | NVDA | Stock | 96.73 | 97.36 | 95.94 | 96.32 | 24789322.0 |
| 2025-04-08 17:00:00 | NVDA | Stock | 96.34 | 97.17 | 96.01 | 96.74 | 863123.0 |
| 2025-04-08 18:00:00 | NVDA | Stock | 96.72 | 96.79 | 94.56 | 94.83 | 1343309.0 |
| 2025-04-08 19:00:00 | NVDA | Stock | 94.82 | 94.8514 | 92.59 | 93.3101 | 1935629.0 |
| 2025-04-08 04:00:00 | AMZN | Stock | 179.0 | 180.46 | 178.17 | 179.51 | 99694.0 |
| 2025-04-08 05:00:00 | AMZN | Stock | 179.52 | 179.55 | 178.24 | 178.24 | 40608.0 |
> showing 50 of 64,494 rows — these rows as CSV