PREVIEW / stock_1hour / 2024-12-31
file: by_date/stock_1hour/2024/2024-12-31.parquet size: 1.4 MB rows: 64,274 symbols: 610
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-12-31 04:00:00 | AAPL | Stock | 252.14 | 253.26 | 251.85 | 253.25 | 9690.0 |
| 2024-12-31 05:00:00 | AAPL | Stock | 253.2 | 253.4 | 252.81 | 253.08 | 3664.0 |
| 2024-12-31 06:00:00 | AAPL | Stock | 253.1 | 253.21 | 252.81 | 253.2 | 6242.0 |
| 2024-12-31 07:00:00 | AAPL | Stock | 253.09 | 253.48 | 252.72 | 252.8 | 32641.0 |
| 2024-12-31 08:00:00 | AAPL | Stock | 253.15 | 253.47 | 252.17 | 252.31 | 64592.0 |
| 2024-12-31 09:00:00 | AAPL | Stock | 252.3 | 253.28 | 251.5501 | 252.269 | 2693771.0 |
| 2024-12-31 10:00:00 | AAPL | Stock | 252.25 | 252.4 | 251.31 | 251.8185 | 2135462.0 |
| 2024-12-31 11:00:00 | AAPL | Stock | 251.83 | 251.846 | 251.02 | 251.315 | 1574747.0 |
| 2024-12-31 12:00:00 | AAPL | Stock | 251.32 | 251.53 | 250.06 | 250.67 | 2242562.0 |
| 2024-12-31 13:00:00 | AAPL | Stock | 250.66 | 250.74 | 249.43 | 249.88 | 2183003.0 |
| 2024-12-31 14:00:00 | AAPL | Stock | 249.8899 | 250.43 | 249.67 | 250.42 | 1883135.0 |
| 2024-12-31 15:00:00 | AAPL | Stock | 250.41 | 251.08 | 249.5 | 250.38 | 6301045.0 |
| 2024-12-31 16:00:00 | AAPL | Stock | 250.46 | 250.67 | 250.2 | 250.43 | 7580865.0 |
| 2024-12-31 17:00:00 | AAPL | Stock | 250.43 | 250.5 | 250.41 | 250.433 | 7692.0 |
| 2024-12-31 18:00:00 | AAPL | Stock | 250.4406 | 250.49 | 250.4209 | 250.4219 | 1791.0 |
| 2024-12-31 19:00:00 | AAPL | Stock | 250.4216 | 250.45 | 250.41 | 250.41 | 6530.0 |
| 2024-12-31 04:00:00 | MSFT | Stock | 424.87 | 427.5 | 424.87 | 426.82 | 6755.0 |
| 2024-12-31 05:00:00 | MSFT | Stock | 426.7 | 427.5 | 426.7 | 427.5 | 300.0 |
| 2024-12-31 06:00:00 | MSFT | Stock | 427.4 | 427.42 | 427.0 | 427.42 | 828.0 |
| 2024-12-31 07:00:00 | MSFT | Stock | 427.34 | 427.49 | 426.01 | 426.24 | 5511.0 |
| 2024-12-31 08:00:00 | MSFT | Stock | 427.48 | 427.48 | 424.1 | 426.0 | 22543.0 |
| 2024-12-31 09:00:00 | MSFT | Stock | 426.0 | 426.75 | 424.205 | 425.62 | 696048.0 |
| 2024-12-31 10:00:00 | MSFT | Stock | 425.66 | 426.37 | 424.0001 | 424.76 | 650583.0 |
| 2024-12-31 11:00:00 | MSFT | Stock | 424.825 | 424.8688 | 422.78 | 423.19 | 497768.0 |
| 2024-12-31 12:00:00 | MSFT | Stock | 423.19 | 423.6834 | 421.864 | 423.6834 | 589455.0 |
| 2024-12-31 13:00:00 | MSFT | Stock | 423.55 | 423.86 | 421.71 | 421.99 | 501595.0 |
| 2024-12-31 14:00:00 | MSFT | Stock | 421.93 | 423.0012 | 421.55 | 422.81 | 446207.0 |
| 2024-12-31 15:00:00 | MSFT | Stock | 422.74 | 423.4 | 420.66 | 421.291 | 2137415.0 |
| 2024-12-31 16:00:00 | MSFT | Stock | 421.61 | 421.95 | 421.15 | 421.51 | 3867026.0 |
| 2024-12-31 17:00:00 | MSFT | Stock | 421.5999 | 421.61 | 421.4 | 421.61 | 3678.0 |
| 2024-12-31 18:00:00 | MSFT | Stock | 421.65 | 421.75 | 421.2 | 421.2 | 3147.0 |
| 2024-12-31 19:00:00 | MSFT | Stock | 421.3 | 421.76 | 421.3 | 421.6 | 3399.0 |
| 2024-12-31 04:00:00 | NVDA | Stock | 136.99 | 138.82 | 136.97 | 138.24 | 226711.0 |
| 2024-12-31 05:00:00 | NVDA | Stock | 138.3 | 138.61 | 138.16 | 138.47 | 57913.0 |
| 2024-12-31 06:00:00 | NVDA | Stock | 138.47 | 138.69 | 138.2 | 138.42 | 84030.0 |
| 2024-12-31 07:00:00 | NVDA | Stock | 138.37 | 138.74 | 138.2 | 138.39 | 290150.0 |
| 2024-12-31 08:00:00 | NVDA | Stock | 138.4 | 138.74 | 136.75 | 138.55 | 973391.0 |
| 2024-12-31 09:00:00 | NVDA | Stock | 138.53 | 138.74 | 136.1537 | 136.965 | 17781527.0 |
| 2024-12-31 10:00:00 | NVDA | Stock | 136.95 | 137.79 | 135.67 | 136.574 | 20201338.0 |
| 2024-12-31 11:00:00 | NVDA | Stock | 136.59 | 136.654 | 134.93 | 135.725 | 16818306.0 |
| 2024-12-31 12:00:00 | NVDA | Stock | 135.72 | 136.2 | 134.256 | 135.315 | 14911281.0 |
| 2024-12-31 13:00:00 | NVDA | Stock | 135.3 | 135.7224 | 134.04 | 134.31 | 12642051.0 |
| 2024-12-31 14:00:00 | NVDA | Stock | 134.31 | 134.86 | 133.83 | 134.845 | 12682849.0 |
| 2024-12-31 15:00:00 | NVDA | Stock | 134.84 | 135.63 | 134.0 | 134.29 | 21815419.0 |
| 2024-12-31 16:00:00 | NVDA | Stock | 134.26 | 134.8 | 134.06 | 134.36 | 15381030.0 |
| 2024-12-31 17:00:00 | NVDA | Stock | 134.39 | 134.45 | 134.25 | 134.35 | 184318.0 |
| 2024-12-31 18:00:00 | NVDA | Stock | 134.33 | 134.35 | 134.2 | 134.21 | 126766.0 |
| 2024-12-31 19:00:00 | NVDA | Stock | 134.21 | 134.29 | 134.1401 | 134.29 | 168179.0 |
| 2024-12-31 04:00:00 | AMZN | Stock | 221.03 | 222.53 | 221.0 | 222.44 | 2584.0 |
| 2024-12-31 05:00:00 | AMZN | Stock | 222.35 | 222.69 | 222.24 | 222.44 | 1784.0 |
> showing 50 of 64,274 rows — these rows as CSV