PREVIEW / stock_1hour / 2001-05-10
file: by_date/stock_1hour/2001/2001-05-10.parquet size: 357 KB rows: 16,874 symbols: 1,282
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 |
|---|---|---|---|---|---|---|---|
| 2001-05-10 08:00:00 | AAPL | Stock | 0.4321 | 0.4375 | 0.4279 | 0.4321 | 868000.0 |
| 2001-05-10 09:00:00 | AAPL | Stock | 0.4321 | 0.4375 | 0.428 | 0.4298 | 44469600.0 |
| 2001-05-10 10:00:00 | AAPL | Stock | 0.4298 | 0.4321 | 0.4273 | 0.4311 | 31948000.0 |
| 2001-05-10 11:00:00 | AAPL | Stock | 0.4311 | 0.4316 | 0.4239 | 0.425 | 27126400.0 |
| 2001-05-10 12:00:00 | AAPL | Stock | 0.4248 | 0.4259 | 0.4202 | 0.4218 | 31752000.0 |
| 2001-05-10 13:00:00 | AAPL | Stock | 0.4229 | 0.4277 | 0.4216 | 0.4248 | 18855200.0 |
| 2001-05-10 14:00:00 | AAPL | Stock | 0.4248 | 0.4268 | 0.4196 | 0.4202 | 30833600.0 |
| 2001-05-10 15:00:00 | AAPL | Stock | 0.4205 | 0.4214 | 0.4098 | 0.4105 | 65430400.0 |
| 2001-05-10 16:00:00 | AAPL | Stock | 0.4105 | 0.4221 | 0.408 | 0.4113 | 22943200.0 |
| 2001-05-10 17:00:00 | AAPL | Stock | 0.4098 | 0.4098 | 0.4095 | 0.4095 | 67200.0 |
| 2001-05-10 18:00:00 | AAPL | Stock | 0.4095 | 0.4107 | 0.4095 | 0.4107 | 44800.0 |
| 2001-05-10 08:00:00 | MSFT | Stock | 35.725 | 35.75 | 35.375 | 35.6 | 188000.0 |
| 2001-05-10 09:00:00 | MSFT | Stock | 35.62 | 35.625 | 35.06 | 35.435 | 10048800.0 |
| 2001-05-10 10:00:00 | MSFT | Stock | 35.45 | 35.6 | 35.295 | 35.54 | 10508800.0 |
| 2001-05-10 11:00:00 | MSFT | Stock | 35.55 | 35.58 | 35.375 | 35.425 | 8859200.0 |
| 2001-05-10 12:00:00 | MSFT | Stock | 35.42 | 35.6 | 35.25 | 35.445 | 5825400.0 |
| 2001-05-10 13:00:00 | MSFT | Stock | 35.435 | 35.495 | 35.315 | 35.405 | 5189400.0 |
| 2001-05-10 14:00:00 | MSFT | Stock | 35.395 | 35.425 | 35.035 | 35.07 | 6251400.0 |
| 2001-05-10 15:00:00 | MSFT | Stock | 35.07 | 35.16 | 35.0 | 35.005 | 13757400.0 |
| 2001-05-10 16:00:00 | MSFT | Stock | 35.005 | 35.35 | 34.97 | 35.015 | 1681600.0 |
| 2001-05-10 17:00:00 | MSFT | Stock | 35.025 | 35.09 | 35.0 | 35.0 | 10600.0 |
| 2001-05-10 18:00:00 | MSFT | Stock | 35.06 | 35.06 | 35.0 | 35.0 | 4600.0 |
| 2001-05-10 08:00:00 | NVDA | Stock | 0.3521 | 0.3604 | 0.351 | 0.3542 | 3960000.0 |
| 2001-05-10 09:00:00 | NVDA | Stock | 0.3551 | 0.36 | 0.349 | 0.3506 | 191664000.0 |
| 2001-05-10 10:00:00 | NVDA | Stock | 0.3504 | 0.3525 | 0.3458 | 0.3474 | 120432000.0 |
| 2001-05-10 11:00:00 | NVDA | Stock | 0.3479 | 0.3485 | 0.3363 | 0.3365 | 197736000.0 |
| 2001-05-10 12:00:00 | NVDA | Stock | 0.3365 | 0.3383 | 0.334 | 0.3365 | 127128000.0 |
| 2001-05-10 13:00:00 | NVDA | Stock | 0.3368 | 0.3425 | 0.3354 | 0.3421 | 64464000.0 |
| 2001-05-10 14:00:00 | NVDA | Stock | 0.3419 | 0.3426 | 0.33 | 0.3303 | 103320000.0 |
| 2001-05-10 15:00:00 | NVDA | Stock | 0.3304 | 0.3365 | 0.33 | 0.3338 | 119040000.0 |
| 2001-05-10 16:00:00 | NVDA | Stock | 0.3338 | 0.3344 | 0.333 | 0.334 | 6528000.0 |
| 2001-05-10 17:00:00 | NVDA | Stock | 0.335 | 0.3356 | 0.3341 | 0.3356 | 552000.0 |
| 2001-05-10 18:00:00 | NVDA | Stock | 0.3342 | 0.3356 | 0.3342 | 0.3342 | 168000.0 |
| 2001-05-10 08:00:00 | AMZN | Stock | 0.769 | 0.775 | 0.7625 | 0.775 | 104000.0 |
| 2001-05-10 09:00:00 | AMZN | Stock | 0.775 | 0.782 | 0.7625 | 0.7645 | 10952000.0 |
| 2001-05-10 10:00:00 | AMZN | Stock | 0.7635 | 0.77 | 0.75 | 0.757 | 17714000.0 |
| 2001-05-10 11:00:00 | AMZN | Stock | 0.7565 | 0.7695 | 0.754 | 0.76 | 10228000.0 |
| 2001-05-10 12:00:00 | AMZN | Stock | 0.76 | 0.766 | 0.755 | 0.7575 | 10360000.0 |
| 2001-05-10 13:00:00 | AMZN | Stock | 0.7585 | 0.7685 | 0.7575 | 0.7655 | 7086000.0 |
| 2001-05-10 14:00:00 | AMZN | Stock | 0.7655 | 0.768 | 0.7525 | 0.754 | 10140000.0 |
| 2001-05-10 15:00:00 | AMZN | Stock | 0.7535 | 0.755 | 0.73 | 0.7305 | 26034000.0 |
| 2001-05-10 16:00:00 | AMZN | Stock | 0.7305 | 0.734 | 0.6425 | 0.7285 | 4394000.0 |
| 2001-05-10 17:00:00 | AMZN | Stock | 0.7285 | 0.73 | 0.7285 | 0.73 | 22000.0 |
| 2001-05-10 09:00:00 | CL | Stock | 28.875 | 28.875 | 28.695 | 28.85 | 223800.0 |
| 2001-05-10 10:00:00 | CL | Stock | 28.85 | 28.995 | 28.73 | 28.825 | 474200.0 |
| 2001-05-10 11:00:00 | CL | Stock | 28.8 | 28.95 | 28.76 | 28.825 | 302600.0 |
| 2001-05-10 12:00:00 | CL | Stock | 28.825 | 28.855 | 28.75 | 28.78 | 184200.0 |
| 2001-05-10 13:00:00 | CL | Stock | 28.78 | 28.815 | 28.765 | 28.795 | 185200.0 |
| 2001-05-10 14:00:00 | CL | Stock | 28.8 | 29.0 | 28.78 | 28.975 | 389000.0 |
| 2001-05-10 15:00:00 | CL | Stock | 28.98 | 29.0 | 28.925 | 28.96 | 349000.0 |
> showing 50 of 16,874 rows — these rows as CSV