PREVIEW / stock_1hour / 2025-09-16
file: by_date/stock_1hour/2025/2025-09-16.parquet size: 1.5 MB rows: 64,315 symbols: 314
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-09-16 04:00:00 | AAPL | Stock | 236.72 | 236.91 | 236.62 | 236.9 | 16011.0 |
| 2025-09-16 05:00:00 | AAPL | Stock | 236.81 | 236.83 | 236.5 | 236.5 | 3272.0 |
| 2025-09-16 06:00:00 | AAPL | Stock | 236.55 | 236.59 | 236.48 | 236.57 | 4541.0 |
| 2025-09-16 07:00:00 | AAPL | Stock | 236.6 | 236.81 | 236.1 | 236.81 | 38859.0 |
| 2025-09-16 08:00:00 | AAPL | Stock | 236.5 | 236.98 | 236.34 | 236.8 | 130842.0 |
| 2025-09-16 09:00:00 | AAPL | Stock | 236.92 | 240.56 | 236.3235 | 240.36 | 9202695.0 |
| 2025-09-16 10:00:00 | AAPL | Stock | 240.375 | 241.22 | 238.73 | 238.98 | 8883619.0 |
| 2025-09-16 11:00:00 | AAPL | Stock | 238.99 | 239.85 | 238.245 | 238.655 | 4370547.0 |
| 2025-09-16 12:00:00 | AAPL | Stock | 238.66 | 239.4142 | 238.63 | 239.14 | 2810405.0 |
| 2025-09-16 13:00:00 | AAPL | Stock | 239.15 | 239.4 | 238.13 | 238.32 | 2761118.0 |
| 2025-09-16 14:00:00 | AAPL | Stock | 238.32 | 239.11 | 238.2099 | 239.06 | 2731664.0 |
| 2025-09-16 15:00:00 | AAPL | Stock | 239.06 | 239.63 | 238.08 | 238.14 | 6744509.0 |
| 2025-09-16 16:00:00 | AAPL | Stock | 238.12 | 238.3 | 237.8135 | 237.94 | 10536639.0 |
| 2025-09-16 17:00:00 | AAPL | Stock | 237.95 | 238.0919 | 237.85 | 237.9501 | 17452.0 |
| 2025-09-16 18:00:00 | AAPL | Stock | 237.95 | 238.15 | 237.89 | 237.9384 | 26882.0 |
| 2025-09-16 19:00:00 | AAPL | Stock | 238.0 | 238.0 | 237.8 | 237.91 | 9974.0 |
| 2025-09-16 04:00:00 | MSFT | Stock | 517.1 | 517.61 | 516.0 | 517.61 | 2794.0 |
| 2025-09-16 05:00:00 | MSFT | Stock | 517.63 | 517.8 | 517.22 | 517.48 | 1929.0 |
| 2025-09-16 06:00:00 | MSFT | Stock | 517.48 | 517.48 | 517.25 | 517.28 | 3715.0 |
| 2025-09-16 07:00:00 | MSFT | Stock | 517.28 | 517.28 | 516.31 | 517.0 | 15043.0 |
| 2025-09-16 08:00:00 | MSFT | Stock | 517.36 | 517.86 | 515.8 | 515.8 | 41766.0 |
| 2025-09-16 09:00:00 | MSFT | Stock | 515.5 | 517.5 | 511.06 | 511.245 | 1728775.0 |
| 2025-09-16 10:00:00 | MSFT | Stock | 511.32 | 514.0 | 510.59 | 513.3 | 1151310.0 |
| 2025-09-16 11:00:00 | MSFT | Stock | 513.34 | 513.65 | 512.12 | 512.99 | 500651.0 |
| 2025-09-16 12:00:00 | MSFT | Stock | 512.9842 | 513.82 | 512.595 | 513.35 | 391075.0 |
| 2025-09-16 13:00:00 | MSFT | Stock | 513.42 | 514.2234 | 512.26 | 512.295 | 680010.0 |
| 2025-09-16 14:00:00 | MSFT | Stock | 512.27 | 512.45 | 510.26 | 510.59 | 1013830.0 |
| 2025-09-16 15:00:00 | MSFT | Stock | 510.6274 | 510.7199 | 508.6 | 509.149 | 2513079.0 |
| 2025-09-16 16:00:00 | MSFT | Stock | 509.04 | 511.8901 | 509.04 | 509.65 | 3263910.0 |
| 2025-09-16 17:00:00 | MSFT | Stock | 509.59 | 509.6 | 509.3 | 509.5 | 8822.0 |
| 2025-09-16 18:00:00 | MSFT | Stock | 509.4829 | 510.0 | 509.04 | 509.8938 | 12040.0 |
| 2025-09-16 19:00:00 | MSFT | Stock | 510.0379 | 510.4 | 510.0379 | 510.2519 | 6309.0 |
| 2025-09-16 04:00:00 | NVDA | Stock | 177.06 | 177.82 | 177.03 | 177.29 | 191970.0 |
| 2025-09-16 05:00:00 | NVDA | Stock | 177.28 | 177.47 | 177.16 | 177.23 | 108426.0 |
| 2025-09-16 06:00:00 | NVDA | Stock | 177.24 | 177.37 | 177.08 | 177.21 | 127141.0 |
| 2025-09-16 07:00:00 | NVDA | Stock | 177.22 | 177.45 | 177.2 | 177.43 | 125381.0 |
| 2025-09-16 08:00:00 | NVDA | Stock | 177.3 | 177.83 | 176.88 | 177.23 | 785298.0 |
| 2025-09-16 09:00:00 | NVDA | Stock | 177.24 | 177.5 | 175.71 | 176.13 | 17231215.0 |
| 2025-09-16 10:00:00 | NVDA | Stock | 176.13 | 176.85 | 176.0986 | 176.5255 | 14196887.0 |
| 2025-09-16 11:00:00 | NVDA | Stock | 176.53 | 176.5451 | 175.25 | 175.3188 | 14812161.0 |
| 2025-09-16 12:00:00 | NVDA | Stock | 175.315 | 175.3799 | 174.81 | 174.95 | 12309971.0 |
| 2025-09-16 13:00:00 | NVDA | Stock | 174.96 | 175.4 | 174.77 | 174.9688 | 9562370.0 |
| 2025-09-16 14:00:00 | NVDA | Stock | 174.9692 | 175.13 | 174.65 | 174.9645 | 9549526.0 |
| 2025-09-16 15:00:00 | NVDA | Stock | 174.965 | 175.22 | 174.38 | 174.86 | 18196278.0 |
| 2025-09-16 16:00:00 | NVDA | Stock | 174.86 | 175.5419 | 174.839 | 175.1 | 12791449.0 |
| 2025-09-16 17:00:00 | NVDA | Stock | 175.09 | 175.19 | 174.88 | 175.15 | 204697.0 |
| 2025-09-16 18:00:00 | NVDA | Stock | 175.1805 | 175.31 | 175.14 | 175.28 | 208800.0 |
| 2025-09-16 19:00:00 | NVDA | Stock | 175.25 | 175.34 | 175.1 | 175.1126 | 221826.0 |
| 2025-09-16 04:00:00 | AMZN | Stock | 232.35 | 232.87 | 232.05 | 232.59 | 13121.0 |
| 2025-09-16 05:00:00 | AMZN | Stock | 232.6 | 232.73 | 232.44 | 232.5 | 30459.0 |
> showing 50 of 64,315 rows — these rows as CSV