PREVIEW / stock_5min / 2005-10-28
file: by_date/stock_5min/2005/2005-10-28.parquet size: 2.8 MB rows: 201,608 symbols: 2,097
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-28 08:00:00 | AAPL | Stock | 1.9821 | 1.9893 | 1.9821 | 1.9871 | 58800.0 |
| 2005-10-28 08:05:00 | AAPL | Stock | 1.9864 | 1.9864 | 1.9864 | 1.9864 | 16800.0 |
| 2005-10-28 08:10:00 | AAPL | Stock | 1.9857 | 1.9857 | 1.9857 | 1.9857 | 70000.0 |
| 2005-10-28 08:15:00 | AAPL | Stock | 1.9857 | 1.9857 | 1.9857 | 1.9857 | 32200.0 |
| 2005-10-28 08:20:00 | AAPL | Stock | 1.9857 | 1.9875 | 1.9857 | 1.9875 | 43736.0 |
| 2005-10-28 08:25:00 | AAPL | Stock | 1.9882 | 1.9893 | 1.9864 | 1.9864 | 28000.0 |
| 2005-10-28 08:30:00 | AAPL | Stock | 1.9879 | 1.9882 | 1.9864 | 1.9864 | 70000.0 |
| 2005-10-28 08:35:00 | AAPL | Stock | 1.9882 | 1.9911 | 1.9882 | 1.9889 | 300804.0 |
| 2005-10-28 08:40:00 | AAPL | Stock | 1.9921 | 1.9929 | 1.9893 | 1.9893 | 57400.0 |
| 2005-10-28 08:45:00 | AAPL | Stock | 1.9893 | 1.99 | 1.9879 | 1.99 | 70700.0 |
| 2005-10-28 08:50:00 | AAPL | Stock | 1.99 | 1.99 | 1.9875 | 1.9875 | 33600.0 |
| 2005-10-28 08:55:00 | AAPL | Stock | 1.9871 | 1.9871 | 1.9857 | 1.9857 | 43064.0 |
| 2005-10-28 09:00:00 | AAPL | Stock | 1.9875 | 1.9929 | 1.9864 | 1.9929 | 144200.0 |
| 2005-10-28 09:05:00 | AAPL | Stock | 1.9925 | 1.9946 | 1.9893 | 1.9893 | 349160.0 |
| 2005-10-28 09:10:00 | AAPL | Stock | 1.9932 | 1.9932 | 1.9889 | 1.9889 | 114800.0 |
| 2005-10-28 09:15:00 | AAPL | Stock | 1.9889 | 1.9982 | 1.9889 | 1.9964 | 39200.0 |
| 2005-10-28 09:20:00 | AAPL | Stock | 1.9946 | 1.9964 | 1.9907 | 1.9954 | 142800.0 |
| 2005-10-28 09:25:00 | AAPL | Stock | 1.9954 | 2.0014 | 1.9939 | 2.0 | 1943956.0 |
| 2005-10-28 09:30:00 | AAPL | Stock | 2.0014 | 2.0054 | 1.9943 | 2.0046 | 17953712.0 |
| 2005-10-28 09:35:00 | AAPL | Stock | 2.0046 | 2.0132 | 2.0032 | 2.0107 | 13624268.0 |
| 2005-10-28 09:40:00 | AAPL | Stock | 2.0107 | 2.0154 | 2.0054 | 2.0071 | 9494632.0 |
| 2005-10-28 09:45:00 | AAPL | Stock | 2.0071 | 2.0079 | 2.0029 | 2.0046 | 11507412.0 |
| 2005-10-28 09:50:00 | AAPL | Stock | 2.005 | 2.0125 | 2.0025 | 2.0046 | 13210596.0 |
| 2005-10-28 09:55:00 | AAPL | Stock | 2.005 | 2.0061 | 2.0025 | 2.0036 | 5607868.0 |
| 2005-10-28 10:00:00 | AAPL | Stock | 2.0036 | 2.0061 | 1.9993 | 2.0039 | 7215880.0 |
| 2005-10-28 10:05:00 | AAPL | Stock | 2.0039 | 2.0064 | 2.0 | 2.0007 | 4443012.0 |
| 2005-10-28 10:10:00 | AAPL | Stock | 2.0004 | 2.0054 | 1.9968 | 2.0029 | 8720432.0 |
| 2005-10-28 10:15:00 | AAPL | Stock | 2.0029 | 2.0054 | 2.0021 | 2.0032 | 8364244.0 |
| 2005-10-28 10:20:00 | AAPL | Stock | 2.0032 | 2.0039 | 1.9946 | 1.9946 | 10470572.0 |
| 2005-10-28 10:25:00 | AAPL | Stock | 1.9946 | 2.0061 | 1.9946 | 1.9957 | 10543568.0 |
| 2005-10-28 10:30:00 | AAPL | Stock | 1.9957 | 1.9961 | 1.9643 | 1.9707 | 27920396.0 |
| 2005-10-28 10:35:00 | AAPL | Stock | 1.9707 | 1.9732 | 1.9404 | 1.9457 | 30051420.0 |
| 2005-10-28 10:40:00 | AAPL | Stock | 1.9461 | 1.9654 | 1.9456 | 1.9561 | 25693108.0 |
| 2005-10-28 10:45:00 | AAPL | Stock | 1.9564 | 1.9575 | 1.9368 | 1.9464 | 22634388.0 |
| 2005-10-28 10:50:00 | AAPL | Stock | 1.9458 | 1.9546 | 1.9396 | 1.9536 | 15679216.0 |
| 2005-10-28 10:55:00 | AAPL | Stock | 1.9532 | 1.9554 | 1.9457 | 1.9518 | 10133732.0 |
| 2005-10-28 11:00:00 | AAPL | Stock | 1.9521 | 1.9625 | 1.9518 | 1.9579 | 11571308.0 |
| 2005-10-28 11:05:00 | AAPL | Stock | 1.9575 | 1.9607 | 1.9532 | 1.9543 | 9430736.0 |
| 2005-10-28 11:10:00 | AAPL | Stock | 1.9543 | 1.9632 | 1.9543 | 1.9607 | 9524060.0 |
| 2005-10-28 11:15:00 | AAPL | Stock | 1.9607 | 1.9646 | 1.9582 | 1.9636 | 10038028.0 |
| 2005-10-28 11:20:00 | AAPL | Stock | 1.9625 | 1.9643 | 1.9571 | 1.9624 | 7543732.0 |
| 2005-10-28 11:25:00 | AAPL | Stock | 1.9618 | 1.9686 | 1.96 | 1.9671 | 11982068.0 |
| 2005-10-28 11:30:00 | AAPL | Stock | 1.9675 | 1.9693 | 1.9625 | 1.9643 | 6147680.0 |
| 2005-10-28 11:35:00 | AAPL | Stock | 1.965 | 1.9682 | 1.9629 | 1.9679 | 3472196.0 |
| 2005-10-28 11:40:00 | AAPL | Stock | 1.9679 | 1.9721 | 1.9654 | 1.9704 | 7883540.0 |
| 2005-10-28 11:45:00 | AAPL | Stock | 1.9704 | 1.9821 | 1.9696 | 1.9818 | 15430324.0 |
| 2005-10-28 11:50:00 | AAPL | Stock | 1.9818 | 1.9821 | 1.9757 | 1.9786 | 10006556.0 |
| 2005-10-28 11:55:00 | AAPL | Stock | 1.9785 | 1.9907 | 1.9771 | 1.9882 | 13405840.0 |
| 2005-10-28 12:00:00 | AAPL | Stock | 1.9886 | 1.9914 | 1.9868 | 1.9889 | 9153732.0 |
| 2005-10-28 12:05:00 | AAPL | Stock | 1.9893 | 1.9893 | 1.9818 | 1.9832 | 9124948.0 |
> showing 50 of 201,608 rows — these rows as CSV