PREVIEW / stock_1hour / 2025-08-18
file: by_date/stock_1hour/2025/2025-08-18.parquet size: 1.4 MB rows: 63,141 symbols: 339
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-08-18 04:00:00 | AAPL | Stock | 231.18 | 231.36 | 230.9 | 231.1 | 12207.0 |
| 2025-08-18 05:00:00 | AAPL | Stock | 231.02 | 231.1 | 230.98 | 231.05 | 10819.0 |
| 2025-08-18 06:00:00 | AAPL | Stock | 231.1 | 231.14 | 231.0 | 231.04 | 4517.0 |
| 2025-08-18 07:00:00 | AAPL | Stock | 231.15 | 231.35 | 231.04 | 231.32 | 9286.0 |
| 2025-08-18 08:00:00 | AAPL | Stock | 231.0 | 231.7 | 230.96 | 231.1601 | 53019.0 |
| 2025-08-18 09:00:00 | AAPL | Stock | 231.16 | 232.73 | 230.8 | 232.35 | 3968783.0 |
| 2025-08-18 10:00:00 | AAPL | Stock | 232.35 | 233.12 | 230.37 | 230.51 | 5313221.0 |
| 2025-08-18 11:00:00 | AAPL | Stock | 230.5305 | 231.22 | 230.47 | 230.905 | 2731276.0 |
| 2025-08-18 12:00:00 | AAPL | Stock | 230.9 | 231.11 | 230.11 | 230.595 | 2338280.0 |
| 2025-08-18 13:00:00 | AAPL | Stock | 230.595 | 231.67 | 230.59 | 231.08 | 1994144.0 |
| 2025-08-18 14:00:00 | AAPL | Stock | 231.09 | 231.57 | 230.94 | 231.47 | 1801239.0 |
| 2025-08-18 15:00:00 | AAPL | Stock | 231.47 | 231.675 | 230.88 | 230.88 | 3384787.0 |
| 2025-08-18 16:00:00 | AAPL | Stock | 230.89 | 231.12 | 230.8 | 230.83 | 5659627.0 |
| 2025-08-18 17:00:00 | AAPL | Stock | 230.8 | 231.2001 | 230.8 | 231.0 | 27623.0 |
| 2025-08-18 18:00:00 | AAPL | Stock | 231.0 | 231.25 | 230.95 | 231.0 | 7925.0 |
| 2025-08-18 19:00:00 | AAPL | Stock | 231.05 | 231.09 | 230.8 | 230.91 | 10658.0 |
| 2025-08-18 04:00:00 | MSFT | Stock | 522.0 | 522.0 | 520.65 | 521.26 | 2672.0 |
| 2025-08-18 05:00:00 | MSFT | Stock | 520.97 | 520.97 | 520.4 | 520.52 | 448.0 |
| 2025-08-18 06:00:00 | MSFT | Stock | 520.61 | 521.57 | 520.61 | 521.5 | 4233.0 |
| 2025-08-18 07:00:00 | MSFT | Stock | 521.5 | 521.5 | 520.45 | 520.8 | 6724.0 |
| 2025-08-18 08:00:00 | MSFT | Stock | 521.0 | 521.6 | 518.87 | 520.84 | 25454.0 |
| 2025-08-18 09:00:00 | MSFT | Stock | 520.77 | 522.82 | 518.36 | 519.195 | 1236120.0 |
| 2025-08-18 10:00:00 | MSFT | Stock | 519.21 | 520.25 | 517.66 | 518.18 | 1676410.0 |
| 2025-08-18 11:00:00 | MSFT | Stock | 518.16 | 518.22 | 515.8 | 516.925 | 1272667.0 |
| 2025-08-18 12:00:00 | MSFT | Stock | 516.965 | 517.8495 | 515.76 | 516.0 | 1148268.0 |
| 2025-08-18 13:00:00 | MSFT | Stock | 516.0 | 517.0 | 515.24 | 515.515 | 1246467.0 |
| 2025-08-18 14:00:00 | MSFT | Stock | 515.5 | 516.35 | 515.29 | 515.6 | 1072192.0 |
| 2025-08-18 15:00:00 | MSFT | Stock | 515.6 | 517.305 | 514.02 | 517.14 | 3478116.0 |
| 2025-08-18 16:00:00 | MSFT | Stock | 517.1 | 517.34 | 516.08 | 517.24 | 3551812.0 |
| 2025-08-18 17:00:00 | MSFT | Stock | 517.25 | 517.41 | 516.8948 | 517.2 | 12755.0 |
| 2025-08-18 18:00:00 | MSFT | Stock | 517.0789 | 517.5 | 517.0789 | 517.36 | 3709.0 |
| 2025-08-18 19:00:00 | MSFT | Stock | 517.2 | 517.4699 | 516.9 | 516.9 | 6812.0 |
| 2025-08-18 04:00:00 | NVDA | Stock | 180.0 | 180.35 | 179.19 | 179.54 | 184996.0 |
| 2025-08-18 05:00:00 | NVDA | Stock | 179.55 | 179.6 | 179.09 | 179.54 | 164424.0 |
| 2025-08-18 06:00:00 | NVDA | Stock | 179.52 | 180.15 | 179.51 | 180.0 | 196141.0 |
| 2025-08-18 07:00:00 | NVDA | Stock | 180.0 | 180.08 | 179.65 | 179.94 | 163578.0 |
| 2025-08-18 08:00:00 | NVDA | Stock | 179.94 | 180.9 | 179.08 | 180.17 | 885504.0 |
| 2025-08-18 09:00:00 | NVDA | Stock | 180.17 | 182.78 | 180.12 | 182.1733 | 20553669.0 |
| 2025-08-18 10:00:00 | NVDA | Stock | 182.19 | 182.9375 | 180.94 | 181.4181 | 23890458.0 |
| 2025-08-18 11:00:00 | NVDA | Stock | 181.41 | 181.7181 | 181.03 | 181.415 | 11096031.0 |
| 2025-08-18 12:00:00 | NVDA | Stock | 181.41 | 181.91 | 180.95 | 180.998 | 9673847.0 |
| 2025-08-18 13:00:00 | NVDA | Stock | 180.995 | 181.69 | 180.96 | 181.4599 | 7285222.0 |
| 2025-08-18 14:00:00 | NVDA | Stock | 181.455 | 182.4042 | 181.35 | 182.24 | 9869366.0 |
| 2025-08-18 15:00:00 | NVDA | Stock | 182.2551 | 182.61 | 181.97 | 181.97 | 13272176.0 |
| 2025-08-18 16:00:00 | NVDA | Stock | 181.97 | 182.14 | 181.89 | 182.026 | 9247963.0 |
| 2025-08-18 17:00:00 | NVDA | Stock | 182.05 | 182.06 | 181.96 | 181.97 | 88444.0 |
| 2025-08-18 18:00:00 | NVDA | Stock | 181.98 | 182.2 | 181.97 | 182.06 | 127082.0 |
| 2025-08-18 19:00:00 | NVDA | Stock | 182.08 | 182.12 | 181.88 | 181.9999 | 135517.0 |
| 2025-08-18 04:00:00 | AMZN | Stock | 230.9 | 231.02 | 230.06 | 230.31 | 17410.0 |
| 2025-08-18 05:00:00 | AMZN | Stock | 230.25 | 230.29 | 229.51 | 229.76 | 24199.0 |
> showing 50 of 63,141 rows — these rows as CSV