PREVIEW / stock_1hour / 2001-06-25
file: by_date/stock_1hour/2001/2001-06-25.parquet size: 351 KB rows: 16,970 symbols: 1,304
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-06-25 08:00:00 | AAPL | Stock | 0.4018 | 0.402 | 0.4009 | 0.4009 | 196000.0 |
| 2001-06-25 09:00:00 | AAPL | Stock | 0.4 | 0.4096 | 0.4 | 0.4096 | 58167200.0 |
| 2001-06-25 10:00:00 | AAPL | Stock | 0.4093 | 0.4148 | 0.4071 | 0.4132 | 87192000.0 |
| 2001-06-25 11:00:00 | AAPL | Stock | 0.4132 | 0.4268 | 0.413 | 0.4263 | 100217600.0 |
| 2001-06-25 12:00:00 | AAPL | Stock | 0.4261 | 0.4268 | 0.4161 | 0.418 | 41311200.0 |
| 2001-06-25 13:00:00 | AAPL | Stock | 0.4182 | 0.4232 | 0.4161 | 0.4223 | 24774400.0 |
| 2001-06-25 14:00:00 | AAPL | Stock | 0.4223 | 0.425 | 0.4168 | 0.423 | 28112000.0 |
| 2001-06-25 15:00:00 | AAPL | Stock | 0.4232 | 0.4286 | 0.4216 | 0.4284 | 68695200.0 |
| 2001-06-25 16:00:00 | AAPL | Stock | 0.4284 | 0.4304 | 0.4145 | 0.4284 | 15674400.0 |
| 2001-06-25 08:00:00 | MSFT | Stock | 34.495 | 34.875 | 34.425 | 34.695 | 31800.0 |
| 2001-06-25 09:00:00 | MSFT | Stock | 34.665 | 34.725 | 34.485 | 34.695 | 5503000.0 |
| 2001-06-25 10:00:00 | MSFT | Stock | 34.69 | 34.875 | 34.645 | 34.785 | 6748600.0 |
| 2001-06-25 11:00:00 | MSFT | Stock | 34.785 | 34.905 | 34.39 | 34.4 | 7487600.0 |
| 2001-06-25 12:00:00 | MSFT | Stock | 34.405 | 34.425 | 33.9 | 34.03 | 6183200.0 |
| 2001-06-25 13:00:00 | MSFT | Stock | 34.04 | 34.2 | 34.0 | 34.085 | 3276800.0 |
| 2001-06-25 14:00:00 | MSFT | Stock | 34.085 | 34.235 | 33.885 | 34.205 | 5752600.0 |
| 2001-06-25 15:00:00 | MSFT | Stock | 34.205 | 34.465 | 34.08 | 34.43 | 7094400.0 |
| 2001-06-25 16:00:00 | MSFT | Stock | 34.43 | 34.535 | 34.295 | 34.445 | 1664600.0 |
| 2001-06-25 17:00:00 | MSFT | Stock | 34.445 | 34.47 | 34.445 | 34.47 | 3800.0 |
| 2001-06-25 18:00:00 | MSFT | Stock | 34.445 | 34.445 | 34.425 | 34.425 | 1400.0 |
| 2001-06-25 08:00:00 | NVDA | Stock | 0.3817 | 0.385 | 0.3817 | 0.385 | 216000.0 |
| 2001-06-25 09:00:00 | NVDA | Stock | 0.3853 | 0.3863 | 0.3765 | 0.3797 | 91128000.0 |
| 2001-06-25 10:00:00 | NVDA | Stock | 0.3797 | 0.3833 | 0.3756 | 0.3778 | 110760000.0 |
| 2001-06-25 11:00:00 | NVDA | Stock | 0.3775 | 0.3799 | 0.3729 | 0.3733 | 63792000.0 |
| 2001-06-25 12:00:00 | NVDA | Stock | 0.3732 | 0.3752 | 0.3698 | 0.3713 | 54888000.0 |
| 2001-06-25 13:00:00 | NVDA | Stock | 0.3713 | 0.3754 | 0.3686 | 0.3752 | 62880000.0 |
| 2001-06-25 14:00:00 | NVDA | Stock | 0.3752 | 0.3798 | 0.371 | 0.3797 | 96576000.0 |
| 2001-06-25 15:00:00 | NVDA | Stock | 0.3798 | 0.3813 | 0.3771 | 0.3797 | 117096000.0 |
| 2001-06-25 16:00:00 | NVDA | Stock | 0.3796 | 0.3847 | 0.3745 | 0.375 | 9192000.0 |
| 2001-06-25 08:00:00 | AMZN | Stock | 0.625 | 0.6325 | 0.625 | 0.6325 | 18000.0 |
| 2001-06-25 09:00:00 | AMZN | Stock | 0.6325 | 0.6405 | 0.6305 | 0.638 | 11822000.0 |
| 2001-06-25 10:00:00 | AMZN | Stock | 0.638 | 0.642 | 0.63 | 0.633 | 26598000.0 |
| 2001-06-25 11:00:00 | AMZN | Stock | 0.633 | 0.638 | 0.6315 | 0.635 | 16638000.0 |
| 2001-06-25 12:00:00 | AMZN | Stock | 0.635 | 0.638 | 0.6285 | 0.63 | 11406000.0 |
| 2001-06-25 13:00:00 | AMZN | Stock | 0.633 | 0.637 | 0.629 | 0.635 | 11410000.0 |
| 2001-06-25 14:00:00 | AMZN | Stock | 0.635 | 0.6385 | 0.6325 | 0.6365 | 20016000.0 |
| 2001-06-25 15:00:00 | AMZN | Stock | 0.636 | 0.6515 | 0.635 | 0.642 | 23210000.0 |
| 2001-06-25 16:00:00 | AMZN | Stock | 0.6405 | 0.645 | 0.6355 | 0.6405 | 11212000.0 |
| 2001-06-25 17:00:00 | AMZN | Stock | 0.6405 | 0.6405 | 0.6405 | 0.6405 | 12000.0 |
| 2001-06-25 09:00:00 | CL | Stock | 29.725 | 29.795 | 29.63 | 29.725 | 286000.0 |
| 2001-06-25 10:00:00 | CL | Stock | 29.725 | 29.725 | 29.25 | 29.45 | 653800.0 |
| 2001-06-25 11:00:00 | CL | Stock | 29.46 | 29.49 | 28.925 | 29.0 | 882000.0 |
| 2001-06-25 12:00:00 | CL | Stock | 29.02 | 29.405 | 29.02 | 29.405 | 434600.0 |
| 2001-06-25 13:00:00 | CL | Stock | 29.375 | 29.45 | 29.35 | 29.45 | 282200.0 |
| 2001-06-25 14:00:00 | CL | Stock | 29.45 | 29.45 | 29.25 | 29.39 | 538200.0 |
| 2001-06-25 15:00:00 | CL | Stock | 29.39 | 29.575 | 29.38 | 29.455 | 682600.0 |
| 2001-06-25 16:00:00 | CL | Stock | 29.45 | 29.45 | 29.45 | 29.45 | 98800.0 |
> showing 47 of 16,970 rows — these rows as CSV