PREVIEW / stock_1hour / 2022-12-22
file: by_date/stock_1hour/2022/2022-12-22.parquet size: 1.3 MB rows: 60,369 symbols: 1,961
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 |
|---|---|---|---|---|---|---|---|
| 2022-12-22 04:00:00 | AAPL | Stock | 135.95 | 135.95 | 135.45 | 135.45 | 11859.0 |
| 2022-12-22 05:00:00 | AAPL | Stock | 135.39 | 135.44 | 135.27 | 135.36 | 7440.0 |
| 2022-12-22 06:00:00 | AAPL | Stock | 135.32 | 135.32 | 135.12 | 135.21 | 5291.0 |
| 2022-12-22 07:00:00 | AAPL | Stock | 135.25 | 135.44 | 134.8 | 134.93 | 61043.0 |
| 2022-12-22 08:00:00 | AAPL | Stock | 135.29 | 136.0 | 133.8 | 133.8696 | 430025.0 |
| 2022-12-22 09:00:00 | AAPL | Stock | 133.87 | 134.56 | 133.17 | 133.5392 | 6861731.0 |
| 2022-12-22 10:00:00 | AAPL | Stock | 133.53 | 133.535 | 131.135 | 131.5381 | 11382117.0 |
| 2022-12-22 11:00:00 | AAPL | Stock | 131.535 | 132.01 | 131.0501 | 131.705 | 6487840.0 |
| 2022-12-22 12:00:00 | AAPL | Stock | 131.701 | 131.775 | 130.7 | 131.01 | 5912013.0 |
| 2022-12-22 13:00:00 | AAPL | Stock | 131.0117 | 131.055 | 130.3 | 130.79 | 6238815.0 |
| 2022-12-22 14:00:00 | AAPL | Stock | 130.808 | 131.55 | 130.65 | 131.5 | 6933679.0 |
| 2022-12-22 15:00:00 | AAPL | Stock | 131.5 | 132.36 | 131.17 | 132.25 | 14145602.0 |
| 2022-12-22 16:00:00 | AAPL | Stock | 132.225 | 132.5 | 131.92 | 132.1726 | 9707842.0 |
| 2022-12-22 17:00:00 | AAPL | Stock | 132.1867 | 132.19 | 132.05 | 132.17 | 52182.0 |
| 2022-12-22 18:00:00 | AAPL | Stock | 132.19 | 132.19 | 132.0 | 132.03 | 61031.0 |
| 2022-12-22 19:00:00 | AAPL | Stock | 132.0 | 132.01 | 131.25 | 131.3 | 61974.0 |
| 2022-12-22 04:00:00 | MSFT | Stock | 244.85 | 244.85 | 244.56 | 244.7 | 2278.0 |
| 2022-12-22 05:00:00 | MSFT | Stock | 244.51 | 244.51 | 244.42 | 244.42 | 1836.0 |
| 2022-12-22 06:00:00 | MSFT | Stock | 243.82 | 244.15 | 243.82 | 244.15 | 2219.0 |
| 2022-12-22 07:00:00 | MSFT | Stock | 244.1 | 244.1 | 243.31 | 243.6 | 11040.0 |
| 2022-12-22 08:00:00 | MSFT | Stock | 244.0101 | 244.0101 | 240.29 | 240.75 | 31029.0 |
| 2022-12-22 09:00:00 | MSFT | Stock | 240.65 | 241.99 | 238.95 | 239.48 | 1994413.0 |
| 2022-12-22 10:00:00 | MSFT | Stock | 239.48 | 239.48 | 234.72 | 236.19 | 3629346.0 |
| 2022-12-22 11:00:00 | MSFT | Stock | 236.19 | 236.48 | 235.04 | 236.11 | 1855400.0 |
| 2022-12-22 12:00:00 | MSFT | Stock | 236.09 | 236.44 | 234.81 | 235.44 | 2041441.0 |
| 2022-12-22 13:00:00 | MSFT | Stock | 235.44 | 235.44 | 233.87 | 235.01 | 1507264.0 |
| 2022-12-22 14:00:00 | MSFT | Stock | 235.02 | 236.87 | 235.02 | 236.799 | 1785962.0 |
| 2022-12-22 15:00:00 | MSFT | Stock | 236.8 | 238.63 | 236.45 | 238.28 | 5122107.0 |
| 2022-12-22 16:00:00 | MSFT | Stock | 238.27 | 238.46 | 237.41 | 237.74 | 4561217.0 |
| 2022-12-22 17:00:00 | MSFT | Stock | 237.56 | 238.15 | 237.56 | 238.15 | 9815.0 |
| 2022-12-22 18:00:00 | MSFT | Stock | 237.9 | 238.0 | 237.4 | 237.55 | 3986.0 |
| 2022-12-22 19:00:00 | MSFT | Stock | 237.64 | 237.7 | 237.0 | 237.0 | 2571.0 |
| 2022-12-22 04:00:00 | NVDA | Stock | 16.524 | 16.524 | 16.44 | 16.44 | 6690.0 |
| 2022-12-22 05:00:00 | NVDA | Stock | 16.42 | 16.446 | 16.395 | 16.418 | 64430.0 |
| 2022-12-22 06:00:00 | NVDA | Stock | 16.418 | 16.429 | 16.382 | 16.388 | 44600.0 |
| 2022-12-22 07:00:00 | NVDA | Stock | 16.41 | 16.42 | 16.255 | 16.27 | 462770.0 |
| 2022-12-22 08:00:00 | NVDA | Stock | 16.42 | 16.6 | 16.112 | 16.135 | 1461240.0 |
| 2022-12-22 09:00:00 | NVDA | Stock | 16.126 | 16.141 | 15.6462 | 15.72 | 56215810.0 |
| 2022-12-22 10:00:00 | NVDA | Stock | 15.719 | 15.731 | 15.356 | 15.388 | 79269860.0 |
| 2022-12-22 11:00:00 | NVDA | Stock | 15.389 | 15.418 | 15.056 | 15.083 | 57454490.0 |
| 2022-12-22 12:00:00 | NVDA | Stock | 15.081 | 15.132 | 14.914 | 15.063 | 54432870.0 |
| 2022-12-22 13:00:00 | NVDA | Stock | 15.0615 | 15.063 | 14.882 | 14.9973 | 49616980.0 |
| 2022-12-22 14:00:00 | NVDA | Stock | 14.999 | 15.155 | 14.981 | 15.145 | 46182560.0 |
| 2022-12-22 15:00:00 | NVDA | Stock | 15.145 | 15.435 | 15.117 | 15.34 | 98570990.0 |
| 2022-12-22 16:00:00 | NVDA | Stock | 15.34 | 15.366 | 15.286 | 15.304 | 34199790.0 |
| 2022-12-22 17:00:00 | NVDA | Stock | 15.3 | 15.339 | 15.292 | 15.325 | 326760.0 |
| 2022-12-22 18:00:00 | NVDA | Stock | 15.32 | 15.335 | 15.29 | 15.3 | 142010.0 |
| 2022-12-22 19:00:00 | NVDA | Stock | 15.3 | 15.305 | 15.166 | 15.166 | 260840.0 |
| 2022-12-22 04:00:00 | AMZN | Stock | 87.04 | 87.1 | 86.93 | 86.95 | 8563.0 |
| 2022-12-22 05:00:00 | AMZN | Stock | 86.94 | 86.95 | 86.74 | 86.87 | 12597.0 |
> showing 50 of 60,369 rows — these rows as CSV