PREVIEW / stock_1hour / 2024-06-21
file: by_date/stock_1hour/2024/2024-06-21.parquet size: 1.3 MB rows: 57,936 symbols: 957
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-06-21 04:00:00 | AAPL | Stock | 209.47 | 209.62 | 208.67 | 209.0 | 30873.0 |
| 2024-06-21 05:00:00 | AAPL | Stock | 209.0 | 209.33 | 208.75 | 209.04 | 14209.0 |
| 2024-06-21 06:00:00 | AAPL | Stock | 209.09 | 210.3 | 209.09 | 210.15 | 17778.0 |
| 2024-06-21 07:00:00 | AAPL | Stock | 210.01 | 210.77 | 210.01 | 210.35 | 65558.0 |
| 2024-06-21 08:00:00 | AAPL | Stock | 210.3 | 211.4 | 209.0502 | 211.2 | 341711.0 |
| 2024-06-21 09:00:00 | AAPL | Stock | 211.21 | 211.95 | 209.5 | 210.43 | 19533790.0 |
| 2024-06-21 10:00:00 | AAPL | Stock | 210.44 | 211.48 | 209.58 | 211.06 | 7072582.0 |
| 2024-06-21 11:00:00 | AAPL | Stock | 211.055 | 211.63 | 210.63 | 211.2693 | 4677983.0 |
| 2024-06-21 12:00:00 | AAPL | Stock | 211.28 | 211.5 | 209.85 | 210.22 | 6771157.0 |
| 2024-06-21 13:00:00 | AAPL | Stock | 210.225 | 210.63 | 209.91 | 210.3 | 3987986.0 |
| 2024-06-21 14:00:00 | AAPL | Stock | 210.3 | 210.98 | 209.97 | 210.16 | 5367481.0 |
| 2024-06-21 15:00:00 | AAPL | Stock | 210.1699 | 210.97 | 207.11 | 207.11 | 21473345.0 |
| 2024-06-21 16:00:00 | AAPL | Stock | 207.11 | 208.49 | 207.1 | 207.65 | 114300409.0 |
| 2024-06-21 17:00:00 | AAPL | Stock | 207.63 | 207.75 | 207.47 | 207.6999 | 296163.0 |
| 2024-06-21 18:00:00 | AAPL | Stock | 207.69 | 207.7 | 207.4 | 207.42 | 149225.0 |
| 2024-06-21 19:00:00 | AAPL | Stock | 207.43 | 207.44 | 207.18 | 207.22 | 126444.0 |
| 2024-06-21 04:00:00 | MSFT | Stock | 444.6 | 444.66 | 443.95 | 444.12 | 3539.0 |
| 2024-06-21 05:00:00 | MSFT | Stock | 444.2 | 444.9 | 444.2 | 444.9 | 2062.0 |
| 2024-06-21 06:00:00 | MSFT | Stock | 444.8 | 444.8 | 444.02 | 444.56 | 1093.0 |
| 2024-06-21 07:00:00 | MSFT | Stock | 444.93 | 446.58 | 444.91 | 446.58 | 8365.0 |
| 2024-06-21 08:00:00 | MSFT | Stock | 444.84 | 447.58 | 444.2101 | 446.6 | 42338.0 |
| 2024-06-21 09:00:00 | MSFT | Stock | 446.42 | 450.3899 | 445.24 | 447.295 | 7415471.0 |
| 2024-06-21 10:00:00 | MSFT | Stock | 447.285 | 448.93 | 446.51 | 447.5915 | 1215462.0 |
| 2024-06-21 11:00:00 | MSFT | Stock | 447.6387 | 449.3 | 447.45 | 449.1529 | 1081997.0 |
| 2024-06-21 12:00:00 | MSFT | Stock | 449.185 | 449.78 | 448.54 | 448.73 | 766718.0 |
| 2024-06-21 13:00:00 | MSFT | Stock | 448.73 | 449.1538 | 448.09 | 448.8 | 581342.0 |
| 2024-06-21 14:00:00 | MSFT | Stock | 448.88 | 449.4403 | 448.46 | 449.1 | 601277.0 |
| 2024-06-21 15:00:00 | MSFT | Stock | 449.0206 | 450.58 | 448.53 | 449.78 | 1863320.0 |
| 2024-06-21 16:00:00 | MSFT | Stock | 449.78 | 450.6 | 449.78 | 450.05 | 7232318.0 |
| 2024-06-21 17:00:00 | MSFT | Stock | 450.04 | 450.2 | 449.78 | 450.2 | 111810.0 |
| 2024-06-21 18:00:00 | MSFT | Stock | 450.18 | 450.22 | 450.12 | 450.2182 | 4524.0 |
| 2024-06-21 19:00:00 | MSFT | Stock | 450.0992 | 450.2 | 449.96 | 450.2 | 5766.0 |
| 2024-06-21 04:00:00 | NVDA | Stock | 131.17 | 132.28 | 126.66 | 127.5 | 2793742.0 |
| 2024-06-21 05:00:00 | NVDA | Stock | 127.53 | 129.1 | 127.4 | 128.74 | 1521118.0 |
| 2024-06-21 06:00:00 | NVDA | Stock | 128.73 | 129.69 | 128.28 | 129.07 | 800605.0 |
| 2024-06-21 07:00:00 | NVDA | Stock | 129.09 | 129.4 | 127.76 | 127.86 | 1777150.0 |
| 2024-06-21 08:00:00 | NVDA | Stock | 128.97 | 132.64 | 127.0071 | 127.98 | 5425868.0 |
| 2024-06-21 09:00:00 | NVDA | Stock | 127.98 | 128.78 | 124.3 | 126.625 | 101063931.0 |
| 2024-06-21 10:00:00 | NVDA | Stock | 126.62 | 127.61 | 125.13 | 127.6099 | 55619069.0 |
| 2024-06-21 11:00:00 | NVDA | Stock | 127.6 | 130.12 | 127.21 | 130.09 | 50147734.0 |
| 2024-06-21 12:00:00 | NVDA | Stock | 130.09 | 130.63 | 127.31 | 127.475 | 40971388.0 |
| 2024-06-21 13:00:00 | NVDA | Stock | 127.46 | 127.97 | 126.02 | 126.16 | 33892567.0 |
| 2024-06-21 14:00:00 | NVDA | Stock | 126.16 | 126.87 | 126.1 | 126.6 | 26379774.0 |
| 2024-06-21 15:00:00 | NVDA | Stock | 126.58 | 127.19 | 125.08 | 127.06 | 51948782.0 |
| 2024-06-21 16:00:00 | NVDA | Stock | 127.05 | 127.18 | 126.39 | 126.99 | 117470683.0 |
| 2024-06-21 17:00:00 | NVDA | Stock | 126.97 | 127.05 | 126.41 | 126.56 | 1186890.0 |
| 2024-06-21 18:00:00 | NVDA | Stock | 126.57 | 126.88 | 126.51 | 126.82 | 410911.0 |
| 2024-06-21 19:00:00 | NVDA | Stock | 126.82 | 127.0 | 126.54 | 127.0 | 717806.0 |
| 2024-06-21 04:00:00 | AMZN | Stock | 185.94 | 186.0 | 185.19 | 185.3 | 9433.0 |
| 2024-06-21 05:00:00 | AMZN | Stock | 185.36 | 185.84 | 185.34 | 185.74 | 8924.0 |
> showing 50 of 57,936 rows — these rows as CSV