PREVIEW / stock_1hour / 2024-11-26
file: by_date/stock_1hour/2024/2024-11-26.parquet size: 1.4 MB rows: 61,862 symbols: 684
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-11-26 04:00:00 | AAPL | Stock | 231.93 | 233.0 | 231.93 | 232.7 | 41074.0 |
| 2024-11-26 05:00:00 | AAPL | Stock | 232.67 | 232.82 | 232.49 | 232.6 | 10654.0 |
| 2024-11-26 06:00:00 | AAPL | Stock | 232.6 | 233.08 | 232.25 | 232.95 | 31226.0 |
| 2024-11-26 07:00:00 | AAPL | Stock | 232.93 | 233.48 | 232.72 | 233.18 | 51125.0 |
| 2024-11-26 08:00:00 | AAPL | Stock | 233.33 | 233.5 | 231.93 | 233.37 | 108426.0 |
| 2024-11-26 09:00:00 | AAPL | Stock | 233.3899 | 235.435 | 232.86 | 234.81 | 5938450.0 |
| 2024-11-26 10:00:00 | AAPL | Stock | 234.78 | 235.57 | 233.65 | 235.1699 | 4486477.0 |
| 2024-11-26 11:00:00 | AAPL | Stock | 235.17 | 235.46 | 234.61 | 235.03 | 2424247.0 |
| 2024-11-26 12:00:00 | AAPL | Stock | 235.02 | 235.18 | 234.27 | 235.0 | 2112852.0 |
| 2024-11-26 13:00:00 | AAPL | Stock | 235.005 | 235.08 | 234.35 | 235.08 | 1935021.0 |
| 2024-11-26 14:00:00 | AAPL | Stock | 235.07 | 235.1 | 234.56 | 234.92 | 1801690.0 |
| 2024-11-26 15:00:00 | AAPL | Stock | 234.91 | 235.28 | 234.58 | 235.08 | 5059318.0 |
| 2024-11-26 16:00:00 | AAPL | Stock | 235.06 | 235.55 | 234.9811 | 235.55 | 7395546.0 |
| 2024-11-26 17:00:00 | AAPL | Stock | 235.55 | 235.62 | 235.35 | 235.41 | 21922.0 |
| 2024-11-26 18:00:00 | AAPL | Stock | 235.41 | 235.64 | 235.06 | 235.4617 | 15978.0 |
| 2024-11-26 19:00:00 | AAPL | Stock | 235.5935 | 235.65 | 235.3109 | 235.53 | 17281.0 |
| 2024-11-26 04:00:00 | MSFT | Stock | 417.66 | 418.84 | 415.15 | 418.0 | 14986.0 |
| 2024-11-26 05:00:00 | MSFT | Stock | 418.0 | 418.46 | 416.98 | 417.4 | 44091.0 |
| 2024-11-26 06:00:00 | MSFT | Stock | 417.4 | 418.5 | 417.35 | 418.5 | 3004.0 |
| 2024-11-26 07:00:00 | MSFT | Stock | 418.76 | 419.22 | 418.76 | 419.0 | 2773.0 |
| 2024-11-26 08:00:00 | MSFT | Stock | 418.68 | 419.72 | 417.67 | 419.58 | 34712.0 |
| 2024-11-26 09:00:00 | MSFT | Stock | 419.58 | 424.57 | 418.79 | 424.29 | 2544183.0 |
| 2024-11-26 10:00:00 | MSFT | Stock | 424.32 | 427.25 | 423.52 | 425.64 | 2102885.0 |
| 2024-11-26 11:00:00 | MSFT | Stock | 425.67 | 426.8 | 425.2101 | 425.8999 | 947612.0 |
| 2024-11-26 12:00:00 | MSFT | Stock | 425.87 | 426.97 | 425.135 | 426.9 | 676773.0 |
| 2024-11-26 13:00:00 | MSFT | Stock | 426.885 | 427.0 | 425.88 | 426.695 | 714316.0 |
| 2024-11-26 14:00:00 | MSFT | Stock | 426.71 | 427.25 | 426.1 | 427.09 | 769555.0 |
| 2024-11-26 15:00:00 | MSFT | Stock | 427.095 | 429.0414 | 427.05 | 427.65 | 2374086.0 |
| 2024-11-26 16:00:00 | MSFT | Stock | 427.99 | 427.99 | 425.604 | 426.4 | 3984884.0 |
| 2024-11-26 17:00:00 | MSFT | Stock | 426.15 | 427.99 | 425.4 | 425.5 | 354703.0 |
| 2024-11-26 18:00:00 | MSFT | Stock | 425.43 | 427.99 | 425.43 | 426.05 | 5207.0 |
| 2024-11-26 19:00:00 | MSFT | Stock | 426.0 | 426.4 | 425.65 | 426.4 | 5477.0 |
| 2024-11-26 04:00:00 | NVDA | Stock | 136.05 | 136.94 | 135.8 | 136.6 | 375513.0 |
| 2024-11-26 05:00:00 | NVDA | Stock | 136.65 | 136.94 | 136.32 | 136.67 | 182884.0 |
| 2024-11-26 06:00:00 | NVDA | Stock | 136.67 | 137.29 | 136.51 | 136.97 | 342189.0 |
| 2024-11-26 07:00:00 | NVDA | Stock | 136.97 | 137.72 | 136.72 | 137.45 | 1016243.0 |
| 2024-11-26 08:00:00 | NVDA | Stock | 136.81 | 138.55 | 135.957 | 138.05 | 3275129.0 |
| 2024-11-26 09:00:00 | NVDA | Stock | 138.05 | 139.3 | 136.02 | 137.16 | 35455448.0 |
| 2024-11-26 10:00:00 | NVDA | Stock | 137.21 | 137.68 | 136.17 | 136.195 | 31850675.0 |
| 2024-11-26 11:00:00 | NVDA | Stock | 136.19 | 137.14 | 136.17 | 136.9899 | 17192938.0 |
| 2024-11-26 12:00:00 | NVDA | Stock | 136.985 | 137.1 | 136.48 | 136.995 | 11339095.0 |
| 2024-11-26 13:00:00 | NVDA | Stock | 136.99 | 137.03 | 136.375 | 136.81 | 10036663.0 |
| 2024-11-26 14:00:00 | NVDA | Stock | 136.81 | 136.85 | 135.67 | 136.295 | 14435542.0 |
| 2024-11-26 15:00:00 | NVDA | Stock | 136.29 | 137.1 | 136.195 | 136.84 | 17136247.0 |
| 2024-11-26 16:00:00 | NVDA | Stock | 136.92 | 136.95 | 136.47 | 136.69 | 17378018.0 |
| 2024-11-26 17:00:00 | NVDA | Stock | 136.68 | 136.74 | 136.2 | 136.33 | 447860.0 |
| 2024-11-26 18:00:00 | NVDA | Stock | 136.34 | 136.92 | 136.2682 | 136.32 | 195800.0 |
| 2024-11-26 19:00:00 | NVDA | Stock | 136.32 | 136.43 | 136.15 | 136.27 | 325956.0 |
| 2024-11-26 04:00:00 | AMZN | Stock | 200.9 | 201.25 | 200.5 | 200.78 | 20164.0 |
| 2024-11-26 05:00:00 | AMZN | Stock | 200.91 | 200.91 | 200.46 | 200.64 | 5407.0 |
> showing 50 of 61,862 rows — these rows as CSV