PREVIEW / stock_1hour / 2001-06-26
file: by_date/stock_1hour/2001/2001-06-26.parquet size: 358 KB rows: 17,222 symbols: 1,312
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-26 08:00:00 | AAPL | Stock | 0.4205 | 0.4282 | 0.4161 | 0.4196 | 660800.0 |
| 2001-06-26 09:00:00 | AAPL | Stock | 0.4284 | 0.4284 | 0.4134 | 0.4179 | 35672000.0 |
| 2001-06-26 10:00:00 | AAPL | Stock | 0.4179 | 0.4186 | 0.4109 | 0.4129 | 54857600.0 |
| 2001-06-26 11:00:00 | AAPL | Stock | 0.4129 | 0.4145 | 0.412 | 0.4121 | 19068000.0 |
| 2001-06-26 12:00:00 | AAPL | Stock | 0.4123 | 0.4154 | 0.4116 | 0.4143 | 17791200.0 |
| 2001-06-26 13:00:00 | AAPL | Stock | 0.4143 | 0.4163 | 0.4123 | 0.4159 | 41283200.0 |
| 2001-06-26 14:00:00 | AAPL | Stock | 0.4159 | 0.4175 | 0.4143 | 0.4152 | 25138400.0 |
| 2001-06-26 15:00:00 | AAPL | Stock | 0.4152 | 0.4245 | 0.415 | 0.4239 | 53457600.0 |
| 2001-06-26 16:00:00 | AAPL | Stock | 0.4239 | 0.4246 | 0.4152 | 0.4241 | 11653600.0 |
| 2001-06-26 17:00:00 | AAPL | Stock | 0.4223 | 0.4223 | 0.4223 | 0.4223 | 28000.0 |
| 2001-06-26 08:00:00 | MSFT | Stock | 33.75 | 34.425 | 33.5 | 33.9 | 486400.0 |
| 2001-06-26 09:00:00 | MSFT | Stock | 33.86 | 34.5 | 33.725 | 34.265 | 8214000.0 |
| 2001-06-26 10:00:00 | MSFT | Stock | 34.265 | 34.425 | 34.05 | 34.195 | 7858000.0 |
| 2001-06-26 11:00:00 | MSFT | Stock | 34.18 | 34.345 | 33.87 | 33.965 | 5635200.0 |
| 2001-06-26 12:00:00 | MSFT | Stock | 33.965 | 34.195 | 33.95 | 34.19 | 4428800.0 |
| 2001-06-26 13:00:00 | MSFT | Stock | 34.195 | 34.855 | 34.13 | 34.83 | 7515200.0 |
| 2001-06-26 14:00:00 | MSFT | Stock | 34.835 | 35.05 | 34.75 | 34.78 | 11796600.0 |
| 2001-06-26 15:00:00 | MSFT | Stock | 34.78 | 35.105 | 34.75 | 35.06 | 10984000.0 |
| 2001-06-26 16:00:00 | MSFT | Stock | 35.05 | 35.075 | 34.46 | 34.825 | 1962000.0 |
| 2001-06-26 17:00:00 | MSFT | Stock | 34.885 | 34.975 | 34.885 | 34.975 | 16600.0 |
| 2001-06-26 18:00:00 | MSFT | Stock | 34.915 | 34.915 | 34.915 | 34.915 | 600.0 |
| 2001-06-26 08:00:00 | NVDA | Stock | 0.3796 | 0.3796 | 0.3715 | 0.3715 | 8208000.0 |
| 2001-06-26 09:00:00 | NVDA | Stock | 0.3717 | 0.3767 | 0.3698 | 0.3758 | 92832000.0 |
| 2001-06-26 10:00:00 | NVDA | Stock | 0.3758 | 0.3775 | 0.3714 | 0.3756 | 110616000.0 |
| 2001-06-26 11:00:00 | NVDA | Stock | 0.3756 | 0.38 | 0.3735 | 0.376 | 57120000.0 |
| 2001-06-26 12:00:00 | NVDA | Stock | 0.376 | 0.3786 | 0.3746 | 0.3783 | 40008000.0 |
| 2001-06-26 13:00:00 | NVDA | Stock | 0.378 | 0.389 | 0.3778 | 0.3865 | 154056000.0 |
| 2001-06-26 14:00:00 | NVDA | Stock | 0.3869 | 0.3925 | 0.3857 | 0.3875 | 139656000.0 |
| 2001-06-26 15:00:00 | NVDA | Stock | 0.3872 | 0.3922 | 0.386 | 0.3904 | 117168000.0 |
| 2001-06-26 16:00:00 | NVDA | Stock | 0.3903 | 0.3924 | 0.389 | 0.389 | 6552000.0 |
| 2001-06-26 17:00:00 | NVDA | Stock | 0.3917 | 0.3917 | 0.3917 | 0.3917 | 24000.0 |
| 2001-06-26 08:00:00 | AMZN | Stock | 0.6405 | 0.6405 | 0.621 | 0.6225 | 252000.0 |
| 2001-06-26 09:00:00 | AMZN | Stock | 0.6225 | 0.6345 | 0.615 | 0.626 | 7624000.0 |
| 2001-06-26 10:00:00 | AMZN | Stock | 0.626 | 0.63 | 0.6025 | 0.606 | 13798000.0 |
| 2001-06-26 11:00:00 | AMZN | Stock | 0.608 | 0.62 | 0.6055 | 0.6185 | 7482000.0 |
| 2001-06-26 12:00:00 | AMZN | Stock | 0.6185 | 0.6355 | 0.617 | 0.635 | 23474000.0 |
| 2001-06-26 13:00:00 | AMZN | Stock | 0.6355 | 0.6475 | 0.63 | 0.6465 | 15090000.0 |
| 2001-06-26 14:00:00 | AMZN | Stock | 0.646 | 0.687 | 0.646 | 0.6775 | 38130000.0 |
| 2001-06-26 15:00:00 | AMZN | Stock | 0.677 | 0.6835 | 0.6535 | 0.6625 | 16034000.0 |
| 2001-06-26 16:00:00 | AMZN | Stock | 0.6625 | 0.6705 | 0.627 | 0.6625 | 6184000.0 |
| 2001-06-26 09:00:00 | CL | Stock | 29.3 | 29.52 | 29.215 | 29.52 | 265200.0 |
| 2001-06-26 10:00:00 | CL | Stock | 29.52 | 29.7 | 29.495 | 29.7 | 470400.0 |
| 2001-06-26 11:00:00 | CL | Stock | 29.68 | 29.735 | 29.505 | 29.705 | 431400.0 |
| 2001-06-26 12:00:00 | CL | Stock | 29.675 | 29.8 | 29.51 | 29.795 | 658800.0 |
| 2001-06-26 13:00:00 | CL | Stock | 29.785 | 29.98 | 29.775 | 29.895 | 510800.0 |
| 2001-06-26 14:00:00 | CL | Stock | 29.89 | 30.25 | 29.89 | 30.14 | 595800.0 |
| 2001-06-26 15:00:00 | CL | Stock | 30.135 | 30.325 | 30.12 | 30.3 | 798800.0 |
| 2001-06-26 16:00:00 | CL | Stock | 30.3 | 30.35 | 29.925 | 29.925 | 619000.0 |
> showing 48 of 17,222 rows — these rows as CSV