PREVIEW / stock_1hour / 2025-06-20
file: by_date/stock_1hour/2025/2025-06-20.parquet size: 1.4 MB rows: 62,567 symbols: 399
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-20 04:00:00 | AAPL | Stock | 196.0 | 196.5 | 195.7 | 195.73 | 20844.0 |
| 2025-06-20 05:00:00 | AAPL | Stock | 195.71 | 196.11 | 195.71 | 196.1 | 23066.0 |
| 2025-06-20 06:00:00 | AAPL | Stock | 196.08 | 196.11 | 195.9 | 195.95 | 9615.0 |
| 2025-06-20 07:00:00 | AAPL | Stock | 195.94 | 196.7 | 195.84 | 196.6 | 36999.0 |
| 2025-06-20 08:00:00 | AAPL | Stock | 196.01 | 197.48 | 195.77 | 197.39 | 143099.0 |
| 2025-06-20 09:00:00 | AAPL | Stock | 197.38 | 200.95 | 196.91 | 199.845 | 16164092.0 |
| 2025-06-20 10:00:00 | AAPL | Stock | 199.84 | 199.94 | 197.035 | 197.2798 | 4992588.0 |
| 2025-06-20 11:00:00 | AAPL | Stock | 197.26 | 199.0 | 196.855 | 198.08 | 4678944.0 |
| 2025-06-20 12:00:00 | AAPL | Stock | 198.07 | 198.9391 | 197.9 | 198.81 | 2816510.0 |
| 2025-06-20 13:00:00 | AAPL | Stock | 198.81 | 199.41 | 198.07 | 199.14 | 3241547.0 |
| 2025-06-20 14:00:00 | AAPL | Stock | 199.145 | 200.19 | 199.1129 | 199.71 | 4145813.0 |
| 2025-06-20 15:00:00 | AAPL | Stock | 199.71 | 201.7 | 199.6001 | 200.92 | 11404020.0 |
| 2025-06-20 16:00:00 | AAPL | Stock | 200.92 | 201.55 | 200.47 | 200.6 | 22964980.0 |
| 2025-06-20 17:00:00 | AAPL | Stock | 200.5619 | 201.51 | 200.5619 | 201.4 | 213471.0 |
| 2025-06-20 18:00:00 | AAPL | Stock | 201.4 | 201.7885 | 201.4 | 201.7 | 120779.0 |
| 2025-06-20 19:00:00 | AAPL | Stock | 201.71 | 201.71 | 201.12 | 201.2901 | 72596.0 |
| 2025-06-20 04:00:00 | MSFT | Stock | 480.08 | 480.08 | 478.61 | 478.61 | 4673.0 |
| 2025-06-20 05:00:00 | MSFT | Stock | 478.03 | 479.02 | 478.0 | 479.02 | 2489.0 |
| 2025-06-20 06:00:00 | MSFT | Stock | 478.9 | 479.1 | 478.66 | 479.1 | 1450.0 |
| 2025-06-20 07:00:00 | MSFT | Stock | 478.86 | 480.34 | 478.86 | 479.75 | 7284.0 |
| 2025-06-20 08:00:00 | MSFT | Stock | 479.14 | 481.14 | 477.88 | 480.95 | 31540.0 |
| 2025-06-20 09:00:00 | MSFT | Stock | 480.93 | 483.84 | 478.08 | 480.67 | 6207140.0 |
| 2025-06-20 10:00:00 | MSFT | Stock | 480.66 | 481.438 | 479.14 | 479.93 | 1195066.0 |
| 2025-06-20 11:00:00 | MSFT | Stock | 479.83 | 481.08 | 478.9 | 480.025 | 681342.0 |
| 2025-06-20 12:00:00 | MSFT | Stock | 480.025 | 480.65 | 479.38 | 480.2 | 729733.0 |
| 2025-06-20 13:00:00 | MSFT | Stock | 480.21 | 481.42 | 478.12 | 478.54 | 661985.0 |
| 2025-06-20 14:00:00 | MSFT | Stock | 478.53 | 479.1899 | 477.36 | 477.56 | 621698.0 |
| 2025-06-20 15:00:00 | MSFT | Stock | 477.51 | 478.8 | 476.87 | 477.2275 | 2015867.0 |
| 2025-06-20 16:00:00 | MSFT | Stock | 477.16 | 478.4 | 477.15 | 477.58 | 10490081.0 |
| 2025-06-20 17:00:00 | MSFT | Stock | 477.5 | 477.5006 | 477.4 | 477.4 | 224541.0 |
| 2025-06-20 18:00:00 | MSFT | Stock | 477.6 | 477.7997 | 477.0 | 477.6 | 5445.0 |
| 2025-06-20 19:00:00 | MSFT | Stock | 477.7967 | 477.7967 | 477.7967 | 477.7967 | 920.0 |
| 2025-06-20 04:00:00 | NVDA | Stock | 145.0 | 145.19 | 144.5 | 144.56 | 290896.0 |
| 2025-06-20 05:00:00 | NVDA | Stock | 144.56 | 145.01 | 144.55 | 144.82 | 207542.0 |
| 2025-06-20 06:00:00 | NVDA | Stock | 144.85 | 144.98 | 144.7 | 144.9 | 133992.0 |
| 2025-06-20 07:00:00 | NVDA | Stock | 144.9 | 145.3 | 144.8 | 145.1 | 694426.0 |
| 2025-06-20 08:00:00 | NVDA | Stock | 144.92 | 145.5899 | 144.54 | 145.57 | 1419116.0 |
| 2025-06-20 09:00:00 | NVDA | Stock | 145.58 | 146.2 | 144.96 | 145.675 | 37327226.0 |
| 2025-06-20 10:00:00 | NVDA | Stock | 145.67 | 145.75 | 142.71 | 143.1482 | 30789128.0 |
| 2025-06-20 11:00:00 | NVDA | Stock | 143.14 | 144.47 | 142.65 | 143.82 | 18096513.0 |
| 2025-06-20 12:00:00 | NVDA | Stock | 143.81 | 144.34 | 143.79 | 144.15 | 11164659.0 |
| 2025-06-20 13:00:00 | NVDA | Stock | 144.145 | 144.33 | 143.22 | 143.8601 | 11063291.0 |
| 2025-06-20 14:00:00 | NVDA | Stock | 143.865 | 144.32 | 143.6 | 143.6745 | 9697859.0 |
| 2025-06-20 15:00:00 | NVDA | Stock | 143.68 | 144.0 | 143.07 | 143.78 | 19694741.0 |
| 2025-06-20 16:00:00 | NVDA | Stock | 143.85 | 144.13 | 143.7 | 143.73 | 39507557.0 |
| 2025-06-20 17:00:00 | NVDA | Stock | 143.7492 | 143.85 | 143.48 | 143.5801 | 337494.0 |
| 2025-06-20 18:00:00 | NVDA | Stock | 143.58 | 143.73 | 143.56 | 143.62 | 103137.0 |
| 2025-06-20 19:00:00 | NVDA | Stock | 143.6101 | 143.75 | 143.58 | 143.611 | 199887.0 |
| 2025-06-20 04:00:00 | AMZN | Stock | 212.71 | 212.96 | 211.9 | 211.9 | 17370.0 |
| 2025-06-20 05:00:00 | AMZN | Stock | 212.04 | 212.46 | 211.9 | 212.46 | 9975.0 |
> showing 50 of 62,567 rows — these rows as CSV