PREVIEW / stock_1hour / 2024-02-05
file: by_date/stock_1hour/2024/2024-02-05.parquet size: 1.3 MB rows: 59,346 symbols: 1,164
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-02-05 04:00:00 | AAPL | Stock | 186.0 | 186.5 | 185.24 | 185.42 | 62756.0 |
| 2024-02-05 05:00:00 | AAPL | Stock | 185.44 | 186.38 | 185.36 | 186.29 | 20001.0 |
| 2024-02-05 06:00:00 | AAPL | Stock | 186.2 | 186.59 | 185.79 | 186.3 | 37486.0 |
| 2024-02-05 07:00:00 | AAPL | Stock | 186.19 | 187.4 | 186.09 | 187.38 | 122279.0 |
| 2024-02-05 08:00:00 | AAPL | Stock | 186.15 | 187.55 | 185.25 | 186.84 | 283550.0 |
| 2024-02-05 09:00:00 | AAPL | Stock | 186.86 | 188.4 | 185.84 | 186.58 | 8030420.0 |
| 2024-02-05 10:00:00 | AAPL | Stock | 186.56 | 188.36 | 186.11 | 186.895 | 9523707.0 |
| 2024-02-05 11:00:00 | AAPL | Stock | 186.89 | 188.105 | 186.78 | 187.985 | 5851556.0 |
| 2024-02-05 12:00:00 | AAPL | Stock | 187.98 | 189.25 | 187.89 | 189.065 | 6582653.0 |
| 2024-02-05 13:00:00 | AAPL | Stock | 189.07 | 189.075 | 188.53 | 188.72 | 4224918.0 |
| 2024-02-05 14:00:00 | AAPL | Stock | 188.715 | 188.9 | 188.37 | 188.5182 | 4226849.0 |
| 2024-02-05 15:00:00 | AAPL | Stock | 188.52 | 188.63 | 187.64 | 187.66 | 6876878.0 |
| 2024-02-05 16:00:00 | AAPL | Stock | 187.66 | 188.06 | 187.45 | 187.71 | 6359621.0 |
| 2024-02-05 17:00:00 | AAPL | Stock | 187.71 | 187.7798 | 187.61 | 187.65 | 80888.0 |
| 2024-02-05 18:00:00 | AAPL | Stock | 187.71 | 187.85 | 187.62 | 187.62 | 34161.0 |
| 2024-02-05 19:00:00 | AAPL | Stock | 187.62 | 187.93 | 187.61 | 187.8 | 40835.0 |
| 2024-02-05 04:00:00 | MSFT | Stock | 411.0 | 412.2 | 411.0 | 411.71 | 4247.0 |
| 2024-02-05 05:00:00 | MSFT | Stock | 411.67 | 411.92 | 411.6 | 411.7 | 3441.0 |
| 2024-02-05 06:00:00 | MSFT | Stock | 411.79 | 412.0 | 411.71 | 412.0 | 2026.0 |
| 2024-02-05 07:00:00 | MSFT | Stock | 411.92 | 412.25 | 411.55 | 411.9 | 23264.0 |
| 2024-02-05 08:00:00 | MSFT | Stock | 411.9793 | 412.3 | 410.66 | 411.1 | 68382.0 |
| 2024-02-05 09:00:00 | MSFT | Stock | 411.1 | 411.44 | 407.32 | 408.325 | 2585153.0 |
| 2024-02-05 10:00:00 | MSFT | Stock | 408.325 | 408.49 | 404.26 | 404.5878 | 2513383.0 |
| 2024-02-05 11:00:00 | MSFT | Stock | 404.585 | 406.49 | 403.99 | 406.28 | 1795428.0 |
| 2024-02-05 12:00:00 | MSFT | Stock | 406.32 | 406.8 | 405.57 | 405.82 | 1167591.0 |
| 2024-02-05 13:00:00 | MSFT | Stock | 405.83 | 406.09 | 404.5 | 405.21 | 1066942.0 |
| 2024-02-05 14:00:00 | MSFT | Stock | 405.22 | 406.06 | 404.81 | 405.72 | 1030244.0 |
| 2024-02-05 15:00:00 | MSFT | Stock | 405.72 | 406.24 | 404.45 | 405.58 | 2324461.0 |
| 2024-02-05 16:00:00 | MSFT | Stock | 405.58 | 405.89 | 405.25 | 405.5702 | 5309250.0 |
| 2024-02-05 17:00:00 | MSFT | Stock | 405.61 | 406.6 | 405.61 | 406.6 | 22293.0 |
| 2024-02-05 18:00:00 | MSFT | Stock | 406.4 | 406.75 | 406.0 | 406.2 | 17346.0 |
| 2024-02-05 19:00:00 | MSFT | Stock | 406.2501 | 406.4 | 406.13 | 406.36 | 10801.0 |
| 2024-02-05 04:00:00 | NVDA | Stock | 66.666 | 67.387 | 66.416 | 67.31 | 770450.0 |
| 2024-02-05 05:00:00 | NVDA | Stock | 67.338 | 67.949 | 67.338 | 67.8 | 920710.0 |
| 2024-02-05 06:00:00 | NVDA | Stock | 67.78 | 67.95 | 67.561 | 67.594 | 518460.0 |
| 2024-02-05 07:00:00 | NVDA | Stock | 67.59 | 68.695 | 67.5 | 68.44 | 3806160.0 |
| 2024-02-05 08:00:00 | NVDA | Stock | 67.65 | 68.696 | 66.557 | 68.2 | 6369030.0 |
| 2024-02-05 09:00:00 | NVDA | Stock | 68.18 | 69.497 | 67.7 | 69.301 | 99662940.0 |
| 2024-02-05 10:00:00 | NVDA | Stock | 69.282 | 69.35 | 67.205 | 68.0 | 110062870.0 |
| 2024-02-05 11:00:00 | NVDA | Stock | 67.998 | 68.79 | 67.834 | 68.775 | 53963670.0 |
| 2024-02-05 12:00:00 | NVDA | Stock | 68.775 | 69.18 | 68.5 | 68.7285 | 52958710.0 |
| 2024-02-05 13:00:00 | NVDA | Stock | 68.732 | 68.998 | 68.51 | 68.854 | 39096890.0 |
| 2024-02-05 14:00:00 | NVDA | Stock | 68.8563 | 69.35 | 68.669 | 69.089 | 42215090.0 |
| 2024-02-05 15:00:00 | NVDA | Stock | 69.0992 | 69.449 | 68.1 | 69.318 | 73890000.0 |
| 2024-02-05 16:00:00 | NVDA | Stock | 69.332 | 69.74 | 69.17 | 69.651 | 23277200.0 |
| 2024-02-05 17:00:00 | NVDA | Stock | 69.658 | 69.78 | 69.511 | 69.696 | 1227050.0 |
| 2024-02-05 18:00:00 | NVDA | Stock | 69.7 | 69.9938 | 69.671 | 69.876 | 1846910.0 |
| 2024-02-05 19:00:00 | NVDA | Stock | 69.871 | 70.24 | 69.85 | 70.2 | 1851650.0 |
| 2024-02-05 04:00:00 | AMZN | Stock | 170.9 | 171.53 | 170.26 | 170.7 | 31754.0 |
| 2024-02-05 05:00:00 | AMZN | Stock | 170.63 | 171.15 | 170.61 | 171.09 | 26330.0 |
> showing 50 of 59,346 rows — these rows as CSV