PREVIEW / stock_1hour / 2024-07-08
file: by_date/stock_1hour/2024/2024-07-08.parquet size: 1.3 MB rows: 58,846 symbols: 923
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-07-08 04:00:00 | AAPL | Stock | 227.6 | 227.6 | 226.61 | 227.5 | 23377.0 |
| 2024-07-08 05:00:00 | AAPL | Stock | 227.36 | 227.55 | 227.13 | 227.16 | 9434.0 |
| 2024-07-08 06:00:00 | AAPL | Stock | 227.23 | 227.27 | 227.07 | 227.1 | 7195.0 |
| 2024-07-08 07:00:00 | AAPL | Stock | 227.1 | 227.88 | 226.88 | 227.84 | 55089.0 |
| 2024-07-08 08:00:00 | AAPL | Stock | 227.0 | 228.21 | 225.775 | 227.48 | 288568.0 |
| 2024-07-08 09:00:00 | AAPL | Stock | 227.48 | 227.5 | 223.4 | 223.67 | 8846339.0 |
| 2024-07-08 10:00:00 | AAPL | Stock | 223.67 | 225.82 | 223.25 | 225.42 | 6948439.0 |
| 2024-07-08 11:00:00 | AAPL | Stock | 225.43 | 227.01 | 225.4001 | 226.5 | 5570294.0 |
| 2024-07-08 12:00:00 | AAPL | Stock | 226.49 | 226.77 | 225.79 | 226.68 | 3150275.0 |
| 2024-07-08 13:00:00 | AAPL | Stock | 226.69 | 227.07 | 226.26 | 226.46 | 3152929.0 |
| 2024-07-08 14:00:00 | AAPL | Stock | 226.45 | 227.45 | 226.4 | 226.976 | 3877659.0 |
| 2024-07-08 15:00:00 | AAPL | Stock | 226.975 | 227.85 | 226.725 | 227.8 | 7011353.0 |
| 2024-07-08 16:00:00 | AAPL | Stock | 227.82 | 227.88 | 227.58 | 227.65 | 6387774.0 |
| 2024-07-08 17:00:00 | AAPL | Stock | 227.64 | 227.95 | 227.54 | 227.95 | 140051.0 |
| 2024-07-08 18:00:00 | AAPL | Stock | 227.9 | 227.98 | 227.81 | 227.86 | 26977.0 |
| 2024-07-08 19:00:00 | AAPL | Stock | 227.9176 | 228.49 | 227.88 | 228.39 | 61484.0 |
| 2024-07-08 04:00:00 | MSFT | Stock | 469.15 | 469.28 | 468.21 | 468.21 | 2465.0 |
| 2024-07-08 05:00:00 | MSFT | Stock | 468.5 | 468.76 | 468.5 | 468.76 | 1405.0 |
| 2024-07-08 06:00:00 | MSFT | Stock | 468.7 | 468.7 | 468.5 | 468.5 | 1210.0 |
| 2024-07-08 07:00:00 | MSFT | Stock | 468.2 | 468.75 | 467.65 | 468.01 | 7199.0 |
| 2024-07-08 08:00:00 | MSFT | Stock | 467.63 | 469.55 | 466.392 | 467.35 | 32701.0 |
| 2024-07-08 09:00:00 | MSFT | Stock | 467.14 | 467.92 | 464.7656 | 466.63 | 1220299.0 |
| 2024-07-08 10:00:00 | MSFT | Stock | 466.66 | 466.82 | 464.46 | 465.5236 | 1066100.0 |
| 2024-07-08 11:00:00 | MSFT | Stock | 465.5078 | 466.85 | 465.17 | 466.325 | 669447.0 |
| 2024-07-08 12:00:00 | MSFT | Stock | 466.39 | 466.41 | 465.16 | 465.53 | 423057.0 |
| 2024-07-08 13:00:00 | MSFT | Stock | 465.53 | 465.73 | 464.86 | 465.35 | 462339.0 |
| 2024-07-08 14:00:00 | MSFT | Stock | 465.28 | 466.0 | 464.9503 | 465.59 | 533825.0 |
| 2024-07-08 15:00:00 | MSFT | Stock | 465.58 | 466.53 | 464.76 | 466.29 | 1250778.0 |
| 2024-07-08 16:00:00 | MSFT | Stock | 466.24 | 466.4 | 465.38 | 466.28 | 2460317.0 |
| 2024-07-08 17:00:00 | MSFT | Stock | 466.26 | 466.4899 | 466.1313 | 466.1313 | 1369.0 |
| 2024-07-08 18:00:00 | MSFT | Stock | 465.9883 | 466.48 | 465.9883 | 466.33 | 1320.0 |
| 2024-07-08 19:00:00 | MSFT | Stock | 466.2092 | 467.98 | 466.2092 | 467.4547 | 16706.0 |
| 2024-07-08 04:00:00 | NVDA | Stock | 125.65 | 126.38 | 124.77 | 125.02 | 323725.0 |
| 2024-07-08 05:00:00 | NVDA | Stock | 125.03 | 125.26 | 124.88 | 125.05 | 134294.0 |
| 2024-07-08 06:00:00 | NVDA | Stock | 125.03 | 125.89 | 125.03 | 125.68 | 248811.0 |
| 2024-07-08 07:00:00 | NVDA | Stock | 125.61 | 126.99 | 125.5 | 126.77 | 995399.0 |
| 2024-07-08 08:00:00 | NVDA | Stock | 125.74 | 126.99 | 124.59 | 126.9 | 2247539.0 |
| 2024-07-08 09:00:00 | NVDA | Stock | 126.91 | 130.77 | 125.83 | 130.52 | 47212982.0 |
| 2024-07-08 10:00:00 | NVDA | Stock | 130.5133 | 130.59 | 127.14 | 127.589 | 47270950.0 |
| 2024-07-08 11:00:00 | NVDA | Stock | 127.5701 | 129.19 | 127.37 | 129.14 | 25074307.0 |
| 2024-07-08 12:00:00 | NVDA | Stock | 129.13 | 129.14 | 127.65 | 128.09 | 16733671.0 |
| 2024-07-08 13:00:00 | NVDA | Stock | 128.1 | 129.17 | 127.98 | 128.97 | 14416260.0 |
| 2024-07-08 14:00:00 | NVDA | Stock | 128.97 | 129.2 | 128.23 | 128.71 | 13232597.0 |
| 2024-07-08 15:00:00 | NVDA | Stock | 128.71 | 128.71 | 127.68 | 128.19 | 23026569.0 |
| 2024-07-08 16:00:00 | NVDA | Stock | 128.17 | 128.5847 | 128.03 | 128.15 | 13286886.0 |
| 2024-07-08 17:00:00 | NVDA | Stock | 128.14 | 128.21 | 128.1 | 128.11 | 275090.0 |
| 2024-07-08 18:00:00 | NVDA | Stock | 128.1 | 128.39 | 128.06 | 128.27 | 333034.0 |
| 2024-07-08 19:00:00 | NVDA | Stock | 128.25 | 128.9 | 128.22 | 128.68 | 667418.0 |
| 2024-07-08 04:00:00 | AMZN | Stock | 200.07 | 200.27 | 199.95 | 200.21 | 3185.0 |
| 2024-07-08 05:00:00 | AMZN | Stock | 200.22 | 200.5 | 200.0 | 200.0 | 6424.0 |
> showing 50 of 58,846 rows — these rows as CSV