PREVIEW / stock_1hour / 2024-10-08
file: by_date/stock_1hour/2024/2024-10-08.parquet size: 1.4 MB rows: 59,529 symbols: 779
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-10-08 04:00:00 | AAPL | Stock | 222.1 | 222.3 | 221.7 | 221.97 | 12394.0 |
| 2024-10-08 05:00:00 | AAPL | Stock | 222.07 | 222.8 | 222.07 | 222.8 | 11085.0 |
| 2024-10-08 06:00:00 | AAPL | Stock | 222.77 | 223.24 | 222.68 | 223.13 | 18022.0 |
| 2024-10-08 07:00:00 | AAPL | Stock | 223.08 | 223.35 | 222.78 | 223.18 | 28896.0 |
| 2024-10-08 08:00:00 | AAPL | Stock | 223.2 | 223.58 | 221.136 | 223.4404 | 117745.0 |
| 2024-10-08 09:00:00 | AAPL | Stock | 223.45 | 225.17 | 223.06 | 225.07 | 3760369.0 |
| 2024-10-08 10:00:00 | AAPL | Stock | 225.08 | 225.97 | 224.54 | 225.04 | 4062055.0 |
| 2024-10-08 11:00:00 | AAPL | Stock | 225.045 | 225.6 | 224.66 | 225.3452 | 1891691.0 |
| 2024-10-08 12:00:00 | AAPL | Stock | 225.34 | 225.35 | 224.57 | 224.7098 | 1283287.0 |
| 2024-10-08 13:00:00 | AAPL | Stock | 224.692 | 224.99 | 224.22 | 224.9611 | 1254327.0 |
| 2024-10-08 14:00:00 | AAPL | Stock | 224.96 | 225.44 | 224.77 | 225.34 | 1396954.0 |
| 2024-10-08 15:00:00 | AAPL | Stock | 225.32 | 225.98 | 225.1 | 225.78 | 3814660.0 |
| 2024-10-08 16:00:00 | AAPL | Stock | 225.77 | 225.9 | 225.44 | 225.51 | 5290551.0 |
| 2024-10-08 17:00:00 | AAPL | Stock | 225.5 | 225.77 | 225.37 | 225.4 | 34326.0 |
| 2024-10-08 18:00:00 | AAPL | Stock | 225.49 | 225.53 | 225.2 | 225.53 | 18442.0 |
| 2024-10-08 19:00:00 | AAPL | Stock | 225.53 | 225.53 | 225.2212 | 225.2212 | 8582.0 |
| 2024-10-08 04:00:00 | MSFT | Stock | 410.94 | 412.71 | 410.8 | 411.5 | 7222.0 |
| 2024-10-08 05:00:00 | MSFT | Stock | 412.75 | 413.98 | 412.71 | 413.14 | 9053.0 |
| 2024-10-08 06:00:00 | MSFT | Stock | 413.26 | 413.47 | 405.5 | 407.69 | 116885.0 |
| 2024-10-08 07:00:00 | MSFT | Stock | 407.72 | 408.58 | 407.34 | 408.05 | 55844.0 |
| 2024-10-08 08:00:00 | MSFT | Stock | 407.4 | 410.5 | 407.01 | 409.44 | 102718.0 |
| 2024-10-08 09:00:00 | MSFT | Stock | 409.43 | 413.99 | 408.17 | 413.33 | 2720828.0 |
| 2024-10-08 10:00:00 | MSFT | Stock | 413.33 | 414.85 | 412.16 | 413.735 | 1522683.0 |
| 2024-10-08 11:00:00 | MSFT | Stock | 413.7 | 414.62 | 412.9 | 414.5 | 994594.0 |
| 2024-10-08 12:00:00 | MSFT | Stock | 414.495 | 414.72 | 413.25 | 413.585 | 839236.0 |
| 2024-10-08 13:00:00 | MSFT | Stock | 413.55 | 413.7 | 412.27 | 413.005 | 588173.0 |
| 2024-10-08 14:00:00 | MSFT | Stock | 413.005 | 414.09 | 412.9 | 413.98 | 780508.0 |
| 2024-10-08 15:00:00 | MSFT | Stock | 413.98 | 415.66 | 413.78 | 414.78 | 1892747.0 |
| 2024-10-08 16:00:00 | MSFT | Stock | 414.71 | 414.71 | 414.17 | 414.39 | 2879475.0 |
| 2024-10-08 17:00:00 | MSFT | Stock | 414.42 | 414.6 | 414.0 | 414.5 | 5932.0 |
| 2024-10-08 18:00:00 | MSFT | Stock | 414.4 | 414.73 | 414.3836 | 414.53 | 12176.0 |
| 2024-10-08 19:00:00 | MSFT | Stock | 414.58 | 414.69 | 414.38 | 414.65 | 8159.0 |
| 2024-10-08 04:00:00 | NVDA | Stock | 128.5 | 129.24 | 127.77 | 128.89 | 601130.0 |
| 2024-10-08 05:00:00 | NVDA | Stock | 128.91 | 130.05 | 128.82 | 129.93 | 658956.0 |
| 2024-10-08 06:00:00 | NVDA | Stock | 129.91 | 130.2 | 129.62 | 129.99 | 508701.0 |
| 2024-10-08 07:00:00 | NVDA | Stock | 129.95 | 130.49 | 129.72 | 130.05 | 1667731.0 |
| 2024-10-08 08:00:00 | NVDA | Stock | 130.05 | 130.49 | 127.8 | 129.92 | 2914762.0 |
| 2024-10-08 09:00:00 | NVDA | Stock | 129.93 | 130.99 | 129.42 | 130.605 | 41423189.0 |
| 2024-10-08 10:00:00 | NVDA | Stock | 130.61 | 132.8 | 130.6 | 132.71 | 58639656.0 |
| 2024-10-08 11:00:00 | NVDA | Stock | 132.715 | 132.92 | 131.535 | 132.2649 | 32613468.0 |
| 2024-10-08 12:00:00 | NVDA | Stock | 132.26 | 132.69 | 131.61 | 132.275 | 21668132.0 |
| 2024-10-08 13:00:00 | NVDA | Stock | 132.28 | 132.5 | 131.7 | 132.48 | 17128809.0 |
| 2024-10-08 14:00:00 | NVDA | Stock | 132.475 | 133.0 | 132.18 | 132.975 | 21779659.0 |
| 2024-10-08 15:00:00 | NVDA | Stock | 132.9711 | 133.48 | 132.58 | 132.94 | 37230811.0 |
| 2024-10-08 16:00:00 | NVDA | Stock | 132.93 | 132.94 | 132.49 | 132.52 | 15973781.0 |
| 2024-10-08 17:00:00 | NVDA | Stock | 132.521 | 132.89 | 132.45 | 132.83 | 581656.0 |
| 2024-10-08 18:00:00 | NVDA | Stock | 132.81 | 132.81 | 132.58 | 132.728 | 321984.0 |
| 2024-10-08 19:00:00 | NVDA | Stock | 132.72 | 133.03 | 132.699 | 133.0 | 552303.0 |
| 2024-10-08 04:00:00 | AMZN | Stock | 180.91 | 181.08 | 180.75 | 181.05 | 15363.0 |
| 2024-10-08 05:00:00 | AMZN | Stock | 181.1 | 181.85 | 181.1 | 181.79 | 21578.0 |
> showing 50 of 59,529 rows — these rows as CSV