PREVIEW / stock_5min / 2005-10-04
file: by_date/stock_5min/2005/2005-10-04.parquet size: 2.8 MB rows: 207,784 symbols: 2,089
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-04 08:00:00 | AAPL | Stock | 1.9482 | 1.9482 | 1.9482 | 1.9482 | 28000.0 |
| 2005-10-04 08:05:00 | AAPL | Stock | 1.95 | 1.95 | 1.95 | 1.95 | 11200.0 |
| 2005-10-04 08:10:00 | AAPL | Stock | 1.95 | 1.9596 | 1.95 | 1.9596 | 150360.0 |
| 2005-10-04 08:15:00 | AAPL | Stock | 1.9589 | 1.96 | 1.9586 | 1.9589 | 89600.0 |
| 2005-10-04 08:20:00 | AAPL | Stock | 1.9561 | 1.9561 | 1.9536 | 1.9554 | 47908.0 |
| 2005-10-04 08:25:00 | AAPL | Stock | 1.9539 | 1.9543 | 1.9518 | 1.9518 | 134904.0 |
| 2005-10-04 08:30:00 | AAPL | Stock | 1.9536 | 1.9536 | 1.9521 | 1.9536 | 123200.0 |
| 2005-10-04 08:35:00 | AAPL | Stock | 1.9543 | 1.9571 | 1.9543 | 1.9554 | 109340.0 |
| 2005-10-04 08:40:00 | AAPL | Stock | 1.9564 | 1.9604 | 1.9564 | 1.9596 | 246400.0 |
| 2005-10-04 08:45:00 | AAPL | Stock | 1.9607 | 1.9625 | 1.9589 | 1.9625 | 316400.0 |
| 2005-10-04 08:50:00 | AAPL | Stock | 1.9596 | 1.9596 | 1.9596 | 1.9596 | 30800.0 |
| 2005-10-04 08:55:00 | AAPL | Stock | 1.9611 | 1.9621 | 1.9607 | 1.9621 | 127400.0 |
| 2005-10-04 09:00:00 | AAPL | Stock | 1.9621 | 1.9629 | 1.9614 | 1.9629 | 84168.0 |
| 2005-10-04 09:05:00 | AAPL | Stock | 1.9632 | 1.9632 | 1.9607 | 1.9607 | 133840.0 |
| 2005-10-04 09:10:00 | AAPL | Stock | 1.9604 | 1.9604 | 1.9596 | 1.9596 | 15400.0 |
| 2005-10-04 09:15:00 | AAPL | Stock | 1.9589 | 1.9593 | 1.9589 | 1.9593 | 42000.0 |
| 2005-10-04 09:20:00 | AAPL | Stock | 1.9596 | 1.9604 | 1.9596 | 1.9596 | 22400.0 |
| 2005-10-04 09:25:00 | AAPL | Stock | 1.9593 | 1.9639 | 1.9593 | 1.9604 | 481852.0 |
| 2005-10-04 09:30:00 | AAPL | Stock | 1.9625 | 1.9643 | 1.96 | 1.9604 | 16336068.0 |
| 2005-10-04 09:35:00 | AAPL | Stock | 1.96 | 1.9636 | 1.9564 | 1.9564 | 7551852.0 |
| 2005-10-04 09:40:00 | AAPL | Stock | 1.9564 | 1.9604 | 1.9507 | 1.9518 | 10864616.0 |
| 2005-10-04 09:45:00 | AAPL | Stock | 1.9521 | 1.955 | 1.9496 | 1.9525 | 9940784.0 |
| 2005-10-04 09:50:00 | AAPL | Stock | 1.9529 | 1.9579 | 1.9529 | 1.9571 | 7724864.0 |
| 2005-10-04 09:55:00 | AAPL | Stock | 1.9568 | 1.9579 | 1.9546 | 1.9554 | 6441148.0 |
| 2005-10-04 10:00:00 | AAPL | Stock | 1.9554 | 1.9607 | 1.9554 | 1.9596 | 6673436.0 |
| 2005-10-04 10:05:00 | AAPL | Stock | 1.9596 | 1.96 | 1.9554 | 1.9589 | 5906600.0 |
| 2005-10-04 10:10:00 | AAPL | Stock | 1.9589 | 1.9661 | 1.9586 | 1.9654 | 16808764.0 |
| 2005-10-04 10:15:00 | AAPL | Stock | 1.9654 | 1.9654 | 1.9607 | 1.9632 | 10350368.0 |
| 2005-10-04 10:20:00 | AAPL | Stock | 1.9632 | 1.9729 | 1.9614 | 1.9725 | 14022764.0 |
| 2005-10-04 10:25:00 | AAPL | Stock | 1.9725 | 1.9764 | 1.9589 | 1.975 | 15198764.0 |
| 2005-10-04 10:30:00 | AAPL | Stock | 1.9754 | 1.9768 | 1.9686 | 1.9714 | 12003460.0 |
| 2005-10-04 10:35:00 | AAPL | Stock | 1.9711 | 1.9732 | 1.9686 | 1.9707 | 7259448.0 |
| 2005-10-04 10:40:00 | AAPL | Stock | 1.9704 | 1.9714 | 1.9686 | 1.9711 | 4856096.0 |
| 2005-10-04 10:45:00 | AAPL | Stock | 1.9711 | 1.9725 | 1.97 | 1.9707 | 4100152.0 |
| 2005-10-04 10:50:00 | AAPL | Stock | 1.9711 | 1.9721 | 1.9696 | 1.9718 | 4976888.0 |
| 2005-10-04 10:55:00 | AAPL | Stock | 1.9718 | 1.9729 | 1.97 | 1.9707 | 4963028.0 |
| 2005-10-04 11:00:00 | AAPL | Stock | 1.9707 | 1.9725 | 1.9664 | 1.9675 | 6721484.0 |
| 2005-10-04 11:05:00 | AAPL | Stock | 1.9675 | 1.9704 | 1.9661 | 1.9661 | 3986444.0 |
| 2005-10-04 11:10:00 | AAPL | Stock | 1.9661 | 1.9725 | 1.9625 | 1.9636 | 10829336.0 |
| 2005-10-04 11:15:00 | AAPL | Stock | 1.9636 | 1.9643 | 1.9579 | 1.9607 | 9184308.0 |
| 2005-10-04 11:20:00 | AAPL | Stock | 1.9607 | 1.9629 | 1.9596 | 1.9618 | 6540744.0 |
| 2005-10-04 11:25:00 | AAPL | Stock | 1.9611 | 1.9696 | 1.9611 | 1.9696 | 7725844.0 |
| 2005-10-04 11:30:00 | AAPL | Stock | 1.9693 | 1.9714 | 1.9679 | 1.9696 | 6348048.0 |
| 2005-10-04 11:35:00 | AAPL | Stock | 1.9696 | 1.9721 | 1.9679 | 1.9721 | 4400620.0 |
| 2005-10-04 11:40:00 | AAPL | Stock | 1.9721 | 1.9721 | 1.9696 | 1.9696 | 2742292.0 |
| 2005-10-04 11:45:00 | AAPL | Stock | 1.9704 | 1.9711 | 1.9693 | 1.9707 | 2965844.0 |
| 2005-10-04 11:50:00 | AAPL | Stock | 1.9707 | 1.9714 | 1.9693 | 1.9693 | 2402736.0 |
| 2005-10-04 11:55:00 | AAPL | Stock | 1.9696 | 1.9729 | 1.9693 | 1.9718 | 5059040.0 |
| 2005-10-04 12:00:00 | AAPL | Stock | 1.9718 | 1.9732 | 1.9704 | 1.9707 | 2721936.0 |
| 2005-10-04 12:05:00 | AAPL | Stock | 1.9707 | 1.9714 | 1.9693 | 1.9714 | 1915844.0 |
> showing 50 of 207,784 rows — these rows as CSV