PREVIEW / stock_1hour / 2025-10-16
file: by_date/stock_1hour/2025/2025-10-16.parquet size: 1.5 MB rows: 65,584 symbols: 233
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-10-16 04:00:00 | AAPL | Stock | 249.88 | 250.25 | 249.78 | 249.9 | 13861.0 |
| 2025-10-16 05:00:00 | AAPL | Stock | 250.04 | 250.24 | 249.71 | 250.24 | 9237.0 |
| 2025-10-16 06:00:00 | AAPL | Stock | 250.35 | 250.64 | 250.05 | 250.25 | 30841.0 |
| 2025-10-16 07:00:00 | AAPL | Stock | 250.14 | 250.36 | 249.87 | 250.02 | 17042.0 |
| 2025-10-16 08:00:00 | AAPL | Stock | 250.0 | 250.5754 | 249.0 | 250.43 | 84918.0 |
| 2025-10-16 09:00:00 | AAPL | Stock | 250.44 | 250.4995 | 246.18 | 247.51 | 5360108.0 |
| 2025-10-16 10:00:00 | AAPL | Stock | 247.56 | 248.91 | 246.86 | 248.6 | 4306469.0 |
| 2025-10-16 11:00:00 | AAPL | Stock | 248.62 | 249.04 | 247.5017 | 247.97 | 2640830.0 |
| 2025-10-16 12:00:00 | AAPL | Stock | 247.96 | 248.2 | 246.04 | 247.65 | 2931862.0 |
| 2025-10-16 13:00:00 | AAPL | Stock | 247.65 | 247.7721 | 246.2 | 246.565 | 1928145.0 |
| 2025-10-16 14:00:00 | AAPL | Stock | 246.55 | 246.96 | 245.13 | 246.605 | 2749332.0 |
| 2025-10-16 15:00:00 | AAPL | Stock | 246.6 | 247.97 | 246.29 | 247.43 | 3922772.0 |
| 2025-10-16 16:00:00 | AAPL | Stock | 247.519 | 247.8 | 246.92 | 247.2 | 5009921.0 |
| 2025-10-16 17:00:00 | AAPL | Stock | 247.45 | 247.45 | 247.01 | 247.15 | 30508.0 |
| 2025-10-16 18:00:00 | AAPL | Stock | 247.2 | 247.6 | 246.27 | 246.33 | 19613.0 |
| 2025-10-16 19:00:00 | AAPL | Stock | 246.53 | 246.9429 | 246.26 | 246.61 | 11487.0 |
| 2025-10-16 04:00:00 | MSFT | Stock | 514.34 | 514.62 | 513.6 | 513.81 | 2666.0 |
| 2025-10-16 05:00:00 | MSFT | Stock | 514.0 | 515.3 | 513.89 | 515.3 | 6690.0 |
| 2025-10-16 06:00:00 | MSFT | Stock | 515.55 | 516.3 | 514.61 | 514.99 | 5682.0 |
| 2025-10-16 07:00:00 | MSFT | Stock | 515.06 | 515.5 | 515.06 | 515.16 | 3763.0 |
| 2025-10-16 08:00:00 | MSFT | Stock | 515.0 | 515.86 | 512.99 | 514.96 | 26349.0 |
| 2025-10-16 09:00:00 | MSFT | Stock | 514.91 | 515.59 | 511.65 | 514.335 | 1063989.0 |
| 2025-10-16 10:00:00 | MSFT | Stock | 514.355 | 516.85 | 513.0 | 514.995 | 817049.0 |
| 2025-10-16 11:00:00 | MSFT | Stock | 514.94 | 516.3 | 513.4 | 513.74 | 580042.0 |
| 2025-10-16 12:00:00 | MSFT | Stock | 513.65 | 514.2 | 509.89 | 513.18 | 743123.0 |
| 2025-10-16 13:00:00 | MSFT | Stock | 513.01 | 513.22 | 510.55 | 511.05 | 572895.0 |
| 2025-10-16 14:00:00 | MSFT | Stock | 511.03 | 511.07 | 508.13 | 510.485 | 593269.0 |
| 2025-10-16 15:00:00 | MSFT | Stock | 510.54 | 512.1 | 508.66 | 511.55 | 1242879.0 |
| 2025-10-16 16:00:00 | MSFT | Stock | 511.61 | 512.89 | 509.51 | 511.5 | 3512814.0 |
| 2025-10-16 17:00:00 | MSFT | Stock | 511.61 | 511.61 | 510.45 | 511.0 | 6963.0 |
| 2025-10-16 18:00:00 | MSFT | Stock | 511.5 | 512.1 | 510.0 | 510.0 | 3538.0 |
| 2025-10-16 19:00:00 | MSFT | Stock | 509.86 | 510.4783 | 509.767 | 509.767 | 2336.0 |
| 2025-10-16 04:00:00 | NVDA | Stock | 181.9 | 182.23 | 181.5 | 181.71 | 301898.0 |
| 2025-10-16 05:00:00 | NVDA | Stock | 181.76 | 182.07 | 181.62 | 182.03 | 241651.0 |
| 2025-10-16 06:00:00 | NVDA | Stock | 182.03 | 182.37 | 181.98 | 182.06 | 301999.0 |
| 2025-10-16 07:00:00 | NVDA | Stock | 182.03 | 182.23 | 181.85 | 182.17 | 391986.0 |
| 2025-10-16 08:00:00 | NVDA | Stock | 182.17 | 182.68 | 180.55 | 182.48 | 2519853.0 |
| 2025-10-16 09:00:00 | NVDA | Stock | 182.48 | 182.7 | 181.24 | 181.695 | 18827042.0 |
| 2025-10-16 10:00:00 | NVDA | Stock | 181.7 | 183.28 | 181.4793 | 182.48 | 21105091.0 |
| 2025-10-16 11:00:00 | NVDA | Stock | 182.48 | 182.93 | 181.546 | 181.9 | 16191606.0 |
| 2025-10-16 12:00:00 | NVDA | Stock | 181.89 | 182.18 | 179.77 | 181.49 | 18418101.0 |
| 2025-10-16 13:00:00 | NVDA | Stock | 181.48 | 182.52 | 180.65 | 182.1196 | 14464554.0 |
| 2025-10-16 14:00:00 | NVDA | Stock | 182.11 | 182.1899 | 179.82 | 181.4682 | 16131732.0 |
| 2025-10-16 15:00:00 | NVDA | Stock | 181.465 | 182.49 | 180.26 | 181.811 | 17286237.0 |
| 2025-10-16 16:00:00 | NVDA | Stock | 181.82 | 182.0 | 181.21 | 181.4 | 14944354.0 |
| 2025-10-16 17:00:00 | NVDA | Stock | 181.3908 | 181.49 | 181.0983 | 181.25 | 221550.0 |
| 2025-10-16 18:00:00 | NVDA | Stock | 181.3 | 181.75 | 180.9 | 180.91 | 226558.0 |
| 2025-10-16 19:00:00 | NVDA | Stock | 181.0424 | 181.0424 | 180.51 | 180.6816 | 316339.0 |
| 2025-10-16 04:00:00 | AMZN | Stock | 215.5 | 216.49 | 215.5 | 216.22 | 13638.0 |
| 2025-10-16 05:00:00 | AMZN | Stock | 216.34 | 216.34 | 215.91 | 216.23 | 9726.0 |
> showing 50 of 65,584 rows — these rows as CSV