PREVIEW / stock_5min / 2007-05-15
file: by_date/stock_5min/2007/2007-05-15.parquet size: 4.0 MB rows: 288,103 symbols: 2,757
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-05-15 09:30:00 | AAPL | Stock | 3.9132 | 3.9161 | 3.8929 | 3.8964 | 16181004.0 |
| 2007-05-15 09:35:00 | AAPL | Stock | 3.8964 | 3.8982 | 3.8868 | 3.8929 | 17374952.0 |
| 2007-05-15 09:40:00 | AAPL | Stock | 3.8932 | 3.905 | 3.8929 | 3.9032 | 12716200.0 |
| 2007-05-15 09:45:00 | AAPL | Stock | 3.9021 | 3.9082 | 3.8946 | 3.9039 | 15192660.0 |
| 2007-05-15 09:50:00 | AAPL | Stock | 3.9036 | 3.9068 | 3.8993 | 3.9025 | 11727072.0 |
| 2007-05-15 09:55:00 | AAPL | Stock | 3.9025 | 3.92 | 3.8961 | 3.9171 | 15540252.0 |
| 2007-05-15 10:00:00 | AAPL | Stock | 3.9168 | 3.93 | 3.9168 | 3.924 | 28234668.0 |
| 2007-05-15 10:05:00 | AAPL | Stock | 3.925 | 3.9325 | 3.9186 | 3.9268 | 19908924.0 |
| 2007-05-15 10:10:00 | AAPL | Stock | 3.9268 | 3.9357 | 3.9232 | 3.9243 | 16476376.0 |
| 2007-05-15 10:15:00 | AAPL | Stock | 3.9246 | 3.9339 | 3.9218 | 3.9321 | 12136320.0 |
| 2007-05-15 10:20:00 | AAPL | Stock | 3.9318 | 3.9321 | 3.9196 | 3.9279 | 12840744.0 |
| 2007-05-15 10:25:00 | AAPL | Stock | 3.9282 | 3.9282 | 3.9232 | 3.9243 | 7949060.0 |
| 2007-05-15 10:30:00 | AAPL | Stock | 3.925 | 3.9321 | 3.9232 | 3.9307 | 12207916.0 |
| 2007-05-15 10:35:00 | AAPL | Stock | 3.9304 | 3.9321 | 3.92 | 3.9204 | 10462956.0 |
| 2007-05-15 10:40:00 | AAPL | Stock | 3.9207 | 3.9254 | 3.92 | 3.9229 | 9314844.0 |
| 2007-05-15 10:45:00 | AAPL | Stock | 3.9225 | 3.9304 | 3.9207 | 3.9296 | 7534772.0 |
| 2007-05-15 10:50:00 | AAPL | Stock | 3.9296 | 3.935 | 3.9271 | 3.9293 | 9361212.0 |
| 2007-05-15 10:55:00 | AAPL | Stock | 3.9293 | 3.9318 | 3.9143 | 3.9189 | 12456276.0 |
| 2007-05-15 11:00:00 | AAPL | Stock | 3.9189 | 3.9204 | 3.9111 | 3.9189 | 11479132.0 |
| 2007-05-15 11:05:00 | AAPL | Stock | 3.9193 | 3.9204 | 3.9118 | 3.9129 | 7064260.0 |
| 2007-05-15 11:10:00 | AAPL | Stock | 3.9129 | 3.915 | 3.9079 | 3.9114 | 9005836.0 |
| 2007-05-15 11:15:00 | AAPL | Stock | 3.9114 | 3.92 | 3.9111 | 3.9154 | 5240200.0 |
| 2007-05-15 11:20:00 | AAPL | Stock | 3.9161 | 3.9193 | 3.9136 | 3.9179 | 3270932.0 |
| 2007-05-15 11:25:00 | AAPL | Stock | 3.9175 | 3.9193 | 3.9129 | 3.9182 | 6224624.0 |
| 2007-05-15 11:30:00 | AAPL | Stock | 3.9179 | 3.9182 | 3.9014 | 3.9014 | 14080024.0 |
| 2007-05-15 11:35:00 | AAPL | Stock | 3.9014 | 3.9143 | 3.8957 | 3.9136 | 21069608.0 |
| 2007-05-15 11:40:00 | AAPL | Stock | 3.9139 | 3.9171 | 3.9089 | 3.9146 | 9242016.0 |
| 2007-05-15 11:45:00 | AAPL | Stock | 3.915 | 3.9193 | 3.9082 | 3.9193 | 7639800.0 |
| 2007-05-15 11:50:00 | AAPL | Stock | 3.9196 | 3.9243 | 3.9168 | 3.9189 | 7609700.0 |
| 2007-05-15 11:55:00 | AAPL | Stock | 3.9189 | 3.9196 | 3.9157 | 3.9161 | 2604644.0 |
| 2007-05-15 12:00:00 | AAPL | Stock | 3.9168 | 3.9211 | 3.9161 | 3.9182 | 3059224.0 |
| 2007-05-15 12:05:00 | AAPL | Stock | 3.9179 | 3.9186 | 3.9111 | 3.9157 | 2696484.0 |
| 2007-05-15 12:10:00 | AAPL | Stock | 3.916 | 3.9211 | 3.915 | 3.9186 | 5899488.0 |
| 2007-05-15 12:15:00 | AAPL | Stock | 3.9189 | 3.9243 | 3.9164 | 3.9166 | 10639160.0 |
| 2007-05-15 12:20:00 | AAPL | Stock | 3.9168 | 3.9171 | 3.9089 | 3.9139 | 6066284.0 |
| 2007-05-15 12:25:00 | AAPL | Stock | 3.9143 | 3.9146 | 3.9121 | 3.9139 | 2728096.0 |
| 2007-05-15 12:30:00 | AAPL | Stock | 3.9137 | 3.9139 | 3.9111 | 3.9124 | 3339448.0 |
| 2007-05-15 12:35:00 | AAPL | Stock | 3.9125 | 3.9125 | 3.9082 | 3.9089 | 5264140.0 |
| 2007-05-15 12:40:00 | AAPL | Stock | 3.9089 | 3.9139 | 3.9083 | 3.9114 | 6168988.0 |
| 2007-05-15 12:45:00 | AAPL | Stock | 3.9125 | 3.9125 | 3.9025 | 3.9041 | 6514760.0 |
| 2007-05-15 12:50:00 | AAPL | Stock | 3.9036 | 3.9054 | 3.9 | 3.9 | 5622148.0 |
| 2007-05-15 12:55:00 | AAPL | Stock | 3.9007 | 3.9014 | 3.8925 | 3.8929 | 12891844.0 |
| 2007-05-15 13:00:00 | AAPL | Stock | 3.8929 | 3.8996 | 3.8911 | 3.8929 | 9744840.0 |
| 2007-05-15 13:05:00 | AAPL | Stock | 3.8929 | 3.8961 | 3.8882 | 3.8946 | 9554580.0 |
| 2007-05-15 13:10:00 | AAPL | Stock | 3.8946 | 3.9004 | 3.8932 | 3.8979 | 5306784.0 |
| 2007-05-15 13:15:00 | AAPL | Stock | 3.8979 | 3.9 | 3.895 | 3.895 | 3928652.0 |
| 2007-05-15 13:20:00 | AAPL | Stock | 3.895 | 3.8975 | 3.8932 | 3.8936 | 3698296.0 |
| 2007-05-15 13:25:00 | AAPL | Stock | 3.8936 | 3.8957 | 3.8907 | 3.8932 | 3214148.0 |
| 2007-05-15 13:30:00 | AAPL | Stock | 3.8932 | 3.8975 | 3.8904 | 3.8925 | 4775204.0 |
| 2007-05-15 13:35:00 | AAPL | Stock | 3.8929 | 3.8946 | 3.8907 | 3.8914 | 4089904.0 |
> showing 50 of 288,103 rows — these rows as CSV