PREVIEW / stock_1hour / 2002-02-25
file: by_date/stock_1hour/2002/2002-02-25.parquet size: 387 KB rows: 18,256 symbols: 1,400
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-25 08:00:00 | AAPL | Stock | 0.4072 | 0.4072 | 0.4061 | 0.4071 | 1461600.0 |
| 2002-02-25 09:00:00 | AAPL | Stock | 0.408 | 0.4105 | 0.4025 | 0.4029 | 31673600.0 |
| 2002-02-25 10:00:00 | AAPL | Stock | 0.4027 | 0.4061 | 0.3993 | 0.4052 | 40656000.0 |
| 2002-02-25 11:00:00 | AAPL | Stock | 0.4052 | 0.4218 | 0.4046 | 0.4164 | 47409600.0 |
| 2002-02-25 12:00:00 | AAPL | Stock | 0.4164 | 0.4211 | 0.415 | 0.4177 | 28616000.0 |
| 2002-02-25 13:00:00 | AAPL | Stock | 0.4182 | 0.4254 | 0.4182 | 0.4236 | 40392800.0 |
| 2002-02-25 14:00:00 | AAPL | Stock | 0.4239 | 0.4409 | 0.4225 | 0.4384 | 61420800.0 |
| 2002-02-25 15:00:00 | AAPL | Stock | 0.4384 | 0.4414 | 0.4252 | 0.4252 | 127825600.0 |
| 2002-02-25 16:00:00 | AAPL | Stock | 0.4261 | 0.4314 | 0.4239 | 0.4241 | 37553600.0 |
| 2002-02-25 17:00:00 | AAPL | Stock | 0.4252 | 0.4252 | 0.4252 | 0.4252 | 11200.0 |
| 2002-02-25 08:00:00 | MSFT | Stock | 29.225 | 29.225 | 28.99 | 29.01 | 37200.0 |
| 2002-02-25 09:00:00 | MSFT | Stock | 29.01 | 29.351 | 28.945 | 29.2995 | 6213000.0 |
| 2002-02-25 10:00:00 | MSFT | Stock | 29.28 | 29.51 | 29.23 | 29.375 | 7971400.0 |
| 2002-02-25 11:00:00 | MSFT | Stock | 29.375 | 29.57 | 29.265 | 29.39 | 5776000.0 |
| 2002-02-25 12:00:00 | MSFT | Stock | 29.39 | 29.55 | 29.1945 | 29.375 | 4347000.0 |
| 2002-02-25 13:00:00 | MSFT | Stock | 29.375 | 29.68 | 29.345 | 29.66 | 5916800.0 |
| 2002-02-25 14:00:00 | MSFT | Stock | 29.665 | 29.87 | 29.635 | 29.8305 | 6361400.0 |
| 2002-02-25 15:00:00 | MSFT | Stock | 29.83 | 29.945 | 29.51 | 29.54 | 11359200.0 |
| 2002-02-25 16:00:00 | MSFT | Stock | 29.535 | 29.688 | 29.41 | 29.53 | 2281200.0 |
| 2002-02-25 17:00:00 | MSFT | Stock | 29.535 | 29.545 | 29.5 | 29.545 | 41000.0 |
| 2002-02-25 18:00:00 | MSFT | Stock | 29.54 | 29.54 | 29.54 | 29.54 | 200.0 |
| 2002-02-25 08:00:00 | NVDA | Stock | 0.4158 | 0.4192 | 0.4158 | 0.4185 | 912000.0 |
| 2002-02-25 09:00:00 | NVDA | Stock | 0.4191 | 0.4317 | 0.4177 | 0.4227 | 223920000.0 |
| 2002-02-25 10:00:00 | NVDA | Stock | 0.423 | 0.4325 | 0.4178 | 0.4312 | 330300000.0 |
| 2002-02-25 11:00:00 | NVDA | Stock | 0.4312 | 0.4391 | 0.4301 | 0.4367 | 207660000.0 |
| 2002-02-25 12:00:00 | NVDA | Stock | 0.4369 | 0.4428 | 0.4367 | 0.4405 | 153072000.0 |
| 2002-02-25 13:00:00 | NVDA | Stock | 0.4403 | 0.4483 | 0.44 | 0.4479 | 194208000.0 |
| 2002-02-25 14:00:00 | NVDA | Stock | 0.4483 | 0.4491 | 0.4446 | 0.4467 | 179148000.0 |
| 2002-02-25 15:00:00 | NVDA | Stock | 0.4468 | 0.4518 | 0.4427 | 0.4486 | 259536000.0 |
| 2002-02-25 16:00:00 | NVDA | Stock | 0.4486 | 0.4514 | 0.4424 | 0.4497 | 10356000.0 |
| 2002-02-25 17:00:00 | NVDA | Stock | 0.4489 | 0.4507 | 0.4486 | 0.4507 | 612000.0 |
| 2002-02-25 18:00:00 | NVDA | Stock | 0.4507 | 0.4515 | 0.4507 | 0.4515 | 168000.0 |
| 2002-02-25 08:00:00 | AMZN | Stock | 0.6535 | 0.6595 | 0.6516 | 0.6516 | 206000.0 |
| 2002-02-25 09:00:00 | AMZN | Stock | 0.653 | 0.675 | 0.65 | 0.6718 | 23786000.0 |
| 2002-02-25 10:00:00 | AMZN | Stock | 0.6715 | 0.6785 | 0.6625 | 0.665 | 22398000.0 |
| 2002-02-25 11:00:00 | AMZN | Stock | 0.6646 | 0.667 | 0.66 | 0.664 | 11024000.0 |
| 2002-02-25 12:00:00 | AMZN | Stock | 0.664 | 0.668 | 0.6605 | 0.667 | 8716000.0 |
| 2002-02-25 13:00:00 | AMZN | Stock | 0.6655 | 0.669 | 0.665 | 0.6675 | 10016000.0 |
| 2002-02-25 14:00:00 | AMZN | Stock | 0.6675 | 0.68 | 0.667 | 0.68 | 15228000.0 |
| 2002-02-25 15:00:00 | AMZN | Stock | 0.679 | 0.687 | 0.6765 | 0.6862 | 20448000.0 |
| 2002-02-25 16:00:00 | AMZN | Stock | 0.686 | 0.6875 | 0.6815 | 0.6825 | 1028000.0 |
| 2002-02-25 17:00:00 | AMZN | Stock | 0.6865 | 0.6865 | 0.685 | 0.686 | 64000.0 |
| 2002-02-25 18:00:00 | AMZN | Stock | 0.686 | 0.686 | 0.686 | 0.686 | 22000.0 |
| 2002-02-25 09:00:00 | CL | Stock | 28.6 | 28.6 | 28.3 | 28.4 | 208600.0 |
| 2002-02-25 10:00:00 | CL | Stock | 28.395 | 28.485 | 28.36 | 28.415 | 206800.0 |
| 2002-02-25 11:00:00 | CL | Stock | 28.4 | 28.415 | 28.125 | 28.205 | 309000.0 |
| 2002-02-25 12:00:00 | CL | Stock | 28.205 | 28.215 | 28.075 | 28.105 | 262800.0 |
| 2002-02-25 13:00:00 | CL | Stock | 28.095 | 28.325 | 28.095 | 28.235 | 234400.0 |
| 2002-02-25 14:00:00 | CL | Stock | 28.24 | 28.495 | 28.2 | 28.495 | 258200.0 |
| 2002-02-25 15:00:00 | CL | Stock | 28.5 | 28.69 | 28.415 | 28.475 | 788000.0 |
> showing 50 of 18,256 rows — these rows as CSV