PREVIEW / stock_5min / 2006-06-16
file: by_date/stock_5min/2006/2006-06-16.parquet size: 3.1 MB rows: 228,619 symbols: 2,275
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-16 07:30:00 | AAPL | Stock | 2.1143 | 2.1143 | 2.1143 | 2.1143 | 5600.0 |
| 2006-06-16 07:35:00 | AAPL | Stock | 2.1143 | 2.1143 | 2.1143 | 2.1143 | 28000.0 |
| 2006-06-16 07:45:00 | AAPL | Stock | 2.1143 | 2.1161 | 2.1089 | 2.1089 | 64400.0 |
| 2006-06-16 08:00:00 | AAPL | Stock | 2.1232 | 2.1232 | 2.115 | 2.1211 | 37800.0 |
| 2006-06-16 08:05:00 | AAPL | Stock | 2.1143 | 2.1143 | 2.1143 | 2.1143 | 2800.0 |
| 2006-06-16 08:10:00 | AAPL | Stock | 2.1089 | 2.1107 | 2.1071 | 2.1093 | 150892.0 |
| 2006-06-16 08:15:00 | AAPL | Stock | 2.1089 | 2.1096 | 2.1089 | 2.1089 | 39200.0 |
| 2006-06-16 08:20:00 | AAPL | Stock | 2.1086 | 2.1089 | 2.1075 | 2.1089 | 53200.0 |
| 2006-06-16 08:25:00 | AAPL | Stock | 2.1089 | 2.1143 | 2.1089 | 2.1143 | 103600.0 |
| 2006-06-16 08:30:00 | AAPL | Stock | 2.1107 | 2.1143 | 2.1089 | 2.1089 | 156800.0 |
| 2006-06-16 08:35:00 | AAPL | Stock | 2.1089 | 2.1093 | 2.1089 | 2.1089 | 81200.0 |
| 2006-06-16 08:40:00 | AAPL | Stock | 2.1089 | 2.1093 | 2.1071 | 2.1071 | 194964.0 |
| 2006-06-16 08:45:00 | AAPL | Stock | 2.1071 | 2.1071 | 2.0936 | 2.0936 | 676200.0 |
| 2006-06-16 08:50:00 | AAPL | Stock | 2.0939 | 2.1 | 2.0939 | 2.0982 | 617456.0 |
| 2006-06-16 08:55:00 | AAPL | Stock | 2.0989 | 2.1 | 2.0946 | 2.1 | 604940.0 |
| 2006-06-16 09:00:00 | AAPL | Stock | 2.1018 | 2.105 | 2.0954 | 2.0982 | 229600.0 |
| 2006-06-16 09:05:00 | AAPL | Stock | 2.1 | 2.1 | 2.0946 | 2.0946 | 452956.0 |
| 2006-06-16 09:10:00 | AAPL | Stock | 2.095 | 2.0964 | 2.0918 | 2.0964 | 614992.0 |
| 2006-06-16 09:15:00 | AAPL | Stock | 2.0957 | 2.0968 | 2.0936 | 2.0946 | 238000.0 |
| 2006-06-16 09:20:00 | AAPL | Stock | 2.0946 | 2.0964 | 2.0896 | 2.0943 | 602000.0 |
| 2006-06-16 09:25:00 | AAPL | Stock | 2.0946 | 2.1089 | 2.0946 | 2.1064 | 1568084.0 |
| 2006-06-16 09:30:00 | AAPL | Stock | 2.1055 | 2.1139 | 2.0929 | 2.1 | 94201464.0 |
| 2006-06-16 09:35:00 | AAPL | Stock | 2.0989 | 2.105 | 2.0896 | 2.1014 | 19368468.0 |
| 2006-06-16 09:40:00 | AAPL | Stock | 2.1025 | 2.1114 | 2.1018 | 2.1021 | 20763120.0 |
| 2006-06-16 09:45:00 | AAPL | Stock | 2.1021 | 2.1069 | 2.0864 | 2.0932 | 27691888.0 |
| 2006-06-16 09:50:00 | AAPL | Stock | 2.0932 | 2.105 | 2.0929 | 2.0939 | 19767076.0 |
| 2006-06-16 09:55:00 | AAPL | Stock | 2.0939 | 2.1004 | 2.0882 | 2.0925 | 12776400.0 |
| 2006-06-16 10:00:00 | AAPL | Stock | 2.0925 | 2.0975 | 2.0871 | 2.0896 | 17486980.0 |
| 2006-06-16 10:05:00 | AAPL | Stock | 2.0904 | 2.0925 | 2.0818 | 2.0836 | 19766852.0 |
| 2006-06-16 10:10:00 | AAPL | Stock | 2.0832 | 2.0868 | 2.0793 | 2.0851 | 14046032.0 |
| 2006-06-16 10:15:00 | AAPL | Stock | 2.085 | 2.0882 | 2.0746 | 2.075 | 14571424.0 |
| 2006-06-16 10:20:00 | AAPL | Stock | 2.075 | 2.0807 | 2.0743 | 2.08 | 13195308.0 |
| 2006-06-16 10:25:00 | AAPL | Stock | 2.08 | 2.08 | 2.0718 | 2.0718 | 13688332.0 |
| 2006-06-16 10:30:00 | AAPL | Stock | 2.0721 | 2.0771 | 2.0682 | 2.0682 | 16721376.0 |
| 2006-06-16 10:35:00 | AAPL | Stock | 2.0686 | 2.08 | 2.0675 | 2.0786 | 14748636.0 |
| 2006-06-16 10:40:00 | AAPL | Stock | 2.0786 | 2.0829 | 2.0761 | 2.0764 | 13162996.0 |
| 2006-06-16 10:45:00 | AAPL | Stock | 2.0764 | 2.0951 | 2.0704 | 2.0736 | 10131716.0 |
| 2006-06-16 10:50:00 | AAPL | Stock | 2.0736 | 2.0807 | 2.0729 | 2.0786 | 11973696.0 |
| 2006-06-16 10:55:00 | AAPL | Stock | 2.0786 | 2.0786 | 2.0711 | 2.0761 | 8626660.0 |
| 2006-06-16 11:00:00 | AAPL | Stock | 2.0757 | 2.0825 | 2.0757 | 2.0768 | 11528664.0 |
| 2006-06-16 11:05:00 | AAPL | Stock | 2.0771 | 2.0818 | 2.0761 | 2.0771 | 8670312.0 |
| 2006-06-16 11:10:00 | AAPL | Stock | 2.0775 | 2.0775 | 2.0739 | 2.0753 | 5518632.0 |
| 2006-06-16 11:15:00 | AAPL | Stock | 2.075 | 2.075 | 2.0704 | 2.0743 | 9088800.0 |
| 2006-06-16 11:20:00 | AAPL | Stock | 2.0736 | 2.0764 | 2.0693 | 2.07 | 8620332.0 |
| 2006-06-16 11:25:00 | AAPL | Stock | 2.07 | 2.075 | 2.0682 | 2.0736 | 5788468.0 |
| 2006-06-16 11:30:00 | AAPL | Stock | 2.0736 | 2.0746 | 2.0707 | 2.0725 | 5884396.0 |
| 2006-06-16 11:35:00 | AAPL | Stock | 2.0725 | 2.0804 | 2.0725 | 2.0786 | 5707100.0 |
| 2006-06-16 11:40:00 | AAPL | Stock | 2.0786 | 2.0786 | 2.0746 | 2.0764 | 4712148.0 |
| 2006-06-16 11:45:00 | AAPL | Stock | 2.0768 | 2.0814 | 2.0761 | 2.0793 | 6483820.0 |
| 2006-06-16 11:50:00 | AAPL | Stock | 2.0782 | 2.0814 | 2.0764 | 2.08 | 5816272.0 |
> showing 50 of 228,619 rows — these rows as CSV