PREVIEW / stock_5min / 2007-09-19
file: by_date/stock_5min/2007/2007-09-19.parquet size: 4.2 MB rows: 305,827 symbols: 3,134
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-09-19 09:30:00 | AAPL | Stock | 5.1071 | 5.1121 | 5.0714 | 5.0875 | 47966604.0 |
| 2007-09-19 09:35:00 | AAPL | Stock | 5.0871 | 5.0914 | 5.0746 | 5.0779 | 21993860.0 |
| 2007-09-19 09:40:00 | AAPL | Stock | 5.0775 | 5.0925 | 5.0754 | 5.0893 | 19999616.0 |
| 2007-09-19 09:45:00 | AAPL | Stock | 5.0889 | 5.0982 | 5.0882 | 5.0957 | 17692360.0 |
| 2007-09-19 09:50:00 | AAPL | Stock | 5.0957 | 5.1129 | 5.095 | 5.1 | 19748092.0 |
| 2007-09-19 09:55:00 | AAPL | Stock | 5.1 | 5.1 | 5.0793 | 5.0821 | 16758476.0 |
| 2007-09-19 10:00:00 | AAPL | Stock | 5.0814 | 5.0893 | 5.0807 | 5.085 | 6966120.0 |
| 2007-09-19 10:05:00 | AAPL | Stock | 5.0854 | 5.0879 | 5.0736 | 5.0793 | 13766592.0 |
| 2007-09-19 10:10:00 | AAPL | Stock | 5.0793 | 5.0807 | 5.0625 | 5.0693 | 24425968.0 |
| 2007-09-19 10:15:00 | AAPL | Stock | 5.0686 | 5.0811 | 5.0686 | 5.0761 | 11076352.0 |
| 2007-09-19 10:20:00 | AAPL | Stock | 5.0761 | 5.0807 | 5.0729 | 5.0729 | 8249136.0 |
| 2007-09-19 10:25:00 | AAPL | Stock | 5.0725 | 5.0943 | 5.0714 | 5.0818 | 21592620.0 |
| 2007-09-19 10:30:00 | AAPL | Stock | 5.0814 | 5.0939 | 5.08 | 5.0929 | 11753084.0 |
| 2007-09-19 10:35:00 | AAPL | Stock | 5.0929 | 5.0936 | 5.0832 | 5.0846 | 9896180.0 |
| 2007-09-19 10:40:00 | AAPL | Stock | 5.085 | 5.0879 | 5.0786 | 5.0857 | 7062188.0 |
| 2007-09-19 10:45:00 | AAPL | Stock | 5.0854 | 5.0857 | 5.0814 | 5.0832 | 4290104.0 |
| 2007-09-19 10:50:00 | AAPL | Stock | 5.0829 | 5.0889 | 5.0825 | 5.0857 | 7232232.0 |
| 2007-09-19 10:55:00 | AAPL | Stock | 5.0864 | 5.0929 | 5.0846 | 5.0905 | 10967600.0 |
| 2007-09-19 11:00:00 | AAPL | Stock | 5.0907 | 5.0911 | 5.0861 | 5.0893 | 5543300.0 |
| 2007-09-19 11:05:00 | AAPL | Stock | 5.0889 | 5.0893 | 5.085 | 5.0889 | 4887932.0 |
| 2007-09-19 11:10:00 | AAPL | Stock | 5.0893 | 5.0907 | 5.0821 | 5.0889 | 5976068.0 |
| 2007-09-19 11:15:00 | AAPL | Stock | 5.0887 | 5.1068 | 5.0886 | 5.1039 | 17487316.0 |
| 2007-09-19 11:20:00 | AAPL | Stock | 5.1039 | 5.1089 | 5.1 | 5.1021 | 15937600.0 |
| 2007-09-19 11:25:00 | AAPL | Stock | 5.1018 | 5.1039 | 5.0886 | 5.0896 | 9806020.0 |
| 2007-09-19 11:30:00 | AAPL | Stock | 5.09 | 5.0964 | 5.0886 | 5.0939 | 7320012.0 |
| 2007-09-19 11:35:00 | AAPL | Stock | 5.0936 | 5.0943 | 5.0829 | 5.0843 | 10010364.0 |
| 2007-09-19 11:40:00 | AAPL | Stock | 5.0839 | 5.0911 | 5.0829 | 5.085 | 5996452.0 |
| 2007-09-19 11:45:00 | AAPL | Stock | 5.085 | 5.0946 | 5.0846 | 5.0871 | 7648760.0 |
| 2007-09-19 11:50:00 | AAPL | Stock | 5.0871 | 5.0886 | 5.0807 | 5.0868 | 9322936.0 |
| 2007-09-19 11:55:00 | AAPL | Stock | 5.0868 | 5.09 | 5.085 | 5.09 | 3816512.0 |
| 2007-09-19 12:00:00 | AAPL | Stock | 5.09 | 5.0904 | 5.0854 | 5.0868 | 4280892.0 |
| 2007-09-19 12:05:00 | AAPL | Stock | 5.0864 | 5.0921 | 5.0861 | 5.09 | 5061756.0 |
| 2007-09-19 12:10:00 | AAPL | Stock | 5.0903 | 5.0939 | 5.0864 | 5.0864 | 5664484.0 |
| 2007-09-19 12:15:00 | AAPL | Stock | 5.0864 | 5.0879 | 5.0771 | 5.0786 | 10368148.0 |
| 2007-09-19 12:20:00 | AAPL | Stock | 5.0779 | 5.0836 | 5.0757 | 5.0829 | 9134860.0 |
| 2007-09-19 12:25:00 | AAPL | Stock | 5.0829 | 5.0856 | 5.0779 | 5.0786 | 8052016.0 |
| 2007-09-19 12:30:00 | AAPL | Stock | 5.0786 | 5.08 | 5.0693 | 5.0693 | 12480636.0 |
| 2007-09-19 12:35:00 | AAPL | Stock | 5.0693 | 5.0764 | 5.0664 | 5.0746 | 9367232.0 |
| 2007-09-19 12:40:00 | AAPL | Stock | 5.0754 | 5.0793 | 5.0736 | 5.0782 | 5625648.0 |
| 2007-09-19 12:45:00 | AAPL | Stock | 5.0775 | 5.0843 | 5.075 | 5.0807 | 5512920.0 |
| 2007-09-19 12:50:00 | AAPL | Stock | 5.0811 | 5.0829 | 5.0775 | 5.0829 | 4113592.0 |
| 2007-09-19 12:55:00 | AAPL | Stock | 5.0829 | 5.0907 | 5.0814 | 5.0825 | 8564836.0 |
| 2007-09-19 13:00:00 | AAPL | Stock | 5.0825 | 5.0829 | 5.0725 | 5.075 | 8439760.0 |
| 2007-09-19 13:05:00 | AAPL | Stock | 5.0754 | 5.0796 | 5.0725 | 5.0782 | 8194816.0 |
| 2007-09-19 13:10:00 | AAPL | Stock | 5.0786 | 5.0789 | 5.0732 | 5.075 | 5705336.0 |
| 2007-09-19 13:15:00 | AAPL | Stock | 5.0746 | 5.0796 | 5.0706 | 5.0754 | 7112448.0 |
| 2007-09-19 13:20:00 | AAPL | Stock | 5.0757 | 5.0786 | 5.0629 | 5.063 | 12174260.0 |
| 2007-09-19 13:25:00 | AAPL | Stock | 5.0629 | 5.0696 | 5.0589 | 5.0618 | 7817740.0 |
| 2007-09-19 13:30:00 | AAPL | Stock | 5.0621 | 5.0779 | 5.0589 | 5.075 | 9436616.0 |
| 2007-09-19 13:35:00 | AAPL | Stock | 5.0754 | 5.0804 | 5.0729 | 5.0736 | 6810916.0 |
> showing 50 of 305,827 rows — these rows as CSV