PREVIEW / stock_1hour / 2024-06-14
file: by_date/stock_1hour/2024/2024-06-14.parquet size: 1.3 MB rows: 58,547 symbols: 949
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-14 04:00:00 | AAPL | Stock | 214.4 | 214.6 | 213.81 | 214.23 | 52725.0 |
| 2024-06-14 05:00:00 | AAPL | Stock | 214.23 | 214.26 | 213.59 | 213.7 | 21510.0 |
| 2024-06-14 06:00:00 | AAPL | Stock | 213.65 | 213.75 | 212.8 | 213.55 | 47871.0 |
| 2024-06-14 07:00:00 | AAPL | Stock | 213.4 | 213.9 | 212.75 | 213.3 | 46163.0 |
| 2024-06-14 08:00:00 | AAPL | Stock | 212.8 | 214.78 | 212.75 | 213.48 | 226828.0 |
| 2024-06-14 09:00:00 | AAPL | Stock | 213.49 | 215.17 | 212.65 | 213.7499 | 6853805.0 |
| 2024-06-14 10:00:00 | AAPL | Stock | 213.74 | 214.64 | 212.62 | 213.1115 | 8270769.0 |
| 2024-06-14 11:00:00 | AAPL | Stock | 213.12 | 213.85 | 212.45 | 212.55 | 6156600.0 |
| 2024-06-14 12:00:00 | AAPL | Stock | 212.54 | 212.55 | 211.3 | 212.18 | 6981932.0 |
| 2024-06-14 13:00:00 | AAPL | Stock | 212.19 | 212.45 | 211.35 | 212.37 | 4848462.0 |
| 2024-06-14 14:00:00 | AAPL | Stock | 212.37 | 212.39 | 211.68 | 212.165 | 3801382.0 |
| 2024-06-14 15:00:00 | AAPL | Stock | 212.16 | 212.59 | 211.42 | 212.52 | 8535357.0 |
| 2024-06-14 16:00:00 | AAPL | Stock | 212.54 | 212.63 | 212.38 | 212.49 | 6749649.0 |
| 2024-06-14 17:00:00 | AAPL | Stock | 212.48 | 212.65 | 212.46 | 212.6 | 106906.0 |
| 2024-06-14 18:00:00 | AAPL | Stock | 212.62 | 212.8564 | 212.49 | 212.69 | 40934.0 |
| 2024-06-14 19:00:00 | AAPL | Stock | 212.69 | 212.71 | 212.37 | 212.44 | 34243.0 |
| 2024-06-14 04:00:00 | MSFT | Stock | 441.25 | 441.25 | 439.33 | 439.5 | 7574.0 |
| 2024-06-14 05:00:00 | MSFT | Stock | 439.5 | 439.66 | 437.97 | 438.3 | 6315.0 |
| 2024-06-14 06:00:00 | MSFT | Stock | 438.24 | 438.24 | 437.16 | 437.79 | 15330.0 |
| 2024-06-14 07:00:00 | MSFT | Stock | 437.99 | 438.85 | 437.3 | 438.02 | 12831.0 |
| 2024-06-14 08:00:00 | MSFT | Stock | 437.69 | 440.96 | 437.0901 | 438.94 | 32675.0 |
| 2024-06-14 09:00:00 | MSFT | Stock | 438.9 | 442.2 | 436.721 | 442.02 | 1427828.0 |
| 2024-06-14 10:00:00 | MSFT | Stock | 442.01 | 442.7838 | 440.33 | 442.78 | 1127222.0 |
| 2024-06-14 11:00:00 | MSFT | Stock | 442.86 | 442.97 | 441.01 | 442.52 | 714859.0 |
| 2024-06-14 12:00:00 | MSFT | Stock | 442.51 | 443.1376 | 442.05 | 442.3897 | 551290.0 |
| 2024-06-14 13:00:00 | MSFT | Stock | 442.35 | 443.01 | 441.8101 | 442.49 | 509146.0 |
| 2024-06-14 14:00:00 | MSFT | Stock | 442.48 | 442.7 | 441.59 | 442.3 | 655756.0 |
| 2024-06-14 15:00:00 | MSFT | Stock | 442.28 | 442.72 | 441.35 | 442.55 | 1136321.0 |
| 2024-06-14 16:00:00 | MSFT | Stock | 442.57 | 442.85 | 442.46 | 442.55 | 2315179.0 |
| 2024-06-14 17:00:00 | MSFT | Stock | 442.57 | 442.66 | 442.43 | 442.66 | 2321.0 |
| 2024-06-14 18:00:00 | MSFT | Stock | 442.4298 | 442.8 | 442.41 | 442.6 | 1434.0 |
| 2024-06-14 19:00:00 | MSFT | Stock | 442.58 | 442.64 | 442.2 | 442.41 | 6305.0 |
| 2024-06-14 04:00:00 | NVDA | Stock | 131.0 | 131.64 | 129.5 | 131.47 | 839628.0 |
| 2024-06-14 05:00:00 | NVDA | Stock | 131.5 | 131.67 | 130.3 | 130.36 | 611381.0 |
| 2024-06-14 06:00:00 | NVDA | Stock | 130.36 | 130.5 | 129.6 | 129.96 | 745883.0 |
| 2024-06-14 07:00:00 | NVDA | Stock | 129.96 | 130.04 | 128.6 | 129.56 | 1989527.0 |
| 2024-06-14 08:00:00 | NVDA | Stock | 129.59 | 131.92 | 128.62 | 130.11 | 5400927.0 |
| 2024-06-14 09:00:00 | NVDA | Stock | 130.12 | 131.13 | 128.32 | 130.87 | 41522391.0 |
| 2024-06-14 10:00:00 | NVDA | Stock | 130.86 | 132.84 | 130.61 | 131.99 | 58199292.0 |
| 2024-06-14 11:00:00 | NVDA | Stock | 132.0 | 132.0299 | 129.2 | 130.5999 | 36756400.0 |
| 2024-06-14 12:00:00 | NVDA | Stock | 130.58 | 131.42 | 130.46 | 131.1421 | 26092498.0 |
| 2024-06-14 13:00:00 | NVDA | Stock | 131.15 | 132.58 | 130.93 | 131.795 | 29870777.0 |
| 2024-06-14 14:00:00 | NVDA | Stock | 131.79 | 132.18 | 131.4 | 131.91 | 22154894.0 |
| 2024-06-14 15:00:00 | NVDA | Stock | 131.91 | 132.1 | 131.55 | 131.98 | 27774306.0 |
| 2024-06-14 16:00:00 | NVDA | Stock | 131.88 | 132.18 | 131.2411 | 131.98 | 16072987.0 |
| 2024-06-14 17:00:00 | NVDA | Stock | 131.99 | 132.05 | 131.88 | 131.93 | 427335.0 |
| 2024-06-14 18:00:00 | NVDA | Stock | 131.9245 | 131.96 | 131.76 | 131.8 | 355019.0 |
| 2024-06-14 19:00:00 | NVDA | Stock | 131.8 | 131.83 | 131.1 | 131.25 | 839627.0 |
| 2024-06-14 04:00:00 | AMZN | Stock | 183.93 | 183.93 | 183.14 | 183.18 | 10515.0 |
| 2024-06-14 05:00:00 | AMZN | Stock | 183.17 | 183.39 | 182.7 | 182.88 | 10883.0 |
> showing 50 of 58,547 rows — these rows as CSV