PREVIEW / stock_1hour / 2024-10-10
file: by_date/stock_1hour/2024/2024-10-10.parquet size: 1.3 MB rows: 58,121 symbols: 765
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-10-10 04:00:00 | AAPL | Stock | 229.4 | 229.4 | 228.76 | 228.83 | 5143.0 |
| 2024-10-10 05:00:00 | AAPL | Stock | 228.84 | 228.93 | 228.36 | 228.66 | 15967.0 |
| 2024-10-10 06:00:00 | AAPL | Stock | 228.68 | 228.75 | 228.48 | 228.49 | 11933.0 |
| 2024-10-10 07:00:00 | AAPL | Stock | 228.57 | 229.0 | 228.47 | 229.0 | 20637.0 |
| 2024-10-10 08:00:00 | AAPL | Stock | 228.6 | 229.1 | 227.75 | 227.8 | 302363.0 |
| 2024-10-10 09:00:00 | AAPL | Stock | 227.82 | 228.8298 | 227.17 | 228.44 | 3193597.0 |
| 2024-10-10 10:00:00 | AAPL | Stock | 228.44 | 228.57 | 227.63 | 227.83 | 2574986.0 |
| 2024-10-10 11:00:00 | AAPL | Stock | 227.85 | 228.66 | 227.69 | 228.655 | 1403969.0 |
| 2024-10-10 12:00:00 | AAPL | Stock | 228.66 | 229.24 | 228.1203 | 228.44 | 1668956.0 |
| 2024-10-10 13:00:00 | AAPL | Stock | 228.44 | 228.8 | 228.03 | 228.62 | 1306811.0 |
| 2024-10-10 14:00:00 | AAPL | Stock | 228.6499 | 228.6499 | 228.07 | 228.485 | 1010447.0 |
| 2024-10-10 15:00:00 | AAPL | Stock | 228.48 | 229.5 | 228.26 | 229.03 | 3065261.0 |
| 2024-10-10 16:00:00 | AAPL | Stock | 229.04 | 229.24 | 229.02 | 229.1915 | 5992218.0 |
| 2024-10-10 17:00:00 | AAPL | Stock | 229.208 | 229.23 | 229.1025 | 229.12 | 5594.0 |
| 2024-10-10 18:00:00 | AAPL | Stock | 229.15 | 229.25 | 229.0904 | 229.2284 | 23195.0 |
| 2024-10-10 19:00:00 | AAPL | Stock | 229.2464 | 229.44 | 229.2211 | 229.36 | 26082.0 |
| 2024-10-10 04:00:00 | MSFT | Stock | 417.11 | 418.0 | 416.66 | 416.66 | 9147.0 |
| 2024-10-10 05:00:00 | MSFT | Stock | 416.95 | 417.55 | 416.95 | 417.43 | 1758.0 |
| 2024-10-10 06:00:00 | MSFT | Stock | 417.67 | 418.79 | 417.67 | 418.15 | 7682.0 |
| 2024-10-10 07:00:00 | MSFT | Stock | 418.01 | 418.01 | 416.95 | 417.29 | 7492.0 |
| 2024-10-10 08:00:00 | MSFT | Stock | 418.0016 | 418.0016 | 415.2062 | 415.495 | 47224.0 |
| 2024-10-10 09:00:00 | MSFT | Stock | 415.4 | 416.48 | 413.15 | 414.9 | 1338879.0 |
| 2024-10-10 10:00:00 | MSFT | Stock | 414.96 | 415.755 | 413.88 | 414.37 | 1022158.0 |
| 2024-10-10 11:00:00 | MSFT | Stock | 414.375 | 416.95 | 414.1 | 416.9199 | 801816.0 |
| 2024-10-10 12:00:00 | MSFT | Stock | 416.85 | 417.35 | 415.65 | 415.87 | 685435.0 |
| 2024-10-10 13:00:00 | MSFT | Stock | 415.85 | 416.4099 | 414.7 | 415.86 | 638048.0 |
| 2024-10-10 14:00:00 | MSFT | Stock | 415.86 | 415.86 | 414.74 | 415.4 | 640889.0 |
| 2024-10-10 15:00:00 | MSFT | Stock | 415.38 | 416.26 | 414.7176 | 415.841 | 1459425.0 |
| 2024-10-10 16:00:00 | MSFT | Stock | 415.84 | 416.1 | 415.65 | 415.84 | 2778707.0 |
| 2024-10-10 17:00:00 | MSFT | Stock | 415.95 | 416.0 | 415.88 | 415.88 | 1185.0 |
| 2024-10-10 18:00:00 | MSFT | Stock | 415.88 | 416.34 | 415.88 | 416.2375 | 2583.0 |
| 2024-10-10 19:00:00 | MSFT | Stock | 416.34 | 416.9799 | 416.34 | 416.9799 | 5433.0 |
| 2024-10-10 04:00:00 | NVDA | Stock | 132.65 | 132.65 | 131.38 | 131.71 | 492342.0 |
| 2024-10-10 05:00:00 | NVDA | Stock | 131.67 | 131.99 | 131.47 | 131.95 | 167683.0 |
| 2024-10-10 06:00:00 | NVDA | Stock | 131.98 | 132.25 | 131.9 | 132.02 | 138821.0 |
| 2024-10-10 07:00:00 | NVDA | Stock | 132.05 | 132.74 | 131.99 | 132.66 | 516544.0 |
| 2024-10-10 08:00:00 | NVDA | Stock | 132.65 | 132.95 | 130.8 | 131.57 | 4933859.0 |
| 2024-10-10 09:00:00 | NVDA | Stock | 131.5215 | 133.33 | 131.0 | 132.83 | 36022829.0 |
| 2024-10-10 10:00:00 | NVDA | Stock | 132.826 | 134.77 | 132.62 | 134.3007 | 45393924.0 |
| 2024-10-10 11:00:00 | NVDA | Stock | 134.3001 | 134.95 | 133.83 | 134.893 | 25080434.0 |
| 2024-10-10 12:00:00 | NVDA | Stock | 134.89 | 135.0 | 133.95 | 134.465 | 23475284.0 |
| 2024-10-10 13:00:00 | NVDA | Stock | 134.47 | 134.98 | 134.1 | 134.61 | 19990107.0 |
| 2024-10-10 14:00:00 | NVDA | Stock | 134.62 | 134.71 | 133.52 | 134.094 | 18690852.0 |
| 2024-10-10 15:00:00 | NVDA | Stock | 134.1 | 134.85 | 133.71 | 134.8 | 27441799.0 |
| 2024-10-10 16:00:00 | NVDA | Stock | 134.83 | 134.85 | 134.54 | 134.68 | 12271443.0 |
| 2024-10-10 17:00:00 | NVDA | Stock | 134.67 | 134.7 | 134.51 | 134.5811 | 293319.0 |
| 2024-10-10 18:00:00 | NVDA | Stock | 134.58 | 134.79 | 134.58 | 134.68 | 268987.0 |
| 2024-10-10 19:00:00 | NVDA | Stock | 134.67 | 134.8 | 134.67 | 134.78 | 419714.0 |
| 2024-10-10 04:00:00 | AMZN | Stock | 185.15 | 185.25 | 185.06 | 185.08 | 11198.0 |
| 2024-10-10 05:00:00 | AMZN | Stock | 185.07 | 185.29 | 185.07 | 185.24 | 2290.0 |
> showing 50 of 58,121 rows — these rows as CSV