PREVIEW / stock_1hour / 2024-07-30
file: by_date/stock_1hour/2024/2024-07-30.parquet size: 1.3 MB rows: 58,167 symbols: 882
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-07-30 04:00:00 | AAPL | Stock | 218.42 | 219.1 | 218.42 | 218.79 | 6925.0 |
| 2024-07-30 05:00:00 | AAPL | Stock | 218.8 | 218.98 | 218.18 | 218.69 | 7939.0 |
| 2024-07-30 06:00:00 | AAPL | Stock | 218.74 | 218.99 | 218.74 | 218.99 | 10612.0 |
| 2024-07-30 07:00:00 | AAPL | Stock | 219.0 | 219.3 | 218.82 | 219.15 | 19974.0 |
| 2024-07-30 08:00:00 | AAPL | Stock | 218.9 | 219.65 | 217.65 | 219.59 | 68847.0 |
| 2024-07-30 09:00:00 | AAPL | Stock | 219.6 | 220.325 | 218.56 | 219.64 | 4011810.0 |
| 2024-07-30 10:00:00 | AAPL | Stock | 219.66 | 220.0799 | 218.04 | 218.7213 | 4453549.0 |
| 2024-07-30 11:00:00 | AAPL | Stock | 218.729 | 218.82 | 216.33 | 216.545 | 4074352.0 |
| 2024-07-30 12:00:00 | AAPL | Stock | 216.5533 | 217.2151 | 216.15 | 216.15 | 2267375.0 |
| 2024-07-30 13:00:00 | AAPL | Stock | 216.17 | 217.62 | 216.12 | 217.58 | 2193127.0 |
| 2024-07-30 14:00:00 | AAPL | Stock | 217.585 | 218.74 | 217.58 | 218.2 | 2601504.0 |
| 2024-07-30 15:00:00 | AAPL | Stock | 218.21 | 219.92 | 217.975 | 218.79 | 5459440.0 |
| 2024-07-30 16:00:00 | AAPL | Stock | 218.79 | 218.8 | 216.52 | 217.45 | 7283656.0 |
| 2024-07-30 17:00:00 | AAPL | Stock | 217.4 | 218.8 | 216.66 | 217.12 | 653683.0 |
| 2024-07-30 18:00:00 | AAPL | Stock | 217.23 | 218.15 | 217.05 | 217.61 | 82382.0 |
| 2024-07-30 19:00:00 | AAPL | Stock | 217.59 | 218.4 | 217.36 | 218.1 | 41993.0 |
| 2024-07-30 04:00:00 | MSFT | Stock | 426.7 | 426.79 | 425.5 | 426.4 | 1933.0 |
| 2024-07-30 05:00:00 | MSFT | Stock | 426.38 | 427.14 | 425.77 | 425.77 | 4527.0 |
| 2024-07-30 06:00:00 | MSFT | Stock | 425.89 | 427.08 | 425.89 | 427.0 | 3377.0 |
| 2024-07-30 07:00:00 | MSFT | Stock | 427.0 | 427.35 | 426.5 | 427.35 | 6412.0 |
| 2024-07-30 08:00:00 | MSFT | Stock | 426.99 | 427.67 | 426.23 | 427.47 | 36055.0 |
| 2024-07-30 09:00:00 | MSFT | Stock | 427.5 | 429.05 | 425.0 | 427.29 | 1725069.0 |
| 2024-07-30 10:00:00 | MSFT | Stock | 427.305 | 428.9 | 424.6901 | 424.9967 | 1451517.0 |
| 2024-07-30 11:00:00 | MSFT | Stock | 424.98 | 425.2199 | 418.7333 | 419.465 | 2048132.0 |
| 2024-07-30 12:00:00 | MSFT | Stock | 419.45 | 421.59 | 418.0 | 418.17 | 1542311.0 |
| 2024-07-30 13:00:00 | MSFT | Stock | 418.15 | 419.594 | 417.36 | 419.57 | 1973442.0 |
| 2024-07-30 14:00:00 | MSFT | Stock | 419.6012 | 421.85 | 419.27 | 420.46 | 1144780.0 |
| 2024-07-30 15:00:00 | MSFT | Stock | 420.435 | 425.2 | 419.561 | 422.42 | 2910816.0 |
| 2024-07-30 16:00:00 | MSFT | Stock | 422.92 | 425.6407 | 389.2 | 395.61 | 6936704.0 |
| 2024-07-30 17:00:00 | MSFT | Stock | 395.7269 | 401.24 | 389.99 | 393.0 | 861229.0 |
| 2024-07-30 18:00:00 | MSFT | Stock | 392.5 | 414.74 | 390.46 | 407.69 | 1489093.0 |
| 2024-07-30 19:00:00 | MSFT | Stock | 407.65 | 411.5 | 405.5 | 411.4 | 243114.0 |
| 2024-07-30 04:00:00 | NVDA | Stock | 111.3 | 112.04 | 110.82 | 111.21 | 361246.0 |
| 2024-07-30 05:00:00 | NVDA | Stock | 111.25 | 111.47 | 110.54 | 110.99 | 205673.0 |
| 2024-07-30 06:00:00 | NVDA | Stock | 110.97 | 111.28 | 110.75 | 111.2 | 126271.0 |
| 2024-07-30 07:00:00 | NVDA | Stock | 111.17 | 111.98 | 111.0 | 111.66 | 481212.0 |
| 2024-07-30 08:00:00 | NVDA | Stock | 111.22 | 112.0 | 110.2 | 111.5597 | 1392526.0 |
| 2024-07-30 09:00:00 | NVDA | Stock | 111.56 | 111.99 | 108.11 | 108.1699 | 40510163.0 |
| 2024-07-30 10:00:00 | NVDA | Stock | 108.16 | 109.16 | 106.33 | 106.725 | 66750773.0 |
| 2024-07-30 11:00:00 | NVDA | Stock | 106.72 | 106.88 | 103.91 | 104.5409 | 77396246.0 |
| 2024-07-30 12:00:00 | NVDA | Stock | 104.55 | 105.34 | 102.54 | 102.6199 | 49156234.0 |
| 2024-07-30 13:00:00 | NVDA | Stock | 102.6201 | 106.09 | 102.6201 | 105.3296 | 49974565.0 |
| 2024-07-30 14:00:00 | NVDA | Stock | 105.33 | 106.48 | 104.86 | 105.2201 | 35296953.0 |
| 2024-07-30 15:00:00 | NVDA | Stock | 105.2209 | 105.26 | 103.41 | 103.71 | 58291742.0 |
| 2024-07-30 16:00:00 | NVDA | Stock | 103.7 | 108.0 | 100.01 | 106.02 | 40013853.0 |
| 2024-07-30 17:00:00 | NVDA | Stock | 106.01 | 108.0 | 103.73 | 106.1294 | 3753047.0 |
| 2024-07-30 18:00:00 | NVDA | Stock | 106.3 | 108.989 | 106.0 | 108.51 | 4947376.0 |
| 2024-07-30 19:00:00 | NVDA | Stock | 108.51 | 109.9 | 108.2 | 109.0 | 3277354.0 |
| 2024-07-30 04:00:00 | AMZN | Stock | 183.6 | 183.97 | 183.41 | 183.86 | 5145.0 |
| 2024-07-30 05:00:00 | AMZN | Stock | 183.9 | 184.1 | 183.75 | 184.0 | 9098.0 |
> showing 50 of 58,167 rows — these rows as CSV