PREVIEW / stock_1hour / 2024-11-12
file: by_date/stock_1hour/2024/2024-11-12.parquet size: 1.4 MB rows: 64,017 symbols: 727
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 |
|---|---|---|---|---|---|---|---|
| 2024-11-12 04:00:00 | AAPL | Stock | 223.2 | 223.75 | 223.01 | 223.2 | 18208.0 |
| 2024-11-12 05:00:00 | AAPL | Stock | 223.28 | 224.0 | 223.28 | 223.97 | 20292.0 |
| 2024-11-12 06:00:00 | AAPL | Stock | 223.99 | 224.19 | 223.61 | 224.19 | 9930.0 |
| 2024-11-12 07:00:00 | AAPL | Stock | 224.19 | 224.5 | 223.86 | 224.23 | 30654.0 |
| 2024-11-12 08:00:00 | AAPL | Stock | 224.25 | 224.7 | 223.45 | 224.5 | 98126.0 |
| 2024-11-12 09:00:00 | AAPL | Stock | 224.521 | 225.04 | 223.55 | 224.25 | 3281402.0 |
| 2024-11-12 10:00:00 | AAPL | Stock | 224.25 | 225.03 | 223.66 | 224.6 | 3052660.0 |
| 2024-11-12 11:00:00 | AAPL | Stock | 224.59 | 225.59 | 224.53 | 224.97 | 2876120.0 |
| 2024-11-12 12:00:00 | AAPL | Stock | 224.9695 | 225.07 | 223.386 | 223.4199 | 2421865.0 |
| 2024-11-12 13:00:00 | AAPL | Stock | 223.42 | 224.6 | 223.355 | 224.1498 | 1852948.0 |
| 2024-11-12 14:00:00 | AAPL | Stock | 224.13 | 224.77 | 224.13 | 224.53 | 1487446.0 |
| 2024-11-12 15:00:00 | AAPL | Stock | 224.53 | 224.82 | 223.9404 | 224.24 | 5100716.0 |
| 2024-11-12 16:00:00 | AAPL | Stock | 224.21 | 224.31 | 223.81 | 224.0 | 8699733.0 |
| 2024-11-12 17:00:00 | AAPL | Stock | 223.98 | 224.35 | 223.98 | 224.19 | 16996.0 |
| 2024-11-12 18:00:00 | AAPL | Stock | 224.2 | 224.2736 | 224.01 | 224.2 | 47162.0 |
| 2024-11-12 19:00:00 | AAPL | Stock | 224.19 | 224.2 | 224.01 | 224.09 | 7684.0 |
| 2024-11-12 04:00:00 | MSFT | Stock | 417.28 | 417.28 | 416.79 | 417.2 | 1557.0 |
| 2024-11-12 05:00:00 | MSFT | Stock | 417.4 | 418.0 | 416.98 | 417.88 | 3277.0 |
| 2024-11-12 06:00:00 | MSFT | Stock | 417.5 | 418.01 | 417.0 | 418.01 | 5907.0 |
| 2024-11-12 07:00:00 | MSFT | Stock | 418.05 | 418.05 | 417.45 | 417.5 | 11430.0 |
| 2024-11-12 08:00:00 | MSFT | Stock | 417.83 | 418.799 | 416.86 | 418.3 | 45275.0 |
| 2024-11-12 09:00:00 | MSFT | Stock | 418.289 | 420.5899 | 417.1 | 418.745 | 1532432.0 |
| 2024-11-12 10:00:00 | MSFT | Stock | 418.8 | 420.3 | 417.71 | 419.0002 | 1146693.0 |
| 2024-11-12 11:00:00 | MSFT | Stock | 419.01 | 420.43 | 419.01 | 419.94 | 759305.0 |
| 2024-11-12 12:00:00 | MSFT | Stock | 419.945 | 421.73 | 419.72 | 419.79 | 1027589.0 |
| 2024-11-12 13:00:00 | MSFT | Stock | 419.765 | 423.2 | 419.6351 | 422.84 | 781781.0 |
| 2024-11-12 14:00:00 | MSFT | Stock | 422.82 | 423.84 | 422.7401 | 423.71 | 705269.0 |
| 2024-11-12 15:00:00 | MSFT | Stock | 423.72 | 424.44 | 421.64 | 423.13 | 1711994.0 |
| 2024-11-12 16:00:00 | MSFT | Stock | 423.03 | 424.0 | 423.03 | 423.6 | 4707198.0 |
| 2024-11-12 17:00:00 | MSFT | Stock | 423.4148 | 423.5496 | 423.3 | 423.5 | 3969.0 |
| 2024-11-12 18:00:00 | MSFT | Stock | 423.4 | 423.4 | 423.03 | 423.25 | 25420.0 |
| 2024-11-12 19:00:00 | MSFT | Stock | 423.35 | 423.35 | 423.06 | 423.35 | 3172.0 |
| 2024-11-12 04:00:00 | NVDA | Stock | 144.9 | 145.25 | 143.89 | 144.13 | 471406.0 |
| 2024-11-12 05:00:00 | NVDA | Stock | 144.08 | 144.18 | 143.38 | 143.81 | 487090.0 |
| 2024-11-12 06:00:00 | NVDA | Stock | 143.88 | 144.69 | 143.82 | 144.58 | 307392.0 |
| 2024-11-12 07:00:00 | NVDA | Stock | 144.6 | 145.97 | 144.25 | 145.62 | 1007918.0 |
| 2024-11-12 08:00:00 | NVDA | Stock | 144.52 | 146.86 | 143.95 | 146.78 | 2712989.0 |
| 2024-11-12 09:00:00 | NVDA | Stock | 146.78 | 148.32 | 146.01 | 147.88 | 30341651.0 |
| 2024-11-12 10:00:00 | NVDA | Stock | 147.88 | 149.65 | 147.62 | 148.31 | 35871195.0 |
| 2024-11-12 11:00:00 | NVDA | Stock | 148.32 | 149.37 | 147.93 | 148.5901 | 18479304.0 |
| 2024-11-12 12:00:00 | NVDA | Stock | 148.59 | 148.67 | 146.83 | 146.93 | 15932655.0 |
| 2024-11-12 13:00:00 | NVDA | Stock | 146.94 | 148.4198 | 146.58 | 148.12 | 14455925.0 |
| 2024-11-12 14:00:00 | NVDA | Stock | 148.11 | 148.7451 | 147.705 | 148.5 | 11107055.0 |
| 2024-11-12 15:00:00 | NVDA | Stock | 148.51 | 148.58 | 147.55 | 148.39 | 15444179.0 |
| 2024-11-12 16:00:00 | NVDA | Stock | 148.4 | 148.43 | 148.15 | 148.2 | 13957712.0 |
| 2024-11-12 17:00:00 | NVDA | Stock | 148.21 | 148.68 | 148.16 | 148.67 | 518931.0 |
| 2024-11-12 18:00:00 | NVDA | Stock | 148.6503 | 148.75 | 148.25 | 148.51 | 365428.0 |
| 2024-11-12 19:00:00 | NVDA | Stock | 148.52 | 148.52 | 148.1704 | 148.2 | 328508.0 |
| 2024-11-12 04:00:00 | AMZN | Stock | 206.28 | 206.6 | 206.03 | 206.41 | 12985.0 |
| 2024-11-12 05:00:00 | AMZN | Stock | 206.41 | 206.65 | 205.94 | 206.65 | 18831.0 |
> showing 50 of 64,017 rows — these rows as CSV