PREVIEW / stock_1hour / 2001-08-10
file: by_date/stock_1hour/2001/2001-08-10.parquet size: 351 KB rows: 16,784 symbols: 1,319
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-08-10 08:00:00 | AAPL | Stock | 0.3407 | 0.3407 | 0.3407 | 0.3407 | 28000.0 |
| 2001-08-10 09:00:00 | AAPL | Stock | 0.3409 | 0.3418 | 0.337 | 0.3384 | 17455200.0 |
| 2001-08-10 10:00:00 | AAPL | Stock | 0.3388 | 0.3396 | 0.332 | 0.3379 | 41675200.0 |
| 2001-08-10 11:00:00 | AAPL | Stock | 0.338 | 0.3393 | 0.3363 | 0.3371 | 19241600.0 |
| 2001-08-10 12:00:00 | AAPL | Stock | 0.3371 | 0.34 | 0.3359 | 0.3396 | 18900000.0 |
| 2001-08-10 13:00:00 | AAPL | Stock | 0.34 | 0.3441 | 0.3386 | 0.3423 | 38718400.0 |
| 2001-08-10 14:00:00 | AAPL | Stock | 0.3423 | 0.345 | 0.3404 | 0.3434 | 20736800.0 |
| 2001-08-10 15:00:00 | AAPL | Stock | 0.3436 | 0.3446 | 0.3384 | 0.3396 | 20557600.0 |
| 2001-08-10 16:00:00 | AAPL | Stock | 0.3398 | 0.343 | 0.3395 | 0.3413 | 3813600.0 |
| 2001-08-10 17:00:00 | AAPL | Stock | 0.3427 | 0.3427 | 0.3402 | 0.3402 | 33600.0 |
| 2001-08-10 08:00:00 | MSFT | Stock | 32.5 | 32.5 | 32.4 | 32.425 | 29200.0 |
| 2001-08-10 09:00:00 | MSFT | Stock | 32.445 | 32.63 | 32.31 | 32.45 | 3835200.0 |
| 2001-08-10 10:00:00 | MSFT | Stock | 32.455 | 32.465 | 31.45 | 31.725 | 12166800.0 |
| 2001-08-10 11:00:00 | MSFT | Stock | 31.715 | 31.995 | 31.65 | 31.83 | 4994000.0 |
| 2001-08-10 12:00:00 | MSFT | Stock | 31.825 | 32.35 | 31.66 | 32.335 | 6276800.0 |
| 2001-08-10 13:00:00 | MSFT | Stock | 32.345 | 32.6 | 32.3 | 32.57 | 7252400.0 |
| 2001-08-10 14:00:00 | MSFT | Stock | 32.56 | 32.93 | 32.355 | 32.805 | 5190400.0 |
| 2001-08-10 15:00:00 | MSFT | Stock | 32.795 | 32.9 | 32.1 | 32.75 | 6446800.0 |
| 2001-08-10 16:00:00 | MSFT | Stock | 32.76 | 32.795 | 32.18 | 32.475 | 1920600.0 |
| 2001-08-10 17:00:00 | MSFT | Stock | 32.565 | 32.625 | 32.565 | 32.6 | 12400.0 |
| 2001-08-10 18:00:00 | MSFT | Stock | 32.605 | 32.625 | 32.605 | 32.625 | 600.0 |
| 2001-08-10 08:00:00 | NVDA | Stock | 0.3521 | 0.3531 | 0.3498 | 0.3513 | 600000.0 |
| 2001-08-10 09:00:00 | NVDA | Stock | 0.3522 | 0.3575 | 0.3487 | 0.3502 | 169656000.0 |
| 2001-08-10 10:00:00 | NVDA | Stock | 0.3502 | 0.3512 | 0.3421 | 0.3444 | 238896000.0 |
| 2001-08-10 11:00:00 | NVDA | Stock | 0.3445 | 0.3548 | 0.3433 | 0.352 | 148152000.0 |
| 2001-08-10 12:00:00 | NVDA | Stock | 0.352 | 0.3552 | 0.3461 | 0.355 | 100560000.0 |
| 2001-08-10 13:00:00 | NVDA | Stock | 0.355 | 0.3559 | 0.3506 | 0.353 | 113952000.0 |
| 2001-08-10 14:00:00 | NVDA | Stock | 0.3523 | 0.356 | 0.35 | 0.355 | 104280000.0 |
| 2001-08-10 15:00:00 | NVDA | Stock | 0.3554 | 0.3558 | 0.3509 | 0.3527 | 111720000.0 |
| 2001-08-10 16:00:00 | NVDA | Stock | 0.3527 | 0.3546 | 0.3517 | 0.3532 | 13608000.0 |
| 2001-08-10 17:00:00 | NVDA | Stock | 0.3528 | 0.3528 | 0.3513 | 0.3517 | 528000.0 |
| 2001-08-10 08:00:00 | AMZN | Stock | 0.5315 | 0.535 | 0.522 | 0.53 | 338000.0 |
| 2001-08-10 09:00:00 | AMZN | Stock | 0.5275 | 0.5325 | 0.5135 | 0.5135 | 11394000.0 |
| 2001-08-10 10:00:00 | AMZN | Stock | 0.514 | 0.5155 | 0.5005 | 0.5035 | 19608000.0 |
| 2001-08-10 11:00:00 | AMZN | Stock | 0.5035 | 0.5065 | 0.497 | 0.5035 | 30776000.0 |
| 2001-08-10 12:00:00 | AMZN | Stock | 0.5035 | 0.507 | 0.5 | 0.506 | 22264000.0 |
| 2001-08-10 13:00:00 | AMZN | Stock | 0.506 | 0.5085 | 0.5015 | 0.5025 | 10730000.0 |
| 2001-08-10 14:00:00 | AMZN | Stock | 0.5025 | 0.505 | 0.5 | 0.5005 | 26588000.0 |
| 2001-08-10 15:00:00 | AMZN | Stock | 0.5005 | 0.5025 | 0.497 | 0.498 | 49150000.0 |
| 2001-08-10 16:00:00 | AMZN | Stock | 0.498 | 0.5015 | 0.4965 | 0.4985 | 6528000.0 |
| 2001-08-10 09:00:00 | CL | Stock | 26.875 | 27.1 | 26.86 | 27.05 | 356600.0 |
| 2001-08-10 10:00:00 | CL | Stock | 27.05 | 27.05 | 26.85 | 26.855 | 394600.0 |
| 2001-08-10 11:00:00 | CL | Stock | 26.85 | 27.0 | 26.8 | 26.95 | 287200.0 |
| 2001-08-10 12:00:00 | CL | Stock | 26.94 | 27.025 | 26.875 | 27.025 | 312000.0 |
| 2001-08-10 13:00:00 | CL | Stock | 27.025 | 27.075 | 26.95 | 26.985 | 409800.0 |
| 2001-08-10 14:00:00 | CL | Stock | 26.985 | 26.99 | 26.775 | 26.855 | 463400.0 |
| 2001-08-10 15:00:00 | CL | Stock | 26.855 | 26.925 | 26.7 | 26.725 | 564800.0 |
| 2001-08-10 16:00:00 | CL | Stock | 26.725 | 26.865 | 26.725 | 26.865 | 389200.0 |
> showing 48 of 16,784 rows — these rows as CSV