PREVIEW / stock_1hour / 2001-05-03
file: by_date/stock_1hour/2001/2001-05-03.parquet size: 350 KB rows: 16,797 symbols: 1,287
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-05-03 08:00:00 | AAPL | Stock | 0.4745 | 0.4745 | 0.46 | 0.4616 | 100800.0 |
| 2001-05-03 09:00:00 | AAPL | Stock | 0.4591 | 0.4688 | 0.4591 | 0.4663 | 31141600.0 |
| 2001-05-03 10:00:00 | AAPL | Stock | 0.4664 | 0.4682 | 0.4616 | 0.4627 | 35599200.0 |
| 2001-05-03 11:00:00 | AAPL | Stock | 0.4627 | 0.4634 | 0.45 | 0.4518 | 38052000.0 |
| 2001-05-03 12:00:00 | AAPL | Stock | 0.4527 | 0.4546 | 0.45 | 0.4507 | 17987200.0 |
| 2001-05-03 13:00:00 | AAPL | Stock | 0.4507 | 0.4513 | 0.4448 | 0.4486 | 33622400.0 |
| 2001-05-03 14:00:00 | AAPL | Stock | 0.4486 | 0.4516 | 0.443 | 0.4446 | 45684800.0 |
| 2001-05-03 15:00:00 | AAPL | Stock | 0.4446 | 0.4486 | 0.4416 | 0.4452 | 61370400.0 |
| 2001-05-03 16:00:00 | AAPL | Stock | 0.4457 | 0.4457 | 0.4429 | 0.4457 | 12157600.0 |
| 2001-05-03 17:00:00 | AAPL | Stock | 0.4457 | 0.4457 | 0.4441 | 0.4441 | 509600.0 |
| 2001-05-03 18:00:00 | AAPL | Stock | 0.4421 | 0.4438 | 0.4421 | 0.4438 | 39200.0 |
| 2001-05-03 08:00:00 | MSFT | Stock | 34.79 | 34.88 | 34.575 | 34.675 | 153600.0 |
| 2001-05-03 09:00:00 | MSFT | Stock | 34.675 | 35.09 | 34.175 | 34.91 | 11266200.0 |
| 2001-05-03 10:00:00 | MSFT | Stock | 34.925 | 35.0 | 34.51 | 34.695 | 11392400.0 |
| 2001-05-03 11:00:00 | MSFT | Stock | 34.68 | 34.715 | 34.45 | 34.585 | 7200600.0 |
| 2001-05-03 12:00:00 | MSFT | Stock | 34.59 | 34.69 | 34.425 | 34.455 | 4824800.0 |
| 2001-05-03 13:00:00 | MSFT | Stock | 34.45 | 34.52 | 34.335 | 34.47 | 5334600.0 |
| 2001-05-03 14:00:00 | MSFT | Stock | 34.47 | 34.475 | 34.07 | 34.295 | 7246200.0 |
| 2001-05-03 15:00:00 | MSFT | Stock | 34.3 | 34.4 | 34.13 | 34.265 | 10236600.0 |
| 2001-05-03 16:00:00 | MSFT | Stock | 34.265 | 34.525 | 34.24 | 34.25 | 3207200.0 |
| 2001-05-03 17:00:00 | MSFT | Stock | 34.31 | 34.31 | 34.265 | 34.31 | 66200.0 |
| 2001-05-03 18:00:00 | MSFT | Stock | 34.31 | 34.31 | 34.31 | 34.31 | 200.0 |
| 2001-05-03 08:00:00 | NVDA | Stock | 0.3658 | 0.3658 | 0.3583 | 0.3583 | 648000.0 |
| 2001-05-03 09:00:00 | NVDA | Stock | 0.3584 | 0.3636 | 0.3575 | 0.3627 | 172224000.0 |
| 2001-05-03 10:00:00 | NVDA | Stock | 0.3629 | 0.3681 | 0.3605 | 0.3661 | 163728000.0 |
| 2001-05-03 11:00:00 | NVDA | Stock | 0.3663 | 0.3675 | 0.3604 | 0.3621 | 145536000.0 |
| 2001-05-03 12:00:00 | NVDA | Stock | 0.3621 | 0.365 | 0.3604 | 0.3635 | 57264000.0 |
| 2001-05-03 13:00:00 | NVDA | Stock | 0.3636 | 0.3663 | 0.362 | 0.3658 | 103680000.0 |
| 2001-05-03 14:00:00 | NVDA | Stock | 0.3661 | 0.3668 | 0.3573 | 0.3608 | 100392000.0 |
| 2001-05-03 15:00:00 | NVDA | Stock | 0.3602 | 0.3708 | 0.3587 | 0.3692 | 144624000.0 |
| 2001-05-03 16:00:00 | NVDA | Stock | 0.3692 | 0.3726 | 0.3668 | 0.3679 | 8520000.0 |
| 2001-05-03 17:00:00 | NVDA | Stock | 0.3679 | 0.3692 | 0.3679 | 0.3683 | 840000.0 |
| 2001-05-03 18:00:00 | NVDA | Stock | 0.3675 | 0.3675 | 0.3667 | 0.3667 | 336000.0 |
| 2001-05-03 08:00:00 | AMZN | Stock | 0.8535 | 0.8535 | 0.8125 | 0.815 | 16000.0 |
| 2001-05-03 09:00:00 | AMZN | Stock | 0.837 | 0.8475 | 0.8125 | 0.822 | 8834000.0 |
| 2001-05-03 10:00:00 | AMZN | Stock | 0.824 | 0.8345 | 0.817 | 0.83 | 14328000.0 |
| 2001-05-03 11:00:00 | AMZN | Stock | 0.8305 | 0.835 | 0.824 | 0.828 | 14298000.0 |
| 2001-05-03 12:00:00 | AMZN | Stock | 0.8285 | 0.85 | 0.8265 | 0.839 | 16614000.0 |
| 2001-05-03 13:00:00 | AMZN | Stock | 0.8395 | 0.8425 | 0.8275 | 0.835 | 7654000.0 |
| 2001-05-03 14:00:00 | AMZN | Stock | 0.835 | 0.8355 | 0.8275 | 0.8275 | 9934000.0 |
| 2001-05-03 15:00:00 | AMZN | Stock | 0.828 | 0.8415 | 0.825 | 0.8375 | 15340000.0 |
| 2001-05-03 16:00:00 | AMZN | Stock | 0.8375 | 0.8405 | 0.831 | 0.8375 | 1864000.0 |
| 2001-05-03 17:00:00 | AMZN | Stock | 0.8345 | 0.8345 | 0.8345 | 0.8345 | 4000.0 |
| 2001-05-03 09:00:00 | CL | Stock | 28.0 | 28.005 | 27.8 | 27.8 | 251200.0 |
| 2001-05-03 10:00:00 | CL | Stock | 27.805 | 27.95 | 27.6 | 27.925 | 363600.0 |
| 2001-05-03 11:00:00 | CL | Stock | 27.94 | 28.025 | 27.775 | 27.97 | 245600.0 |
| 2001-05-03 12:00:00 | CL | Stock | 27.97 | 28.15 | 27.9 | 27.9 | 254200.0 |
| 2001-05-03 13:00:00 | CL | Stock | 27.9 | 27.91 | 27.75 | 27.8 | 351600.0 |
| 2001-05-03 14:00:00 | CL | Stock | 27.825 | 27.875 | 27.67 | 27.695 | 351800.0 |
| 2001-05-03 15:00:00 | CL | Stock | 27.7 | 28.0 | 27.655 | 27.93 | 518200.0 |
> showing 50 of 16,797 rows — these rows as CSV