PREVIEW / stock_1hour / 2024-06-26
file: by_date/stock_1hour/2024/2024-06-26.parquet size: 1.3 MB rows: 58,257 symbols: 914
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-26 04:00:00 | AAPL | Stock | 209.35 | 210.09 | 209.35 | 209.9 | 25507.0 |
| 2024-06-26 05:00:00 | AAPL | Stock | 209.73 | 209.86 | 209.7 | 209.7 | 2119.0 |
| 2024-06-26 06:00:00 | AAPL | Stock | 209.7 | 211.64 | 209.5 | 211.0 | 96790.0 |
| 2024-06-26 07:00:00 | AAPL | Stock | 211.0 | 211.2 | 210.53 | 211.15 | 90239.0 |
| 2024-06-26 08:00:00 | AAPL | Stock | 210.9 | 211.15 | 209.11 | 210.38 | 267625.0 |
| 2024-06-26 09:00:00 | AAPL | Stock | 210.3969 | 212.4 | 210.3 | 211.53 | 7102159.0 |
| 2024-06-26 10:00:00 | AAPL | Stock | 211.49 | 213.43 | 211.37 | 213.195 | 8491227.0 |
| 2024-06-26 11:00:00 | AAPL | Stock | 213.195 | 214.44 | 213.03 | 214.27 | 6128776.0 |
| 2024-06-26 12:00:00 | AAPL | Stock | 214.26 | 214.78 | 213.265 | 213.83 | 4629771.0 |
| 2024-06-26 13:00:00 | AAPL | Stock | 213.83 | 214.06 | 213.23 | 214.0122 | 3014609.0 |
| 2024-06-26 14:00:00 | AAPL | Stock | 214.01 | 214.86 | 213.945 | 214.15 | 4806191.0 |
| 2024-06-26 15:00:00 | AAPL | Stock | 214.15 | 214.16 | 212.72 | 213.1 | 7223963.0 |
| 2024-06-26 16:00:00 | AAPL | Stock | 213.25 | 213.3 | 212.89 | 213.22 | 9379236.0 |
| 2024-06-26 17:00:00 | AAPL | Stock | 213.23 | 213.25 | 212.93 | 212.95 | 1520675.0 |
| 2024-06-26 18:00:00 | AAPL | Stock | 212.96 | 213.08 | 212.5 | 212.65 | 29530.0 |
| 2024-06-26 19:00:00 | AAPL | Stock | 212.61 | 213.0 | 212.6 | 212.8 | 60251.0 |
| 2024-06-26 04:00:00 | MSFT | Stock | 452.45 | 452.45 | 451.79 | 452.0 | 867.0 |
| 2024-06-26 05:00:00 | MSFT | Stock | 451.27 | 451.31 | 451.1 | 451.3 | 604.0 |
| 2024-06-26 06:00:00 | MSFT | Stock | 450.65 | 451.0 | 450.64 | 450.85 | 1840.0 |
| 2024-06-26 07:00:00 | MSFT | Stock | 450.85 | 450.85 | 449.38 | 449.71 | 4938.0 |
| 2024-06-26 08:00:00 | MSFT | Stock | 450.71 | 452.36 | 449.39 | 449.71 | 27863.0 |
| 2024-06-26 09:00:00 | MSFT | Stock | 449.6 | 450.804 | 447.8 | 450.43 | 1170740.0 |
| 2024-06-26 10:00:00 | MSFT | Stock | 450.5 | 453.5885 | 450.08 | 453.105 | 1223049.0 |
| 2024-06-26 11:00:00 | MSFT | Stock | 453.09 | 453.6 | 451.65 | 453.38 | 832918.0 |
| 2024-06-26 12:00:00 | MSFT | Stock | 453.3776 | 453.3821 | 452.2 | 452.63 | 598378.0 |
| 2024-06-26 13:00:00 | MSFT | Stock | 452.575 | 452.78 | 451.32 | 452.0896 | 525667.0 |
| 2024-06-26 14:00:00 | MSFT | Stock | 452.05 | 452.19 | 450.87 | 451.62 | 623277.0 |
| 2024-06-26 15:00:00 | MSFT | Stock | 451.63 | 452.59 | 450.87 | 452.12 | 918394.0 |
| 2024-06-26 16:00:00 | MSFT | Stock | 452.09 | 452.2612 | 450.8 | 451.49 | 3578693.0 |
| 2024-06-26 17:00:00 | MSFT | Stock | 451.86 | 451.95 | 451.5245 | 451.95 | 2185.0 |
| 2024-06-26 18:00:00 | MSFT | Stock | 451.8914 | 452.16 | 451.61 | 451.7 | 1694.0 |
| 2024-06-26 19:00:00 | MSFT | Stock | 451.8 | 451.8382 | 450.89 | 451.3 | 6446.0 |
| 2024-06-26 04:00:00 | NVDA | Stock | 129.2 | 129.74 | 128.3 | 129.27 | 1167776.0 |
| 2024-06-26 05:00:00 | NVDA | Stock | 129.28 | 129.35 | 128.5 | 128.78 | 545564.0 |
| 2024-06-26 06:00:00 | NVDA | Stock | 128.75 | 129.04 | 128.37 | 128.44 | 486817.0 |
| 2024-06-26 07:00:00 | NVDA | Stock | 128.41 | 129.43 | 128.31 | 129.25 | 1968487.0 |
| 2024-06-26 08:00:00 | NVDA | Stock | 129.24 | 129.95 | 126.3 | 126.4113 | 8773547.0 |
| 2024-06-26 09:00:00 | NVDA | Stock | 126.42 | 127.39 | 124.25 | 126.72 | 48597571.0 |
| 2024-06-26 10:00:00 | NVDA | Stock | 126.73 | 128.12 | 123.94 | 124.01 | 58244080.0 |
| 2024-06-26 11:00:00 | NVDA | Stock | 124.02 | 124.71 | 122.6 | 124.47 | 47994959.0 |
| 2024-06-26 12:00:00 | NVDA | Stock | 124.4697 | 124.99 | 123.12 | 123.52 | 30246454.0 |
| 2024-06-26 13:00:00 | NVDA | Stock | 123.5 | 124.22 | 123.35 | 124.04 | 20380441.0 |
| 2024-06-26 14:00:00 | NVDA | Stock | 124.04 | 124.0487 | 122.88 | 122.9597 | 20981482.0 |
| 2024-06-26 15:00:00 | NVDA | Stock | 122.96 | 126.48 | 122.86 | 126.42 | 39667360.0 |
| 2024-06-26 16:00:00 | NVDA | Stock | 126.4 | 126.56 | 123.8183 | 124.88 | 22534402.0 |
| 2024-06-26 17:00:00 | NVDA | Stock | 124.89 | 125.5201 | 124.5 | 124.68 | 1217942.0 |
| 2024-06-26 18:00:00 | NVDA | Stock | 124.6798 | 126.4 | 124.01 | 124.03 | 885143.0 |
| 2024-06-26 19:00:00 | NVDA | Stock | 124.04 | 124.24 | 123.5833 | 123.9496 | 1131739.0 |
| 2024-06-26 04:00:00 | AMZN | Stock | 188.02 | 188.02 | 187.47 | 187.6 | 9298.0 |
| 2024-06-26 05:00:00 | AMZN | Stock | 187.6 | 187.67 | 187.51 | 187.6 | 5023.0 |
> showing 50 of 58,257 rows — these rows as CSV