PREVIEW / stock_1hour / 2024-09-16
file: by_date/stock_1hour/2024/2024-09-16.parquet size: 1.3 MB rows: 59,577 symbols: 824
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-09-16 04:00:00 | AAPL | Stock | 222.2 | 222.2 | 218.34 | 219.21 | 59648.0 |
| 2024-09-16 05:00:00 | AAPL | Stock | 219.16 | 219.17 | 218.5 | 218.82 | 33215.0 |
| 2024-09-16 06:00:00 | AAPL | Stock | 218.75 | 218.9 | 217.58 | 218.2 | 98197.0 |
| 2024-09-16 07:00:00 | AAPL | Stock | 218.25 | 218.6 | 216.93 | 217.0 | 290022.0 |
| 2024-09-16 08:00:00 | AAPL | Stock | 217.0 | 221.96 | 216.75 | 217.015 | 502827.0 |
| 2024-09-16 09:00:00 | AAPL | Stock | 217.0 | 217.15 | 213.92 | 215.195 | 11667179.0 |
| 2024-09-16 10:00:00 | AAPL | Stock | 215.18 | 217.22 | 215.02 | 215.3 | 7814878.0 |
| 2024-09-16 11:00:00 | AAPL | Stock | 215.29 | 216.58 | 214.84 | 215.955 | 4824109.0 |
| 2024-09-16 12:00:00 | AAPL | Stock | 215.97 | 216.05 | 214.91 | 215.59 | 3419867.0 |
| 2024-09-16 13:00:00 | AAPL | Stock | 215.59 | 216.4 | 215.52 | 216.21 | 2764855.0 |
| 2024-09-16 14:00:00 | AAPL | Stock | 216.215 | 216.52 | 215.98 | 216.4 | 2582538.0 |
| 2024-09-16 15:00:00 | AAPL | Stock | 216.405 | 216.7 | 215.92 | 216.3 | 5506023.0 |
| 2024-09-16 16:00:00 | AAPL | Stock | 216.32 | 216.32 | 216.0 | 216.1 | 6768375.0 |
| 2024-09-16 17:00:00 | AAPL | Stock | 216.09 | 216.32 | 216.0 | 216.0376 | 125549.0 |
| 2024-09-16 18:00:00 | AAPL | Stock | 216.002 | 216.1786 | 216.0 | 216.1308 | 24546.0 |
| 2024-09-16 19:00:00 | AAPL | Stock | 216.155 | 216.25 | 216.1025 | 216.249 | 37568.0 |
| 2024-09-16 04:00:00 | MSFT | Stock | 431.35 | 431.43 | 430.6 | 431.0 | 1051.0 |
| 2024-09-16 05:00:00 | MSFT | Stock | 431.35 | 431.49 | 431.2 | 431.49 | 360.0 |
| 2024-09-16 06:00:00 | MSFT | Stock | 430.12 | 430.62 | 429.92 | 429.92 | 3104.0 |
| 2024-09-16 07:00:00 | MSFT | Stock | 429.81 | 430.78 | 429.7 | 430.01 | 5429.0 |
| 2024-09-16 08:00:00 | MSFT | Stock | 430.55 | 430.66 | 429.0058 | 429.7 | 16673.0 |
| 2024-09-16 09:00:00 | MSFT | Stock | 429.87 | 433.53 | 428.22 | 432.145 | 1445494.0 |
| 2024-09-16 10:00:00 | MSFT | Stock | 431.98 | 432.64 | 429.44 | 429.79 | 1297517.0 |
| 2024-09-16 11:00:00 | MSFT | Stock | 429.81 | 431.86 | 428.92 | 430.0 | 1173637.0 |
| 2024-09-16 12:00:00 | MSFT | Stock | 430.02 | 430.11 | 428.82 | 429.81 | 674610.0 |
| 2024-09-16 13:00:00 | MSFT | Stock | 429.79 | 431.71 | 429.3499 | 431.63 | 502548.0 |
| 2024-09-16 14:00:00 | MSFT | Stock | 431.615 | 431.65 | 430.0503 | 430.7 | 463919.0 |
| 2024-09-16 15:00:00 | MSFT | Stock | 430.68 | 431.62 | 430.2785 | 431.44 | 886779.0 |
| 2024-09-16 16:00:00 | MSFT | Stock | 431.44 | 431.53 | 431.0 | 431.0 | 2506676.0 |
| 2024-09-16 17:00:00 | MSFT | Stock | 431.09 | 434.43 | 430.753 | 433.3898 | 20440.0 |
| 2024-09-16 18:00:00 | MSFT | Stock | 433.2 | 433.99 | 432.99 | 433.8 | 44659.0 |
| 2024-09-16 19:00:00 | MSFT | Stock | 433.87 | 434.95 | 433.65 | 434.5 | 15339.0 |
| 2024-09-16 04:00:00 | NVDA | Stock | 118.85 | 119.25 | 118.5 | 118.65 | 218740.0 |
| 2024-09-16 05:00:00 | NVDA | Stock | 118.67 | 118.74 | 118.23 | 118.26 | 204278.0 |
| 2024-09-16 06:00:00 | NVDA | Stock | 118.25 | 118.3 | 117.67 | 117.95 | 413959.0 |
| 2024-09-16 07:00:00 | NVDA | Stock | 117.96 | 118.02 | 116.82 | 117.28 | 1764207.0 |
| 2024-09-16 08:00:00 | NVDA | Stock | 117.31 | 119.35 | 116.82 | 117.03 | 2946394.0 |
| 2024-09-16 09:00:00 | NVDA | Stock | 117.02 | 117.4 | 114.36 | 116.8 | 47436182.0 |
| 2024-09-16 10:00:00 | NVDA | Stock | 116.7926 | 118.18 | 116.03 | 116.5699 | 45617350.0 |
| 2024-09-16 11:00:00 | NVDA | Stock | 116.55 | 117.03 | 115.77 | 116.184 | 24907835.0 |
| 2024-09-16 12:00:00 | NVDA | Stock | 116.19 | 116.45 | 115.7109 | 116.26 | 19988193.0 |
| 2024-09-16 13:00:00 | NVDA | Stock | 116.26 | 117.075 | 116.11 | 116.89 | 16757150.0 |
| 2024-09-16 14:00:00 | NVDA | Stock | 116.89 | 116.89 | 116.1 | 116.3441 | 15984106.0 |
| 2024-09-16 15:00:00 | NVDA | Stock | 116.345 | 116.85 | 116.2 | 116.77 | 20678293.0 |
| 2024-09-16 16:00:00 | NVDA | Stock | 116.74 | 116.8 | 116.45 | 116.5894 | 15369899.0 |
| 2024-09-16 17:00:00 | NVDA | Stock | 116.533 | 116.78 | 116.42 | 116.57 | 3549750.0 |
| 2024-09-16 18:00:00 | NVDA | Stock | 116.51 | 116.7295 | 116.51 | 116.68 | 216467.0 |
| 2024-09-16 19:00:00 | NVDA | Stock | 116.66 | 116.6905 | 116.42 | 116.458 | 316535.0 |
| 2024-09-16 04:00:00 | AMZN | Stock | 185.41 | 186.81 | 185.12 | 186.81 | 5845.0 |
| 2024-09-16 05:00:00 | AMZN | Stock | 186.88 | 187.1 | 186.71 | 187.0 | 4554.0 |
> showing 50 of 59,577 rows — these rows as CSV