PREVIEW / stock_1hour / 2024-01-05
file: by_date/stock_1hour/2024/2024-01-05.parquet size: 1.3 MB rows: 58,655 symbols: 1,169
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-01-05 04:00:00 | AAPL | Stock | 181.79 | 181.79 | 180.8 | 180.8 | 23134.0 |
| 2024-01-05 05:00:00 | AAPL | Stock | 180.71 | 180.8 | 180.45 | 180.6 | 16586.0 |
| 2024-01-05 06:00:00 | AAPL | Stock | 180.63 | 180.75 | 180.2 | 180.75 | 23319.0 |
| 2024-01-05 07:00:00 | AAPL | Stock | 180.72 | 181.06 | 180.55 | 180.55 | 53313.0 |
| 2024-01-05 08:00:00 | AAPL | Stock | 181.01 | 181.92 | 180.18 | 181.13 | 428396.0 |
| 2024-01-05 09:00:00 | AAPL | Stock | 181.14 | 182.76 | 181.14 | 181.69 | 6071991.0 |
| 2024-01-05 10:00:00 | AAPL | Stock | 181.71 | 182.65 | 181.7 | 182.65 | 6130268.0 |
| 2024-01-05 11:00:00 | AAPL | Stock | 182.66 | 182.74 | 181.9101 | 182.1022 | 3641469.0 |
| 2024-01-05 12:00:00 | AAPL | Stock | 182.11 | 182.22 | 181.28 | 181.59 | 3964423.0 |
| 2024-01-05 13:00:00 | AAPL | Stock | 181.5933 | 182.23 | 181.21 | 182.035 | 3826878.0 |
| 2024-01-05 14:00:00 | AAPL | Stock | 182.035 | 182.18 | 180.42 | 180.485 | 9939297.0 |
| 2024-01-05 15:00:00 | AAPL | Stock | 180.49 | 181.26 | 180.17 | 181.18 | 9082059.0 |
| 2024-01-05 16:00:00 | AAPL | Stock | 181.17 | 181.27 | 180.76 | 180.87 | 7966284.0 |
| 2024-01-05 17:00:00 | AAPL | Stock | 180.86 | 181.18 | 180.86 | 181.03 | 35032.0 |
| 2024-01-05 18:00:00 | AAPL | Stock | 181.05 | 181.0565 | 180.8 | 180.83 | 33884.0 |
| 2024-01-05 19:00:00 | AAPL | Stock | 180.89 | 180.9 | 180.74 | 180.78 | 28856.0 |
| 2024-01-05 04:00:00 | MSFT | Stock | 367.97 | 368.0 | 367.5 | 367.5 | 2156.0 |
| 2024-01-05 05:00:00 | MSFT | Stock | 367.66 | 367.86 | 367.53 | 367.53 | 1521.0 |
| 2024-01-05 06:00:00 | MSFT | Stock | 367.82 | 367.82 | 367.47 | 367.52 | 1880.0 |
| 2024-01-05 07:00:00 | MSFT | Stock | 367.47 | 368.25 | 367.41 | 367.7 | 7853.0 |
| 2024-01-05 08:00:00 | MSFT | Stock | 367.5892 | 368.6706 | 367.0 | 368.509 | 51657.0 |
| 2024-01-05 09:00:00 | MSFT | Stock | 368.3127 | 370.65 | 368.3127 | 369.66 | 1510745.0 |
| 2024-01-05 10:00:00 | MSFT | Stock | 369.63 | 371.73 | 369.58 | 371.6712 | 1927871.0 |
| 2024-01-05 11:00:00 | MSFT | Stock | 371.67 | 372.06 | 370.215 | 370.765 | 1209411.0 |
| 2024-01-05 12:00:00 | MSFT | Stock | 370.76 | 370.76 | 368.81 | 368.9359 | 1002232.0 |
| 2024-01-05 13:00:00 | MSFT | Stock | 368.9549 | 369.14 | 367.99 | 368.4 | 1096807.0 |
| 2024-01-05 14:00:00 | MSFT | Stock | 368.395 | 368.85 | 366.952 | 367.19 | 1210295.0 |
| 2024-01-05 15:00:00 | MSFT | Stock | 367.19 | 368.02 | 366.5 | 367.72 | 2278925.0 |
| 2024-01-05 16:00:00 | MSFT | Stock | 367.67 | 368.31 | 367.5 | 367.53 | 3249892.0 |
| 2024-01-05 17:00:00 | MSFT | Stock | 367.65 | 367.95 | 367.56 | 367.9 | 2865.0 |
| 2024-01-05 18:00:00 | MSFT | Stock | 367.8 | 367.8 | 367.6 | 367.7 | 3633.0 |
| 2024-01-05 19:00:00 | MSFT | Stock | 367.7 | 367.94 | 367.66 | 367.94 | 7406.0 |
| 2024-01-05 04:00:00 | NVDA | Stock | 48.03 | 48.037 | 47.766 | 47.766 | 68130.0 |
| 2024-01-05 05:00:00 | NVDA | Stock | 47.77 | 47.85 | 47.73 | 47.804 | 54460.0 |
| 2024-01-05 06:00:00 | NVDA | Stock | 47.822 | 47.84 | 47.776 | 47.84 | 26160.0 |
| 2024-01-05 07:00:00 | NVDA | Stock | 47.85 | 48.016 | 47.831 | 48.0 | 266210.0 |
| 2024-01-05 08:00:00 | NVDA | Stock | 47.927 | 48.2705 | 47.849 | 48.23 | 2732610.0 |
| 2024-01-05 09:00:00 | NVDA | Stock | 48.25 | 48.7477 | 48.237 | 48.517 | 43627180.0 |
| 2024-01-05 10:00:00 | NVDA | Stock | 48.521 | 49.278 | 48.519 | 49.2438 | 62309290.0 |
| 2024-01-05 11:00:00 | NVDA | Stock | 49.249 | 49.547 | 49.211 | 49.2588 | 55313040.0 |
| 2024-01-05 12:00:00 | NVDA | Stock | 49.2491 | 49.261 | 48.97 | 49.2348 | 37398680.0 |
| 2024-01-05 13:00:00 | NVDA | Stock | 49.2345 | 49.35 | 49.01 | 49.2259 | 27175670.0 |
| 2024-01-05 14:00:00 | NVDA | Stock | 49.229 | 49.29 | 48.907 | 48.972 | 27059580.0 |
| 2024-01-05 15:00:00 | NVDA | Stock | 48.963 | 49.103 | 48.783 | 49.09 | 45643590.0 |
| 2024-01-05 16:00:00 | NVDA | Stock | 49.087 | 49.199 | 49.082 | 49.1868 | 19182490.0 |
| 2024-01-05 17:00:00 | NVDA | Stock | 49.156 | 49.216 | 49.097 | 49.1748 | 312170.0 |
| 2024-01-05 18:00:00 | NVDA | Stock | 49.1738 | 49.216 | 49.168 | 49.18 | 195980.0 |
| 2024-01-05 19:00:00 | NVDA | Stock | 49.17 | 49.194 | 49.168 | 49.17 | 125620.0 |
| 2024-01-05 04:00:00 | AMZN | Stock | 144.75 | 144.75 | 144.2 | 144.32 | 3579.0 |
| 2024-01-05 05:00:00 | AMZN | Stock | 144.26 | 144.3 | 143.83 | 143.95 | 12245.0 |
> showing 50 of 58,655 rows — these rows as CSV