PREVIEW / stock_1hour / 2025-01-16
file: by_date/stock_1hour/2025/2025-01-16.parquet size: 1.4 MB rows: 63,451 symbols: 585
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-16 04:00:00 | AAPL | Stock | 240.4 | 241.41 | 238.88 | 239.5 | 33219.0 |
| 2025-01-16 05:00:00 | AAPL | Stock | 239.28 | 239.68 | 239.14 | 239.55 | 6769.0 |
| 2025-01-16 06:00:00 | AAPL | Stock | 239.55 | 239.61 | 239.46 | 239.6 | 4584.0 |
| 2025-01-16 07:00:00 | AAPL | Stock | 239.58 | 239.6 | 238.7 | 238.7 | 18853.0 |
| 2025-01-16 08:00:00 | AAPL | Stock | 239.16 | 241.41 | 238.0 | 238.7 | 100545.0 |
| 2025-01-16 09:00:00 | AAPL | Stock | 238.77 | 238.82 | 234.74 | 234.845 | 4524259.0 |
| 2025-01-16 10:00:00 | AAPL | Stock | 234.845 | 235.17 | 231.16 | 231.9601 | 8523438.0 |
| 2025-01-16 11:00:00 | AAPL | Stock | 231.965 | 232.3125 | 229.75 | 230.6854 | 7693622.0 |
| 2025-01-16 12:00:00 | AAPL | Stock | 230.68 | 231.2 | 230.38 | 230.46 | 4318866.0 |
| 2025-01-16 13:00:00 | AAPL | Stock | 230.48 | 230.67 | 228.62 | 229.0 | 5119967.0 |
| 2025-01-16 14:00:00 | AAPL | Stock | 228.98 | 229.93 | 228.56 | 229.86 | 4127478.0 |
| 2025-01-16 15:00:00 | AAPL | Stock | 229.855 | 230.0686 | 228.03 | 228.24 | 10004890.0 |
| 2025-01-16 16:00:00 | AAPL | Stock | 228.26 | 228.3 | 227.7 | 228.3 | 8712592.0 |
| 2025-01-16 17:00:00 | AAPL | Stock | 228.33 | 228.37 | 228.05 | 228.24 | 61756.0 |
| 2025-01-16 18:00:00 | AAPL | Stock | 228.2091 | 228.65 | 228.2091 | 228.47 | 49761.0 |
| 2025-01-16 19:00:00 | AAPL | Stock | 228.45 | 228.58 | 228.3512 | 228.4 | 52177.0 |
| 2025-01-16 04:00:00 | MSFT | Stock | 429.99 | 429.99 | 427.27 | 428.11 | 18029.0 |
| 2025-01-16 05:00:00 | MSFT | Stock | 427.8 | 429.0 | 427.37 | 428.99 | 3617.0 |
| 2025-01-16 06:00:00 | MSFT | Stock | 428.95 | 429.29 | 428.33 | 429.15 | 4239.0 |
| 2025-01-16 07:00:00 | MSFT | Stock | 428.97 | 429.25 | 427.35 | 427.48 | 12853.0 |
| 2025-01-16 08:00:00 | MSFT | Stock | 428.71 | 430.29 | 426.74 | 427.6 | 33588.0 |
| 2025-01-16 09:00:00 | MSFT | Stock | 427.75 | 429.49 | 425.62 | 426.825 | 1426459.0 |
| 2025-01-16 10:00:00 | MSFT | Stock | 426.825 | 428.1627 | 425.02 | 427.4099 | 1045714.0 |
| 2025-01-16 11:00:00 | MSFT | Stock | 427.4 | 428.22 | 426.03 | 427.26 | 741193.0 |
| 2025-01-16 12:00:00 | MSFT | Stock | 427.19 | 427.46 | 426.48 | 426.91 | 474566.0 |
| 2025-01-16 13:00:00 | MSFT | Stock | 426.87 | 427.6 | 425.1142 | 425.585 | 663000.0 |
| 2025-01-16 14:00:00 | MSFT | Stock | 425.56 | 427.74 | 425.16 | 427.58 | 780526.0 |
| 2025-01-16 15:00:00 | MSFT | Stock | 427.56 | 428.08 | 424.39 | 424.54 | 1201061.0 |
| 2025-01-16 16:00:00 | MSFT | Stock | 424.53 | 424.67 | 422.601 | 423.45 | 3339879.0 |
| 2025-01-16 17:00:00 | MSFT | Stock | 423.7 | 423.99 | 423.4 | 423.5 | 3184.0 |
| 2025-01-16 18:00:00 | MSFT | Stock | 423.58 | 423.88 | 423.441 | 423.551 | 7163.0 |
| 2025-01-16 19:00:00 | MSFT | Stock | 423.89 | 423.89 | 423.05 | 423.44 | 6037.0 |
| 2025-01-16 04:00:00 | NVDA | Stock | 139.02 | 140.25 | 137.68 | 138.46 | 1374882.0 |
| 2025-01-16 05:00:00 | NVDA | Stock | 138.47 | 138.99 | 137.94 | 138.47 | 576161.0 |
| 2025-01-16 06:00:00 | NVDA | Stock | 138.45 | 139.01 | 138.41 | 138.6 | 322174.0 |
| 2025-01-16 07:00:00 | NVDA | Stock | 138.57 | 138.61 | 137.361 | 137.86 | 1159093.0 |
| 2025-01-16 08:00:00 | NVDA | Stock | 138.55 | 140.1 | 134.75 | 138.24 | 3883255.0 |
| 2025-01-16 09:00:00 | NVDA | Stock | 138.2393 | 138.84 | 136.46 | 137.1 | 27963764.0 |
| 2025-01-16 10:00:00 | NVDA | Stock | 137.089 | 137.74 | 136.09 | 136.842 | 23471128.0 |
| 2025-01-16 11:00:00 | NVDA | Stock | 136.85 | 137.28 | 134.11 | 135.1575 | 24363144.0 |
| 2025-01-16 12:00:00 | NVDA | Stock | 135.15 | 135.67 | 134.84 | 135.015 | 12601736.0 |
| 2025-01-16 13:00:00 | NVDA | Stock | 135.02 | 135.2399 | 133.55 | 134.44 | 15852726.0 |
| 2025-01-16 14:00:00 | NVDA | Stock | 134.43 | 135.8686 | 134.27 | 135.74 | 16433511.0 |
| 2025-01-16 15:00:00 | NVDA | Stock | 135.74 | 135.82 | 133.49 | 133.57 | 19471886.0 |
| 2025-01-16 16:00:00 | NVDA | Stock | 133.57 | 134.0782 | 133.27 | 133.58 | 19418885.0 |
| 2025-01-16 17:00:00 | NVDA | Stock | 133.58 | 133.96 | 133.55 | 133.75 | 341661.0 |
| 2025-01-16 18:00:00 | NVDA | Stock | 133.75 | 133.92 | 133.62 | 133.69 | 284556.0 |
| 2025-01-16 19:00:00 | NVDA | Stock | 133.7285 | 133.9 | 133.4303 | 133.83 | 398151.0 |
| 2025-01-16 04:00:00 | AMZN | Stock | 224.01 | 225.31 | 224.01 | 224.35 | 20160.0 |
| 2025-01-16 05:00:00 | AMZN | Stock | 224.28 | 224.49 | 224.1 | 224.3 | 8057.0 |
> showing 50 of 63,451 rows — these rows as CSV