PREVIEW / stock_5min / 2006-07-07
file: by_date/stock_5min/2006/2006-07-07.parquet size: 3.1 MB rows: 225,120 symbols: 2,304
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-07 08:00:00 | AAPL | Stock | 2.0014 | 2.0014 | 1.9886 | 1.9932 | 56000.0 |
| 2006-07-07 08:05:00 | AAPL | Stock | 1.9904 | 1.9932 | 1.9893 | 1.9932 | 70000.0 |
| 2006-07-07 08:10:00 | AAPL | Stock | 1.9896 | 1.9943 | 1.9896 | 1.9904 | 221816.0 |
| 2006-07-07 08:15:00 | AAPL | Stock | 1.9911 | 1.9911 | 1.9911 | 1.9911 | 8400.0 |
| 2006-07-07 08:20:00 | AAPL | Stock | 1.9904 | 1.9939 | 1.9904 | 1.9911 | 189000.0 |
| 2006-07-07 08:25:00 | AAPL | Stock | 1.9911 | 1.9929 | 1.9911 | 1.9929 | 106400.0 |
| 2006-07-07 08:30:00 | AAPL | Stock | 1.9954 | 2.005 | 1.9918 | 1.995 | 526848.0 |
| 2006-07-07 08:35:00 | AAPL | Stock | 1.9954 | 1.9964 | 1.9943 | 1.9964 | 95620.0 |
| 2006-07-07 08:40:00 | AAPL | Stock | 1.9964 | 1.9964 | 1.9946 | 1.9946 | 187628.0 |
| 2006-07-07 08:45:00 | AAPL | Stock | 1.9954 | 1.9964 | 1.9954 | 1.9964 | 152432.0 |
| 2006-07-07 08:50:00 | AAPL | Stock | 1.9946 | 1.9946 | 1.9911 | 1.9936 | 565572.0 |
| 2006-07-07 08:55:00 | AAPL | Stock | 1.9936 | 1.9954 | 1.9936 | 1.9939 | 131768.0 |
| 2006-07-07 09:00:00 | AAPL | Stock | 1.9936 | 1.9936 | 1.9857 | 1.9857 | 171920.0 |
| 2006-07-07 09:05:00 | AAPL | Stock | 1.9857 | 1.9857 | 1.9832 | 1.9854 | 735672.0 |
| 2006-07-07 09:10:00 | AAPL | Stock | 1.9854 | 1.9857 | 1.9839 | 1.9839 | 434000.0 |
| 2006-07-07 09:15:00 | AAPL | Stock | 1.9839 | 1.9857 | 1.9839 | 1.9857 | 86800.0 |
| 2006-07-07 09:20:00 | AAPL | Stock | 1.9839 | 1.9857 | 1.9839 | 1.9846 | 50400.0 |
| 2006-07-07 09:25:00 | AAPL | Stock | 1.985 | 1.9918 | 1.9821 | 1.9825 | 1863372.0 |
| 2006-07-07 09:30:00 | AAPL | Stock | 1.9814 | 1.9846 | 1.9568 | 1.9575 | 38277904.0 |
| 2006-07-07 09:35:00 | AAPL | Stock | 1.9579 | 1.9846 | 1.9568 | 1.9625 | 23700824.0 |
| 2006-07-07 09:40:00 | AAPL | Stock | 1.9621 | 1.9621 | 1.9525 | 1.9579 | 24070760.0 |
| 2006-07-07 09:45:00 | AAPL | Stock | 1.9582 | 1.9596 | 1.9536 | 1.9582 | 16553852.0 |
| 2006-07-07 09:50:00 | AAPL | Stock | 1.9582 | 1.9668 | 1.955 | 1.9568 | 17318000.0 |
| 2006-07-07 09:55:00 | AAPL | Stock | 1.9571 | 1.9636 | 1.9554 | 1.9636 | 12593784.0 |
| 2006-07-07 10:00:00 | AAPL | Stock | 1.9634 | 1.9636 | 1.9564 | 1.9575 | 10943016.0 |
| 2006-07-07 10:05:00 | AAPL | Stock | 1.9571 | 1.9639 | 1.9568 | 1.9632 | 12862612.0 |
| 2006-07-07 10:10:00 | AAPL | Stock | 1.9632 | 1.9679 | 1.9618 | 1.9636 | 16071944.0 |
| 2006-07-07 10:15:00 | AAPL | Stock | 1.9639 | 1.9729 | 1.9632 | 1.9682 | 16644320.0 |
| 2006-07-07 10:20:00 | AAPL | Stock | 1.9682 | 1.9707 | 1.9646 | 1.9668 | 11651136.0 |
| 2006-07-07 10:25:00 | AAPL | Stock | 1.9671 | 1.9711 | 1.965 | 1.9664 | 6992272.0 |
| 2006-07-07 10:30:00 | AAPL | Stock | 1.9668 | 1.9671 | 1.96 | 1.9614 | 15853124.0 |
| 2006-07-07 10:35:00 | AAPL | Stock | 1.9614 | 1.9629 | 1.9596 | 1.9621 | 6599656.0 |
| 2006-07-07 10:40:00 | AAPL | Stock | 1.9625 | 1.9686 | 1.9621 | 1.9686 | 9849980.0 |
| 2006-07-07 10:45:00 | AAPL | Stock | 1.9689 | 1.9746 | 1.9679 | 1.9711 | 11822636.0 |
| 2006-07-07 10:50:00 | AAPL | Stock | 1.9711 | 1.9764 | 1.9696 | 1.9729 | 11829048.0 |
| 2006-07-07 10:55:00 | AAPL | Stock | 1.9732 | 1.9743 | 1.9679 | 1.9704 | 6687716.0 |
| 2006-07-07 11:00:00 | AAPL | Stock | 1.9704 | 1.9732 | 1.9686 | 1.9711 | 6672652.0 |
| 2006-07-07 11:05:00 | AAPL | Stock | 1.9711 | 1.9757 | 1.9704 | 1.9721 | 5992756.0 |
| 2006-07-07 11:10:00 | AAPL | Stock | 1.9725 | 1.9746 | 1.97 | 1.9714 | 3769052.0 |
| 2006-07-07 11:15:00 | AAPL | Stock | 1.9714 | 1.9729 | 1.9704 | 1.9724 | 2289084.0 |
| 2006-07-07 11:20:00 | AAPL | Stock | 1.9721 | 1.975 | 1.9704 | 1.975 | 3967208.0 |
| 2006-07-07 11:25:00 | AAPL | Stock | 1.975 | 1.9814 | 1.9746 | 1.9807 | 9942940.0 |
| 2006-07-07 11:30:00 | AAPL | Stock | 1.9804 | 1.995 | 1.98 | 1.9918 | 30028152.0 |
| 2006-07-07 11:35:00 | AAPL | Stock | 1.9918 | 1.9982 | 1.9914 | 1.9918 | 16216872.0 |
| 2006-07-07 11:40:00 | AAPL | Stock | 1.9914 | 1.9993 | 1.9875 | 1.9893 | 17620876.0 |
| 2006-07-07 11:45:00 | AAPL | Stock | 1.9889 | 1.995 | 1.9871 | 1.9907 | 8404004.0 |
| 2006-07-07 11:50:00 | AAPL | Stock | 1.9907 | 1.9982 | 1.9879 | 1.9892 | 13181252.0 |
| 2006-07-07 11:55:00 | AAPL | Stock | 1.9889 | 1.9907 | 1.9843 | 1.9896 | 10955084.0 |
| 2006-07-07 12:00:00 | AAPL | Stock | 1.9904 | 1.9932 | 1.9879 | 1.9893 | 6310444.0 |
| 2006-07-07 12:05:00 | AAPL | Stock | 1.9893 | 1.9911 | 1.9846 | 1.9904 | 5566960.0 |
> showing 50 of 225,120 rows — these rows as CSV