PREVIEW / stock_5min / 2009-01-14
file: by_date/stock_5min/2009/2009-01-14.parquet size: 4.4 MB rows: 311,565 symbols: 3,315
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-14 07:30:00 | AAPL | Stock | 3.1125 | 3.1125 | 3.1125 | 3.1125 | 2800.0 |
| 2009-01-14 07:45:00 | AAPL | Stock | 3.1104 | 3.1104 | 3.1079 | 3.1079 | 5600.0 |
| 2009-01-14 07:55:00 | AAPL | Stock | 3.1029 | 3.1029 | 3.1029 | 3.1029 | 2800.0 |
| 2009-01-14 08:00:00 | AAPL | Stock | 3.1061 | 3.1071 | 3.1061 | 3.1071 | 23436.0 |
| 2009-01-14 08:05:00 | AAPL | Stock | 3.1071 | 3.1071 | 3.1 | 3.1 | 57400.0 |
| 2009-01-14 08:10:00 | AAPL | Stock | 3.1036 | 3.1036 | 3.095 | 3.0964 | 105000.0 |
| 2009-01-14 08:15:00 | AAPL | Stock | 3.0979 | 3.0982 | 3.0921 | 3.0946 | 117600.0 |
| 2009-01-14 08:20:00 | AAPL | Stock | 3.0921 | 3.0954 | 3.0921 | 3.095 | 25200.0 |
| 2009-01-14 08:25:00 | AAPL | Stock | 3.0943 | 3.0975 | 3.0943 | 3.0975 | 22400.0 |
| 2009-01-14 08:30:00 | AAPL | Stock | 3.0943 | 3.0975 | 3.0893 | 3.0893 | 94640.0 |
| 2009-01-14 08:35:00 | AAPL | Stock | 3.0893 | 3.0914 | 3.0893 | 3.0914 | 96180.0 |
| 2009-01-14 08:40:00 | AAPL | Stock | 3.09 | 3.09 | 3.0875 | 3.0879 | 127512.0 |
| 2009-01-14 08:45:00 | AAPL | Stock | 3.0871 | 3.0889 | 3.0871 | 3.0882 | 44240.0 |
| 2009-01-14 08:50:00 | AAPL | Stock | 3.0879 | 3.0893 | 3.0864 | 3.0864 | 74116.0 |
| 2009-01-14 08:55:00 | AAPL | Stock | 3.0868 | 3.0868 | 3.0771 | 3.0775 | 189140.0 |
| 2009-01-14 09:00:00 | AAPL | Stock | 3.0775 | 3.0789 | 3.0714 | 3.0775 | 187040.0 |
| 2009-01-14 09:05:00 | AAPL | Stock | 3.0775 | 3.0821 | 3.0768 | 3.0768 | 219212.0 |
| 2009-01-14 09:10:00 | AAPL | Stock | 3.0779 | 3.0804 | 3.0779 | 3.0789 | 168000.0 |
| 2009-01-14 09:15:00 | AAPL | Stock | 3.0793 | 3.0821 | 3.0786 | 3.0821 | 75600.0 |
| 2009-01-14 09:20:00 | AAPL | Stock | 3.0836 | 3.0886 | 3.0836 | 3.0857 | 138600.0 |
| 2009-01-14 09:25:00 | AAPL | Stock | 3.0875 | 3.0875 | 3.0786 | 3.0836 | 196140.0 |
| 2009-01-14 09:30:00 | AAPL | Stock | 3.085 | 3.1071 | 3.0796 | 3.1061 | 14773724.0 |
| 2009-01-14 09:35:00 | AAPL | Stock | 3.1061 | 3.1161 | 3.0904 | 3.0961 | 16794624.0 |
| 2009-01-14 09:40:00 | AAPL | Stock | 3.0957 | 3.1071 | 3.0725 | 3.0736 | 16336012.0 |
| 2009-01-14 09:45:00 | AAPL | Stock | 3.0739 | 3.0871 | 3.0686 | 3.0821 | 19130860.0 |
| 2009-01-14 09:50:00 | AAPL | Stock | 3.0825 | 3.0857 | 3.0718 | 3.0821 | 13403544.0 |
| 2009-01-14 09:55:00 | AAPL | Stock | 3.0821 | 3.0882 | 3.0775 | 3.0811 | 11645172.0 |
| 2009-01-14 10:00:00 | AAPL | Stock | 3.0811 | 3.0921 | 3.0714 | 3.0864 | 14154336.0 |
| 2009-01-14 10:05:00 | AAPL | Stock | 3.0861 | 3.09 | 3.0761 | 3.0775 | 9817976.0 |
| 2009-01-14 10:10:00 | AAPL | Stock | 3.0775 | 3.0836 | 3.0632 | 3.0643 | 13357176.0 |
| 2009-01-14 10:15:00 | AAPL | Stock | 3.0643 | 3.0679 | 3.0593 | 3.0625 | 15306872.0 |
| 2009-01-14 10:20:00 | AAPL | Stock | 3.0625 | 3.0768 | 3.0596 | 3.0764 | 11624536.0 |
| 2009-01-14 10:25:00 | AAPL | Stock | 3.0764 | 3.0768 | 3.065 | 3.0671 | 8670004.0 |
| 2009-01-14 10:30:00 | AAPL | Stock | 3.0675 | 3.0714 | 3.0607 | 3.0639 | 11709572.0 |
| 2009-01-14 10:35:00 | AAPL | Stock | 3.0639 | 3.0682 | 3.0568 | 3.0614 | 10771208.0 |
| 2009-01-14 10:40:00 | AAPL | Stock | 3.0614 | 3.0632 | 3.0518 | 3.0561 | 13193740.0 |
| 2009-01-14 10:45:00 | AAPL | Stock | 3.0564 | 3.0607 | 3.0489 | 3.0596 | 11559212.0 |
| 2009-01-14 10:50:00 | AAPL | Stock | 3.0596 | 3.0618 | 3.0543 | 3.0579 | 8273300.0 |
| 2009-01-14 10:55:00 | AAPL | Stock | 3.0582 | 3.0671 | 3.0539 | 3.0646 | 9419536.0 |
| 2009-01-14 11:00:00 | AAPL | Stock | 3.0646 | 3.0664 | 3.0589 | 3.0593 | 5323388.0 |
| 2009-01-14 11:05:00 | AAPL | Stock | 3.0596 | 3.0643 | 3.0554 | 3.0604 | 8363768.0 |
| 2009-01-14 11:10:00 | AAPL | Stock | 3.06 | 3.0605 | 3.0521 | 3.0561 | 8730344.0 |
| 2009-01-14 11:15:00 | AAPL | Stock | 3.0564 | 3.0625 | 3.0546 | 3.0614 | 7038612.0 |
| 2009-01-14 11:20:00 | AAPL | Stock | 3.0618 | 3.0643 | 3.0564 | 3.0621 | 9999416.0 |
| 2009-01-14 11:25:00 | AAPL | Stock | 3.0621 | 3.0668 | 3.0618 | 3.0629 | 7260064.0 |
| 2009-01-14 11:30:00 | AAPL | Stock | 3.0629 | 3.0689 | 3.0604 | 3.0661 | 8680224.0 |
| 2009-01-14 11:35:00 | AAPL | Stock | 3.065 | 3.0671 | 3.0589 | 3.0639 | 5849704.0 |
| 2009-01-14 11:40:00 | AAPL | Stock | 3.0639 | 3.0714 | 3.0625 | 3.0668 | 7798700.0 |
| 2009-01-14 11:45:00 | AAPL | Stock | 3.0668 | 3.075 | 3.0632 | 3.0746 | 8290940.0 |
| 2009-01-14 11:50:00 | AAPL | Stock | 3.075 | 3.0832 | 3.0746 | 3.08 | 9184560.0 |
> showing 50 of 311,565 rows — these rows as CSV