PREVIEW / stock_5min / 2006-10-25
file: by_date/stock_5min/2006/2006-10-25.parquet size: 3.2 MB rows: 232,011 symbols: 2,398
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-10-25 08:00:00 | AAPL | Stock | 2.9068 | 2.9068 | 2.9068 | 2.9068 | 11200.0 |
| 2006-10-25 08:05:00 | AAPL | Stock | 2.9071 | 2.9071 | 2.9071 | 2.9071 | 14000.0 |
| 2006-10-25 08:10:00 | AAPL | Stock | 2.9089 | 2.9121 | 2.9089 | 2.9089 | 84000.0 |
| 2006-10-25 08:15:00 | AAPL | Stock | 2.9089 | 2.9096 | 2.9089 | 2.9096 | 109200.0 |
| 2006-10-25 08:20:00 | AAPL | Stock | 2.9096 | 2.9096 | 2.9054 | 2.9068 | 33600.0 |
| 2006-10-25 08:30:00 | AAPL | Stock | 2.9071 | 2.9071 | 2.9071 | 2.9071 | 14000.0 |
| 2006-10-25 08:35:00 | AAPL | Stock | 2.9089 | 2.9089 | 2.9068 | 2.9068 | 194040.0 |
| 2006-10-25 08:40:00 | AAPL | Stock | 2.9071 | 2.9071 | 2.9071 | 2.9071 | 262416.0 |
| 2006-10-25 08:45:00 | AAPL | Stock | 2.9071 | 2.9071 | 2.9071 | 2.9071 | 11620.0 |
| 2006-10-25 08:50:00 | AAPL | Stock | 2.9071 | 2.9089 | 2.9071 | 2.9086 | 51184.0 |
| 2006-10-25 08:55:00 | AAPL | Stock | 2.9089 | 2.9107 | 2.9089 | 2.9107 | 109032.0 |
| 2006-10-25 09:00:00 | AAPL | Stock | 2.9082 | 2.9082 | 2.9071 | 2.9071 | 151200.0 |
| 2006-10-25 09:05:00 | AAPL | Stock | 2.9082 | 2.9082 | 2.9071 | 2.9082 | 77280.0 |
| 2006-10-25 09:10:00 | AAPL | Stock | 2.9071 | 2.9082 | 2.9071 | 2.9082 | 70000.0 |
| 2006-10-25 09:15:00 | AAPL | Stock | 2.9082 | 2.9082 | 2.9082 | 2.9082 | 2800.0 |
| 2006-10-25 09:20:00 | AAPL | Stock | 2.9071 | 2.9089 | 2.9071 | 2.9071 | 45976.0 |
| 2006-10-25 09:25:00 | AAPL | Stock | 2.9068 | 2.9068 | 2.9032 | 2.9054 | 322000.0 |
| 2006-10-25 09:30:00 | AAPL | Stock | 2.9054 | 2.9107 | 2.8964 | 2.9089 | 15676360.0 |
| 2006-10-25 09:35:00 | AAPL | Stock | 2.9089 | 2.9193 | 2.9079 | 2.9171 | 16552844.0 |
| 2006-10-25 09:40:00 | AAPL | Stock | 2.9179 | 2.9179 | 2.9107 | 2.9132 | 7488068.0 |
| 2006-10-25 09:45:00 | AAPL | Stock | 2.9132 | 2.9168 | 2.9079 | 2.9125 | 8638420.0 |
| 2006-10-25 09:50:00 | AAPL | Stock | 2.9125 | 2.9161 | 2.9116 | 2.9154 | 5932724.0 |
| 2006-10-25 09:55:00 | AAPL | Stock | 2.9154 | 2.9161 | 2.9093 | 2.9107 | 5658996.0 |
| 2006-10-25 10:00:00 | AAPL | Stock | 2.9104 | 2.9136 | 2.9018 | 2.9029 | 9727592.0 |
| 2006-10-25 10:05:00 | AAPL | Stock | 2.9025 | 2.9125 | 2.9021 | 2.9118 | 6037304.0 |
| 2006-10-25 10:10:00 | AAPL | Stock | 2.9114 | 2.9143 | 2.9089 | 2.9121 | 11324012.0 |
| 2006-10-25 10:15:00 | AAPL | Stock | 2.9118 | 2.9246 | 2.9118 | 2.9229 | 11806872.0 |
| 2006-10-25 10:20:00 | AAPL | Stock | 2.9229 | 2.9236 | 2.9157 | 2.9218 | 6662656.0 |
| 2006-10-25 10:25:00 | AAPL | Stock | 2.9214 | 2.9286 | 2.9196 | 2.9196 | 10455844.0 |
| 2006-10-25 10:30:00 | AAPL | Stock | 2.92 | 2.9232 | 2.9125 | 2.9154 | 7842576.0 |
| 2006-10-25 10:35:00 | AAPL | Stock | 2.9157 | 2.9214 | 2.9136 | 2.9157 | 4138876.0 |
| 2006-10-25 10:40:00 | AAPL | Stock | 2.9154 | 2.9196 | 2.9107 | 2.9125 | 9900912.0 |
| 2006-10-25 10:45:00 | AAPL | Stock | 2.9129 | 2.9154 | 2.9121 | 2.9136 | 4749220.0 |
| 2006-10-25 10:50:00 | AAPL | Stock | 2.9129 | 2.9143 | 2.9111 | 2.9125 | 3212692.0 |
| 2006-10-25 10:55:00 | AAPL | Stock | 2.9129 | 2.9143 | 2.9111 | 2.9114 | 2496984.0 |
| 2006-10-25 11:00:00 | AAPL | Stock | 2.9114 | 2.9121 | 2.9096 | 2.9118 | 3985716.0 |
| 2006-10-25 11:05:00 | AAPL | Stock | 2.9114 | 2.9171 | 2.9114 | 2.915 | 4452840.0 |
| 2006-10-25 11:10:00 | AAPL | Stock | 2.9153 | 2.9161 | 2.9107 | 2.9111 | 2564632.0 |
| 2006-10-25 11:15:00 | AAPL | Stock | 2.9111 | 2.9161 | 2.9107 | 2.9132 | 4488372.0 |
| 2006-10-25 11:20:00 | AAPL | Stock | 2.9132 | 2.9175 | 2.9132 | 2.9154 | 2559424.0 |
| 2006-10-25 11:25:00 | AAPL | Stock | 2.915 | 2.9189 | 2.9143 | 2.9171 | 3848208.0 |
| 2006-10-25 11:30:00 | AAPL | Stock | 2.9174 | 2.9207 | 2.9161 | 2.9189 | 3539200.0 |
| 2006-10-25 11:35:00 | AAPL | Stock | 2.9193 | 2.9236 | 2.9186 | 2.9211 | 4737152.0 |
| 2006-10-25 11:40:00 | AAPL | Stock | 2.9207 | 2.9229 | 2.9207 | 2.9207 | 3977540.0 |
| 2006-10-25 11:45:00 | AAPL | Stock | 2.9207 | 2.9211 | 2.9172 | 2.9175 | 3962168.0 |
| 2006-10-25 11:50:00 | AAPL | Stock | 2.9175 | 2.9193 | 2.9157 | 2.9174 | 2446780.0 |
| 2006-10-25 11:55:00 | AAPL | Stock | 2.9175 | 2.9207 | 2.9164 | 2.9171 | 2573760.0 |
| 2006-10-25 12:00:00 | AAPL | Stock | 2.9171 | 2.9189 | 2.9161 | 2.9161 | 1849372.0 |
| 2006-10-25 12:05:00 | AAPL | Stock | 2.9164 | 2.9186 | 2.9143 | 2.915 | 2480716.0 |
| 2006-10-25 12:10:00 | AAPL | Stock | 2.9154 | 2.9171 | 2.915 | 2.9164 | 1422792.0 |
> showing 50 of 232,011 rows — these rows as CSV