PREVIEW / stock_1min / 2009-12-16
file: by_date/stock_1min/2009/2009-12-16.parquet size: 12.6 MB rows: 950,389 symbols: 2,796
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-16 07:01:00 | AAPL | Stock | 6.9714 | 6.9714 | 6.9714 | 6.9714 | 2800.0 |
| 2009-12-16 07:08:00 | AAPL | Stock | 6.9654 | 6.9821 | 6.9654 | 6.9821 | 11060.0 |
| 2009-12-16 07:12:00 | AAPL | Stock | 6.9811 | 6.9811 | 6.9811 | 6.9811 | 4200.0 |
| 2009-12-16 07:21:00 | AAPL | Stock | 6.9889 | 6.9889 | 6.9889 | 6.9889 | 2800.0 |
| 2009-12-16 07:30:00 | AAPL | Stock | 6.9821 | 6.9821 | 6.9821 | 6.9821 | 8400.0 |
| 2009-12-16 07:32:00 | AAPL | Stock | 6.9793 | 6.9793 | 6.9793 | 6.9793 | 11200.0 |
| 2009-12-16 07:36:00 | AAPL | Stock | 6.9786 | 6.9793 | 6.9786 | 6.9793 | 16240.0 |
| 2009-12-16 07:37:00 | AAPL | Stock | 6.9829 | 6.9829 | 6.9829 | 6.9829 | 5600.0 |
| 2009-12-16 07:45:00 | AAPL | Stock | 6.9829 | 6.9829 | 6.9821 | 6.9821 | 28000.0 |
| 2009-12-16 07:49:00 | AAPL | Stock | 6.985 | 6.985 | 6.985 | 6.985 | 2800.0 |
| 2009-12-16 07:53:00 | AAPL | Stock | 6.9882 | 6.9889 | 6.9882 | 6.9889 | 14000.0 |
| 2009-12-16 07:54:00 | AAPL | Stock | 6.9889 | 6.9889 | 6.9868 | 6.9868 | 33572.0 |
| 2009-12-16 07:58:00 | AAPL | Stock | 6.9882 | 6.9882 | 6.9882 | 6.9882 | 19600.0 |
| 2009-12-16 08:00:00 | AAPL | Stock | 6.9889 | 6.9889 | 6.9779 | 6.9786 | 156380.0 |
| 2009-12-16 08:01:00 | AAPL | Stock | 6.9804 | 6.9804 | 6.975 | 6.9768 | 32172.0 |
| 2009-12-16 08:02:00 | AAPL | Stock | 6.975 | 6.975 | 6.975 | 6.975 | 9240.0 |
| 2009-12-16 08:03:00 | AAPL | Stock | 6.9768 | 6.9768 | 6.9721 | 6.9721 | 11900.0 |
| 2009-12-16 08:04:00 | AAPL | Stock | 6.9718 | 6.9718 | 6.9661 | 6.9661 | 57232.0 |
| 2009-12-16 08:05:00 | AAPL | Stock | 6.9643 | 6.9643 | 6.9643 | 6.9643 | 2800.0 |
| 2009-12-16 08:06:00 | AAPL | Stock | 6.9643 | 6.9643 | 6.9643 | 6.9643 | 28364.0 |
| 2009-12-16 08:07:00 | AAPL | Stock | 6.9607 | 6.9643 | 6.9607 | 6.9636 | 36204.0 |
| 2009-12-16 08:08:00 | AAPL | Stock | 6.9639 | 6.9639 | 6.9639 | 6.9639 | 9800.0 |
| 2009-12-16 08:10:00 | AAPL | Stock | 6.9636 | 6.9643 | 6.9636 | 6.9639 | 16800.0 |
| 2009-12-16 08:11:00 | AAPL | Stock | 6.9571 | 6.9571 | 6.9521 | 6.9521 | 61180.0 |
| 2009-12-16 08:12:00 | AAPL | Stock | 6.9518 | 6.9636 | 6.9518 | 6.9636 | 25200.0 |
| 2009-12-16 08:13:00 | AAPL | Stock | 6.9621 | 6.9621 | 6.9621 | 6.9621 | 2800.0 |
| 2009-12-16 08:14:00 | AAPL | Stock | 6.9554 | 6.9618 | 6.9536 | 6.9589 | 24080.0 |
| 2009-12-16 08:15:00 | AAPL | Stock | 6.9571 | 6.9571 | 6.9571 | 6.9571 | 8400.0 |
| 2009-12-16 08:16:00 | AAPL | Stock | 6.9589 | 6.9629 | 6.9589 | 6.9629 | 5600.0 |
| 2009-12-16 08:17:00 | AAPL | Stock | 6.9579 | 6.9579 | 6.9579 | 6.9579 | 2800.0 |
| 2009-12-16 08:18:00 | AAPL | Stock | 6.9636 | 6.9636 | 6.9625 | 6.9625 | 5600.0 |
| 2009-12-16 08:19:00 | AAPL | Stock | 6.9589 | 6.9589 | 6.9589 | 6.9589 | 13468.0 |
| 2009-12-16 08:20:00 | AAPL | Stock | 6.9596 | 6.9607 | 6.9596 | 6.9607 | 14000.0 |
| 2009-12-16 08:21:00 | AAPL | Stock | 6.9607 | 6.9804 | 6.9607 | 6.9764 | 126672.0 |
| 2009-12-16 08:22:00 | AAPL | Stock | 6.9804 | 6.9818 | 6.9804 | 6.9818 | 7280.0 |
| 2009-12-16 08:23:00 | AAPL | Stock | 6.9679 | 6.9786 | 6.9679 | 6.9714 | 11200.0 |
| 2009-12-16 08:24:00 | AAPL | Stock | 6.9718 | 6.9718 | 6.9718 | 6.9718 | 5460.0 |
| 2009-12-16 08:25:00 | AAPL | Stock | 6.9689 | 6.9689 | 6.9689 | 6.9689 | 2800.0 |
| 2009-12-16 08:28:00 | AAPL | Stock | 6.9707 | 6.9732 | 6.9707 | 6.9732 | 29092.0 |
| 2009-12-16 08:29:00 | AAPL | Stock | 6.9732 | 6.9732 | 6.9732 | 6.9732 | 8400.0 |
| 2009-12-16 08:30:00 | AAPL | Stock | 6.9732 | 6.975 | 6.9732 | 6.975 | 32200.0 |
| 2009-12-16 08:31:00 | AAPL | Stock | 6.9714 | 6.9714 | 6.9714 | 6.9714 | 14000.0 |
| 2009-12-16 08:33:00 | AAPL | Stock | 6.9739 | 6.9739 | 6.9739 | 6.9739 | 28000.0 |
| 2009-12-16 08:34:00 | AAPL | Stock | 6.9689 | 6.9689 | 6.9643 | 6.9643 | 22400.0 |
| 2009-12-16 08:35:00 | AAPL | Stock | 6.9686 | 6.9689 | 6.9686 | 6.9686 | 25200.0 |
| 2009-12-16 08:36:00 | AAPL | Stock | 6.9732 | 6.9732 | 6.9714 | 6.9714 | 33600.0 |
| 2009-12-16 08:37:00 | AAPL | Stock | 6.9686 | 6.9686 | 6.9686 | 6.9686 | 24584.0 |
| 2009-12-16 08:38:00 | AAPL | Stock | 6.9693 | 6.9693 | 6.9693 | 6.9693 | 2800.0 |
| 2009-12-16 08:39:00 | AAPL | Stock | 6.9686 | 6.9689 | 6.9643 | 6.9643 | 52920.0 |
| 2009-12-16 08:40:00 | AAPL | Stock | 6.9643 | 6.9643 | 6.9629 | 6.9643 | 20916.0 |
> showing 50 of 950,389 rows — these rows as CSV