PREVIEW / stock_1hour / 2024-11-08
file: by_date/stock_1hour/2024/2024-11-08.parquet size: 1.4 MB rows: 61,665 symbols: 708
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-11-08 04:00:00 | AAPL | Stock | 227.75 | 227.81 | 227.5 | 227.79 | 8075.0 |
| 2024-11-08 05:00:00 | AAPL | Stock | 227.82 | 228.0 | 227.0 | 227.06 | 13187.0 |
| 2024-11-08 06:00:00 | AAPL | Stock | 227.06 | 227.7 | 227.05 | 227.56 | 11818.0 |
| 2024-11-08 07:00:00 | AAPL | Stock | 227.57 | 227.71 | 227.41 | 227.55 | 12630.0 |
| 2024-11-08 08:00:00 | AAPL | Stock | 227.57 | 227.9 | 227.25 | 227.37 | 67555.0 |
| 2024-11-08 09:00:00 | AAPL | Stock | 227.38 | 228.66 | 226.78 | 227.7699 | 3193725.0 |
| 2024-11-08 10:00:00 | AAPL | Stock | 227.78 | 228.1499 | 226.505 | 226.51 | 2923401.0 |
| 2024-11-08 11:00:00 | AAPL | Stock | 226.515 | 227.58 | 226.405 | 227.27 | 2541290.0 |
| 2024-11-08 12:00:00 | AAPL | Stock | 227.265 | 227.4565 | 226.75 | 227.02 | 1579513.0 |
| 2024-11-08 13:00:00 | AAPL | Stock | 227.03 | 227.61 | 226.79 | 227.5 | 1489302.0 |
| 2024-11-08 14:00:00 | AAPL | Stock | 227.495 | 227.68 | 227.23 | 227.44 | 1260409.0 |
| 2024-11-08 15:00:00 | AAPL | Stock | 227.435 | 227.72 | 226.72 | 227.16 | 4198988.0 |
| 2024-11-08 16:00:00 | AAPL | Stock | 226.96 | 227.39 | 226.96 | 227.18 | 6797979.0 |
| 2024-11-08 17:00:00 | AAPL | Stock | 227.15 | 227.2584 | 226.85 | 226.85 | 399596.0 |
| 2024-11-08 18:00:00 | AAPL | Stock | 226.88 | 226.9912 | 226.85 | 226.96 | 7752.0 |
| 2024-11-08 19:00:00 | AAPL | Stock | 226.96 | 226.98 | 226.8808 | 226.96 | 5080.0 |
| 2024-11-08 04:00:00 | MSFT | Stock | 425.97 | 427.0 | 425.97 | 426.02 | 2581.0 |
| 2024-11-08 05:00:00 | MSFT | Stock | 425.73 | 425.73 | 423.47 | 423.8 | 4561.0 |
| 2024-11-08 06:00:00 | MSFT | Stock | 423.45 | 423.79 | 423.05 | 423.79 | 6140.0 |
| 2024-11-08 07:00:00 | MSFT | Stock | 423.78 | 425.0 | 423.78 | 424.84 | 7472.0 |
| 2024-11-08 08:00:00 | MSFT | Stock | 424.6 | 426.493 | 423.81 | 424.33 | 25914.0 |
| 2024-11-08 09:00:00 | MSFT | Stock | 424.15 | 426.5 | 423.9759 | 426.15 | 1333339.0 |
| 2024-11-08 10:00:00 | MSFT | Stock | 426.24 | 426.5 | 423.11 | 423.87 | 1396505.0 |
| 2024-11-08 11:00:00 | MSFT | Stock | 423.88 | 424.37 | 423.0582 | 423.8209 | 1013016.0 |
| 2024-11-08 12:00:00 | MSFT | Stock | 423.8 | 423.85 | 422.15 | 422.3 | 751464.0 |
| 2024-11-08 13:00:00 | MSFT | Stock | 422.33 | 423.63 | 421.85 | 423.46 | 630463.0 |
| 2024-11-08 14:00:00 | MSFT | Stock | 423.445 | 424.08 | 423.01 | 423.04 | 566056.0 |
| 2024-11-08 15:00:00 | MSFT | Stock | 423.05 | 423.5 | 421.78 | 422.93 | 1258689.0 |
| 2024-11-08 16:00:00 | MSFT | Stock | 422.54 | 423.2 | 422.54 | 422.9 | 4387489.0 |
| 2024-11-08 17:00:00 | MSFT | Stock | 422.8116 | 422.83 | 422.5019 | 422.5019 | 240917.0 |
| 2024-11-08 18:00:00 | MSFT | Stock | 422.55 | 422.7955 | 422.55 | 422.7955 | 3457.0 |
| 2024-11-08 19:00:00 | MSFT | Stock | 422.76 | 422.8 | 422.35 | 422.35 | 5599.0 |
| 2024-11-08 04:00:00 | NVDA | Stock | 149.73 | 149.95 | 149.45 | 149.51 | 421169.0 |
| 2024-11-08 05:00:00 | NVDA | Stock | 149.48 | 149.48 | 146.85 | 147.27 | 854954.0 |
| 2024-11-08 06:00:00 | NVDA | Stock | 147.29 | 148.22 | 146.8 | 148.14 | 723057.0 |
| 2024-11-08 07:00:00 | NVDA | Stock | 148.17 | 149.2 | 148.0 | 149.16 | 1191298.0 |
| 2024-11-08 08:00:00 | NVDA | Stock | 149.14 | 150.0 | 146.9171 | 148.5001 | 2806587.0 |
| 2024-11-08 09:00:00 | NVDA | Stock | 148.51 | 149.77 | 147.95 | 148.42 | 28648099.0 |
| 2024-11-08 10:00:00 | NVDA | Stock | 148.42 | 148.72 | 146.26 | 147.29 | 33163689.0 |
| 2024-11-08 11:00:00 | NVDA | Stock | 147.28 | 147.97 | 146.35 | 147.65 | 18200245.0 |
| 2024-11-08 12:00:00 | NVDA | Stock | 147.66 | 147.85 | 147.13 | 147.34 | 10935897.0 |
| 2024-11-08 13:00:00 | NVDA | Stock | 147.345 | 147.73 | 147.22 | 147.5435 | 8152761.0 |
| 2024-11-08 14:00:00 | NVDA | Stock | 147.545 | 147.56 | 146.85 | 147.01 | 9601440.0 |
| 2024-11-08 15:00:00 | NVDA | Stock | 147.0199 | 147.88 | 146.88 | 147.5 | 15521841.0 |
| 2024-11-08 16:00:00 | NVDA | Stock | 147.63 | 147.8 | 147.51 | 147.54 | 18331583.0 |
| 2024-11-08 17:00:00 | NVDA | Stock | 147.53 | 147.65 | 147.39 | 147.55 | 887389.0 |
| 2024-11-08 18:00:00 | NVDA | Stock | 147.55 | 147.63 | 147.46 | 147.49 | 155656.0 |
| 2024-11-08 19:00:00 | NVDA | Stock | 147.4898 | 147.55 | 147.44 | 147.51 | 200596.0 |
| 2024-11-08 04:00:00 | AMZN | Stock | 210.55 | 210.66 | 210.27 | 210.4 | 6486.0 |
| 2024-11-08 05:00:00 | AMZN | Stock | 210.39 | 210.39 | 208.75 | 208.97 | 18655.0 |
> showing 50 of 61,665 rows — these rows as CSV