PREVIEW / stock_5min / 2006-07-11
file: by_date/stock_5min/2006/2006-07-11.parquet size: 3.1 MB rows: 227,386 symbols: 2,314
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-11 06:35:00 | AAPL | Stock | 1.9643 | 1.9643 | 1.9643 | 1.9643 | 8400.0 |
| 2006-07-11 06:55:00 | AAPL | Stock | 1.9714 | 1.9714 | 1.9714 | 1.9714 | 5600.0 |
| 2006-07-11 07:05:00 | AAPL | Stock | 1.9732 | 1.9732 | 1.9732 | 1.9732 | 5600.0 |
| 2006-07-11 07:15:00 | AAPL | Stock | 1.9679 | 1.9679 | 1.9643 | 1.9643 | 22400.0 |
| 2006-07-11 07:35:00 | AAPL | Stock | 1.9693 | 1.9693 | 1.9693 | 1.9693 | 8400.0 |
| 2006-07-11 07:45:00 | AAPL | Stock | 1.9718 | 1.9718 | 1.9718 | 1.9718 | 14000.0 |
| 2006-07-11 08:00:00 | AAPL | Stock | 1.9643 | 1.9714 | 1.9614 | 1.9696 | 506772.0 |
| 2006-07-11 08:05:00 | AAPL | Stock | 1.9696 | 1.9696 | 1.9696 | 1.9696 | 69832.0 |
| 2006-07-11 08:10:00 | AAPL | Stock | 1.9696 | 1.9704 | 1.9689 | 1.9696 | 142268.0 |
| 2006-07-11 08:15:00 | AAPL | Stock | 1.9696 | 1.975 | 1.9696 | 1.975 | 465808.0 |
| 2006-07-11 08:20:00 | AAPL | Stock | 1.9739 | 1.975 | 1.9714 | 1.9721 | 311640.0 |
| 2006-07-11 08:25:00 | AAPL | Stock | 1.9714 | 1.9714 | 1.9682 | 1.9682 | 131180.0 |
| 2006-07-11 08:30:00 | AAPL | Stock | 1.9693 | 1.9693 | 1.9679 | 1.9679 | 233800.0 |
| 2006-07-11 08:35:00 | AAPL | Stock | 1.9675 | 1.9679 | 1.9657 | 1.9675 | 23800.0 |
| 2006-07-11 08:40:00 | AAPL | Stock | 1.965 | 1.9675 | 1.965 | 1.9675 | 30800.0 |
| 2006-07-11 08:45:00 | AAPL | Stock | 1.9675 | 1.97 | 1.9675 | 1.97 | 152488.0 |
| 2006-07-11 08:50:00 | AAPL | Stock | 1.9714 | 1.9714 | 1.9696 | 1.97 | 66500.0 |
| 2006-07-11 08:55:00 | AAPL | Stock | 1.9707 | 1.9707 | 1.9707 | 1.9707 | 39200.0 |
| 2006-07-11 09:00:00 | AAPL | Stock | 1.9714 | 1.9732 | 1.9714 | 1.9714 | 269612.0 |
| 2006-07-11 09:05:00 | AAPL | Stock | 1.9714 | 1.9732 | 1.9714 | 1.9721 | 52500.0 |
| 2006-07-11 09:10:00 | AAPL | Stock | 1.9707 | 1.9721 | 1.9696 | 1.9718 | 292124.0 |
| 2006-07-11 09:20:00 | AAPL | Stock | 1.9711 | 1.9711 | 1.9682 | 1.9682 | 11200.0 |
| 2006-07-11 09:25:00 | AAPL | Stock | 1.9704 | 1.9707 | 1.9671 | 1.9679 | 451388.0 |
| 2006-07-11 09:30:00 | AAPL | Stock | 1.9682 | 1.9704 | 1.9511 | 1.9554 | 18014668.0 |
| 2006-07-11 09:35:00 | AAPL | Stock | 1.9554 | 1.9643 | 1.9518 | 1.9618 | 14864696.0 |
| 2006-07-11 09:40:00 | AAPL | Stock | 1.9618 | 1.9618 | 1.9529 | 1.9536 | 9161488.0 |
| 2006-07-11 09:45:00 | AAPL | Stock | 1.9536 | 1.9671 | 1.9489 | 1.9643 | 18913272.0 |
| 2006-07-11 09:50:00 | AAPL | Stock | 1.9643 | 1.9782 | 1.9636 | 1.9775 | 22358028.0 |
| 2006-07-11 09:55:00 | AAPL | Stock | 1.9779 | 1.9875 | 1.9754 | 1.9757 | 16612428.0 |
| 2006-07-11 10:00:00 | AAPL | Stock | 1.9757 | 1.9775 | 1.9693 | 1.9714 | 14761180.0 |
| 2006-07-11 10:05:00 | AAPL | Stock | 1.9718 | 1.9757 | 1.9643 | 1.965 | 12437600.0 |
| 2006-07-11 10:10:00 | AAPL | Stock | 1.9643 | 1.9665 | 1.9589 | 1.9654 | 15493996.0 |
| 2006-07-11 10:15:00 | AAPL | Stock | 1.965 | 1.9682 | 1.9604 | 1.9657 | 13550068.0 |
| 2006-07-11 10:20:00 | AAPL | Stock | 1.9654 | 1.9729 | 1.9646 | 1.9714 | 12875128.0 |
| 2006-07-11 10:25:00 | AAPL | Stock | 1.9711 | 1.9711 | 1.9664 | 1.9671 | 8411116.0 |
| 2006-07-11 10:30:00 | AAPL | Stock | 1.9671 | 1.9671 | 1.9607 | 1.9631 | 11768932.0 |
| 2006-07-11 10:35:00 | AAPL | Stock | 1.9629 | 1.9682 | 1.9543 | 1.9654 | 7649488.0 |
| 2006-07-11 10:40:00 | AAPL | Stock | 1.9657 | 1.9704 | 1.9625 | 1.9625 | 9579192.0 |
| 2006-07-11 10:45:00 | AAPL | Stock | 1.9625 | 1.965 | 1.9607 | 1.9618 | 8295896.0 |
| 2006-07-11 10:50:00 | AAPL | Stock | 1.9621 | 1.9664 | 1.955 | 1.9579 | 9697380.0 |
| 2006-07-11 10:55:00 | AAPL | Stock | 1.9579 | 1.9618 | 1.9579 | 1.9618 | 6099380.0 |
| 2006-07-11 11:00:00 | AAPL | Stock | 1.9614 | 1.9661 | 1.9607 | 1.9643 | 6373640.0 |
| 2006-07-11 11:05:00 | AAPL | Stock | 1.9643 | 1.9675 | 1.9611 | 1.9675 | 7111888.0 |
| 2006-07-11 11:10:00 | AAPL | Stock | 1.9675 | 1.9675 | 1.9575 | 1.9604 | 13253688.0 |
| 2006-07-11 11:15:00 | AAPL | Stock | 1.9604 | 1.9654 | 1.96 | 1.9643 | 6235068.0 |
| 2006-07-11 11:20:00 | AAPL | Stock | 1.9643 | 1.9657 | 1.9586 | 1.9589 | 6606264.0 |
| 2006-07-11 11:25:00 | AAPL | Stock | 1.9586 | 1.9629 | 1.9583 | 1.9611 | 6993812.0 |
| 2006-07-11 11:30:00 | AAPL | Stock | 1.9607 | 1.9639 | 1.96 | 1.9604 | 6889764.0 |
| 2006-07-11 11:35:00 | AAPL | Stock | 1.9607 | 1.9629 | 1.96 | 1.9629 | 4082344.0 |
| 2006-07-11 11:40:00 | AAPL | Stock | 1.9629 | 1.9668 | 1.96 | 1.9657 | 5992868.0 |
> showing 50 of 227,386 rows — these rows as CSV