PREVIEW / stock_1hour / 2024-06-11
file: by_date/stock_1hour/2024/2024-06-11.parquet size: 1.3 MB rows: 58,379 symbols: 948
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-06-11 04:00:00 | AAPL | Stock | 192.48 | 192.61 | 191.68 | 192.0 | 43579.0 |
| 2024-06-11 05:00:00 | AAPL | Stock | 191.93 | 192.0 | 191.48 | 191.85 | 15947.0 |
| 2024-06-11 06:00:00 | AAPL | Stock | 191.74 | 193.0 | 191.74 | 192.74 | 66047.0 |
| 2024-06-11 07:00:00 | AAPL | Stock | 192.75 | 193.24 | 192.1 | 192.85 | 94197.0 |
| 2024-06-11 08:00:00 | AAPL | Stock | 192.5 | 193.2365 | 191.28 | 193.05 | 278279.0 |
| 2024-06-11 09:00:00 | AAPL | Stock | 193.0 | 199.149 | 193.0 | 199.13 | 17866313.0 |
| 2024-06-11 10:00:00 | AAPL | Stock | 199.1316 | 203.8 | 198.87 | 203.24 | 33951616.0 |
| 2024-06-11 11:00:00 | AAPL | Stock | 203.235 | 205.45 | 202.25 | 204.3299 | 26082183.0 |
| 2024-06-11 12:00:00 | AAPL | Stock | 204.33 | 205.07 | 203.45 | 205.04 | 13317677.0 |
| 2024-06-11 13:00:00 | AAPL | Stock | 205.0499 | 206.03 | 204.44 | 204.99 | 12325857.0 |
| 2024-06-11 14:00:00 | AAPL | Stock | 204.985 | 205.93 | 204.44 | 205.6 | 10014132.0 |
| 2024-06-11 15:00:00 | AAPL | Stock | 205.595 | 207.16 | 204.7 | 207.14 | 19559603.0 |
| 2024-06-11 16:00:00 | AAPL | Stock | 207.15 | 207.89 | 202.865 | 207.69 | 12171188.0 |
| 2024-06-11 17:00:00 | AAPL | Stock | 207.68 | 207.77 | 207.01 | 207.15 | 208548.0 |
| 2024-06-11 18:00:00 | AAPL | Stock | 207.15 | 207.1999 | 206.61 | 206.95 | 249841.0 |
| 2024-06-11 19:00:00 | AAPL | Stock | 206.91 | 207.44 | 206.51 | 206.54 | 258156.0 |
| 2024-06-11 04:00:00 | MSFT | Stock | 427.17 | 427.7 | 427.17 | 427.27 | 1044.0 |
| 2024-06-11 05:00:00 | MSFT | Stock | 427.0 | 427.22 | 427.0 | 427.22 | 618.0 |
| 2024-06-11 06:00:00 | MSFT | Stock | 427.1 | 427.1 | 426.9 | 426.9 | 243.0 |
| 2024-06-11 07:00:00 | MSFT | Stock | 426.79 | 426.79 | 425.61 | 426.09 | 3397.0 |
| 2024-06-11 08:00:00 | MSFT | Stock | 426.73 | 427.64 | 426.0 | 426.39 | 14435.0 |
| 2024-06-11 09:00:00 | MSFT | Stock | 426.13 | 427.36 | 425.07 | 426.47 | 752904.0 |
| 2024-06-11 10:00:00 | MSFT | Stock | 426.475 | 428.24 | 425.48 | 428.13 | 966263.0 |
| 2024-06-11 11:00:00 | MSFT | Stock | 428.14 | 428.79 | 427.45 | 428.35 | 632617.0 |
| 2024-06-11 12:00:00 | MSFT | Stock | 428.36 | 428.38 | 427.2 | 427.82 | 445756.0 |
| 2024-06-11 13:00:00 | MSFT | Stock | 427.85 | 429.14 | 427.72 | 429.1275 | 748331.0 |
| 2024-06-11 14:00:00 | MSFT | Stock | 429.11 | 431.09 | 429.06 | 431.06 | 993436.0 |
| 2024-06-11 15:00:00 | MSFT | Stock | 431.07 | 432.82 | 430.78 | 432.65 | 1849644.0 |
| 2024-06-11 16:00:00 | MSFT | Stock | 432.68 | 433.8 | 432.0 | 433.3 | 2680735.0 |
| 2024-06-11 17:00:00 | MSFT | Stock | 433.3 | 433.4492 | 432.68 | 433.2 | 152711.0 |
| 2024-06-11 18:00:00 | MSFT | Stock | 433.1442 | 433.71 | 432.68 | 433.69 | 14845.0 |
| 2024-06-11 19:00:00 | MSFT | Stock | 433.8 | 433.8 | 433.12 | 433.2999 | 5934.0 |
| 2024-06-11 04:00:00 | NVDA | Stock | 121.92 | 122.4 | 121.2 | 121.45 | 423155.0 |
| 2024-06-11 05:00:00 | NVDA | Stock | 121.45 | 121.8 | 121.36 | 121.61 | 246702.0 |
| 2024-06-11 06:00:00 | NVDA | Stock | 121.52 | 121.79 | 121.2 | 121.78 | 182895.0 |
| 2024-06-11 07:00:00 | NVDA | Stock | 121.75 | 121.8 | 121.0 | 121.37 | 672348.0 |
| 2024-06-11 08:00:00 | NVDA | Stock | 121.55 | 122.53 | 121.01 | 121.47 | 1717102.0 |
| 2024-06-11 09:00:00 | NVDA | Stock | 121.46 | 122.87 | 120.77 | 121.435 | 36137693.0 |
| 2024-06-11 10:00:00 | NVDA | Stock | 121.42 | 122.3 | 120.0 | 121.29 | 36824443.0 |
| 2024-06-11 11:00:00 | NVDA | Stock | 121.28 | 121.4 | 118.74 | 119.24 | 34197433.0 |
| 2024-06-11 12:00:00 | NVDA | Stock | 119.25 | 120.73 | 119.14 | 120.4508 | 20752850.0 |
| 2024-06-11 13:00:00 | NVDA | Stock | 120.45 | 120.95 | 119.81 | 120.81 | 15877432.0 |
| 2024-06-11 14:00:00 | NVDA | Stock | 120.82 | 121.29 | 120.2601 | 120.9824 | 15590081.0 |
| 2024-06-11 15:00:00 | NVDA | Stock | 121.0 | 121.05 | 120.26 | 120.91 | 20349474.0 |
| 2024-06-11 16:00:00 | NVDA | Stock | 120.89 | 120.96 | 120.56 | 120.79 | 9826053.0 |
| 2024-06-11 17:00:00 | NVDA | Stock | 120.79 | 121.19 | 120.75 | 121.11 | 628216.0 |
| 2024-06-11 18:00:00 | NVDA | Stock | 121.1 | 121.101 | 120.82 | 121.04 | 275543.0 |
| 2024-06-11 19:00:00 | NVDA | Stock | 121.04 | 121.15 | 120.99 | 121.05 | 348180.0 |
| 2024-06-11 04:00:00 | AMZN | Stock | 186.9 | 187.06 | 186.7 | 186.72 | 5453.0 |
| 2024-06-11 05:00:00 | AMZN | Stock | 186.74 | 186.74 | 186.39 | 186.39 | 1283.0 |
> showing 50 of 58,379 rows — these rows as CSV