PREVIEW / stock_1hour / 2025-01-27
file: by_date/stock_1hour/2025/2025-01-27.parquet size: 1.5 MB rows: 67,310 symbols: 584
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-27 04:00:00 | AAPL | Stock | 219.9 | 220.94 | 218.2 | 220.89 | 133174.0 |
| 2025-01-27 05:00:00 | AAPL | Stock | 220.88 | 221.84 | 220.08 | 221.51 | 173448.0 |
| 2025-01-27 06:00:00 | AAPL | Stock | 221.51 | 223.0 | 220.45 | 221.8 | 244363.0 |
| 2025-01-27 07:00:00 | AAPL | Stock | 221.81 | 222.06 | 220.77 | 222.04 | 324591.0 |
| 2025-01-27 08:00:00 | AAPL | Stock | 221.26 | 223.62 | 218.06 | 223.26 | 787077.0 |
| 2025-01-27 09:00:00 | AAPL | Stock | 223.21 | 227.7 | 222.01 | 225.66 | 11966320.0 |
| 2025-01-27 10:00:00 | AAPL | Stock | 225.65 | 228.5876 | 224.82 | 227.79 | 7850258.0 |
| 2025-01-27 11:00:00 | AAPL | Stock | 227.76 | 229.78 | 227.51 | 228.445 | 7349308.0 |
| 2025-01-27 12:00:00 | AAPL | Stock | 228.4661 | 230.48 | 228.29 | 230.15 | 4990461.0 |
| 2025-01-27 13:00:00 | AAPL | Stock | 230.18 | 231.79 | 230.07 | 231.435 | 5031892.0 |
| 2025-01-27 14:00:00 | AAPL | Stock | 231.431 | 232.15 | 230.14 | 231.58 | 4871192.0 |
| 2025-01-27 15:00:00 | AAPL | Stock | 231.57 | 231.91 | 228.48 | 229.94 | 13101403.0 |
| 2025-01-27 16:00:00 | AAPL | Stock | 229.86 | 231.0 | 229.1 | 230.04 | 14782063.0 |
| 2025-01-27 17:00:00 | AAPL | Stock | 230.08 | 230.08 | 229.03 | 229.8 | 54512.0 |
| 2025-01-27 18:00:00 | AAPL | Stock | 229.8 | 230.0 | 228.6075 | 229.7745 | 52445.0 |
| 2025-01-27 19:00:00 | AAPL | Stock | 229.77 | 229.79 | 229.02 | 229.79 | 14647.0 |
| 2025-01-27 04:00:00 | MSFT | Stock | 427.57 | 435.65 | 423.46 | 423.51 | 187768.0 |
| 2025-01-27 05:00:00 | MSFT | Stock | 423.24 | 423.24 | 412.98 | 415.0 | 252992.0 |
| 2025-01-27 06:00:00 | MSFT | Stock | 414.77 | 418.84 | 410.05 | 416.66 | 314314.0 |
| 2025-01-27 07:00:00 | MSFT | Stock | 416.81 | 423.0 | 416.1 | 422.56 | 338244.0 |
| 2025-01-27 08:00:00 | MSFT | Stock | 417.75 | 435.0 | 416.06 | 426.79 | 384621.0 |
| 2025-01-27 09:00:00 | MSFT | Stock | 426.22 | 429.98 | 422.25 | 429.83 | 5216927.0 |
| 2025-01-27 10:00:00 | MSFT | Stock | 429.82 | 433.96 | 426.7 | 429.406 | 2999150.0 |
| 2025-01-27 11:00:00 | MSFT | Stock | 429.365 | 429.79 | 426.59 | 427.4633 | 1986126.0 |
| 2025-01-27 12:00:00 | MSFT | Stock | 427.4413 | 428.0989 | 426.25 | 427.94 | 1040453.0 |
| 2025-01-27 13:00:00 | MSFT | Stock | 428.01 | 431.81 | 427.91 | 431.63 | 1104577.0 |
| 2025-01-27 14:00:00 | MSFT | Stock | 431.604 | 434.79 | 431.54 | 432.96 | 1249583.0 |
| 2025-01-27 15:00:00 | MSFT | Stock | 432.98 | 435.2 | 432.96 | 434.57 | 2333588.0 |
| 2025-01-27 16:00:00 | MSFT | Stock | 434.56 | 436.54 | 434.56 | 435.5 | 4891136.0 |
| 2025-01-27 17:00:00 | MSFT | Stock | 435.7501 | 436.0 | 435.18 | 435.74 | 5654.0 |
| 2025-01-27 18:00:00 | MSFT | Stock | 435.64 | 435.64 | 433.7 | 435.5 | 12952.0 |
| 2025-01-27 19:00:00 | MSFT | Stock | 435.76 | 435.7924 | 434.1969 | 434.56 | 4456.0 |
| 2025-01-27 04:00:00 | NVDA | Stock | 133.37 | 135.9 | 128.14 | 128.2 | 7938279.0 |
| 2025-01-27 05:00:00 | NVDA | Stock | 128.22 | 129.12 | 122.75 | 124.2 | 7769275.0 |
| 2025-01-27 06:00:00 | NVDA | Stock | 124.21 | 127.77 | 123.5 | 124.93 | 10097790.0 |
| 2025-01-27 07:00:00 | NVDA | Stock | 124.94 | 127.0 | 124.74 | 126.19 | 10906376.0 |
| 2025-01-27 08:00:00 | NVDA | Stock | 126.23 | 134.92 | 122.7704 | 127.14 | 17582498.0 |
| 2025-01-27 09:00:00 | NVDA | Stock | 127.14 | 128.4 | 123.64 | 126.88 | 94487289.0 |
| 2025-01-27 10:00:00 | NVDA | Stock | 126.87 | 126.99 | 122.8 | 122.9999 | 92113929.0 |
| 2025-01-27 11:00:00 | NVDA | Stock | 122.99 | 123.3 | 117.26 | 120.27 | 125246904.0 |
| 2025-01-27 12:00:00 | NVDA | Stock | 120.28 | 121.75 | 118.49 | 118.505 | 63376089.0 |
| 2025-01-27 13:00:00 | NVDA | Stock | 118.5 | 119.96 | 117.8 | 117.8301 | 49235212.0 |
| 2025-01-27 14:00:00 | NVDA | Stock | 117.835 | 119.47 | 116.7 | 117.912 | 64140849.0 |
| 2025-01-27 15:00:00 | NVDA | Stock | 117.92 | 118.75 | 117.05 | 118.51 | 86720866.0 |
| 2025-01-27 16:00:00 | NVDA | Stock | 118.51 | 121.5164 | 118.3303 | 120.43 | 53535143.0 |
| 2025-01-27 17:00:00 | NVDA | Stock | 120.45 | 122.89 | 120.43 | 122.71 | 5637614.0 |
| 2025-01-27 18:00:00 | NVDA | Stock | 122.7003 | 122.95 | 118.42 | 121.231 | 4368114.0 |
| 2025-01-27 19:00:00 | NVDA | Stock | 121.2307 | 121.77 | 120.01 | 120.18 | 3098903.0 |
| 2025-01-27 04:00:00 | AMZN | Stock | 228.63 | 229.77 | 224.28 | 224.28 | 207378.0 |
| 2025-01-27 05:00:00 | AMZN | Stock | 224.35 | 224.55 | 219.0 | 219.48 | 343727.0 |
> showing 50 of 67,310 rows — these rows as CSV