PREVIEW / stock_5min / 2010-05-19
file: by_date/stock_5min/2010/2010-05-19.parquet size: 5.0 MB rows: 342,302 symbols: 3,475
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-19 04:20:00 | AAPL | Stock | 8.9125 | 8.9125 | 8.9125 | 8.9125 | 2800.0 |
| 2010-05-19 04:30:00 | AAPL | Stock | 8.86 | 8.86 | 8.86 | 8.86 | 6860.0 |
| 2010-05-19 05:10:00 | AAPL | Stock | 8.8814 | 8.8814 | 8.8814 | 8.8814 | 2800.0 |
| 2010-05-19 05:50:00 | AAPL | Stock | 8.9143 | 8.9143 | 8.9143 | 8.9143 | 12600.0 |
| 2010-05-19 06:15:00 | AAPL | Stock | 8.9107 | 8.9107 | 8.9107 | 8.9107 | 5600.0 |
| 2010-05-19 06:40:00 | AAPL | Stock | 8.8771 | 8.8771 | 8.8771 | 8.8771 | 5600.0 |
| 2010-05-19 06:45:00 | AAPL | Stock | 8.8771 | 8.9107 | 8.8768 | 8.905 | 36120.0 |
| 2010-05-19 06:50:00 | AAPL | Stock | 8.905 | 8.905 | 8.905 | 8.905 | 2800.0 |
| 2010-05-19 06:55:00 | AAPL | Stock | 8.905 | 8.905 | 8.905 | 8.905 | 7000.0 |
| 2010-05-19 07:00:00 | AAPL | Stock | 8.9036 | 8.9143 | 8.8946 | 8.9143 | 148540.0 |
| 2010-05-19 07:05:00 | AAPL | Stock | 8.9143 | 8.9143 | 8.91 | 8.91 | 9660.0 |
| 2010-05-19 07:10:00 | AAPL | Stock | 8.93 | 8.93 | 8.93 | 8.93 | 8400.0 |
| 2010-05-19 07:15:00 | AAPL | Stock | 8.9279 | 8.9286 | 8.9279 | 8.9286 | 53200.0 |
| 2010-05-19 07:20:00 | AAPL | Stock | 8.9214 | 8.925 | 8.9018 | 8.9196 | 35840.0 |
| 2010-05-19 07:25:00 | AAPL | Stock | 8.9261 | 8.9286 | 8.9207 | 8.9279 | 33600.0 |
| 2010-05-19 07:30:00 | AAPL | Stock | 8.925 | 8.9293 | 8.925 | 8.9286 | 69440.0 |
| 2010-05-19 07:35:00 | AAPL | Stock | 8.9214 | 8.925 | 8.9214 | 8.9218 | 28000.0 |
| 2010-05-19 07:40:00 | AAPL | Stock | 8.9282 | 8.9289 | 8.9239 | 8.9239 | 41664.0 |
| 2010-05-19 07:45:00 | AAPL | Stock | 8.9282 | 8.9286 | 8.9282 | 8.9286 | 14000.0 |
| 2010-05-19 07:50:00 | AAPL | Stock | 8.9271 | 8.9375 | 8.9271 | 8.9375 | 22400.0 |
| 2010-05-19 07:55:00 | AAPL | Stock | 8.9371 | 8.9375 | 8.9307 | 8.9321 | 28000.0 |
| 2010-05-19 08:00:00 | AAPL | Stock | 8.9311 | 8.9321 | 8.9089 | 8.9089 | 678776.0 |
| 2010-05-19 08:05:00 | AAPL | Stock | 8.9039 | 8.9089 | 8.8893 | 8.8954 | 426720.0 |
| 2010-05-19 08:10:00 | AAPL | Stock | 8.8971 | 8.9375 | 8.8964 | 8.9289 | 483168.0 |
| 2010-05-19 08:15:00 | AAPL | Stock | 8.9325 | 8.9446 | 8.8968 | 8.9375 | 672364.0 |
| 2010-05-19 08:20:00 | AAPL | Stock | 8.9357 | 8.9425 | 8.9321 | 8.9321 | 336588.0 |
| 2010-05-19 08:25:00 | AAPL | Stock | 8.9304 | 8.9304 | 8.92 | 8.9243 | 219800.0 |
| 2010-05-19 08:30:00 | AAPL | Stock | 8.9264 | 8.9393 | 8.9161 | 8.9314 | 385896.0 |
| 2010-05-19 08:35:00 | AAPL | Stock | 8.9307 | 8.9321 | 8.9154 | 8.9154 | 284340.0 |
| 2010-05-19 08:40:00 | AAPL | Stock | 8.9164 | 8.9286 | 8.9154 | 8.9271 | 273784.0 |
| 2010-05-19 08:45:00 | AAPL | Stock | 8.9268 | 8.9532 | 8.9268 | 8.9439 | 1193556.0 |
| 2010-05-19 08:50:00 | AAPL | Stock | 8.9404 | 8.9518 | 8.9393 | 8.9443 | 169400.0 |
| 2010-05-19 08:55:00 | AAPL | Stock | 8.9471 | 8.9779 | 8.9396 | 8.9736 | 658756.0 |
| 2010-05-19 09:00:00 | AAPL | Stock | 8.975 | 8.975 | 8.9643 | 8.9686 | 420168.0 |
| 2010-05-19 09:05:00 | AAPL | Stock | 8.9725 | 8.9739 | 8.9589 | 8.9654 | 517860.0 |
| 2010-05-19 09:10:00 | AAPL | Stock | 8.9664 | 8.9714 | 8.947 | 8.947 | 417732.0 |
| 2010-05-19 09:15:00 | AAPL | Stock | 8.9632 | 8.9643 | 8.9521 | 8.9607 | 42000.0 |
| 2010-05-19 09:20:00 | AAPL | Stock | 8.9607 | 8.9607 | 8.9564 | 8.9579 | 123760.0 |
| 2010-05-19 09:25:00 | AAPL | Stock | 8.9598 | 8.9604 | 8.9107 | 8.9107 | 1112972.0 |
| 2010-05-19 09:30:00 | AAPL | Stock | 8.9143 | 8.9932 | 8.8964 | 8.9536 | 21073584.0 |
| 2010-05-19 09:35:00 | AAPL | Stock | 8.9561 | 9.0161 | 8.9475 | 9.0125 | 18392892.0 |
| 2010-05-19 09:40:00 | AAPL | Stock | 9.015 | 9.0268 | 8.9686 | 8.9918 | 17771320.0 |
| 2010-05-19 09:45:00 | AAPL | Stock | 8.9918 | 9.0329 | 8.9286 | 8.9518 | 29992564.0 |
| 2010-05-19 09:50:00 | AAPL | Stock | 8.9482 | 8.9811 | 8.8857 | 8.8989 | 28390040.0 |
| 2010-05-19 09:55:00 | AAPL | Stock | 8.8979 | 8.9089 | 8.8682 | 8.9 | 21715736.0 |
| 2010-05-19 10:00:00 | AAPL | Stock | 8.9 | 8.9075 | 8.8214 | 8.8582 | 33178712.0 |
| 2010-05-19 10:05:00 | AAPL | Stock | 8.8546 | 8.8804 | 8.825 | 8.8439 | 17341856.0 |
| 2010-05-19 10:10:00 | AAPL | Stock | 8.8439 | 8.8625 | 8.8072 | 8.8239 | 17516408.0 |
| 2010-05-19 10:15:00 | AAPL | Stock | 8.8232 | 8.85 | 8.7736 | 8.7885 | 23211468.0 |
| 2010-05-19 10:20:00 | AAPL | Stock | 8.7882 | 8.8036 | 8.7593 | 8.7699 | 27287736.0 |
> showing 50 of 342,302 rows — these rows as CSV