PREVIEW / stock_5min / 2007-09-13
file: by_date/stock_5min/2007/2007-09-13.parquet size: 3.9 MB rows: 287,376 symbols: 3,092
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-09-13 09:30:00 | AAPL | Stock | 4.9582 | 4.9589 | 4.9339 | 4.9371 | 23610412.0 |
| 2007-09-13 09:35:00 | AAPL | Stock | 4.9361 | 4.9439 | 4.9196 | 4.9436 | 16621920.0 |
| 2007-09-13 09:40:00 | AAPL | Stock | 4.9436 | 4.9439 | 4.9246 | 4.9282 | 9989252.0 |
| 2007-09-13 09:45:00 | AAPL | Stock | 4.9275 | 4.9393 | 4.9189 | 4.9375 | 15824732.0 |
| 2007-09-13 09:50:00 | AAPL | Stock | 4.9375 | 4.9518 | 4.9368 | 4.9412 | 16160732.0 |
| 2007-09-13 09:55:00 | AAPL | Stock | 4.9414 | 4.9643 | 4.9409 | 4.9504 | 21225792.0 |
| 2007-09-13 10:00:00 | AAPL | Stock | 4.9511 | 4.9543 | 4.9325 | 4.9379 | 15766212.0 |
| 2007-09-13 10:05:00 | AAPL | Stock | 4.9387 | 4.9432 | 4.9321 | 4.9346 | 12330332.0 |
| 2007-09-13 10:10:00 | AAPL | Stock | 4.9346 | 4.9375 | 4.92 | 4.9243 | 14869148.0 |
| 2007-09-13 10:15:00 | AAPL | Stock | 4.9239 | 4.9404 | 4.9239 | 4.9379 | 10618356.0 |
| 2007-09-13 10:20:00 | AAPL | Stock | 4.9379 | 4.9386 | 4.9229 | 4.9311 | 11120032.0 |
| 2007-09-13 10:25:00 | AAPL | Stock | 4.9311 | 4.9336 | 4.9268 | 4.9304 | 7468244.0 |
| 2007-09-13 10:30:00 | AAPL | Stock | 4.93 | 4.9329 | 4.9082 | 4.9196 | 18316816.0 |
| 2007-09-13 10:35:00 | AAPL | Stock | 4.919 | 4.9236 | 4.9121 | 4.9143 | 8017016.0 |
| 2007-09-13 10:40:00 | AAPL | Stock | 4.9143 | 4.9154 | 4.9043 | 4.9093 | 10513300.0 |
| 2007-09-13 10:45:00 | AAPL | Stock | 4.9093 | 4.9189 | 4.9068 | 4.9089 | 7309876.0 |
| 2007-09-13 10:50:00 | AAPL | Stock | 4.9095 | 4.9193 | 4.9075 | 4.9161 | 4774196.0 |
| 2007-09-13 10:55:00 | AAPL | Stock | 4.9154 | 4.9204 | 4.9118 | 4.9167 | 5903856.0 |
| 2007-09-13 11:00:00 | AAPL | Stock | 4.9168 | 4.9279 | 4.9161 | 4.9211 | 8366736.0 |
| 2007-09-13 11:05:00 | AAPL | Stock | 4.9211 | 4.9221 | 4.9136 | 4.9182 | 5472600.0 |
| 2007-09-13 11:10:00 | AAPL | Stock | 4.9182 | 4.9243 | 4.9164 | 4.9196 | 3174724.0 |
| 2007-09-13 11:15:00 | AAPL | Stock | 4.92 | 4.9286 | 4.92 | 4.9214 | 5714268.0 |
| 2007-09-13 11:20:00 | AAPL | Stock | 4.9216 | 4.9329 | 4.9207 | 4.9321 | 6489616.0 |
| 2007-09-13 11:25:00 | AAPL | Stock | 4.9318 | 4.9384 | 4.9299 | 4.9318 | 8077552.0 |
| 2007-09-13 11:30:00 | AAPL | Stock | 4.9318 | 4.9329 | 4.9214 | 4.9225 | 5382832.0 |
| 2007-09-13 11:35:00 | AAPL | Stock | 4.9224 | 4.9268 | 4.9182 | 4.92 | 5183444.0 |
| 2007-09-13 11:40:00 | AAPL | Stock | 4.92 | 4.9268 | 4.9171 | 4.9204 | 5985700.0 |
| 2007-09-13 11:45:00 | AAPL | Stock | 4.9204 | 4.9268 | 4.9179 | 4.9193 | 3381784.0 |
| 2007-09-13 11:50:00 | AAPL | Stock | 4.9196 | 4.9218 | 4.9171 | 4.9179 | 2947140.0 |
| 2007-09-13 11:55:00 | AAPL | Stock | 4.9181 | 4.9225 | 4.9129 | 4.9193 | 4025616.0 |
| 2007-09-13 12:00:00 | AAPL | Stock | 4.9193 | 4.9196 | 4.9121 | 4.9157 | 3725624.0 |
| 2007-09-13 12:05:00 | AAPL | Stock | 4.9161 | 4.9214 | 4.9132 | 4.915 | 3721592.0 |
| 2007-09-13 12:10:00 | AAPL | Stock | 4.915 | 4.9175 | 4.9118 | 4.913 | 3517332.0 |
| 2007-09-13 12:15:00 | AAPL | Stock | 4.9136 | 4.9204 | 4.9132 | 4.9193 | 3970288.0 |
| 2007-09-13 12:20:00 | AAPL | Stock | 4.9193 | 4.9268 | 4.9186 | 4.9225 | 4814180.0 |
| 2007-09-13 12:25:00 | AAPL | Stock | 4.9221 | 4.9243 | 4.9189 | 4.9204 | 3563000.0 |
| 2007-09-13 12:30:00 | AAPL | Stock | 4.92 | 4.9239 | 4.9168 | 4.9193 | 3780308.0 |
| 2007-09-13 12:35:00 | AAPL | Stock | 4.9193 | 4.9214 | 4.9168 | 4.9171 | 2280124.0 |
| 2007-09-13 12:40:00 | AAPL | Stock | 4.9171 | 4.9196 | 4.9143 | 4.9154 | 2726892.0 |
| 2007-09-13 12:45:00 | AAPL | Stock | 4.9146 | 4.9154 | 4.9109 | 4.9114 | 3047156.0 |
| 2007-09-13 12:50:00 | AAPL | Stock | 4.9111 | 4.9139 | 4.9071 | 4.9071 | 4168612.0 |
| 2007-09-13 12:55:00 | AAPL | Stock | 4.9075 | 4.9142 | 4.9054 | 4.9132 | 4278624.0 |
| 2007-09-13 13:00:00 | AAPL | Stock | 4.9129 | 4.9196 | 4.9093 | 4.9193 | 4638228.0 |
| 2007-09-13 13:05:00 | AAPL | Stock | 4.9193 | 4.9214 | 4.913 | 4.9161 | 4616248.0 |
| 2007-09-13 13:10:00 | AAPL | Stock | 4.9164 | 4.9186 | 4.91 | 4.91 | 2718520.0 |
| 2007-09-13 13:15:00 | AAPL | Stock | 4.9107 | 4.9193 | 4.9096 | 4.9186 | 4029144.0 |
| 2007-09-13 13:20:00 | AAPL | Stock | 4.9184 | 4.9246 | 4.9168 | 4.9207 | 6353060.0 |
| 2007-09-13 13:25:00 | AAPL | Stock | 4.9211 | 4.9214 | 4.9057 | 4.9071 | 8407224.0 |
| 2007-09-13 13:30:00 | AAPL | Stock | 4.9071 | 4.9129 | 4.9061 | 4.9104 | 5257280.0 |
| 2007-09-13 13:35:00 | AAPL | Stock | 4.9106 | 4.9125 | 4.9025 | 4.9067 | 6953240.0 |
> showing 50 of 287,376 rows — these rows as CSV