PREVIEW / stock_1hour / 2024-04-03
file: by_date/stock_1hour/2024/2024-04-03.parquet size: 1.3 MB rows: 59,500 symbols: 1,038
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-04-03 04:00:00 | AAPL | Stock | 169.3 | 169.3 | 168.81 | 168.86 | 14530.0 |
| 2024-04-03 05:00:00 | AAPL | Stock | 168.86 | 168.9 | 168.54 | 168.6 | 4113.0 |
| 2024-04-03 06:00:00 | AAPL | Stock | 168.6 | 168.75 | 168.5 | 168.68 | 6337.0 |
| 2024-04-03 07:00:00 | AAPL | Stock | 168.72 | 169.1 | 168.72 | 169.06 | 21131.0 |
| 2024-04-03 08:00:00 | AAPL | Stock | 168.74 | 169.35 | 168.68 | 168.97 | 135121.0 |
| 2024-04-03 09:00:00 | AAPL | Stock | 168.952 | 169.32 | 168.42 | 169.08 | 3817553.0 |
| 2024-04-03 10:00:00 | AAPL | Stock | 169.08 | 170.65 | 169.08 | 170.52 | 5880985.0 |
| 2024-04-03 11:00:00 | AAPL | Stock | 170.5101 | 170.68 | 170.35 | 170.4 | 3206658.0 |
| 2024-04-03 12:00:00 | AAPL | Stock | 170.405 | 170.45 | 169.74 | 170.195 | 3300358.0 |
| 2024-04-03 13:00:00 | AAPL | Stock | 170.2 | 170.39 | 170.15 | 170.17 | 2295841.0 |
| 2024-04-03 14:00:00 | AAPL | Stock | 170.17 | 170.38 | 170.06 | 170.26 | 2108927.0 |
| 2024-04-03 15:00:00 | AAPL | Stock | 170.2734 | 170.61 | 169.28 | 169.66 | 9725244.0 |
| 2024-04-03 16:00:00 | AAPL | Stock | 169.65 | 169.77 | 169.25 | 169.72 | 6218582.0 |
| 2024-04-03 17:00:00 | AAPL | Stock | 169.73 | 169.86 | 169.65 | 169.76 | 17507.0 |
| 2024-04-03 18:00:00 | AAPL | Stock | 169.75 | 169.75 | 169.52 | 169.7 | 11948.0 |
| 2024-04-03 19:00:00 | AAPL | Stock | 169.65 | 170.64 | 169.62 | 170.14 | 54778.0 |
| 2024-04-03 04:00:00 | MSFT | Stock | 420.5 | 421.21 | 420.37 | 421.18 | 2528.0 |
| 2024-04-03 05:00:00 | MSFT | Stock | 421.0 | 421.7 | 421.0 | 421.59 | 2091.0 |
| 2024-04-03 06:00:00 | MSFT | Stock | 421.4 | 421.4 | 421.28 | 421.28 | 418.0 |
| 2024-04-03 07:00:00 | MSFT | Stock | 421.42 | 421.62 | 421.12 | 421.39 | 2877.0 |
| 2024-04-03 08:00:00 | MSFT | Stock | 421.4 | 421.82 | 420.0 | 420.64 | 8230.0 |
| 2024-04-03 09:00:00 | MSFT | Stock | 421.0 | 421.07 | 419.085 | 419.92 | 1419968.0 |
| 2024-04-03 10:00:00 | MSFT | Stock | 419.96 | 423.07 | 419.88 | 422.9754 | 2135244.0 |
| 2024-04-03 11:00:00 | MSFT | Stock | 423.0 | 423.26 | 422.31 | 422.5 | 807952.0 |
| 2024-04-03 12:00:00 | MSFT | Stock | 422.4601 | 422.85 | 421.35 | 422.2681 | 793827.0 |
| 2024-04-03 13:00:00 | MSFT | Stock | 422.26 | 422.65 | 421.87 | 422.51 | 483221.0 |
| 2024-04-03 14:00:00 | MSFT | Stock | 422.49 | 422.99 | 421.885 | 422.01 | 670131.0 |
| 2024-04-03 15:00:00 | MSFT | Stock | 421.98 | 422.1 | 419.8 | 420.49 | 2213325.0 |
| 2024-04-03 16:00:00 | MSFT | Stock | 420.45 | 422.11 | 420.45 | 421.36 | 2517337.0 |
| 2024-04-03 17:00:00 | MSFT | Stock | 421.16 | 421.58 | 421.15 | 421.47 | 2536.0 |
| 2024-04-03 18:00:00 | MSFT | Stock | 421.41 | 421.5 | 421.13 | 421.4 | 2792.0 |
| 2024-04-03 19:00:00 | MSFT | Stock | 421.5 | 423.0 | 421.5 | 422.54 | 12203.0 |
| 2024-04-03 04:00:00 | NVDA | Stock | 88.568 | 88.855 | 88.5 | 88.848 | 81750.0 |
| 2024-04-03 05:00:00 | NVDA | Stock | 88.812 | 88.85 | 88.406 | 88.406 | 47670.0 |
| 2024-04-03 06:00:00 | NVDA | Stock | 88.414 | 88.56 | 88.4 | 88.56 | 31830.0 |
| 2024-04-03 07:00:00 | NVDA | Stock | 88.519 | 89.25 | 88.51 | 89.2 | 579020.0 |
| 2024-04-03 08:00:00 | NVDA | Stock | 88.695 | 89.24 | 88.413 | 88.595 | 1877230.0 |
| 2024-04-03 09:00:00 | NVDA | Stock | 88.555 | 89.354 | 88.3076 | 88.889 | 40137130.0 |
| 2024-04-03 10:00:00 | NVDA | Stock | 88.917 | 90.374 | 88.913 | 90.096 | 68140040.0 |
| 2024-04-03 11:00:00 | NVDA | Stock | 90.083 | 90.346 | 89.508 | 89.553 | 29916300.0 |
| 2024-04-03 12:00:00 | NVDA | Stock | 89.569 | 89.984 | 89.139 | 89.774 | 40162710.0 |
| 2024-04-03 13:00:00 | NVDA | Stock | 89.797 | 90.125 | 89.6751 | 89.89 | 23715550.0 |
| 2024-04-03 14:00:00 | NVDA | Stock | 89.896 | 90.075 | 89.4585 | 89.5478 | 22268100.0 |
| 2024-04-03 15:00:00 | NVDA | Stock | 89.561 | 89.634 | 88.811 | 88.966 | 38582410.0 |
| 2024-04-03 16:00:00 | NVDA | Stock | 88.964 | 89.086 | 88.964 | 89.0 | 10915060.0 |
| 2024-04-03 17:00:00 | NVDA | Stock | 88.998 | 89.035 | 88.9 | 88.969 | 308910.0 |
| 2024-04-03 18:00:00 | NVDA | Stock | 88.9979 | 89.13 | 88.961 | 89.1299 | 196160.0 |
| 2024-04-03 19:00:00 | NVDA | Stock | 89.13 | 89.6 | 89.1 | 89.486 | 726380.0 |
| 2024-04-03 04:00:00 | AMZN | Stock | 180.09 | 180.69 | 180.09 | 180.51 | 4052.0 |
| 2024-04-03 05:00:00 | AMZN | Stock | 180.55 | 180.67 | 180.53 | 180.55 | 1380.0 |
> showing 50 of 59,500 rows — these rows as CSV