PREVIEW / stock_5min / 2007-01-26
file: by_date/stock_5min/2007/2007-01-26.parquet size: 3.3 MB rows: 239,736 symbols: 2,496
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-01-26 07:40:00 | AAPL | Stock | 3.0879 | 3.0896 | 3.0879 | 3.0896 | 11200.0 |
| 2007-01-26 07:50:00 | AAPL | Stock | 3.095 | 3.095 | 3.095 | 3.095 | 11200.0 |
| 2007-01-26 07:55:00 | AAPL | Stock | 3.095 | 3.0989 | 3.095 | 3.0989 | 56000.0 |
| 2007-01-26 08:00:00 | AAPL | Stock | 3.1004 | 3.1018 | 3.0936 | 3.0936 | 439040.0 |
| 2007-01-26 08:05:00 | AAPL | Stock | 3.095 | 3.0979 | 3.095 | 3.0968 | 95200.0 |
| 2007-01-26 08:10:00 | AAPL | Stock | 3.0975 | 3.0979 | 3.0936 | 3.0936 | 239260.0 |
| 2007-01-26 08:15:00 | AAPL | Stock | 3.0932 | 3.0946 | 3.0921 | 3.0929 | 65408.0 |
| 2007-01-26 08:20:00 | AAPL | Stock | 3.0929 | 3.0964 | 3.0929 | 3.0964 | 63196.0 |
| 2007-01-26 08:25:00 | AAPL | Stock | 3.0961 | 3.0979 | 3.095 | 3.0979 | 75432.0 |
| 2007-01-26 08:30:00 | AAPL | Stock | 3.0957 | 3.0982 | 3.0939 | 3.0975 | 211036.0 |
| 2007-01-26 08:35:00 | AAPL | Stock | 3.0964 | 3.0964 | 3.0957 | 3.0961 | 211400.0 |
| 2007-01-26 08:40:00 | AAPL | Stock | 3.0964 | 3.0982 | 3.0964 | 3.0971 | 192640.0 |
| 2007-01-26 08:45:00 | AAPL | Stock | 3.0982 | 3.1014 | 3.0979 | 3.1014 | 390656.0 |
| 2007-01-26 08:50:00 | AAPL | Stock | 3.1 | 3.1043 | 3.1 | 3.1036 | 749028.0 |
| 2007-01-26 08:55:00 | AAPL | Stock | 3.1036 | 3.1111 | 3.1036 | 3.1093 | 1054368.0 |
| 2007-01-26 09:00:00 | AAPL | Stock | 3.1093 | 3.1107 | 3.1071 | 3.1075 | 353668.0 |
| 2007-01-26 09:05:00 | AAPL | Stock | 3.1075 | 3.1089 | 3.1029 | 3.1071 | 290612.0 |
| 2007-01-26 09:10:00 | AAPL | Stock | 3.1057 | 3.1071 | 3.1046 | 3.1068 | 283024.0 |
| 2007-01-26 09:15:00 | AAPL | Stock | 3.1071 | 3.1071 | 3.1071 | 3.1071 | 26572.0 |
| 2007-01-26 09:20:00 | AAPL | Stock | 3.1029 | 3.1029 | 3.1 | 3.1 | 92344.0 |
| 2007-01-26 09:25:00 | AAPL | Stock | 3.1018 | 3.1118 | 3.1018 | 3.1114 | 617148.0 |
| 2007-01-26 09:30:00 | AAPL | Stock | 3.1112 | 3.1204 | 3.0911 | 3.095 | 24886988.0 |
| 2007-01-26 09:35:00 | AAPL | Stock | 3.095 | 3.0986 | 3.0857 | 3.0905 | 22116080.0 |
| 2007-01-26 09:40:00 | AAPL | Stock | 3.0904 | 3.0946 | 3.0768 | 3.0914 | 25279688.0 |
| 2007-01-26 09:45:00 | AAPL | Stock | 3.0911 | 3.0914 | 3.0714 | 3.075 | 25235980.0 |
| 2007-01-26 09:50:00 | AAPL | Stock | 3.0754 | 3.1157 | 3.0732 | 3.0761 | 17229184.0 |
| 2007-01-26 09:55:00 | AAPL | Stock | 3.0761 | 3.0796 | 3.0629 | 3.0679 | 29470532.0 |
| 2007-01-26 10:00:00 | AAPL | Stock | 3.0671 | 3.0736 | 3.0475 | 3.0507 | 36735048.0 |
| 2007-01-26 10:05:00 | AAPL | Stock | 3.0511 | 3.1093 | 3.0454 | 3.0525 | 33235748.0 |
| 2007-01-26 10:10:00 | AAPL | Stock | 3.0521 | 3.0646 | 3.0493 | 3.0636 | 22539048.0 |
| 2007-01-26 10:15:00 | AAPL | Stock | 3.0639 | 3.0661 | 3.0593 | 3.0629 | 14671356.0 |
| 2007-01-26 10:20:00 | AAPL | Stock | 3.0629 | 3.0771 | 3.0586 | 3.0771 | 25868696.0 |
| 2007-01-26 10:25:00 | AAPL | Stock | 3.0771 | 3.0861 | 3.075 | 3.0857 | 29128568.0 |
| 2007-01-26 10:30:00 | AAPL | Stock | 3.0857 | 3.0889 | 3.0782 | 3.0821 | 21387464.0 |
| 2007-01-26 10:35:00 | AAPL | Stock | 3.0825 | 3.0929 | 3.0779 | 3.0895 | 17498124.0 |
| 2007-01-26 10:40:00 | AAPL | Stock | 3.0889 | 3.0896 | 3.0793 | 3.0825 | 10048108.0 |
| 2007-01-26 10:45:00 | AAPL | Stock | 3.0825 | 3.0875 | 3.0814 | 3.0818 | 10944528.0 |
| 2007-01-26 10:50:00 | AAPL | Stock | 3.0818 | 3.0843 | 3.0682 | 3.0718 | 15699152.0 |
| 2007-01-26 10:55:00 | AAPL | Stock | 3.0718 | 3.0793 | 3.0718 | 3.0735 | 7252308.0 |
| 2007-01-26 11:00:00 | AAPL | Stock | 3.0732 | 3.075 | 3.0643 | 3.0689 | 12615456.0 |
| 2007-01-26 11:05:00 | AAPL | Stock | 3.0693 | 3.07 | 3.0629 | 3.0668 | 10827572.0 |
| 2007-01-26 11:10:00 | AAPL | Stock | 3.0668 | 3.0732 | 3.0625 | 3.0686 | 8807680.0 |
| 2007-01-26 11:15:00 | AAPL | Stock | 3.0686 | 3.0739 | 3.0671 | 3.0729 | 8262604.0 |
| 2007-01-26 11:20:00 | AAPL | Stock | 3.0729 | 3.0764 | 3.0707 | 3.0725 | 9506560.0 |
| 2007-01-26 11:25:00 | AAPL | Stock | 3.0732 | 3.0736 | 3.0689 | 3.0707 | 5746412.0 |
| 2007-01-26 11:30:00 | AAPL | Stock | 3.0707 | 3.0729 | 3.0664 | 3.0699 | 6975388.0 |
| 2007-01-26 11:35:00 | AAPL | Stock | 3.07 | 3.07 | 3.0625 | 3.0643 | 6477016.0 |
| 2007-01-26 11:40:00 | AAPL | Stock | 3.0639 | 3.0643 | 3.0582 | 3.0596 | 12278000.0 |
| 2007-01-26 11:45:00 | AAPL | Stock | 3.06 | 3.0639 | 3.0568 | 3.0582 | 9011744.0 |
| 2007-01-26 11:50:00 | AAPL | Stock | 3.0582 | 3.0618 | 3.0536 | 3.0571 | 10635072.0 |
> showing 50 of 239,736 rows — these rows as CSV