PREVIEW / stock_1hour / 2024-11-27
file: by_date/stock_1hour/2024/2024-11-27.parquet size: 1.4 MB rows: 60,468 symbols: 691
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-27 04:00:00 | AAPL | Stock | 235.5 | 235.5 | 234.13 | 234.4 | 24298.0 |
| 2024-11-27 05:00:00 | AAPL | Stock | 234.34 | 234.49 | 234.21 | 234.38 | 17057.0 |
| 2024-11-27 06:00:00 | AAPL | Stock | 234.26 | 234.3 | 234.0 | 234.19 | 21588.0 |
| 2024-11-27 07:00:00 | AAPL | Stock | 234.29 | 234.38 | 233.92 | 234.17 | 51405.0 |
| 2024-11-27 08:00:00 | AAPL | Stock | 233.95 | 235.72 | 233.5 | 233.81 | 115040.0 |
| 2024-11-27 09:00:00 | AAPL | Stock | 233.8 | 235.68 | 233.26 | 234.32 | 3271054.0 |
| 2024-11-27 10:00:00 | AAPL | Stock | 234.33 | 235.69 | 233.9796 | 234.62 | 3867771.0 |
| 2024-11-27 11:00:00 | AAPL | Stock | 234.62 | 234.89 | 234.12 | 234.3525 | 2260823.0 |
| 2024-11-27 12:00:00 | AAPL | Stock | 234.35 | 234.74 | 233.98 | 234.73 | 1737730.0 |
| 2024-11-27 13:00:00 | AAPL | Stock | 234.73 | 235.02 | 234.6125 | 234.93 | 1314994.0 |
| 2024-11-27 14:00:00 | AAPL | Stock | 234.925 | 235.25 | 234.77 | 235.06 | 1336455.0 |
| 2024-11-27 15:00:00 | AAPL | Stock | 235.065 | 235.2 | 234.585 | 234.99 | 2896061.0 |
| 2024-11-27 16:00:00 | AAPL | Stock | 234.93 | 235.34 | 234.9 | 235.01 | 8771302.0 |
| 2024-11-27 17:00:00 | AAPL | Stock | 235.03 | 235.14 | 235.03 | 235.0981 | 3726.0 |
| 2024-11-27 18:00:00 | AAPL | Stock | 235.07 | 235.1805 | 235.01 | 235.15 | 4792.0 |
| 2024-11-27 19:00:00 | AAPL | Stock | 235.13 | 235.25 | 235.0608 | 235.2 | 5794.0 |
| 2024-11-27 04:00:00 | MSFT | Stock | 425.45 | 425.69 | 425.0 | 425.01 | 3585.0 |
| 2024-11-27 05:00:00 | MSFT | Stock | 425.62 | 425.62 | 425.38 | 425.38 | 420.0 |
| 2024-11-27 06:00:00 | MSFT | Stock | 425.35 | 425.47 | 425.25 | 425.25 | 625.0 |
| 2024-11-27 07:00:00 | MSFT | Stock | 425.49 | 426.21 | 425.38 | 426.0 | 14372.0 |
| 2024-11-27 08:00:00 | MSFT | Stock | 425.65 | 426.98 | 425.5 | 425.51 | 37016.0 |
| 2024-11-27 09:00:00 | MSFT | Stock | 425.51 | 427.2299 | 424.1 | 425.74 | 1327427.0 |
| 2024-11-27 10:00:00 | MSFT | Stock | 425.6 | 426.09 | 423.745 | 424.44 | 1133042.0 |
| 2024-11-27 11:00:00 | MSFT | Stock | 424.46 | 425.005 | 422.99 | 424.225 | 927945.0 |
| 2024-11-27 12:00:00 | MSFT | Stock | 424.225 | 424.395 | 423.25 | 423.37 | 539026.0 |
| 2024-11-27 13:00:00 | MSFT | Stock | 423.36 | 424.5 | 423.17 | 424.33 | 556497.0 |
| 2024-11-27 14:00:00 | MSFT | Stock | 424.3457 | 424.65 | 423.91 | 424.06 | 532060.0 |
| 2024-11-27 15:00:00 | MSFT | Stock | 424.04 | 424.9 | 422.02 | 422.91 | 1971765.0 |
| 2024-11-27 16:00:00 | MSFT | Stock | 422.99 | 422.99 | 419.9509 | 421.38 | 4678629.0 |
| 2024-11-27 17:00:00 | MSFT | Stock | 421.3057 | 421.7886 | 421.03 | 421.7886 | 10611.0 |
| 2024-11-27 18:00:00 | MSFT | Stock | 421.6 | 421.86 | 421.25 | 421.86 | 13691.0 |
| 2024-11-27 19:00:00 | MSFT | Stock | 421.89 | 421.98 | 421.71 | 421.98 | 8858.0 |
| 2024-11-27 04:00:00 | NVDA | Stock | 136.3 | 136.5 | 135.26 | 135.6 | 499099.0 |
| 2024-11-27 05:00:00 | NVDA | Stock | 135.61 | 135.62 | 135.05 | 135.46 | 437144.0 |
| 2024-11-27 06:00:00 | NVDA | Stock | 135.45 | 135.64 | 135.27 | 135.57 | 242709.0 |
| 2024-11-27 07:00:00 | NVDA | Stock | 135.57 | 135.64 | 135.01 | 135.18 | 798165.0 |
| 2024-11-27 08:00:00 | NVDA | Stock | 135.18 | 136.75 | 135.0101 | 135.07 | 1710203.0 |
| 2024-11-27 09:00:00 | NVDA | Stock | 135.1 | 137.22 | 133.4 | 133.9901 | 34535347.0 |
| 2024-11-27 10:00:00 | NVDA | Stock | 133.99 | 134.024 | 132.01 | 132.725 | 39662411.0 |
| 2024-11-27 11:00:00 | NVDA | Stock | 132.72 | 133.08 | 132.0 | 132.3138 | 22420907.0 |
| 2024-11-27 12:00:00 | NVDA | Stock | 132.319 | 133.08 | 131.8 | 133.0411 | 15848873.0 |
| 2024-11-27 13:00:00 | NVDA | Stock | 133.045 | 134.43 | 132.84 | 134.215 | 17349584.0 |
| 2024-11-27 14:00:00 | NVDA | Stock | 134.22 | 134.6 | 133.98 | 134.345 | 14208586.0 |
| 2024-11-27 15:00:00 | NVDA | Stock | 134.345 | 135.42 | 134.18 | 135.4 | 23304707.0 |
| 2024-11-27 16:00:00 | NVDA | Stock | 135.41 | 135.7 | 135.1 | 135.42 | 21998781.0 |
| 2024-11-27 17:00:00 | NVDA | Stock | 135.4192 | 135.49 | 135.25 | 135.31 | 263721.0 |
| 2024-11-27 18:00:00 | NVDA | Stock | 135.3001 | 135.44 | 135.3001 | 135.43 | 230328.0 |
| 2024-11-27 19:00:00 | NVDA | Stock | 135.4296 | 136.0 | 135.42 | 135.98 | 647534.0 |
| 2024-11-27 04:00:00 | AMZN | Stock | 208.02 | 208.06 | 207.56 | 207.66 | 9133.0 |
| 2024-11-27 05:00:00 | AMZN | Stock | 207.74 | 207.9 | 207.59 | 207.86 | 5354.0 |
> showing 50 of 60,468 rows — these rows as CSV