PREVIEW / stock_1hour / 2002-04-10
file: by_date/stock_1hour/2002/2002-04-10.parquet size: 400 KB rows: 18,871 symbols: 1,398
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 |
|---|---|---|---|---|---|---|---|
| 2002-04-10 08:00:00 | AAPL | Stock | 0.4329 | 0.4329 | 0.4327 | 0.4327 | 72800.0 |
| 2002-04-10 09:00:00 | AAPL | Stock | 0.4323 | 0.4352 | 0.4288 | 0.4313 | 21487200.0 |
| 2002-04-10 10:00:00 | AAPL | Stock | 0.4313 | 0.438 | 0.4307 | 0.435 | 22881600.0 |
| 2002-04-10 11:00:00 | AAPL | Stock | 0.4346 | 0.4393 | 0.4339 | 0.4384 | 27787200.0 |
| 2002-04-10 12:00:00 | AAPL | Stock | 0.4379 | 0.4398 | 0.4332 | 0.4345 | 15136800.0 |
| 2002-04-10 13:00:00 | AAPL | Stock | 0.4345 | 0.4429 | 0.4343 | 0.4421 | 34529600.0 |
| 2002-04-10 14:00:00 | AAPL | Stock | 0.4418 | 0.4455 | 0.4409 | 0.4438 | 47756800.0 |
| 2002-04-10 15:00:00 | AAPL | Stock | 0.4445 | 0.4446 | 0.4395 | 0.4407 | 39816000.0 |
| 2002-04-10 16:00:00 | AAPL | Stock | 0.4405 | 0.4464 | 0.4387 | 0.4429 | 6053600.0 |
| 2002-04-10 17:00:00 | AAPL | Stock | 0.437 | 0.4429 | 0.437 | 0.4429 | 50400.0 |
| 2002-04-10 08:00:00 | MSFT | Stock | 27.5 | 27.75 | 27.2 | 27.6 | 74800.0 |
| 2002-04-10 09:00:00 | MSFT | Stock | 27.6 | 27.815 | 27.515 | 27.6915 | 8405000.0 |
| 2002-04-10 10:00:00 | MSFT | Stock | 27.685 | 28.245 | 27.65 | 28.1 | 12578000.0 |
| 2002-04-10 11:00:00 | MSFT | Stock | 28.095 | 28.19 | 27.8055 | 27.955 | 10598200.0 |
| 2002-04-10 12:00:00 | MSFT | Stock | 27.9645 | 28.025 | 27.71 | 27.85 | 8164800.0 |
| 2002-04-10 13:00:00 | MSFT | Stock | 27.85 | 28.175 | 27.755 | 28.175 | 7723000.0 |
| 2002-04-10 14:00:00 | MSFT | Stock | 28.175 | 28.555 | 28.135 | 28.2795 | 11020200.0 |
| 2002-04-10 15:00:00 | MSFT | Stock | 28.275 | 28.425 | 27.875 | 28.15 | 11925800.0 |
| 2002-04-10 16:00:00 | MSFT | Stock | 28.145 | 28.385 | 27.83 | 28.15 | 1533800.0 |
| 2002-04-10 17:00:00 | MSFT | Stock | 28.0199 | 28.24 | 28.0199 | 28.15 | 34800.0 |
| 2002-04-10 18:00:00 | MSFT | Stock | 28.175 | 28.19 | 28.175 | 28.19 | 1400.0 |
| 2002-04-10 08:00:00 | NVDA | Stock | 0.3417 | 0.3421 | 0.3392 | 0.3412 | 2724000.0 |
| 2002-04-10 09:00:00 | NVDA | Stock | 0.3403 | 0.3437 | 0.3372 | 0.3372 | 215832000.0 |
| 2002-04-10 10:00:00 | NVDA | Stock | 0.3373 | 0.345 | 0.3348 | 0.3389 | 430368000.0 |
| 2002-04-10 11:00:00 | NVDA | Stock | 0.3389 | 0.3408 | 0.3092 | 0.3097 | 558432000.0 |
| 2002-04-10 12:00:00 | NVDA | Stock | 0.3099 | 0.3154 | 0.3012 | 0.3029 | 558708000.0 |
| 2002-04-10 13:00:00 | NVDA | Stock | 0.3027 | 0.3175 | 0.2967 | 0.3137 | 680448000.0 |
| 2002-04-10 14:00:00 | NVDA | Stock | 0.314 | 0.3243 | 0.313 | 0.3235 | 549828000.0 |
| 2002-04-10 15:00:00 | NVDA | Stock | 0.3235 | 0.325 | 0.3157 | 0.3212 | 491676000.0 |
| 2002-04-10 16:00:00 | NVDA | Stock | 0.3212 | 0.3231 | 0.3194 | 0.3227 | 29364000.0 |
| 2002-04-10 17:00:00 | NVDA | Stock | 0.3216 | 0.3229 | 0.3214 | 0.3216 | 2100000.0 |
| 2002-04-10 18:00:00 | NVDA | Stock | 0.3216 | 0.3222 | 0.3216 | 0.3221 | 120000.0 |
| 2002-04-10 08:00:00 | AMZN | Stock | 0.6775 | 0.69 | 0.676 | 0.69 | 14000.0 |
| 2002-04-10 09:00:00 | AMZN | Stock | 0.691 | 0.695 | 0.6835 | 0.688 | 11344000.0 |
| 2002-04-10 10:00:00 | AMZN | Stock | 0.688 | 0.6985 | 0.6855 | 0.694 | 11768000.0 |
| 2002-04-10 11:00:00 | AMZN | Stock | 0.6935 | 0.694 | 0.676 | 0.678 | 9376000.0 |
| 2002-04-10 12:00:00 | AMZN | Stock | 0.677 | 0.6825 | 0.6525 | 0.6565 | 16650000.0 |
| 2002-04-10 13:00:00 | AMZN | Stock | 0.6565 | 0.673 | 0.653 | 0.6665 | 12338000.0 |
| 2002-04-10 14:00:00 | AMZN | Stock | 0.666 | 0.6705 | 0.664 | 0.6705 | 10980000.0 |
| 2002-04-10 15:00:00 | AMZN | Stock | 0.67 | 0.68 | 0.665 | 0.674 | 17062000.0 |
| 2002-04-10 16:00:00 | AMZN | Stock | 0.6725 | 0.69 | 0.6725 | 0.675 | 12066000.0 |
| 2002-04-10 17:00:00 | AMZN | Stock | 0.6745 | 0.6745 | 0.6625 | 0.668 | 166000.0 |
| 2002-04-10 18:00:00 | AMZN | Stock | 0.674 | 0.674 | 0.6625 | 0.6625 | 158000.0 |
| 2002-04-10 09:00:00 | CL | Stock | 28.625 | 28.725 | 28.6 | 28.65 | 276200.0 |
| 2002-04-10 10:00:00 | CL | Stock | 28.655 | 28.955 | 28.65 | 28.925 | 712200.0 |
| 2002-04-10 11:00:00 | CL | Stock | 28.92 | 28.92 | 28.5 | 28.625 | 1104200.0 |
| 2002-04-10 12:00:00 | CL | Stock | 28.645 | 28.75 | 28.62 | 28.715 | 353000.0 |
| 2002-04-10 13:00:00 | CL | Stock | 28.74 | 28.8 | 28.665 | 28.8 | 330000.0 |
| 2002-04-10 14:00:00 | CL | Stock | 28.795 | 28.92 | 28.79 | 28.9 | 423800.0 |
| 2002-04-10 15:00:00 | CL | Stock | 28.9 | 29.265 | 28.9 | 29.2 | 1337400.0 |
> showing 50 of 18,871 rows — these rows as CSV