PREVIEW / stock_1hour / 2024-01-29
file: by_date/stock_1hour/2024/2024-01-29.parquet size: 1.3 MB rows: 59,421 symbols: 1,179
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-29 04:00:00 | AAPL | Stock | 192.2 | 192.99 | 192.02 | 192.02 | 20683.0 |
| 2024-01-29 05:00:00 | AAPL | Stock | 192.02 | 192.28 | 191.98 | 192.2 | 9291.0 |
| 2024-01-29 06:00:00 | AAPL | Stock | 192.2 | 192.28 | 192.05 | 192.19 | 2154.0 |
| 2024-01-29 07:00:00 | AAPL | Stock | 192.3 | 192.6 | 192.21 | 192.35 | 31898.0 |
| 2024-01-29 08:00:00 | AAPL | Stock | 192.3 | 192.66 | 191.95 | 191.95 | 92367.0 |
| 2024-01-29 09:00:00 | AAPL | Stock | 191.9467 | 192.2 | 189.58 | 190.7744 | 6506245.0 |
| 2024-01-29 10:00:00 | AAPL | Stock | 190.78 | 191.255 | 190.49 | 190.5901 | 4854662.0 |
| 2024-01-29 11:00:00 | AAPL | Stock | 190.59 | 191.0284 | 190.4 | 190.775 | 3092296.0 |
| 2024-01-29 12:00:00 | AAPL | Stock | 190.78 | 191.16 | 190.72 | 191.05 | 2396826.0 |
| 2024-01-29 13:00:00 | AAPL | Stock | 191.07 | 191.39 | 190.9333 | 191.27 | 2209954.0 |
| 2024-01-29 14:00:00 | AAPL | Stock | 191.27 | 191.67 | 191.24 | 191.375 | 2835443.0 |
| 2024-01-29 15:00:00 | AAPL | Stock | 191.38 | 192.2 | 191.37 | 191.78 | 6582777.0 |
| 2024-01-29 16:00:00 | AAPL | Stock | 191.6 | 191.74 | 191.3 | 191.39 | 7122311.0 |
| 2024-01-29 17:00:00 | AAPL | Stock | 191.39 | 191.73 | 191.37 | 191.54 | 75887.0 |
| 2024-01-29 18:00:00 | AAPL | Stock | 191.51 | 191.51 | 191.04 | 191.11 | 55688.0 |
| 2024-01-29 19:00:00 | AAPL | Stock | 191.15 | 191.15 | 190.88 | 190.88 | 31421.0 |
| 2024-01-29 04:00:00 | MSFT | Stock | 403.0 | 406.76 | 403.0 | 406.0 | 8683.0 |
| 2024-01-29 05:00:00 | MSFT | Stock | 406.24 | 406.55 | 406.2 | 406.3 | 3822.0 |
| 2024-01-29 06:00:00 | MSFT | Stock | 406.29 | 407.49 | 406.29 | 406.93 | 10429.0 |
| 2024-01-29 07:00:00 | MSFT | Stock | 406.85 | 407.1 | 406.3 | 406.45 | 27737.0 |
| 2024-01-29 08:00:00 | MSFT | Stock | 406.95 | 407.15 | 405.4 | 406.6 | 79624.0 |
| 2024-01-29 09:00:00 | MSFT | Stock | 406.6 | 409.12 | 404.33 | 407.63 | 2762687.0 |
| 2024-01-29 10:00:00 | MSFT | Stock | 407.605 | 407.732 | 405.55 | 406.0391 | 2105649.0 |
| 2024-01-29 11:00:00 | MSFT | Stock | 406.0551 | 407.49 | 405.81 | 407.06 | 1318502.0 |
| 2024-01-29 12:00:00 | MSFT | Stock | 407.09 | 407.45 | 406.71 | 407.05 | 1052843.0 |
| 2024-01-29 13:00:00 | MSFT | Stock | 407.05 | 407.37 | 406.77 | 407.0342 | 862860.0 |
| 2024-01-29 14:00:00 | MSFT | Stock | 407.04 | 408.32 | 406.94 | 407.81 | 1194935.0 |
| 2024-01-29 15:00:00 | MSFT | Stock | 407.8 | 409.98 | 407.8 | 409.72 | 2775994.0 |
| 2024-01-29 16:00:00 | MSFT | Stock | 409.72 | 411.25 | 409.61 | 410.87 | 3509767.0 |
| 2024-01-29 17:00:00 | MSFT | Stock | 410.9 | 412.0 | 410.8 | 411.7 | 64672.0 |
| 2024-01-29 18:00:00 | MSFT | Stock | 411.56 | 413.37 | 411.5 | 413.37 | 42873.0 |
| 2024-01-29 19:00:00 | MSFT | Stock | 413.26 | 413.5 | 412.8 | 412.8 | 52525.0 |
| 2024-01-29 04:00:00 | NVDA | Stock | 61.414 | 61.77 | 61.414 | 61.594 | 127610.0 |
| 2024-01-29 05:00:00 | NVDA | Stock | 61.59 | 61.65 | 61.565 | 61.61 | 105180.0 |
| 2024-01-29 06:00:00 | NVDA | Stock | 61.59 | 61.595 | 61.48 | 61.55 | 156820.0 |
| 2024-01-29 07:00:00 | NVDA | Stock | 61.54 | 61.55 | 61.323 | 61.459 | 806940.0 |
| 2024-01-29 08:00:00 | NVDA | Stock | 61.4 | 61.7 | 61.325 | 61.3848 | 1400840.0 |
| 2024-01-29 09:00:00 | NVDA | Stock | 61.4 | 61.716 | 60.907 | 61.7072 | 43898910.0 |
| 2024-01-29 10:00:00 | NVDA | Stock | 61.7075 | 61.875 | 61.41 | 61.5222 | 45117670.0 |
| 2024-01-29 11:00:00 | NVDA | Stock | 61.53 | 61.5436 | 61.291 | 61.4251 | 28178360.0 |
| 2024-01-29 12:00:00 | NVDA | Stock | 61.435 | 61.699 | 61.432 | 61.611 | 20959190.0 |
| 2024-01-29 13:00:00 | NVDA | Stock | 61.619 | 61.82 | 61.472 | 61.736 | 16407380.0 |
| 2024-01-29 14:00:00 | NVDA | Stock | 61.7385 | 61.998 | 61.701 | 61.9545 | 26603020.0 |
| 2024-01-29 15:00:00 | NVDA | Stock | 61.958 | 62.489 | 61.955 | 62.473 | 49903940.0 |
| 2024-01-29 16:00:00 | NVDA | Stock | 62.465 | 63.18 | 62.4 | 63.12 | 21680030.0 |
| 2024-01-29 17:00:00 | NVDA | Stock | 63.133 | 63.3251 | 62.465 | 63.318 | 2950210.0 |
| 2024-01-29 18:00:00 | NVDA | Stock | 63.308 | 63.438 | 63.161 | 63.198 | 1179630.0 |
| 2024-01-29 19:00:00 | NVDA | Stock | 63.198 | 63.3 | 63.16 | 63.27 | 598560.0 |
| 2024-01-29 04:00:00 | AMZN | Stock | 159.39 | 160.0 | 159.39 | 159.73 | 11906.0 |
| 2024-01-29 05:00:00 | AMZN | Stock | 159.79 | 160.17 | 159.75 | 159.96 | 13063.0 |
> showing 50 of 59,421 rows — these rows as CSV