PREVIEW / stock_1hour / 2024-09-04
file: by_date/stock_1hour/2024/2024-09-04.parquet size: 1.3 MB rows: 58,045 symbols: 841
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-04 04:00:00 | AAPL | Stock | 220.1 | 220.9 | 220.1 | 220.54 | 31587.0 |
| 2024-09-04 05:00:00 | AAPL | Stock | 220.5 | 221.09 | 220.5 | 221.08 | 34203.0 |
| 2024-09-04 06:00:00 | AAPL | Stock | 221.15 | 221.48 | 220.66 | 220.75 | 12956.0 |
| 2024-09-04 07:00:00 | AAPL | Stock | 220.7 | 221.12 | 220.56 | 220.7 | 25633.0 |
| 2024-09-04 08:00:00 | AAPL | Stock | 220.65 | 222.77 | 219.67 | 221.5 | 88275.0 |
| 2024-09-04 09:00:00 | AAPL | Stock | 221.5 | 222.0 | 219.04 | 219.57 | 5232171.0 |
| 2024-09-04 10:00:00 | AAPL | Stock | 219.56 | 219.62 | 217.48 | 219.45 | 7371897.0 |
| 2024-09-04 11:00:00 | AAPL | Stock | 219.48 | 220.25 | 218.01 | 219.32 | 3541593.0 |
| 2024-09-04 12:00:00 | AAPL | Stock | 219.315 | 220.2182 | 219.08 | 220.215 | 2266714.0 |
| 2024-09-04 13:00:00 | AAPL | Stock | 220.21 | 220.91 | 219.79 | 220.875 | 2213308.0 |
| 2024-09-04 14:00:00 | AAPL | Stock | 220.875 | 221.14 | 220.4 | 220.51 | 2296901.0 |
| 2024-09-04 15:00:00 | AAPL | Stock | 220.52 | 221.4301 | 220.17 | 220.79 | 4815492.0 |
| 2024-09-04 16:00:00 | AAPL | Stock | 220.85 | 220.9 | 219.9133 | 220.67 | 4879785.0 |
| 2024-09-04 17:00:00 | AAPL | Stock | 220.66 | 220.95 | 220.65 | 220.9 | 152750.0 |
| 2024-09-04 18:00:00 | AAPL | Stock | 220.86 | 221.0 | 220.7 | 221.0 | 11273.0 |
| 2024-09-04 19:00:00 | AAPL | Stock | 220.8 | 220.8482 | 219.43 | 220.0 | 29952.0 |
| 2024-09-04 04:00:00 | MSFT | Stock | 407.0 | 407.49 | 406.54 | 406.65 | 3684.0 |
| 2024-09-04 05:00:00 | MSFT | Stock | 406.57 | 407.47 | 406.5 | 407.08 | 3296.0 |
| 2024-09-04 06:00:00 | MSFT | Stock | 406.94 | 406.94 | 405.9 | 405.9 | 1131.0 |
| 2024-09-04 07:00:00 | MSFT | Stock | 406.04 | 406.68 | 405.99 | 406.3 | 3227.0 |
| 2024-09-04 08:00:00 | MSFT | Stock | 406.15 | 409.44 | 406.0778 | 407.32 | 34530.0 |
| 2024-09-04 09:00:00 | MSFT | Stock | 407.2855 | 407.89 | 404.37 | 406.89 | 1507447.0 |
| 2024-09-04 10:00:00 | MSFT | Stock | 406.87 | 410.6 | 404.6 | 410.565 | 1619449.0 |
| 2024-09-04 11:00:00 | MSFT | Stock | 410.565 | 411.24 | 408.64 | 409.503 | 903766.0 |
| 2024-09-04 12:00:00 | MSFT | Stock | 409.48 | 410.74 | 408.66 | 409.41 | 909719.0 |
| 2024-09-04 13:00:00 | MSFT | Stock | 409.32 | 409.35 | 407.98 | 408.795 | 599648.0 |
| 2024-09-04 14:00:00 | MSFT | Stock | 408.78 | 409.69 | 408.46 | 408.925 | 540335.0 |
| 2024-09-04 15:00:00 | MSFT | Stock | 408.92 | 410.92 | 408.33 | 408.8 | 1302124.0 |
| 2024-09-04 16:00:00 | MSFT | Stock | 408.9 | 409.01 | 408.05 | 408.9358 | 2656727.0 |
| 2024-09-04 17:00:00 | MSFT | Stock | 408.9 | 409.33 | 408.8988 | 409.08 | 81570.0 |
| 2024-09-04 18:00:00 | MSFT | Stock | 409.1 | 409.25 | 408.82 | 409.25 | 4313.0 |
| 2024-09-04 19:00:00 | MSFT | Stock | 409.16 | 409.1835 | 407.15 | 408.2902 | 9308.0 |
| 2024-09-04 04:00:00 | NVDA | Stock | 105.2 | 107.48 | 104.25 | 106.78 | 1940277.0 |
| 2024-09-04 05:00:00 | NVDA | Stock | 106.77 | 107.66 | 106.51 | 107.09 | 866856.0 |
| 2024-09-04 06:00:00 | NVDA | Stock | 107.14 | 107.2 | 106.12 | 106.28 | 574910.0 |
| 2024-09-04 07:00:00 | NVDA | Stock | 106.26 | 106.45 | 105.56 | 106.08 | 1692197.0 |
| 2024-09-04 08:00:00 | NVDA | Stock | 106.1 | 108.0 | 103.7 | 106.74 | 3878698.0 |
| 2024-09-04 09:00:00 | NVDA | Stock | 106.73 | 107.9 | 104.12 | 106.94 | 67110401.0 |
| 2024-09-04 10:00:00 | NVDA | Stock | 106.95 | 109.785 | 105.51 | 109.665 | 65776864.0 |
| 2024-09-04 11:00:00 | NVDA | Stock | 109.6684 | 109.99 | 107.52 | 107.905 | 42184054.0 |
| 2024-09-04 12:00:00 | NVDA | Stock | 107.895 | 109.19 | 107.61 | 108.92 | 25860482.0 |
| 2024-09-04 13:00:00 | NVDA | Stock | 108.92 | 109.51 | 108.68 | 108.7106 | 23145318.0 |
| 2024-09-04 14:00:00 | NVDA | Stock | 108.715 | 108.77 | 106.11 | 106.1999 | 32292848.0 |
| 2024-09-04 15:00:00 | NVDA | Stock | 106.195 | 106.99 | 105.4 | 106.17 | 50084366.0 |
| 2024-09-04 16:00:00 | NVDA | Stock | 106.16 | 106.61 | 105.61 | 106.58 | 15328500.0 |
| 2024-09-04 17:00:00 | NVDA | Stock | 106.58 | 107.27 | 106.39 | 107.1292 | 1372177.0 |
| 2024-09-04 18:00:00 | NVDA | Stock | 107.12 | 107.2 | 106.65 | 107.04 | 652396.0 |
| 2024-09-04 19:00:00 | NVDA | Stock | 107.06 | 107.1 | 106.5 | 106.7 | 856066.0 |
| 2024-09-04 04:00:00 | AMZN | Stock | 175.0 | 175.42 | 174.82 | 175.25 | 6719.0 |
| 2024-09-04 05:00:00 | AMZN | Stock | 175.33 | 175.51 | 175.24 | 175.31 | 3219.0 |
> showing 50 of 58,045 rows — these rows as CSV