PREVIEW / stock_1hour / 2004-01-08
file: by_date/stock_1hour/2004/2004-01-08.parquet size: 504 KB rows: 23,322 symbols: 1,713
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-08 08:00:00 | AAPL | Stock | 0.4054 | 0.4055 | 0.4054 | 0.4054 | 560000.0 |
| 2004-01-08 09:00:00 | AAPL | Stock | 0.4054 | 0.4143 | 0.4052 | 0.4134 | 74462528.0 |
| 2004-01-08 10:00:00 | AAPL | Stock | 0.4132 | 0.4141 | 0.4084 | 0.4111 | 57549352.0 |
| 2004-01-08 11:00:00 | AAPL | Stock | 0.411 | 0.4139 | 0.4098 | 0.4132 | 32525640.0 |
| 2004-01-08 12:00:00 | AAPL | Stock | 0.4132 | 0.4148 | 0.4129 | 0.4134 | 24896872.0 |
| 2004-01-08 13:00:00 | AAPL | Stock | 0.4134 | 0.4204 | 0.4129 | 0.4202 | 49062888.0 |
| 2004-01-08 14:00:00 | AAPL | Stock | 0.4202 | 0.4238 | 0.4175 | 0.422 | 69606768.0 |
| 2004-01-08 15:00:00 | AAPL | Stock | 0.422 | 0.4227 | 0.4155 | 0.418 | 94760624.0 |
| 2004-01-08 16:00:00 | AAPL | Stock | 0.418 | 0.4214 | 0.4155 | 0.4214 | 16348136.0 |
| 2004-01-08 17:00:00 | AAPL | Stock | 0.4214 | 0.4214 | 0.4182 | 0.42 | 446768.0 |
| 2004-01-08 08:00:00 | MSFT | Stock | 28.22 | 29.03 | 28.1 | 28.4 | 69814.0 |
| 2004-01-08 09:00:00 | MSFT | Stock | 28.4 | 28.48 | 28.21 | 28.289 | 7145494.0 |
| 2004-01-08 10:00:00 | MSFT | Stock | 28.29 | 28.33 | 28.13 | 28.15 | 8262839.0 |
| 2004-01-08 11:00:00 | MSFT | Stock | 28.14 | 28.2 | 28.0 | 28.07 | 7489954.0 |
| 2004-01-08 12:00:00 | MSFT | Stock | 28.07 | 28.14 | 28.07 | 28.12 | 7352980.0 |
| 2004-01-08 13:00:00 | MSFT | Stock | 28.12 | 28.14 | 28.05 | 28.11 | 5114466.0 |
| 2004-01-08 14:00:00 | MSFT | Stock | 28.11 | 28.14 | 28.05 | 28.1 | 5035010.0 |
| 2004-01-08 15:00:00 | MSFT | Stock | 28.1 | 28.2 | 28.05 | 28.17 | 9520889.0 |
| 2004-01-08 16:00:00 | MSFT | Stock | 28.15 | 28.25 | 28.09 | 28.17 | 3508630.0 |
| 2004-01-08 17:00:00 | MSFT | Stock | 28.14 | 28.23 | 28.1 | 28.13 | 39127.0 |
| 2004-01-08 18:00:00 | MSFT | Stock | 28.13 | 28.14 | 28.11 | 28.11 | 4590.0 |
| 2004-01-08 08:00:00 | NVDA | Stock | 0.2096 | 0.2097 | 0.2096 | 0.2096 | 288000.0 |
| 2004-01-08 09:00:00 | NVDA | Stock | 0.2104 | 0.2121 | 0.2085 | 0.2099 | 93699720.0 |
| 2004-01-08 10:00:00 | NVDA | Stock | 0.21 | 0.2103 | 0.2072 | 0.208 | 65755920.0 |
| 2004-01-08 11:00:00 | NVDA | Stock | 0.208 | 0.2099 | 0.2078 | 0.2092 | 58796160.0 |
| 2004-01-08 12:00:00 | NVDA | Stock | 0.2091 | 0.2097 | 0.2082 | 0.2096 | 34961520.0 |
| 2004-01-08 13:00:00 | NVDA | Stock | 0.2096 | 0.2104 | 0.2083 | 0.2098 | 51187680.0 |
| 2004-01-08 14:00:00 | NVDA | Stock | 0.2098 | 0.2101 | 0.2087 | 0.2093 | 45881760.0 |
| 2004-01-08 15:00:00 | NVDA | Stock | 0.2092 | 0.2097 | 0.2087 | 0.2096 | 68766240.0 |
| 2004-01-08 16:00:00 | NVDA | Stock | 0.2096 | 0.21 | 0.2091 | 0.2097 | 5115600.0 |
| 2004-01-08 17:00:00 | NVDA | Stock | 0.2097 | 0.2097 | 0.209 | 0.2092 | 748680.0 |
| 2004-01-08 08:00:00 | AMZN | Stock | 2.5995 | 2.6125 | 2.5995 | 2.61 | 280300.0 |
| 2004-01-08 09:00:00 | AMZN | Stock | 2.61 | 2.6105 | 2.535 | 2.549 | 36616540.0 |
| 2004-01-08 10:00:00 | AMZN | Stock | 2.549 | 2.558 | 2.518 | 2.5225 | 49355540.0 |
| 2004-01-08 11:00:00 | AMZN | Stock | 2.5224 | 2.534 | 2.517 | 2.5275 | 25573120.0 |
| 2004-01-08 12:00:00 | AMZN | Stock | 2.5265 | 2.5345 | 2.5225 | 2.5305 | 9895160.0 |
| 2004-01-08 13:00:00 | AMZN | Stock | 2.531 | 2.5452 | 2.525 | 2.5305 | 16254640.0 |
| 2004-01-08 14:00:00 | AMZN | Stock | 2.531 | 2.531 | 2.5015 | 2.5109 | 28694640.0 |
| 2004-01-08 15:00:00 | AMZN | Stock | 2.51 | 2.529 | 2.5075 | 2.5115 | 35124360.0 |
| 2004-01-08 16:00:00 | AMZN | Stock | 2.5115 | 2.5195 | 2.504 | 2.507 | 1528500.0 |
| 2004-01-08 17:00:00 | AMZN | Stock | 2.507 | 2.509 | 2.5025 | 2.5025 | 235000.0 |
| 2004-01-08 18:00:00 | AMZN | Stock | 2.505 | 2.505 | 2.5045 | 2.505 | 20000.0 |
| 2004-01-08 09:00:00 | CL | Stock | 25.34 | 25.42 | 25.33 | 25.38 | 859600.0 |
| 2004-01-08 10:00:00 | CL | Stock | 25.38 | 25.465 | 25.355 | 25.375 | 945400.0 |
| 2004-01-08 11:00:00 | CL | Stock | 25.375 | 25.4 | 25.3 | 25.3 | 613400.0 |
| 2004-01-08 12:00:00 | CL | Stock | 25.3 | 25.365 | 25.26 | 25.305 | 549400.0 |
| 2004-01-08 13:00:00 | CL | Stock | 25.305 | 25.335 | 25.265 | 25.315 | 445800.0 |
| 2004-01-08 14:00:00 | CL | Stock | 25.315 | 25.365 | 25.285 | 25.315 | 620400.0 |
| 2004-01-08 15:00:00 | CL | Stock | 25.315 | 25.38 | 25.3 | 25.36 | 937200.0 |
| 2004-01-08 16:00:00 | CL | Stock | 25.375 | 25.385 | 25.37 | 25.385 | 4800.0 |
> showing 50 of 23,322 rows — these rows as CSV