PREVIEW / stock_1hour / 2024-07-29
file: by_date/stock_1hour/2024/2024-07-29.parquet size: 1.3 MB rows: 58,898 symbols: 890
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-29 04:00:00 | AAPL | Stock | 218.69 | 218.69 | 218.11 | 218.29 | 13149.0 |
| 2024-07-29 05:00:00 | AAPL | Stock | 218.3 | 218.8 | 218.3 | 218.75 | 4725.0 |
| 2024-07-29 06:00:00 | AAPL | Stock | 218.51 | 218.58 | 216.87 | 217.7 | 29876.0 |
| 2024-07-29 07:00:00 | AAPL | Stock | 217.8 | 218.23 | 217.5 | 218.0 | 37013.0 |
| 2024-07-29 08:00:00 | AAPL | Stock | 217.5 | 219.32 | 217.0 | 217.0 | 191742.0 |
| 2024-07-29 09:00:00 | AAPL | Stock | 217.02 | 219.3 | 215.75 | 218.94 | 5037868.0 |
| 2024-07-29 10:00:00 | AAPL | Stock | 218.95 | 219.09 | 217.445 | 217.815 | 4272124.0 |
| 2024-07-29 11:00:00 | AAPL | Stock | 217.83 | 218.08 | 216.51 | 218.03 | 3098580.0 |
| 2024-07-29 12:00:00 | AAPL | Stock | 218.04 | 218.96 | 218.04 | 218.78 | 2053938.0 |
| 2024-07-29 13:00:00 | AAPL | Stock | 218.79 | 219.28 | 218.3209 | 218.36 | 2387235.0 |
| 2024-07-29 14:00:00 | AAPL | Stock | 218.37 | 218.75 | 217.97 | 218.57 | 2394994.0 |
| 2024-07-29 15:00:00 | AAPL | Stock | 218.56 | 219.12 | 218.0 | 218.22 | 4476006.0 |
| 2024-07-29 16:00:00 | AAPL | Stock | 218.24 | 218.43 | 217.83 | 218.31 | 4157871.0 |
| 2024-07-29 17:00:00 | AAPL | Stock | 218.38 | 218.39 | 218.11 | 218.18 | 15813.0 |
| 2024-07-29 18:00:00 | AAPL | Stock | 218.26 | 218.44 | 218.12 | 218.15 | 13729.0 |
| 2024-07-29 19:00:00 | AAPL | Stock | 218.2997 | 218.2997 | 217.0364 | 217.19 | 22392.0 |
| 2024-07-29 04:00:00 | MSFT | Stock | 428.54 | 428.54 | 427.3 | 427.3 | 4370.0 |
| 2024-07-29 05:00:00 | MSFT | Stock | 427.3 | 428.6 | 427.19 | 428.6 | 600.0 |
| 2024-07-29 06:00:00 | MSFT | Stock | 428.38 | 428.8 | 428.31 | 428.56 | 3829.0 |
| 2024-07-29 07:00:00 | MSFT | Stock | 428.73 | 429.65 | 428.25 | 429.6 | 13517.0 |
| 2024-07-29 08:00:00 | MSFT | Stock | 428.7 | 431.0 | 425.27 | 430.0 | 67402.0 |
| 2024-07-29 09:00:00 | MSFT | Stock | 429.9 | 432.2 | 425.32 | 428.4 | 1785570.0 |
| 2024-07-29 10:00:00 | MSFT | Stock | 428.425 | 428.78 | 425.66 | 426.28 | 1172313.0 |
| 2024-07-29 11:00:00 | MSFT | Stock | 426.325 | 427.62 | 424.7042 | 427.19 | 883965.0 |
| 2024-07-29 12:00:00 | MSFT | Stock | 427.23 | 429.38 | 427.23 | 428.58 | 817165.0 |
| 2024-07-29 13:00:00 | MSFT | Stock | 428.6 | 429.75 | 427.971 | 427.99 | 561680.0 |
| 2024-07-29 14:00:00 | MSFT | Stock | 428.04 | 428.13 | 426.14 | 427.29 | 558669.0 |
| 2024-07-29 15:00:00 | MSFT | Stock | 427.32 | 428.63 | 426.625 | 426.8 | 1380882.0 |
| 2024-07-29 16:00:00 | MSFT | Stock | 426.73 | 427.59 | 426.32 | 427.28 | 2959942.0 |
| 2024-07-29 17:00:00 | MSFT | Stock | 427.25 | 427.25 | 425.75 | 426.9126 | 40117.0 |
| 2024-07-29 18:00:00 | MSFT | Stock | 426.9 | 427.3982 | 426.0 | 426.68 | 12059.0 |
| 2024-07-29 19:00:00 | MSFT | Stock | 426.68 | 426.69 | 425.0 | 425.0 | 13184.0 |
| 2024-07-29 04:00:00 | NVDA | Stock | 113.9 | 114.48 | 113.29 | 113.74 | 291913.0 |
| 2024-07-29 05:00:00 | NVDA | Stock | 113.75 | 114.0 | 113.62 | 113.97 | 125521.0 |
| 2024-07-29 06:00:00 | NVDA | Stock | 113.97 | 114.14 | 113.66 | 113.87 | 173109.0 |
| 2024-07-29 07:00:00 | NVDA | Stock | 113.88 | 114.09 | 113.2 | 113.37 | 848249.0 |
| 2024-07-29 08:00:00 | NVDA | Stock | 113.94 | 114.84 | 113.06 | 114.0 | 1996711.0 |
| 2024-07-29 09:00:00 | NVDA | Stock | 113.99 | 116.28 | 113.25 | 115.305 | 34715665.0 |
| 2024-07-29 10:00:00 | NVDA | Stock | 115.31 | 115.9 | 112.83 | 112.8806 | 36512093.0 |
| 2024-07-29 11:00:00 | NVDA | Stock | 112.89 | 113.3668 | 111.43 | 113.01 | 35963247.0 |
| 2024-07-29 12:00:00 | NVDA | Stock | 113.02 | 113.71 | 112.73 | 113.1198 | 21398363.0 |
| 2024-07-29 13:00:00 | NVDA | Stock | 113.116 | 113.415 | 111.95 | 112.224 | 19383603.0 |
| 2024-07-29 14:00:00 | NVDA | Stock | 112.23 | 112.24 | 111.3 | 111.945 | 21437829.0 |
| 2024-07-29 15:00:00 | NVDA | Stock | 111.92 | 112.29 | 111.38 | 111.55 | 25091250.0 |
| 2024-07-29 16:00:00 | NVDA | Stock | 111.51 | 113.2943 | 111.21 | 111.58 | 20300854.0 |
| 2024-07-29 17:00:00 | NVDA | Stock | 111.5351 | 111.78 | 111.39 | 111.72 | 433018.0 |
| 2024-07-29 18:00:00 | NVDA | Stock | 111.74 | 113.1764 | 111.5 | 111.5914 | 236908.0 |
| 2024-07-29 19:00:00 | NVDA | Stock | 111.6 | 111.61 | 110.71 | 110.77 | 745656.0 |
| 2024-07-29 04:00:00 | AMZN | Stock | 182.76 | 183.72 | 182.76 | 183.54 | 8639.0 |
| 2024-07-29 05:00:00 | AMZN | Stock | 183.49 | 183.5 | 183.2 | 183.5 | 3125.0 |
> showing 50 of 58,898 rows — these rows as CSV