PREVIEW / stock_1hour / 2024-09-27
file: by_date/stock_1hour/2024/2024-09-27.parquet size: 1.3 MB rows: 59,447 symbols: 770
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-27 04:00:00 | AAPL | Stock | 226.4 | 227.62 | 226.11 | 227.24 | 16216.0 |
| 2024-09-27 05:00:00 | AAPL | Stock | 227.24 | 228.11 | 227.0 | 228.11 | 19595.0 |
| 2024-09-27 06:00:00 | AAPL | Stock | 227.92 | 228.09 | 227.52 | 227.72 | 8868.0 |
| 2024-09-27 07:00:00 | AAPL | Stock | 227.68 | 228.11 | 227.62 | 228.01 | 7383.0 |
| 2024-09-27 08:00:00 | AAPL | Stock | 227.69 | 228.5 | 226.89 | 228.0195 | 86005.0 |
| 2024-09-27 09:00:00 | AAPL | Stock | 228.04 | 229.51 | 227.9 | 228.8 | 3303864.0 |
| 2024-09-27 10:00:00 | AAPL | Stock | 228.81 | 229.52 | 228.5 | 228.64 | 3296301.0 |
| 2024-09-27 11:00:00 | AAPL | Stock | 228.64 | 228.7106 | 227.3 | 227.51 | 2487514.0 |
| 2024-09-27 12:00:00 | AAPL | Stock | 227.51 | 228.34 | 227.44 | 228.33 | 1441997.0 |
| 2024-09-27 13:00:00 | AAPL | Stock | 228.34 | 228.62 | 227.81 | 228.365 | 1379837.0 |
| 2024-09-27 14:00:00 | AAPL | Stock | 228.36 | 228.52 | 227.53 | 228.1066 | 1528977.0 |
| 2024-09-27 15:00:00 | AAPL | Stock | 228.12 | 228.13 | 227.55 | 227.82 | 3228134.0 |
| 2024-09-27 16:00:00 | AAPL | Stock | 227.79 | 227.79 | 227.42 | 227.5985 | 6919770.0 |
| 2024-09-27 17:00:00 | AAPL | Stock | 227.57 | 227.65 | 227.486 | 227.57 | 14615.0 |
| 2024-09-27 18:00:00 | AAPL | Stock | 227.505 | 227.59 | 227.49 | 227.57 | 1799.0 |
| 2024-09-27 19:00:00 | AAPL | Stock | 227.5 | 227.55 | 227.14 | 227.4982 | 22195.0 |
| 2024-09-27 04:00:00 | MSFT | Stock | 430.0 | 431.0 | 429.15 | 430.5 | 5820.0 |
| 2024-09-27 05:00:00 | MSFT | Stock | 430.4 | 430.4 | 430.09 | 430.09 | 340.0 |
| 2024-09-27 06:00:00 | MSFT | Stock | 430.39 | 431.04 | 430.39 | 430.87 | 1209.0 |
| 2024-09-27 07:00:00 | MSFT | Stock | 430.81 | 431.4 | 430.65 | 431.31 | 2302.0 |
| 2024-09-27 08:00:00 | MSFT | Stock | 430.8 | 432.74 | 430.6 | 432.62 | 20360.0 |
| 2024-09-27 09:00:00 | MSFT | Stock | 432.52 | 432.95 | 429.9 | 430.76 | 857430.0 |
| 2024-09-27 10:00:00 | MSFT | Stock | 430.78 | 431.85 | 430.455 | 430.83 | 814659.0 |
| 2024-09-27 11:00:00 | MSFT | Stock | 430.8288 | 431.07 | 428.25 | 428.295 | 702593.0 |
| 2024-09-27 12:00:00 | MSFT | Stock | 428.28 | 429.13 | 427.47 | 429.07 | 693125.0 |
| 2024-09-27 13:00:00 | MSFT | Stock | 429.04 | 429.95 | 428.72 | 429.93 | 364572.0 |
| 2024-09-27 14:00:00 | MSFT | Stock | 429.92 | 430.14 | 427.9 | 428.84 | 631955.0 |
| 2024-09-27 15:00:00 | MSFT | Stock | 428.86 | 429.21 | 427.54 | 428.03 | 1363019.0 |
| 2024-09-27 16:00:00 | MSFT | Stock | 428.02 | 428.02 | 427.35 | 427.39 | 3977794.0 |
| 2024-09-27 17:00:00 | MSFT | Stock | 427.54 | 427.55 | 427.48 | 427.55 | 1500.0 |
| 2024-09-27 18:00:00 | MSFT | Stock | 427.6404 | 427.6404 | 427.45 | 427.45 | 350.0 |
| 2024-09-27 19:00:00 | MSFT | Stock | 427.37 | 427.4 | 427.3001 | 427.3797 | 2159.0 |
| 2024-09-27 04:00:00 | NVDA | Stock | 122.52 | 122.95 | 122.15 | 122.53 | 589696.0 |
| 2024-09-27 05:00:00 | NVDA | Stock | 122.56 | 122.69 | 122.23 | 122.66 | 301638.0 |
| 2024-09-27 06:00:00 | NVDA | Stock | 122.66 | 122.72 | 122.35 | 122.66 | 144717.0 |
| 2024-09-27 07:00:00 | NVDA | Stock | 122.66 | 123.49 | 122.63 | 123.47 | 674030.0 |
| 2024-09-27 08:00:00 | NVDA | Stock | 122.66 | 124.49 | 122.2676 | 124.21 | 3563990.0 |
| 2024-09-27 09:00:00 | NVDA | Stock | 124.23 | 124.25 | 122.245 | 122.7699 | 29330334.0 |
| 2024-09-27 10:00:00 | NVDA | Stock | 122.77 | 122.98 | 120.35 | 121.17 | 49082430.0 |
| 2024-09-27 11:00:00 | NVDA | Stock | 121.16 | 121.19 | 119.82 | 120.62 | 34573700.0 |
| 2024-09-27 12:00:00 | NVDA | Stock | 120.62 | 121.18 | 120.27 | 120.76 | 19770870.0 |
| 2024-09-27 13:00:00 | NVDA | Stock | 120.765 | 121.09 | 120.13 | 120.78 | 17914564.0 |
| 2024-09-27 14:00:00 | NVDA | Stock | 120.78 | 120.96 | 119.26 | 120.191 | 28402270.0 |
| 2024-09-27 15:00:00 | NVDA | Stock | 120.195 | 121.97 | 119.93 | 121.4 | 33692148.0 |
| 2024-09-27 16:00:00 | NVDA | Stock | 121.39 | 121.45 | 120.88 | 120.98 | 17966075.0 |
| 2024-09-27 17:00:00 | NVDA | Stock | 120.98 | 121.4 | 120.95 | 120.9699 | 1316071.0 |
| 2024-09-27 18:00:00 | NVDA | Stock | 120.96 | 120.98 | 120.73 | 120.73 | 371023.0 |
| 2024-09-27 19:00:00 | NVDA | Stock | 120.74 | 120.81 | 120.5 | 120.5601 | 396860.0 |
| 2024-09-27 04:00:00 | AMZN | Stock | 191.3 | 191.3 | 190.5 | 190.85 | 10075.0 |
| 2024-09-27 05:00:00 | AMZN | Stock | 191.0 | 191.0 | 190.86 | 191.0 | 3586.0 |
> showing 50 of 59,447 rows — these rows as CSV