PREVIEW / stock_5min / 2004-10-27
file: by_date/stock_5min/2004/2004-10-27.parquet size: 2.7 MB rows: 192,028 symbols: 1,851
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-27 08:00:00 | AAPL | Stock | 0.8679 | 0.8679 | 0.8652 | 0.8654 | 170800.0 |
| 2004-10-27 08:05:00 | AAPL | Stock | 0.8652 | 0.8652 | 0.865 | 0.865 | 84000.0 |
| 2004-10-27 08:10:00 | AAPL | Stock | 0.8643 | 0.8643 | 0.8643 | 0.8643 | 7000.0 |
| 2004-10-27 08:15:00 | AAPL | Stock | 0.8643 | 0.8643 | 0.8616 | 0.8643 | 145600.0 |
| 2004-10-27 08:20:00 | AAPL | Stock | 0.8634 | 0.8634 | 0.862 | 0.862 | 106400.0 |
| 2004-10-27 08:25:00 | AAPL | Stock | 0.8616 | 0.8616 | 0.8616 | 0.8616 | 11200.0 |
| 2004-10-27 08:30:00 | AAPL | Stock | 0.8616 | 0.8643 | 0.8616 | 0.8643 | 211400.0 |
| 2004-10-27 08:35:00 | AAPL | Stock | 0.8627 | 0.8627 | 0.8627 | 0.8627 | 54600.0 |
| 2004-10-27 08:40:00 | AAPL | Stock | 0.8645 | 0.8663 | 0.8645 | 0.8659 | 253400.0 |
| 2004-10-27 08:45:00 | AAPL | Stock | 0.8634 | 0.8634 | 0.8634 | 0.8634 | 44800.0 |
| 2004-10-27 08:50:00 | AAPL | Stock | 0.8652 | 0.8652 | 0.8652 | 0.8652 | 28000.0 |
| 2004-10-27 08:55:00 | AAPL | Stock | 0.8634 | 0.8634 | 0.8634 | 0.8634 | 11200.0 |
| 2004-10-27 09:00:00 | AAPL | Stock | 0.8643 | 0.8643 | 0.8643 | 0.8643 | 28000.0 |
| 2004-10-27 09:05:00 | AAPL | Stock | 0.8657 | 0.867 | 0.8657 | 0.867 | 298200.0 |
| 2004-10-27 09:10:00 | AAPL | Stock | 0.867 | 0.867 | 0.8652 | 0.8659 | 224000.0 |
| 2004-10-27 09:15:00 | AAPL | Stock | 0.8659 | 0.8661 | 0.8659 | 0.8661 | 123200.0 |
| 2004-10-27 09:20:00 | AAPL | Stock | 0.8645 | 0.8748 | 0.8639 | 0.8679 | 978320.0 |
| 2004-10-27 09:25:00 | AAPL | Stock | 0.8582 | 0.8693 | 0.8577 | 0.8684 | 3157000.0 |
| 2004-10-27 09:30:00 | AAPL | Stock | 0.8689 | 0.8729 | 0.865 | 0.8711 | 34203848.0 |
| 2004-10-27 09:35:00 | AAPL | Stock | 0.8711 | 0.8714 | 0.863 | 0.863 | 16013424.0 |
| 2004-10-27 09:40:00 | AAPL | Stock | 0.8629 | 0.865 | 0.8602 | 0.8634 | 23973096.0 |
| 2004-10-27 09:45:00 | AAPL | Stock | 0.8638 | 0.8661 | 0.8625 | 0.863 | 16808456.0 |
| 2004-10-27 09:50:00 | AAPL | Stock | 0.863 | 0.8634 | 0.8614 | 0.8629 | 16354688.0 |
| 2004-10-27 09:55:00 | AAPL | Stock | 0.8629 | 0.8634 | 0.8616 | 0.8618 | 10849888.0 |
| 2004-10-27 10:00:00 | AAPL | Stock | 0.8618 | 0.863 | 0.8611 | 0.8629 | 5279736.0 |
| 2004-10-27 10:05:00 | AAPL | Stock | 0.8629 | 0.8639 | 0.8614 | 0.863 | 8000720.0 |
| 2004-10-27 10:10:00 | AAPL | Stock | 0.8632 | 0.8675 | 0.8632 | 0.8673 | 16004352.0 |
| 2004-10-27 10:15:00 | AAPL | Stock | 0.8671 | 0.8718 | 0.8661 | 0.8713 | 20079416.0 |
| 2004-10-27 10:20:00 | AAPL | Stock | 0.8714 | 0.8721 | 0.8698 | 0.8713 | 20800304.0 |
| 2004-10-27 10:25:00 | AAPL | Stock | 0.8714 | 0.8754 | 0.8713 | 0.8736 | 19803560.0 |
| 2004-10-27 10:30:00 | AAPL | Stock | 0.8729 | 0.8741 | 0.8698 | 0.873 | 27397720.0 |
| 2004-10-27 10:35:00 | AAPL | Stock | 0.8729 | 0.8732 | 0.8705 | 0.8714 | 12073096.0 |
| 2004-10-27 10:40:00 | AAPL | Stock | 0.8714 | 0.8716 | 0.8686 | 0.8702 | 7719432.0 |
| 2004-10-27 10:45:00 | AAPL | Stock | 0.8702 | 0.8705 | 0.867 | 0.867 | 11460680.0 |
| 2004-10-27 10:50:00 | AAPL | Stock | 0.8673 | 0.8739 | 0.8666 | 0.8734 | 13924120.0 |
| 2004-10-27 10:55:00 | AAPL | Stock | 0.8732 | 0.8748 | 0.8721 | 0.8748 | 18488008.0 |
| 2004-10-27 11:00:00 | AAPL | Stock | 0.8748 | 0.8759 | 0.873 | 0.8745 | 21434336.0 |
| 2004-10-27 11:05:00 | AAPL | Stock | 0.8748 | 0.8796 | 0.8739 | 0.8768 | 25047736.0 |
| 2004-10-27 11:10:00 | AAPL | Stock | 0.8768 | 0.8768 | 0.8738 | 0.8746 | 16012472.0 |
| 2004-10-27 11:15:00 | AAPL | Stock | 0.8746 | 0.8805 | 0.8746 | 0.8804 | 16203544.0 |
| 2004-10-27 11:20:00 | AAPL | Stock | 0.8798 | 0.883 | 0.8795 | 0.8818 | 19848976.0 |
| 2004-10-27 11:25:00 | AAPL | Stock | 0.8821 | 0.8859 | 0.8811 | 0.8836 | 20855296.0 |
| 2004-10-27 11:30:00 | AAPL | Stock | 0.883 | 0.8854 | 0.8818 | 0.8843 | 13678112.0 |
| 2004-10-27 11:35:00 | AAPL | Stock | 0.8843 | 0.8905 | 0.8843 | 0.8884 | 22034096.0 |
| 2004-10-27 11:40:00 | AAPL | Stock | 0.8891 | 0.8916 | 0.8882 | 0.8898 | 18096064.0 |
| 2004-10-27 11:45:00 | AAPL | Stock | 0.89 | 0.892 | 0.8873 | 0.8882 | 14288400.0 |
| 2004-10-27 11:50:00 | AAPL | Stock | 0.8882 | 0.8886 | 0.8843 | 0.8845 | 14927864.0 |
| 2004-10-27 11:55:00 | AAPL | Stock | 0.8848 | 0.8859 | 0.8834 | 0.8852 | 10275048.0 |
| 2004-10-27 12:00:00 | AAPL | Stock | 0.8852 | 0.8886 | 0.8841 | 0.885 | 12365696.0 |
| 2004-10-27 12:05:00 | AAPL | Stock | 0.8846 | 0.8884 | 0.8845 | 0.8871 | 5498808.0 |
> showing 50 of 192,028 rows — these rows as CSV