PREVIEW / stock_5min / 2004-10-14
file: by_date/stock_5min/2004/2004-10-14.parquet size: 2.4 MB rows: 174,553 symbols: 1,833
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-14 08:00:00 | AAPL | Stock | 0.7696 | 0.7759 | 0.7661 | 0.775 | 11999400.0 |
| 2004-10-14 08:05:00 | AAPL | Stock | 0.775 | 0.775 | 0.7679 | 0.7688 | 6165712.0 |
| 2004-10-14 08:10:00 | AAPL | Stock | 0.7695 | 0.7704 | 0.7661 | 0.7696 | 2268112.0 |
| 2004-10-14 08:15:00 | AAPL | Stock | 0.7696 | 0.7773 | 0.7688 | 0.7755 | 8786680.0 |
| 2004-10-14 08:20:00 | AAPL | Stock | 0.7759 | 0.7759 | 0.7723 | 0.7732 | 11259640.0 |
| 2004-10-14 08:25:00 | AAPL | Stock | 0.7739 | 0.775 | 0.7723 | 0.775 | 6374200.0 |
| 2004-10-14 08:30:00 | AAPL | Stock | 0.775 | 0.775 | 0.7679 | 0.7679 | 4804800.0 |
| 2004-10-14 08:35:00 | AAPL | Stock | 0.7743 | 0.7743 | 0.7721 | 0.7729 | 6386240.0 |
| 2004-10-14 08:40:00 | AAPL | Stock | 0.7732 | 0.7736 | 0.7714 | 0.7721 | 6782720.0 |
| 2004-10-14 08:45:00 | AAPL | Stock | 0.7718 | 0.7732 | 0.7718 | 0.7732 | 2769368.0 |
| 2004-10-14 08:50:00 | AAPL | Stock | 0.7732 | 0.7748 | 0.7727 | 0.7748 | 2516976.0 |
| 2004-10-14 08:55:00 | AAPL | Stock | 0.7741 | 0.7746 | 0.7741 | 0.7746 | 1162560.0 |
| 2004-10-14 09:00:00 | AAPL | Stock | 0.7745 | 0.7786 | 0.7043 | 0.7786 | 14109200.0 |
| 2004-10-14 09:05:00 | AAPL | Stock | 0.7788 | 0.7788 | 0.7764 | 0.7777 | 13834464.0 |
| 2004-10-14 09:10:00 | AAPL | Stock | 0.7777 | 0.7802 | 0.7775 | 0.7789 | 23187136.0 |
| 2004-10-14 09:15:00 | AAPL | Stock | 0.7793 | 0.7804 | 0.7782 | 0.7786 | 11298336.0 |
| 2004-10-14 09:20:00 | AAPL | Stock | 0.7784 | 0.7795 | 0.7729 | 0.7732 | 36985144.0 |
| 2004-10-14 09:25:00 | AAPL | Stock | 0.7732 | 0.7798 | 0.7698 | 0.7698 | 23483152.0 |
| 2004-10-14 09:30:00 | AAPL | Stock | 0.7711 | 0.772 | 0.7634 | 0.7695 | 119117040.0 |
| 2004-10-14 09:35:00 | AAPL | Stock | 0.7691 | 0.7711 | 0.767 | 0.7675 | 88942168.0 |
| 2004-10-14 09:40:00 | AAPL | Stock | 0.7673 | 0.7684 | 0.7641 | 0.7666 | 67888128.0 |
| 2004-10-14 09:45:00 | AAPL | Stock | 0.7666 | 0.7671 | 0.7629 | 0.7629 | 49970088.0 |
| 2004-10-14 09:50:00 | AAPL | Stock | 0.7629 | 0.7634 | 0.7598 | 0.7623 | 56461496.0 |
| 2004-10-14 09:55:00 | AAPL | Stock | 0.7623 | 0.7643 | 0.7607 | 0.7611 | 54182184.0 |
| 2004-10-14 10:00:00 | AAPL | Stock | 0.7611 | 0.7677 | 0.7607 | 0.7668 | 47512304.0 |
| 2004-10-14 10:05:00 | AAPL | Stock | 0.7668 | 0.7679 | 0.765 | 0.7664 | 37713200.0 |
| 2004-10-14 10:10:00 | AAPL | Stock | 0.7668 | 0.775 | 0.7664 | 0.7746 | 65345672.0 |
| 2004-10-14 10:15:00 | AAPL | Stock | 0.7746 | 0.7775 | 0.7716 | 0.7746 | 59261888.0 |
| 2004-10-14 10:20:00 | AAPL | Stock | 0.7748 | 0.7788 | 0.7732 | 0.7768 | 54103952.0 |
| 2004-10-14 10:25:00 | AAPL | Stock | 0.7768 | 0.7777 | 0.7752 | 0.7761 | 31183712.0 |
| 2004-10-14 10:30:00 | AAPL | Stock | 0.7761 | 0.785 | 0.7761 | 0.7838 | 44515072.0 |
| 2004-10-14 10:35:00 | AAPL | Stock | 0.7839 | 0.7857 | 0.7804 | 0.782 | 46733568.0 |
| 2004-10-14 10:40:00 | AAPL | Stock | 0.7814 | 0.7875 | 0.7813 | 0.7875 | 45865232.0 |
| 2004-10-14 10:45:00 | AAPL | Stock | 0.7875 | 0.7925 | 0.7864 | 0.7904 | 62484688.0 |
| 2004-10-14 10:50:00 | AAPL | Stock | 0.7904 | 0.7904 | 0.7873 | 0.7879 | 32175584.0 |
| 2004-10-14 10:55:00 | AAPL | Stock | 0.7879 | 0.7879 | 0.7854 | 0.7873 | 30668232.0 |
| 2004-10-14 11:00:00 | AAPL | Stock | 0.7875 | 0.79 | 0.7864 | 0.79 | 21304696.0 |
| 2004-10-14 11:05:00 | AAPL | Stock | 0.79 | 0.7941 | 0.7893 | 0.7934 | 44725632.0 |
| 2004-10-14 11:10:00 | AAPL | Stock | 0.7936 | 0.7952 | 0.7898 | 0.7914 | 34183016.0 |
| 2004-10-14 11:15:00 | AAPL | Stock | 0.7913 | 0.7993 | 0.7905 | 0.7993 | 48608056.0 |
| 2004-10-14 11:20:00 | AAPL | Stock | 0.7993 | 0.8023 | 0.7988 | 0.8005 | 59539928.0 |
| 2004-10-14 11:25:00 | AAPL | Stock | 0.8007 | 0.8039 | 0.7989 | 0.8029 | 58217600.0 |
| 2004-10-14 11:30:00 | AAPL | Stock | 0.8027 | 0.8032 | 0.7989 | 0.7991 | 37718968.0 |
| 2004-10-14 11:35:00 | AAPL | Stock | 0.8 | 0.8 | 0.793 | 0.7946 | 46850104.0 |
| 2004-10-14 11:40:00 | AAPL | Stock | 0.7943 | 0.7973 | 0.7932 | 0.7932 | 27779920.0 |
| 2004-10-14 11:45:00 | AAPL | Stock | 0.7932 | 0.7948 | 0.7911 | 0.792 | 20619480.0 |
| 2004-10-14 11:50:00 | AAPL | Stock | 0.792 | 0.7954 | 0.7911 | 0.7954 | 21805280.0 |
| 2004-10-14 11:55:00 | AAPL | Stock | 0.7954 | 0.7966 | 0.7941 | 0.7959 | 17716216.0 |
| 2004-10-14 12:00:00 | AAPL | Stock | 0.7957 | 0.7971 | 0.7929 | 0.7939 | 13089776.0 |
| 2004-10-14 12:05:00 | AAPL | Stock | 0.7938 | 0.7952 | 0.7932 | 0.7943 | 12278392.0 |
> showing 50 of 174,553 rows — these rows as CSV