PREVIEW / stock_1hour / 2024-01-11
file: by_date/stock_1hour/2024/2024-01-11.parquet size: 1.3 MB rows: 59,127 symbols: 1,178
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-01-11 04:00:00 | AAPL | Stock | 187.0 | 187.16 | 186.81 | 186.91 | 23448.0 |
| 2024-01-11 05:00:00 | AAPL | Stock | 187.0 | 187.13 | 187.0 | 187.04 | 8364.0 |
| 2024-01-11 06:00:00 | AAPL | Stock | 187.15 | 187.42 | 187.13 | 187.2 | 8555.0 |
| 2024-01-11 07:00:00 | AAPL | Stock | 187.18 | 187.27 | 186.95 | 186.95 | 38400.0 |
| 2024-01-11 08:00:00 | AAPL | Stock | 187.24 | 187.25 | 185.58 | 185.64 | 303848.0 |
| 2024-01-11 09:00:00 | AAPL | Stock | 185.65 | 187.05 | 184.6 | 184.72 | 6238601.0 |
| 2024-01-11 10:00:00 | AAPL | Stock | 184.735 | 184.88 | 183.62 | 184.6798 | 6861836.0 |
| 2024-01-11 11:00:00 | AAPL | Stock | 184.67 | 184.87 | 183.835 | 183.94 | 4160009.0 |
| 2024-01-11 12:00:00 | AAPL | Stock | 183.95 | 184.585 | 183.91 | 184.32 | 2425286.0 |
| 2024-01-11 13:00:00 | AAPL | Stock | 184.32 | 185.17 | 184.255 | 185.1516 | 2842139.0 |
| 2024-01-11 14:00:00 | AAPL | Stock | 185.16 | 185.7 | 184.99 | 185.54 | 3170810.0 |
| 2024-01-11 15:00:00 | AAPL | Stock | 185.54 | 185.77 | 184.755 | 185.58 | 5952105.0 |
| 2024-01-11 16:00:00 | AAPL | Stock | 185.59 | 185.92 | 185.59 | 185.66 | 6326182.0 |
| 2024-01-11 17:00:00 | AAPL | Stock | 185.66 | 185.75 | 185.59 | 185.72 | 50879.0 |
| 2024-01-11 18:00:00 | AAPL | Stock | 185.635 | 185.68 | 185.3 | 185.59 | 25358.0 |
| 2024-01-11 19:00:00 | AAPL | Stock | 185.4 | 185.69 | 185.35 | 185.4 | 21393.0 |
| 2024-01-11 04:00:00 | MSFT | Stock | 385.7 | 385.7 | 385.0 | 385.4 | 7374.0 |
| 2024-01-11 05:00:00 | MSFT | Stock | 385.3 | 385.38 | 385.09 | 385.15 | 2362.0 |
| 2024-01-11 06:00:00 | MSFT | Stock | 385.15 | 385.33 | 384.9 | 384.9 | 5537.0 |
| 2024-01-11 07:00:00 | MSFT | Stock | 385.01 | 385.16 | 384.08 | 384.94 | 16298.0 |
| 2024-01-11 08:00:00 | MSFT | Stock | 385.01 | 385.64 | 382.88 | 383.6 | 176515.0 |
| 2024-01-11 09:00:00 | MSFT | Stock | 383.6 | 390.68 | 383.6 | 387.025 | 4333822.0 |
| 2024-01-11 10:00:00 | MSFT | Stock | 387.08 | 387.24 | 382.71 | 382.9193 | 3172321.0 |
| 2024-01-11 11:00:00 | MSFT | Stock | 382.91 | 383.09 | 380.38 | 380.92 | 2376650.0 |
| 2024-01-11 12:00:00 | MSFT | Stock | 380.94 | 382.85 | 380.7 | 382.17 | 1173894.0 |
| 2024-01-11 13:00:00 | MSFT | Stock | 382.19 | 384.66 | 382.07 | 384.65 | 1191298.0 |
| 2024-01-11 14:00:00 | MSFT | Stock | 384.68 | 385.53 | 384.15 | 385.3 | 1274607.0 |
| 2024-01-11 15:00:00 | MSFT | Stock | 385.29 | 385.36 | 384.1543 | 384.59 | 2280567.0 |
| 2024-01-11 16:00:00 | MSFT | Stock | 384.63 | 384.77 | 384.4 | 384.4 | 3772512.0 |
| 2024-01-11 17:00:00 | MSFT | Stock | 384.46 | 384.5 | 384.0 | 384.1801 | 10786.0 |
| 2024-01-11 18:00:00 | MSFT | Stock | 384.11 | 384.26 | 382.04 | 382.2 | 27043.0 |
| 2024-01-11 19:00:00 | MSFT | Stock | 382.51 | 383.13 | 382.51 | 382.56 | 8029.0 |
| 2024-01-11 04:00:00 | NVDA | Stock | 54.714 | 54.999 | 54.714 | 54.876 | 238830.0 |
| 2024-01-11 05:00:00 | NVDA | Stock | 54.854 | 54.923 | 54.839 | 54.91 | 147030.0 |
| 2024-01-11 06:00:00 | NVDA | Stock | 54.93 | 54.989 | 54.899 | 54.973 | 235400.0 |
| 2024-01-11 07:00:00 | NVDA | Stock | 54.966 | 55.134 | 54.887 | 55.066 | 1321550.0 |
| 2024-01-11 08:00:00 | NVDA | Stock | 54.98 | 55.165 | 54.613 | 54.664 | 7693620.0 |
| 2024-01-11 09:00:00 | NVDA | Stock | 54.676 | 55.346 | 54.501 | 54.852 | 71499900.0 |
| 2024-01-11 10:00:00 | NVDA | Stock | 54.855 | 54.8651 | 53.882 | 54.2065 | 81060530.0 |
| 2024-01-11 11:00:00 | NVDA | Stock | 54.22 | 54.279 | 53.56 | 53.8976 | 66974820.0 |
| 2024-01-11 12:00:00 | NVDA | Stock | 53.887 | 54.712 | 53.874 | 54.6251 | 52878960.0 |
| 2024-01-11 13:00:00 | NVDA | Stock | 54.623 | 55.1 | 54.582 | 55.0269 | 66416990.0 |
| 2024-01-11 14:00:00 | NVDA | Stock | 55.025 | 55.2 | 54.777 | 55.1288 | 49967170.0 |
| 2024-01-11 15:00:00 | NVDA | Stock | 55.1405 | 55.152 | 54.6 | 54.83 | 59867720.0 |
| 2024-01-11 16:00:00 | NVDA | Stock | 54.823 | 54.889 | 54.797 | 54.833 | 15795600.0 |
| 2024-01-11 17:00:00 | NVDA | Stock | 54.84 | 54.84 | 54.635 | 54.697 | 440330.0 |
| 2024-01-11 18:00:00 | NVDA | Stock | 54.685 | 54.86 | 54.657 | 54.701 | 351500.0 |
| 2024-01-11 19:00:00 | NVDA | Stock | 54.716 | 54.725 | 54.465 | 54.471 | 835830.0 |
| 2024-01-11 04:00:00 | AMZN | Stock | 154.68 | 154.9 | 154.5 | 154.62 | 12427.0 |
| 2024-01-11 05:00:00 | AMZN | Stock | 154.68 | 154.84 | 154.62 | 154.78 | 10504.0 |
> showing 50 of 59,127 rows — these rows as CSV