PREVIEW / stock_1hour / 2023-12-08
file: by_date/stock_1hour/2023/2023-12-08.parquet size: 1.3 MB rows: 58,870 symbols: 1,262
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 |
|---|---|---|---|---|---|---|---|
| 2023-12-08 04:00:00 | AAPL | Stock | 194.0 | 194.17 | 194.0 | 194.13 | 2486.0 |
| 2023-12-08 05:00:00 | AAPL | Stock | 194.13 | 194.3 | 194.13 | 194.23 | 5895.0 |
| 2023-12-08 06:00:00 | AAPL | Stock | 194.22 | 194.33 | 194.0 | 194.0 | 12130.0 |
| 2023-12-08 07:00:00 | AAPL | Stock | 193.9 | 194.05 | 193.78 | 194.05 | 14518.0 |
| 2023-12-08 08:00:00 | AAPL | Stock | 193.85 | 194.39 | 193.44 | 194.1 | 287222.0 |
| 2023-12-08 09:00:00 | AAPL | Stock | 194.11 | 194.55 | 193.65 | 193.82 | 4939354.0 |
| 2023-12-08 10:00:00 | AAPL | Stock | 193.82 | 195.0 | 193.82 | 194.9799 | 6060886.0 |
| 2023-12-08 11:00:00 | AAPL | Stock | 194.975 | 195.0 | 194.271 | 194.4501 | 3398638.0 |
| 2023-12-08 12:00:00 | AAPL | Stock | 194.455 | 195.3 | 194.335 | 195.1701 | 4940972.0 |
| 2023-12-08 13:00:00 | AAPL | Stock | 195.18 | 195.6353 | 195.02 | 195.6137 | 3429175.0 |
| 2023-12-08 14:00:00 | AAPL | Stock | 195.62 | 195.98 | 195.45 | 195.8299 | 3935270.0 |
| 2023-12-08 15:00:00 | AAPL | Stock | 195.835 | 195.99 | 195.41 | 195.72 | 6404099.0 |
| 2023-12-08 16:00:00 | AAPL | Stock | 195.72 | 195.77 | 195.61 | 195.69 | 9098112.0 |
| 2023-12-08 17:00:00 | AAPL | Stock | 195.71 | 195.74 | 195.1825 | 195.71 | 118987.0 |
| 2023-12-08 18:00:00 | AAPL | Stock | 195.72 | 195.73 | 195.66 | 195.71 | 16182.0 |
| 2023-12-08 19:00:00 | AAPL | Stock | 195.7 | 195.79 | 195.68 | 195.79 | 7068.0 |
| 2023-12-08 04:00:00 | MSFT | Stock | 369.86 | 369.86 | 369.85 | 369.85 | 500.0 |
| 2023-12-08 05:00:00 | MSFT | Stock | 370.14 | 370.14 | 368.91 | 369.0 | 3921.0 |
| 2023-12-08 06:00:00 | MSFT | Stock | 369.25 | 369.25 | 368.55 | 368.55 | 1304.0 |
| 2023-12-08 07:00:00 | MSFT | Stock | 368.89 | 370.2 | 368.89 | 369.8 | 5752.0 |
| 2023-12-08 08:00:00 | MSFT | Stock | 369.2 | 370.51 | 368.0 | 369.5 | 60613.0 |
| 2023-12-08 09:00:00 | MSFT | Stock | 369.87 | 370.92 | 368.23 | 370.45 | 1878676.0 |
| 2023-12-08 10:00:00 | MSFT | Stock | 370.48 | 373.33 | 370.4286 | 373.1476 | 2411072.0 |
| 2023-12-08 11:00:00 | MSFT | Stock | 373.16 | 373.38 | 371.01 | 372.1424 | 1556594.0 |
| 2023-12-08 12:00:00 | MSFT | Stock | 372.13 | 373.04 | 371.315 | 372.86 | 915941.0 |
| 2023-12-08 13:00:00 | MSFT | Stock | 372.92 | 373.29 | 372.63 | 373.24 | 930076.0 |
| 2023-12-08 14:00:00 | MSFT | Stock | 373.25 | 373.97 | 373.1547 | 373.57 | 1142939.0 |
| 2023-12-08 15:00:00 | MSFT | Stock | 373.59 | 374.46 | 373.2 | 374.25 | 2178980.0 |
| 2023-12-08 16:00:00 | MSFT | Stock | 374.22 | 374.23 | 373.61 | 373.8 | 3402855.0 |
| 2023-12-08 17:00:00 | MSFT | Stock | 374.23 | 374.23 | 372.8622 | 373.9 | 48413.0 |
| 2023-12-08 18:00:00 | MSFT | Stock | 373.94 | 373.94 | 373.81 | 373.81 | 1596.0 |
| 2023-12-08 19:00:00 | MSFT | Stock | 373.93 | 373.94 | 373.7 | 373.93 | 3725.0 |
| 2023-12-08 04:00:00 | NVDA | Stock | 46.49 | 47.0 | 46.49 | 46.944 | 166600.0 |
| 2023-12-08 05:00:00 | NVDA | Stock | 46.921 | 46.925 | 46.855 | 46.87 | 38790.0 |
| 2023-12-08 06:00:00 | NVDA | Stock | 46.864 | 46.864 | 46.632 | 46.65 | 74160.0 |
| 2023-12-08 07:00:00 | NVDA | Stock | 46.7 | 46.8 | 46.596 | 46.599 | 250630.0 |
| 2023-12-08 08:00:00 | NVDA | Stock | 46.69 | 46.774 | 46.225 | 46.544 | 2877450.0 |
| 2023-12-08 09:00:00 | NVDA | Stock | 46.54 | 47.277 | 46.439 | 47.11 | 48622700.0 |
| 2023-12-08 10:00:00 | NVDA | Stock | 47.116 | 47.74 | 47.116 | 47.72 | 65010780.0 |
| 2023-12-08 11:00:00 | NVDA | Stock | 47.722 | 47.7408 | 47.328 | 47.417 | 35239120.0 |
| 2023-12-08 12:00:00 | NVDA | Stock | 47.413 | 47.586 | 47.163 | 47.577 | 29045230.0 |
| 2023-12-08 13:00:00 | NVDA | Stock | 47.577 | 47.633 | 47.478 | 47.5492 | 18906100.0 |
| 2023-12-08 14:00:00 | NVDA | Stock | 47.555 | 47.698 | 47.528 | 47.646 | 20314510.0 |
| 2023-12-08 15:00:00 | NVDA | Stock | 47.6426 | 47.649 | 47.427 | 47.508 | 33765970.0 |
| 2023-12-08 16:00:00 | NVDA | Stock | 47.507 | 47.513 | 47.48 | 47.5 | 14575440.0 |
| 2023-12-08 17:00:00 | NVDA | Stock | 47.5 | 47.506 | 47.4106 | 47.4756 | 504570.0 |
| 2023-12-08 18:00:00 | NVDA | Stock | 47.479 | 47.506 | 47.465 | 47.497 | 92170.0 |
| 2023-12-08 19:00:00 | NVDA | Stock | 47.5 | 47.524 | 47.489 | 47.497 | 193000.0 |
| 2023-12-08 04:00:00 | AMZN | Stock | 146.9 | 146.9 | 146.38 | 146.45 | 3431.0 |
| 2023-12-08 05:00:00 | AMZN | Stock | 146.58 | 146.62 | 146.51 | 146.6 | 3210.0 |
> showing 50 of 58,870 rows — these rows as CSV