PREVIEW / stock_1hour / 2025-04-17
file: by_date/stock_1hour/2025/2025-04-17.parquet size: 1.4 MB rows: 60,307 symbols: 434
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-04-17 04:00:00 | AAPL | Stock | 196.5 | 197.15 | 196.36 | 196.37 | 35063.0 |
| 2025-04-17 05:00:00 | AAPL | Stock | 196.3 | 196.61 | 196.08 | 196.48 | 18316.0 |
| 2025-04-17 06:00:00 | AAPL | Stock | 196.47 | 196.58 | 195.86 | 195.95 | 22048.0 |
| 2025-04-17 07:00:00 | AAPL | Stock | 195.94 | 196.2 | 195.2 | 195.98 | 35983.0 |
| 2025-04-17 08:00:00 | AAPL | Stock | 195.76 | 198.0 | 195.2 | 197.28 | 174342.0 |
| 2025-04-17 09:00:00 | AAPL | Stock | 197.43 | 197.43 | 194.64 | 196.08 | 6544832.0 |
| 2025-04-17 10:00:00 | AAPL | Stock | 196.1 | 197.095 | 194.42 | 195.7826 | 5225797.0 |
| 2025-04-17 11:00:00 | AAPL | Stock | 195.79 | 197.08 | 195.43 | 196.11 | 3519285.0 |
| 2025-04-17 12:00:00 | AAPL | Stock | 196.12 | 198.57 | 196.08 | 198.17 | 3775365.0 |
| 2025-04-17 13:00:00 | AAPL | Stock | 198.16 | 198.39 | 196.67 | 197.81 | 2772574.0 |
| 2025-04-17 14:00:00 | AAPL | Stock | 197.82 | 198.8335 | 197.3763 | 197.395 | 3189919.0 |
| 2025-04-17 15:00:00 | AAPL | Stock | 197.4 | 197.77 | 195.81 | 196.87 | 5057621.0 |
| 2025-04-17 16:00:00 | AAPL | Stock | 196.98 | 198.0 | 196.93 | 197.32 | 7883407.0 |
| 2025-04-17 17:00:00 | AAPL | Stock | 197.59 | 197.6 | 196.98 | 197.38 | 48523.0 |
| 2025-04-17 18:00:00 | AAPL | Stock | 197.5291 | 197.5291 | 197.0 | 197.1 | 8810.0 |
| 2025-04-17 19:00:00 | AAPL | Stock | 197.199 | 197.4 | 197.0102 | 197.25 | 19758.0 |
| 2025-04-17 04:00:00 | MSFT | Stock | 375.29 | 375.62 | 372.7 | 373.0 | 10660.0 |
| 2025-04-17 05:00:00 | MSFT | Stock | 373.0 | 375.0 | 373.0 | 374.58 | 13259.0 |
| 2025-04-17 06:00:00 | MSFT | Stock | 374.21 | 374.6 | 373.0 | 373.1 | 13450.0 |
| 2025-04-17 07:00:00 | MSFT | Stock | 373.47 | 373.5 | 372.04 | 372.69 | 15593.0 |
| 2025-04-17 08:00:00 | MSFT | Stock | 372.5 | 375.1 | 371.61 | 372.63 | 44804.0 |
| 2025-04-17 09:00:00 | MSFT | Stock | 372.68 | 374.79 | 370.5 | 372.37 | 2718489.0 |
| 2025-04-17 10:00:00 | MSFT | Stock | 372.37 | 372.51 | 368.625 | 369.7544 | 1171389.0 |
| 2025-04-17 11:00:00 | MSFT | Stock | 369.71 | 372.5 | 369.09 | 370.85 | 919939.0 |
| 2025-04-17 12:00:00 | MSFT | Stock | 370.89 | 372.53 | 369.78 | 371.485 | 945751.0 |
| 2025-04-17 13:00:00 | MSFT | Stock | 371.515 | 371.92 | 370.3 | 371.0 | 641680.0 |
| 2025-04-17 14:00:00 | MSFT | Stock | 370.99 | 371.8347 | 369.38 | 369.39 | 1192460.0 |
| 2025-04-17 15:00:00 | MSFT | Stock | 369.4375 | 369.68 | 366.89 | 367.6 | 2497164.0 |
| 2025-04-17 16:00:00 | MSFT | Stock | 367.6 | 369.0 | 367.5 | 368.0 | 3512886.0 |
| 2025-04-17 17:00:00 | MSFT | Stock | 368.15 | 368.3989 | 367.81 | 368.08 | 5278.0 |
| 2025-04-17 18:00:00 | MSFT | Stock | 367.9 | 368.19 | 367.7876 | 367.788 | 1814.0 |
| 2025-04-17 19:00:00 | MSFT | Stock | 368.1 | 368.28 | 367.85 | 368.16 | 3347.0 |
| 2025-04-17 04:00:00 | NVDA | Stock | 105.95 | 106.05 | 105.21 | 105.32 | 777245.0 |
| 2025-04-17 05:00:00 | NVDA | Stock | 105.33 | 105.98 | 105.3 | 105.64 | 383970.0 |
| 2025-04-17 06:00:00 | NVDA | Stock | 105.62 | 105.76 | 104.63 | 104.77 | 608782.0 |
| 2025-04-17 07:00:00 | NVDA | Stock | 104.77 | 104.89 | 104.21 | 104.87 | 677399.0 |
| 2025-04-17 08:00:00 | NVDA | Stock | 104.88 | 106.48 | 104.2101 | 104.8 | 4519736.0 |
| 2025-04-17 09:00:00 | NVDA | Stock | 104.8 | 104.8 | 102.03 | 102.915 | 37452330.0 |
| 2025-04-17 10:00:00 | NVDA | Stock | 102.915 | 103.06 | 100.12 | 100.14 | 52180148.0 |
| 2025-04-17 11:00:00 | NVDA | Stock | 100.15 | 101.33 | 100.05 | 100.2717 | 33217939.0 |
| 2025-04-17 12:00:00 | NVDA | Stock | 100.275 | 101.71 | 100.16 | 101.5515 | 29613258.0 |
| 2025-04-17 13:00:00 | NVDA | Stock | 101.55 | 101.84 | 100.79 | 101.485 | 21186634.0 |
| 2025-04-17 14:00:00 | NVDA | Stock | 101.485 | 102.49 | 101.421 | 101.421 | 24519572.0 |
| 2025-04-17 15:00:00 | NVDA | Stock | 101.425 | 101.82 | 100.845 | 101.42 | 32009768.0 |
| 2025-04-17 16:00:00 | NVDA | Stock | 101.4 | 101.7 | 101.235 | 101.3983 | 15815104.0 |
| 2025-04-17 17:00:00 | NVDA | Stock | 101.38 | 101.66 | 101.17 | 101.2018 | 612005.0 |
| 2025-04-17 18:00:00 | NVDA | Stock | 101.24 | 101.26 | 101.03 | 101.13 | 377729.0 |
| 2025-04-17 19:00:00 | NVDA | Stock | 101.13 | 101.38 | 101.06 | 101.2703 | 431322.0 |
| 2025-04-17 04:00:00 | AMZN | Stock | 176.29 | 176.53 | 175.7 | 175.79 | 12929.0 |
| 2025-04-17 05:00:00 | AMZN | Stock | 175.6 | 176.41 | 175.6 | 176.38 | 13085.0 |
> showing 50 of 60,307 rows — these rows as CSV