PREVIEW / stock_5min / 2008-12-31
file: by_date/stock_5min/2008/2008-12-31.parquet size: 4.6 MB rows: 322,435 symbols: 3,409
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 |
|---|---|---|---|---|---|---|---|
| 2008-12-31 07:40:00 | AAPL | Stock | 3.1068 | 3.1071 | 3.1068 | 3.1071 | 11200.0 |
| 2008-12-31 07:45:00 | AAPL | Stock | 3.1143 | 3.1143 | 3.1143 | 3.1143 | 8400.0 |
| 2008-12-31 07:50:00 | AAPL | Stock | 3.1025 | 3.1025 | 3.1025 | 3.1025 | 14000.0 |
| 2008-12-31 07:55:00 | AAPL | Stock | 3.0893 | 3.0893 | 3.0893 | 3.0893 | 14000.0 |
| 2008-12-31 08:00:00 | AAPL | Stock | 3.0832 | 3.0832 | 3.0789 | 3.0811 | 29540.0 |
| 2008-12-31 08:05:00 | AAPL | Stock | 3.0868 | 3.0875 | 3.0868 | 3.0875 | 30380.0 |
| 2008-12-31 08:10:00 | AAPL | Stock | 3.0875 | 3.0968 | 3.0861 | 3.0893 | 68292.0 |
| 2008-12-31 08:15:00 | AAPL | Stock | 3.0882 | 3.095 | 3.0882 | 3.0893 | 71568.0 |
| 2008-12-31 08:20:00 | AAPL | Stock | 3.0882 | 3.0882 | 3.0882 | 3.0882 | 2828.0 |
| 2008-12-31 08:25:00 | AAPL | Stock | 3.0886 | 3.0886 | 3.0839 | 3.0857 | 146160.0 |
| 2008-12-31 08:30:00 | AAPL | Stock | 3.0857 | 3.0911 | 3.0854 | 3.0911 | 99120.0 |
| 2008-12-31 08:35:00 | AAPL | Stock | 3.0893 | 3.0911 | 3.0757 | 3.0821 | 528080.0 |
| 2008-12-31 08:40:00 | AAPL | Stock | 3.0868 | 3.0868 | 3.0821 | 3.0857 | 35000.0 |
| 2008-12-31 08:45:00 | AAPL | Stock | 3.0854 | 3.0854 | 3.0718 | 3.0732 | 67200.0 |
| 2008-12-31 08:50:00 | AAPL | Stock | 3.0782 | 3.0821 | 3.0679 | 3.0679 | 215180.0 |
| 2008-12-31 08:55:00 | AAPL | Stock | 3.0729 | 3.075 | 3.0714 | 3.075 | 51772.0 |
| 2008-12-31 09:00:00 | AAPL | Stock | 3.075 | 3.0779 | 3.0714 | 3.0771 | 187264.0 |
| 2008-12-31 09:05:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0743 | 3.0779 | 211372.0 |
| 2008-12-31 09:10:00 | AAPL | Stock | 3.0779 | 3.0804 | 3.0768 | 3.0768 | 128800.0 |
| 2008-12-31 09:20:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.075 | 3.075 | 5600.0 |
| 2008-12-31 09:25:00 | AAPL | Stock | 3.0768 | 3.0768 | 3.0679 | 3.0679 | 232568.0 |
| 2008-12-31 09:30:00 | AAPL | Stock | 3.0657 | 3.1025 | 3.0632 | 3.0986 | 14702548.0 |
| 2008-12-31 09:35:00 | AAPL | Stock | 3.0986 | 3.1104 | 3.0932 | 3.0957 | 11752160.0 |
| 2008-12-31 09:40:00 | AAPL | Stock | 3.095 | 3.1154 | 3.095 | 3.1082 | 12310032.0 |
| 2008-12-31 09:45:00 | AAPL | Stock | 3.1082 | 3.1114 | 3.1011 | 3.1071 | 9462180.0 |
| 2008-12-31 09:50:00 | AAPL | Stock | 3.1079 | 3.1104 | 3.0964 | 3.0989 | 8022420.0 |
| 2008-12-31 09:55:00 | AAPL | Stock | 3.0989 | 3.1025 | 3.0954 | 3.0993 | 7261380.0 |
| 2008-12-31 10:00:00 | AAPL | Stock | 3.0989 | 3.1064 | 3.0932 | 3.0939 | 9047780.0 |
| 2008-12-31 10:05:00 | AAPL | Stock | 3.0934 | 3.0979 | 3.085 | 3.0857 | 10800468.0 |
| 2008-12-31 10:10:00 | AAPL | Stock | 3.0854 | 3.0889 | 3.08 | 3.085 | 9501828.0 |
| 2008-12-31 10:15:00 | AAPL | Stock | 3.0857 | 3.0943 | 3.085 | 3.092 | 6510896.0 |
| 2008-12-31 10:20:00 | AAPL | Stock | 3.0925 | 3.0957 | 3.0875 | 3.0914 | 4941132.0 |
| 2008-12-31 10:25:00 | AAPL | Stock | 3.0925 | 3.0925 | 3.0868 | 3.0896 | 5616772.0 |
| 2008-12-31 10:30:00 | AAPL | Stock | 3.0893 | 3.0946 | 3.0871 | 3.0871 | 4684316.0 |
| 2008-12-31 10:35:00 | AAPL | Stock | 3.0871 | 3.09 | 3.0829 | 3.0857 | 6926724.0 |
| 2008-12-31 10:40:00 | AAPL | Stock | 3.0857 | 3.0914 | 3.0857 | 3.0886 | 4521608.0 |
| 2008-12-31 10:45:00 | AAPL | Stock | 3.0886 | 3.0975 | 3.0868 | 3.0925 | 6893712.0 |
| 2008-12-31 10:50:00 | AAPL | Stock | 3.0925 | 3.0975 | 3.0921 | 3.0964 | 4138820.0 |
| 2008-12-31 10:55:00 | AAPL | Stock | 3.0964 | 3.1011 | 3.0932 | 3.095 | 5206264.0 |
| 2008-12-31 11:00:00 | AAPL | Stock | 3.095 | 3.0954 | 3.09 | 3.0921 | 4099704.0 |
| 2008-12-31 11:05:00 | AAPL | Stock | 3.0918 | 3.0961 | 3.0911 | 3.0957 | 2976960.0 |
| 2008-12-31 11:10:00 | AAPL | Stock | 3.0954 | 3.0961 | 3.09 | 3.0957 | 2992192.0 |
| 2008-12-31 11:15:00 | AAPL | Stock | 3.095 | 3.1 | 3.095 | 3.0982 | 3504984.0 |
| 2008-12-31 11:20:00 | AAPL | Stock | 3.0982 | 3.1068 | 3.0971 | 3.1057 | 6002808.0 |
| 2008-12-31 11:25:00 | AAPL | Stock | 3.1061 | 3.1111 | 3.1025 | 3.1096 | 7929208.0 |
| 2008-12-31 11:30:00 | AAPL | Stock | 3.1096 | 3.1132 | 3.1068 | 3.1114 | 7973140.0 |
| 2008-12-31 11:35:00 | AAPL | Stock | 3.1116 | 3.1125 | 3.11 | 3.1111 | 5056744.0 |
| 2008-12-31 11:40:00 | AAPL | Stock | 3.1111 | 3.1121 | 3.1093 | 3.1107 | 6525652.0 |
| 2008-12-31 11:45:00 | AAPL | Stock | 3.1111 | 3.1171 | 3.11 | 3.1114 | 9498216.0 |
| 2008-12-31 11:50:00 | AAPL | Stock | 3.1111 | 3.1136 | 3.1093 | 3.1129 | 4938696.0 |
> showing 50 of 322,435 rows — these rows as CSV