PREVIEW / stock_5min / 2006-06-27
file: by_date/stock_5min/2006/2006-06-27.parquet size: 3.1 MB rows: 227,695 symbols: 2,288
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-27 07:10:00 | AAPL | Stock | 2.0946 | 2.0946 | 2.0893 | 2.0893 | 28000.0 |
| 2006-06-27 08:00:00 | AAPL | Stock | 2.1007 | 2.1007 | 2.1 | 2.1 | 7756.0 |
| 2006-06-27 08:05:00 | AAPL | Stock | 2.1 | 2.1029 | 2.1 | 2.1029 | 44800.0 |
| 2006-06-27 08:10:00 | AAPL | Stock | 2.0982 | 2.0986 | 2.0982 | 2.0986 | 26600.0 |
| 2006-06-27 08:15:00 | AAPL | Stock | 2.1018 | 2.1018 | 2.0971 | 2.0971 | 89600.0 |
| 2006-06-27 08:20:00 | AAPL | Stock | 2.0986 | 2.1 | 2.0986 | 2.1 | 202944.0 |
| 2006-06-27 08:25:00 | AAPL | Stock | 2.1 | 2.1 | 2.1 | 2.1 | 33600.0 |
| 2006-06-27 08:30:00 | AAPL | Stock | 2.1004 | 2.1004 | 2.1004 | 2.1004 | 19600.0 |
| 2006-06-27 08:40:00 | AAPL | Stock | 2.1036 | 2.1036 | 2.1036 | 2.1036 | 5600.0 |
| 2006-06-27 08:45:00 | AAPL | Stock | 2.1032 | 2.1032 | 2.1004 | 2.1004 | 5600.0 |
| 2006-06-27 08:50:00 | AAPL | Stock | 2.1018 | 2.1018 | 2.1018 | 2.1018 | 28000.0 |
| 2006-06-27 08:55:00 | AAPL | Stock | 2.1029 | 2.1032 | 2.1029 | 2.1029 | 56000.0 |
| 2006-06-27 09:00:00 | AAPL | Stock | 2.1039 | 2.1043 | 2.1039 | 2.1043 | 21000.0 |
| 2006-06-27 09:05:00 | AAPL | Stock | 2.1054 | 2.1086 | 2.1054 | 2.1086 | 81200.0 |
| 2006-06-27 09:10:00 | AAPL | Stock | 2.1071 | 2.1082 | 2.1071 | 2.1079 | 47600.0 |
| 2006-06-27 09:15:00 | AAPL | Stock | 2.1071 | 2.1071 | 2.1068 | 2.1068 | 70000.0 |
| 2006-06-27 09:20:00 | AAPL | Stock | 2.1071 | 2.1071 | 2.1071 | 2.1071 | 14000.0 |
| 2006-06-27 09:25:00 | AAPL | Stock | 2.1046 | 2.1125 | 2.1018 | 2.11 | 468132.0 |
| 2006-06-27 09:30:00 | AAPL | Stock | 2.1104 | 2.115 | 2.1054 | 2.1064 | 12600196.0 |
| 2006-06-27 09:35:00 | AAPL | Stock | 2.1064 | 2.1082 | 2.1018 | 2.1061 | 5416012.0 |
| 2006-06-27 09:40:00 | AAPL | Stock | 2.1061 | 2.1068 | 2.0993 | 2.1029 | 7456484.0 |
| 2006-06-27 09:45:00 | AAPL | Stock | 2.1029 | 2.1039 | 2.0961 | 2.0968 | 7874132.0 |
| 2006-06-27 09:50:00 | AAPL | Stock | 2.0968 | 2.1014 | 2.0929 | 2.0979 | 9410968.0 |
| 2006-06-27 09:55:00 | AAPL | Stock | 2.0979 | 2.0993 | 2.0957 | 2.0961 | 4577580.0 |
| 2006-06-27 10:00:00 | AAPL | Stock | 2.0964 | 2.0996 | 2.0889 | 2.0925 | 16022048.0 |
| 2006-06-27 10:05:00 | AAPL | Stock | 2.0925 | 2.1025 | 2.0868 | 2.0896 | 12884564.0 |
| 2006-06-27 10:10:00 | AAPL | Stock | 2.0896 | 2.0907 | 2.0846 | 2.0857 | 10617600.0 |
| 2006-06-27 10:15:00 | AAPL | Stock | 2.0857 | 2.0886 | 2.0757 | 2.0764 | 17752896.0 |
| 2006-06-27 10:20:00 | AAPL | Stock | 2.0768 | 2.08 | 2.0721 | 2.0732 | 14003276.0 |
| 2006-06-27 10:25:00 | AAPL | Stock | 2.0729 | 2.075 | 2.0686 | 2.0729 | 15271200.0 |
| 2006-06-27 10:30:00 | AAPL | Stock | 2.0729 | 2.0782 | 2.0729 | 2.0768 | 9397668.0 |
| 2006-06-27 10:35:00 | AAPL | Stock | 2.0771 | 2.0807 | 2.0757 | 2.0782 | 5467420.0 |
| 2006-06-27 10:40:00 | AAPL | Stock | 2.0782 | 2.0796 | 2.0768 | 2.0775 | 5492732.0 |
| 2006-06-27 10:45:00 | AAPL | Stock | 2.0775 | 2.08 | 2.0736 | 2.0739 | 8925532.0 |
| 2006-06-27 10:50:00 | AAPL | Stock | 2.0746 | 2.0746 | 2.07 | 2.0725 | 10931648.0 |
| 2006-06-27 10:55:00 | AAPL | Stock | 2.0725 | 2.0736 | 2.0639 | 2.0657 | 15735524.0 |
| 2006-06-27 11:00:00 | AAPL | Stock | 2.0657 | 2.0679 | 2.0639 | 2.0643 | 10103436.0 |
| 2006-06-27 11:05:00 | AAPL | Stock | 2.0636 | 2.0682 | 2.0625 | 2.0671 | 13026552.0 |
| 2006-06-27 11:10:00 | AAPL | Stock | 2.0671 | 2.0693 | 2.0614 | 2.0625 | 8400476.0 |
| 2006-06-27 11:15:00 | AAPL | Stock | 2.0625 | 2.0668 | 2.0621 | 2.0636 | 9248988.0 |
| 2006-06-27 11:20:00 | AAPL | Stock | 2.0636 | 2.0711 | 2.0636 | 2.0693 | 9178456.0 |
| 2006-06-27 11:25:00 | AAPL | Stock | 2.0686 | 2.0739 | 2.0679 | 2.0725 | 9523360.0 |
| 2006-06-27 11:30:00 | AAPL | Stock | 2.0725 | 2.0743 | 2.0696 | 2.0696 | 5740084.0 |
| 2006-06-27 11:35:00 | AAPL | Stock | 2.0696 | 2.0732 | 2.0696 | 2.0707 | 3207008.0 |
| 2006-06-27 11:40:00 | AAPL | Stock | 2.0707 | 2.0711 | 2.0671 | 2.0683 | 2717288.0 |
| 2006-06-27 11:45:00 | AAPL | Stock | 2.0686 | 2.0689 | 2.0668 | 2.0675 | 3327380.0 |
| 2006-06-27 11:50:00 | AAPL | Stock | 2.0671 | 2.0686 | 2.0661 | 2.0668 | 3690484.0 |
| 2006-06-27 11:55:00 | AAPL | Stock | 2.0668 | 2.07 | 2.0661 | 2.0689 | 3974264.0 |
| 2006-06-27 12:00:00 | AAPL | Stock | 2.0689 | 2.1116 | 2.0661 | 2.0664 | 2803500.0 |
| 2006-06-27 12:05:00 | AAPL | Stock | 2.0664 | 2.0664 | 2.0639 | 2.065 | 5176220.0 |
> showing 50 of 227,695 rows — these rows as CSV