PREVIEW / stock_1hour / 2024-06-06
file: by_date/stock_1hour/2024/2024-06-06.parquet size: 1.3 MB rows: 59,114 symbols: 965
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-06-06 04:00:00 | AAPL | Stock | 195.65 | 196.04 | 195.65 | 195.91 | 28313.0 |
| 2024-06-06 05:00:00 | AAPL | Stock | 196.0 | 196.0 | 195.7 | 195.82 | 13137.0 |
| 2024-06-06 06:00:00 | AAPL | Stock | 195.79 | 195.96 | 195.79 | 195.92 | 10570.0 |
| 2024-06-06 07:00:00 | AAPL | Stock | 195.9 | 195.98 | 195.63 | 195.67 | 22045.0 |
| 2024-06-06 08:00:00 | AAPL | Stock | 195.9 | 196.41 | 195.6 | 195.869 | 104287.0 |
| 2024-06-06 09:00:00 | AAPL | Stock | 195.86 | 196.37 | 195.18 | 196.1101 | 4585747.0 |
| 2024-06-06 10:00:00 | AAPL | Stock | 196.13 | 196.5 | 195.44 | 195.745 | 5036153.0 |
| 2024-06-06 11:00:00 | AAPL | Stock | 195.74 | 195.89 | 195.41 | 195.53 | 2819590.0 |
| 2024-06-06 12:00:00 | AAPL | Stock | 195.535 | 195.97 | 195.4324 | 195.97 | 2300967.0 |
| 2024-06-06 13:00:00 | AAPL | Stock | 195.96 | 196.07 | 195.44 | 195.475 | 2564056.0 |
| 2024-06-06 14:00:00 | AAPL | Stock | 195.475 | 195.57 | 194.95 | 195.235 | 3104201.0 |
| 2024-06-06 15:00:00 | AAPL | Stock | 195.235 | 195.5 | 194.17 | 194.48 | 6466099.0 |
| 2024-06-06 16:00:00 | AAPL | Stock | 194.43 | 194.5 | 193.94 | 194.45 | 5708249.0 |
| 2024-06-06 17:00:00 | AAPL | Stock | 194.45 | 194.48 | 194.35 | 194.4 | 38015.0 |
| 2024-06-06 18:00:00 | AAPL | Stock | 194.46 | 194.75 | 194.4 | 194.6408 | 18247.0 |
| 2024-06-06 19:00:00 | AAPL | Stock | 194.63 | 194.76 | 194.51 | 194.59 | 11487.0 |
| 2024-06-06 04:00:00 | MSFT | Stock | 423.25 | 423.25 | 422.68 | 423.1 | 3628.0 |
| 2024-06-06 05:00:00 | MSFT | Stock | 422.83 | 423.12 | 422.8 | 422.8 | 1453.0 |
| 2024-06-06 06:00:00 | MSFT | Stock | 422.77 | 423.5 | 422.77 | 423.5 | 3763.0 |
| 2024-06-06 07:00:00 | MSFT | Stock | 423.23 | 423.4 | 422.68 | 423.0 | 3975.0 |
| 2024-06-06 08:00:00 | MSFT | Stock | 423.3 | 423.87 | 422.22 | 423.16 | 26799.0 |
| 2024-06-06 09:00:00 | MSFT | Stock | 423.11 | 425.31 | 422.59 | 423.32 | 1168632.0 |
| 2024-06-06 10:00:00 | MSFT | Stock | 423.37 | 424.11 | 422.57 | 422.86 | 1071403.0 |
| 2024-06-06 11:00:00 | MSFT | Stock | 422.83 | 423.16 | 420.58 | 421.6 | 951907.0 |
| 2024-06-06 12:00:00 | MSFT | Stock | 421.59 | 423.45 | 421.59 | 423.42 | 707465.0 |
| 2024-06-06 13:00:00 | MSFT | Stock | 423.43 | 423.54 | 422.7792 | 423.1699 | 427089.0 |
| 2024-06-06 14:00:00 | MSFT | Stock | 423.16 | 423.6 | 422.02 | 423.31 | 504227.0 |
| 2024-06-06 15:00:00 | MSFT | Stock | 423.25 | 424.7 | 423.06 | 424.49 | 1000400.0 |
| 2024-06-06 16:00:00 | MSFT | Stock | 424.45 | 424.52 | 424.0 | 424.0 | 3802700.0 |
| 2024-06-06 17:00:00 | MSFT | Stock | 424.01 | 424.3 | 424.0 | 424.3 | 1535.0 |
| 2024-06-06 18:00:00 | MSFT | Stock | 424.3 | 425.0 | 424.3 | 424.3 | 9791.0 |
| 2024-06-06 19:00:00 | MSFT | Stock | 424.49 | 424.52 | 424.32 | 424.45 | 2158.0 |
| 2024-06-06 04:00:00 | NVDA | Stock | 124.593 | 125.202 | 124.022 | 124.35 | 1066290.0 |
| 2024-06-06 05:00:00 | NVDA | Stock | 124.32 | 124.39 | 123.0 | 123.33 | 665950.0 |
| 2024-06-06 06:00:00 | NVDA | Stock | 123.359 | 124.0 | 123.359 | 123.806 | 323600.0 |
| 2024-06-06 07:00:00 | NVDA | Stock | 123.8 | 124.929 | 123.7 | 124.55 | 2896530.0 |
| 2024-06-06 08:00:00 | NVDA | Stock | 123.953 | 124.932 | 123.0 | 124.2 | 7079150.0 |
| 2024-06-06 09:00:00 | NVDA | Stock | 124.225 | 125.587 | 118.4 | 118.539 | 108431560.0 |
| 2024-06-06 10:00:00 | NVDA | Stock | 118.4601 | 122.389 | 118.4 | 121.2503 | 88893000.0 |
| 2024-06-06 11:00:00 | NVDA | Stock | 121.2 | 121.789 | 120.035 | 120.357 | 43828100.0 |
| 2024-06-06 12:00:00 | NVDA | Stock | 120.349 | 120.835 | 118.567 | 118.6741 | 46054760.0 |
| 2024-06-06 13:00:00 | NVDA | Stock | 118.675 | 120.375 | 118.32 | 119.8208 | 35773000.0 |
| 2024-06-06 14:00:00 | NVDA | Stock | 119.8335 | 120.473 | 119.162 | 120.1565 | 29362110.0 |
| 2024-06-06 15:00:00 | NVDA | Stock | 120.1555 | 121.402 | 119.5592 | 120.9415 | 46758730.0 |
| 2024-06-06 16:00:00 | NVDA | Stock | 120.941 | 121.6484 | 120.606 | 120.69 | 15357100.0 |
| 2024-06-06 17:00:00 | NVDA | Stock | 120.645 | 120.998 | 119.9019 | 119.968 | 1321070.0 |
| 2024-06-06 18:00:00 | NVDA | Stock | 119.968 | 120.479 | 119.84 | 120.4 | 575080.0 |
| 2024-06-06 19:00:00 | NVDA | Stock | 120.425 | 120.5 | 120.1 | 120.36 | 689100.0 |
| 2024-06-06 04:00:00 | AMZN | Stock | 181.39 | 181.39 | 181.04 | 181.27 | 12360.0 |
| 2024-06-06 05:00:00 | AMZN | Stock | 181.28 | 181.28 | 181.09 | 181.09 | 543.0 |
> showing 50 of 59,114 rows — these rows as CSV