PREVIEW / stock_1hour / 2024-07-24
file: by_date/stock_1hour/2024/2024-07-24.parquet size: 1.3 MB rows: 58,913 symbols: 882
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-24 04:00:00 | AAPL | Stock | 223.44 | 224.1 | 223.4 | 223.76 | 16449.0 |
| 2024-07-24 05:00:00 | AAPL | Stock | 223.84 | 225.0 | 223.83 | 224.1 | 18946.0 |
| 2024-07-24 06:00:00 | AAPL | Stock | 224.27 | 225.77 | 224.14 | 225.0 | 38385.0 |
| 2024-07-24 07:00:00 | AAPL | Stock | 225.0 | 225.47 | 224.57 | 224.8 | 24549.0 |
| 2024-07-24 08:00:00 | AAPL | Stock | 225.0 | 225.4495 | 223.07 | 223.88 | 160797.0 |
| 2024-07-24 09:00:00 | AAPL | Stock | 223.8 | 224.8 | 220.7 | 221.29 | 5829576.0 |
| 2024-07-24 10:00:00 | AAPL | Stock | 221.28 | 221.41 | 218.8 | 218.8302 | 6755281.0 |
| 2024-07-24 11:00:00 | AAPL | Stock | 218.86 | 219.2 | 218.02 | 218.04 | 5241090.0 |
| 2024-07-24 12:00:00 | AAPL | Stock | 218.04 | 218.55 | 217.13 | 217.815 | 4483755.0 |
| 2024-07-24 13:00:00 | AAPL | Stock | 217.83 | 218.55 | 217.77 | 218.1803 | 2898353.0 |
| 2024-07-24 14:00:00 | AAPL | Stock | 218.19 | 218.86 | 217.81 | 218.1735 | 3115834.0 |
| 2024-07-24 15:00:00 | AAPL | Stock | 218.17 | 218.79 | 217.7 | 218.57 | 8040597.0 |
| 2024-07-24 16:00:00 | AAPL | Stock | 218.57 | 218.79 | 217.91 | 218.41 | 10451933.0 |
| 2024-07-24 17:00:00 | AAPL | Stock | 218.4101 | 218.54 | 217.6 | 217.85 | 211148.0 |
| 2024-07-24 18:00:00 | AAPL | Stock | 217.86 | 218.49 | 217.86 | 217.9601 | 73013.0 |
| 2024-07-24 19:00:00 | AAPL | Stock | 217.9841 | 218.2499 | 217.62 | 218.1448 | 59790.0 |
| 2024-07-24 04:00:00 | MSFT | Stock | 442.85 | 443.26 | 442.04 | 442.49 | 6631.0 |
| 2024-07-24 05:00:00 | MSFT | Stock | 442.7 | 442.7 | 441.0 | 441.58 | 3384.0 |
| 2024-07-24 06:00:00 | MSFT | Stock | 441.67 | 442.44 | 441.47 | 441.5 | 4233.0 |
| 2024-07-24 07:00:00 | MSFT | Stock | 441.55 | 441.7 | 441.0 | 441.5 | 10473.0 |
| 2024-07-24 08:00:00 | MSFT | Stock | 441.7 | 442.79 | 439.2 | 439.299 | 42822.0 |
| 2024-07-24 09:00:00 | MSFT | Stock | 439.4175 | 441.48 | 437.15 | 439.415 | 1311048.0 |
| 2024-07-24 10:00:00 | MSFT | Stock | 439.33 | 439.42 | 433.4307 | 434.18 | 1652344.0 |
| 2024-07-24 11:00:00 | MSFT | Stock | 434.2157 | 434.33 | 430.81 | 431.61 | 1994212.0 |
| 2024-07-24 12:00:00 | MSFT | Stock | 431.63 | 431.99 | 429.12 | 429.15 | 1889348.0 |
| 2024-07-24 13:00:00 | MSFT | Stock | 429.14 | 430.9576 | 428.92 | 429.01 | 1198550.0 |
| 2024-07-24 14:00:00 | MSFT | Stock | 429.05 | 430.09 | 427.585 | 428.64 | 1687422.0 |
| 2024-07-24 15:00:00 | MSFT | Stock | 428.63 | 429.87 | 427.73 | 428.94 | 2873451.0 |
| 2024-07-24 16:00:00 | MSFT | Stock | 429.02 | 430.3 | 428.25 | 429.65 | 5717736.0 |
| 2024-07-24 17:00:00 | MSFT | Stock | 429.79 | 430.3 | 429.4 | 430.07 | 22556.0 |
| 2024-07-24 18:00:00 | MSFT | Stock | 430.07 | 430.8 | 429.8306 | 430.34 | 21672.0 |
| 2024-07-24 19:00:00 | MSFT | Stock | 430.2645 | 430.35 | 429.5 | 430.0 | 7361.0 |
| 2024-07-24 04:00:00 | NVDA | Stock | 120.48 | 121.35 | 120.17 | 120.8 | 241652.0 |
| 2024-07-24 05:00:00 | NVDA | Stock | 120.84 | 120.84 | 120.25 | 120.34 | 182361.0 |
| 2024-07-24 06:00:00 | NVDA | Stock | 120.34 | 120.76 | 120.31 | 120.64 | 160116.0 |
| 2024-07-24 07:00:00 | NVDA | Stock | 120.64 | 120.85 | 120.1 | 120.65 | 489570.0 |
| 2024-07-24 08:00:00 | NVDA | Stock | 120.51 | 121.22 | 118.89 | 119.47 | 2800506.0 |
| 2024-07-24 09:00:00 | NVDA | Stock | 119.48 | 119.95 | 117.39 | 118.72 | 35273804.0 |
| 2024-07-24 10:00:00 | NVDA | Stock | 118.73 | 119.43 | 117.56 | 118.1 | 29886219.0 |
| 2024-07-24 11:00:00 | NVDA | Stock | 118.09 | 118.27 | 116.8 | 116.86 | 25581713.0 |
| 2024-07-24 12:00:00 | NVDA | Stock | 116.8687 | 116.87 | 115.55 | 116.38 | 35641408.0 |
| 2024-07-24 13:00:00 | NVDA | Stock | 116.38 | 117.33 | 116.13 | 116.355 | 21547979.0 |
| 2024-07-24 14:00:00 | NVDA | Stock | 116.36 | 116.47 | 114.41 | 114.91 | 33112905.0 |
| 2024-07-24 15:00:00 | NVDA | Stock | 114.905 | 115.74 | 113.44 | 114.4237 | 55390399.0 |
| 2024-07-24 16:00:00 | NVDA | Stock | 114.78 | 118.0 | 113.76 | 115.13 | 33085254.0 |
| 2024-07-24 17:00:00 | NVDA | Stock | 115.13 | 115.35 | 114.25 | 114.62 | 5364206.0 |
| 2024-07-24 18:00:00 | NVDA | Stock | 114.63 | 115.25 | 114.51 | 115.2 | 729625.0 |
| 2024-07-24 19:00:00 | NVDA | Stock | 115.19 | 115.56 | 115.07 | 115.45 | 692025.0 |
| 2024-07-24 04:00:00 | AMZN | Stock | 185.98 | 186.0 | 185.04 | 185.89 | 9941.0 |
| 2024-07-24 05:00:00 | AMZN | Stock | 186.0 | 186.15 | 185.5 | 185.72 | 8064.0 |
> showing 50 of 58,913 rows — these rows as CSV