PREVIEW / stock_1hour / 2024-10-14
file: by_date/stock_1hour/2024/2024-10-14.parquet size: 1.4 MB rows: 59,805 symbols: 773
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-14 04:00:00 | AAPL | Stock | 228.0 | 228.4 | 227.71 | 227.85 | 19969.0 |
| 2024-10-14 05:00:00 | AAPL | Stock | 227.98 | 228.4 | 227.95 | 228.24 | 9792.0 |
| 2024-10-14 06:00:00 | AAPL | Stock | 228.04 | 229.49 | 228.04 | 229.0 | 33752.0 |
| 2024-10-14 07:00:00 | AAPL | Stock | 229.0 | 229.2 | 228.7 | 228.8 | 41486.0 |
| 2024-10-14 08:00:00 | AAPL | Stock | 229.0 | 229.2 | 227.12 | 228.79 | 85548.0 |
| 2024-10-14 09:00:00 | AAPL | Stock | 228.75 | 231.31 | 228.56 | 230.555 | 4544315.0 |
| 2024-10-14 10:00:00 | AAPL | Stock | 230.57 | 230.885 | 229.31 | 229.48 | 3319033.0 |
| 2024-10-14 11:00:00 | AAPL | Stock | 229.47 | 230.35 | 229.15 | 230.346 | 1978989.0 |
| 2024-10-14 12:00:00 | AAPL | Stock | 230.34 | 230.61 | 229.97 | 230.33 | 1356689.0 |
| 2024-10-14 13:00:00 | AAPL | Stock | 230.355 | 230.56 | 230.16 | 230.19 | 1035127.0 |
| 2024-10-14 14:00:00 | AAPL | Stock | 230.19 | 231.2 | 230.06 | 231.15 | 1988863.0 |
| 2024-10-14 15:00:00 | AAPL | Stock | 231.16 | 231.73 | 231.04 | 231.4 | 4662013.0 |
| 2024-10-14 16:00:00 | AAPL | Stock | 231.3 | 231.46 | 230.84 | 231.19 | 6397263.0 |
| 2024-10-14 17:00:00 | AAPL | Stock | 231.19 | 231.3 | 231.0877 | 231.14 | 296086.0 |
| 2024-10-14 18:00:00 | AAPL | Stock | 231.14 | 231.25 | 231.0928 | 231.2235 | 12528.0 |
| 2024-10-14 19:00:00 | AAPL | Stock | 231.2235 | 231.3 | 231.2 | 231.3 | 13389.0 |
| 2024-10-14 04:00:00 | MSFT | Stock | 416.34 | 416.89 | 416.33 | 416.35 | 2977.0 |
| 2024-10-14 05:00:00 | MSFT | Stock | 416.54 | 416.99 | 416.54 | 416.7 | 1370.0 |
| 2024-10-14 06:00:00 | MSFT | Stock | 416.84 | 417.0 | 416.83 | 416.83 | 4104.0 |
| 2024-10-14 07:00:00 | MSFT | Stock | 416.9 | 417.1 | 416.76 | 417.1 | 4296.0 |
| 2024-10-14 08:00:00 | MSFT | Stock | 416.69 | 418.5 | 415.56 | 418.5 | 20982.0 |
| 2024-10-14 09:00:00 | MSFT | Stock | 418.442 | 422.255 | 417.5 | 421.71 | 1468991.0 |
| 2024-10-14 10:00:00 | MSFT | Stock | 421.71 | 424.04 | 419.59 | 419.8079 | 1854828.0 |
| 2024-10-14 11:00:00 | MSFT | Stock | 419.75 | 420.78 | 419.01 | 420.75 | 901815.0 |
| 2024-10-14 12:00:00 | MSFT | Stock | 420.78 | 420.78 | 419.7 | 420.1405 | 601313.0 |
| 2024-10-14 13:00:00 | MSFT | Stock | 420.145 | 420.67 | 419.79 | 419.7906 | 615022.0 |
| 2024-10-14 14:00:00 | MSFT | Stock | 419.805 | 420.7 | 419.3 | 420.42 | 802350.0 |
| 2024-10-14 15:00:00 | MSFT | Stock | 420.4 | 421.31 | 419.0 | 419.11 | 2058817.0 |
| 2024-10-14 16:00:00 | MSFT | Stock | 419.14 | 419.5 | 418.73 | 419.28 | 2981689.0 |
| 2024-10-14 17:00:00 | MSFT | Stock | 419.16 | 419.2 | 419.0 | 419.13 | 93626.0 |
| 2024-10-14 18:00:00 | MSFT | Stock | 419.13 | 419.228 | 419.0 | 419.13 | 3610.0 |
| 2024-10-14 19:00:00 | MSFT | Stock | 419.05 | 419.257 | 419.0036 | 419.2 | 6871.0 |
| 2024-10-14 04:00:00 | NVDA | Stock | 135.05 | 135.84 | 134.52 | 135.52 | 495301.0 |
| 2024-10-14 05:00:00 | NVDA | Stock | 135.53 | 135.68 | 135.4 | 135.45 | 147011.0 |
| 2024-10-14 06:00:00 | NVDA | Stock | 135.48 | 136.33 | 135.48 | 135.96 | 414117.0 |
| 2024-10-14 07:00:00 | NVDA | Stock | 135.93 | 136.38 | 135.7 | 136.32 | 1209739.0 |
| 2024-10-14 08:00:00 | NVDA | Stock | 135.85 | 136.54 | 134.13 | 136.48 | 2449096.0 |
| 2024-10-14 09:00:00 | NVDA | Stock | 136.49 | 139.3973 | 136.3 | 139.3973 | 42561478.0 |
| 2024-10-14 10:00:00 | NVDA | Stock | 139.39 | 139.6 | 138.41 | 138.425 | 41520958.0 |
| 2024-10-14 11:00:00 | NVDA | Stock | 138.4202 | 138.68 | 137.43 | 137.7101 | 25399357.0 |
| 2024-10-14 12:00:00 | NVDA | Stock | 137.715 | 138.62 | 137.62 | 138.2891 | 16342475.0 |
| 2024-10-14 13:00:00 | NVDA | Stock | 138.29 | 138.92 | 138.27 | 138.6801 | 12781803.0 |
| 2024-10-14 14:00:00 | NVDA | Stock | 138.69 | 139.05 | 138.46 | 138.535 | 14549864.0 |
| 2024-10-14 15:00:00 | NVDA | Stock | 138.53 | 138.9 | 137.86 | 138.1401 | 26731122.0 |
| 2024-10-14 16:00:00 | NVDA | Stock | 138.16 | 138.39 | 137.75 | 138.2904 | 14645527.0 |
| 2024-10-14 17:00:00 | NVDA | Stock | 138.29 | 138.3 | 138.0 | 138.0484 | 614985.0 |
| 2024-10-14 18:00:00 | NVDA | Stock | 138.05 | 138.06 | 137.8999 | 137.9201 | 426344.0 |
| 2024-10-14 19:00:00 | NVDA | Stock | 137.93 | 138.15 | 137.9004 | 138.07 | 401789.0 |
| 2024-10-14 04:00:00 | AMZN | Stock | 188.9 | 189.22 | 188.69 | 188.96 | 16602.0 |
| 2024-10-14 05:00:00 | AMZN | Stock | 189.03 | 189.38 | 188.96 | 189.38 | 7270.0 |
> showing 50 of 59,805 rows — these rows as CSV