PREVIEW / stock_1hour / 2002-02-22
file: by_date/stock_1hour/2002/2002-02-22.parquet size: 383 KB rows: 18,171 symbols: 1,392
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 |
|---|---|---|---|---|---|---|---|
| 2002-02-22 08:00:00 | AAPL | Stock | 0.3884 | 0.3884 | 0.3866 | 0.3884 | 128800.0 |
| 2002-02-22 09:00:00 | AAPL | Stock | 0.385 | 0.3998 | 0.3786 | 0.3964 | 60250400.0 |
| 2002-02-22 10:00:00 | AAPL | Stock | 0.3962 | 0.4009 | 0.3905 | 0.3961 | 59964800.0 |
| 2002-02-22 11:00:00 | AAPL | Stock | 0.3957 | 0.3995 | 0.3943 | 0.3954 | 32541600.0 |
| 2002-02-22 12:00:00 | AAPL | Stock | 0.3957 | 0.3982 | 0.3954 | 0.3975 | 26376000.0 |
| 2002-02-22 13:00:00 | AAPL | Stock | 0.3975 | 0.3998 | 0.3964 | 0.3982 | 38584000.0 |
| 2002-02-22 14:00:00 | AAPL | Stock | 0.3982 | 0.4089 | 0.3979 | 0.4079 | 68275200.0 |
| 2002-02-22 15:00:00 | AAPL | Stock | 0.4079 | 0.4098 | 0.4027 | 0.4061 | 92540000.0 |
| 2002-02-22 16:00:00 | AAPL | Stock | 0.4061 | 0.4066 | 0.403 | 0.4061 | 12101600.0 |
| 2002-02-22 17:00:00 | AAPL | Stock | 0.4054 | 0.4061 | 0.4054 | 0.4061 | 571200.0 |
| 2002-02-22 08:00:00 | MSFT | Stock | 29.0275 | 29.1 | 29.0275 | 29.03 | 114800.0 |
| 2002-02-22 09:00:00 | MSFT | Stock | 29.03 | 29.18 | 28.7945 | 29.165 | 9550000.0 |
| 2002-02-22 10:00:00 | MSFT | Stock | 29.16 | 29.3755 | 28.785 | 28.94 | 12241000.0 |
| 2002-02-22 11:00:00 | MSFT | Stock | 28.9405 | 29.015 | 28.705 | 28.71 | 9451800.0 |
| 2002-02-22 12:00:00 | MSFT | Stock | 28.71 | 28.76 | 28.575 | 28.59 | 8757000.0 |
| 2002-02-22 13:00:00 | MSFT | Stock | 28.595 | 28.83 | 28.575 | 28.72 | 5302400.0 |
| 2002-02-22 14:00:00 | MSFT | Stock | 28.73 | 29.24 | 28.6 | 29.2196 | 10545400.0 |
| 2002-02-22 15:00:00 | MSFT | Stock | 29.2175 | 29.25 | 28.705 | 28.995 | 11393800.0 |
| 2002-02-22 16:00:00 | MSFT | Stock | 28.99 | 29.0 | 28.8468 | 28.95 | 1338600.0 |
| 2002-02-22 17:00:00 | MSFT | Stock | 28.95 | 29.01 | 28.95 | 29.01 | 672600.0 |
| 2002-02-22 18:00:00 | MSFT | Stock | 29.01 | 29.01 | 28.96 | 28.96 | 400.0 |
| 2002-02-22 08:00:00 | NVDA | Stock | 0.4375 | 0.4396 | 0.435 | 0.435 | 1116000.0 |
| 2002-02-22 09:00:00 | NVDA | Stock | 0.4376 | 0.4376 | 0.414 | 0.4199 | 334584000.0 |
| 2002-02-22 10:00:00 | NVDA | Stock | 0.42 | 0.4262 | 0.4104 | 0.4189 | 472932000.0 |
| 2002-02-22 11:00:00 | NVDA | Stock | 0.4182 | 0.4337 | 0.4145 | 0.4281 | 426432000.0 |
| 2002-02-22 12:00:00 | NVDA | Stock | 0.4281 | 0.4285 | 0.4197 | 0.4202 | 203604000.0 |
| 2002-02-22 13:00:00 | NVDA | Stock | 0.4207 | 0.4208 | 0.4115 | 0.4149 | 321372000.0 |
| 2002-02-22 14:00:00 | NVDA | Stock | 0.4146 | 0.4248 | 0.4146 | 0.4237 | 338064000.0 |
| 2002-02-22 15:00:00 | NVDA | Stock | 0.4231 | 0.4257 | 0.4151 | 0.416 | 392124000.0 |
| 2002-02-22 16:00:00 | NVDA | Stock | 0.416 | 0.4209 | 0.4146 | 0.4158 | 19500000.0 |
| 2002-02-22 17:00:00 | NVDA | Stock | 0.4162 | 0.4167 | 0.415 | 0.4152 | 1524000.0 |
| 2002-02-22 18:00:00 | NVDA | Stock | 0.4163 | 0.4163 | 0.4163 | 0.4163 | 24000.0 |
| 2002-02-22 08:00:00 | AMZN | Stock | 0.6625 | 0.6625 | 0.66 | 0.66 | 20000.0 |
| 2002-02-22 09:00:00 | AMZN | Stock | 0.6625 | 0.6625 | 0.6485 | 0.6495 | 18008000.0 |
| 2002-02-22 10:00:00 | AMZN | Stock | 0.649 | 0.649 | 0.635 | 0.64 | 28356000.0 |
| 2002-02-22 11:00:00 | AMZN | Stock | 0.6405 | 0.6465 | 0.6375 | 0.64 | 8858000.0 |
| 2002-02-22 12:00:00 | AMZN | Stock | 0.64 | 0.6465 | 0.6355 | 0.645 | 15638000.0 |
| 2002-02-22 13:00:00 | AMZN | Stock | 0.645 | 0.6615 | 0.6445 | 0.654 | 25860000.0 |
| 2002-02-22 14:00:00 | AMZN | Stock | 0.654 | 0.6595 | 0.6415 | 0.6505 | 27018000.0 |
| 2002-02-22 15:00:00 | AMZN | Stock | 0.6505 | 0.6535 | 0.644 | 0.6535 | 15202000.0 |
| 2002-02-22 16:00:00 | AMZN | Stock | 0.6515 | 0.6615 | 0.6434 | 0.656 | 4528000.0 |
| 2002-02-22 17:00:00 | AMZN | Stock | 0.6535 | 0.657 | 0.6535 | 0.656 | 268000.0 |
| 2002-02-22 18:00:00 | AMZN | Stock | 0.654 | 0.654 | 0.654 | 0.654 | 10000.0 |
| 2002-02-22 09:00:00 | CL | Stock | 27.925 | 28.05 | 27.785 | 28.0 | 426600.0 |
| 2002-02-22 10:00:00 | CL | Stock | 27.99 | 28.115 | 27.925 | 28.115 | 481800.0 |
| 2002-02-22 11:00:00 | CL | Stock | 28.11 | 28.2 | 28.0 | 28.06 | 404800.0 |
| 2002-02-22 12:00:00 | CL | Stock | 28.05 | 28.2 | 27.825 | 28.15 | 333200.0 |
| 2002-02-22 13:00:00 | CL | Stock | 28.15 | 28.24 | 28.08 | 28.175 | 197600.0 |
| 2002-02-22 14:00:00 | CL | Stock | 28.175 | 28.575 | 28.165 | 28.575 | 477600.0 |
| 2002-02-22 15:00:00 | CL | Stock | 28.575 | 28.65 | 28.29 | 28.38 | 774400.0 |
> showing 50 of 18,171 rows — these rows as CSV