PREVIEW / stock_1hour / 2024-10-17
file: by_date/stock_1hour/2024/2024-10-17.parquet size: 1.4 MB rows: 59,983 symbols: 749
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-10-17 04:00:00 | AAPL | Stock | 232.0 | 233.9 | 232.0 | 232.9 | 45066.0 |
| 2024-10-17 05:00:00 | AAPL | Stock | 232.86 | 233.78 | 232.81 | 233.65 | 89349.0 |
| 2024-10-17 06:00:00 | AAPL | Stock | 233.49 | 233.71 | 233.18 | 233.65 | 49627.0 |
| 2024-10-17 07:00:00 | AAPL | Stock | 233.53 | 233.79 | 233.17 | 233.47 | 58194.0 |
| 2024-10-17 08:00:00 | AAPL | Stock | 233.53 | 233.81 | 231.201 | 233.76 | 128350.0 |
| 2024-10-17 09:00:00 | AAPL | Stock | 233.792 | 234.19 | 230.52 | 231.72 | 3959182.0 |
| 2024-10-17 10:00:00 | AAPL | Stock | 231.76 | 232.58 | 231.16 | 231.3599 | 2979148.0 |
| 2024-10-17 11:00:00 | AAPL | Stock | 231.36 | 232.56 | 231.23 | 232.5462 | 1777547.0 |
| 2024-10-17 12:00:00 | AAPL | Stock | 232.54 | 232.81 | 232.02 | 232.1761 | 1227918.0 |
| 2024-10-17 13:00:00 | AAPL | Stock | 232.18 | 232.58 | 232.07 | 232.43 | 1368163.0 |
| 2024-10-17 14:00:00 | AAPL | Stock | 232.43 | 232.57 | 231.27 | 232.1 | 1710394.0 |
| 2024-10-17 15:00:00 | AAPL | Stock | 232.1 | 232.33 | 231.63 | 232.26 | 2902215.0 |
| 2024-10-17 16:00:00 | AAPL | Stock | 232.18 | 232.37 | 232.03 | 232.15 | 5111797.0 |
| 2024-10-17 17:00:00 | AAPL | Stock | 232.1 | 232.11 | 232.04 | 232.1 | 2756.0 |
| 2024-10-17 18:00:00 | AAPL | Stock | 232.11 | 232.28 | 231.95 | 232.28 | 8362.0 |
| 2024-10-17 19:00:00 | AAPL | Stock | 232.229 | 232.32 | 232.1598 | 232.16 | 3326.0 |
| 2024-10-17 04:00:00 | MSFT | Stock | 417.99 | 418.81 | 417.11 | 418.61 | 17256.0 |
| 2024-10-17 05:00:00 | MSFT | Stock | 418.59 | 419.19 | 418.14 | 419.19 | 5184.0 |
| 2024-10-17 06:00:00 | MSFT | Stock | 419.19 | 419.24 | 418.32 | 419.24 | 7507.0 |
| 2024-10-17 07:00:00 | MSFT | Stock | 418.9 | 419.0 | 418.1 | 418.1 | 10588.0 |
| 2024-10-17 08:00:00 | MSFT | Stock | 418.26 | 419.25 | 415.44 | 419.21 | 41255.0 |
| 2024-10-17 09:00:00 | MSFT | Stock | 419.34 | 422.99 | 417.24 | 417.385 | 1470499.0 |
| 2024-10-17 10:00:00 | MSFT | Stock | 417.44 | 418.36 | 415.9 | 416.22 | 866262.0 |
| 2024-10-17 11:00:00 | MSFT | Stock | 416.28 | 418.6 | 415.59 | 418.56 | 599169.0 |
| 2024-10-17 12:00:00 | MSFT | Stock | 418.525 | 418.885 | 417.26 | 417.7548 | 558949.0 |
| 2024-10-17 13:00:00 | MSFT | Stock | 417.8 | 418.3 | 417.34 | 417.722 | 411514.0 |
| 2024-10-17 14:00:00 | MSFT | Stock | 417.73 | 417.81 | 415.59 | 417.25 | 561452.0 |
| 2024-10-17 15:00:00 | MSFT | Stock | 417.3 | 417.67 | 416.36 | 416.72 | 1052344.0 |
| 2024-10-17 16:00:00 | MSFT | Stock | 416.72 | 417.53 | 416.16 | 416.5906 | 3326473.0 |
| 2024-10-17 17:00:00 | MSFT | Stock | 416.6 | 416.99 | 416.6 | 416.76 | 4217.0 |
| 2024-10-17 18:00:00 | MSFT | Stock | 416.86 | 417.21 | 416.59 | 417.2 | 6406.0 |
| 2024-10-17 19:00:00 | MSFT | Stock | 417.25 | 417.2925 | 416.8005 | 417.2925 | 4421.0 |
| 2024-10-17 04:00:00 | NVDA | Stock | 138.2 | 139.4 | 137.05 | 139.18 | 1174466.0 |
| 2024-10-17 05:00:00 | NVDA | Stock | 139.18 | 139.32 | 138.6 | 138.9 | 561585.0 |
| 2024-10-17 06:00:00 | NVDA | Stock | 138.9 | 140.3 | 138.9 | 140.08 | 1278582.0 |
| 2024-10-17 07:00:00 | NVDA | Stock | 140.07 | 140.09 | 139.56 | 139.95 | 2069341.0 |
| 2024-10-17 08:00:00 | NVDA | Stock | 139.94 | 140.065 | 135.41 | 139.94 | 5397335.0 |
| 2024-10-17 09:00:00 | NVDA | Stock | 139.94 | 140.89 | 137.65 | 138.865 | 65361243.0 |
| 2024-10-17 10:00:00 | NVDA | Stock | 138.88 | 139.75 | 137.3648 | 139.12 | 53924635.0 |
| 2024-10-17 11:00:00 | NVDA | Stock | 139.13 | 140.13 | 138.6 | 140.104 | 28890568.0 |
| 2024-10-17 12:00:00 | NVDA | Stock | 140.11 | 140.252 | 138.8934 | 139.0 | 24130441.0 |
| 2024-10-17 13:00:00 | NVDA | Stock | 139.0 | 139.92 | 138.9 | 139.51 | 14726630.0 |
| 2024-10-17 14:00:00 | NVDA | Stock | 139.51 | 139.58 | 138.11 | 138.9199 | 24152572.0 |
| 2024-10-17 15:00:00 | NVDA | Stock | 138.914 | 138.98 | 136.87 | 136.92 | 31683215.0 |
| 2024-10-17 16:00:00 | NVDA | Stock | 136.92 | 137.68 | 136.34 | 137.26 | 13990343.0 |
| 2024-10-17 17:00:00 | NVDA | Stock | 137.288 | 137.49 | 137.22 | 137.39 | 519359.0 |
| 2024-10-17 18:00:00 | NVDA | Stock | 137.4 | 137.7 | 137.34 | 137.54 | 419476.0 |
| 2024-10-17 19:00:00 | NVDA | Stock | 137.5285 | 137.5496 | 137.28 | 137.39 | 432975.0 |
| 2024-10-17 04:00:00 | AMZN | Stock | 187.16 | 187.88 | 187.15 | 187.88 | 13138.0 |
| 2024-10-17 05:00:00 | AMZN | Stock | 187.9 | 188.15 | 187.74 | 187.97 | 15473.0 |
> showing 50 of 59,983 rows — these rows as CSV