PREVIEW / stock_1hour / 2024-04-08
file: by_date/stock_1hour/2024/2024-04-08.parquet size: 1.3 MB rows: 58,890 symbols: 1,029
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-08 04:00:00 | AAPL | Stock | 169.6 | 169.6 | 168.9 | 169.05 | 14467.0 |
| 2024-04-08 05:00:00 | AAPL | Stock | 169.05 | 169.3 | 169.05 | 169.1 | 10310.0 |
| 2024-04-08 06:00:00 | AAPL | Stock | 169.12 | 169.2 | 168.93 | 169.2 | 9411.0 |
| 2024-04-08 07:00:00 | AAPL | Stock | 169.22 | 169.31 | 168.85 | 169.11 | 30473.0 |
| 2024-04-08 08:00:00 | AAPL | Stock | 169.22 | 169.61 | 168.85 | 169.35 | 91310.0 |
| 2024-04-08 09:00:00 | AAPL | Stock | 169.38 | 169.39 | 168.24 | 168.985 | 4246487.0 |
| 2024-04-08 10:00:00 | AAPL | Stock | 168.99 | 169.16 | 168.71 | 168.9901 | 4235532.0 |
| 2024-04-08 11:00:00 | AAPL | Stock | 168.995 | 169.08 | 168.4301 | 168.64 | 3540111.0 |
| 2024-04-08 12:00:00 | AAPL | Stock | 168.64 | 168.835 | 168.26 | 168.805 | 2924128.0 |
| 2024-04-08 13:00:00 | AAPL | Stock | 168.81 | 168.83 | 168.405 | 168.695 | 2403960.0 |
| 2024-04-08 14:00:00 | AAPL | Stock | 168.7 | 168.9 | 168.545 | 168.76 | 1837453.0 |
| 2024-04-08 15:00:00 | AAPL | Stock | 168.76 | 168.96 | 168.325 | 168.46 | 5286966.0 |
| 2024-04-08 16:00:00 | AAPL | Stock | 168.49 | 168.55 | 168.32 | 168.37 | 6157105.0 |
| 2024-04-08 17:00:00 | AAPL | Stock | 168.37 | 168.41 | 168.36 | 168.41 | 14914.0 |
| 2024-04-08 18:00:00 | AAPL | Stock | 168.42 | 168.45 | 168.2852 | 168.39 | 20250.0 |
| 2024-04-08 19:00:00 | AAPL | Stock | 168.3908 | 168.41 | 168.26 | 168.27 | 21756.0 |
| 2024-04-08 04:00:00 | MSFT | Stock | 425.79 | 425.99 | 424.0 | 424.0 | 9860.0 |
| 2024-04-08 05:00:00 | MSFT | Stock | 424.09 | 424.09 | 423.74 | 424.05 | 1849.0 |
| 2024-04-08 06:00:00 | MSFT | Stock | 424.09 | 424.32 | 423.91 | 424.26 | 2137.0 |
| 2024-04-08 07:00:00 | MSFT | Stock | 424.48 | 425.55 | 424.4 | 424.9 | 9356.0 |
| 2024-04-08 08:00:00 | MSFT | Stock | 424.99 | 426.8354 | 424.4003 | 426.0995 | 22496.0 |
| 2024-04-08 09:00:00 | MSFT | Stock | 426.39 | 426.491 | 423.3 | 425.63 | 1378225.0 |
| 2024-04-08 10:00:00 | MSFT | Stock | 425.59 | 427.28 | 424.97 | 426.33 | 1339073.0 |
| 2024-04-08 11:00:00 | MSFT | Stock | 426.36 | 426.53 | 424.21 | 424.78 | 934191.0 |
| 2024-04-08 12:00:00 | MSFT | Stock | 424.78 | 424.96 | 423.36 | 424.96 | 702571.0 |
| 2024-04-08 13:00:00 | MSFT | Stock | 424.95 | 424.96 | 423.64 | 424.35 | 436095.0 |
| 2024-04-08 14:00:00 | MSFT | Stock | 424.355 | 425.57 | 424.03 | 425.55 | 498236.0 |
| 2024-04-08 15:00:00 | MSFT | Stock | 425.55 | 426.24 | 424.47 | 424.66 | 1525958.0 |
| 2024-04-08 16:00:00 | MSFT | Stock | 424.59 | 425.0 | 424.59 | 425.0 | 2248024.0 |
| 2024-04-08 17:00:00 | MSFT | Stock | 424.99 | 425.3575 | 424.97 | 425.1 | 4269.0 |
| 2024-04-08 18:00:00 | MSFT | Stock | 425.1052 | 425.45 | 425.1052 | 425.25 | 1023.0 |
| 2024-04-08 19:00:00 | MSFT | Stock | 425.22 | 425.35 | 425.2 | 425.3 | 5506.0 |
| 2024-04-08 04:00:00 | NVDA | Stock | 88.1 | 88.559 | 87.845 | 87.845 | 170640.0 |
| 2024-04-08 05:00:00 | NVDA | Stock | 87.945 | 88.061 | 87.85 | 87.978 | 46740.0 |
| 2024-04-08 06:00:00 | NVDA | Stock | 87.968 | 88.3 | 87.938 | 88.24 | 47010.0 |
| 2024-04-08 07:00:00 | NVDA | Stock | 88.25 | 88.5 | 88.21 | 88.4 | 564130.0 |
| 2024-04-08 08:00:00 | NVDA | Stock | 88.23 | 88.79 | 87.6 | 88.73 | 1691220.0 |
| 2024-04-08 09:00:00 | NVDA | Stock | 88.735 | 89.0 | 86.811 | 87.343 | 45330120.0 |
| 2024-04-08 10:00:00 | NVDA | Stock | 87.341 | 88.133 | 87.081 | 87.8125 | 38329540.0 |
| 2024-04-08 11:00:00 | NVDA | Stock | 87.815 | 87.8679 | 87.228 | 87.423 | 22158340.0 |
| 2024-04-08 12:00:00 | NVDA | Stock | 87.421 | 87.441 | 86.732 | 87.378 | 27229450.0 |
| 2024-04-08 13:00:00 | NVDA | Stock | 87.368 | 87.44 | 86.889 | 87.169 | 15622030.0 |
| 2024-04-08 14:00:00 | NVDA | Stock | 87.17 | 87.368 | 87.026 | 87.363 | 13936680.0 |
| 2024-04-08 15:00:00 | NVDA | Stock | 87.363 | 87.47 | 86.982 | 87.188 | 23186690.0 |
| 2024-04-08 16:00:00 | NVDA | Stock | 87.133 | 87.2 | 87.054 | 87.0957 | 13308810.0 |
| 2024-04-08 17:00:00 | NVDA | Stock | 87.098 | 87.109 | 87.0 | 87.058 | 128340.0 |
| 2024-04-08 18:00:00 | NVDA | Stock | 87.058 | 87.133 | 87.007 | 87.048 | 220480.0 |
| 2024-04-08 19:00:00 | NVDA | Stock | 87.056 | 87.07 | 87.02 | 87.02 | 261030.0 |
| 2024-04-08 04:00:00 | AMZN | Stock | 185.54 | 186.67 | 185.37 | 186.3 | 25998.0 |
| 2024-04-08 05:00:00 | AMZN | Stock | 186.32 | 187.8 | 186.3 | 187.49 | 25029.0 |
> showing 50 of 58,890 rows — these rows as CSV