PREVIEW / stock_1hour / 2024-08-14
file: by_date/stock_1hour/2024/2024-08-14.parquet size: 1.3 MB rows: 58,279 symbols: 852
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-08-14 04:00:00 | AAPL | Stock | 221.28 | 221.4 | 220.77 | 221.07 | 19298.0 |
| 2024-08-14 05:00:00 | AAPL | Stock | 221.19 | 221.7 | 221.12 | 221.61 | 7437.0 |
| 2024-08-14 06:00:00 | AAPL | Stock | 221.69 | 221.77 | 221.2 | 221.35 | 8254.0 |
| 2024-08-14 07:00:00 | AAPL | Stock | 221.33 | 221.33 | 220.95 | 221.04 | 17246.0 |
| 2024-08-14 08:00:00 | AAPL | Stock | 221.2 | 221.9996 | 220.32 | 221.41 | 160922.0 |
| 2024-08-14 09:00:00 | AAPL | Stock | 221.35 | 222.02 | 219.7 | 220.95 | 4974266.0 |
| 2024-08-14 10:00:00 | AAPL | Stock | 220.945 | 221.73 | 220.455 | 221.6901 | 3864172.0 |
| 2024-08-14 11:00:00 | AAPL | Stock | 221.695 | 223.03 | 221.6 | 222.9701 | 2937310.0 |
| 2024-08-14 12:00:00 | AAPL | Stock | 222.97 | 222.97 | 220.38 | 221.04 | 3209852.0 |
| 2024-08-14 13:00:00 | AAPL | Stock | 221.03 | 221.77 | 220.88 | 221.27 | 2330365.0 |
| 2024-08-14 14:00:00 | AAPL | Stock | 221.26 | 221.72 | 220.9 | 221.57 | 2303095.0 |
| 2024-08-14 15:00:00 | AAPL | Stock | 221.58 | 222.35 | 220.81 | 221.61 | 4525141.0 |
| 2024-08-14 16:00:00 | AAPL | Stock | 221.59 | 221.96 | 221.49 | 221.68 | 5249652.0 |
| 2024-08-14 17:00:00 | AAPL | Stock | 221.71 | 221.85 | 221.5841 | 221.85 | 9290.0 |
| 2024-08-14 18:00:00 | AAPL | Stock | 221.85 | 221.85 | 221.5005 | 221.6081 | 14866.0 |
| 2024-08-14 19:00:00 | AAPL | Stock | 221.6 | 222.1594 | 221.59 | 222.0 | 46131.0 |
| 2024-08-14 04:00:00 | MSFT | Stock | 415.07 | 415.7 | 414.35 | 415.13 | 5979.0 |
| 2024-08-14 05:00:00 | MSFT | Stock | 415.28 | 415.28 | 414.79 | 414.79 | 2157.0 |
| 2024-08-14 06:00:00 | MSFT | Stock | 414.72 | 415.49 | 414.72 | 415.49 | 1466.0 |
| 2024-08-14 07:00:00 | MSFT | Stock | 415.32 | 415.4 | 414.8 | 415.13 | 6546.0 |
| 2024-08-14 08:00:00 | MSFT | Stock | 415.0097 | 416.3 | 412.41 | 414.51 | 45396.0 |
| 2024-08-14 09:00:00 | MSFT | Stock | 414.6 | 416.637 | 413.86 | 415.38 | 1354732.0 |
| 2024-08-14 10:00:00 | MSFT | Stock | 415.395 | 415.56 | 412.4456 | 414.865 | 805699.0 |
| 2024-08-14 11:00:00 | MSFT | Stock | 414.915 | 417.56 | 414.77 | 417.445 | 829373.0 |
| 2024-08-14 12:00:00 | MSFT | Stock | 417.33 | 417.3699 | 415.11 | 416.45 | 649083.0 |
| 2024-08-14 13:00:00 | MSFT | Stock | 416.41 | 417.0383 | 415.58 | 416.455 | 566046.0 |
| 2024-08-14 14:00:00 | MSFT | Stock | 416.44 | 416.58 | 415.7 | 416.54 | 400943.0 |
| 2024-08-14 15:00:00 | MSFT | Stock | 416.545 | 417.72 | 415.12 | 416.62 | 1437479.0 |
| 2024-08-14 16:00:00 | MSFT | Stock | 416.86 | 418.28 | 416.72 | 418.05 | 4360727.0 |
| 2024-08-14 17:00:00 | MSFT | Stock | 418.224 | 418.28 | 417.77 | 417.77 | 5542.0 |
| 2024-08-14 18:00:00 | MSFT | Stock | 418.23 | 418.23 | 417.25 | 417.54 | 1764.0 |
| 2024-08-14 19:00:00 | MSFT | Stock | 417.55 | 417.8 | 417.0 | 417.25 | 7940.0 |
| 2024-08-14 04:00:00 | NVDA | Stock | 116.9 | 117.25 | 116.15 | 116.78 | 795187.0 |
| 2024-08-14 05:00:00 | NVDA | Stock | 116.81 | 117.9 | 116.75 | 117.65 | 500630.0 |
| 2024-08-14 06:00:00 | NVDA | Stock | 117.68 | 118.33 | 117.6 | 117.79 | 803420.0 |
| 2024-08-14 07:00:00 | NVDA | Stock | 117.79 | 118.3 | 117.7 | 118.25 | 2133736.0 |
| 2024-08-14 08:00:00 | NVDA | Stock | 118.24 | 119.0 | 116.4631 | 118.2398 | 9388700.0 |
| 2024-08-14 09:00:00 | NVDA | Stock | 118.22 | 119.5 | 114.07 | 115.01 | 67362220.0 |
| 2024-08-14 10:00:00 | NVDA | Stock | 115.03 | 117.189 | 114.51 | 117.04 | 55171985.0 |
| 2024-08-14 11:00:00 | NVDA | Stock | 117.04 | 118.43 | 116.61 | 118.3494 | 39065341.0 |
| 2024-08-14 12:00:00 | NVDA | Stock | 118.3444 | 118.47 | 116.22 | 116.7 | 36698111.0 |
| 2024-08-14 13:00:00 | NVDA | Stock | 116.69 | 117.59 | 116.51 | 116.7899 | 22430883.0 |
| 2024-08-14 14:00:00 | NVDA | Stock | 116.78 | 117.5 | 116.55 | 117.47 | 16967206.0 |
| 2024-08-14 15:00:00 | NVDA | Stock | 117.47 | 118.24 | 116.75 | 117.97 | 33268565.0 |
| 2024-08-14 16:00:00 | NVDA | Stock | 117.98 | 118.35 | 117.55 | 117.78 | 18648685.0 |
| 2024-08-14 17:00:00 | NVDA | Stock | 117.77 | 118.0 | 117.7501 | 117.94 | 357719.0 |
| 2024-08-14 18:00:00 | NVDA | Stock | 117.96 | 118.0 | 117.69 | 117.7296 | 383790.0 |
| 2024-08-14 19:00:00 | NVDA | Stock | 117.7109 | 117.79 | 117.26 | 117.28 | 561669.0 |
| 2024-08-14 04:00:00 | AMZN | Stock | 170.45 | 170.65 | 170.03 | 170.57 | 9741.0 |
| 2024-08-14 05:00:00 | AMZN | Stock | 170.63 | 170.72 | 170.55 | 170.6 | 2757.0 |
> showing 50 of 58,279 rows — these rows as CSV