PREVIEW / stock_1hour / 2025-06-17
file: by_date/stock_1hour/2025/2025-06-17.parquet size: 1.4 MB rows: 61,887 symbols: 397
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-17 04:00:00 | AAPL | Stock | 197.51 | 197.7 | 197.4 | 197.4 | 12358.0 |
| 2025-06-17 05:00:00 | AAPL | Stock | 197.69 | 197.71 | 197.24 | 197.4 | 8686.0 |
| 2025-06-17 06:00:00 | AAPL | Stock | 197.37 | 197.51 | 197.16 | 197.5 | 20383.0 |
| 2025-06-17 07:00:00 | AAPL | Stock | 197.52 | 197.79 | 197.5 | 197.7 | 15666.0 |
| 2025-06-17 08:00:00 | AAPL | Stock | 197.52 | 197.98 | 197.2 | 197.49 | 87654.0 |
| 2025-06-17 09:00:00 | AAPL | Stock | 197.45 | 197.93 | 196.255 | 196.82 | 3972171.0 |
| 2025-06-17 10:00:00 | AAPL | Stock | 196.82 | 197.91 | 196.69 | 197.3801 | 3159900.0 |
| 2025-06-17 11:00:00 | AAPL | Stock | 197.38 | 198.39 | 197.345 | 197.785 | 2617854.0 |
| 2025-06-17 12:00:00 | AAPL | Stock | 197.785 | 198.15 | 196.68 | 196.775 | 2387645.0 |
| 2025-06-17 13:00:00 | AAPL | Stock | 196.77 | 196.86 | 195.92 | 196.12 | 2802545.0 |
| 2025-06-17 14:00:00 | AAPL | Stock | 196.11 | 196.12 | 195.21 | 195.84 | 2546807.0 |
| 2025-06-17 15:00:00 | AAPL | Stock | 195.85 | 195.94 | 195.441 | 195.64 | 4346821.0 |
| 2025-06-17 16:00:00 | AAPL | Stock | 195.65 | 195.9591 | 195.55 | 195.75 | 5557553.0 |
| 2025-06-17 17:00:00 | AAPL | Stock | 195.7 | 195.72 | 195.5 | 195.56 | 38019.0 |
| 2025-06-17 18:00:00 | AAPL | Stock | 195.56 | 195.6539 | 195.2 | 195.2 | 45195.0 |
| 2025-06-17 19:00:00 | AAPL | Stock | 195.24 | 195.4 | 195.112 | 195.15 | 46070.0 |
| 2025-06-17 04:00:00 | MSFT | Stock | 475.43 | 475.5 | 474.25 | 474.85 | 18881.0 |
| 2025-06-17 05:00:00 | MSFT | Stock | 474.87 | 474.99 | 473.9 | 474.0 | 23548.0 |
| 2025-06-17 06:00:00 | MSFT | Stock | 474.44 | 474.44 | 473.4 | 473.9 | 11738.0 |
| 2025-06-17 07:00:00 | MSFT | Stock | 473.9 | 474.8 | 473.8 | 474.75 | 21303.0 |
| 2025-06-17 08:00:00 | MSFT | Stock | 474.01 | 477.22 | 473.87 | 474.86 | 56163.0 |
| 2025-06-17 09:00:00 | MSFT | Stock | 474.8001 | 476.61 | 474.08 | 475.43 | 1211606.0 |
| 2025-06-17 10:00:00 | MSFT | Stock | 475.48 | 476.38 | 474.5 | 475.855 | 667854.0 |
| 2025-06-17 11:00:00 | MSFT | Stock | 475.805 | 477.98 | 475.8 | 477.46 | 681253.0 |
| 2025-06-17 12:00:00 | MSFT | Stock | 477.39 | 478.7399 | 477.0 | 477.245 | 661340.0 |
| 2025-06-17 13:00:00 | MSFT | Stock | 477.23 | 477.8 | 475.9 | 476.2197 | 730326.0 |
| 2025-06-17 14:00:00 | MSFT | Stock | 476.21 | 477.37 | 475.39 | 477.345 | 521781.0 |
| 2025-06-17 15:00:00 | MSFT | Stock | 477.37 | 478.7 | 476.66 | 478.04 | 1359736.0 |
| 2025-06-17 16:00:00 | MSFT | Stock | 477.99 | 478.6084 | 477.5 | 478.11 | 3123642.0 |
| 2025-06-17 17:00:00 | MSFT | Stock | 478.0306 | 478.0306 | 477.5 | 477.5 | 3530.0 |
| 2025-06-17 18:00:00 | MSFT | Stock | 477.4713 | 477.4713 | 476.5 | 476.56 | 11923.0 |
| 2025-06-17 19:00:00 | MSFT | Stock | 476.67 | 477.21 | 476.67 | 476.76 | 9490.0 |
| 2025-06-17 04:00:00 | NVDA | Stock | 144.06 | 145.27 | 143.79 | 144.97 | 599335.0 |
| 2025-06-17 05:00:00 | NVDA | Stock | 145.02 | 145.2 | 144.52 | 144.71 | 292565.0 |
| 2025-06-17 06:00:00 | NVDA | Stock | 144.7 | 144.8 | 143.8 | 144.41 | 434019.0 |
| 2025-06-17 07:00:00 | NVDA | Stock | 144.36 | 144.93 | 144.24 | 144.88 | 437699.0 |
| 2025-06-17 08:00:00 | NVDA | Stock | 144.32 | 145.44 | 143.7 | 144.849 | 2064303.0 |
| 2025-06-17 09:00:00 | NVDA | Stock | 144.8498 | 145.22 | 144.0201 | 144.755 | 17154513.0 |
| 2025-06-17 10:00:00 | NVDA | Stock | 144.755 | 145.04 | 144.24 | 144.3889 | 15389184.0 |
| 2025-06-17 11:00:00 | NVDA | Stock | 144.375 | 144.96 | 144.22 | 144.735 | 13056444.0 |
| 2025-06-17 12:00:00 | NVDA | Stock | 144.74 | 145.165 | 144.4 | 144.5 | 12041791.0 |
| 2025-06-17 13:00:00 | NVDA | Stock | 144.5 | 145.13 | 144.18 | 144.3386 | 13463272.0 |
| 2025-06-17 14:00:00 | NVDA | Stock | 144.33 | 144.67 | 143.78 | 144.3814 | 11852814.0 |
| 2025-06-17 15:00:00 | NVDA | Stock | 144.39 | 144.77 | 144.0001 | 144.04 | 14857769.0 |
| 2025-06-17 16:00:00 | NVDA | Stock | 144.03 | 144.22 | 143.91 | 144.06 | 12607861.0 |
| 2025-06-17 17:00:00 | NVDA | Stock | 144.06 | 144.0899 | 143.57 | 143.7328 | 430482.0 |
| 2025-06-17 18:00:00 | NVDA | Stock | 143.74 | 143.75 | 143.34 | 143.35 | 344785.0 |
| 2025-06-17 19:00:00 | NVDA | Stock | 143.34 | 143.6599 | 143.2601 | 143.63 | 404006.0 |
| 2025-06-17 04:00:00 | AMZN | Stock | 214.06 | 215.0 | 214.04 | 214.21 | 13374.0 |
| 2025-06-17 05:00:00 | AMZN | Stock | 214.9 | 214.9 | 214.21 | 214.48 | 3444.0 |
> showing 50 of 61,887 rows — these rows as CSV