PREVIEW / stock_1hour / 2025-06-30
file: by_date/stock_1hour/2025/2025-06-30.parquet size: 1.5 MB rows: 64,536 symbols: 393
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-30 04:00:00 | AAPL | Stock | 202.0 | 202.32 | 201.69 | 202.09 | 22556.0 |
| 2025-06-30 05:00:00 | AAPL | Stock | 202.08 | 202.47 | 202.08 | 202.21 | 11731.0 |
| 2025-06-30 06:00:00 | AAPL | Stock | 202.25 | 202.51 | 202.25 | 202.5 | 18762.0 |
| 2025-06-30 07:00:00 | AAPL | Stock | 202.48 | 202.74 | 202.34 | 202.4 | 42606.0 |
| 2025-06-30 08:00:00 | AAPL | Stock | 202.4 | 202.74 | 200.578 | 201.9 | 206565.0 |
| 2025-06-30 09:00:00 | AAPL | Stock | 201.92 | 202.19 | 200.5501 | 200.76 | 4415657.0 |
| 2025-06-30 10:00:00 | AAPL | Stock | 200.755 | 201.3711 | 199.5901 | 199.97 | 6108706.0 |
| 2025-06-30 11:00:00 | AAPL | Stock | 199.97 | 200.2853 | 199.63 | 200.035 | 3730264.0 |
| 2025-06-30 12:00:00 | AAPL | Stock | 200.04 | 200.48 | 199.845 | 200.12 | 2728694.0 |
| 2025-06-30 13:00:00 | AAPL | Stock | 200.12 | 200.34 | 199.9 | 200.27 | 2952618.0 |
| 2025-06-30 14:00:00 | AAPL | Stock | 200.275 | 202.68 | 199.2607 | 201.9195 | 8455080.0 |
| 2025-06-30 15:00:00 | AAPL | Stock | 201.91 | 207.39 | 201.885 | 205.12 | 26783841.0 |
| 2025-06-30 16:00:00 | AAPL | Stock | 205.06 | 206.3 | 204.66 | 205.45 | 14988086.0 |
| 2025-06-30 17:00:00 | AAPL | Stock | 205.26 | 205.62 | 205.13 | 205.4 | 135921.0 |
| 2025-06-30 18:00:00 | AAPL | Stock | 205.41 | 205.5 | 205.0 | 205.2451 | 143525.0 |
| 2025-06-30 19:00:00 | AAPL | Stock | 205.2 | 205.96 | 205.17 | 205.44 | 142440.0 |
| 2025-06-30 04:00:00 | MSFT | Stock | 497.51 | 497.9 | 497.5 | 497.73 | 812.0 |
| 2025-06-30 05:00:00 | MSFT | Stock | 497.75 | 498.66 | 497.75 | 498.2 | 1870.0 |
| 2025-06-30 06:00:00 | MSFT | Stock | 498.68 | 498.85 | 498.68 | 498.84 | 1376.0 |
| 2025-06-30 07:00:00 | MSFT | Stock | 498.75 | 499.0 | 498.5 | 498.6 | 10302.0 |
| 2025-06-30 08:00:00 | MSFT | Stock | 498.75 | 499.1799 | 494.701 | 497.5 | 37176.0 |
| 2025-06-30 09:00:00 | MSFT | Stock | 497.7 | 498.34 | 495.58 | 496.875 | 1274712.0 |
| 2025-06-30 10:00:00 | MSFT | Stock | 496.875 | 497.02 | 495.33 | 496.56 | 1351187.0 |
| 2025-06-30 11:00:00 | MSFT | Stock | 496.64 | 499.31 | 496.49 | 498.57 | 1305440.0 |
| 2025-06-30 12:00:00 | MSFT | Stock | 498.59 | 499.18 | 497.73 | 498.035 | 963800.0 |
| 2025-06-30 13:00:00 | MSFT | Stock | 498.035 | 498.13 | 496.94 | 497.565 | 618667.0 |
| 2025-06-30 14:00:00 | MSFT | Stock | 497.56 | 498.85 | 497.28 | 498.7775 | 716343.0 |
| 2025-06-30 15:00:00 | MSFT | Stock | 498.75 | 500.76 | 497.16 | 497.16 | 2780779.0 |
| 2025-06-30 16:00:00 | MSFT | Stock | 497.14 | 497.61 | 496.99 | 497.35 | 7822054.0 |
| 2025-06-30 17:00:00 | MSFT | Stock | 497.35 | 497.35 | 497.15 | 497.2 | 5148.0 |
| 2025-06-30 18:00:00 | MSFT | Stock | 497.3455 | 497.35 | 497.17 | 497.17 | 991.0 |
| 2025-06-30 19:00:00 | MSFT | Stock | 497.18 | 497.6523 | 497.15 | 497.35 | 4566.0 |
| 2025-06-30 04:00:00 | NVDA | Stock | 158.8 | 159.28 | 158.45 | 158.72 | 316812.0 |
| 2025-06-30 05:00:00 | NVDA | Stock | 158.72 | 159.09 | 158.72 | 158.81 | 229465.0 |
| 2025-06-30 06:00:00 | NVDA | Stock | 158.81 | 159.0 | 158.67 | 158.67 | 146357.0 |
| 2025-06-30 07:00:00 | NVDA | Stock | 158.65 | 158.85 | 158.35 | 158.45 | 417691.0 |
| 2025-06-30 08:00:00 | NVDA | Stock | 158.44 | 159.42 | 158.33 | 158.4002 | 1444562.0 |
| 2025-06-30 09:00:00 | NVDA | Stock | 158.41 | 158.9 | 155.96 | 156.63 | 24768806.0 |
| 2025-06-30 10:00:00 | NVDA | Stock | 156.62 | 157.5 | 156.53 | 157.42 | 19646459.0 |
| 2025-06-30 11:00:00 | NVDA | Stock | 157.43 | 158.27 | 156.755 | 158.0799 | 17343142.0 |
| 2025-06-30 12:00:00 | NVDA | Stock | 158.07 | 158.11 | 157.5642 | 157.99 | 10995065.0 |
| 2025-06-30 13:00:00 | NVDA | Stock | 158.0 | 158.17 | 157.59 | 157.83 | 9566028.0 |
| 2025-06-30 14:00:00 | NVDA | Stock | 157.82 | 158.025 | 156.84 | 157.745 | 12156784.0 |
| 2025-06-30 15:00:00 | NVDA | Stock | 157.75 | 158.66 | 157.67 | 157.87 | 22897224.0 |
| 2025-06-30 16:00:00 | NVDA | Stock | 157.87 | 158.23 | 157.4 | 157.79 | 25200944.0 |
| 2025-06-30 17:00:00 | NVDA | Stock | 157.751 | 157.85 | 157.71 | 157.79 | 178203.0 |
| 2025-06-30 18:00:00 | NVDA | Stock | 157.75 | 157.8 | 157.5 | 157.53 | 182666.0 |
| 2025-06-30 19:00:00 | NVDA | Stock | 157.52 | 157.62 | 157.49 | 157.52 | 182096.0 |
| 2025-06-30 04:00:00 | AMZN | Stock | 225.0 | 225.01 | 224.0 | 224.64 | 51694.0 |
| 2025-06-30 05:00:00 | AMZN | Stock | 224.64 | 225.04 | 224.27 | 224.35 | 29476.0 |
> showing 50 of 64,536 rows — these rows as CSV