PREVIEW / stock_1hour / 2025-01-07
file: by_date/stock_1hour/2025/2025-01-07.parquet size: 1.5 MB rows: 65,185 symbols: 595
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-01-07 04:00:00 | AAPL | Stock | 244.58 | 244.75 | 244.12 | 244.18 | 13443.0 |
| 2025-01-07 05:00:00 | AAPL | Stock | 244.31 | 244.75 | 244.19 | 244.59 | 4071.0 |
| 2025-01-07 06:00:00 | AAPL | Stock | 244.57 | 244.84 | 241.57 | 242.53 | 115441.0 |
| 2025-01-07 07:00:00 | AAPL | Stock | 242.7 | 242.84 | 241.73 | 242.31 | 105194.0 |
| 2025-01-07 08:00:00 | AAPL | Stock | 242.43 | 244.78 | 241.75 | 243.48 | 236168.0 |
| 2025-01-07 09:00:00 | AAPL | Stock | 243.48 | 245.36 | 242.66 | 244.92 | 3816215.0 |
| 2025-01-07 10:00:00 | AAPL | Stock | 244.85 | 245.55 | 244.03 | 244.67 | 4073941.0 |
| 2025-01-07 11:00:00 | AAPL | Stock | 244.67 | 244.78 | 243.0 | 243.08 | 2467091.0 |
| 2025-01-07 12:00:00 | AAPL | Stock | 243.06 | 243.31 | 241.35 | 242.26 | 2688828.0 |
| 2025-01-07 13:00:00 | AAPL | Stock | 242.27 | 243.4084 | 242.0701 | 242.33 | 2291777.0 |
| 2025-01-07 14:00:00 | AAPL | Stock | 242.3101 | 242.57 | 241.84 | 242.2102 | 1575404.0 |
| 2025-01-07 15:00:00 | AAPL | Stock | 242.23 | 242.405 | 241.539 | 242.19 | 4097976.0 |
| 2025-01-07 16:00:00 | AAPL | Stock | 242.21 | 242.35 | 242.0314 | 242.2499 | 7691247.0 |
| 2025-01-07 17:00:00 | AAPL | Stock | 242.09 | 242.21 | 242.03 | 242.1 | 19078.0 |
| 2025-01-07 18:00:00 | AAPL | Stock | 242.07 | 242.2 | 242.03 | 242.15 | 8580.0 |
| 2025-01-07 19:00:00 | AAPL | Stock | 242.19 | 242.85 | 242.15 | 242.84 | 31506.0 |
| 2025-01-07 04:00:00 | MSFT | Stock | 428.49 | 429.71 | 428.48 | 429.0 | 9500.0 |
| 2025-01-07 05:00:00 | MSFT | Stock | 428.54 | 429.8 | 428.54 | 429.75 | 3617.0 |
| 2025-01-07 06:00:00 | MSFT | Stock | 429.73 | 430.02 | 429.56 | 429.9 | 3742.0 |
| 2025-01-07 07:00:00 | MSFT | Stock | 429.9 | 429.95 | 429.0 | 429.0 | 7329.0 |
| 2025-01-07 08:00:00 | MSFT | Stock | 429.3 | 429.84 | 427.56 | 429.41 | 19616.0 |
| 2025-01-07 09:00:00 | MSFT | Stock | 429.2643 | 430.65 | 427.155 | 430.37 | 1590648.0 |
| 2025-01-07 10:00:00 | MSFT | Stock | 430.3 | 430.3 | 425.585 | 426.97 | 1390345.0 |
| 2025-01-07 11:00:00 | MSFT | Stock | 427.03 | 427.18 | 424.36 | 424.585 | 1169454.0 |
| 2025-01-07 12:00:00 | MSFT | Stock | 424.49 | 424.9326 | 422.76 | 423.725 | 690569.0 |
| 2025-01-07 13:00:00 | MSFT | Stock | 423.72 | 424.5267 | 422.94 | 423.375 | 520655.0 |
| 2025-01-07 14:00:00 | MSFT | Stock | 423.39 | 424.64 | 423.16 | 423.76 | 506686.0 |
| 2025-01-07 15:00:00 | MSFT | Stock | 423.74 | 423.8556 | 420.8 | 422.49 | 1323618.0 |
| 2025-01-07 16:00:00 | MSFT | Stock | 422.49 | 423.35 | 422.312 | 422.37 | 4779259.0 |
| 2025-01-07 17:00:00 | MSFT | Stock | 422.99 | 423.11 | 422.99 | 423.11 | 2422.0 |
| 2025-01-07 18:00:00 | MSFT | Stock | 423.1 | 423.2 | 422.65 | 422.8 | 3925.0 |
| 2025-01-07 19:00:00 | MSFT | Stock | 423.14 | 423.9 | 423.14 | 423.48 | 5893.0 |
| 2025-01-07 04:00:00 | NVDA | Stock | 150.47 | 152.13 | 146.45 | 151.49 | 995827.0 |
| 2025-01-07 05:00:00 | NVDA | Stock | 151.48 | 152.29 | 151.3 | 152.27 | 485321.0 |
| 2025-01-07 06:00:00 | NVDA | Stock | 152.27 | 152.57 | 151.95 | 152.4 | 741052.0 |
| 2025-01-07 07:00:00 | NVDA | Stock | 152.4 | 153.66 | 152.06 | 153.11 | 2062492.0 |
| 2025-01-07 08:00:00 | NVDA | Stock | 152.35 | 153.66 | 148.01 | 152.9799 | 4515945.0 |
| 2025-01-07 09:00:00 | NVDA | Stock | 152.98 | 153.74 | 145.59 | 146.26 | 53267272.0 |
| 2025-01-07 10:00:00 | NVDA | Stock | 146.23 | 146.49 | 140.44 | 142.695 | 78652838.0 |
| 2025-01-07 11:00:00 | NVDA | Stock | 142.7112 | 143.11 | 141.0 | 141.675 | 41055960.0 |
| 2025-01-07 12:00:00 | NVDA | Stock | 141.68 | 142.3 | 141.12 | 142.27 | 19133469.0 |
| 2025-01-07 13:00:00 | NVDA | Stock | 142.2602 | 143.45 | 141.91 | 142.0399 | 18745849.0 |
| 2025-01-07 14:00:00 | NVDA | Stock | 142.035 | 142.53 | 141.08 | 141.25 | 15707117.0 |
| 2025-01-07 15:00:00 | NVDA | Stock | 141.26 | 141.58 | 140.01 | 140.12 | 34418703.0 |
| 2025-01-07 16:00:00 | NVDA | Stock | 140.12 | 141.39 | 140.01 | 141.39 | 23798252.0 |
| 2025-01-07 17:00:00 | NVDA | Stock | 141.36 | 141.58 | 141.09 | 141.2291 | 741293.0 |
| 2025-01-07 18:00:00 | NVDA | Stock | 141.21 | 141.5 | 141.0 | 141.45 | 572109.0 |
| 2025-01-07 19:00:00 | NVDA | Stock | 141.47 | 141.69 | 141.3674 | 141.5999 | 617067.0 |
| 2025-01-07 04:00:00 | AMZN | Stock | 227.35 | 227.62 | 226.58 | 226.85 | 10203.0 |
| 2025-01-07 05:00:00 | AMZN | Stock | 226.74 | 227.37 | 226.69 | 227.37 | 7068.0 |
> showing 50 of 65,185 rows — these rows as CSV