PREVIEW / stock_1hour / 2025-06-25
file: by_date/stock_1hour/2025/2025-06-25.parquet size: 1.4 MB rows: 61,640 symbols: 390
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-25 04:00:00 | AAPL | Stock | 201.0 | 201.25 | 200.86 | 201.25 | 12540.0 |
| 2025-06-25 05:00:00 | AAPL | Stock | 201.25 | 201.31 | 201.09 | 201.21 | 8261.0 |
| 2025-06-25 06:00:00 | AAPL | Stock | 201.15 | 201.71 | 201.09 | 201.18 | 26976.0 |
| 2025-06-25 07:00:00 | AAPL | Stock | 201.17 | 201.24 | 200.92 | 201.21 | 39019.0 |
| 2025-06-25 08:00:00 | AAPL | Stock | 201.1 | 201.5 | 199.8 | 201.39 | 174502.0 |
| 2025-06-25 09:00:00 | AAPL | Stock | 201.39 | 203.67 | 201.05 | 201.8 | 5872736.0 |
| 2025-06-25 10:00:00 | AAPL | Stock | 201.76 | 203.175 | 201.24 | 202.455 | 4756279.0 |
| 2025-06-25 11:00:00 | AAPL | Stock | 202.44 | 202.56 | 201.8276 | 201.98 | 2535104.0 |
| 2025-06-25 12:00:00 | AAPL | Stock | 201.99 | 202.1999 | 201.4 | 202.055 | 2005119.0 |
| 2025-06-25 13:00:00 | AAPL | Stock | 202.06 | 202.09 | 200.6201 | 200.9999 | 2668663.0 |
| 2025-06-25 14:00:00 | AAPL | Stock | 201.0 | 201.5 | 200.8558 | 201.07 | 1634432.0 |
| 2025-06-25 15:00:00 | AAPL | Stock | 201.07 | 201.62 | 200.885 | 201.6 | 4149905.0 |
| 2025-06-25 16:00:00 | AAPL | Stock | 201.56 | 201.74 | 201.1501 | 201.4 | 4654246.0 |
| 2025-06-25 17:00:00 | AAPL | Stock | 201.42 | 201.52 | 201.29 | 201.29 | 22637.0 |
| 2025-06-25 18:00:00 | AAPL | Stock | 201.3 | 201.4991 | 201.27 | 201.39 | 19129.0 |
| 2025-06-25 19:00:00 | AAPL | Stock | 201.4 | 201.74 | 201.33 | 201.74 | 39695.0 |
| 2025-06-25 04:00:00 | MSFT | Stock | 490.07 | 490.07 | 489.59 | 489.94 | 2426.0 |
| 2025-06-25 05:00:00 | MSFT | Stock | 489.77 | 489.77 | 488.93 | 489.19 | 1066.0 |
| 2025-06-25 06:00:00 | MSFT | Stock | 489.34 | 493.61 | 489.34 | 491.5 | 29048.0 |
| 2025-06-25 07:00:00 | MSFT | Stock | 491.19 | 491.7 | 491.03 | 491.32 | 5966.0 |
| 2025-06-25 08:00:00 | MSFT | Stock | 491.7 | 492.64 | 488.885 | 491.981 | 36457.0 |
| 2025-06-25 09:00:00 | MSFT | Stock | 491.85 | 494.1504 | 491.03 | 493.54 | 1624542.0 |
| 2025-06-25 10:00:00 | MSFT | Stock | 493.455 | 494.5556 | 492.75 | 492.9575 | 1241586.0 |
| 2025-06-25 11:00:00 | MSFT | Stock | 492.92 | 493.1 | 491.56 | 491.72 | 810764.0 |
| 2025-06-25 12:00:00 | MSFT | Stock | 491.71 | 491.91 | 490.21 | 490.73 | 732747.0 |
| 2025-06-25 13:00:00 | MSFT | Stock | 490.74 | 491.0 | 489.39 | 490.475 | 589033.0 |
| 2025-06-25 14:00:00 | MSFT | Stock | 490.485 | 491.23 | 490.09 | 490.705 | 764585.0 |
| 2025-06-25 15:00:00 | MSFT | Stock | 490.705 | 492.44 | 490.66 | 492.44 | 1940689.0 |
| 2025-06-25 16:00:00 | MSFT | Stock | 492.43 | 492.62 | 491.8 | 492.4499 | 2670758.0 |
| 2025-06-25 17:00:00 | MSFT | Stock | 490.11 | 492.8 | 490.11 | 492.64 | 15753.0 |
| 2025-06-25 18:00:00 | MSFT | Stock | 492.6 | 493.35 | 492.3642 | 492.96 | 7239.0 |
| 2025-06-25 19:00:00 | MSFT | Stock | 492.9 | 492.9 | 492.3534 | 492.5 | 5407.0 |
| 2025-06-25 04:00:00 | NVDA | Stock | 148.0 | 148.0 | 147.5 | 147.67 | 257056.0 |
| 2025-06-25 05:00:00 | NVDA | Stock | 147.66 | 147.95 | 147.55 | 147.75 | 139931.0 |
| 2025-06-25 06:00:00 | NVDA | Stock | 147.76 | 148.74 | 147.55 | 148.67 | 583568.0 |
| 2025-06-25 07:00:00 | NVDA | Stock | 148.65 | 149.55 | 148.37 | 149.45 | 1114744.0 |
| 2025-06-25 08:00:00 | NVDA | Stock | 148.69 | 149.65 | 147.531 | 149.61 | 2493568.0 |
| 2025-06-25 09:00:00 | NVDA | Stock | 149.6099 | 151.8755 | 147.9 | 151.4 | 48806767.0 |
| 2025-06-25 10:00:00 | NVDA | Stock | 151.38 | 153.0 | 150.9 | 152.8199 | 38154260.0 |
| 2025-06-25 11:00:00 | NVDA | Stock | 152.82 | 152.85 | 151.47 | 151.525 | 21017794.0 |
| 2025-06-25 12:00:00 | NVDA | Stock | 151.52 | 152.88 | 151.39 | 152.855 | 15054460.0 |
| 2025-06-25 13:00:00 | NVDA | Stock | 152.86 | 153.95 | 152.69 | 153.595 | 29047106.0 |
| 2025-06-25 14:00:00 | NVDA | Stock | 153.6 | 154.01 | 153.36 | 153.71 | 18565994.0 |
| 2025-06-25 15:00:00 | NVDA | Stock | 153.715 | 154.45 | 153.335 | 154.31 | 34211145.0 |
| 2025-06-25 16:00:00 | NVDA | Stock | 154.31 | 155.0 | 154.1861 | 154.6 | 16620355.0 |
| 2025-06-25 17:00:00 | NVDA | Stock | 154.6101 | 154.76 | 154.18 | 154.28 | 599530.0 |
| 2025-06-25 18:00:00 | NVDA | Stock | 154.29 | 154.64 | 154.2814 | 154.54 | 330019.0 |
| 2025-06-25 19:00:00 | NVDA | Stock | 154.53 | 154.67 | 154.35 | 154.5902 | 422798.0 |
| 2025-06-25 04:00:00 | AMZN | Stock | 213.35 | 218.0 | 213.35 | 214.19 | 30764.0 |
| 2025-06-25 05:00:00 | AMZN | Stock | 214.33 | 214.65 | 214.23 | 214.23 | 6599.0 |
> showing 50 of 61,640 rows — these rows as CSV