PREVIEW / stock_1hour / 2024-08-21
file: by_date/stock_1hour/2024/2024-08-21.parquet size: 1.3 MB rows: 58,335 symbols: 845
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-21 04:00:00 | AAPL | Stock | 225.89 | 226.89 | 225.89 | 226.73 | 3717.0 |
| 2024-08-21 05:00:00 | AAPL | Stock | 226.63 | 226.69 | 226.5 | 226.58 | 3315.0 |
| 2024-08-21 06:00:00 | AAPL | Stock | 226.6 | 227.01 | 226.55 | 227.01 | 6386.0 |
| 2024-08-21 07:00:00 | AAPL | Stock | 226.99 | 227.0 | 226.72 | 226.92 | 11200.0 |
| 2024-08-21 08:00:00 | AAPL | Stock | 227.0 | 227.08 | 225.944 | 226.84 | 51917.0 |
| 2024-08-21 09:00:00 | AAPL | Stock | 226.84 | 227.07 | 225.91 | 227.06 | 2933737.0 |
| 2024-08-21 10:00:00 | AAPL | Stock | 227.07 | 227.98 | 225.87 | 226.28 | 4401865.0 |
| 2024-08-21 11:00:00 | AAPL | Stock | 226.26 | 226.98 | 225.758 | 226.21 | 2387190.0 |
| 2024-08-21 12:00:00 | AAPL | Stock | 226.205 | 226.504 | 225.635 | 226.42 | 1725345.0 |
| 2024-08-21 13:00:00 | AAPL | Stock | 226.42 | 226.46 | 225.83 | 226.15 | 1658485.0 |
| 2024-08-21 14:00:00 | AAPL | Stock | 226.17 | 226.58 | 225.86 | 226.416 | 1928017.0 |
| 2024-08-21 15:00:00 | AAPL | Stock | 226.41 | 226.56 | 225.05 | 226.36 | 4075161.0 |
| 2024-08-21 16:00:00 | AAPL | Stock | 226.4 | 226.73 | 226.38 | 226.64 | 5410409.0 |
| 2024-08-21 17:00:00 | AAPL | Stock | 226.65 | 226.67 | 226.0933 | 226.6663 | 9221.0 |
| 2024-08-21 18:00:00 | AAPL | Stock | 226.69 | 226.8492 | 226.57 | 226.65 | 7902.0 |
| 2024-08-21 19:00:00 | AAPL | Stock | 226.74 | 226.79 | 226.59 | 226.59 | 20442.0 |
| 2024-08-21 04:00:00 | MSFT | Stock | 421.53 | 425.24 | 421.53 | 424.68 | 5061.0 |
| 2024-08-21 05:00:00 | MSFT | Stock | 424.4 | 426.21 | 424.4 | 426.0 | 5049.0 |
| 2024-08-21 06:00:00 | MSFT | Stock | 425.53 | 426.0 | 425.53 | 425.81 | 1191.0 |
| 2024-08-21 07:00:00 | MSFT | Stock | 425.72 | 426.21 | 424.8 | 424.91 | 14992.0 |
| 2024-08-21 08:00:00 | MSFT | Stock | 425.8 | 425.9999 | 424.65 | 425.6 | 18295.0 |
| 2024-08-21 09:00:00 | MSFT | Stock | 425.7 | 425.9 | 422.62 | 423.595 | 1033550.0 |
| 2024-08-21 10:00:00 | MSFT | Stock | 423.65 | 426.4 | 423.07 | 423.69 | 1298586.0 |
| 2024-08-21 11:00:00 | MSFT | Stock | 423.64 | 424.71 | 421.96 | 422.33 | 789166.0 |
| 2024-08-21 12:00:00 | MSFT | Stock | 422.3 | 423.67 | 421.72 | 423.47 | 508966.0 |
| 2024-08-21 13:00:00 | MSFT | Stock | 423.49 | 424.13 | 423.29 | 423.91 | 439718.0 |
| 2024-08-21 14:00:00 | MSFT | Stock | 423.97 | 424.58 | 423.4 | 424.09 | 498677.0 |
| 2024-08-21 15:00:00 | MSFT | Stock | 424.14 | 424.26 | 422.7575 | 424.1 | 1124935.0 |
| 2024-08-21 16:00:00 | MSFT | Stock | 424.14 | 424.91 | 419.21 | 423.1 | 4852599.0 |
| 2024-08-21 17:00:00 | MSFT | Stock | 423.35 | 423.49 | 422.0975 | 423.0 | 11377.0 |
| 2024-08-21 18:00:00 | MSFT | Stock | 423.0 | 424.1899 | 423.0 | 424.09 | 7321.0 |
| 2024-08-21 19:00:00 | MSFT | Stock | 424.12 | 424.26 | 423.5347 | 424.2 | 9384.0 |
| 2024-08-21 04:00:00 | NVDA | Stock | 126.59 | 127.09 | 126.16 | 126.31 | 326814.0 |
| 2024-08-21 05:00:00 | NVDA | Stock | 126.3 | 126.41 | 125.99 | 126.21 | 241930.0 |
| 2024-08-21 06:00:00 | NVDA | Stock | 126.21 | 126.81 | 126.21 | 126.8 | 160863.0 |
| 2024-08-21 07:00:00 | NVDA | Stock | 126.79 | 127.65 | 126.5 | 127.24 | 1329126.0 |
| 2024-08-21 08:00:00 | NVDA | Stock | 126.83 | 127.89 | 126.18 | 127.42 | 2547646.0 |
| 2024-08-21 09:00:00 | NVDA | Stock | 127.42 | 128.58 | 126.83 | 128.0 | 35023191.0 |
| 2024-08-21 10:00:00 | NVDA | Stock | 127.99 | 129.34 | 127.2 | 127.8 | 54637129.0 |
| 2024-08-21 11:00:00 | NVDA | Stock | 127.801 | 128.42 | 127.41 | 127.56 | 23084062.0 |
| 2024-08-21 12:00:00 | NVDA | Stock | 127.56 | 128.05 | 126.66 | 127.985 | 22515606.0 |
| 2024-08-21 13:00:00 | NVDA | Stock | 127.98 | 128.34 | 127.65 | 128.276 | 14204535.0 |
| 2024-08-21 14:00:00 | NVDA | Stock | 128.29 | 129.35 | 128.18 | 128.276 | 29591003.0 |
| 2024-08-21 15:00:00 | NVDA | Stock | 128.2799 | 128.615 | 127.66 | 128.45 | 30511462.0 |
| 2024-08-21 16:00:00 | NVDA | Stock | 128.42 | 128.5 | 128.0 | 128.47 | 15190563.0 |
| 2024-08-21 17:00:00 | NVDA | Stock | 128.49 | 128.5 | 127.5051 | 128.31 | 287948.0 |
| 2024-08-21 18:00:00 | NVDA | Stock | 128.34 | 128.49 | 128.33 | 128.48 | 354957.0 |
| 2024-08-21 19:00:00 | NVDA | Stock | 128.4701 | 128.55 | 128.33 | 128.5 | 518525.0 |
| 2024-08-21 04:00:00 | AMZN | Stock | 178.99 | 178.99 | 178.68 | 178.68 | 1371.0 |
| 2024-08-21 05:00:00 | AMZN | Stock | 178.67 | 178.77 | 178.6 | 178.7 | 2478.0 |
> showing 50 of 58,335 rows — these rows as CSV