PREVIEW / stock_1hour / 2024-04-10
file: by_date/stock_1hour/2024/2024-04-10.parquet size: 1.3 MB rows: 59,593 symbols: 1,012
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-04-10 04:00:00 | AAPL | Stock | 169.86 | 170.03 | 169.81 | 170.03 | 8216.0 |
| 2024-04-10 05:00:00 | AAPL | Stock | 170.0 | 170.0 | 169.83 | 169.95 | 17887.0 |
| 2024-04-10 06:00:00 | AAPL | Stock | 169.95 | 170.35 | 169.95 | 170.3 | 21911.0 |
| 2024-04-10 07:00:00 | AAPL | Stock | 170.28 | 170.4 | 170.1 | 170.38 | 22121.0 |
| 2024-04-10 08:00:00 | AAPL | Stock | 170.18 | 170.91 | 168.6 | 168.72 | 359155.0 |
| 2024-04-10 09:00:00 | AAPL | Stock | 168.7999 | 169.25 | 167.31 | 167.47 | 6962348.0 |
| 2024-04-10 10:00:00 | AAPL | Stock | 167.47 | 168.7 | 167.11 | 168.03 | 6707808.0 |
| 2024-04-10 11:00:00 | AAPL | Stock | 168.025 | 168.09 | 167.54 | 167.6401 | 3092131.0 |
| 2024-04-10 12:00:00 | AAPL | Stock | 167.645 | 168.44 | 167.585 | 168.4199 | 2869350.0 |
| 2024-04-10 13:00:00 | AAPL | Stock | 168.42 | 168.6 | 167.63 | 168.22 | 4300793.0 |
| 2024-04-10 14:00:00 | AAPL | Stock | 168.215 | 168.42 | 167.69 | 167.7299 | 3210083.0 |
| 2024-04-10 15:00:00 | AAPL | Stock | 167.73 | 168.685 | 167.69 | 167.75 | 6040365.0 |
| 2024-04-10 16:00:00 | AAPL | Stock | 167.76 | 168.02 | 167.72 | 168.02 | 6504310.0 |
| 2024-04-10 17:00:00 | AAPL | Stock | 168.0 | 168.05 | 167.9 | 167.99 | 44131.0 |
| 2024-04-10 18:00:00 | AAPL | Stock | 167.92 | 167.92 | 167.78 | 167.82 | 85115.0 |
| 2024-04-10 19:00:00 | AAPL | Stock | 167.82 | 167.9 | 167.75 | 167.85 | 21763.0 |
| 2024-04-10 04:00:00 | MSFT | Stock | 426.77 | 426.84 | 426.45 | 426.75 | 550.0 |
| 2024-04-10 05:00:00 | MSFT | Stock | 426.49 | 426.49 | 426.43 | 426.43 | 200.0 |
| 2024-04-10 06:00:00 | MSFT | Stock | 425.53 | 425.8 | 425.25 | 425.8 | 3272.0 |
| 2024-04-10 07:00:00 | MSFT | Stock | 425.65 | 425.87 | 425.43 | 425.84 | 14492.0 |
| 2024-04-10 08:00:00 | MSFT | Stock | 425.75 | 427.03 | 420.35 | 422.48 | 95973.0 |
| 2024-04-10 09:00:00 | MSFT | Stock | 422.2026 | 424.03 | 420.3 | 421.47 | 1685101.0 |
| 2024-04-10 10:00:00 | MSFT | Stock | 421.5 | 422.48 | 420.09 | 420.59 | 1309917.0 |
| 2024-04-10 11:00:00 | MSFT | Stock | 420.57 | 421.13 | 419.7 | 420.42 | 1184623.0 |
| 2024-04-10 12:00:00 | MSFT | Stock | 420.44 | 421.92 | 419.91 | 421.77 | 660398.0 |
| 2024-04-10 13:00:00 | MSFT | Stock | 421.76 | 422.87 | 419.995 | 421.675 | 1164743.0 |
| 2024-04-10 14:00:00 | MSFT | Stock | 421.71 | 422.66 | 421.07 | 421.15 | 773156.0 |
| 2024-04-10 15:00:00 | MSFT | Stock | 421.21 | 423.8 | 421.02 | 423.13 | 1497152.0 |
| 2024-04-10 16:00:00 | MSFT | Stock | 423.14 | 423.26 | 422.22 | 423.0 | 2356487.0 |
| 2024-04-10 17:00:00 | MSFT | Stock | 422.87 | 423.01 | 422.8 | 423.0 | 9770.0 |
| 2024-04-10 18:00:00 | MSFT | Stock | 422.81 | 423.18 | 422.81 | 423.18 | 3199.0 |
| 2024-04-10 19:00:00 | MSFT | Stock | 422.87 | 422.9999 | 422.18 | 422.18 | 3803.0 |
| 2024-04-10 04:00:00 | NVDA | Stock | 85.158 | 85.2 | 84.767 | 84.95 | 85420.0 |
| 2024-04-10 05:00:00 | NVDA | Stock | 84.93 | 84.931 | 84.8 | 84.8 | 44820.0 |
| 2024-04-10 06:00:00 | NVDA | Stock | 84.693 | 84.693 | 84.0 | 84.531 | 179120.0 |
| 2024-04-10 07:00:00 | NVDA | Stock | 84.55 | 84.972 | 84.401 | 84.801 | 532230.0 |
| 2024-04-10 08:00:00 | NVDA | Stock | 84.517 | 85.396 | 83.48 | 84.057 | 7012930.0 |
| 2024-04-10 09:00:00 | NVDA | Stock | 84.072 | 87.2 | 83.456 | 86.709 | 75722370.0 |
| 2024-04-10 10:00:00 | NVDA | Stock | 86.75 | 87.4 | 86.133 | 86.612 | 65948110.0 |
| 2024-04-10 11:00:00 | NVDA | Stock | 86.61 | 86.989 | 86.25 | 86.6576 | 30570340.0 |
| 2024-04-10 12:00:00 | NVDA | Stock | 86.6576 | 86.92 | 86.4 | 86.814 | 21799100.0 |
| 2024-04-10 13:00:00 | NVDA | Stock | 86.816 | 87.048 | 86.321 | 86.779 | 31095190.0 |
| 2024-04-10 14:00:00 | NVDA | Stock | 86.795 | 87.0 | 86.501 | 86.585 | 21156420.0 |
| 2024-04-10 15:00:00 | NVDA | Stock | 86.586 | 87.213 | 86.361 | 86.999 | 38453760.0 |
| 2024-04-10 16:00:00 | NVDA | Stock | 86.99 | 87.171 | 86.926 | 87.15 | 14384980.0 |
| 2024-04-10 17:00:00 | NVDA | Stock | 87.175 | 87.3 | 87.0808 | 87.269 | 507420.0 |
| 2024-04-10 18:00:00 | NVDA | Stock | 87.2311 | 87.249 | 86.972 | 86.9993 | 516420.0 |
| 2024-04-10 19:00:00 | NVDA | Stock | 86.977 | 87.031 | 86.9 | 86.95 | 544250.0 |
| 2024-04-10 04:00:00 | AMZN | Stock | 185.77 | 185.88 | 185.58 | 185.79 | 9150.0 |
| 2024-04-10 05:00:00 | AMZN | Stock | 185.89 | 185.89 | 185.58 | 185.58 | 6324.0 |
> showing 50 of 59,593 rows — these rows as CSV