PREVIEW / stock_1hour / 2024-02-27
file: by_date/stock_1hour/2024/2024-02-27.parquet size: 1.4 MB rows: 60,766 symbols: 1,132
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-02-27 04:00:00 | AAPL | Stock | 180.6 | 181.16 | 180.6 | 181.0 | 12103.0 |
| 2024-02-27 05:00:00 | AAPL | Stock | 181.0 | 181.15 | 180.77 | 180.98 | 8312.0 |
| 2024-02-27 06:00:00 | AAPL | Stock | 180.91 | 180.91 | 180.85 | 180.85 | 5421.0 |
| 2024-02-27 07:00:00 | AAPL | Stock | 180.82 | 181.22 | 180.81 | 181.16 | 16011.0 |
| 2024-02-27 08:00:00 | AAPL | Stock | 180.89 | 181.25 | 180.8401 | 181.12 | 95582.0 |
| 2024-02-27 09:00:00 | AAPL | Stock | 181.15 | 181.54 | 180.3 | 180.93 | 4167382.0 |
| 2024-02-27 10:00:00 | AAPL | Stock | 180.93 | 181.67 | 180.715 | 181.08 | 4107891.0 |
| 2024-02-27 11:00:00 | AAPL | Stock | 181.085 | 181.12 | 180.725 | 180.82 | 2339687.0 |
| 2024-02-27 12:00:00 | AAPL | Stock | 180.8227 | 181.0101 | 180.11 | 180.18 | 2586982.0 |
| 2024-02-27 13:00:00 | AAPL | Stock | 180.18 | 180.49 | 179.56 | 180.4599 | 3713820.0 |
| 2024-02-27 14:00:00 | AAPL | Stock | 180.465 | 183.9225 | 180.43 | 182.945 | 13687571.0 |
| 2024-02-27 15:00:00 | AAPL | Stock | 182.95 | 183.0 | 182.18 | 182.63 | 9177319.0 |
| 2024-02-27 16:00:00 | AAPL | Stock | 182.6 | 183.27 | 182.6 | 182.9 | 5055956.0 |
| 2024-02-27 17:00:00 | AAPL | Stock | 182.88 | 183.14 | 182.8 | 183.06 | 59872.0 |
| 2024-02-27 18:00:00 | AAPL | Stock | 183.06 | 183.18 | 182.8 | 182.88 | 35821.0 |
| 2024-02-27 19:00:00 | AAPL | Stock | 182.86 | 183.2 | 182.81 | 183.06 | 51972.0 |
| 2024-02-27 04:00:00 | MSFT | Stock | 407.54 | 407.86 | 406.97 | 407.72 | 6380.0 |
| 2024-02-27 05:00:00 | MSFT | Stock | 407.8 | 408.21 | 407.8 | 408.12 | 5627.0 |
| 2024-02-27 06:00:00 | MSFT | Stock | 407.99 | 407.99 | 406.56 | 406.79 | 3867.0 |
| 2024-02-27 07:00:00 | MSFT | Stock | 407.0 | 407.95 | 407.0 | 407.54 | 10399.0 |
| 2024-02-27 08:00:00 | MSFT | Stock | 407.3 | 407.9 | 406.63 | 407.1091 | 33309.0 |
| 2024-02-27 09:00:00 | MSFT | Stock | 407.0478 | 408.32 | 405.4 | 406.19 | 1356248.0 |
| 2024-02-27 10:00:00 | MSFT | Stock | 406.13 | 407.51 | 405.76 | 406.592 | 1059119.0 |
| 2024-02-27 11:00:00 | MSFT | Stock | 406.65 | 406.71 | 405.17 | 405.58 | 888192.0 |
| 2024-02-27 12:00:00 | MSFT | Stock | 405.61 | 406.12 | 403.9606 | 404.16 | 776615.0 |
| 2024-02-27 13:00:00 | MSFT | Stock | 404.12 | 406.25 | 403.85 | 406.08 | 772059.0 |
| 2024-02-27 14:00:00 | MSFT | Stock | 406.105 | 407.45 | 406.045 | 407.3413 | 928160.0 |
| 2024-02-27 15:00:00 | MSFT | Stock | 407.36 | 407.85 | 406.06 | 407.55 | 1789139.0 |
| 2024-02-27 16:00:00 | MSFT | Stock | 407.48 | 407.96 | 407.36 | 407.64 | 1881202.0 |
| 2024-02-27 17:00:00 | MSFT | Stock | 407.45 | 407.5 | 407.2 | 407.33 | 2102.0 |
| 2024-02-27 18:00:00 | MSFT | Stock | 407.3004 | 407.57 | 407.22 | 407.38 | 1000.0 |
| 2024-02-27 19:00:00 | MSFT | Stock | 407.25 | 407.4 | 407.01 | 407.01 | 3293.0 |
| 2024-02-27 04:00:00 | NVDA | Stock | 79.3 | 79.465 | 79.148 | 79.394 | 218740.0 |
| 2024-02-27 05:00:00 | NVDA | Stock | 79.393 | 79.498 | 79.22 | 79.365 | 120350.0 |
| 2024-02-27 06:00:00 | NVDA | Stock | 79.355 | 79.355 | 79.233 | 79.3 | 81120.0 |
| 2024-02-27 07:00:00 | NVDA | Stock | 79.27 | 79.515 | 79.163 | 79.25 | 734880.0 |
| 2024-02-27 08:00:00 | NVDA | Stock | 79.27 | 79.5 | 78.7 | 79.0 | 2705500.0 |
| 2024-02-27 09:00:00 | NVDA | Stock | 79.038 | 79.44 | 77.162 | 78.2996 | 70998230.0 |
| 2024-02-27 10:00:00 | NVDA | Stock | 78.34 | 79.05 | 78.21 | 78.9325 | 53264630.0 |
| 2024-02-27 11:00:00 | NVDA | Stock | 78.9362 | 79.205 | 78.55 | 79.0928 | 29605560.0 |
| 2024-02-27 12:00:00 | NVDA | Stock | 79.0868 | 79.299 | 78.7401 | 78.863 | 30533470.0 |
| 2024-02-27 13:00:00 | NVDA | Stock | 78.85 | 79.48 | 78.716 | 79.16 | 31061480.0 |
| 2024-02-27 14:00:00 | NVDA | Stock | 79.1597 | 79.284 | 78.951 | 79.059 | 22334000.0 |
| 2024-02-27 15:00:00 | NVDA | Stock | 79.062 | 79.165 | 78.7 | 78.7 | 29545010.0 |
| 2024-02-27 16:00:00 | NVDA | Stock | 78.701 | 78.839 | 78.601 | 78.839 | 10422150.0 |
| 2024-02-27 17:00:00 | NVDA | Stock | 78.825 | 78.835 | 78.701 | 78.733 | 246350.0 |
| 2024-02-27 18:00:00 | NVDA | Stock | 78.725 | 78.745 | 78.514 | 78.529 | 313890.0 |
| 2024-02-27 19:00:00 | NVDA | Stock | 78.526 | 78.6 | 78.5 | 78.55 | 396010.0 |
| 2024-02-27 04:00:00 | AMZN | Stock | 174.0 | 174.68 | 173.99 | 174.55 | 6126.0 |
| 2024-02-27 05:00:00 | AMZN | Stock | 174.53 | 174.67 | 174.28 | 174.35 | 5319.0 |
> showing 50 of 60,766 rows — these rows as CSV