PREVIEW / stock_1hour / 2024-05-15
file: by_date/stock_1hour/2024/2024-05-15.parquet size: 1.4 MB rows: 60,285 symbols: 972
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-05-15 04:00:00 | AAPL | Stock | 187.43 | 187.43 | 187.0 | 187.34 | 5199.0 |
| 2024-05-15 05:00:00 | AAPL | Stock | 187.34 | 187.37 | 187.3 | 187.3 | 3865.0 |
| 2024-05-15 06:00:00 | AAPL | Stock | 187.27 | 187.27 | 187.2 | 187.2 | 901.0 |
| 2024-05-15 07:00:00 | AAPL | Stock | 187.24 | 187.35 | 187.2 | 187.3 | 19362.0 |
| 2024-05-15 08:00:00 | AAPL | Stock | 187.29 | 188.23 | 187.0 | 187.75 | 259552.0 |
| 2024-05-15 09:00:00 | AAPL | Stock | 187.76 | 188.89 | 187.2 | 188.87 | 5888755.0 |
| 2024-05-15 10:00:00 | AAPL | Stock | 188.8521 | 189.95 | 188.8 | 189.92 | 9485763.0 |
| 2024-05-15 11:00:00 | AAPL | Stock | 189.93 | 190.07 | 189.54 | 189.885 | 6867243.0 |
| 2024-05-15 12:00:00 | AAPL | Stock | 189.89 | 190.51 | 189.795 | 190.39 | 5185705.0 |
| 2024-05-15 13:00:00 | AAPL | Stock | 190.395 | 190.65 | 190.17 | 190.38 | 4235665.0 |
| 2024-05-15 14:00:00 | AAPL | Stock | 190.385 | 190.39 | 189.82 | 189.975 | 4484437.0 |
| 2024-05-15 15:00:00 | AAPL | Stock | 189.975 | 190.26 | 189.5 | 189.75 | 10295850.0 |
| 2024-05-15 16:00:00 | AAPL | Stock | 189.93 | 190.0 | 189.6 | 189.78 | 9723866.0 |
| 2024-05-15 17:00:00 | AAPL | Stock | 189.75 | 189.78 | 189.71 | 189.72 | 45970.0 |
| 2024-05-15 18:00:00 | AAPL | Stock | 189.78 | 190.0 | 189.76 | 189.85 | 15778.0 |
| 2024-05-15 19:00:00 | AAPL | Stock | 189.92 | 190.0 | 189.87 | 189.96 | 11326.0 |
| 2024-05-15 04:00:00 | MSFT | Stock | 415.61 | 415.61 | 415.35 | 415.4 | 2398.0 |
| 2024-05-15 05:00:00 | MSFT | Stock | 415.63 | 415.81 | 415.63 | 415.71 | 967.0 |
| 2024-05-15 06:00:00 | MSFT | Stock | 415.6 | 415.83 | 415.6 | 415.74 | 3226.0 |
| 2024-05-15 07:00:00 | MSFT | Stock | 415.92 | 416.7 | 415.92 | 416.5 | 5433.0 |
| 2024-05-15 08:00:00 | MSFT | Stock | 416.61 | 418.75 | 415.7 | 417.27 | 65119.0 |
| 2024-05-15 09:00:00 | MSFT | Stock | 417.1 | 420.45 | 416.35 | 418.27 | 1651525.0 |
| 2024-05-15 10:00:00 | MSFT | Stock | 418.21 | 420.3 | 418.2 | 420.1399 | 1256007.0 |
| 2024-05-15 11:00:00 | MSFT | Stock | 420.17 | 422.0976 | 420.17 | 421.6781 | 1166698.0 |
| 2024-05-15 12:00:00 | MSFT | Stock | 421.66 | 421.85 | 420.69 | 421.84 | 674015.0 |
| 2024-05-15 13:00:00 | MSFT | Stock | 421.87 | 423.07 | 421.8236 | 422.955 | 642399.0 |
| 2024-05-15 14:00:00 | MSFT | Stock | 422.9699 | 423.67 | 422.85 | 423.25 | 705770.0 |
| 2024-05-15 15:00:00 | MSFT | Stock | 423.22 | 423.81 | 422.56 | 423.15 | 2035532.0 |
| 2024-05-15 16:00:00 | MSFT | Stock | 423.08 | 423.5 | 421.8395 | 423.0 | 3952398.0 |
| 2024-05-15 17:00:00 | MSFT | Stock | 423.14 | 423.2 | 422.8 | 422.9499 | 6872.0 |
| 2024-05-15 18:00:00 | MSFT | Stock | 423.08 | 423.45 | 422.92 | 423.3 | 4610.0 |
| 2024-05-15 19:00:00 | MSFT | Stock | 423.15 | 423.85 | 423.0 | 423.55 | 7621.0 |
| 2024-05-15 04:00:00 | NVDA | Stock | 91.3 | 91.3 | 91.101 | 91.161 | 33170.0 |
| 2024-05-15 05:00:00 | NVDA | Stock | 91.185 | 91.221 | 91.14 | 91.159 | 39260.0 |
| 2024-05-15 06:00:00 | NVDA | Stock | 91.131 | 91.15 | 91.0 | 91.023 | 34990.0 |
| 2024-05-15 07:00:00 | NVDA | Stock | 91.1 | 91.417 | 91.06 | 91.28 | 354280.0 |
| 2024-05-15 08:00:00 | NVDA | Stock | 91.1 | 92.635 | 91.075 | 92.44 | 5943850.0 |
| 2024-05-15 09:00:00 | NVDA | Stock | 92.44 | 93.23 | 91.599 | 92.7625 | 55989370.0 |
| 2024-05-15 10:00:00 | NVDA | Stock | 92.79 | 93.977 | 92.739 | 93.972 | 54014270.0 |
| 2024-05-15 11:00:00 | NVDA | Stock | 93.973 | 94.488 | 93.82 | 94.3556 | 43351770.0 |
| 2024-05-15 12:00:00 | NVDA | Stock | 94.3695 | 94.687 | 94.186 | 94.503 | 28709260.0 |
| 2024-05-15 13:00:00 | NVDA | Stock | 94.525 | 94.613 | 94.06 | 94.5492 | 23381850.0 |
| 2024-05-15 14:00:00 | NVDA | Stock | 94.5465 | 94.85 | 94.439 | 94.706 | 25081830.0 |
| 2024-05-15 15:00:00 | NVDA | Stock | 94.6847 | 94.862 | 94.358 | 94.656 | 38409240.0 |
| 2024-05-15 16:00:00 | NVDA | Stock | 94.63 | 94.997 | 94.55 | 94.975 | 20251320.0 |
| 2024-05-15 17:00:00 | NVDA | Stock | 94.982 | 95.204 | 94.9 | 95.07 | 1196470.0 |
| 2024-05-15 18:00:00 | NVDA | Stock | 95.063 | 95.184 | 95.036 | 95.066 | 462680.0 |
| 2024-05-15 19:00:00 | NVDA | Stock | 95.076 | 95.2 | 95.055 | 95.17 | 506530.0 |
| 2024-05-15 04:00:00 | AMZN | Stock | 186.98 | 187.0 | 186.76 | 186.93 | 5681.0 |
| 2024-05-15 05:00:00 | AMZN | Stock | 186.93 | 186.93 | 186.82 | 186.86 | 2495.0 |
> showing 50 of 60,285 rows — these rows as CSV