PREVIEW / stock_1hour / 2025-03-18
file: by_date/stock_1hour/2025/2025-03-18.parquet size: 1.4 MB rows: 60,742 symbols: 487
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-03-18 04:00:00 | AAPL | Stock | 213.73 | 213.91 | 213.6 | 213.72 | 7551.0 |
| 2025-03-18 05:00:00 | AAPL | Stock | 213.82 | 213.85 | 213.63 | 213.64 | 4593.0 |
| 2025-03-18 06:00:00 | AAPL | Stock | 213.65 | 214.0 | 213.25 | 213.91 | 28594.0 |
| 2025-03-18 07:00:00 | AAPL | Stock | 213.87 | 213.95 | 213.44 | 213.95 | 25619.0 |
| 2025-03-18 08:00:00 | AAPL | Stock | 213.88 | 214.0 | 213.0 | 213.42 | 83661.0 |
| 2025-03-18 09:00:00 | AAPL | Stock | 213.42 | 215.05 | 212.85 | 214.43 | 4880197.0 |
| 2025-03-18 10:00:00 | AAPL | Stock | 214.42 | 215.15 | 213.4701 | 213.715 | 4779325.0 |
| 2025-03-18 11:00:00 | AAPL | Stock | 213.7047 | 213.82 | 212.65 | 213.345 | 2963188.0 |
| 2025-03-18 12:00:00 | AAPL | Stock | 213.315 | 214.0 | 211.59 | 212.205 | 2877445.0 |
| 2025-03-18 13:00:00 | AAPL | Stock | 212.195 | 212.575 | 211.49 | 211.86 | 2533120.0 |
| 2025-03-18 14:00:00 | AAPL | Stock | 211.85 | 212.655 | 211.68 | 212.215 | 2308199.0 |
| 2025-03-18 15:00:00 | AAPL | Stock | 212.215 | 213.28 | 211.89 | 212.79 | 4483600.0 |
| 2025-03-18 16:00:00 | AAPL | Stock | 212.69 | 214.0 | 212.34 | 212.86 | 6254565.0 |
| 2025-03-18 17:00:00 | AAPL | Stock | 212.92 | 213.0 | 212.75 | 212.7835 | 9054.0 |
| 2025-03-18 18:00:00 | AAPL | Stock | 212.88 | 212.99 | 212.37 | 212.83 | 14617.0 |
| 2025-03-18 19:00:00 | AAPL | Stock | 212.75 | 213.0 | 212.6 | 213.0 | 16987.0 |
| 2025-03-18 04:00:00 | MSFT | Stock | 388.52 | 388.52 | 387.75 | 388.0 | 1283.0 |
| 2025-03-18 05:00:00 | MSFT | Stock | 388.14 | 388.15 | 387.42 | 387.42 | 730.0 |
| 2025-03-18 06:00:00 | MSFT | Stock | 386.9 | 387.42 | 386.5 | 387.42 | 6162.0 |
| 2025-03-18 07:00:00 | MSFT | Stock | 387.6 | 387.6 | 386.0 | 387.22 | 7950.0 |
| 2025-03-18 08:00:00 | MSFT | Stock | 386.77 | 388.22 | 386.4113 | 386.9999 | 16447.0 |
| 2025-03-18 09:00:00 | MSFT | Stock | 386.62 | 387.38 | 382.5 | 384.01 | 1353733.0 |
| 2025-03-18 10:00:00 | MSFT | Stock | 384.03 | 384.5995 | 382.81 | 383.125 | 1280132.0 |
| 2025-03-18 11:00:00 | MSFT | Stock | 383.125 | 383.43 | 382.02 | 382.695 | 889660.0 |
| 2025-03-18 12:00:00 | MSFT | Stock | 382.65 | 384.065 | 381.14 | 382.23 | 821878.0 |
| 2025-03-18 13:00:00 | MSFT | Stock | 382.23 | 383.2253 | 381.1 | 382.72 | 826757.0 |
| 2025-03-18 14:00:00 | MSFT | Stock | 382.6695 | 383.9 | 382.15 | 383.0 | 666549.0 |
| 2025-03-18 15:00:00 | MSFT | Stock | 383.0 | 384.0 | 382.37 | 383.58 | 1453389.0 |
| 2025-03-18 16:00:00 | MSFT | Stock | 383.5439 | 384.0 | 382.95 | 383.29 | 3838128.0 |
| 2025-03-18 17:00:00 | MSFT | Stock | 383.4291 | 383.4291 | 382.81 | 382.9 | 4926.0 |
| 2025-03-18 18:00:00 | MSFT | Stock | 383.26 | 383.44 | 382.9722 | 382.9722 | 3044.0 |
| 2025-03-18 19:00:00 | MSFT | Stock | 383.52 | 383.98 | 383.2552 | 383.2552 | 3266.0 |
| 2025-03-18 04:00:00 | NVDA | Stock | 119.19 | 120.73 | 119.19 | 120.45 | 507969.0 |
| 2025-03-18 05:00:00 | NVDA | Stock | 120.45 | 120.56 | 119.62 | 119.63 | 316738.0 |
| 2025-03-18 06:00:00 | NVDA | Stock | 119.64 | 120.01 | 119.19 | 119.96 | 481240.0 |
| 2025-03-18 07:00:00 | NVDA | Stock | 119.93 | 120.04 | 118.82 | 119.36 | 744702.0 |
| 2025-03-18 08:00:00 | NVDA | Stock | 119.63 | 120.73 | 118.46 | 118.4722 | 2106141.0 |
| 2025-03-18 09:00:00 | NVDA | Stock | 118.45 | 118.61 | 114.85 | 115.08 | 37872264.0 |
| 2025-03-18 10:00:00 | NVDA | Stock | 115.09 | 116.48 | 114.54 | 116.28 | 35847337.0 |
| 2025-03-18 11:00:00 | NVDA | Stock | 116.28 | 117.08 | 115.48 | 116.42 | 24574872.0 |
| 2025-03-18 12:00:00 | NVDA | Stock | 116.425 | 118.73 | 116.325 | 118.39 | 25443799.0 |
| 2025-03-18 13:00:00 | NVDA | Stock | 118.39 | 119.02 | 116.52 | 116.875 | 36430337.0 |
| 2025-03-18 14:00:00 | NVDA | Stock | 116.88 | 117.58 | 115.7407 | 117.0329 | 30509243.0 |
| 2025-03-18 15:00:00 | NVDA | Stock | 117.03 | 117.29 | 114.95 | 115.58 | 36808459.0 |
| 2025-03-18 16:00:00 | NVDA | Stock | 115.59 | 115.81 | 114.76 | 115.21 | 20632982.0 |
| 2025-03-18 17:00:00 | NVDA | Stock | 115.2 | 115.27 | 114.6801 | 115.04 | 846497.0 |
| 2025-03-18 18:00:00 | NVDA | Stock | 115.05 | 115.15 | 114.7 | 115.03 | 664832.0 |
| 2025-03-18 19:00:00 | NVDA | Stock | 115.0201 | 115.15 | 114.72 | 114.78 | 558057.0 |
| 2025-03-18 04:00:00 | AMZN | Stock | 195.99 | 196.35 | 195.74 | 196.06 | 13049.0 |
| 2025-03-18 05:00:00 | AMZN | Stock | 196.14 | 196.35 | 196.01 | 196.06 | 25315.0 |
> showing 50 of 60,742 rows — these rows as CSV