PREVIEW / stock_1min / 2013-06-21
file: by_date/stock_1min/2013/2013-06-21.parquet size: 15.1 MB rows: 1,099,072 symbols: 2,845
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 |
|---|---|---|---|---|---|---|---|
| 2013-06-21 05:50:00 | AAPL | Stock | 14.9707 | 14.9707 | 14.9707 | 14.9707 | 8400.0 |
| 2013-06-21 05:52:00 | AAPL | Stock | 14.9707 | 14.9707 | 14.9707 | 14.9707 | 2800.0 |
| 2013-06-21 05:57:00 | AAPL | Stock | 14.9675 | 14.9675 | 14.9675 | 14.9675 | 5600.0 |
| 2013-06-21 06:54:00 | AAPL | Stock | 14.9714 | 14.9718 | 14.9714 | 14.9714 | 22372.0 |
| 2013-06-21 07:00:00 | AAPL | Stock | 14.9643 | 14.9668 | 14.9643 | 14.9668 | 13804.0 |
| 2013-06-21 07:01:00 | AAPL | Stock | 14.9779 | 14.9796 | 14.9704 | 14.9704 | 14000.0 |
| 2013-06-21 07:03:00 | AAPL | Stock | 14.9679 | 14.9679 | 14.9643 | 14.9643 | 9800.0 |
| 2013-06-21 07:04:00 | AAPL | Stock | 14.9679 | 14.9679 | 14.9679 | 14.9679 | 2800.0 |
| 2013-06-21 07:05:00 | AAPL | Stock | 14.9732 | 14.9782 | 14.9732 | 14.9782 | 18480.0 |
| 2013-06-21 07:06:00 | AAPL | Stock | 14.9686 | 14.9686 | 14.9686 | 14.9686 | 2800.0 |
| 2013-06-21 07:15:00 | AAPL | Stock | 14.9643 | 14.9679 | 14.9643 | 14.9643 | 19600.0 |
| 2013-06-21 07:20:00 | AAPL | Stock | 14.9643 | 14.9643 | 14.9643 | 14.9643 | 2800.0 |
| 2013-06-21 07:22:00 | AAPL | Stock | 14.9554 | 14.9571 | 14.9468 | 14.9468 | 13496.0 |
| 2013-06-21 07:23:00 | AAPL | Stock | 14.9568 | 14.9568 | 14.9568 | 14.9568 | 2800.0 |
| 2013-06-21 07:24:00 | AAPL | Stock | 14.9436 | 14.9436 | 14.9436 | 14.9436 | 4200.0 |
| 2013-06-21 07:27:00 | AAPL | Stock | 14.9607 | 14.9607 | 14.9607 | 14.9607 | 2800.0 |
| 2013-06-21 07:29:00 | AAPL | Stock | 14.9643 | 14.9643 | 14.9643 | 14.9643 | 2800.0 |
| 2013-06-21 07:37:00 | AAPL | Stock | 14.9604 | 14.9636 | 14.9604 | 14.9636 | 5600.0 |
| 2013-06-21 07:38:00 | AAPL | Stock | 14.9711 | 14.9711 | 14.9518 | 14.9518 | 21420.0 |
| 2013-06-21 07:41:00 | AAPL | Stock | 14.9679 | 14.9711 | 14.9643 | 14.9643 | 18424.0 |
| 2013-06-21 07:42:00 | AAPL | Stock | 14.9732 | 14.9732 | 14.9732 | 14.9732 | 3780.0 |
| 2013-06-21 07:45:00 | AAPL | Stock | 14.975 | 14.9754 | 14.975 | 14.975 | 16800.0 |
| 2013-06-21 07:46:00 | AAPL | Stock | 14.975 | 14.9811 | 14.975 | 14.9811 | 5600.0 |
| 2013-06-21 07:48:00 | AAPL | Stock | 14.9807 | 14.9807 | 14.975 | 14.975 | 8400.0 |
| 2013-06-21 07:50:00 | AAPL | Stock | 14.9764 | 14.9775 | 14.9764 | 14.9775 | 8400.0 |
| 2013-06-21 07:53:00 | AAPL | Stock | 14.9775 | 14.9775 | 14.9757 | 14.9757 | 5600.0 |
| 2013-06-21 07:54:00 | AAPL | Stock | 14.9768 | 14.9768 | 14.9768 | 14.9768 | 4200.0 |
| 2013-06-21 07:55:00 | AAPL | Stock | 14.98 | 14.9889 | 14.98 | 14.9889 | 53760.0 |
| 2013-06-21 07:58:00 | AAPL | Stock | 14.9789 | 14.9789 | 14.9789 | 14.9789 | 2800.0 |
| 2013-06-21 08:00:00 | AAPL | Stock | 14.9918 | 14.9946 | 14.9611 | 14.9821 | 197428.0 |
| 2013-06-21 08:01:00 | AAPL | Stock | 14.985 | 14.985 | 14.9757 | 14.9818 | 8400.0 |
| 2013-06-21 08:02:00 | AAPL | Stock | 14.9761 | 14.9875 | 14.9761 | 14.9875 | 37100.0 |
| 2013-06-21 08:03:00 | AAPL | Stock | 14.9811 | 14.9896 | 14.9811 | 14.9857 | 17360.0 |
| 2013-06-21 08:04:00 | AAPL | Stock | 14.9832 | 14.9832 | 14.8536 | 14.8536 | 18928.0 |
| 2013-06-21 08:05:00 | AAPL | Stock | 14.9882 | 14.9882 | 14.975 | 14.9761 | 54544.0 |
| 2013-06-21 08:06:00 | AAPL | Stock | 14.9786 | 14.9804 | 14.9779 | 14.9779 | 25200.0 |
| 2013-06-21 08:07:00 | AAPL | Stock | 14.9779 | 14.9779 | 14.9743 | 14.9757 | 39200.0 |
| 2013-06-21 08:08:00 | AAPL | Stock | 14.975 | 14.975 | 14.9686 | 14.9686 | 28000.0 |
| 2013-06-21 08:09:00 | AAPL | Stock | 14.9657 | 14.9657 | 14.9654 | 14.9654 | 14000.0 |
| 2013-06-21 08:10:00 | AAPL | Stock | 14.9711 | 14.9711 | 14.9643 | 14.9646 | 29344.0 |
| 2013-06-21 08:11:00 | AAPL | Stock | 14.965 | 14.9711 | 14.9646 | 14.9696 | 44856.0 |
| 2013-06-21 08:12:00 | AAPL | Stock | 14.9679 | 14.9679 | 14.9679 | 14.9679 | 14000.0 |
| 2013-06-21 08:13:00 | AAPL | Stock | 14.9696 | 14.9696 | 14.9696 | 14.9696 | 5460.0 |
| 2013-06-21 08:14:00 | AAPL | Stock | 14.9646 | 14.9646 | 14.9607 | 14.9607 | 92120.0 |
| 2013-06-21 08:15:00 | AAPL | Stock | 14.9593 | 14.96 | 14.9589 | 14.9596 | 30856.0 |
| 2013-06-21 08:16:00 | AAPL | Stock | 14.9607 | 14.9607 | 14.9521 | 14.9554 | 38640.0 |
| 2013-06-21 08:17:00 | AAPL | Stock | 14.9589 | 14.9589 | 14.9557 | 14.9564 | 21840.0 |
| 2013-06-21 08:18:00 | AAPL | Stock | 14.9579 | 14.9589 | 14.95 | 14.95 | 92204.0 |
| 2013-06-21 08:19:00 | AAPL | Stock | 14.9471 | 14.9536 | 14.9396 | 14.9396 | 84000.0 |
| 2013-06-21 08:21:00 | AAPL | Stock | 14.9496 | 14.9504 | 14.9461 | 14.9504 | 33600.0 |
> showing 50 of 1,099,072 rows — these rows as CSV