PREVIEW / stock_1hour / 2024-10-18
file: by_date/stock_1hour/2024/2024-10-18.parquet size: 1.3 MB rows: 59,117 symbols: 736
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-18 04:00:00 | AAPL | Stock | 233.3 | 234.7 | 233.3 | 234.41 | 67894.0 |
| 2024-10-18 05:00:00 | AAPL | Stock | 234.5 | 235.2 | 234.47 | 235.02 | 50090.0 |
| 2024-10-18 06:00:00 | AAPL | Stock | 234.95 | 236.05 | 234.95 | 235.75 | 76449.0 |
| 2024-10-18 07:00:00 | AAPL | Stock | 235.76 | 236.99 | 235.21 | 236.35 | 215746.0 |
| 2024-10-18 08:00:00 | AAPL | Stock | 235.69 | 237.0 | 231.57 | 236.3124 | 369263.0 |
| 2024-10-18 09:00:00 | AAPL | Stock | 236.35 | 237.23 | 234.01 | 235.42 | 11148935.0 |
| 2024-10-18 10:00:00 | AAPL | Stock | 235.43 | 235.8799 | 234.275 | 234.69 | 4280932.0 |
| 2024-10-18 11:00:00 | AAPL | Stock | 234.7 | 235.34 | 234.64 | 235.0275 | 2194118.0 |
| 2024-10-18 12:00:00 | AAPL | Stock | 235.02 | 235.645 | 234.8601 | 235.464 | 1716703.0 |
| 2024-10-18 13:00:00 | AAPL | Stock | 235.465 | 235.86 | 235.0416 | 235.648 | 2139923.0 |
| 2024-10-18 14:00:00 | AAPL | Stock | 235.64 | 235.75 | 235.31 | 235.56 | 1500204.0 |
| 2024-10-18 15:00:00 | AAPL | Stock | 235.55 | 235.555 | 234.8 | 234.98 | 3700623.0 |
| 2024-10-18 16:00:00 | AAPL | Stock | 235.0 | 235.08 | 234.91 | 235.02 | 6684994.0 |
| 2024-10-18 17:00:00 | AAPL | Stock | 235.02 | 235.03 | 234.88 | 234.898 | 40157.0 |
| 2024-10-18 18:00:00 | AAPL | Stock | 234.89 | 234.9 | 234.7 | 234.7856 | 11792.0 |
| 2024-10-18 19:00:00 | AAPL | Stock | 234.86 | 234.9 | 234.792 | 234.89 | 3990.0 |
| 2024-10-18 04:00:00 | MSFT | Stock | 417.25 | 418.38 | 417.25 | 418.19 | 4084.0 |
| 2024-10-18 05:00:00 | MSFT | Stock | 417.9 | 417.9 | 417.0 | 417.0 | 1926.0 |
| 2024-10-18 06:00:00 | MSFT | Stock | 417.0 | 417.32 | 417.0 | 417.32 | 987.0 |
| 2024-10-18 07:00:00 | MSFT | Stock | 417.2 | 417.25 | 416.81 | 417.17 | 6125.0 |
| 2024-10-18 08:00:00 | MSFT | Stock | 417.05 | 417.46 | 416.8 | 416.87 | 23004.0 |
| 2024-10-18 09:00:00 | MSFT | Stock | 417.0 | 419.65 | 415.76 | 417.31 | 3535826.0 |
| 2024-10-18 10:00:00 | MSFT | Stock | 417.365 | 418.03 | 416.2703 | 416.41 | 777100.0 |
| 2024-10-18 11:00:00 | MSFT | Stock | 416.405 | 418.73 | 416.32 | 416.97 | 637273.0 |
| 2024-10-18 12:00:00 | MSFT | Stock | 416.9901 | 417.75 | 416.2601 | 417.17 | 528348.0 |
| 2024-10-18 13:00:00 | MSFT | Stock | 417.14 | 418.0399 | 417.05 | 417.52 | 429659.0 |
| 2024-10-18 14:00:00 | MSFT | Stock | 417.49 | 418.1 | 416.9 | 417.83 | 382254.0 |
| 2024-10-18 15:00:00 | MSFT | Stock | 417.81 | 418.22 | 417.1 | 418.17 | 1163467.0 |
| 2024-10-18 16:00:00 | MSFT | Stock | 418.16 | 418.34 | 417.32 | 418.16 | 3185905.0 |
| 2024-10-18 17:00:00 | MSFT | Stock | 418.08 | 418.16 | 417.8606 | 418.0 | 36673.0 |
| 2024-10-18 18:00:00 | MSFT | Stock | 418.0 | 418.32 | 417.99 | 418.16 | 3803.0 |
| 2024-10-18 19:00:00 | MSFT | Stock | 418.0 | 418.25 | 417.5406 | 418.2 | 3071.0 |
| 2024-10-18 04:00:00 | NVDA | Stock | 138.5 | 138.83 | 137.79 | 138.46 | 442062.0 |
| 2024-10-18 05:00:00 | NVDA | Stock | 138.49 | 138.64 | 138.04 | 138.2 | 194076.0 |
| 2024-10-18 06:00:00 | NVDA | Stock | 138.25 | 138.45 | 138.06 | 138.19 | 198031.0 |
| 2024-10-18 07:00:00 | NVDA | Stock | 138.17 | 138.5 | 137.74 | 138.2 | 1020220.0 |
| 2024-10-18 08:00:00 | NVDA | Stock | 138.14 | 138.78 | 137.22 | 138.68 | 2330673.0 |
| 2024-10-18 09:00:00 | NVDA | Stock | 138.7 | 139.15 | 137.38 | 137.99 | 35076170.0 |
| 2024-10-18 10:00:00 | NVDA | Stock | 137.98 | 138.5 | 137.45 | 137.534 | 25589473.0 |
| 2024-10-18 11:00:00 | NVDA | Stock | 137.5399 | 138.1 | 137.48 | 137.8647 | 14895292.0 |
| 2024-10-18 12:00:00 | NVDA | Stock | 137.87 | 138.42 | 137.28 | 138.24 | 16162506.0 |
| 2024-10-18 13:00:00 | NVDA | Stock | 138.2301 | 138.67 | 138.15 | 138.29 | 14908016.0 |
| 2024-10-18 14:00:00 | NVDA | Stock | 138.295 | 138.405 | 137.9201 | 138.035 | 11388407.0 |
| 2024-10-18 15:00:00 | NVDA | Stock | 138.03 | 138.25 | 137.87 | 137.98 | 17240339.0 |
| 2024-10-18 16:00:00 | NVDA | Stock | 137.985 | 138.04 | 137.93 | 138.01 | 17390010.0 |
| 2024-10-18 17:00:00 | NVDA | Stock | 138.01 | 138.03 | 137.98 | 138.0 | 228675.0 |
| 2024-10-18 18:00:00 | NVDA | Stock | 137.99 | 138.02 | 137.95 | 137.97 | 119948.0 |
| 2024-10-18 19:00:00 | NVDA | Stock | 137.96 | 138.0 | 137.9102 | 138.0 | 209654.0 |
| 2024-10-18 04:00:00 | AMZN | Stock | 188.06 | 188.5 | 187.86 | 187.9 | 8652.0 |
| 2024-10-18 05:00:00 | AMZN | Stock | 187.88 | 188.14 | 187.72 | 187.72 | 2504.0 |
> showing 50 of 59,117 rows — these rows as CSV