PREVIEW / stock_1hour / 2025-05-16
file: by_date/stock_1hour/2025/2025-05-16.parquet size: 1.4 MB rows: 62,143 symbols: 414
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-05-16 04:00:00 | AAPL | Stock | 211.75 | 212.05 | 211.73 | 211.9 | 21478.0 |
| 2025-05-16 05:00:00 | AAPL | Stock | 212.0 | 212.0 | 211.72 | 211.87 | 8920.0 |
| 2025-05-16 06:00:00 | AAPL | Stock | 211.76 | 211.78 | 211.0 | 211.7 | 16758.0 |
| 2025-05-16 07:00:00 | AAPL | Stock | 211.7 | 211.97 | 211.52 | 211.79 | 12132.0 |
| 2025-05-16 08:00:00 | AAPL | Stock | 211.75 | 212.0496 | 211.13 | 211.88 | 126132.0 |
| 2025-05-16 09:00:00 | AAPL | Stock | 211.88 | 212.8 | 211.01 | 211.75 | 6880109.0 |
| 2025-05-16 10:00:00 | AAPL | Stock | 211.72 | 211.93 | 209.77 | 210.2301 | 4322014.0 |
| 2025-05-16 11:00:00 | AAPL | Stock | 210.24 | 210.92 | 209.905 | 210.67 | 2848354.0 |
| 2025-05-16 12:00:00 | AAPL | Stock | 210.67 | 211.17 | 210.45 | 210.911 | 1986716.0 |
| 2025-05-16 13:00:00 | AAPL | Stock | 210.91 | 211.42 | 210.73 | 210.975 | 1847797.0 |
| 2025-05-16 14:00:00 | AAPL | Stock | 210.9764 | 211.8998 | 210.925 | 211.525 | 2289895.0 |
| 2025-05-16 15:00:00 | AAPL | Stock | 211.52 | 211.93 | 211.11 | 211.19 | 3855098.0 |
| 2025-05-16 16:00:00 | AAPL | Stock | 211.26 | 211.41 | 209.92 | 210.3993 | 9226633.0 |
| 2025-05-16 17:00:00 | AAPL | Stock | 210.29 | 211.26 | 209.33 | 209.4 | 56781.0 |
| 2025-05-16 18:00:00 | AAPL | Stock | 209.48 | 209.69 | 207.8 | 207.94 | 91876.0 |
| 2025-05-16 19:00:00 | AAPL | Stock | 207.97 | 208.9373 | 207.8 | 207.93 | 75886.0 |
| 2025-05-16 04:00:00 | MSFT | Stock | 452.41 | 453.28 | 446.31 | 452.86 | 4447.0 |
| 2025-05-16 05:00:00 | MSFT | Stock | 452.61 | 453.39 | 452.5 | 453.39 | 6798.0 |
| 2025-05-16 06:00:00 | MSFT | Stock | 452.93 | 453.13 | 452.7 | 453.1 | 1074.0 |
| 2025-05-16 07:00:00 | MSFT | Stock | 452.98 | 453.13 | 452.63 | 452.96 | 5233.0 |
| 2025-05-16 08:00:00 | MSFT | Stock | 453.0 | 453.64 | 451.5 | 451.61 | 23444.0 |
| 2025-05-16 09:00:00 | MSFT | Stock | 451.2528 | 454.0 | 449.35 | 450.065 | 3345311.0 |
| 2025-05-16 10:00:00 | MSFT | Stock | 450.02 | 451.455 | 448.96 | 449.97 | 1596631.0 |
| 2025-05-16 11:00:00 | MSFT | Stock | 449.96 | 450.2 | 448.73 | 449.81 | 841620.0 |
| 2025-05-16 12:00:00 | MSFT | Stock | 449.82 | 450.88 | 449.71 | 450.185 | 1167647.0 |
| 2025-05-16 13:00:00 | MSFT | Stock | 450.14 | 452.2388 | 449.8 | 452.09 | 931004.0 |
| 2025-05-16 14:00:00 | MSFT | Stock | 452.0106 | 453.26 | 451.81 | 452.57 | 828012.0 |
| 2025-05-16 15:00:00 | MSFT | Stock | 452.6 | 454.36 | 451.7701 | 454.26 | 1944650.0 |
| 2025-05-16 16:00:00 | MSFT | Stock | 454.27 | 454.62 | 452.04 | 452.71 | 5018315.0 |
| 2025-05-16 17:00:00 | MSFT | Stock | 452.69 | 454.27 | 451.4858 | 451.7 | 14618.0 |
| 2025-05-16 18:00:00 | MSFT | Stock | 451.6 | 452.0 | 450.003 | 450.003 | 13775.0 |
| 2025-05-16 19:00:00 | MSFT | Stock | 450.49 | 451.99 | 449.51 | 449.5555 | 11742.0 |
| 2025-05-16 04:00:00 | NVDA | Stock | 134.95 | 136.08 | 133.99 | 135.86 | 663267.0 |
| 2025-05-16 05:00:00 | NVDA | Stock | 135.89 | 135.93 | 135.65 | 135.73 | 183077.0 |
| 2025-05-16 06:00:00 | NVDA | Stock | 135.72 | 135.97 | 135.38 | 135.92 | 262933.0 |
| 2025-05-16 07:00:00 | NVDA | Stock | 135.9 | 136.39 | 135.61 | 136.39 | 707061.0 |
| 2025-05-16 08:00:00 | NVDA | Stock | 136.39 | 136.89 | 134.7 | 136.3 | 3304371.0 |
| 2025-05-16 09:00:00 | NVDA | Stock | 136.3 | 136.58 | 135.03 | 135.55 | 28975951.0 |
| 2025-05-16 10:00:00 | NVDA | Stock | 135.52 | 136.12 | 133.46 | 134.33 | 35141005.0 |
| 2025-05-16 11:00:00 | NVDA | Stock | 134.325 | 135.33 | 134.32 | 134.665 | 17436836.0 |
| 2025-05-16 12:00:00 | NVDA | Stock | 134.665 | 135.16 | 134.535 | 134.625 | 11660699.0 |
| 2025-05-16 13:00:00 | NVDA | Stock | 134.623 | 136.25 | 134.43 | 135.545 | 23166242.0 |
| 2025-05-16 14:00:00 | NVDA | Stock | 135.55 | 135.56 | 134.95 | 135.12 | 13480702.0 |
| 2025-05-16 15:00:00 | NVDA | Stock | 135.12 | 135.64 | 134.875 | 135.32 | 23903233.0 |
| 2025-05-16 16:00:00 | NVDA | Stock | 135.32 | 135.5 | 134.71 | 134.83 | 18418274.0 |
| 2025-05-16 17:00:00 | NVDA | Stock | 134.89 | 135.0494 | 133.91 | 133.96 | 1578916.0 |
| 2025-05-16 18:00:00 | NVDA | Stock | 134.03 | 134.38 | 131.8301 | 132.5117 | 2101948.0 |
| 2025-05-16 19:00:00 | NVDA | Stock | 132.54 | 133.23 | 132.08 | 132.1 | 1282782.0 |
| 2025-05-16 04:00:00 | AMZN | Stock | 205.76 | 206.41 | 205.58 | 206.2 | 32079.0 |
| 2025-05-16 05:00:00 | AMZN | Stock | 206.2 | 206.2 | 205.53 | 205.7 | 28853.0 |
> showing 50 of 62,143 rows — these rows as CSV