PREVIEW / stock_1hour / 2025-08-19
file: by_date/stock_1hour/2025/2025-08-19.parquet size: 1.4 MB rows: 62,393 symbols: 335
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-19 04:00:00 | AAPL | Stock | 230.5 | 230.55 | 230.2 | 230.34 | 5820.0 |
| 2025-08-19 05:00:00 | AAPL | Stock | 230.34 | 230.57 | 230.31 | 230.42 | 3149.0 |
| 2025-08-19 06:00:00 | AAPL | Stock | 230.33 | 230.4 | 229.95 | 230.04 | 7895.0 |
| 2025-08-19 07:00:00 | AAPL | Stock | 230.24 | 230.5 | 230.06 | 230.5 | 7723.0 |
| 2025-08-19 08:00:00 | AAPL | Stock | 230.38 | 230.6 | 230.0 | 230.1905 | 40685.0 |
| 2025-08-19 09:00:00 | AAPL | Stock | 230.22 | 232.29 | 230.12 | 232.07 | 3425498.0 |
| 2025-08-19 10:00:00 | AAPL | Stock | 232.04 | 232.87 | 230.785 | 230.88 | 4089779.0 |
| 2025-08-19 11:00:00 | AAPL | Stock | 230.88 | 231.66 | 230.47 | 231.395 | 2853382.0 |
| 2025-08-19 12:00:00 | AAPL | Stock | 231.3912 | 231.54 | 230.7 | 230.715 | 1916218.0 |
| 2025-08-19 13:00:00 | AAPL | Stock | 230.715 | 230.9 | 230.06 | 230.79 | 2026012.0 |
| 2025-08-19 14:00:00 | AAPL | Stock | 230.79 | 230.79 | 229.58 | 229.76 | 2440349.0 |
| 2025-08-19 15:00:00 | AAPL | Stock | 229.76 | 230.69 | 229.35 | 230.56 | 4500034.0 |
| 2025-08-19 16:00:00 | AAPL | Stock | 230.57 | 230.77 | 230.5 | 230.56 | 5804546.0 |
| 2025-08-19 17:00:00 | AAPL | Stock | 230.5075 | 230.75 | 230.4318 | 230.47 | 25355.0 |
| 2025-08-19 18:00:00 | AAPL | Stock | 230.56 | 230.98 | 230.43 | 230.57 | 25464.0 |
| 2025-08-19 19:00:00 | AAPL | Stock | 230.58 | 230.6724 | 229.77 | 229.83 | 42123.0 |
| 2025-08-19 04:00:00 | MSFT | Stock | 516.78 | 517.0 | 516.3 | 517.0 | 1294.0 |
| 2025-08-19 05:00:00 | MSFT | Stock | 517.17 | 517.42 | 517.17 | 517.29 | 492.0 |
| 2025-08-19 06:00:00 | MSFT | Stock | 517.16 | 517.2 | 516.46 | 516.46 | 1286.0 |
| 2025-08-19 07:00:00 | MSFT | Stock | 516.87 | 517.0 | 516.4 | 516.75 | 3375.0 |
| 2025-08-19 08:00:00 | MSFT | Stock | 516.75 | 517.0 | 516.0 | 516.3737 | 24538.0 |
| 2025-08-19 09:00:00 | MSFT | Stock | 516.56 | 516.7 | 511.7001 | 513.55 | 1468740.0 |
| 2025-08-19 10:00:00 | MSFT | Stock | 513.505 | 514.1389 | 509.62 | 509.83 | 1807702.0 |
| 2025-08-19 11:00:00 | MSFT | Stock | 509.8356 | 510.0 | 508.57 | 509.795 | 1444103.0 |
| 2025-08-19 12:00:00 | MSFT | Stock | 509.8 | 510.9799 | 509.6801 | 510.4 | 1048406.0 |
| 2025-08-19 13:00:00 | MSFT | Stock | 510.4 | 511.91 | 509.81 | 511.26 | 907186.0 |
| 2025-08-19 14:00:00 | MSFT | Stock | 511.27 | 511.27 | 509.3417 | 509.6901 | 1000561.0 |
| 2025-08-19 15:00:00 | MSFT | Stock | 509.69 | 510.12 | 508.55 | 509.74 | 2435225.0 |
| 2025-08-19 16:00:00 | MSFT | Stock | 509.77 | 510.47 | 509.77 | 510.21 | 3123810.0 |
| 2025-08-19 17:00:00 | MSFT | Stock | 510.5 | 510.97 | 510.15 | 510.15 | 7349.0 |
| 2025-08-19 18:00:00 | MSFT | Stock | 510.53 | 511.39 | 510.0 | 510.5 | 9668.0 |
| 2025-08-19 19:00:00 | MSFT | Stock | 510.96 | 510.96 | 509.8 | 509.8 | 4839.0 |
| 2025-08-19 04:00:00 | NVDA | Stock | 182.41 | 182.6 | 182.1 | 182.53 | 141096.0 |
| 2025-08-19 05:00:00 | NVDA | Stock | 182.52 | 182.8 | 182.48 | 182.59 | 125864.0 |
| 2025-08-19 06:00:00 | NVDA | Stock | 182.6 | 182.6 | 182.23 | 182.42 | 147002.0 |
| 2025-08-19 07:00:00 | NVDA | Stock | 182.38 | 182.55 | 182.23 | 182.5 | 205195.0 |
| 2025-08-19 08:00:00 | NVDA | Stock | 182.28 | 182.7 | 181.61 | 182.21 | 790459.0 |
| 2025-08-19 09:00:00 | NVDA | Stock | 182.18 | 182.75 | 179.6 | 180.685 | 21931378.0 |
| 2025-08-19 10:00:00 | NVDA | Stock | 180.68 | 181.1 | 177.3 | 178.058 | 29838277.0 |
| 2025-08-19 11:00:00 | NVDA | Stock | 178.055 | 178.788 | 177.69 | 178.219 | 15308245.0 |
| 2025-08-19 12:00:00 | NVDA | Stock | 178.21 | 178.41 | 176.2 | 176.4339 | 20646339.0 |
| 2025-08-19 13:00:00 | NVDA | Stock | 176.44 | 177.23 | 175.75 | 177.13 | 15054435.0 |
| 2025-08-19 14:00:00 | NVDA | Stock | 177.135 | 177.22 | 176.035 | 176.3722 | 12036893.0 |
| 2025-08-19 15:00:00 | NVDA | Stock | 176.38 | 177.35 | 175.49 | 175.65 | 21977056.0 |
| 2025-08-19 16:00:00 | NVDA | Stock | 175.65 | 176.14 | 175.59 | 176.07 | 14294696.0 |
| 2025-08-19 17:00:00 | NVDA | Stock | 176.05 | 176.08 | 175.0 | 175.11 | 738767.0 |
| 2025-08-19 18:00:00 | NVDA | Stock | 175.13 | 175.64 | 175.13 | 175.26 | 308172.0 |
| 2025-08-19 19:00:00 | NVDA | Stock | 175.2508 | 175.34 | 175.0 | 175.04 | 427804.0 |
| 2025-08-19 04:00:00 | AMZN | Stock | 230.68 | 231.01 | 230.45 | 231.01 | 6567.0 |
| 2025-08-19 05:00:00 | AMZN | Stock | 230.88 | 231.14 | 230.85 | 230.85 | 3897.0 |
> showing 50 of 62,393 rows — these rows as CSV