PREVIEW / stock_1hour / 2025-05-06
file: by_date/stock_1hour/2025/2025-05-06.parquet size: 1.4 MB rows: 62,217 symbols: 422
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-05-06 04:00:00 | AAPL | Stock | 198.65 | 198.65 | 197.48 | 197.84 | 29473.0 |
| 2025-05-06 05:00:00 | AAPL | Stock | 197.8 | 197.8 | 197.3 | 197.53 | 16367.0 |
| 2025-05-06 06:00:00 | AAPL | Stock | 197.57 | 197.93 | 197.55 | 197.8 | 15436.0 |
| 2025-05-06 07:00:00 | AAPL | Stock | 197.99 | 198.21 | 197.3 | 197.74 | 50927.0 |
| 2025-05-06 08:00:00 | AAPL | Stock | 197.59 | 198.93 | 197.3 | 197.75 | 105044.0 |
| 2025-05-06 09:00:00 | AAPL | Stock | 197.7899 | 199.88 | 197.02 | 197.65 | 5727978.0 |
| 2025-05-06 10:00:00 | AAPL | Stock | 197.655 | 199.51 | 197.655 | 198.3 | 5015350.0 |
| 2025-05-06 11:00:00 | AAPL | Stock | 198.2715 | 199.45 | 197.95 | 198.805 | 3508008.0 |
| 2025-05-06 12:00:00 | AAPL | Stock | 198.83 | 200.65 | 198.705 | 199.505 | 3369582.0 |
| 2025-05-06 13:00:00 | AAPL | Stock | 199.52 | 200.03 | 198.69 | 199.01 | 2376010.0 |
| 2025-05-06 14:00:00 | AAPL | Stock | 199.03 | 199.85 | 198.8 | 199.85 | 2322589.0 |
| 2025-05-06 15:00:00 | AAPL | Stock | 199.84 | 200.17 | 198.37 | 198.41 | 4673720.0 |
| 2025-05-06 16:00:00 | AAPL | Stock | 198.41 | 199.13 | 197.5 | 198.2 | 6834301.0 |
| 2025-05-06 17:00:00 | AAPL | Stock | 198.0647 | 198.29 | 197.5595 | 197.8 | 57036.0 |
| 2025-05-06 18:00:00 | AAPL | Stock | 197.96 | 201.5 | 197.96 | 201.37 | 447637.0 |
| 2025-05-06 19:00:00 | AAPL | Stock | 201.38 | 201.5 | 200.9 | 201.15 | 111910.0 |
| 2025-05-06 04:00:00 | MSFT | Stock | 432.79 | 433.62 | 431.16 | 432.03 | 11126.0 |
| 2025-05-06 05:00:00 | MSFT | Stock | 431.9 | 433.0 | 431.82 | 433.0 | 10790.0 |
| 2025-05-06 06:00:00 | MSFT | Stock | 433.1 | 433.65 | 432.8 | 433.18 | 2505.0 |
| 2025-05-06 07:00:00 | MSFT | Stock | 433.94 | 434.5 | 432.0 | 432.32 | 10203.0 |
| 2025-05-06 08:00:00 | MSFT | Stock | 432.0 | 435.0 | 432.0 | 433.6 | 29852.0 |
| 2025-05-06 09:00:00 | MSFT | Stock | 433.45 | 435.13 | 430.92 | 433.5375 | 1505202.0 |
| 2025-05-06 10:00:00 | MSFT | Stock | 433.51 | 436.19 | 432.73 | 435.665 | 1421566.0 |
| 2025-05-06 11:00:00 | MSFT | Stock | 435.63 | 436.75 | 435.36 | 435.88 | 680014.0 |
| 2025-05-06 12:00:00 | MSFT | Stock | 435.89 | 437.73 | 435.07 | 435.71 | 656674.0 |
| 2025-05-06 13:00:00 | MSFT | Stock | 435.78 | 436.77 | 434.35 | 434.62 | 726073.0 |
| 2025-05-06 14:00:00 | MSFT | Stock | 434.61 | 436.01 | 434.43 | 435.69 | 535408.0 |
| 2025-05-06 15:00:00 | MSFT | Stock | 435.66 | 435.77 | 433.22 | 433.29 | 1301610.0 |
| 2025-05-06 16:00:00 | MSFT | Stock | 433.31 | 434.16 | 431.18 | 432.62 | 2749760.0 |
| 2025-05-06 17:00:00 | MSFT | Stock | 432.69 | 432.8 | 432.48 | 432.5 | 20035.0 |
| 2025-05-06 18:00:00 | MSFT | Stock | 432.65 | 439.33 | 432.65 | 436.5 | 25698.0 |
| 2025-05-06 19:00:00 | MSFT | Stock | 436.0 | 436.7499 | 435.52 | 436.0 | 7792.0 |
| 2025-05-06 04:00:00 | NVDA | Stock | 113.1 | 113.26 | 112.33 | 112.6 | 301039.0 |
| 2025-05-06 05:00:00 | NVDA | Stock | 112.59 | 112.59 | 112.24 | 112.51 | 257142.0 |
| 2025-05-06 06:00:00 | NVDA | Stock | 112.51 | 112.7 | 112.42 | 112.62 | 91027.0 |
| 2025-05-06 07:00:00 | NVDA | Stock | 112.59 | 112.75 | 112.021 | 112.27 | 460498.0 |
| 2025-05-06 08:00:00 | NVDA | Stock | 112.68 | 113.4 | 112.04 | 112.32 | 1061812.0 |
| 2025-05-06 09:00:00 | NVDA | Stock | 112.31 | 112.32 | 110.822 | 111.1 | 20898882.0 |
| 2025-05-06 10:00:00 | NVDA | Stock | 111.11 | 113.25 | 110.9203 | 112.715 | 25947595.0 |
| 2025-05-06 11:00:00 | NVDA | Stock | 112.71 | 113.16 | 112.5637 | 112.73 | 10885493.0 |
| 2025-05-06 12:00:00 | NVDA | Stock | 112.72 | 113.79 | 112.6 | 112.63 | 14115995.0 |
| 2025-05-06 13:00:00 | NVDA | Stock | 112.63 | 113.12 | 112.61 | 112.875 | 9410294.0 |
| 2025-05-06 14:00:00 | NVDA | Stock | 112.88 | 114.12 | 112.88 | 114.0501 | 13623091.0 |
| 2025-05-06 15:00:00 | NVDA | Stock | 114.05 | 114.74 | 113.38 | 113.45 | 20213317.0 |
| 2025-05-06 16:00:00 | NVDA | Stock | 113.45 | 114.28 | 112.95 | 113.49 | 13057518.0 |
| 2025-05-06 17:00:00 | NVDA | Stock | 113.45 | 113.6393 | 112.02 | 112.27 | 1131288.0 |
| 2025-05-06 18:00:00 | NVDA | Stock | 112.27 | 114.62 | 112.2518 | 114.5 | 1920194.0 |
| 2025-05-06 19:00:00 | NVDA | Stock | 114.5 | 114.59 | 114.13 | 114.5 | 506984.0 |
| 2025-05-06 04:00:00 | AMZN | Stock | 185.9 | 185.9 | 184.39 | 184.69 | 19873.0 |
| 2025-05-06 05:00:00 | AMZN | Stock | 184.92 | 184.92 | 184.33 | 184.57 | 14949.0 |
> showing 50 of 62,217 rows — these rows as CSV