PREVIEW / stock_1hour / 2024-09-18
file: by_date/stock_1hour/2024/2024-09-18.parquet size: 1.3 MB rows: 58,339 symbols: 783
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-09-18 04:00:00 | AAPL | Stock | 216.2 | 216.2 | 215.5 | 216.0 | 22519.0 |
| 2024-09-18 05:00:00 | AAPL | Stock | 216.12 | 216.2 | 215.75 | 215.88 | 6798.0 |
| 2024-09-18 06:00:00 | AAPL | Stock | 215.97 | 216.8 | 215.94 | 216.72 | 57082.0 |
| 2024-09-18 07:00:00 | AAPL | Stock | 216.74 | 217.1 | 216.3 | 216.49 | 50170.0 |
| 2024-09-18 08:00:00 | AAPL | Stock | 217.0 | 217.13 | 216.0 | 217.13 | 105136.0 |
| 2024-09-18 09:00:00 | AAPL | Stock | 217.13 | 219.55 | 216.99 | 219.205 | 5639167.0 |
| 2024-09-18 10:00:00 | AAPL | Stock | 219.21 | 221.61 | 218.98 | 220.93 | 7151593.0 |
| 2024-09-18 11:00:00 | AAPL | Stock | 220.935 | 221.3999 | 219.52 | 219.6115 | 4472659.0 |
| 2024-09-18 12:00:00 | AAPL | Stock | 219.61 | 221.36 | 219.55 | 221.285 | 3228552.0 |
| 2024-09-18 13:00:00 | AAPL | Stock | 221.285 | 221.53 | 220.34 | 220.6816 | 2823464.0 |
| 2024-09-18 14:00:00 | AAPL | Stock | 220.63 | 222.71 | 219.84 | 220.0501 | 6321909.0 |
| 2024-09-18 15:00:00 | AAPL | Stock | 220.048 | 221.82 | 218.93 | 220.69 | 7457628.0 |
| 2024-09-18 16:00:00 | AAPL | Stock | 220.69 | 221.89 | 220.2 | 221.4 | 7701554.0 |
| 2024-09-18 17:00:00 | AAPL | Stock | 221.3225 | 221.6685 | 221.13 | 221.23 | 33495.0 |
| 2024-09-18 18:00:00 | AAPL | Stock | 221.28 | 221.7473 | 221.28 | 221.6 | 20063.0 |
| 2024-09-18 19:00:00 | AAPL | Stock | 221.58 | 222.25 | 221.47 | 222.25 | 55963.0 |
| 2024-09-18 04:00:00 | MSFT | Stock | 436.87 | 436.87 | 436.0 | 436.0 | 1873.0 |
| 2024-09-18 05:00:00 | MSFT | Stock | 436.26 | 436.8 | 436.26 | 436.8 | 1213.0 |
| 2024-09-18 06:00:00 | MSFT | Stock | 436.75 | 436.75 | 434.52 | 436.57 | 5365.0 |
| 2024-09-18 07:00:00 | MSFT | Stock | 436.6 | 437.22 | 436.5 | 436.56 | 7035.0 |
| 2024-09-18 08:00:00 | MSFT | Stock | 436.8 | 437.278 | 435.72 | 436.4 | 26026.0 |
| 2024-09-18 09:00:00 | MSFT | Stock | 436.5012 | 436.8 | 431.5717 | 432.47 | 1176523.0 |
| 2024-09-18 10:00:00 | MSFT | Stock | 432.4719 | 433.33 | 431.38 | 431.94 | 964158.0 |
| 2024-09-18 11:00:00 | MSFT | Stock | 431.935 | 432.28 | 430.45 | 430.925 | 715573.0 |
| 2024-09-18 12:00:00 | MSFT | Stock | 430.91 | 432.84 | 430.6616 | 432.72 | 659545.0 |
| 2024-09-18 13:00:00 | MSFT | Stock | 432.73 | 433.15 | 431.84 | 432.17 | 534403.0 |
| 2024-09-18 14:00:00 | MSFT | Stock | 432.08 | 436.03 | 431.2 | 433.18 | 1948965.0 |
| 2024-09-18 15:00:00 | MSFT | Stock | 433.1 | 435.01 | 430.41 | 430.76 | 1930666.0 |
| 2024-09-18 16:00:00 | MSFT | Stock | 430.84 | 432.8003 | 430.75 | 431.75 | 3928373.0 |
| 2024-09-18 17:00:00 | MSFT | Stock | 431.75 | 431.98 | 431.4022 | 431.93 | 5341.0 |
| 2024-09-18 18:00:00 | MSFT | Stock | 432.1 | 432.95 | 431.8908 | 432.72 | 5768.0 |
| 2024-09-18 19:00:00 | MSFT | Stock | 432.8975 | 435.0 | 431.42 | 435.0 | 14851.0 |
| 2024-09-18 04:00:00 | NVDA | Stock | 115.84 | 115.93 | 114.84 | 115.14 | 405326.0 |
| 2024-09-18 05:00:00 | NVDA | Stock | 115.15 | 115.37 | 114.95 | 115.35 | 113186.0 |
| 2024-09-18 06:00:00 | NVDA | Stock | 115.36 | 115.97 | 115.15 | 115.87 | 275462.0 |
| 2024-09-18 07:00:00 | NVDA | Stock | 115.88 | 115.96 | 115.55 | 115.64 | 491843.0 |
| 2024-09-18 08:00:00 | NVDA | Stock | 115.85 | 115.99 | 114.8635 | 115.71 | 1698253.0 |
| 2024-09-18 09:00:00 | NVDA | Stock | 115.73 | 116.35 | 114.61 | 115.934 | 25861803.0 |
| 2024-09-18 10:00:00 | NVDA | Stock | 115.94 | 115.95 | 114.7 | 115.17 | 27036510.0 |
| 2024-09-18 11:00:00 | NVDA | Stock | 115.175 | 115.39 | 113.68 | 113.904 | 24889871.0 |
| 2024-09-18 12:00:00 | NVDA | Stock | 113.9 | 115.33 | 113.78 | 115.256 | 19343404.0 |
| 2024-09-18 13:00:00 | NVDA | Stock | 115.255 | 115.35 | 114.62 | 115.03 | 17738228.0 |
| 2024-09-18 14:00:00 | NVDA | Stock | 115.02 | 117.7 | 114.62 | 115.9 | 63878082.0 |
| 2024-09-18 15:00:00 | NVDA | Stock | 115.88 | 115.91 | 113.22 | 113.25 | 61234866.0 |
| 2024-09-18 16:00:00 | NVDA | Stock | 113.37 | 115.1216 | 112.778 | 113.35 | 24341270.0 |
| 2024-09-18 17:00:00 | NVDA | Stock | 113.31 | 113.4699 | 113.27 | 113.39 | 469393.0 |
| 2024-09-18 18:00:00 | NVDA | Stock | 113.41 | 113.99 | 113.4 | 113.8995 | 956707.0 |
| 2024-09-18 19:00:00 | NVDA | Stock | 113.9 | 114.57 | 113.82 | 114.551 | 1257049.0 |
| 2024-09-18 04:00:00 | AMZN | Stock | 186.91 | 187.01 | 186.55 | 186.75 | 4846.0 |
| 2024-09-18 05:00:00 | AMZN | Stock | 186.73 | 187.01 | 186.71 | 187.01 | 2874.0 |
> showing 50 of 58,339 rows — these rows as CSV