PREVIEW / stock_1hour / 2024-09-24
file: by_date/stock_1hour/2024/2024-09-24.parquet size: 1.4 MB rows: 60,213 symbols: 799
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-09-24 04:00:00 | AAPL | Stock | 226.97 | 228.12 | 226.97 | 227.97 | 40288.0 |
| 2024-09-24 05:00:00 | AAPL | Stock | 227.99 | 228.57 | 227.76 | 228.15 | 17125.0 |
| 2024-09-24 06:00:00 | AAPL | Stock | 228.12 | 228.38 | 227.82 | 227.85 | 18186.0 |
| 2024-09-24 07:00:00 | AAPL | Stock | 227.8 | 228.16 | 227.0 | 227.76 | 71969.0 |
| 2024-09-24 08:00:00 | AAPL | Stock | 227.5 | 228.4 | 225.904 | 228.1 | 144440.0 |
| 2024-09-24 09:00:00 | AAPL | Stock | 228.08 | 229.35 | 227.17 | 227.41 | 3246771.0 |
| 2024-09-24 10:00:00 | AAPL | Stock | 227.43 | 227.43 | 225.73 | 227.185 | 4195319.0 |
| 2024-09-24 11:00:00 | AAPL | Stock | 227.1857 | 227.615 | 226.7 | 227.45 | 2046469.0 |
| 2024-09-24 12:00:00 | AAPL | Stock | 227.465 | 227.76 | 226.97 | 227.0 | 1469816.0 |
| 2024-09-24 13:00:00 | AAPL | Stock | 227.0195 | 227.49 | 226.81 | 227.29 | 1345516.0 |
| 2024-09-24 14:00:00 | AAPL | Stock | 227.3 | 227.39 | 226.54 | 226.87 | 1483410.0 |
| 2024-09-24 15:00:00 | AAPL | Stock | 226.87 | 227.5 | 226.2 | 227.36 | 3623179.0 |
| 2024-09-24 16:00:00 | AAPL | Stock | 227.37 | 227.77 | 227.13 | 227.56 | 13265424.0 |
| 2024-09-24 17:00:00 | AAPL | Stock | 227.52 | 227.75 | 227.37 | 227.5701 | 455542.0 |
| 2024-09-24 18:00:00 | AAPL | Stock | 227.64 | 227.64 | 227.43 | 227.54 | 15090.0 |
| 2024-09-24 19:00:00 | AAPL | Stock | 227.54 | 227.72 | 227.41 | 227.5128 | 38156.0 |
| 2024-09-24 04:00:00 | MSFT | Stock | 434.0 | 434.48 | 433.64 | 433.88 | 2044.0 |
| 2024-09-24 05:00:00 | MSFT | Stock | 433.6 | 433.8 | 433.39 | 433.8 | 1404.0 |
| 2024-09-24 06:00:00 | MSFT | Stock | 433.5 | 433.6 | 433.25 | 433.25 | 2829.0 |
| 2024-09-24 07:00:00 | MSFT | Stock | 433.2 | 433.5 | 432.25 | 433.2 | 8174.0 |
| 2024-09-24 08:00:00 | MSFT | Stock | 433.25 | 433.5829 | 432.43 | 432.9486 | 13837.0 |
| 2024-09-24 09:00:00 | MSFT | Stock | 433.26 | 433.7574 | 428.83 | 429.0509 | 1393900.0 |
| 2024-09-24 10:00:00 | MSFT | Stock | 429.02 | 429.2229 | 426.1 | 428.37 | 1738137.0 |
| 2024-09-24 11:00:00 | MSFT | Stock | 428.365 | 429.77 | 428.27 | 429.7 | 1002935.0 |
| 2024-09-24 12:00:00 | MSFT | Stock | 429.7 | 430.5396 | 428.88 | 428.92 | 519103.0 |
| 2024-09-24 13:00:00 | MSFT | Stock | 428.935 | 429.6499 | 428.82 | 429.14 | 384909.0 |
| 2024-09-24 14:00:00 | MSFT | Stock | 429.175 | 429.3732 | 427.56 | 428.46 | 613777.0 |
| 2024-09-24 15:00:00 | MSFT | Stock | 428.455 | 429.41 | 428.27 | 429.305 | 1320907.0 |
| 2024-09-24 16:00:00 | MSFT | Stock | 429.305 | 430.19 | 429.14 | 429.82 | 4766096.0 |
| 2024-09-24 17:00:00 | MSFT | Stock | 429.9096 | 429.95 | 429.17 | 429.919 | 82405.0 |
| 2024-09-24 18:00:00 | MSFT | Stock | 429.85 | 430.19 | 429.84 | 430.14 | 7657.0 |
| 2024-09-24 19:00:00 | MSFT | Stock | 430.04 | 430.2989 | 429.7 | 429.95 | 9793.0 |
| 2024-09-24 04:00:00 | NVDA | Stock | 116.6 | 117.28 | 116.25 | 116.97 | 603942.0 |
| 2024-09-24 05:00:00 | NVDA | Stock | 116.96 | 117.12 | 116.7 | 116.8 | 385914.0 |
| 2024-09-24 06:00:00 | NVDA | Stock | 116.79 | 117.0 | 116.64 | 116.7 | 198149.0 |
| 2024-09-24 07:00:00 | NVDA | Stock | 116.68 | 116.8 | 116.07 | 116.37 | 845769.0 |
| 2024-09-24 08:00:00 | NVDA | Stock | 116.51 | 117.1864 | 116.07 | 116.38 | 1501214.0 |
| 2024-09-24 09:00:00 | NVDA | Stock | 116.35 | 117.61 | 116.25 | 117.205 | 26505972.0 |
| 2024-09-24 10:00:00 | NVDA | Stock | 117.21 | 117.21 | 115.38 | 116.1062 | 36530086.0 |
| 2024-09-24 11:00:00 | NVDA | Stock | 116.105 | 121.24 | 115.94 | 120.4379 | 72767151.0 |
| 2024-09-24 12:00:00 | NVDA | Stock | 120.44 | 121.62 | 120.38 | 120.8601 | 52104660.0 |
| 2024-09-24 13:00:00 | NVDA | Stock | 120.87 | 121.8 | 120.72 | 121.31 | 30319373.0 |
| 2024-09-24 14:00:00 | NVDA | Stock | 121.32 | 121.55 | 121.0201 | 121.26 | 23295956.0 |
| 2024-09-24 15:00:00 | NVDA | Stock | 121.25 | 121.27 | 120.1 | 120.95 | 39953723.0 |
| 2024-09-24 16:00:00 | NVDA | Stock | 120.95 | 121.3 | 120.83 | 121.29 | 34876520.0 |
| 2024-09-24 17:00:00 | NVDA | Stock | 121.279 | 121.3 | 120.87 | 121.28 | 1047406.0 |
| 2024-09-24 18:00:00 | NVDA | Stock | 121.28 | 121.63 | 121.25 | 121.63 | 664019.0 |
| 2024-09-24 19:00:00 | NVDA | Stock | 121.6295 | 121.83 | 121.6 | 121.79 | 926523.0 |
| 2024-09-24 04:00:00 | AMZN | Stock | 191.0 | 193.12 | 190.28 | 192.59 | 90571.0 |
| 2024-09-24 05:00:00 | AMZN | Stock | 192.6 | 192.63 | 192.02 | 192.36 | 11802.0 |
> showing 50 of 60,213 rows — these rows as CSV