PREVIEW / stock_1hour / 2024-02-23
file: by_date/stock_1hour/2024/2024-02-23.parquet size: 1.3 MB rows: 59,286 symbols: 1,121
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-23 04:00:00 | AAPL | Stock | 183.94 | 184.0 | 183.4 | 183.76 | 10730.0 |
| 2024-02-23 05:00:00 | AAPL | Stock | 183.71 | 183.85 | 183.61 | 183.85 | 3865.0 |
| 2024-02-23 06:00:00 | AAPL | Stock | 183.85 | 184.1 | 183.75 | 183.9 | 15370.0 |
| 2024-02-23 07:00:00 | AAPL | Stock | 183.9 | 184.18 | 183.8 | 184.08 | 12317.0 |
| 2024-02-23 08:00:00 | AAPL | Stock | 183.8 | 184.5 | 183.78 | 184.44 | 75818.0 |
| 2024-02-23 09:00:00 | AAPL | Stock | 184.47 | 185.35 | 183.75 | 183.87 | 4279512.0 |
| 2024-02-23 10:00:00 | AAPL | Stock | 183.88 | 183.94 | 182.8 | 183.39 | 5065949.0 |
| 2024-02-23 11:00:00 | AAPL | Stock | 183.39 | 183.41 | 182.64 | 182.92 | 3781170.0 |
| 2024-02-23 12:00:00 | AAPL | Stock | 182.915 | 183.03 | 182.31 | 182.8026 | 3154451.0 |
| 2024-02-23 13:00:00 | AAPL | Stock | 182.805 | 182.97 | 182.6 | 182.725 | 2745447.0 |
| 2024-02-23 14:00:00 | AAPL | Stock | 182.73 | 182.77 | 182.4303 | 182.615 | 2650912.0 |
| 2024-02-23 15:00:00 | AAPL | Stock | 182.61 | 182.82 | 182.23 | 182.52 | 6067693.0 |
| 2024-02-23 16:00:00 | AAPL | Stock | 182.45 | 182.9 | 182.35 | 182.57 | 5360116.0 |
| 2024-02-23 17:00:00 | AAPL | Stock | 182.55 | 182.56 | 182.36 | 182.36 | 47136.0 |
| 2024-02-23 18:00:00 | AAPL | Stock | 182.36 | 182.39 | 182.31 | 182.33 | 22233.0 |
| 2024-02-23 19:00:00 | AAPL | Stock | 182.31 | 182.35 | 182.23 | 182.28 | 16380.0 |
| 2024-02-23 04:00:00 | MSFT | Stock | 411.86 | 413.1 | 411.86 | 412.66 | 7570.0 |
| 2024-02-23 05:00:00 | MSFT | Stock | 412.66 | 412.92 | 412.5 | 412.92 | 7927.0 |
| 2024-02-23 06:00:00 | MSFT | Stock | 412.92 | 414.3 | 412.86 | 414.19 | 6324.0 |
| 2024-02-23 07:00:00 | MSFT | Stock | 413.86 | 413.91 | 412.94 | 413.3 | 9103.0 |
| 2024-02-23 08:00:00 | MSFT | Stock | 413.81 | 414.79 | 412.08 | 414.41 | 49339.0 |
| 2024-02-23 09:00:00 | MSFT | Stock | 414.5 | 415.86 | 413.42 | 414.26 | 1921509.0 |
| 2024-02-23 10:00:00 | MSFT | Stock | 414.3 | 414.31 | 411.29 | 411.46 | 1572045.0 |
| 2024-02-23 11:00:00 | MSFT | Stock | 411.4 | 411.5405 | 409.29 | 410.24 | 1061334.0 |
| 2024-02-23 12:00:00 | MSFT | Stock | 410.22 | 410.415 | 408.97 | 409.78 | 733142.0 |
| 2024-02-23 13:00:00 | MSFT | Stock | 409.77 | 410.38 | 409.52 | 410.38 | 539427.0 |
| 2024-02-23 14:00:00 | MSFT | Stock | 410.38 | 410.78 | 409.75 | 410.54 | 582283.0 |
| 2024-02-23 15:00:00 | MSFT | Stock | 410.525 | 410.85 | 409.53 | 410.32 | 1537463.0 |
| 2024-02-23 16:00:00 | MSFT | Stock | 410.34 | 410.91 | 409.92 | 409.92 | 2774614.0 |
| 2024-02-23 17:00:00 | MSFT | Stock | 409.91 | 410.3 | 409.8 | 410.3 | 4611.0 |
| 2024-02-23 18:00:00 | MSFT | Stock | 410.27 | 410.27 | 409.76 | 409.88 | 4106.0 |
| 2024-02-23 19:00:00 | MSFT | Stock | 409.7601 | 409.7601 | 409.36 | 409.42 | 1433.0 |
| 2024-02-23 04:00:00 | NVDA | Stock | 80.218 | 80.62 | 79.851 | 80.22 | 1193970.0 |
| 2024-02-23 05:00:00 | NVDA | Stock | 80.225 | 80.323 | 80.0 | 80.0 | 571520.0 |
| 2024-02-23 06:00:00 | NVDA | Stock | 80.0 | 80.1 | 79.469 | 79.88 | 1029940.0 |
| 2024-02-23 07:00:00 | NVDA | Stock | 79.895 | 80.155 | 79.415 | 80.07 | 2466340.0 |
| 2024-02-23 08:00:00 | NVDA | Stock | 79.93 | 80.693 | 79.413 | 80.2 | 6256850.0 |
| 2024-02-23 09:00:00 | NVDA | Stock | 80.2 | 82.394 | 80.2 | 80.7 | 120464820.0 |
| 2024-02-23 10:00:00 | NVDA | Stock | 80.6965 | 81.245 | 78.602 | 78.685 | 121267780.0 |
| 2024-02-23 11:00:00 | NVDA | Stock | 78.672 | 80.054 | 77.57 | 80.025 | 111419090.0 |
| 2024-02-23 12:00:00 | NVDA | Stock | 80.018 | 80.444 | 79.132 | 80.116 | 68164770.0 |
| 2024-02-23 13:00:00 | NVDA | Stock | 80.1064 | 80.285 | 79.612 | 79.8364 | 39039890.0 |
| 2024-02-23 14:00:00 | NVDA | Stock | 79.838 | 80.0305 | 79.562 | 79.796 | 34622130.0 |
| 2024-02-23 15:00:00 | NVDA | Stock | 79.796 | 79.876 | 78.65 | 78.845 | 69507350.0 |
| 2024-02-23 16:00:00 | NVDA | Stock | 78.817 | 79.033 | 78.817 | 79.001 | 18045510.0 |
| 2024-02-23 17:00:00 | NVDA | Stock | 78.994 | 79.048 | 78.817 | 78.915 | 1414420.0 |
| 2024-02-23 18:00:00 | NVDA | Stock | 78.916 | 78.965 | 78.6241 | 78.631 | 523880.0 |
| 2024-02-23 19:00:00 | NVDA | Stock | 78.631 | 78.8 | 78.46 | 78.69 | 728290.0 |
| 2024-02-23 04:00:00 | AMZN | Stock | 174.27 | 174.67 | 173.7 | 173.92 | 10848.0 |
| 2024-02-23 05:00:00 | AMZN | Stock | 173.96 | 174.0 | 173.58 | 173.75 | 10800.0 |
> showing 50 of 59,286 rows — these rows as CSV