PREVIEW / stock_1hour / 2025-10-20
file: by_date/stock_1hour/2025/2025-10-20.parquet size: 1.5 MB rows: 65,230 symbols: 226
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-20 04:00:00 | AAPL | Stock | 253.57 | 253.67 | 253.11 | 253.31 | 28688.0 |
| 2025-10-20 05:00:00 | AAPL | Stock | 253.15 | 253.52 | 253.0 | 253.52 | 9661.0 |
| 2025-10-20 06:00:00 | AAPL | Stock | 253.44 | 256.06 | 253.0 | 254.7 | 85408.0 |
| 2025-10-20 07:00:00 | AAPL | Stock | 254.6 | 256.25 | 254.3 | 256.1 | 147661.0 |
| 2025-10-20 08:00:00 | AAPL | Stock | 254.6 | 256.96 | 251.66 | 256.79 | 370575.0 |
| 2025-10-20 09:00:00 | AAPL | Stock | 256.7989 | 259.87 | 255.42 | 258.9775 | 9795951.0 |
| 2025-10-20 10:00:00 | AAPL | Stock | 259.0 | 261.63 | 258.0702 | 261.57 | 10889117.0 |
| 2025-10-20 11:00:00 | AAPL | Stock | 261.58 | 264.375 | 261.52 | 263.31 | 11860377.0 |
| 2025-10-20 12:00:00 | AAPL | Stock | 263.32 | 264.23 | 262.65 | 263.62 | 7244213.0 |
| 2025-10-20 13:00:00 | AAPL | Stock | 263.6101 | 264.22 | 262.826 | 262.925 | 4407513.0 |
| 2025-10-20 14:00:00 | AAPL | Stock | 262.92 | 263.83 | 262.79 | 263.28 | 3427791.0 |
| 2025-10-20 15:00:00 | AAPL | Stock | 263.3 | 263.86 | 261.93 | 262.23 | 8115418.0 |
| 2025-10-20 16:00:00 | AAPL | Stock | 262.24 | 262.85 | 262.11 | 262.45 | 7780722.0 |
| 2025-10-20 17:00:00 | AAPL | Stock | 262.43 | 262.68 | 262.24 | 262.65 | 168785.0 |
| 2025-10-20 18:00:00 | AAPL | Stock | 262.64 | 262.93 | 262.24 | 262.7581 | 53410.0 |
| 2025-10-20 19:00:00 | AAPL | Stock | 262.76 | 262.9229 | 262.55 | 262.6 | 40173.0 |
| 2025-10-20 04:00:00 | MSFT | Stock | 514.0 | 516.0 | 514.0 | 516.0 | 4138.0 |
| 2025-10-20 05:00:00 | MSFT | Stock | 515.49 | 515.5 | 515.04 | 515.1 | 1178.0 |
| 2025-10-20 06:00:00 | MSFT | Stock | 514.67 | 514.8 | 513.43 | 513.44 | 6756.0 |
| 2025-10-20 07:00:00 | MSFT | Stock | 513.38 | 514.2 | 513.0 | 514.2 | 3627.0 |
| 2025-10-20 08:00:00 | MSFT | Stock | 513.44 | 516.2 | 513.0 | 514.5 | 20066.0 |
| 2025-10-20 09:00:00 | MSFT | Stock | 514.35 | 516.04 | 513.43 | 514.476 | 914699.0 |
| 2025-10-20 10:00:00 | MSFT | Stock | 514.47 | 518.7 | 514.25 | 518.085 | 1286594.0 |
| 2025-10-20 11:00:00 | MSFT | Stock | 518.09 | 518.4355 | 516.76 | 517.3599 | 671279.0 |
| 2025-10-20 12:00:00 | MSFT | Stock | 517.29 | 517.37 | 516.04 | 516.49 | 462991.0 |
| 2025-10-20 13:00:00 | MSFT | Stock | 516.4525 | 518.0899 | 516.42 | 517.675 | 502249.0 |
| 2025-10-20 14:00:00 | MSFT | Stock | 517.71 | 518.0873 | 516.5201 | 516.64 | 607055.0 |
| 2025-10-20 15:00:00 | MSFT | Stock | 516.6699 | 517.11 | 515.7 | 516.83 | 1067132.0 |
| 2025-10-20 16:00:00 | MSFT | Stock | 516.8484 | 517.1 | 516.79 | 516.7901 | 3611050.0 |
| 2025-10-20 17:00:00 | MSFT | Stock | 516.8224 | 517.08 | 516.7 | 516.7514 | 7706.0 |
| 2025-10-20 18:00:00 | MSFT | Stock | 516.82 | 516.94 | 516.79 | 516.94 | 1533.0 |
| 2025-10-20 19:00:00 | MSFT | Stock | 516.94 | 517.08 | 516.94 | 516.99 | 2341.0 |
| 2025-10-20 04:00:00 | NVDA | Stock | 184.3 | 185.0 | 183.58 | 183.63 | 307964.0 |
| 2025-10-20 05:00:00 | NVDA | Stock | 183.61 | 184.05 | 182.97 | 183.71 | 236853.0 |
| 2025-10-20 06:00:00 | NVDA | Stock | 183.73 | 184.25 | 183.19 | 183.31 | 277412.0 |
| 2025-10-20 07:00:00 | NVDA | Stock | 183.26 | 183.8 | 182.57 | 182.751 | 495254.0 |
| 2025-10-20 08:00:00 | NVDA | Stock | 184.16 | 184.95 | 182.56 | 182.81 | 1652527.0 |
| 2025-10-20 09:00:00 | NVDA | Stock | 182.81 | 183.39 | 181.73 | 182.94 | 15415966.0 |
| 2025-10-20 10:00:00 | NVDA | Stock | 182.947 | 185.2 | 182.3 | 183.9056 | 23473664.0 |
| 2025-10-20 11:00:00 | NVDA | Stock | 183.905 | 184.03 | 183.03 | 183.6252 | 13584898.0 |
| 2025-10-20 12:00:00 | NVDA | Stock | 183.635 | 184.13 | 183.28 | 184.075 | 8462389.0 |
| 2025-10-20 13:00:00 | NVDA | Stock | 184.07 | 184.26 | 183.5 | 183.5642 | 7366570.0 |
| 2025-10-20 14:00:00 | NVDA | Stock | 183.56 | 183.795 | 183.39 | 183.45 | 6688607.0 |
| 2025-10-20 15:00:00 | NVDA | Stock | 183.444 | 183.515 | 182.05 | 182.57 | 15499716.0 |
| 2025-10-20 16:00:00 | NVDA | Stock | 182.56 | 182.97 | 182.5 | 182.84 | 10588976.0 |
| 2025-10-20 17:00:00 | NVDA | Stock | 182.84 | 182.98 | 182.82 | 182.95 | 130828.0 |
| 2025-10-20 18:00:00 | NVDA | Stock | 182.95 | 182.96 | 182.64 | 182.86 | 113030.0 |
| 2025-10-20 19:00:00 | NVDA | Stock | 182.87 | 182.88 | 182.65 | 182.78 | 181038.0 |
| 2025-10-20 04:00:00 | AMZN | Stock | 215.0 | 215.0 | 211.8 | 211.99 | 83296.0 |
| 2025-10-20 05:00:00 | AMZN | Stock | 211.82 | 213.15 | 211.72 | 212.75 | 65467.0 |
> showing 50 of 65,230 rows — these rows as CSV