PREVIEW / stock_1hour / 2001-08-06
file: by_date/stock_1hour/2001/2001-08-06.parquet size: 353 KB rows: 16,673 symbols: 1,322
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-06 08:00:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3429 | 0.3429 | 44800.0 |
| 2001-08-06 09:00:00 | AAPL | Stock | 0.3464 | 0.3511 | 0.3393 | 0.348 | 13703200.0 |
| 2001-08-06 10:00:00 | AAPL | Stock | 0.3488 | 0.35 | 0.3425 | 0.3445 | 16945600.0 |
| 2001-08-06 11:00:00 | AAPL | Stock | 0.3445 | 0.3464 | 0.3429 | 0.3438 | 12544000.0 |
| 2001-08-06 12:00:00 | AAPL | Stock | 0.3438 | 0.3455 | 0.3409 | 0.343 | 17869600.0 |
| 2001-08-06 13:00:00 | AAPL | Stock | 0.343 | 0.3452 | 0.342 | 0.3452 | 11328800.0 |
| 2001-08-06 14:00:00 | AAPL | Stock | 0.345 | 0.345 | 0.3423 | 0.3445 | 9385600.0 |
| 2001-08-06 15:00:00 | AAPL | Stock | 0.3445 | 0.3464 | 0.3416 | 0.3416 | 11312000.0 |
| 2001-08-06 16:00:00 | AAPL | Stock | 0.3418 | 0.3479 | 0.3414 | 0.3416 | 3337600.0 |
| 2001-08-06 08:00:00 | MSFT | Stock | 33.45 | 33.46 | 33.25 | 33.25 | 44400.0 |
| 2001-08-06 09:00:00 | MSFT | Stock | 33.25 | 33.56 | 33.21 | 33.44 | 3741800.0 |
| 2001-08-06 10:00:00 | MSFT | Stock | 33.45 | 33.545 | 33.25 | 33.295 | 5040000.0 |
| 2001-08-06 11:00:00 | MSFT | Stock | 33.3 | 33.375 | 33.25 | 33.285 | 2555000.0 |
| 2001-08-06 12:00:00 | MSFT | Stock | 33.285 | 33.325 | 33.02 | 33.045 | 3234400.0 |
| 2001-08-06 13:00:00 | MSFT | Stock | 33.035 | 33.1 | 33.0 | 33.045 | 4006000.0 |
| 2001-08-06 14:00:00 | MSFT | Stock | 33.055 | 33.09 | 32.975 | 33.045 | 2642200.0 |
| 2001-08-06 15:00:00 | MSFT | Stock | 33.04 | 33.08 | 32.84 | 33.07 | 4117600.0 |
| 2001-08-06 16:00:00 | MSFT | Stock | 33.06 | 33.18 | 32.975 | 33.065 | 1405600.0 |
| 2001-08-06 17:00:00 | MSFT | Stock | 33.0 | 33.04 | 32.945 | 33.0 | 21400.0 |
| 2001-08-06 18:00:00 | MSFT | Stock | 33.0 | 33.0 | 33.0 | 33.0 | 600.0 |
| 2001-08-06 08:00:00 | NVDA | Stock | 0.3633 | 0.3633 | 0.3588 | 0.3594 | 360000.0 |
| 2001-08-06 09:00:00 | NVDA | Stock | 0.3591 | 0.362 | 0.3568 | 0.3574 | 139368000.0 |
| 2001-08-06 10:00:00 | NVDA | Stock | 0.3574 | 0.3643 | 0.3571 | 0.3636 | 177408000.0 |
| 2001-08-06 11:00:00 | NVDA | Stock | 0.3635 | 0.3721 | 0.3634 | 0.3709 | 315048000.0 |
| 2001-08-06 12:00:00 | NVDA | Stock | 0.3708 | 0.3745 | 0.3696 | 0.3708 | 114888000.0 |
| 2001-08-06 13:00:00 | NVDA | Stock | 0.3709 | 0.378 | 0.3708 | 0.3773 | 149664000.0 |
| 2001-08-06 14:00:00 | NVDA | Stock | 0.3773 | 0.3773 | 0.371 | 0.3749 | 140472000.0 |
| 2001-08-06 15:00:00 | NVDA | Stock | 0.3747 | 0.3754 | 0.3723 | 0.3742 | 148608000.0 |
| 2001-08-06 16:00:00 | NVDA | Stock | 0.3744 | 0.3759 | 0.3742 | 0.375 | 11832000.0 |
| 2001-08-06 17:00:00 | NVDA | Stock | 0.375 | 0.375 | 0.3693 | 0.3693 | 10080000.0 |
| 2001-08-06 18:00:00 | NVDA | Stock | 0.375 | 0.3753 | 0.3734 | 0.3734 | 216000.0 |
| 2001-08-06 08:00:00 | AMZN | Stock | 0.61 | 0.6125 | 0.608 | 0.6125 | 48000.0 |
| 2001-08-06 09:00:00 | AMZN | Stock | 0.6125 | 0.6125 | 0.5975 | 0.5985 | 6494000.0 |
| 2001-08-06 10:00:00 | AMZN | Stock | 0.598 | 0.605 | 0.598 | 0.6005 | 8044000.0 |
| 2001-08-06 11:00:00 | AMZN | Stock | 0.6005 | 0.61 | 0.6005 | 0.6025 | 4398000.0 |
| 2001-08-06 12:00:00 | AMZN | Stock | 0.6025 | 0.6075 | 0.601 | 0.601 | 4496000.0 |
| 2001-08-06 13:00:00 | AMZN | Stock | 0.601 | 0.605 | 0.6 | 0.604 | 3684000.0 |
| 2001-08-06 14:00:00 | AMZN | Stock | 0.604 | 0.604 | 0.599 | 0.601 | 7876000.0 |
| 2001-08-06 15:00:00 | AMZN | Stock | 0.601 | 0.604 | 0.5925 | 0.5955 | 11506000.0 |
| 2001-08-06 16:00:00 | AMZN | Stock | 0.5955 | 0.602 | 0.59 | 0.595 | 4714000.0 |
| 2001-08-06 17:00:00 | AMZN | Stock | 0.5895 | 0.5995 | 0.589 | 0.5995 | 52000.0 |
| 2001-08-06 09:00:00 | CL | Stock | 26.55 | 26.65 | 26.425 | 26.425 | 265600.0 |
| 2001-08-06 10:00:00 | CL | Stock | 26.425 | 26.5 | 26.375 | 26.4 | 316400.0 |
| 2001-08-06 11:00:00 | CL | Stock | 26.375 | 26.475 | 26.34 | 26.415 | 181600.0 |
| 2001-08-06 12:00:00 | CL | Stock | 26.4 | 26.5 | 26.285 | 26.345 | 172400.0 |
| 2001-08-06 13:00:00 | CL | Stock | 26.35 | 26.355 | 26.21 | 26.255 | 214000.0 |
| 2001-08-06 14:00:00 | CL | Stock | 26.255 | 26.3 | 26.14 | 26.275 | 631600.0 |
| 2001-08-06 15:00:00 | CL | Stock | 26.275 | 26.535 | 26.275 | 26.425 | 442400.0 |
| 2001-08-06 16:00:00 | CL | Stock | 26.425 | 26.44 | 26.25 | 26.25 | 119200.0 |
> showing 49 of 16,673 rows — these rows as CSV