PREVIEW / stock_1hour / 2024-04-12
file: by_date/stock_1hour/2024/2024-04-12.parquet size: 1.3 MB rows: 58,654 symbols: 1,014
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-12 04:00:00 | AAPL | Stock | 174.96 | 175.5 | 174.7 | 174.84 | 43255.0 |
| 2024-04-12 05:00:00 | AAPL | Stock | 174.83 | 174.85 | 174.17 | 174.36 | 23872.0 |
| 2024-04-12 06:00:00 | AAPL | Stock | 174.32 | 174.34 | 173.49 | 173.93 | 44738.0 |
| 2024-04-12 07:00:00 | AAPL | Stock | 173.97 | 174.95 | 173.8 | 174.63 | 129329.0 |
| 2024-04-12 08:00:00 | AAPL | Stock | 174.05 | 175.4 | 173.7888 | 173.95 | 313033.0 |
| 2024-04-12 09:00:00 | AAPL | Stock | 173.985 | 178.36 | 173.62 | 178.07 | 19895189.0 |
| 2024-04-12 10:00:00 | AAPL | Stock | 178.07 | 178.19 | 175.745 | 175.8717 | 15035814.0 |
| 2024-04-12 11:00:00 | AAPL | Stock | 175.875 | 176.99 | 175.32 | 175.91 | 8858658.0 |
| 2024-04-12 12:00:00 | AAPL | Stock | 175.93 | 176.22 | 174.92 | 175.01 | 6592305.0 |
| 2024-04-12 13:00:00 | AAPL | Stock | 175.02 | 176.0 | 174.8 | 175.4098 | 6211427.0 |
| 2024-04-12 14:00:00 | AAPL | Stock | 175.405 | 176.26 | 175.345 | 175.94 | 6199614.0 |
| 2024-04-12 15:00:00 | AAPL | Stock | 175.935 | 176.74 | 175.63 | 176.56 | 11952966.0 |
| 2024-04-12 16:00:00 | AAPL | Stock | 176.57 | 176.94 | 176.54 | 176.91 | 9428729.0 |
| 2024-04-12 17:00:00 | AAPL | Stock | 176.91 | 176.99 | 176.55 | 176.57 | 60550.0 |
| 2024-04-12 18:00:00 | AAPL | Stock | 176.57 | 176.57 | 176.2209 | 176.4051 | 53329.0 |
| 2024-04-12 19:00:00 | AAPL | Stock | 176.37 | 176.43 | 176.02 | 176.21 | 36066.0 |
| 2024-04-12 04:00:00 | MSFT | Stock | 427.5 | 427.98 | 427.35 | 427.71 | 1983.0 |
| 2024-04-12 05:00:00 | MSFT | Stock | 427.02 | 427.02 | 426.7 | 426.84 | 1612.0 |
| 2024-04-12 06:00:00 | MSFT | Stock | 426.74 | 426.74 | 425.85 | 426.08 | 1897.0 |
| 2024-04-12 07:00:00 | MSFT | Stock | 426.39 | 426.7 | 425.83 | 426.69 | 11705.0 |
| 2024-04-12 08:00:00 | MSFT | Stock | 426.351 | 428.5 | 425.25 | 425.4 | 38590.0 |
| 2024-04-12 09:00:00 | MSFT | Stock | 425.41 | 425.41 | 422.52 | 424.83 | 1750800.0 |
| 2024-04-12 10:00:00 | MSFT | Stock | 424.86 | 424.91 | 420.74 | 421.0 | 1637998.0 |
| 2024-04-12 11:00:00 | MSFT | Stock | 421.05 | 424.44 | 420.92 | 423.83 | 1068771.0 |
| 2024-04-12 12:00:00 | MSFT | Stock | 423.91 | 424.26 | 421.1 | 421.1 | 906862.0 |
| 2024-04-12 13:00:00 | MSFT | Stock | 421.125 | 421.7396 | 419.77 | 420.69 | 1052966.0 |
| 2024-04-12 14:00:00 | MSFT | Stock | 420.7 | 422.25 | 420.42 | 421.13 | 850257.0 |
| 2024-04-12 15:00:00 | MSFT | Stock | 421.12 | 422.27 | 420.84 | 422.12 | 1454582.0 |
| 2024-04-12 16:00:00 | MSFT | Stock | 422.11 | 422.74 | 421.9 | 422.33 | 4004589.0 |
| 2024-04-12 17:00:00 | MSFT | Stock | 422.457 | 422.46 | 421.9 | 421.9 | 3729.0 |
| 2024-04-12 18:00:00 | MSFT | Stock | 421.71 | 421.8907 | 421.4 | 421.4 | 2955.0 |
| 2024-04-12 19:00:00 | MSFT | Stock | 421.5 | 421.5 | 420.87 | 421.4 | 8860.0 |
| 2024-04-12 04:00:00 | NVDA | Stock | 90.76 | 90.863 | 90.12 | 90.38 | 235190.0 |
| 2024-04-12 05:00:00 | NVDA | Stock | 90.241 | 90.4 | 90.1 | 90.202 | 89890.0 |
| 2024-04-12 06:00:00 | NVDA | Stock | 90.275 | 90.275 | 89.55 | 89.9 | 285860.0 |
| 2024-04-12 07:00:00 | NVDA | Stock | 89.938 | 90.45 | 89.85 | 90.36 | 878240.0 |
| 2024-04-12 08:00:00 | NVDA | Stock | 89.9 | 90.85 | 89.7292 | 89.801 | 2517200.0 |
| 2024-04-12 09:00:00 | NVDA | Stock | 89.8519 | 90.175 | 88.832 | 89.467 | 47396310.0 |
| 2024-04-12 10:00:00 | NVDA | Stock | 89.485 | 89.79 | 88.293 | 88.337 | 47115770.0 |
| 2024-04-12 11:00:00 | NVDA | Stock | 88.34 | 89.55 | 88.301 | 89.35 | 39580700.0 |
| 2024-04-12 12:00:00 | NVDA | Stock | 89.3493 | 89.391 | 88.396 | 88.7345 | 29994480.0 |
| 2024-04-12 13:00:00 | NVDA | Stock | 88.7316 | 89.0 | 88.3082 | 88.5343 | 28184540.0 |
| 2024-04-12 14:00:00 | NVDA | Stock | 88.533 | 88.6436 | 87.5316 | 87.62 | 32531920.0 |
| 2024-04-12 15:00:00 | NVDA | Stock | 87.6245 | 88.47 | 87.53 | 88.195 | 48079600.0 |
| 2024-04-12 16:00:00 | NVDA | Stock | 88.279 | 88.279 | 87.96 | 88.05 | 23263090.0 |
| 2024-04-12 17:00:00 | NVDA | Stock | 88.05 | 88.186 | 87.723 | 87.792 | 477760.0 |
| 2024-04-12 18:00:00 | NVDA | Stock | 87.769 | 87.778 | 87.412 | 87.534 | 827040.0 |
| 2024-04-12 19:00:00 | NVDA | Stock | 87.537 | 87.58 | 87.312 | 87.525 | 554010.0 |
| 2024-04-12 04:00:00 | AMZN | Stock | 189.33 | 189.55 | 188.2 | 188.9 | 14088.0 |
| 2024-04-12 05:00:00 | AMZN | Stock | 188.84 | 188.91 | 188.61 | 188.77 | 10493.0 |
> showing 50 of 58,654 rows — these rows as CSV