PREVIEW / stock_1hour / 2024-08-12
file: by_date/stock_1hour/2024/2024-08-12.parquet size: 1.3 MB rows: 57,936 symbols: 854
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-08-12 04:00:00 | AAPL | Stock | 216.77 | 217.01 | 216.3 | 216.7 | 15570.0 |
| 2024-08-12 05:00:00 | AAPL | Stock | 216.79 | 216.94 | 216.75 | 216.92 | 4528.0 |
| 2024-08-12 06:00:00 | AAPL | Stock | 216.9 | 216.93 | 216.66 | 216.85 | 11761.0 |
| 2024-08-12 07:00:00 | AAPL | Stock | 216.8 | 216.99 | 216.42 | 216.8 | 22759.0 |
| 2024-08-12 08:00:00 | AAPL | Stock | 216.7 | 217.26 | 216.42 | 216.68 | 83196.0 |
| 2024-08-12 09:00:00 | AAPL | Stock | 216.72 | 217.65 | 215.6 | 216.9924 | 3919548.0 |
| 2024-08-12 10:00:00 | AAPL | Stock | 217.0 | 219.09 | 216.88 | 218.63 | 4901618.0 |
| 2024-08-12 11:00:00 | AAPL | Stock | 218.64 | 219.5099 | 217.15 | 218.7301 | 3941180.0 |
| 2024-08-12 12:00:00 | AAPL | Stock | 218.73 | 218.7574 | 217.18 | 217.19 | 2217809.0 |
| 2024-08-12 13:00:00 | AAPL | Stock | 217.19 | 217.7 | 216.47 | 216.845 | 2874660.0 |
| 2024-08-12 14:00:00 | AAPL | Stock | 216.85 | 217.42 | 216.53 | 217.3852 | 1818899.0 |
| 2024-08-12 15:00:00 | AAPL | Stock | 217.4 | 217.67 | 216.59 | 217.55 | 3644453.0 |
| 2024-08-12 16:00:00 | AAPL | Stock | 217.53 | 217.79 | 217.45 | 217.6182 | 5934452.0 |
| 2024-08-12 17:00:00 | AAPL | Stock | 217.6 | 217.68 | 217.51 | 217.53 | 31626.0 |
| 2024-08-12 18:00:00 | AAPL | Stock | 217.55 | 217.67 | 217.55 | 217.65 | 6315.0 |
| 2024-08-12 19:00:00 | AAPL | Stock | 217.6 | 217.77 | 217.53 | 217.59 | 22617.0 |
| 2024-08-12 04:00:00 | MSFT | Stock | 407.9 | 408.11 | 406.73 | 406.89 | 7990.0 |
| 2024-08-12 05:00:00 | MSFT | Stock | 407.07 | 407.93 | 407.07 | 407.85 | 3389.0 |
| 2024-08-12 06:00:00 | MSFT | Stock | 407.78 | 409.0 | 407.55 | 408.77 | 3549.0 |
| 2024-08-12 07:00:00 | MSFT | Stock | 408.38 | 408.89 | 408.0 | 408.5 | 8325.0 |
| 2024-08-12 08:00:00 | MSFT | Stock | 408.2601 | 409.0 | 408.0 | 408.0582 | 19850.0 |
| 2024-08-12 09:00:00 | MSFT | Stock | 408.38 | 408.7468 | 404.44 | 404.725 | 1208705.0 |
| 2024-08-12 10:00:00 | MSFT | Stock | 404.72 | 407.1 | 404.2434 | 407.1 | 1120060.0 |
| 2024-08-12 11:00:00 | MSFT | Stock | 407.1 | 408.34 | 404.35 | 408.32 | 1163028.0 |
| 2024-08-12 12:00:00 | MSFT | Stock | 408.32 | 408.76 | 405.85 | 405.86 | 713482.0 |
| 2024-08-12 13:00:00 | MSFT | Stock | 405.8 | 407.85 | 405.3 | 406.01 | 550052.0 |
| 2024-08-12 14:00:00 | MSFT | Stock | 406.0282 | 406.51 | 405.52 | 406.33 | 477509.0 |
| 2024-08-12 15:00:00 | MSFT | Stock | 406.29 | 407.02 | 405.13 | 406.92 | 1150002.0 |
| 2024-08-12 16:00:00 | MSFT | Stock | 406.95 | 406.96 | 405.97 | 406.2 | 2577558.0 |
| 2024-08-12 17:00:00 | MSFT | Stock | 406.31 | 406.75 | 406.2243 | 406.75 | 2564.0 |
| 2024-08-12 18:00:00 | MSFT | Stock | 406.79 | 406.9 | 406.0 | 406.0 | 11310.0 |
| 2024-08-12 19:00:00 | MSFT | Stock | 406.0 | 406.57 | 406.0 | 406.29 | 2905.0 |
| 2024-08-12 04:00:00 | NVDA | Stock | 105.45 | 106.13 | 105.1 | 105.44 | 535432.0 |
| 2024-08-12 05:00:00 | NVDA | Stock | 105.41 | 105.7 | 105.18 | 105.5 | 192449.0 |
| 2024-08-12 06:00:00 | NVDA | Stock | 105.49 | 105.64 | 105.34 | 105.45 | 196409.0 |
| 2024-08-12 07:00:00 | NVDA | Stock | 105.46 | 105.8 | 105.22 | 105.65 | 517049.0 |
| 2024-08-12 08:00:00 | NVDA | Stock | 105.44 | 106.4464 | 104.89 | 106.08 | 2311885.0 |
| 2024-08-12 09:00:00 | NVDA | Stock | 106.07 | 108.5 | 105.96 | 107.14 | 45534861.0 |
| 2024-08-12 10:00:00 | NVDA | Stock | 107.15 | 111.07 | 107.02 | 109.4403 | 65471446.0 |
| 2024-08-12 11:00:00 | NVDA | Stock | 109.45 | 110.6825 | 108.17 | 109.34 | 46511189.0 |
| 2024-08-12 12:00:00 | NVDA | Stock | 109.34 | 110.38 | 108.81 | 109.28 | 30224716.0 |
| 2024-08-12 13:00:00 | NVDA | Stock | 109.2999 | 110.26 | 109.0 | 109.59 | 24827488.0 |
| 2024-08-12 14:00:00 | NVDA | Stock | 109.6 | 110.17 | 109.36 | 110.0519 | 21007949.0 |
| 2024-08-12 15:00:00 | NVDA | Stock | 110.06 | 110.08 | 108.68 | 109.1216 | 35260623.0 |
| 2024-08-12 16:00:00 | NVDA | Stock | 109.12 | 109.18 | 108.641 | 108.76 | 19091807.0 |
| 2024-08-12 17:00:00 | NVDA | Stock | 108.75 | 109.02 | 108.75 | 108.82 | 524147.0 |
| 2024-08-12 18:00:00 | NVDA | Stock | 108.83 | 109.13 | 106.3 | 109.04 | 422767.0 |
| 2024-08-12 19:00:00 | NVDA | Stock | 109.05 | 109.06 | 108.92 | 108.9239 | 414511.0 |
| 2024-08-12 04:00:00 | AMZN | Stock | 167.91 | 168.06 | 167.7 | 167.7 | 10803.0 |
| 2024-08-12 05:00:00 | AMZN | Stock | 167.7 | 168.31 | 167.7 | 168.08 | 14066.0 |
> showing 50 of 57,936 rows — these rows as CSV