PREVIEW / stock_1hour / 2024-01-19
file: by_date/stock_1hour/2024/2024-01-19.parquet size: 1.3 MB rows: 58,258 symbols: 1,169
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-19 04:00:00 | AAPL | Stock | 188.89 | 189.95 | 188.89 | 189.45 | 38526.0 |
| 2024-01-19 05:00:00 | AAPL | Stock | 189.47 | 189.79 | 189.21 | 189.66 | 26633.0 |
| 2024-01-19 06:00:00 | AAPL | Stock | 189.6 | 190.58 | 189.55 | 190.25 | 105027.0 |
| 2024-01-19 07:00:00 | AAPL | Stock | 190.16 | 190.2 | 189.55 | 189.84 | 86439.0 |
| 2024-01-19 08:00:00 | AAPL | Stock | 190.0 | 190.2 | 188.65 | 189.15 | 362798.0 |
| 2024-01-19 09:00:00 | AAPL | Stock | 189.15 | 189.8798 | 188.5 | 189.59 | 9839215.0 |
| 2024-01-19 10:00:00 | AAPL | Stock | 189.59 | 190.16 | 188.91 | 189.79 | 7215823.0 |
| 2024-01-19 11:00:00 | AAPL | Stock | 189.78 | 190.06 | 189.3301 | 189.975 | 4613100.0 |
| 2024-01-19 12:00:00 | AAPL | Stock | 189.975 | 190.64 | 189.9 | 190.565 | 4520798.0 |
| 2024-01-19 13:00:00 | AAPL | Stock | 190.565 | 191.45 | 190.495 | 191.414 | 5033987.0 |
| 2024-01-19 14:00:00 | AAPL | Stock | 191.4101 | 191.95 | 191.17 | 191.65 | 5767698.0 |
| 2024-01-19 15:00:00 | AAPL | Stock | 191.6538 | 191.82 | 191.32 | 191.58 | 7353804.0 |
| 2024-01-19 16:00:00 | AAPL | Stock | 191.56 | 191.61 | 191.32 | 191.55 | 10908684.0 |
| 2024-01-19 17:00:00 | AAPL | Stock | 191.5501 | 191.59 | 191.39 | 191.41 | 10460.0 |
| 2024-01-19 18:00:00 | AAPL | Stock | 191.49 | 191.56 | 191.29 | 191.29 | 127000.0 |
| 2024-01-19 19:00:00 | AAPL | Stock | 191.3 | 191.31 | 191.1 | 191.23 | 19526.0 |
| 2024-01-19 04:00:00 | MSFT | Stock | 397.0 | 398.3 | 396.17 | 398.3 | 17481.0 |
| 2024-01-19 05:00:00 | MSFT | Stock | 398.36 | 398.46 | 397.9 | 398.4 | 8967.0 |
| 2024-01-19 06:00:00 | MSFT | Stock | 397.95 | 398.1 | 397.75 | 397.82 | 5486.0 |
| 2024-01-19 07:00:00 | MSFT | Stock | 397.72 | 397.72 | 396.4 | 397.14 | 28587.0 |
| 2024-01-19 08:00:00 | MSFT | Stock | 395.85 | 398.47 | 395.85 | 396.3406 | 69759.0 |
| 2024-01-19 09:00:00 | MSFT | Stock | 396.45 | 396.85 | 393.5 | 394.88 | 4106118.0 |
| 2024-01-19 10:00:00 | MSFT | Stock | 394.89 | 395.5366 | 393.86 | 394.98 | 2227054.0 |
| 2024-01-19 11:00:00 | MSFT | Stock | 395.0 | 396.3 | 394.81 | 395.4223 | 1595399.0 |
| 2024-01-19 12:00:00 | MSFT | Stock | 395.455 | 396.23 | 394.73 | 396.22 | 1232060.0 |
| 2024-01-19 13:00:00 | MSFT | Stock | 396.22 | 397.05 | 395.81 | 396.99 | 1408195.0 |
| 2024-01-19 14:00:00 | MSFT | Stock | 396.99 | 397.24 | 395.94 | 396.935 | 1602454.0 |
| 2024-01-19 15:00:00 | MSFT | Stock | 396.95 | 398.66 | 396.66 | 398.66 | 2931224.0 |
| 2024-01-19 16:00:00 | MSFT | Stock | 398.62 | 398.98 | 398.0 | 398.0 | 4863862.0 |
| 2024-01-19 17:00:00 | MSFT | Stock | 397.8 | 398.67 | 396.85 | 397.1782 | 395981.0 |
| 2024-01-19 18:00:00 | MSFT | Stock | 397.18 | 397.6 | 397.17 | 397.44 | 22102.0 |
| 2024-01-19 19:00:00 | MSFT | Stock | 397.6 | 397.6 | 397.0 | 397.2 | 27768.0 |
| 2024-01-19 04:00:00 | NVDA | Stock | 57.714 | 58.264 | 57.62 | 58.2 | 732940.0 |
| 2024-01-19 05:00:00 | NVDA | Stock | 58.2 | 58.275 | 58.096 | 58.229 | 194090.0 |
| 2024-01-19 06:00:00 | NVDA | Stock | 58.219 | 58.33 | 58.07 | 58.125 | 372940.0 |
| 2024-01-19 07:00:00 | NVDA | Stock | 58.116 | 58.19 | 57.95 | 58.15 | 1411670.0 |
| 2024-01-19 08:00:00 | NVDA | Stock | 58.1392 | 58.19 | 57.65 | 57.93 | 3883220.0 |
| 2024-01-19 09:00:00 | NVDA | Stock | 57.93 | 58.057 | 57.225 | 57.636 | 64262550.0 |
| 2024-01-19 10:00:00 | NVDA | Stock | 57.65 | 58.098 | 57.4 | 58.0291 | 60474530.0 |
| 2024-01-19 11:00:00 | NVDA | Stock | 58.0353 | 58.509 | 57.955 | 58.509 | 56309630.0 |
| 2024-01-19 12:00:00 | NVDA | Stock | 58.5087 | 59.088 | 58.392 | 58.839 | 56061140.0 |
| 2024-01-19 13:00:00 | NVDA | Stock | 58.839 | 59.184 | 58.755 | 58.9505 | 43490330.0 |
| 2024-01-19 14:00:00 | NVDA | Stock | 58.945 | 59.135 | 58.836 | 59.0905 | 36558440.0 |
| 2024-01-19 15:00:00 | NVDA | Stock | 59.095 | 59.5 | 58.982 | 59.5 | 63575070.0 |
| 2024-01-19 16:00:00 | NVDA | Stock | 59.497 | 59.649 | 59.453 | 59.499 | 26272260.0 |
| 2024-01-19 17:00:00 | NVDA | Stock | 59.502 | 59.5197 | 59.362 | 59.418 | 718600.0 |
| 2024-01-19 18:00:00 | NVDA | Stock | 59.42 | 59.44 | 59.2153 | 59.419 | 605510.0 |
| 2024-01-19 19:00:00 | NVDA | Stock | 59.418 | 59.476 | 59.395 | 59.476 | 439570.0 |
| 2024-01-19 04:00:00 | AMZN | Stock | 153.95 | 154.63 | 153.95 | 154.49 | 21858.0 |
| 2024-01-19 05:00:00 | AMZN | Stock | 154.46 | 154.6 | 154.4 | 154.6 | 4140.0 |
> showing 50 of 58,258 rows — these rows as CSV