PREVIEW / stock_1hour / 2024-06-17
file: by_date/stock_1hour/2024/2024-06-17.parquet size: 1.3 MB rows: 59,168 symbols: 969
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-17 04:00:00 | AAPL | Stock | 212.62 | 214.61 | 212.62 | 214.04 | 124200.0 |
| 2024-06-17 05:00:00 | AAPL | Stock | 214.01 | 214.02 | 213.7 | 213.8 | 29701.0 |
| 2024-06-17 06:00:00 | AAPL | Stock | 213.9 | 214.16 | 213.65 | 213.89 | 61080.0 |
| 2024-06-17 07:00:00 | AAPL | Stock | 213.71 | 214.1 | 213.65 | 213.92 | 81636.0 |
| 2024-06-17 08:00:00 | AAPL | Stock | 213.78 | 214.3 | 212.43 | 213.82 | 466175.0 |
| 2024-06-17 09:00:00 | AAPL | Stock | 213.87 | 214.8 | 212.72 | 213.55 | 9705575.0 |
| 2024-06-17 10:00:00 | AAPL | Stock | 213.54 | 217.02 | 213.53 | 216.88 | 13880329.0 |
| 2024-06-17 11:00:00 | AAPL | Stock | 216.88 | 218.0 | 215.82 | 216.345 | 8228332.0 |
| 2024-06-17 12:00:00 | AAPL | Stock | 216.34 | 217.27 | 216.13 | 217.074 | 5190051.0 |
| 2024-06-17 13:00:00 | AAPL | Stock | 217.08 | 218.7436 | 216.8 | 217.9399 | 6770522.0 |
| 2024-06-17 14:00:00 | AAPL | Stock | 217.92 | 218.95 | 217.87 | 218.7066 | 6784833.0 |
| 2024-06-17 15:00:00 | AAPL | Stock | 218.705 | 218.705 | 215.48 | 216.71 | 13507909.0 |
| 2024-06-17 16:00:00 | AAPL | Stock | 216.69 | 217.1 | 216.46 | 216.58 | 12357676.0 |
| 2024-06-17 17:00:00 | AAPL | Stock | 216.58 | 217.2 | 216.56 | 217.05 | 69390.0 |
| 2024-06-17 18:00:00 | AAPL | Stock | 217.05 | 217.1 | 216.67 | 216.82 | 44845.0 |
| 2024-06-17 19:00:00 | AAPL | Stock | 216.8 | 216.93 | 216.67 | 216.76 | 65076.0 |
| 2024-06-17 04:00:00 | MSFT | Stock | 442.6 | 444.09 | 442.6 | 443.26 | 5833.0 |
| 2024-06-17 05:00:00 | MSFT | Stock | 443.71 | 443.84 | 443.71 | 443.84 | 209.0 |
| 2024-06-17 06:00:00 | MSFT | Stock | 443.66 | 443.66 | 443.13 | 443.4 | 4981.0 |
| 2024-06-17 07:00:00 | MSFT | Stock | 443.35 | 443.35 | 442.23 | 442.63 | 6637.0 |
| 2024-06-17 08:00:00 | MSFT | Stock | 443.16 | 443.26 | 442.0 | 442.39 | 35237.0 |
| 2024-06-17 09:00:00 | MSFT | Stock | 442.49 | 444.28 | 440.72 | 441.81 | 1483984.0 |
| 2024-06-17 10:00:00 | MSFT | Stock | 441.88 | 443.44 | 441.66 | 442.38 | 1234295.0 |
| 2024-06-17 11:00:00 | MSFT | Stock | 442.39 | 445.2 | 442.35 | 444.34 | 1061951.0 |
| 2024-06-17 12:00:00 | MSFT | Stock | 444.3621 | 446.64 | 444.13 | 446.53 | 907929.0 |
| 2024-06-17 13:00:00 | MSFT | Stock | 446.57 | 449.49 | 446.57 | 449.42 | 1037858.0 |
| 2024-06-17 14:00:00 | MSFT | Stock | 449.38 | 450.69 | 448.2201 | 449.3156 | 1597771.0 |
| 2024-06-17 15:00:00 | MSFT | Stock | 449.3 | 450.94 | 448.085 | 448.39 | 2348385.0 |
| 2024-06-17 16:00:00 | MSFT | Stock | 448.39 | 448.54 | 448.0 | 448.35 | 4272089.0 |
| 2024-06-17 17:00:00 | MSFT | Stock | 448.23 | 448.75 | 447.83 | 447.83 | 7189.0 |
| 2024-06-17 18:00:00 | MSFT | Stock | 448.1 | 448.4999 | 448.1 | 448.44 | 3442.0 |
| 2024-06-17 19:00:00 | MSFT | Stock | 448.37 | 448.5 | 448.01 | 448.3 | 4961.0 |
| 2024-06-17 04:00:00 | NVDA | Stock | 132.87 | 133.0 | 132.27 | 132.75 | 637545.0 |
| 2024-06-17 05:00:00 | NVDA | Stock | 132.74 | 132.86 | 132.6 | 132.69 | 207219.0 |
| 2024-06-17 06:00:00 | NVDA | Stock | 132.69 | 132.71 | 132.19 | 132.34 | 269471.0 |
| 2024-06-17 07:00:00 | NVDA | Stock | 132.34 | 133.6 | 132.07 | 133.21 | 1650049.0 |
| 2024-06-17 08:00:00 | NVDA | Stock | 132.4 | 133.7 | 132.2 | 133.29 | 5513789.0 |
| 2024-06-17 09:00:00 | NVDA | Stock | 133.27 | 133.79 | 130.73 | 132.4613 | 55643259.0 |
| 2024-06-17 10:00:00 | NVDA | Stock | 132.47 | 132.6 | 129.58 | 130.42 | 46657716.0 |
| 2024-06-17 11:00:00 | NVDA | Stock | 130.42 | 131.46 | 130.42 | 130.9399 | 23934672.0 |
| 2024-06-17 12:00:00 | NVDA | Stock | 130.93 | 132.46 | 130.61 | 131.64 | 25590196.0 |
| 2024-06-17 13:00:00 | NVDA | Stock | 131.65 | 132.4 | 131.64 | 132.15 | 17644353.0 |
| 2024-06-17 14:00:00 | NVDA | Stock | 132.16 | 132.58 | 131.87 | 132.45 | 19316792.0 |
| 2024-06-17 15:00:00 | NVDA | Stock | 132.44 | 132.49 | 130.96 | 131.09 | 30527038.0 |
| 2024-06-17 16:00:00 | NVDA | Stock | 131.0 | 131.4795 | 130.3705 | 131.03 | 22319140.0 |
| 2024-06-17 17:00:00 | NVDA | Stock | 131.0399 | 132.89 | 130.75 | 130.84 | 586049.0 |
| 2024-06-17 18:00:00 | NVDA | Stock | 130.84 | 131.13 | 130.82 | 130.97 | 337950.0 |
| 2024-06-17 19:00:00 | NVDA | Stock | 130.98 | 131.05 | 130.86 | 130.97 | 619612.0 |
| 2024-06-17 04:00:00 | AMZN | Stock | 183.75 | 183.75 | 182.8 | 183.07 | 5970.0 |
| 2024-06-17 05:00:00 | AMZN | Stock | 182.86 | 183.0 | 182.77 | 182.86 | 3056.0 |
> showing 50 of 59,168 rows — these rows as CSV