PREVIEW / stock_1hour / 2001-12-10
file: by_date/stock_1hour/2001/2001-12-10.parquet size: 385 KB rows: 18,496 symbols: 1,365
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-12-10 08:00:00 | AAPL | Stock | 0.4021 | 0.4025 | 0.4014 | 0.4014 | 4188800.0 |
| 2001-12-10 09:00:00 | AAPL | Stock | 0.4014 | 0.4039 | 0.397 | 0.403 | 15657600.0 |
| 2001-12-10 10:00:00 | AAPL | Stock | 0.4016 | 0.4105 | 0.3986 | 0.4032 | 35173600.0 |
| 2001-12-10 11:00:00 | AAPL | Stock | 0.4036 | 0.405 | 0.397 | 0.3982 | 13176800.0 |
| 2001-12-10 12:00:00 | AAPL | Stock | 0.3984 | 0.4027 | 0.3979 | 0.4018 | 10068800.0 |
| 2001-12-10 13:00:00 | AAPL | Stock | 0.4013 | 0.408 | 0.4011 | 0.4059 | 23598400.0 |
| 2001-12-10 14:00:00 | AAPL | Stock | 0.4047 | 0.4059 | 0.3973 | 0.4013 | 27608000.0 |
| 2001-12-10 15:00:00 | AAPL | Stock | 0.4013 | 0.4032 | 0.398 | 0.4025 | 26723200.0 |
| 2001-12-10 16:00:00 | AAPL | Stock | 0.4025 | 0.4027 | 0.3979 | 0.4025 | 6154400.0 |
| 2001-12-10 17:00:00 | AAPL | Stock | 0.4063 | 0.4063 | 0.4063 | 0.4063 | 554400.0 |
| 2001-12-10 18:00:00 | AAPL | Stock | 0.4025 | 0.4025 | 0.4025 | 0.4025 | 44800.0 |
| 2001-12-10 08:00:00 | MSFT | Stock | 33.75 | 33.915 | 33.695 | 33.915 | 18200.0 |
| 2001-12-10 09:00:00 | MSFT | Stock | 33.785 | 33.935 | 33.63 | 33.895 | 5536000.0 |
| 2001-12-10 10:00:00 | MSFT | Stock | 33.89 | 34.225 | 33.86 | 34.0065 | 7234200.0 |
| 2001-12-10 11:00:00 | MSFT | Stock | 34.02 | 34.035 | 33.715 | 33.8 | 4775600.0 |
| 2001-12-10 12:00:00 | MSFT | Stock | 33.8 | 33.875 | 33.655 | 33.725 | 2420200.0 |
| 2001-12-10 13:00:00 | MSFT | Stock | 33.725 | 33.725 | 33.505 | 33.615 | 4194200.0 |
| 2001-12-10 14:00:00 | MSFT | Stock | 33.61 | 33.75 | 33.43 | 33.645 | 4014000.0 |
| 2001-12-10 15:00:00 | MSFT | Stock | 33.645 | 33.75 | 33.49 | 33.54 | 5880200.0 |
| 2001-12-10 16:00:00 | MSFT | Stock | 33.54 | 33.7724 | 33.5 | 33.53 | 3407600.0 |
| 2001-12-10 17:00:00 | MSFT | Stock | 33.525 | 33.8426 | 33.525 | 33.53 | 310400.0 |
| 2001-12-10 18:00:00 | MSFT | Stock | 33.56 | 33.56 | 33.525 | 33.525 | 26000.0 |
| 2001-12-10 08:00:00 | NVDA | Stock | 0.4996 | 0.5036 | 0.495 | 0.4974 | 420000.0 |
| 2001-12-10 09:00:00 | NVDA | Stock | 0.496 | 0.5083 | 0.4929 | 0.5046 | 124584000.0 |
| 2001-12-10 10:00:00 | NVDA | Stock | 0.5045 | 0.5148 | 0.5032 | 0.5108 | 155568000.0 |
| 2001-12-10 11:00:00 | NVDA | Stock | 0.5108 | 0.516 | 0.5076 | 0.5087 | 83280000.0 |
| 2001-12-10 12:00:00 | NVDA | Stock | 0.5083 | 0.5144 | 0.5051 | 0.5108 | 53016000.0 |
| 2001-12-10 13:00:00 | NVDA | Stock | 0.5107 | 0.5141 | 0.5062 | 0.5115 | 48288000.0 |
| 2001-12-10 14:00:00 | NVDA | Stock | 0.5118 | 0.513 | 0.5088 | 0.5088 | 55008000.0 |
| 2001-12-10 15:00:00 | NVDA | Stock | 0.5088 | 0.5108 | 0.499 | 0.5047 | 143148000.0 |
| 2001-12-10 16:00:00 | NVDA | Stock | 0.5046 | 0.5058 | 0.5037 | 0.5051 | 23496000.0 |
| 2001-12-10 17:00:00 | NVDA | Stock | 0.5093 | 0.5093 | 0.5093 | 0.5093 | 480000.0 |
| 2001-12-10 18:00:00 | NVDA | Stock | 0.5046 | 0.5062 | 0.5046 | 0.5054 | 60000.0 |
| 2001-12-10 08:00:00 | AMZN | Stock | 0.585 | 0.587 | 0.5785 | 0.5785 | 288000.0 |
| 2001-12-10 09:00:00 | AMZN | Stock | 0.5815 | 0.5985 | 0.5735 | 0.5905 | 19380000.0 |
| 2001-12-10 10:00:00 | AMZN | Stock | 0.5905 | 0.6075 | 0.59 | 0.5985 | 37426000.0 |
| 2001-12-10 11:00:00 | AMZN | Stock | 0.598 | 0.6 | 0.595 | 0.596 | 13734000.0 |
| 2001-12-10 12:00:00 | AMZN | Stock | 0.5955 | 0.599 | 0.5915 | 0.5935 | 13972000.0 |
| 2001-12-10 13:00:00 | AMZN | Stock | 0.5935 | 0.597 | 0.5875 | 0.592 | 15126000.0 |
| 2001-12-10 14:00:00 | AMZN | Stock | 0.595 | 0.5975 | 0.59 | 0.5945 | 14612000.0 |
| 2001-12-10 15:00:00 | AMZN | Stock | 0.5944 | 0.5945 | 0.572 | 0.583 | 41390000.0 |
| 2001-12-10 16:00:00 | AMZN | Stock | 0.5805 | 0.5919 | 0.575 | 0.58 | 4164000.0 |
| 2001-12-10 17:00:00 | AMZN | Stock | 0.585 | 0.585 | 0.5825 | 0.5825 | 46000.0 |
| 2001-12-10 18:00:00 | AMZN | Stock | 0.5825 | 0.586 | 0.5825 | 0.586 | 10000.0 |
| 2001-12-10 09:00:00 | CL | Stock | 28.18 | 28.27 | 28.15 | 28.245 | 149800.0 |
| 2001-12-10 10:00:00 | CL | Stock | 28.245 | 28.275 | 28.045 | 28.06 | 746600.0 |
| 2001-12-10 11:00:00 | CL | Stock | 28.06 | 28.45 | 28.06 | 28.29 | 354600.0 |
| 2001-12-10 12:00:00 | CL | Stock | 28.25 | 28.35 | 28.21 | 28.345 | 291200.0 |
| 2001-12-10 13:00:00 | CL | Stock | 28.345 | 28.4 | 28.205 | 28.205 | 413000.0 |
| 2001-12-10 14:00:00 | CL | Stock | 28.2 | 28.44 | 28.2 | 28.42 | 275000.0 |
> showing 50 of 18,496 rows — these rows as CSV