PREVIEW / stock_1hour / 2024-06-13
file: by_date/stock_1hour/2024/2024-06-13.parquet size: 1.3 MB rows: 58,759 symbols: 969
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-13 04:00:00 | AAPL | Stock | 214.52 | 215.25 | 213.71 | 214.19 | 93621.0 |
| 2024-06-13 05:00:00 | AAPL | Stock | 214.26 | 214.29 | 213.07 | 213.5 | 52389.0 |
| 2024-06-13 06:00:00 | AAPL | Stock | 213.45 | 213.51 | 213.1 | 213.23 | 46369.0 |
| 2024-06-13 07:00:00 | AAPL | Stock | 213.24 | 213.55 | 212.49 | 213.0 | 110655.0 |
| 2024-06-13 08:00:00 | AAPL | Stock | 213.43 | 215.33 | 212.46 | 213.93 | 1295169.0 |
| 2024-06-13 09:00:00 | AAPL | Stock | 213.94 | 216.75 | 213.3 | 214.73 | 16683050.0 |
| 2024-06-13 10:00:00 | AAPL | Stock | 214.75 | 214.98 | 212.82 | 212.8601 | 10637408.0 |
| 2024-06-13 11:00:00 | AAPL | Stock | 212.88 | 214.0618 | 212.17 | 213.74 | 8075355.0 |
| 2024-06-13 12:00:00 | AAPL | Stock | 213.745 | 213.745 | 211.6 | 212.296 | 7455545.0 |
| 2024-06-13 13:00:00 | AAPL | Stock | 212.29 | 213.79 | 212.23 | 212.6937 | 5090980.0 |
| 2024-06-13 14:00:00 | AAPL | Stock | 212.7 | 214.1399 | 212.57 | 213.98 | 5390949.0 |
| 2024-06-13 15:00:00 | AAPL | Stock | 213.97 | 214.88 | 213.22 | 214.13 | 11103651.0 |
| 2024-06-13 16:00:00 | AAPL | Stock | 214.12 | 215.0997 | 214.07 | 214.71 | 9402036.0 |
| 2024-06-13 17:00:00 | AAPL | Stock | 214.71 | 214.74 | 214.24 | 214.5 | 401426.0 |
| 2024-06-13 18:00:00 | AAPL | Stock | 214.46 | 214.503 | 214.23 | 214.38 | 38859.0 |
| 2024-06-13 19:00:00 | AAPL | Stock | 214.4 | 214.6 | 214.0403 | 214.6 | 53448.0 |
| 2024-06-13 04:00:00 | MSFT | Stock | 441.0 | 442.0 | 440.0 | 440.33 | 8637.0 |
| 2024-06-13 05:00:00 | MSFT | Stock | 440.42 | 440.53 | 438.0 | 438.85 | 7433.0 |
| 2024-06-13 06:00:00 | MSFT | Stock | 438.96 | 439.54 | 438.91 | 439.37 | 3067.0 |
| 2024-06-13 07:00:00 | MSFT | Stock | 440.0 | 440.25 | 439.05 | 439.05 | 11655.0 |
| 2024-06-13 08:00:00 | MSFT | Stock | 439.69 | 442.85 | 439.0167 | 440.0 | 63811.0 |
| 2024-06-13 09:00:00 | MSFT | Stock | 439.5 | 443.06 | 439.2201 | 441.7023 | 1580233.0 |
| 2024-06-13 10:00:00 | MSFT | Stock | 441.64 | 442.97 | 440.44 | 442.18 | 1327586.0 |
| 2024-06-13 11:00:00 | MSFT | Stock | 442.27 | 443.39 | 442.08 | 442.25 | 975487.0 |
| 2024-06-13 12:00:00 | MSFT | Stock | 442.29 | 442.3 | 439.6603 | 441.42 | 786022.0 |
| 2024-06-13 13:00:00 | MSFT | Stock | 441.45 | 441.9 | 440.52 | 440.55 | 540593.0 |
| 2024-06-13 14:00:00 | MSFT | Stock | 440.62 | 441.5085 | 440.375 | 440.51 | 522916.0 |
| 2024-06-13 15:00:00 | MSFT | Stock | 440.49 | 442.13 | 440.21 | 441.4 | 1572064.0 |
| 2024-06-13 16:00:00 | MSFT | Stock | 441.58 | 442.18 | 440.5 | 440.79 | 3354639.0 |
| 2024-06-13 17:00:00 | MSFT | Stock | 440.8 | 441.58 | 440.2 | 440.27 | 15081.0 |
| 2024-06-13 18:00:00 | MSFT | Stock | 440.0 | 440.3629 | 439.0 | 439.7005 | 8684.0 |
| 2024-06-13 19:00:00 | MSFT | Stock | 439.75 | 440.5751 | 439.75 | 439.9387 | 2967.0 |
| 2024-06-13 04:00:00 | NVDA | Stock | 127.63 | 128.37 | 126.72 | 128.29 | 786036.0 |
| 2024-06-13 05:00:00 | NVDA | Stock | 128.3 | 128.3 | 127.5 | 127.56 | 483221.0 |
| 2024-06-13 06:00:00 | NVDA | Stock | 127.55 | 127.9 | 127.55 | 127.65 | 203591.0 |
| 2024-06-13 07:00:00 | NVDA | Stock | 127.66 | 128.0 | 127.53 | 127.825 | 994209.0 |
| 2024-06-13 08:00:00 | NVDA | Stock | 127.65 | 129.1798 | 126.5 | 128.73 | 5828305.0 |
| 2024-06-13 09:00:00 | NVDA | Stock | 128.7495 | 129.74 | 128.1608 | 129.16 | 45872526.0 |
| 2024-06-13 10:00:00 | NVDA | Stock | 129.1671 | 129.61 | 127.4 | 127.63 | 42845949.0 |
| 2024-06-13 11:00:00 | NVDA | Stock | 127.632 | 129.05 | 127.6 | 128.8 | 23035748.0 |
| 2024-06-13 12:00:00 | NVDA | Stock | 128.79 | 128.87 | 127.16 | 127.67 | 22059533.0 |
| 2024-06-13 13:00:00 | NVDA | Stock | 127.6501 | 128.855 | 127.56 | 128.615 | 15414152.0 |
| 2024-06-13 14:00:00 | NVDA | Stock | 128.63 | 129.62 | 128.38 | 129.43 | 19899487.0 |
| 2024-06-13 15:00:00 | NVDA | Stock | 129.425 | 129.8 | 128.9 | 129.37 | 30736658.0 |
| 2024-06-13 16:00:00 | NVDA | Stock | 129.0 | 129.75 | 129.0 | 129.62 | 20582474.0 |
| 2024-06-13 17:00:00 | NVDA | Stock | 129.64 | 129.69 | 129.35 | 129.37 | 544842.0 |
| 2024-06-13 18:00:00 | NVDA | Stock | 129.36 | 129.61 | 129.33 | 129.4099 | 410705.0 |
| 2024-06-13 19:00:00 | NVDA | Stock | 129.41 | 129.85 | 129.36 | 129.79 | 806399.0 |
| 2024-06-13 04:00:00 | AMZN | Stock | 186.61 | 186.77 | 186.25 | 186.25 | 8112.0 |
| 2024-06-13 05:00:00 | AMZN | Stock | 186.1 | 186.33 | 186.0 | 186.1 | 3109.0 |
> showing 50 of 58,759 rows — these rows as CSV