PREVIEW / stock_1hour / 2024-04-09
file: by_date/stock_1hour/2024/2024-04-09.parquet size: 1.3 MB rows: 58,070 symbols: 1,041
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-09 04:00:00 | AAPL | Stock | 168.51 | 168.51 | 168.19 | 168.32 | 10331.0 |
| 2024-04-09 05:00:00 | AAPL | Stock | 168.29 | 168.36 | 168.24 | 168.3 | 7910.0 |
| 2024-04-09 06:00:00 | AAPL | Stock | 168.28 | 168.28 | 167.8 | 168.0 | 22371.0 |
| 2024-04-09 07:00:00 | AAPL | Stock | 168.01 | 168.31 | 168.0 | 168.3 | 29987.0 |
| 2024-04-09 08:00:00 | AAPL | Stock | 168.02 | 168.8906 | 168.02 | 168.7 | 119275.0 |
| 2024-04-09 09:00:00 | AAPL | Stock | 168.72 | 169.88 | 168.36 | 169.605 | 5047432.0 |
| 2024-04-09 10:00:00 | AAPL | Stock | 169.59 | 170.08 | 168.48 | 168.85 | 5906017.0 |
| 2024-04-09 11:00:00 | AAPL | Stock | 168.84 | 169.16 | 168.59 | 168.975 | 3437204.0 |
| 2024-04-09 12:00:00 | AAPL | Stock | 168.9726 | 169.25 | 168.83 | 169.06 | 2737663.0 |
| 2024-04-09 13:00:00 | AAPL | Stock | 169.07 | 169.56 | 168.94 | 168.95 | 2995708.0 |
| 2024-04-09 14:00:00 | AAPL | Stock | 168.955 | 168.9755 | 168.5 | 168.5945 | 3364370.0 |
| 2024-04-09 15:00:00 | AAPL | Stock | 168.59 | 169.73 | 168.35 | 169.69 | 6918445.0 |
| 2024-04-09 16:00:00 | AAPL | Stock | 169.67 | 169.79 | 169.43 | 169.57 | 4913208.0 |
| 2024-04-09 17:00:00 | AAPL | Stock | 169.56 | 169.6 | 169.44 | 169.58 | 19581.0 |
| 2024-04-09 18:00:00 | AAPL | Stock | 169.6 | 169.74 | 169.58 | 169.68 | 42237.0 |
| 2024-04-09 19:00:00 | AAPL | Stock | 169.71 | 169.76 | 169.67 | 169.76 | 24949.0 |
| 2024-04-09 04:00:00 | MSFT | Stock | 425.2 | 425.75 | 425.2 | 425.75 | 1650.0 |
| 2024-04-09 05:00:00 | MSFT | Stock | 425.61 | 425.61 | 425.57 | 425.57 | 592.0 |
| 2024-04-09 06:00:00 | MSFT | Stock | 424.7 | 424.7 | 424.0 | 424.18 | 2139.0 |
| 2024-04-09 07:00:00 | MSFT | Stock | 424.59 | 425.59 | 424.59 | 425.59 | 2969.0 |
| 2024-04-09 08:00:00 | MSFT | Stock | 425.31 | 426.6001 | 424.65 | 425.6 | 17475.0 |
| 2024-04-09 09:00:00 | MSFT | Stock | 426.0 | 427.74 | 424.53 | 425.99 | 1059879.0 |
| 2024-04-09 10:00:00 | MSFT | Stock | 426.03 | 426.75 | 421.62 | 423.02 | 1352729.0 |
| 2024-04-09 11:00:00 | MSFT | Stock | 422.995 | 424.15 | 422.6513 | 423.79 | 700846.0 |
| 2024-04-09 12:00:00 | MSFT | Stock | 423.78 | 424.67 | 423.39 | 423.68 | 541590.0 |
| 2024-04-09 13:00:00 | MSFT | Stock | 423.659 | 424.8 | 423.48 | 423.78 | 466347.0 |
| 2024-04-09 14:00:00 | MSFT | Stock | 423.755 | 424.46 | 422.98 | 423.07 | 457542.0 |
| 2024-04-09 15:00:00 | MSFT | Stock | 423.035 | 426.5 | 422.47 | 426.35 | 1427940.0 |
| 2024-04-09 16:00:00 | MSFT | Stock | 426.28 | 427.0 | 426.2 | 426.5 | 1932278.0 |
| 2024-04-09 17:00:00 | MSFT | Stock | 426.53 | 426.61 | 425.8683 | 426.2 | 9035.0 |
| 2024-04-09 18:00:00 | MSFT | Stock | 426.3 | 426.39 | 426.1359 | 426.3 | 1899.0 |
| 2024-04-09 19:00:00 | MSFT | Stock | 426.01 | 426.47 | 425.8501 | 426.2 | 7786.0 |
| 2024-04-09 04:00:00 | NVDA | Stock | 87.103 | 87.336 | 87.086 | 87.193 | 43350.0 |
| 2024-04-09 05:00:00 | NVDA | Stock | 87.087 | 87.19 | 87.05 | 87.19 | 24270.0 |
| 2024-04-09 06:00:00 | NVDA | Stock | 87.05 | 87.053 | 86.45 | 86.735 | 107670.0 |
| 2024-04-09 07:00:00 | NVDA | Stock | 86.74 | 87.06 | 86.636 | 86.872 | 381010.0 |
| 2024-04-09 08:00:00 | NVDA | Stock | 86.811 | 87.319 | 86.6334 | 87.228 | 1185520.0 |
| 2024-04-09 09:00:00 | NVDA | Stock | 87.25 | 87.635 | 86.207 | 86.299 | 38853030.0 |
| 2024-04-09 10:00:00 | NVDA | Stock | 86.28 | 86.396 | 83.022 | 83.723 | 110818400.0 |
| 2024-04-09 11:00:00 | NVDA | Stock | 83.7225 | 84.769 | 83.49 | 84.692 | 60860930.0 |
| 2024-04-09 12:00:00 | NVDA | Stock | 84.685 | 84.999 | 84.38 | 84.464 | 39074740.0 |
| 2024-04-09 13:00:00 | NVDA | Stock | 84.473 | 84.996 | 84.369 | 84.7406 | 27875230.0 |
| 2024-04-09 14:00:00 | NVDA | Stock | 84.7405 | 84.855 | 84.2796 | 84.532 | 24494390.0 |
| 2024-04-09 15:00:00 | NVDA | Stock | 84.5175 | 85.38 | 84.125 | 85.364 | 50186150.0 |
| 2024-04-09 16:00:00 | NVDA | Stock | 85.354 | 85.7067 | 85.032 | 85.082 | 11839150.0 |
| 2024-04-09 17:00:00 | NVDA | Stock | 85.354 | 85.354 | 84.912 | 85.016 | 631330.0 |
| 2024-04-09 18:00:00 | NVDA | Stock | 84.994 | 85.1778 | 84.9253 | 85.1 | 523470.0 |
| 2024-04-09 19:00:00 | NVDA | Stock | 85.099 | 85.099 | 84.68 | 84.73 | 652630.0 |
| 2024-04-09 04:00:00 | AMZN | Stock | 185.75 | 185.75 | 185.48 | 185.55 | 6014.0 |
| 2024-04-09 05:00:00 | AMZN | Stock | 185.55 | 185.64 | 185.48 | 185.64 | 3733.0 |
> showing 50 of 58,070 rows — these rows as CSV