PREVIEW / stock_1hour / 2025-06-26
file: by_date/stock_1hour/2025/2025-06-26.parquet size: 1.4 MB rows: 62,138 symbols: 387
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-06-26 04:00:00 | AAPL | Stock | 202.0 | 202.72 | 202.0 | 202.72 | 23929.0 |
| 2025-06-26 05:00:00 | AAPL | Stock | 202.71 | 202.71 | 202.21 | 202.3 | 7433.0 |
| 2025-06-26 06:00:00 | AAPL | Stock | 202.38 | 202.4 | 200.39 | 201.54 | 93601.0 |
| 2025-06-26 07:00:00 | AAPL | Stock | 201.54 | 201.64 | 201.07 | 201.52 | 55830.0 |
| 2025-06-26 08:00:00 | AAPL | Stock | 201.58 | 202.7 | 200.87 | 201.25 | 198117.0 |
| 2025-06-26 09:00:00 | AAPL | Stock | 201.2 | 202.64 | 199.66 | 201.0 | 5774386.0 |
| 2025-06-26 10:00:00 | AAPL | Stock | 201.02 | 201.35 | 199.65 | 200.2799 | 5314052.0 |
| 2025-06-26 11:00:00 | AAPL | Stock | 200.3 | 200.51 | 199.46 | 200.0 | 4010892.0 |
| 2025-06-26 12:00:00 | AAPL | Stock | 199.995 | 200.79 | 199.82 | 199.99 | 3343506.0 |
| 2025-06-26 13:00:00 | AAPL | Stock | 200.0 | 200.71 | 199.635 | 200.63 | 3381113.0 |
| 2025-06-26 14:00:00 | AAPL | Stock | 200.64 | 201.36 | 200.43 | 201.0388 | 3724217.0 |
| 2025-06-26 15:00:00 | AAPL | Stock | 201.035 | 201.56 | 200.75 | 200.94 | 6114323.0 |
| 2025-06-26 16:00:00 | AAPL | Stock | 201.01 | 201.04 | 200.5 | 201.0 | 6830353.0 |
| 2025-06-26 17:00:00 | AAPL | Stock | 200.95 | 201.2 | 200.9392 | 201.1282 | 40834.0 |
| 2025-06-26 18:00:00 | AAPL | Stock | 201.15 | 201.35 | 201.04 | 201.2 | 47151.0 |
| 2025-06-26 19:00:00 | AAPL | Stock | 201.18 | 201.3 | 201.0 | 201.28 | 45600.0 |
| 2025-06-26 04:00:00 | MSFT | Stock | 493.48 | 494.1 | 493.37 | 493.58 | 4011.0 |
| 2025-06-26 05:00:00 | MSFT | Stock | 493.87 | 494.18 | 493.68 | 493.68 | 2899.0 |
| 2025-06-26 06:00:00 | MSFT | Stock | 493.79 | 494.11 | 493.79 | 493.9 | 1023.0 |
| 2025-06-26 07:00:00 | MSFT | Stock | 493.9 | 494.45 | 493.9 | 494.2 | 3025.0 |
| 2025-06-26 08:00:00 | MSFT | Stock | 493.96 | 494.5 | 491.04 | 494.0 | 25109.0 |
| 2025-06-26 09:00:00 | MSFT | Stock | 493.76 | 496.025 | 492.86 | 495.97 | 1332070.0 |
| 2025-06-26 10:00:00 | MSFT | Stock | 495.97 | 496.96 | 493.455 | 493.52 | 1428387.0 |
| 2025-06-26 11:00:00 | MSFT | Stock | 493.46 | 494.42 | 492.81 | 494.16 | 893168.0 |
| 2025-06-26 12:00:00 | MSFT | Stock | 494.165 | 495.61 | 493.78 | 495.57 | 694799.0 |
| 2025-06-26 13:00:00 | MSFT | Stock | 495.57 | 496.66 | 495.26 | 496.43 | 738595.0 |
| 2025-06-26 14:00:00 | MSFT | Stock | 496.43 | 498.04 | 496.39 | 497.31 | 1148615.0 |
| 2025-06-26 15:00:00 | MSFT | Stock | 497.285 | 497.99 | 496.38 | 497.31 | 3196397.0 |
| 2025-06-26 16:00:00 | MSFT | Stock | 497.45 | 497.67 | 495.65 | 496.47 | 3496643.0 |
| 2025-06-26 17:00:00 | MSFT | Stock | 496.69 | 497.49 | 496.51 | 497.49 | 6402.0 |
| 2025-06-26 18:00:00 | MSFT | Stock | 497.14 | 497.55 | 497.0 | 497.55 | 4641.0 |
| 2025-06-26 19:00:00 | MSFT | Stock | 497.5 | 497.5 | 496.91 | 497.2 | 2033.0 |
| 2025-06-26 04:00:00 | NVDA | Stock | 155.87 | 155.94 | 155.49 | 155.88 | 592641.0 |
| 2025-06-26 05:00:00 | NVDA | Stock | 155.88 | 156.27 | 155.86 | 155.98 | 571018.0 |
| 2025-06-26 06:00:00 | NVDA | Stock | 156.0 | 156.2 | 155.8 | 155.9 | 399328.0 |
| 2025-06-26 07:00:00 | NVDA | Stock | 155.89 | 156.81 | 155.58 | 156.81 | 1189156.0 |
| 2025-06-26 08:00:00 | NVDA | Stock | 155.82 | 157.0 | 153.74 | 156.34 | 3946159.0 |
| 2025-06-26 09:00:00 | NVDA | Stock | 156.34 | 156.36 | 153.49 | 155.77 | 33537716.0 |
| 2025-06-26 10:00:00 | NVDA | Stock | 155.77 | 156.715 | 155.22 | 155.49 | 32071444.0 |
| 2025-06-26 11:00:00 | NVDA | Stock | 155.49 | 156.05 | 154.79 | 155.3735 | 18464734.0 |
| 2025-06-26 12:00:00 | NVDA | Stock | 155.37 | 155.7299 | 155.115 | 155.49 | 11811771.0 |
| 2025-06-26 13:00:00 | NVDA | Stock | 155.48 | 156.19 | 155.31 | 155.945 | 13015790.0 |
| 2025-06-26 14:00:00 | NVDA | Stock | 155.94 | 156.5 | 155.66 | 155.8301 | 13383315.0 |
| 2025-06-26 15:00:00 | NVDA | Stock | 155.835 | 155.95 | 154.85 | 155.08 | 20279936.0 |
| 2025-06-26 16:00:00 | NVDA | Stock | 155.08 | 155.11 | 154.7 | 154.9685 | 10522559.0 |
| 2025-06-26 17:00:00 | NVDA | Stock | 154.95 | 155.33 | 154.91 | 155.22 | 326285.0 |
| 2025-06-26 18:00:00 | NVDA | Stock | 155.2 | 155.36 | 155.15 | 155.35 | 209385.0 |
| 2025-06-26 19:00:00 | NVDA | Stock | 155.32 | 155.42 | 155.21 | 155.35 | 375974.0 |
| 2025-06-26 04:00:00 | AMZN | Stock | 212.6 | 213.4 | 212.6 | 213.23 | 10305.0 |
| 2025-06-26 05:00:00 | AMZN | Stock | 213.2 | 213.38 | 213.16 | 213.36 | 10655.0 |
> showing 50 of 62,138 rows — these rows as CSV