PREVIEW / stock_1hour / 2025-03-19
file: by_date/stock_1hour/2025/2025-03-19.parquet size: 1.4 MB rows: 60,443 symbols: 478
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-19 04:00:00 | AAPL | Stock | 213.58 | 213.58 | 212.92 | 213.0 | 8680.0 |
| 2025-03-19 05:00:00 | AAPL | Stock | 213.0 | 213.31 | 212.95 | 213.31 | 3136.0 |
| 2025-03-19 06:00:00 | AAPL | Stock | 213.33 | 213.43 | 213.27 | 213.29 | 6291.0 |
| 2025-03-19 07:00:00 | AAPL | Stock | 213.26 | 213.36 | 213.06 | 213.24 | 8767.0 |
| 2025-03-19 08:00:00 | AAPL | Stock | 213.26 | 213.498 | 212.62 | 213.29 | 41928.0 |
| 2025-03-19 09:00:00 | AAPL | Stock | 213.29 | 217.72 | 213.0 | 217.155 | 4966576.0 |
| 2025-03-19 10:00:00 | AAPL | Stock | 217.18 | 218.76 | 215.45 | 215.55 | 6095522.0 |
| 2025-03-19 11:00:00 | AAPL | Stock | 215.51 | 216.75 | 214.96 | 216.269 | 3212487.0 |
| 2025-03-19 12:00:00 | AAPL | Stock | 216.24 | 216.34 | 214.44 | 214.9573 | 2266412.0 |
| 2025-03-19 13:00:00 | AAPL | Stock | 214.97 | 215.1 | 213.86 | 214.07 | 2212972.0 |
| 2025-03-19 14:00:00 | AAPL | Stock | 213.98 | 215.605 | 213.75 | 215.5888 | 4020793.0 |
| 2025-03-19 15:00:00 | AAPL | Stock | 215.57 | 217.059 | 214.48 | 215.3 | 6075763.0 |
| 2025-03-19 16:00:00 | AAPL | Stock | 215.24 | 215.55 | 215.24 | 215.3301 | 12811713.0 |
| 2025-03-19 17:00:00 | AAPL | Stock | 215.33 | 215.5997 | 215.33 | 215.5 | 16112.0 |
| 2025-03-19 18:00:00 | AAPL | Stock | 215.47 | 215.84 | 215.41 | 215.8 | 16288.0 |
| 2025-03-19 19:00:00 | AAPL | Stock | 215.837 | 216.3 | 215.75 | 216.15 | 21457.0 |
| 2025-03-19 04:00:00 | MSFT | Stock | 384.73 | 384.73 | 383.27 | 383.4 | 1540.0 |
| 2025-03-19 05:00:00 | MSFT | Stock | 383.5 | 384.46 | 383.5 | 384.46 | 1585.0 |
| 2025-03-19 06:00:00 | MSFT | Stock | 384.47 | 384.47 | 384.12 | 384.3 | 1027.0 |
| 2025-03-19 07:00:00 | MSFT | Stock | 384.33 | 384.98 | 384.33 | 384.79 | 3681.0 |
| 2025-03-19 08:00:00 | MSFT | Stock | 384.33 | 384.98 | 384.1056 | 384.2 | 7910.0 |
| 2025-03-19 09:00:00 | MSFT | Stock | 384.3 | 387.5799 | 383.55 | 386.92 | 1189327.0 |
| 2025-03-19 10:00:00 | MSFT | Stock | 387.01 | 387.92 | 385.44 | 385.5 | 741633.0 |
| 2025-03-19 11:00:00 | MSFT | Stock | 385.5 | 387.6681 | 385.4 | 387.39 | 727741.0 |
| 2025-03-19 12:00:00 | MSFT | Stock | 387.44 | 387.9694 | 386.07 | 386.6964 | 684017.0 |
| 2025-03-19 13:00:00 | MSFT | Stock | 386.695 | 386.94 | 384.64 | 385.34 | 689285.0 |
| 2025-03-19 14:00:00 | MSFT | Stock | 385.315 | 388.41 | 384.9 | 388.25 | 1085624.0 |
| 2025-03-19 15:00:00 | MSFT | Stock | 388.24 | 389.68 | 387.0 | 387.87 | 1773319.0 |
| 2025-03-19 16:00:00 | MSFT | Stock | 387.82 | 388.48 | 387.04 | 387.39 | 6005987.0 |
| 2025-03-19 17:00:00 | MSFT | Stock | 387.4 | 387.65 | 387.2 | 387.3178 | 8366.0 |
| 2025-03-19 18:00:00 | MSFT | Stock | 387.3 | 388.5 | 387.0016 | 388.5 | 5793.0 |
| 2025-03-19 19:00:00 | MSFT | Stock | 388.47 | 389.35 | 388.47 | 389.1909 | 6002.0 |
| 2025-03-19 04:00:00 | NVDA | Stock | 114.9 | 116.2 | 114.9 | 115.97 | 488876.0 |
| 2025-03-19 05:00:00 | NVDA | Stock | 115.96 | 116.95 | 115.83 | 116.8 | 508069.0 |
| 2025-03-19 06:00:00 | NVDA | Stock | 116.82 | 117.24 | 116.55 | 116.67 | 588211.0 |
| 2025-03-19 07:00:00 | NVDA | Stock | 116.64 | 117.0 | 116.21 | 116.75 | 854014.0 |
| 2025-03-19 08:00:00 | NVDA | Stock | 116.54 | 117.22 | 114.74 | 116.8597 | 2192799.0 |
| 2025-03-19 09:00:00 | NVDA | Stock | 116.81 | 118.16 | 115.68 | 116.89 | 30524615.0 |
| 2025-03-19 10:00:00 | NVDA | Stock | 116.9 | 118.0 | 116.35 | 116.4261 | 32584439.0 |
| 2025-03-19 11:00:00 | NVDA | Stock | 116.415 | 117.72 | 116.29 | 117.56 | 20167316.0 |
| 2025-03-19 12:00:00 | NVDA | Stock | 117.55 | 118.13 | 117.0 | 118.0099 | 22121305.0 |
| 2025-03-19 13:00:00 | NVDA | Stock | 118.0 | 118.25 | 117.27 | 117.89 | 18605385.0 |
| 2025-03-19 14:00:00 | NVDA | Stock | 117.83 | 119.58 | 117.59 | 119.57 | 33750592.0 |
| 2025-03-19 15:00:00 | NVDA | Stock | 119.56 | 120.445 | 117.39 | 117.52 | 47474830.0 |
| 2025-03-19 16:00:00 | NVDA | Stock | 117.52 | 117.69 | 117.2 | 117.54 | 27378207.0 |
| 2025-03-19 17:00:00 | NVDA | Stock | 117.54 | 117.99 | 117.52 | 117.9201 | 689153.0 |
| 2025-03-19 18:00:00 | NVDA | Stock | 117.92 | 118.6406 | 117.85 | 118.4 | 1043461.0 |
| 2025-03-19 19:00:00 | NVDA | Stock | 118.3902 | 118.8 | 118.31 | 118.79 | 674555.0 |
| 2025-03-19 04:00:00 | AMZN | Stock | 193.36 | 193.46 | 192.32 | 192.93 | 13433.0 |
| 2025-03-19 05:00:00 | AMZN | Stock | 192.8 | 193.21 | 192.61 | 193.12 | 5277.0 |
> showing 50 of 60,443 rows — these rows as CSV