PREVIEW / stock_1hour / 2024-01-22
file: by_date/stock_1hour/2024/2024-01-22.parquet size: 1.4 MB rows: 59,864 symbols: 1,196
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-01-22 04:00:00 | AAPL | Stock | 192.18 | 192.18 | 191.56 | 191.92 | 16998.0 |
| 2024-01-22 05:00:00 | AAPL | Stock | 191.92 | 192.13 | 191.9 | 191.97 | 21017.0 |
| 2024-01-22 06:00:00 | AAPL | Stock | 192.03 | 192.18 | 192.0 | 192.02 | 8608.0 |
| 2024-01-22 07:00:00 | AAPL | Stock | 192.0 | 192.72 | 191.95 | 192.54 | 56766.0 |
| 2024-01-22 08:00:00 | AAPL | Stock | 191.9749 | 192.776 | 191.86 | 192.18 | 172646.0 |
| 2024-01-22 09:00:00 | AAPL | Stock | 192.15 | 194.72 | 191.92 | 194.46 | 7773164.0 |
| 2024-01-22 10:00:00 | AAPL | Stock | 194.46 | 195.33 | 193.3101 | 193.425 | 10358255.0 |
| 2024-01-22 11:00:00 | AAPL | Stock | 193.4482 | 193.99 | 193.15 | 193.69 | 4553303.0 |
| 2024-01-22 12:00:00 | AAPL | Stock | 193.72 | 194.066 | 193.03 | 193.925 | 3611798.0 |
| 2024-01-22 13:00:00 | AAPL | Stock | 193.93 | 194.5 | 193.66 | 194.49 | 3993271.0 |
| 2024-01-22 14:00:00 | AAPL | Stock | 194.49 | 194.57 | 193.9401 | 194.08 | 3755433.0 |
| 2024-01-22 15:00:00 | AAPL | Stock | 194.08 | 194.1081 | 193.46 | 193.87 | 5820944.0 |
| 2024-01-22 16:00:00 | AAPL | Stock | 193.89 | 193.89 | 193.64 | 193.76 | 7600477.0 |
| 2024-01-22 17:00:00 | AAPL | Stock | 193.79 | 193.8 | 193.72 | 193.72 | 9842.0 |
| 2024-01-22 18:00:00 | AAPL | Stock | 193.75 | 193.97 | 193.7005 | 193.89 | 13523.0 |
| 2024-01-22 19:00:00 | AAPL | Stock | 193.88 | 193.91 | 193.71 | 193.91 | 9299.0 |
| 2024-01-22 04:00:00 | MSFT | Stock | 400.1 | 400.44 | 399.76 | 400.43 | 12489.0 |
| 2024-01-22 05:00:00 | MSFT | Stock | 400.36 | 400.65 | 400.04 | 400.5 | 4443.0 |
| 2024-01-22 06:00:00 | MSFT | Stock | 400.47 | 400.66 | 400.3 | 400.31 | 8369.0 |
| 2024-01-22 07:00:00 | MSFT | Stock | 400.2 | 400.87 | 399.9 | 400.25 | 62897.0 |
| 2024-01-22 08:00:00 | MSFT | Stock | 400.0 | 401.79 | 398.78 | 399.33 | 133215.0 |
| 2024-01-22 09:00:00 | MSFT | Stock | 399.39 | 400.95 | 395.47 | 398.005 | 3602819.0 |
| 2024-01-22 10:00:00 | MSFT | Stock | 398.02 | 398.29 | 393.59 | 395.205 | 3192942.0 |
| 2024-01-22 11:00:00 | MSFT | Stock | 395.195 | 398.09 | 394.86 | 397.61 | 1519162.0 |
| 2024-01-22 12:00:00 | MSFT | Stock | 397.595 | 397.595 | 396.0806 | 396.6973 | 876141.0 |
| 2024-01-22 13:00:00 | MSFT | Stock | 396.69 | 397.425 | 395.8 | 397.38 | 870683.0 |
| 2024-01-22 14:00:00 | MSFT | Stock | 397.385 | 397.9 | 396.81 | 397.44 | 1066035.0 |
| 2024-01-22 15:00:00 | MSFT | Stock | 397.46 | 397.49 | 396.365 | 396.5 | 1584874.0 |
| 2024-01-22 16:00:00 | MSFT | Stock | 396.51 | 396.85 | 396.06 | 396.45 | 4188451.0 |
| 2024-01-22 17:00:00 | MSFT | Stock | 396.46 | 396.46 | 396.01 | 396.01 | 5504.0 |
| 2024-01-22 18:00:00 | MSFT | Stock | 396.31 | 396.582 | 396.2 | 396.51 | 6610.0 |
| 2024-01-22 19:00:00 | MSFT | Stock | 396.54 | 396.56 | 396.5 | 396.53 | 3950.0 |
| 2024-01-22 04:00:00 | NVDA | Stock | 60.014 | 60.191 | 59.723 | 59.825 | 452540.0 |
| 2024-01-22 05:00:00 | NVDA | Stock | 59.825 | 59.999 | 59.68 | 59.953 | 301690.0 |
| 2024-01-22 06:00:00 | NVDA | Stock | 59.91 | 60.05 | 59.739 | 59.781 | 284620.0 |
| 2024-01-22 07:00:00 | NVDA | Stock | 59.809 | 60.207 | 59.786 | 60.145 | 2054220.0 |
| 2024-01-22 08:00:00 | NVDA | Stock | 59.87 | 60.52 | 59.811 | 60.065 | 3915370.0 |
| 2024-01-22 09:00:00 | NVDA | Stock | 60.072 | 60.331 | 59.58 | 59.958 | 76458370.0 |
| 2024-01-22 10:00:00 | NVDA | Stock | 59.955 | 59.999 | 59.07 | 59.403 | 77056840.0 |
| 2024-01-22 11:00:00 | NVDA | Stock | 59.4198 | 60.058 | 59.355 | 59.965 | 43059660.0 |
| 2024-01-22 12:00:00 | NVDA | Stock | 59.969 | 59.996 | 59.569 | 59.8825 | 26065780.0 |
| 2024-01-22 13:00:00 | NVDA | Stock | 59.8767 | 60.022 | 59.705 | 59.9855 | 24779050.0 |
| 2024-01-22 14:00:00 | NVDA | Stock | 59.992 | 60.105 | 59.82 | 59.925 | 23216270.0 |
| 2024-01-22 15:00:00 | NVDA | Stock | 59.926 | 60.0 | 59.65 | 59.665 | 30288210.0 |
| 2024-01-22 16:00:00 | NVDA | Stock | 59.654 | 59.75 | 59.48 | 59.685 | 19335610.0 |
| 2024-01-22 17:00:00 | NVDA | Stock | 59.69 | 59.69 | 59.53 | 59.559 | 174750.0 |
| 2024-01-22 18:00:00 | NVDA | Stock | 59.59 | 59.735 | 59.57 | 59.73 | 194310.0 |
| 2024-01-22 19:00:00 | NVDA | Stock | 59.732 | 59.785 | 59.665 | 59.696 | 289200.0 |
| 2024-01-22 04:00:00 | AMZN | Stock | 156.0 | 156.3 | 155.98 | 156.1 | 10969.0 |
| 2024-01-22 05:00:00 | AMZN | Stock | 156.1 | 156.21 | 156.05 | 156.11 | 7082.0 |
> showing 50 of 59,864 rows — these rows as CSV