PREVIEW / stock_1hour / 2025-06-23
file: by_date/stock_1hour/2025/2025-06-23.parquet size: 1.5 MB rows: 64,341 symbols: 396
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-23 04:00:00 | AAPL | Stock | 200.3 | 202.0 | 200.06 | 201.76 | 61007.0 |
| 2025-06-23 05:00:00 | AAPL | Stock | 201.71 | 201.76 | 200.97 | 200.97 | 25937.0 |
| 2025-06-23 06:00:00 | AAPL | Stock | 200.91 | 201.39 | 200.64 | 200.88 | 35375.0 |
| 2025-06-23 07:00:00 | AAPL | Stock | 200.89 | 201.17 | 200.35 | 201.08 | 49164.0 |
| 2025-06-23 08:00:00 | AAPL | Stock | 200.95 | 201.782 | 199.57 | 201.56 | 225291.0 |
| 2025-06-23 09:00:00 | AAPL | Stock | 201.53 | 202.05 | 199.94 | 201.73 | 5669671.0 |
| 2025-06-23 10:00:00 | AAPL | Stock | 201.72 | 202.3 | 200.38 | 200.46 | 5073274.0 |
| 2025-06-23 11:00:00 | AAPL | Stock | 200.465 | 200.875 | 199.51 | 199.88 | 3867391.0 |
| 2025-06-23 12:00:00 | AAPL | Stock | 199.88 | 200.54 | 198.96 | 199.71 | 3264087.0 |
| 2025-06-23 13:00:00 | AAPL | Stock | 199.72 | 201.82 | 199.58 | 201.23 | 3271830.0 |
| 2025-06-23 14:00:00 | AAPL | Stock | 201.25 | 202.24 | 201.235 | 201.43 | 2813503.0 |
| 2025-06-23 15:00:00 | AAPL | Stock | 201.42 | 201.84 | 201.0507 | 201.55 | 4205625.0 |
| 2025-06-23 16:00:00 | AAPL | Stock | 201.55 | 201.64 | 201.3 | 201.4 | 10729780.0 |
| 2025-06-23 17:00:00 | AAPL | Stock | 201.3608 | 201.37 | 201.15 | 201.311 | 21428.0 |
| 2025-06-23 18:00:00 | AAPL | Stock | 201.2701 | 202.49 | 201.27 | 202.38 | 161030.0 |
| 2025-06-23 19:00:00 | AAPL | Stock | 202.26 | 202.5968 | 202.17 | 202.38 | 68836.0 |
| 2025-06-23 04:00:00 | MSFT | Stock | 475.0 | 478.33 | 475.0 | 477.82 | 2892.0 |
| 2025-06-23 05:00:00 | MSFT | Stock | 477.77 | 477.81 | 477.5 | 477.5 | 2143.0 |
| 2025-06-23 06:00:00 | MSFT | Stock | 477.19 | 477.78 | 476.6 | 476.96 | 2752.0 |
| 2025-06-23 07:00:00 | MSFT | Stock | 476.74 | 476.96 | 476.03 | 476.96 | 4659.0 |
| 2025-06-23 08:00:00 | MSFT | Stock | 476.27 | 477.81 | 475.06 | 477.14 | 22173.0 |
| 2025-06-23 09:00:00 | MSFT | Stock | 477.01 | 478.21 | 472.51 | 475.39 | 1761126.0 |
| 2025-06-23 10:00:00 | MSFT | Stock | 475.415 | 477.13 | 475.27 | 476.91 | 1711098.0 |
| 2025-06-23 11:00:00 | MSFT | Stock | 476.92 | 481.3 | 476.86 | 480.09 | 1656574.0 |
| 2025-06-23 12:00:00 | MSFT | Stock | 480.065 | 481.8599 | 478.7 | 481.02 | 1405714.0 |
| 2025-06-23 13:00:00 | MSFT | Stock | 481.04 | 487.59 | 480.56 | 486.7928 | 2281827.0 |
| 2025-06-23 14:00:00 | MSFT | Stock | 486.865 | 487.75 | 485.7984 | 486.1 | 1282460.0 |
| 2025-06-23 15:00:00 | MSFT | Stock | 486.04 | 487.0999 | 485.0 | 485.92 | 1869895.0 |
| 2025-06-23 16:00:00 | MSFT | Stock | 486.0 | 486.0 | 485.05 | 485.7 | 4464935.0 |
| 2025-06-23 17:00:00 | MSFT | Stock | 485.5956 | 486.0 | 485.57 | 485.99 | 12213.0 |
| 2025-06-23 18:00:00 | MSFT | Stock | 486.0 | 489.0 | 486.0 | 488.7169 | 18524.0 |
| 2025-06-23 19:00:00 | MSFT | Stock | 488.82 | 490.0 | 488.82 | 488.95 | 6327.0 |
| 2025-06-23 04:00:00 | NVDA | Stock | 143.15 | 143.8 | 142.45 | 143.38 | 378702.0 |
| 2025-06-23 05:00:00 | NVDA | Stock | 143.39 | 143.56 | 142.95 | 142.95 | 206843.0 |
| 2025-06-23 06:00:00 | NVDA | Stock | 142.96 | 143.38 | 142.68 | 142.88 | 268284.0 |
| 2025-06-23 07:00:00 | NVDA | Stock | 142.91 | 143.1 | 142.1 | 142.52 | 460025.0 |
| 2025-06-23 08:00:00 | NVDA | Stock | 142.52 | 143.69 | 142.1 | 142.82 | 1812075.0 |
| 2025-06-23 09:00:00 | NVDA | Stock | 142.8001 | 143.85 | 142.01 | 143.5796 | 18694328.0 |
| 2025-06-23 10:00:00 | NVDA | Stock | 143.585 | 144.3 | 143.53 | 143.795 | 17155798.0 |
| 2025-06-23 11:00:00 | NVDA | Stock | 143.8 | 144.24 | 143.57 | 143.795 | 11388807.0 |
| 2025-06-23 12:00:00 | NVDA | Stock | 143.8 | 143.905 | 142.03 | 143.21 | 18294640.0 |
| 2025-06-23 13:00:00 | NVDA | Stock | 143.22 | 144.78 | 143.04 | 144.32 | 16897996.0 |
| 2025-06-23 14:00:00 | NVDA | Stock | 144.315 | 144.515 | 143.88 | 144.04 | 9902256.0 |
| 2025-06-23 15:00:00 | NVDA | Stock | 144.04 | 144.46 | 143.66 | 144.175 | 15690160.0 |
| 2025-06-23 16:00:00 | NVDA | Stock | 144.18 | 144.28 | 143.86 | 143.9491 | 10632434.0 |
| 2025-06-23 17:00:00 | NVDA | Stock | 143.95 | 144.05 | 143.9 | 144.05 | 159088.0 |
| 2025-06-23 18:00:00 | NVDA | Stock | 143.98 | 145.22 | 143.96 | 145.07 | 1453825.0 |
| 2025-06-23 19:00:00 | NVDA | Stock | 145.05 | 145.5 | 145.0401 | 145.4998 | 775078.0 |
| 2025-06-23 04:00:00 | AMZN | Stock | 209.58 | 210.78 | 209.58 | 210.35 | 23267.0 |
| 2025-06-23 05:00:00 | AMZN | Stock | 210.25 | 210.5 | 210.02 | 210.15 | 13553.0 |
> showing 50 of 64,341 rows — these rows as CSV