PREVIEW / stock_1min / 2010-10-27
file: by_date/stock_1min/2010/2010-10-27.parquet size: 12.8 MB rows: 965,133 symbols: 2,837
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-10-27 05:05:00 | AAPL | Stock | 10.9843 | 10.9843 | 10.9839 | 10.9839 | 8400.0 |
| 2010-10-27 05:41:00 | AAPL | Stock | 10.9821 | 10.9821 | 10.9821 | 10.9821 | 2800.0 |
| 2010-10-27 07:00:00 | AAPL | Stock | 10.9821 | 10.9821 | 10.9821 | 10.9821 | 5600.0 |
| 2010-10-27 07:01:00 | AAPL | Stock | 10.9821 | 10.9921 | 10.9821 | 10.9921 | 5880.0 |
| 2010-10-27 07:07:00 | AAPL | Stock | 10.9682 | 10.9682 | 10.9682 | 10.9682 | 3080.0 |
| 2010-10-27 07:12:00 | AAPL | Stock | 10.9718 | 10.9729 | 10.9686 | 10.9714 | 16800.0 |
| 2010-10-27 07:14:00 | AAPL | Stock | 10.9714 | 10.9714 | 10.9714 | 10.9714 | 5600.0 |
| 2010-10-27 07:15:00 | AAPL | Stock | 10.9714 | 10.9714 | 10.9661 | 10.9661 | 36400.0 |
| 2010-10-27 07:21:00 | AAPL | Stock | 10.9671 | 10.9671 | 10.9661 | 10.9661 | 14000.0 |
| 2010-10-27 07:24:00 | AAPL | Stock | 10.9757 | 10.9761 | 10.9757 | 10.9761 | 8400.0 |
| 2010-10-27 07:26:00 | AAPL | Stock | 10.9757 | 10.9757 | 10.9757 | 10.9757 | 2800.0 |
| 2010-10-27 07:29:00 | AAPL | Stock | 10.9739 | 10.9739 | 10.9732 | 10.9739 | 11200.0 |
| 2010-10-27 07:32:00 | AAPL | Stock | 10.9739 | 10.9739 | 10.9739 | 10.9739 | 2800.0 |
| 2010-10-27 07:35:00 | AAPL | Stock | 10.9664 | 10.9664 | 10.9661 | 10.9661 | 21000.0 |
| 2010-10-27 07:36:00 | AAPL | Stock | 10.9664 | 10.9664 | 10.9639 | 10.9639 | 50400.0 |
| 2010-10-27 07:40:00 | AAPL | Stock | 10.9546 | 10.9546 | 10.9546 | 10.9546 | 22400.0 |
| 2010-10-27 07:41:00 | AAPL | Stock | 10.9579 | 10.9586 | 10.9579 | 10.9586 | 8400.0 |
| 2010-10-27 07:42:00 | AAPL | Stock | 10.9586 | 10.9586 | 10.9586 | 10.9586 | 22400.0 |
| 2010-10-27 07:46:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9639 | 10.9639 | 5600.0 |
| 2010-10-27 07:50:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9586 | 10.9586 | 72800.0 |
| 2010-10-27 07:52:00 | AAPL | Stock | 10.9639 | 10.9668 | 10.9639 | 10.9668 | 5600.0 |
| 2010-10-27 07:53:00 | AAPL | Stock | 10.9661 | 10.9661 | 10.9661 | 10.9661 | 2800.0 |
| 2010-10-27 07:55:00 | AAPL | Stock | 10.9654 | 10.9657 | 10.9518 | 10.9518 | 29400.0 |
| 2010-10-27 07:56:00 | AAPL | Stock | 10.9529 | 10.9529 | 10.9446 | 10.9482 | 50400.0 |
| 2010-10-27 07:57:00 | AAPL | Stock | 10.95 | 10.9536 | 10.9482 | 10.9536 | 12600.0 |
| 2010-10-27 07:58:00 | AAPL | Stock | 10.9554 | 10.9646 | 10.9554 | 10.9586 | 91000.0 |
| 2010-10-27 07:59:00 | AAPL | Stock | 10.9579 | 10.9579 | 10.9511 | 10.9511 | 19600.0 |
| 2010-10-27 08:00:00 | AAPL | Stock | 10.95 | 10.9643 | 10.9429 | 10.9464 | 453516.0 |
| 2010-10-27 08:01:00 | AAPL | Stock | 10.9475 | 10.9475 | 10.9464 | 10.9464 | 53452.0 |
| 2010-10-27 08:02:00 | AAPL | Stock | 10.9464 | 10.9593 | 10.9464 | 10.9504 | 16800.0 |
| 2010-10-27 08:03:00 | AAPL | Stock | 10.95 | 10.95 | 10.95 | 10.95 | 2800.0 |
| 2010-10-27 08:04:00 | AAPL | Stock | 10.945 | 10.95 | 10.945 | 10.95 | 8400.0 |
| 2010-10-27 08:06:00 | AAPL | Stock | 10.9554 | 10.9554 | 10.9554 | 10.9554 | 7672.0 |
| 2010-10-27 08:07:00 | AAPL | Stock | 10.9589 | 10.9607 | 10.9571 | 10.9571 | 60200.0 |
| 2010-10-27 08:10:00 | AAPL | Stock | 10.9589 | 10.9625 | 10.9589 | 10.9625 | 23800.0 |
| 2010-10-27 08:11:00 | AAPL | Stock | 10.9611 | 10.9679 | 10.9611 | 10.9668 | 34496.0 |
| 2010-10-27 08:13:00 | AAPL | Stock | 10.9693 | 10.9721 | 10.9693 | 10.9721 | 94360.0 |
| 2010-10-27 08:16:00 | AAPL | Stock | 10.9714 | 10.9721 | 10.9714 | 10.9721 | 16800.0 |
| 2010-10-27 08:17:00 | AAPL | Stock | 10.9721 | 10.9721 | 10.9721 | 10.9721 | 2800.0 |
| 2010-10-27 08:18:00 | AAPL | Stock | 10.9696 | 10.9696 | 10.9696 | 10.9696 | 2800.0 |
| 2010-10-27 08:19:00 | AAPL | Stock | 10.9714 | 10.9732 | 10.9714 | 10.9732 | 19600.0 |
| 2010-10-27 08:21:00 | AAPL | Stock | 10.9721 | 10.9721 | 10.97 | 10.97 | 67788.0 |
| 2010-10-27 08:23:00 | AAPL | Stock | 10.9732 | 10.9732 | 10.9732 | 10.9732 | 14000.0 |
| 2010-10-27 08:27:00 | AAPL | Stock | 10.9746 | 10.9746 | 10.9746 | 10.9746 | 12600.0 |
| 2010-10-27 08:28:00 | AAPL | Stock | 10.9729 | 10.9729 | 10.9729 | 10.9729 | 2800.0 |
| 2010-10-27 08:29:00 | AAPL | Stock | 10.975 | 10.9761 | 10.975 | 10.975 | 42000.0 |
| 2010-10-27 08:30:00 | AAPL | Stock | 10.9721 | 10.9721 | 10.9589 | 10.9589 | 274624.0 |
| 2010-10-27 08:31:00 | AAPL | Stock | 10.9643 | 10.9707 | 10.9614 | 10.9664 | 146440.0 |
| 2010-10-27 08:32:00 | AAPL | Stock | 10.9643 | 10.9721 | 10.9643 | 10.9721 | 39200.0 |
| 2010-10-27 08:33:00 | AAPL | Stock | 10.9725 | 10.9861 | 10.9725 | 10.9861 | 119308.0 |
> showing 50 of 965,133 rows — these rows as CSV