PREVIEW / stock_1hour / 2024-07-26
file: by_date/stock_1hour/2024/2024-07-26.parquet size: 1.3 MB rows: 57,781 symbols: 884
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-07-26 04:00:00 | AAPL | Stock | 218.9 | 220.0 | 218.81 | 220.0 | 20402.0 |
| 2024-07-26 05:00:00 | AAPL | Stock | 220.25 | 220.25 | 219.5 | 219.63 | 7133.0 |
| 2024-07-26 06:00:00 | AAPL | Stock | 219.63 | 220.0 | 219.2 | 219.2 | 12773.0 |
| 2024-07-26 07:00:00 | AAPL | Stock | 219.2 | 220.0 | 219.06 | 219.87 | 34982.0 |
| 2024-07-26 08:00:00 | AAPL | Stock | 219.4 | 220.0 | 218.51 | 219.45 | 155182.0 |
| 2024-07-26 09:00:00 | AAPL | Stock | 219.4919 | 219.6 | 216.28 | 217.68 | 5071640.0 |
| 2024-07-26 10:00:00 | AAPL | Stock | 217.664 | 217.95 | 216.01 | 217.515 | 4931455.0 |
| 2024-07-26 11:00:00 | AAPL | Stock | 217.51 | 218.88 | 217.3901 | 218.5 | 3492536.0 |
| 2024-07-26 12:00:00 | AAPL | Stock | 218.5 | 219.49 | 218.431 | 219.26 | 2714828.0 |
| 2024-07-26 13:00:00 | AAPL | Stock | 219.27 | 219.395 | 217.68 | 218.0762 | 2715221.0 |
| 2024-07-26 14:00:00 | AAPL | Stock | 218.06 | 218.49 | 217.56 | 217.7801 | 2273243.0 |
| 2024-07-26 15:00:00 | AAPL | Stock | 217.78 | 218.76 | 217.13 | 218.1 | 4906162.0 |
| 2024-07-26 16:00:00 | AAPL | Stock | 217.96 | 218.13 | 217.75 | 217.87 | 5367823.0 |
| 2024-07-26 17:00:00 | AAPL | Stock | 217.87 | 217.88 | 217.79 | 217.81 | 14834.0 |
| 2024-07-26 18:00:00 | AAPL | Stock | 217.82 | 217.95 | 217.8 | 217.82 | 10576.0 |
| 2024-07-26 19:00:00 | AAPL | Stock | 217.81 | 217.98 | 217.8 | 217.9 | 6073.0 |
| 2024-07-26 04:00:00 | MSFT | Stock | 420.03 | 421.5 | 418.99 | 421.0 | 17109.0 |
| 2024-07-26 05:00:00 | MSFT | Stock | 421.21 | 421.59 | 421.1 | 421.5 | 3472.0 |
| 2024-07-26 06:00:00 | MSFT | Stock | 421.62 | 422.21 | 421.5 | 422.1 | 7844.0 |
| 2024-07-26 07:00:00 | MSFT | Stock | 421.99 | 422.24 | 421.1 | 421.5 | 19616.0 |
| 2024-07-26 08:00:00 | MSFT | Stock | 422.0 | 422.23 | 418.71 | 419.29 | 108159.0 |
| 2024-07-26 09:00:00 | MSFT | Stock | 419.3 | 421.91 | 417.27 | 419.995 | 2112663.0 |
| 2024-07-26 10:00:00 | MSFT | Stock | 419.96 | 424.27 | 419.5 | 422.47 | 1985453.0 |
| 2024-07-26 11:00:00 | MSFT | Stock | 422.56 | 426.2 | 422.34 | 425.95 | 1354758.0 |
| 2024-07-26 12:00:00 | MSFT | Stock | 426.02 | 428.32 | 425.97 | 428.0 | 1399495.0 |
| 2024-07-26 13:00:00 | MSFT | Stock | 428.05 | 428.915 | 426.37 | 426.5301 | 1277254.0 |
| 2024-07-26 14:00:00 | MSFT | Stock | 426.51 | 426.74 | 424.06 | 424.315 | 806811.0 |
| 2024-07-26 15:00:00 | MSFT | Stock | 424.3 | 426.0 | 423.5 | 425.49 | 1757177.0 |
| 2024-07-26 16:00:00 | MSFT | Stock | 425.27 | 425.51 | 424.85 | 424.85 | 3229281.0 |
| 2024-07-26 17:00:00 | MSFT | Stock | 425.2125 | 425.31 | 424.82 | 425.29 | 9760.0 |
| 2024-07-26 18:00:00 | MSFT | Stock | 425.29 | 425.29 | 424.99 | 425.29 | 5476.0 |
| 2024-07-26 19:00:00 | MSFT | Stock | 425.2007 | 425.48 | 425.1221 | 425.44 | 8776.0 |
| 2024-07-26 04:00:00 | NVDA | Stock | 114.0 | 114.82 | 113.44 | 114.79 | 702693.0 |
| 2024-07-26 05:00:00 | NVDA | Stock | 114.79 | 115.24 | 114.6 | 114.86 | 521439.0 |
| 2024-07-26 06:00:00 | NVDA | Stock | 114.87 | 115.04 | 114.4 | 114.5 | 293976.0 |
| 2024-07-26 07:00:00 | NVDA | Stock | 114.5 | 115.51 | 114.27 | 115.5 | 1188982.0 |
| 2024-07-26 08:00:00 | NVDA | Stock | 115.49 | 116.29 | 112.7 | 115.88 | 4215954.0 |
| 2024-07-26 09:00:00 | NVDA | Stock | 115.88 | 116.34 | 113.5 | 114.69 | 37255851.0 |
| 2024-07-26 10:00:00 | NVDA | Stock | 114.66 | 115.12 | 112.01 | 113.25 | 46938398.0 |
| 2024-07-26 11:00:00 | NVDA | Stock | 113.2403 | 113.7601 | 112.45 | 113.005 | 27607076.0 |
| 2024-07-26 12:00:00 | NVDA | Stock | 113.01 | 114.545 | 112.81 | 114.195 | 25254564.0 |
| 2024-07-26 13:00:00 | NVDA | Stock | 114.195 | 114.49 | 112.67 | 113.39 | 22803612.0 |
| 2024-07-26 14:00:00 | NVDA | Stock | 113.39 | 113.75 | 112.51 | 112.7101 | 18136290.0 |
| 2024-07-26 15:00:00 | NVDA | Stock | 112.71 | 113.17 | 111.58 | 113.06 | 37311555.0 |
| 2024-07-26 16:00:00 | NVDA | Stock | 113.06 | 113.6763 | 112.93 | 113.0 | 15819790.0 |
| 2024-07-26 17:00:00 | NVDA | Stock | 113.0 | 113.13 | 112.92 | 113.0 | 377479.0 |
| 2024-07-26 18:00:00 | NVDA | Stock | 113.0 | 113.03 | 112.9 | 113.0 | 230153.0 |
| 2024-07-26 19:00:00 | NVDA | Stock | 113.0 | 113.08 | 112.9 | 113.0381 | 314824.0 |
| 2024-07-26 04:00:00 | AMZN | Stock | 181.6 | 182.32 | 181.3 | 182.32 | 22754.0 |
| 2024-07-26 05:00:00 | AMZN | Stock | 182.42 | 182.42 | 182.0 | 182.1 | 3801.0 |
> showing 50 of 57,781 rows — these rows as CSV