PREVIEW / stock_5min / 2008-05-29
file: by_date/stock_5min/2008/2008-05-29.parquet size: 4.5 MB rows: 319,087 symbols: 3,293
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-29 07:50:00 | AAPL | Stock | 6.6886 | 6.6886 | 6.6668 | 6.6839 | 16800.0 |
| 2008-05-29 07:55:00 | AAPL | Stock | 6.6793 | 6.6793 | 6.6668 | 6.6668 | 14000.0 |
| 2008-05-29 08:00:00 | AAPL | Stock | 6.6782 | 6.6821 | 6.6696 | 6.6789 | 193032.0 |
| 2008-05-29 08:05:00 | AAPL | Stock | 6.6821 | 6.6936 | 6.6821 | 6.6936 | 576800.0 |
| 2008-05-29 08:10:00 | AAPL | Stock | 6.6929 | 6.6975 | 6.6882 | 6.6886 | 189000.0 |
| 2008-05-29 08:15:00 | AAPL | Stock | 6.6893 | 6.6918 | 6.6786 | 6.6789 | 253764.0 |
| 2008-05-29 08:20:00 | AAPL | Stock | 6.6793 | 6.6818 | 6.675 | 6.6793 | 85988.0 |
| 2008-05-29 08:25:00 | AAPL | Stock | 6.6793 | 6.6793 | 6.6714 | 6.6714 | 383096.0 |
| 2008-05-29 08:30:00 | AAPL | Stock | 6.6714 | 6.6718 | 6.6546 | 6.6568 | 672728.0 |
| 2008-05-29 08:35:00 | AAPL | Stock | 6.6543 | 6.6543 | 6.6432 | 6.6496 | 350476.0 |
| 2008-05-29 08:40:00 | AAPL | Stock | 6.6486 | 6.6511 | 6.6429 | 6.6429 | 258776.0 |
| 2008-05-29 08:45:00 | AAPL | Stock | 6.6443 | 6.6518 | 6.6443 | 6.6475 | 148176.0 |
| 2008-05-29 08:50:00 | AAPL | Stock | 6.6489 | 6.6529 | 6.6489 | 6.6518 | 78624.0 |
| 2008-05-29 08:55:00 | AAPL | Stock | 6.6518 | 6.6532 | 6.6489 | 6.6489 | 439712.0 |
| 2008-05-29 09:00:00 | AAPL | Stock | 6.65 | 6.6586 | 6.65 | 6.6571 | 101864.0 |
| 2008-05-29 09:05:00 | AAPL | Stock | 6.6586 | 6.6629 | 6.6546 | 6.6618 | 180908.0 |
| 2008-05-29 09:10:00 | AAPL | Stock | 6.6604 | 6.6671 | 6.6604 | 6.6643 | 224084.0 |
| 2008-05-29 09:15:00 | AAPL | Stock | 6.6643 | 6.6643 | 6.6586 | 6.6604 | 320432.0 |
| 2008-05-29 09:20:00 | AAPL | Stock | 6.6607 | 6.6668 | 6.6604 | 6.6639 | 87920.0 |
| 2008-05-29 09:25:00 | AAPL | Stock | 6.6693 | 6.6793 | 6.6664 | 6.6746 | 493332.0 |
| 2008-05-29 09:30:00 | AAPL | Stock | 6.6714 | 6.6811 | 6.6543 | 6.6575 | 17295684.0 |
| 2008-05-29 09:35:00 | AAPL | Stock | 6.6571 | 6.6614 | 6.6268 | 6.6493 | 15355228.0 |
| 2008-05-29 09:40:00 | AAPL | Stock | 6.6486 | 6.6786 | 6.6486 | 6.6621 | 11820088.0 |
| 2008-05-29 09:45:00 | AAPL | Stock | 6.6614 | 6.6643 | 6.6479 | 6.6582 | 9849672.0 |
| 2008-05-29 09:50:00 | AAPL | Stock | 6.6586 | 6.6671 | 6.625 | 6.6346 | 14963452.0 |
| 2008-05-29 09:55:00 | AAPL | Stock | 6.6346 | 6.6546 | 6.6343 | 6.6511 | 10053680.0 |
| 2008-05-29 10:00:00 | AAPL | Stock | 6.6526 | 6.6604 | 6.6393 | 6.6604 | 11620336.0 |
| 2008-05-29 10:05:00 | AAPL | Stock | 6.6607 | 6.6864 | 6.6504 | 6.6861 | 18442396.0 |
| 2008-05-29 10:10:00 | AAPL | Stock | 6.6864 | 6.6925 | 6.6575 | 6.665 | 17171560.0 |
| 2008-05-29 10:15:00 | AAPL | Stock | 6.6646 | 6.6729 | 6.6546 | 6.6568 | 8912652.0 |
| 2008-05-29 10:20:00 | AAPL | Stock | 6.6579 | 6.6736 | 6.6482 | 6.6714 | 11356520.0 |
| 2008-05-29 10:25:00 | AAPL | Stock | 6.6711 | 6.6911 | 6.67 | 6.6829 | 11620308.0 |
| 2008-05-29 10:30:00 | AAPL | Stock | 6.6836 | 6.6839 | 6.6436 | 6.6557 | 16665208.0 |
| 2008-05-29 10:35:00 | AAPL | Stock | 6.6557 | 6.6657 | 6.6489 | 6.6611 | 9966992.0 |
| 2008-05-29 10:40:00 | AAPL | Stock | 6.6611 | 6.6807 | 6.6571 | 6.6707 | 10337880.0 |
| 2008-05-29 10:45:00 | AAPL | Stock | 6.6704 | 6.6925 | 6.6686 | 6.6793 | 11720548.0 |
| 2008-05-29 10:50:00 | AAPL | Stock | 6.6802 | 6.6875 | 6.675 | 6.6786 | 8426012.0 |
| 2008-05-29 10:55:00 | AAPL | Stock | 6.6786 | 6.6893 | 6.6607 | 6.6686 | 8907976.0 |
| 2008-05-29 11:00:00 | AAPL | Stock | 6.6686 | 6.6782 | 6.6507 | 6.6507 | 10464636.0 |
| 2008-05-29 11:05:00 | AAPL | Stock | 6.6504 | 6.6639 | 6.6446 | 6.6604 | 9585716.0 |
| 2008-05-29 11:10:00 | AAPL | Stock | 6.6604 | 6.6775 | 6.6604 | 6.6718 | 8222116.0 |
| 2008-05-29 11:15:00 | AAPL | Stock | 6.6721 | 6.6739 | 6.6554 | 6.6571 | 5992336.0 |
| 2008-05-29 11:20:00 | AAPL | Stock | 6.6575 | 6.6654 | 6.6464 | 6.6493 | 5769484.0 |
| 2008-05-29 11:25:00 | AAPL | Stock | 6.6489 | 6.6589 | 6.6429 | 6.65 | 9661568.0 |
| 2008-05-29 11:30:00 | AAPL | Stock | 6.65 | 6.6575 | 6.6446 | 6.645 | 5398260.0 |
| 2008-05-29 11:35:00 | AAPL | Stock | 6.6446 | 6.6607 | 6.64 | 6.6553 | 7143696.0 |
| 2008-05-29 11:40:00 | AAPL | Stock | 6.6557 | 6.6696 | 6.6536 | 6.66 | 6981744.0 |
| 2008-05-29 11:45:00 | AAPL | Stock | 6.66 | 6.6807 | 6.6586 | 6.6786 | 9750104.0 |
| 2008-05-29 11:50:00 | AAPL | Stock | 6.6793 | 6.6839 | 6.6739 | 6.6839 | 7118944.0 |
| 2008-05-29 11:55:00 | AAPL | Stock | 6.6836 | 6.6911 | 6.6761 | 6.6761 | 9607360.0 |
> showing 50 of 319,087 rows — these rows as CSV