PREVIEW / stock_1hour / 2024-08-20
file: by_date/stock_1hour/2024/2024-08-20.parquet size: 1.3 MB rows: 58,755 symbols: 848
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-20 04:00:00 | AAPL | Stock | 226.11 | 226.19 | 225.69 | 225.79 | 13678.0 |
| 2024-08-20 05:00:00 | AAPL | Stock | 225.81 | 226.18 | 225.81 | 226.05 | 4135.0 |
| 2024-08-20 06:00:00 | AAPL | Stock | 225.98 | 226.27 | 225.96 | 226.21 | 6028.0 |
| 2024-08-20 07:00:00 | AAPL | Stock | 226.12 | 226.16 | 225.92 | 226.0 | 8089.0 |
| 2024-08-20 08:00:00 | AAPL | Stock | 225.99 | 226.2 | 225.6705 | 225.9019 | 60624.0 |
| 2024-08-20 09:00:00 | AAPL | Stock | 225.98 | 227.17 | 225.11 | 227.02 | 3952979.0 |
| 2024-08-20 10:00:00 | AAPL | Stock | 227.02 | 227.1 | 225.71 | 225.96 | 3484822.0 |
| 2024-08-20 11:00:00 | AAPL | Stock | 225.96 | 226.9756 | 225.86 | 226.9268 | 1870552.0 |
| 2024-08-20 12:00:00 | AAPL | Stock | 226.92 | 227.1 | 226.46 | 226.52 | 1668446.0 |
| 2024-08-20 13:00:00 | AAPL | Stock | 226.53 | 226.79 | 226.11 | 226.76 | 1405034.0 |
| 2024-08-20 14:00:00 | AAPL | Stock | 226.75 | 227.11 | 226.5202 | 226.525 | 1546717.0 |
| 2024-08-20 15:00:00 | AAPL | Stock | 226.52 | 226.93 | 226.19 | 226.51 | 2976226.0 |
| 2024-08-20 16:00:00 | AAPL | Stock | 226.4334 | 226.89 | 226.4334 | 226.53 | 6233244.0 |
| 2024-08-20 17:00:00 | AAPL | Stock | 226.58 | 226.66 | 226.45 | 226.4503 | 23115.0 |
| 2024-08-20 18:00:00 | AAPL | Stock | 226.53 | 226.84 | 226.32 | 226.3584 | 20612.0 |
| 2024-08-20 19:00:00 | AAPL | Stock | 226.52 | 227.0 | 226.44 | 226.55 | 24596.0 |
| 2024-08-20 04:00:00 | MSFT | Stock | 422.69 | 423.1 | 422.03 | 422.66 | 6669.0 |
| 2024-08-20 05:00:00 | MSFT | Stock | 422.85 | 422.95 | 422.81 | 422.9 | 1330.0 |
| 2024-08-20 06:00:00 | MSFT | Stock | 422.41 | 422.94 | 422.41 | 422.6 | 1688.0 |
| 2024-08-20 07:00:00 | MSFT | Stock | 422.6 | 422.63 | 422.22 | 422.22 | 4462.0 |
| 2024-08-20 08:00:00 | MSFT | Stock | 422.6 | 423.0 | 421.25 | 421.4717 | 27637.0 |
| 2024-08-20 09:00:00 | MSFT | Stock | 421.61 | 423.61 | 421.05 | 423.4098 | 1047737.0 |
| 2024-08-20 10:00:00 | MSFT | Stock | 423.43 | 423.655 | 421.97 | 423.12 | 1160568.0 |
| 2024-08-20 11:00:00 | MSFT | Stock | 423.17 | 423.17 | 421.82 | 422.87 | 527384.0 |
| 2024-08-20 12:00:00 | MSFT | Stock | 422.9 | 424.0 | 422.36 | 423.5 | 718164.0 |
| 2024-08-20 13:00:00 | MSFT | Stock | 423.53 | 424.25 | 423.21 | 424.18 | 845127.0 |
| 2024-08-20 14:00:00 | MSFT | Stock | 424.17 | 425.86 | 424.08 | 424.93 | 923218.0 |
| 2024-08-20 15:00:00 | MSFT | Stock | 424.93 | 425.52 | 424.265 | 424.87 | 1442490.0 |
| 2024-08-20 16:00:00 | MSFT | Stock | 424.86 | 425.48 | 424.75 | 424.92 | 2605258.0 |
| 2024-08-20 17:00:00 | MSFT | Stock | 424.82 | 424.82 | 424.51 | 424.65 | 2485.0 |
| 2024-08-20 18:00:00 | MSFT | Stock | 424.8 | 424.99 | 424.5 | 424.97 | 3660.0 |
| 2024-08-20 19:00:00 | MSFT | Stock | 425.0 | 425.62 | 424.77 | 424.79 | 16710.0 |
| 2024-08-20 04:00:00 | NVDA | Stock | 129.75 | 129.98 | 128.79 | 129.06 | 597127.0 |
| 2024-08-20 05:00:00 | NVDA | Stock | 129.08 | 129.6 | 129.05 | 129.4 | 313541.0 |
| 2024-08-20 06:00:00 | NVDA | Stock | 129.39 | 129.39 | 129.1 | 129.15 | 207279.0 |
| 2024-08-20 07:00:00 | NVDA | Stock | 129.15 | 129.88 | 129.13 | 129.62 | 1377181.0 |
| 2024-08-20 08:00:00 | NVDA | Stock | 129.36 | 129.89 | 128.894 | 129.33 | 2956644.0 |
| 2024-08-20 09:00:00 | NVDA | Stock | 129.32 | 129.88 | 128.19 | 129.5 | 45672856.0 |
| 2024-08-20 10:00:00 | NVDA | Stock | 129.5 | 129.58 | 125.89 | 126.9693 | 68528130.0 |
| 2024-08-20 11:00:00 | NVDA | Stock | 126.965 | 128.4 | 126.44 | 128.37 | 32723329.0 |
| 2024-08-20 12:00:00 | NVDA | Stock | 128.37 | 128.38 | 126.82 | 126.8907 | 24980509.0 |
| 2024-08-20 13:00:00 | NVDA | Stock | 126.9 | 127.7499 | 126.53 | 127.434 | 18168320.0 |
| 2024-08-20 14:00:00 | NVDA | Stock | 127.435 | 128.56 | 127.25 | 128.1047 | 23937319.0 |
| 2024-08-20 15:00:00 | NVDA | Stock | 128.1 | 128.23 | 127.12 | 127.27 | 27092708.0 |
| 2024-08-20 16:00:00 | NVDA | Stock | 127.25 | 128.36 | 126.75 | 126.81 | 12931174.0 |
| 2024-08-20 17:00:00 | NVDA | Stock | 126.78 | 127.25 | 126.33 | 126.35 | 792720.0 |
| 2024-08-20 18:00:00 | NVDA | Stock | 126.35 | 126.84 | 126.35 | 126.4601 | 672604.0 |
| 2024-08-20 19:00:00 | NVDA | Stock | 126.5 | 126.56 | 125.8 | 125.89 | 1401758.0 |
| 2024-08-20 04:00:00 | AMZN | Stock | 178.29 | 178.79 | 178.29 | 178.75 | 23439.0 |
| 2024-08-20 05:00:00 | AMZN | Stock | 178.77 | 179.11 | 178.75 | 178.75 | 9325.0 |
> showing 50 of 58,755 rows — these rows as CSV