PREVIEW / stock_5min / 2007-07-09
file: by_date/stock_5min/2007/2007-07-09.parquet size: 4.0 MB rows: 297,991 symbols: 3,067
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 |
|---|---|---|---|---|---|---|---|
| 2007-07-09 09:30:00 | AAPL | Stock | 4.7279 | 4.7464 | 4.7 | 4.74 | 33812996.0 |
| 2007-07-09 09:35:00 | AAPL | Stock | 4.7407 | 4.7445 | 4.7089 | 4.7196 | 25432512.0 |
| 2007-07-09 09:40:00 | AAPL | Stock | 4.7196 | 4.7286 | 4.7118 | 4.715 | 26320392.0 |
| 2007-07-09 09:45:00 | AAPL | Stock | 4.7146 | 4.7189 | 4.6789 | 4.7014 | 33533192.0 |
| 2007-07-09 09:50:00 | AAPL | Stock | 4.7014 | 4.7061 | 4.6921 | 4.6934 | 20223952.0 |
| 2007-07-09 09:55:00 | AAPL | Stock | 4.6932 | 4.7043 | 4.6857 | 4.6993 | 24489220.0 |
| 2007-07-09 10:00:00 | AAPL | Stock | 4.6986 | 4.7096 | 4.6946 | 4.6982 | 23352420.0 |
| 2007-07-09 10:05:00 | AAPL | Stock | 4.6989 | 4.7054 | 4.6936 | 4.6946 | 11380264.0 |
| 2007-07-09 10:10:00 | AAPL | Stock | 4.6946 | 4.6979 | 4.6875 | 4.6964 | 14318248.0 |
| 2007-07-09 10:15:00 | AAPL | Stock | 4.6964 | 4.7011 | 4.6921 | 4.6982 | 8917636.0 |
| 2007-07-09 10:20:00 | AAPL | Stock | 4.6971 | 4.7111 | 4.6964 | 4.705 | 15857856.0 |
| 2007-07-09 10:25:00 | AAPL | Stock | 4.7044 | 4.705 | 4.6946 | 4.6982 | 8760192.0 |
| 2007-07-09 10:30:00 | AAPL | Stock | 4.6979 | 4.6996 | 4.6893 | 4.6936 | 8015028.0 |
| 2007-07-09 10:35:00 | AAPL | Stock | 4.6936 | 4.6946 | 4.6786 | 4.6796 | 22519784.0 |
| 2007-07-09 10:40:00 | AAPL | Stock | 4.6793 | 4.6829 | 4.6611 | 4.6654 | 31571624.0 |
| 2007-07-09 10:45:00 | AAPL | Stock | 4.6647 | 4.6725 | 4.6589 | 4.6715 | 24692052.0 |
| 2007-07-09 10:50:00 | AAPL | Stock | 4.6715 | 4.675 | 4.6579 | 4.6607 | 17859156.0 |
| 2007-07-09 10:55:00 | AAPL | Stock | 4.6604 | 4.6693 | 4.6514 | 4.6518 | 13013224.0 |
| 2007-07-09 11:00:00 | AAPL | Stock | 4.6511 | 4.6664 | 4.6507 | 4.6643 | 16134608.0 |
| 2007-07-09 11:05:00 | AAPL | Stock | 4.6643 | 4.6696 | 4.6614 | 4.6646 | 9399740.0 |
| 2007-07-09 11:10:00 | AAPL | Stock | 4.6643 | 4.6693 | 4.6621 | 4.6632 | 6570648.0 |
| 2007-07-09 11:15:00 | AAPL | Stock | 4.6636 | 4.6639 | 4.6582 | 4.6602 | 6145972.0 |
| 2007-07-09 11:20:00 | AAPL | Stock | 4.6604 | 4.6614 | 4.6504 | 4.6578 | 12300260.0 |
| 2007-07-09 11:25:00 | AAPL | Stock | 4.6571 | 4.6725 | 4.6571 | 4.6682 | 11959724.0 |
| 2007-07-09 11:30:00 | AAPL | Stock | 4.6682 | 4.6693 | 4.6643 | 4.6671 | 4359824.0 |
| 2007-07-09 11:35:00 | AAPL | Stock | 4.6668 | 4.6704 | 4.6643 | 4.6671 | 6907152.0 |
| 2007-07-09 11:40:00 | AAPL | Stock | 4.6671 | 4.6696 | 4.6632 | 4.6632 | 4638284.0 |
| 2007-07-09 11:45:00 | AAPL | Stock | 4.6632 | 4.6643 | 4.6561 | 4.6564 | 6054552.0 |
| 2007-07-09 11:50:00 | AAPL | Stock | 4.6568 | 4.667 | 4.6554 | 4.6657 | 6602204.0 |
| 2007-07-09 11:55:00 | AAPL | Stock | 4.6661 | 4.6668 | 4.6607 | 4.6616 | 2683800.0 |
| 2007-07-09 12:00:00 | AAPL | Stock | 4.6621 | 4.665 | 4.6605 | 4.6639 | 4249532.0 |
| 2007-07-09 12:05:00 | AAPL | Stock | 4.6639 | 4.6643 | 4.6579 | 4.6596 | 5205004.0 |
| 2007-07-09 12:10:00 | AAPL | Stock | 4.6596 | 4.6604 | 4.6464 | 4.6543 | 13519716.0 |
| 2007-07-09 12:15:00 | AAPL | Stock | 4.6543 | 4.6564 | 4.6511 | 4.655 | 7207424.0 |
| 2007-07-09 12:20:00 | AAPL | Stock | 4.655 | 4.6586 | 4.6546 | 4.6546 | 5493348.0 |
| 2007-07-09 12:25:00 | AAPL | Stock | 4.6546 | 4.6575 | 4.6536 | 4.6561 | 2276008.0 |
| 2007-07-09 12:30:00 | AAPL | Stock | 4.6564 | 4.6664 | 4.6553 | 4.6639 | 7497028.0 |
| 2007-07-09 12:35:00 | AAPL | Stock | 4.6642 | 4.6657 | 4.6543 | 4.6575 | 4949756.0 |
| 2007-07-09 12:40:00 | AAPL | Stock | 4.6571 | 4.6625 | 4.6554 | 4.6593 | 3311532.0 |
| 2007-07-09 12:45:00 | AAPL | Stock | 4.6593 | 4.6643 | 4.6589 | 4.6624 | 5188876.0 |
| 2007-07-09 12:50:00 | AAPL | Stock | 4.6621 | 4.6711 | 4.6621 | 4.6711 | 8489488.0 |
| 2007-07-09 12:55:00 | AAPL | Stock | 4.6711 | 4.6711 | 4.6629 | 4.6629 | 7392392.0 |
| 2007-07-09 13:00:00 | AAPL | Stock | 4.6632 | 4.6643 | 4.6564 | 4.6589 | 10985324.0 |
| 2007-07-09 13:05:00 | AAPL | Stock | 4.6593 | 4.6596 | 4.6554 | 4.6596 | 6791708.0 |
| 2007-07-09 13:10:00 | AAPL | Stock | 4.6596 | 4.6625 | 4.6514 | 4.652 | 6884444.0 |
| 2007-07-09 13:15:00 | AAPL | Stock | 4.6521 | 4.6571 | 4.6518 | 4.6536 | 5710264.0 |
| 2007-07-09 13:20:00 | AAPL | Stock | 4.6536 | 4.6536 | 4.6446 | 4.6493 | 11199524.0 |
| 2007-07-09 13:25:00 | AAPL | Stock | 4.6496 | 4.655 | 4.6486 | 4.6525 | 6424348.0 |
| 2007-07-09 13:30:00 | AAPL | Stock | 4.6525 | 4.6532 | 4.6361 | 4.6411 | 22227380.0 |
| 2007-07-09 13:35:00 | AAPL | Stock | 4.6411 | 4.6443 | 4.6375 | 4.6384 | 7672588.0 |
> showing 50 of 297,991 rows — these rows as CSV