PREVIEW / stock_1hour / 2024-10-24
file: by_date/stock_1hour/2024/2024-10-24.parquet size: 1.4 MB rows: 59,106 symbols: 723
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-10-24 04:00:00 | AAPL | Stock | 230.66 | 231.48 | 230.66 | 231.2 | 17993.0 |
| 2024-10-24 05:00:00 | AAPL | Stock | 231.28 | 231.38 | 231.21 | 231.34 | 6732.0 |
| 2024-10-24 06:00:00 | AAPL | Stock | 231.36 | 231.45 | 231.36 | 231.4 | 4117.0 |
| 2024-10-24 07:00:00 | AAPL | Stock | 231.4 | 231.46 | 231.05 | 231.33 | 20120.0 |
| 2024-10-24 08:00:00 | AAPL | Stock | 231.27 | 231.61 | 230.45 | 230.5 | 119389.0 |
| 2024-10-24 09:00:00 | AAPL | Stock | 230.442 | 230.74 | 228.41 | 229.82 | 4075636.0 |
| 2024-10-24 10:00:00 | AAPL | Stock | 229.83 | 230.38 | 229.24 | 229.25 | 2906768.0 |
| 2024-10-24 11:00:00 | AAPL | Stock | 229.25 | 230.2 | 228.8806 | 229.58 | 2383253.0 |
| 2024-10-24 12:00:00 | AAPL | Stock | 229.59 | 230.345 | 228.67 | 230.308 | 1850878.0 |
| 2024-10-24 13:00:00 | AAPL | Stock | 230.31 | 230.82 | 230.11 | 230.255 | 1633296.0 |
| 2024-10-24 14:00:00 | AAPL | Stock | 230.26 | 230.5676 | 230.04 | 230.46 | 1187604.0 |
| 2024-10-24 15:00:00 | AAPL | Stock | 230.45 | 230.81 | 230.12 | 230.57 | 2703483.0 |
| 2024-10-24 16:00:00 | AAPL | Stock | 230.57 | 230.77 | 230.43 | 230.48 | 5648826.0 |
| 2024-10-24 17:00:00 | AAPL | Stock | 230.43 | 230.46 | 230.01 | 230.39 | 18619.0 |
| 2024-10-24 18:00:00 | AAPL | Stock | 230.42 | 230.48 | 230.15 | 230.2603 | 7612.0 |
| 2024-10-24 19:00:00 | AAPL | Stock | 230.27 | 230.33 | 229.47 | 229.51 | 19420.0 |
| 2024-10-24 04:00:00 | MSFT | Stock | 426.65 | 426.81 | 426.0 | 426.0 | 4802.0 |
| 2024-10-24 05:00:00 | MSFT | Stock | 426.5 | 426.71 | 426.4 | 426.71 | 1969.0 |
| 2024-10-24 06:00:00 | MSFT | Stock | 426.71 | 426.85 | 426.71 | 426.85 | 477.0 |
| 2024-10-24 07:00:00 | MSFT | Stock | 426.43 | 426.62 | 426.25 | 426.25 | 5843.0 |
| 2024-10-24 08:00:00 | MSFT | Stock | 426.55 | 426.69 | 425.12 | 426.05 | 32871.0 |
| 2024-10-24 09:00:00 | MSFT | Stock | 426.0353 | 427.21 | 423.2 | 424.685 | 1197968.0 |
| 2024-10-24 10:00:00 | MSFT | Stock | 424.72 | 425.38 | 423.7101 | 424.08 | 1001043.0 |
| 2024-10-24 11:00:00 | MSFT | Stock | 424.095 | 425.045 | 422.54 | 423.76 | 616261.0 |
| 2024-10-24 12:00:00 | MSFT | Stock | 423.77 | 424.41 | 422.4 | 424.395 | 493716.0 |
| 2024-10-24 13:00:00 | MSFT | Stock | 424.39 | 425.24 | 423.82 | 423.89 | 427324.0 |
| 2024-10-24 14:00:00 | MSFT | Stock | 423.9 | 424.71 | 423.59 | 424.48 | 417854.0 |
| 2024-10-24 15:00:00 | MSFT | Stock | 424.48 | 425.27 | 423.86 | 424.68 | 1007767.0 |
| 2024-10-24 16:00:00 | MSFT | Stock | 424.71 | 425.5 | 424.6 | 424.66 | 3771526.0 |
| 2024-10-24 17:00:00 | MSFT | Stock | 424.66 | 424.7 | 424.59 | 424.59 | 2306.0 |
| 2024-10-24 18:00:00 | MSFT | Stock | 424.8 | 424.85 | 424.5 | 424.85 | 3020.0 |
| 2024-10-24 19:00:00 | MSFT | Stock | 424.75 | 424.75 | 424.44 | 424.44 | 7811.0 |
| 2024-10-24 04:00:00 | NVDA | Stock | 141.9 | 141.9 | 140.39 | 141.4 | 444892.0 |
| 2024-10-24 05:00:00 | NVDA | Stock | 141.37 | 141.44 | 140.47 | 141.0 | 261022.0 |
| 2024-10-24 06:00:00 | NVDA | Stock | 141.0 | 141.4 | 140.82 | 140.9 | 218280.0 |
| 2024-10-24 07:00:00 | NVDA | Stock | 140.91 | 141.39 | 140.88 | 141.39 | 791590.0 |
| 2024-10-24 08:00:00 | NVDA | Stock | 141.39 | 142.15 | 140.36 | 140.58 | 2612447.0 |
| 2024-10-24 09:00:00 | NVDA | Stock | 140.59 | 141.35 | 139.58 | 140.43 | 26864259.0 |
| 2024-10-24 10:00:00 | NVDA | Stock | 140.425 | 140.99 | 138.46 | 139.3115 | 34260307.0 |
| 2024-10-24 11:00:00 | NVDA | Stock | 139.33 | 139.96 | 138.79 | 139.555 | 15786277.0 |
| 2024-10-24 12:00:00 | NVDA | Stock | 139.56 | 139.83 | 138.83 | 139.53 | 14633027.0 |
| 2024-10-24 13:00:00 | NVDA | Stock | 139.52 | 140.06 | 139.145 | 139.4 | 11439405.0 |
| 2024-10-24 14:00:00 | NVDA | Stock | 139.41 | 140.14 | 139.26 | 139.97 | 11067464.0 |
| 2024-10-24 15:00:00 | NVDA | Stock | 139.96 | 140.84 | 139.7 | 140.4 | 19407041.0 |
| 2024-10-24 16:00:00 | NVDA | Stock | 140.41 | 140.41 | 139.9781 | 140.15 | 13367042.0 |
| 2024-10-24 17:00:00 | NVDA | Stock | 140.13 | 140.23 | 140.01 | 140.15 | 286051.0 |
| 2024-10-24 18:00:00 | NVDA | Stock | 140.17 | 140.41 | 140.15 | 140.1505 | 198174.0 |
| 2024-10-24 19:00:00 | NVDA | Stock | 140.17 | 140.3 | 140.05 | 140.0601 | 275748.0 |
| 2024-10-24 04:00:00 | AMZN | Stock | 185.73 | 186.39 | 185.73 | 185.92 | 25546.0 |
| 2024-10-24 05:00:00 | AMZN | Stock | 186.06 | 186.33 | 185.98 | 186.15 | 10528.0 |
> showing 50 of 59,106 rows — these rows as CSV