PREVIEW / stock_1hour / 2024-01-25
file: by_date/stock_1hour/2024/2024-01-25.parquet size: 1.3 MB rows: 58,636 symbols: 1,160
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-01-25 04:00:00 | AAPL | Stock | 194.0 | 194.0 | 193.42 | 193.66 | 14068.0 |
| 2024-01-25 05:00:00 | AAPL | Stock | 193.57 | 193.71 | 193.5 | 193.64 | 6626.0 |
| 2024-01-25 06:00:00 | AAPL | Stock | 193.6 | 194.0 | 193.53 | 193.99 | 10125.0 |
| 2024-01-25 07:00:00 | AAPL | Stock | 194.0 | 194.5 | 193.89 | 193.94 | 33660.0 |
| 2024-01-25 08:00:00 | AAPL | Stock | 194.23 | 195.09 | 193.6095 | 194.9 | 223882.0 |
| 2024-01-25 09:00:00 | AAPL | Stock | 194.9326 | 195.64 | 194.45 | 194.8101 | 4575168.0 |
| 2024-01-25 10:00:00 | AAPL | Stock | 194.82 | 195.63 | 194.63 | 195.4702 | 5488070.0 |
| 2024-01-25 11:00:00 | AAPL | Stock | 195.48 | 196.2675 | 195.16 | 195.958 | 4942922.0 |
| 2024-01-25 12:00:00 | AAPL | Stock | 195.96 | 196.056 | 195.53 | 195.805 | 3812891.0 |
| 2024-01-25 13:00:00 | AAPL | Stock | 195.805 | 195.9574 | 194.05 | 194.125 | 7550971.0 |
| 2024-01-25 14:00:00 | AAPL | Stock | 194.12 | 194.12 | 193.1125 | 193.56 | 4636195.0 |
| 2024-01-25 15:00:00 | AAPL | Stock | 193.55 | 194.31 | 193.45 | 194.19 | 6056818.0 |
| 2024-01-25 16:00:00 | AAPL | Stock | 194.05 | 194.55 | 194.05 | 194.21 | 6148711.0 |
| 2024-01-25 17:00:00 | AAPL | Stock | 194.2 | 194.38 | 193.88 | 194.15 | 111776.0 |
| 2024-01-25 18:00:00 | AAPL | Stock | 193.9 | 194.17 | 193.75 | 194.0003 | 35644.0 |
| 2024-01-25 19:00:00 | AAPL | Stock | 194.08 | 194.17 | 193.82 | 194.17 | 29486.0 |
| 2024-01-25 04:00:00 | MSFT | Stock | 404.0 | 404.1 | 402.75 | 402.76 | 8158.0 |
| 2024-01-25 05:00:00 | MSFT | Stock | 402.59 | 402.75 | 401.6 | 401.67 | 7960.0 |
| 2024-01-25 06:00:00 | MSFT | Stock | 401.71 | 404.2 | 401.71 | 404.08 | 2597.0 |
| 2024-01-25 07:00:00 | MSFT | Stock | 404.1 | 404.67 | 403.79 | 404.14 | 18181.0 |
| 2024-01-25 08:00:00 | MSFT | Stock | 404.1 | 405.55 | 403.51 | 405.5 | 87070.0 |
| 2024-01-25 09:00:00 | MSFT | Stock | 405.53 | 406.0 | 403.365 | 404.3 | 2004642.0 |
| 2024-01-25 10:00:00 | MSFT | Stock | 404.33 | 407.01 | 403.43 | 406.94 | 2088547.0 |
| 2024-01-25 11:00:00 | MSFT | Stock | 406.92 | 406.9493 | 405.75 | 406.185 | 1291671.0 |
| 2024-01-25 12:00:00 | MSFT | Stock | 406.1884 | 406.45 | 404.89 | 405.47 | 1538152.0 |
| 2024-01-25 13:00:00 | MSFT | Stock | 405.47 | 406.18 | 403.5 | 403.72 | 1302784.0 |
| 2024-01-25 14:00:00 | MSFT | Stock | 403.68 | 403.84 | 402.5294 | 403.7914 | 1282975.0 |
| 2024-01-25 15:00:00 | MSFT | Stock | 403.78 | 405.09 | 403.34 | 405.09 | 2242179.0 |
| 2024-01-25 16:00:00 | MSFT | Stock | 404.87 | 405.1699 | 403.85 | 404.11 | 3250384.0 |
| 2024-01-25 17:00:00 | MSFT | Stock | 404.15 | 404.16 | 403.4 | 403.5 | 7410.0 |
| 2024-01-25 18:00:00 | MSFT | Stock | 403.28 | 403.83 | 402.96 | 403.25 | 29392.0 |
| 2024-01-25 19:00:00 | MSFT | Stock | 403.25 | 403.3 | 402.0 | 402.99 | 28799.0 |
| 2024-01-25 04:00:00 | NVDA | Stock | 61.889 | 62.218 | 61.81 | 62.15 | 303460.0 |
| 2024-01-25 05:00:00 | NVDA | Stock | 62.114 | 62.126 | 62.02 | 62.112 | 152310.0 |
| 2024-01-25 06:00:00 | NVDA | Stock | 62.13 | 62.23 | 62.098 | 62.2 | 101510.0 |
| 2024-01-25 07:00:00 | NVDA | Stock | 62.172 | 62.433 | 62.036 | 62.236 | 871630.0 |
| 2024-01-25 08:00:00 | NVDA | Stock | 62.175 | 62.52 | 61.8 | 62.405 | 3347470.0 |
| 2024-01-25 09:00:00 | NVDA | Stock | 62.405 | 62.639 | 61.854 | 61.9497 | 61390360.0 |
| 2024-01-25 10:00:00 | NVDA | Stock | 61.929 | 62.719 | 61.8923 | 62.507 | 62484920.0 |
| 2024-01-25 11:00:00 | NVDA | Stock | 62.512 | 62.56 | 62.225 | 62.313 | 33896710.0 |
| 2024-01-25 12:00:00 | NVDA | Stock | 62.313 | 62.42 | 61.576 | 61.842 | 51822980.0 |
| 2024-01-25 13:00:00 | NVDA | Stock | 61.8375 | 61.915 | 61.236 | 61.2495 | 43512000.0 |
| 2024-01-25 14:00:00 | NVDA | Stock | 61.24 | 61.778 | 60.85 | 61.772 | 50217100.0 |
| 2024-01-25 15:00:00 | NVDA | Stock | 61.77 | 61.823 | 61.48 | 61.644 | 38689810.0 |
| 2024-01-25 16:00:00 | NVDA | Stock | 61.765 | 61.765 | 61.1181 | 61.38 | 21873730.0 |
| 2024-01-25 17:00:00 | NVDA | Stock | 61.38 | 61.617 | 60.955 | 61.0071 | 1390820.0 |
| 2024-01-25 18:00:00 | NVDA | Stock | 60.99 | 61.032 | 60.124 | 60.634 | 3591680.0 |
| 2024-01-25 19:00:00 | NVDA | Stock | 60.633 | 60.79 | 60.502 | 60.646 | 931940.0 |
| 2024-01-25 04:00:00 | AMZN | Stock | 157.3 | 157.75 | 157.3 | 157.75 | 6223.0 |
| 2024-01-25 05:00:00 | AMZN | Stock | 157.6 | 157.65 | 156.87 | 156.99 | 27281.0 |
> showing 50 of 58,636 rows — these rows as CSV