PREVIEW / stock_1hour / 2024-02-09
file: by_date/stock_1hour/2024/2024-02-09.parquet size: 1.3 MB rows: 58,938 symbols: 1,140
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-02-09 04:00:00 | AAPL | Stock | 188.5 | 188.5 | 188.3 | 188.4 | 2005.0 |
| 2024-02-09 05:00:00 | AAPL | Stock | 188.4 | 188.52 | 188.4 | 188.46 | 3620.0 |
| 2024-02-09 06:00:00 | AAPL | Stock | 188.46 | 188.55 | 188.45 | 188.51 | 2578.0 |
| 2024-02-09 07:00:00 | AAPL | Stock | 188.54 | 188.88 | 188.48 | 188.76 | 25235.0 |
| 2024-02-09 08:00:00 | AAPL | Stock | 188.54 | 189.33 | 188.12 | 188.75 | 136146.0 |
| 2024-02-09 09:00:00 | AAPL | Stock | 188.76 | 188.93 | 188.0 | 188.67 | 3457627.0 |
| 2024-02-09 10:00:00 | AAPL | Stock | 188.67 | 188.8385 | 188.355 | 188.6762 | 4587261.0 |
| 2024-02-09 11:00:00 | AAPL | Stock | 188.685 | 189.99 | 188.68 | 189.77 | 6752894.0 |
| 2024-02-09 12:00:00 | AAPL | Stock | 189.775 | 189.84 | 189.1001 | 189.6477 | 4093958.0 |
| 2024-02-09 13:00:00 | AAPL | Stock | 189.645 | 189.66 | 189.04 | 189.08 | 3244278.0 |
| 2024-02-09 14:00:00 | AAPL | Stock | 189.08 | 189.08 | 188.7 | 188.944 | 2968908.0 |
| 2024-02-09 15:00:00 | AAPL | Stock | 188.95 | 188.965 | 188.565 | 188.83 | 5578676.0 |
| 2024-02-09 16:00:00 | AAPL | Stock | 188.83 | 188.89 | 188.5 | 188.62 | 6910374.0 |
| 2024-02-09 17:00:00 | AAPL | Stock | 188.61 | 188.72 | 188.52 | 188.7 | 31578.0 |
| 2024-02-09 18:00:00 | AAPL | Stock | 188.6505 | 188.74 | 188.55 | 188.62 | 28179.0 |
| 2024-02-09 19:00:00 | AAPL | Stock | 188.62 | 188.6299 | 188.52 | 188.53 | 22542.0 |
| 2024-02-09 04:00:00 | MSFT | Stock | 415.3 | 415.3 | 414.7 | 415.2 | 2507.0 |
| 2024-02-09 05:00:00 | MSFT | Stock | 415.3 | 415.75 | 415.3 | 415.74 | 1326.0 |
| 2024-02-09 06:00:00 | MSFT | Stock | 415.86 | 416.4 | 415.86 | 416.25 | 3555.0 |
| 2024-02-09 07:00:00 | MSFT | Stock | 416.25 | 416.25 | 415.78 | 416.04 | 19782.0 |
| 2024-02-09 08:00:00 | MSFT | Stock | 416.14 | 417.1 | 414.0 | 416.72 | 56223.0 |
| 2024-02-09 09:00:00 | MSFT | Stock | 416.7 | 417.42 | 415.07 | 417.345 | 1922264.0 |
| 2024-02-09 10:00:00 | MSFT | Stock | 417.37 | 419.505 | 416.82 | 418.89 | 2443482.0 |
| 2024-02-09 11:00:00 | MSFT | Stock | 418.91 | 420.39 | 418.62 | 419.5217 | 1812846.0 |
| 2024-02-09 12:00:00 | MSFT | Stock | 419.53 | 420.01 | 418.89 | 419.76 | 1201746.0 |
| 2024-02-09 13:00:00 | MSFT | Stock | 419.78 | 419.85 | 419.3 | 419.505 | 830659.0 |
| 2024-02-09 14:00:00 | MSFT | Stock | 419.503 | 420.4 | 419.46 | 420.1476 | 830506.0 |
| 2024-02-09 15:00:00 | MSFT | Stock | 420.15 | 420.82 | 419.8 | 420.59 | 1969104.0 |
| 2024-02-09 16:00:00 | MSFT | Stock | 420.59 | 421.21 | 420.49 | 420.71 | 3479703.0 |
| 2024-02-09 17:00:00 | MSFT | Stock | 420.8 | 420.9199 | 420.55 | 420.7 | 11916.0 |
| 2024-02-09 18:00:00 | MSFT | Stock | 420.5129 | 420.802 | 420.51 | 420.55 | 3490.0 |
| 2024-02-09 19:00:00 | MSFT | Stock | 420.69 | 421.1 | 420.69 | 420.83 | 10475.0 |
| 2024-02-09 04:00:00 | NVDA | Stock | 69.9 | 70.03 | 69.75 | 70.03 | 132950.0 |
| 2024-02-09 05:00:00 | NVDA | Stock | 70.022 | 70.05 | 69.925 | 70.05 | 55540.0 |
| 2024-02-09 06:00:00 | NVDA | Stock | 70.0 | 70.0 | 69.883 | 69.95 | 48350.0 |
| 2024-02-09 07:00:00 | NVDA | Stock | 69.95 | 70.487 | 69.836 | 70.268 | 1288630.0 |
| 2024-02-09 08:00:00 | NVDA | Stock | 69.95 | 70.498 | 69.8 | 70.4252 | 3405450.0 |
| 2024-02-09 09:00:00 | NVDA | Stock | 70.4345 | 70.929 | 70.212 | 70.726 | 54109060.0 |
| 2024-02-09 10:00:00 | NVDA | Stock | 70.735 | 71.586 | 70.605 | 71.5295 | 67443020.0 |
| 2024-02-09 11:00:00 | NVDA | Stock | 71.531 | 71.814 | 71.272 | 71.5606 | 44494190.0 |
| 2024-02-09 12:00:00 | NVDA | Stock | 71.5525 | 71.795 | 71.452 | 71.719 | 25664760.0 |
| 2024-02-09 13:00:00 | NVDA | Stock | 71.719 | 72.06 | 71.667 | 71.9823 | 34485400.0 |
| 2024-02-09 14:00:00 | NVDA | Stock | 71.9883 | 72.0 | 71.711 | 71.96 | 27372100.0 |
| 2024-02-09 15:00:00 | NVDA | Stock | 71.96 | 72.185 | 71.771 | 72.131 | 49000070.0 |
| 2024-02-09 16:00:00 | NVDA | Stock | 72.133 | 72.296 | 72.016 | 72.198 | 19632990.0 |
| 2024-02-09 17:00:00 | NVDA | Stock | 72.198 | 72.22 | 72.05 | 72.105 | 642560.0 |
| 2024-02-09 18:00:00 | NVDA | Stock | 72.1 | 72.145 | 72.042 | 72.128 | 534470.0 |
| 2024-02-09 19:00:00 | NVDA | Stock | 72.128 | 72.2 | 72.101 | 72.102 | 447200.0 |
| 2024-02-09 04:00:00 | AMZN | Stock | 170.0 | 170.3 | 170.0 | 170.15 | 7638.0 |
| 2024-02-09 05:00:00 | AMZN | Stock | 170.2 | 170.26 | 170.2 | 170.21 | 2768.0 |
> showing 50 of 58,938 rows — these rows as CSV