PREVIEW / stock_1hour / 2024-09-19
file: by_date/stock_1hour/2024/2024-09-19.parquet size: 1.4 MB rows: 61,228 symbols: 802
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-09-19 04:00:00 | AAPL | Stock | 222.79 | 224.76 | 222.79 | 224.5 | 54196.0 |
| 2024-09-19 05:00:00 | AAPL | Stock | 224.34 | 224.49 | 223.87 | 224.38 | 27735.0 |
| 2024-09-19 06:00:00 | AAPL | Stock | 224.23 | 224.85 | 224.13 | 224.84 | 24223.0 |
| 2024-09-19 07:00:00 | AAPL | Stock | 224.5 | 224.89 | 224.01 | 224.7 | 62947.0 |
| 2024-09-19 08:00:00 | AAPL | Stock | 224.14 | 225.29 | 223.0 | 225.105 | 355256.0 |
| 2024-09-19 09:00:00 | AAPL | Stock | 225.1 | 227.42 | 224.63 | 227.3 | 8464788.0 |
| 2024-09-19 10:00:00 | AAPL | Stock | 227.29 | 229.82 | 227.23 | 227.94 | 9602811.0 |
| 2024-09-19 11:00:00 | AAPL | Stock | 227.96 | 228.8699 | 227.66 | 228.37 | 4408004.0 |
| 2024-09-19 12:00:00 | AAPL | Stock | 228.37 | 229.33 | 228.28 | 229.18 | 3218792.0 |
| 2024-09-19 13:00:00 | AAPL | Stock | 229.18 | 229.46 | 228.715 | 229.38 | 2802708.0 |
| 2024-09-19 14:00:00 | AAPL | Stock | 229.38 | 229.44 | 228.4 | 229.32 | 3280137.0 |
| 2024-09-19 15:00:00 | AAPL | Stock | 229.32 | 229.59 | 228.28 | 228.81 | 7882639.0 |
| 2024-09-19 16:00:00 | AAPL | Stock | 228.87 | 228.9 | 228.5291 | 228.58 | 11161934.0 |
| 2024-09-19 17:00:00 | AAPL | Stock | 228.6275 | 228.71 | 228.5374 | 228.6293 | 16596.0 |
| 2024-09-19 18:00:00 | AAPL | Stock | 228.63 | 228.8 | 228.4 | 228.5 | 21773.0 |
| 2024-09-19 19:00:00 | AAPL | Stock | 228.59 | 228.5944 | 228.258 | 228.546 | 21885.0 |
| 2024-09-19 04:00:00 | MSFT | Stock | 437.0 | 437.67 | 436.5 | 437.39 | 7657.0 |
| 2024-09-19 05:00:00 | MSFT | Stock | 438.0 | 439.2 | 437.9 | 439.06 | 7050.0 |
| 2024-09-19 06:00:00 | MSFT | Stock | 439.25 | 440.0 | 438.82 | 439.13 | 10372.0 |
| 2024-09-19 07:00:00 | MSFT | Stock | 439.02 | 439.25 | 437.81 | 438.0 | 21895.0 |
| 2024-09-19 08:00:00 | MSFT | Stock | 438.32 | 439.3667 | 430.81 | 437.6 | 37192.0 |
| 2024-09-19 09:00:00 | MSFT | Stock | 437.6075 | 442.47 | 436.9 | 436.97 | 2500911.0 |
| 2024-09-19 10:00:00 | MSFT | Stock | 437.135 | 440.059 | 437.0 | 438.16 | 1384328.0 |
| 2024-09-19 11:00:00 | MSFT | Stock | 438.17 | 439.74 | 437.29 | 438.91 | 892500.0 |
| 2024-09-19 12:00:00 | MSFT | Stock | 438.96 | 439.84 | 438.45 | 438.475 | 758087.0 |
| 2024-09-19 13:00:00 | MSFT | Stock | 438.4999 | 439.88 | 437.8 | 439.36 | 825114.0 |
| 2024-09-19 14:00:00 | MSFT | Stock | 439.35 | 439.73 | 438.19 | 439.51 | 892842.0 |
| 2024-09-19 15:00:00 | MSFT | Stock | 439.49 | 439.6 | 437.7 | 438.68 | 1486248.0 |
| 2024-09-19 16:00:00 | MSFT | Stock | 438.69 | 438.92 | 437.79 | 438.11 | 6044276.0 |
| 2024-09-19 17:00:00 | MSFT | Stock | 438.2 | 438.39 | 438.07 | 438.35 | 1907.0 |
| 2024-09-19 18:00:00 | MSFT | Stock | 438.37 | 439.1 | 438.2577 | 438.69 | 14293.0 |
| 2024-09-19 19:00:00 | MSFT | Stock | 438.6001 | 439.0 | 438.5167 | 438.8822 | 6341.0 |
| 2024-09-19 04:00:00 | NVDA | Stock | 116.56 | 116.72 | 115.56 | 116.53 | 1002814.0 |
| 2024-09-19 05:00:00 | NVDA | Stock | 116.54 | 117.33 | 116.46 | 117.09 | 708079.0 |
| 2024-09-19 06:00:00 | NVDA | Stock | 117.09 | 117.3 | 116.78 | 116.98 | 415416.0 |
| 2024-09-19 07:00:00 | NVDA | Stock | 116.95 | 117.25 | 116.79 | 117.17 | 1244699.0 |
| 2024-09-19 08:00:00 | NVDA | Stock | 117.15 | 117.3088 | 115.5 | 117.0 | 3385309.0 |
| 2024-09-19 09:00:00 | NVDA | Stock | 116.99 | 119.19 | 116.8 | 118.4 | 52524587.0 |
| 2024-09-19 10:00:00 | NVDA | Stock | 118.4 | 119.47 | 117.8 | 118.5775 | 42681128.0 |
| 2024-09-19 11:00:00 | NVDA | Stock | 118.58 | 119.66 | 118.51 | 118.875 | 28136280.0 |
| 2024-09-19 12:00:00 | NVDA | Stock | 118.875 | 119.49 | 118.81 | 119.4838 | 20742055.0 |
| 2024-09-19 13:00:00 | NVDA | Stock | 119.485 | 119.66 | 119.03 | 119.2891 | 19004909.0 |
| 2024-09-19 14:00:00 | NVDA | Stock | 119.29 | 119.39 | 118.18 | 118.5592 | 22657869.0 |
| 2024-09-19 15:00:00 | NVDA | Stock | 118.56 | 118.65 | 117.61 | 117.98 | 34231662.0 |
| 2024-09-19 16:00:00 | NVDA | Stock | 117.87 | 118.05 | 117.52 | 117.8898 | 28620639.0 |
| 2024-09-19 17:00:00 | NVDA | Stock | 117.84 | 117.95 | 117.71 | 117.79 | 308559.0 |
| 2024-09-19 18:00:00 | NVDA | Stock | 117.8 | 117.97 | 117.74 | 117.79 | 293413.0 |
| 2024-09-19 19:00:00 | NVDA | Stock | 117.7996 | 117.98 | 117.72 | 117.87 | 360921.0 |
| 2024-09-19 04:00:00 | AMZN | Stock | 188.97 | 189.71 | 188.97 | 189.4 | 18635.0 |
| 2024-09-19 05:00:00 | AMZN | Stock | 189.36 | 189.95 | 189.36 | 189.65 | 11132.0 |
> showing 50 of 61,228 rows — these rows as CSV