PREVIEW / stock_1hour / 2024-04-17
file: by_date/stock_1hour/2024/2024-04-17.parquet size: 1.3 MB rows: 57,802 symbols: 1,018
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-17 04:00:00 | AAPL | Stock | 169.68 | 169.9 | 169.43 | 169.8 | 13757.0 |
| 2024-04-17 05:00:00 | AAPL | Stock | 169.66 | 169.77 | 169.56 | 169.71 | 4250.0 |
| 2024-04-17 06:00:00 | AAPL | Stock | 169.84 | 170.05 | 169.64 | 169.64 | 7496.0 |
| 2024-04-17 07:00:00 | AAPL | Stock | 169.68 | 169.95 | 169.68 | 169.7 | 18192.0 |
| 2024-04-17 08:00:00 | AAPL | Stock | 169.95 | 170.03 | 169.09 | 169.96 | 64841.0 |
| 2024-04-17 09:00:00 | AAPL | Stock | 169.9 | 170.65 | 169.31 | 169.84 | 4930957.0 |
| 2024-04-17 10:00:00 | AAPL | Stock | 169.845 | 170.63 | 169.58 | 169.8465 | 5775965.0 |
| 2024-04-17 11:00:00 | AAPL | Stock | 169.84 | 170.14 | 168.87 | 168.9299 | 4616512.0 |
| 2024-04-17 12:00:00 | AAPL | Stock | 168.93 | 169.05 | 168.07 | 168.35 | 4206828.0 |
| 2024-04-17 13:00:00 | AAPL | Stock | 168.36 | 169.0 | 168.3 | 168.92 | 3156421.0 |
| 2024-04-17 14:00:00 | AAPL | Stock | 168.94 | 169.18 | 168.2607 | 168.33 | 3150750.0 |
| 2024-04-17 15:00:00 | AAPL | Stock | 168.32 | 168.545 | 168.0 | 168.0 | 5803390.0 |
| 2024-04-17 16:00:00 | AAPL | Stock | 168.0 | 168.32 | 168.0 | 168.15 | 5354767.0 |
| 2024-04-17 17:00:00 | AAPL | Stock | 168.1301 | 168.45 | 168.0 | 168.39 | 48851.0 |
| 2024-04-17 18:00:00 | AAPL | Stock | 168.0 | 168.44 | 168.0 | 168.4 | 16808.0 |
| 2024-04-17 19:00:00 | AAPL | Stock | 168.31 | 168.44 | 168.17 | 168.35 | 19146.0 |
| 2024-04-17 04:00:00 | MSFT | Stock | 415.27 | 416.51 | 415.27 | 416.02 | 4483.0 |
| 2024-04-17 05:00:00 | MSFT | Stock | 415.82 | 416.46 | 415.82 | 416.46 | 953.0 |
| 2024-04-17 06:00:00 | MSFT | Stock | 416.65 | 417.36 | 416.65 | 416.92 | 4530.0 |
| 2024-04-17 07:00:00 | MSFT | Stock | 416.79 | 417.21 | 416.49 | 416.5 | 8937.0 |
| 2024-04-17 08:00:00 | MSFT | Stock | 417.0 | 417.5469 | 413.76 | 417.3 | 60698.0 |
| 2024-04-17 09:00:00 | MSFT | Stock | 417.25 | 418.88 | 416.2 | 416.72 | 1316854.0 |
| 2024-04-17 10:00:00 | MSFT | Stock | 416.77 | 416.94 | 414.18 | 415.0217 | 1260543.0 |
| 2024-04-17 11:00:00 | MSFT | Stock | 415.04 | 415.95 | 412.12 | 413.05 | 957937.0 |
| 2024-04-17 12:00:00 | MSFT | Stock | 413.02 | 414.77 | 410.33 | 411.19 | 1287090.0 |
| 2024-04-17 13:00:00 | MSFT | Stock | 411.23 | 413.25 | 411.105 | 413.0155 | 621306.0 |
| 2024-04-17 14:00:00 | MSFT | Stock | 413.01 | 414.5 | 411.96 | 412.32 | 788417.0 |
| 2024-04-17 15:00:00 | MSFT | Stock | 412.33 | 413.21 | 411.31 | 411.73 | 1337186.0 |
| 2024-04-17 16:00:00 | MSFT | Stock | 411.84 | 412.17 | 411.0 | 411.49 | 2014783.0 |
| 2024-04-17 17:00:00 | MSFT | Stock | 411.59 | 411.84 | 411.59 | 411.75 | 14648.0 |
| 2024-04-17 18:00:00 | MSFT | Stock | 411.84 | 411.84 | 411.5503 | 411.64 | 10250.0 |
| 2024-04-17 19:00:00 | MSFT | Stock | 411.65 | 411.7 | 411.11 | 411.42 | 12744.0 |
| 2024-04-17 04:00:00 | NVDA | Stock | 87.261 | 87.7 | 86.945 | 87.652 | 221720.0 |
| 2024-04-17 05:00:00 | NVDA | Stock | 87.65 | 87.822 | 87.51 | 87.822 | 45470.0 |
| 2024-04-17 06:00:00 | NVDA | Stock | 87.85 | 87.949 | 87.65 | 87.65 | 144180.0 |
| 2024-04-17 07:00:00 | NVDA | Stock | 87.65 | 88.435 | 87.65 | 88.095 | 974070.0 |
| 2024-04-17 08:00:00 | NVDA | Stock | 87.9 | 88.44 | 86.58 | 88.1069 | 2219560.0 |
| 2024-04-17 09:00:00 | NVDA | Stock | 88.1 | 88.775 | 86.758 | 87.207 | 49618910.0 |
| 2024-04-17 10:00:00 | NVDA | Stock | 87.2167 | 87.255 | 85.555 | 85.8164 | 60907860.0 |
| 2024-04-17 11:00:00 | NVDA | Stock | 85.8161 | 86.526 | 85.577 | 85.9145 | 39083680.0 |
| 2024-04-17 12:00:00 | NVDA | Stock | 85.9175 | 85.93 | 84.335 | 84.76 | 51502490.0 |
| 2024-04-17 13:00:00 | NVDA | Stock | 84.7631 | 85.48 | 84.639 | 85.3882 | 40906220.0 |
| 2024-04-17 14:00:00 | NVDA | Stock | 85.38 | 85.784 | 84.78 | 84.8943 | 36747310.0 |
| 2024-04-17 15:00:00 | NVDA | Stock | 84.877 | 84.941 | 83.95 | 84.024 | 61241320.0 |
| 2024-04-17 16:00:00 | NVDA | Stock | 84.035 | 87.5505 | 83.872 | 84.33 | 14772090.0 |
| 2024-04-17 17:00:00 | NVDA | Stock | 84.326 | 84.67 | 84.035 | 84.44 | 769570.0 |
| 2024-04-17 18:00:00 | NVDA | Stock | 84.445 | 84.6258 | 84.035 | 84.525 | 378160.0 |
| 2024-04-17 19:00:00 | NVDA | Stock | 84.525 | 84.73 | 84.506 | 84.678 | 782960.0 |
| 2024-04-17 04:00:00 | AMZN | Stock | 183.55 | 184.39 | 183.53 | 184.39 | 3215.0 |
| 2024-04-17 05:00:00 | AMZN | Stock | 184.3 | 184.55 | 184.25 | 184.55 | 9242.0 |
> showing 50 of 57,802 rows — these rows as CSV