PREVIEW / stock_5min / 2006-01-11
file: by_date/stock_5min/2006/2006-01-11.parquet size: 3.0 MB rows: 218,985 symbols: 2,169
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-01-11 04:45:00 | AAPL | Stock | 2.9089 | 2.9089 | 2.9089 | 2.9089 | 8400.0 |
| 2006-01-11 04:50:00 | AAPL | Stock | 2.9107 | 2.9107 | 2.9107 | 2.9107 | 70000.0 |
| 2006-01-11 05:25:00 | AAPL | Stock | 2.9143 | 2.9161 | 2.9143 | 2.9143 | 120400.0 |
| 2006-01-11 05:40:00 | AAPL | Stock | 2.9143 | 2.9143 | 2.9143 | 2.9143 | 3696.0 |
| 2006-01-11 06:00:00 | AAPL | Stock | 2.9161 | 2.9161 | 2.9111 | 2.9111 | 86800.0 |
| 2006-01-11 06:40:00 | AAPL | Stock | 2.9232 | 2.9232 | 2.9232 | 2.9232 | 8400.0 |
| 2006-01-11 07:00:00 | AAPL | Stock | 2.9232 | 2.9357 | 2.9232 | 2.9357 | 313600.0 |
| 2006-01-11 07:05:00 | AAPL | Stock | 2.9321 | 2.9357 | 2.9321 | 2.935 | 106400.0 |
| 2006-01-11 07:15:00 | AAPL | Stock | 2.9364 | 2.9364 | 2.9321 | 2.9357 | 148400.0 |
| 2006-01-11 07:20:00 | AAPL | Stock | 2.9296 | 2.9346 | 2.9296 | 2.9346 | 30800.0 |
| 2006-01-11 07:25:00 | AAPL | Stock | 2.9304 | 2.9339 | 2.9268 | 2.9268 | 42000.0 |
| 2006-01-11 07:30:00 | AAPL | Stock | 2.9286 | 2.9286 | 2.9268 | 2.9268 | 19600.0 |
| 2006-01-11 07:35:00 | AAPL | Stock | 2.9286 | 2.9339 | 2.9286 | 2.9304 | 124236.0 |
| 2006-01-11 07:40:00 | AAPL | Stock | 2.9304 | 2.9339 | 2.9304 | 2.9321 | 84000.0 |
| 2006-01-11 07:45:00 | AAPL | Stock | 2.9321 | 2.9321 | 2.9321 | 2.9321 | 42000.0 |
| 2006-01-11 07:55:00 | AAPL | Stock | 2.925 | 2.925 | 2.925 | 2.925 | 36400.0 |
| 2006-01-11 08:00:00 | AAPL | Stock | 2.9286 | 2.9525 | 2.9271 | 2.9482 | 9197916.0 |
| 2006-01-11 08:05:00 | AAPL | Stock | 2.9482 | 2.9564 | 2.9454 | 2.9525 | 3863216.0 |
| 2006-01-11 08:10:00 | AAPL | Stock | 2.9525 | 2.9682 | 2.9525 | 2.9657 | 6074488.0 |
| 2006-01-11 08:15:00 | AAPL | Stock | 2.9671 | 2.9811 | 2.9657 | 2.9793 | 6332984.0 |
| 2006-01-11 08:20:00 | AAPL | Stock | 2.9804 | 2.9929 | 2.9782 | 2.9886 | 6472760.0 |
| 2006-01-11 08:25:00 | AAPL | Stock | 2.9886 | 3.0018 | 2.9875 | 3.0007 | 5926928.0 |
| 2006-01-11 08:30:00 | AAPL | Stock | 3.0011 | 3.0057 | 2.9861 | 2.9893 | 7385140.0 |
| 2006-01-11 08:35:00 | AAPL | Stock | 2.9907 | 2.9911 | 2.9786 | 2.9814 | 4131204.0 |
| 2006-01-11 08:40:00 | AAPL | Stock | 2.9804 | 2.9836 | 2.9736 | 2.9821 | 3596852.0 |
| 2006-01-11 08:45:00 | AAPL | Stock | 2.9818 | 2.985 | 2.9761 | 2.9764 | 1624476.0 |
| 2006-01-11 08:50:00 | AAPL | Stock | 2.9754 | 2.9871 | 2.975 | 2.9857 | 2532292.0 |
| 2006-01-11 08:55:00 | AAPL | Stock | 2.9857 | 2.9882 | 2.9793 | 2.9804 | 1980440.0 |
| 2006-01-11 09:00:00 | AAPL | Stock | 2.9796 | 2.9807 | 2.9721 | 2.9789 | 2206316.0 |
| 2006-01-11 09:05:00 | AAPL | Stock | 2.9789 | 2.9882 | 2.9768 | 2.9875 | 2130800.0 |
| 2006-01-11 09:10:00 | AAPL | Stock | 2.9882 | 2.9907 | 2.9864 | 2.9907 | 1386056.0 |
| 2006-01-11 09:15:00 | AAPL | Stock | 2.9896 | 2.9896 | 2.985 | 2.9879 | 1159956.0 |
| 2006-01-11 09:20:00 | AAPL | Stock | 2.9882 | 2.9936 | 2.9871 | 2.9932 | 2126544.0 |
| 2006-01-11 09:25:00 | AAPL | Stock | 2.9932 | 3.0 | 2.9868 | 2.9946 | 9672516.0 |
| 2006-01-11 09:30:00 | AAPL | Stock | 2.9946 | 2.9971 | 2.97 | 2.9743 | 92236424.0 |
| 2006-01-11 09:35:00 | AAPL | Stock | 2.9746 | 2.9929 | 2.9596 | 2.965 | 57656480.0 |
| 2006-01-11 09:40:00 | AAPL | Stock | 2.965 | 2.9825 | 2.9639 | 2.9818 | 51484552.0 |
| 2006-01-11 09:45:00 | AAPL | Stock | 2.9814 | 2.9868 | 2.9732 | 2.9857 | 43311324.0 |
| 2006-01-11 09:50:00 | AAPL | Stock | 2.985 | 2.9936 | 2.98 | 2.9925 | 40297320.0 |
| 2006-01-11 09:55:00 | AAPL | Stock | 2.9921 | 2.9927 | 2.9829 | 2.9857 | 31892112.0 |
| 2006-01-11 10:00:00 | AAPL | Stock | 2.9857 | 2.9886 | 2.975 | 2.9796 | 29016512.0 |
| 2006-01-11 10:05:00 | AAPL | Stock | 2.9804 | 2.9836 | 2.9746 | 2.98 | 24538556.0 |
| 2006-01-11 10:10:00 | AAPL | Stock | 2.9796 | 2.9893 | 2.9775 | 2.9821 | 27011208.0 |
| 2006-01-11 10:15:00 | AAPL | Stock | 2.9818 | 2.9839 | 2.9711 | 2.9768 | 27148604.0 |
| 2006-01-11 10:20:00 | AAPL | Stock | 2.9764 | 2.9814 | 2.9736 | 2.9786 | 20830208.0 |
| 2006-01-11 10:25:00 | AAPL | Stock | 2.9789 | 2.9789 | 2.9689 | 2.9732 | 23435076.0 |
| 2006-01-11 10:30:00 | AAPL | Stock | 2.9732 | 2.9786 | 2.9679 | 2.97 | 25720912.0 |
| 2006-01-11 10:35:00 | AAPL | Stock | 2.9707 | 2.9739 | 2.9675 | 2.9718 | 26339180.0 |
| 2006-01-11 10:40:00 | AAPL | Stock | 2.9721 | 2.9754 | 2.9618 | 2.9667 | 25466476.0 |
| 2006-01-11 10:45:00 | AAPL | Stock | 2.9668 | 2.9679 | 2.9518 | 2.96 | 32720436.0 |
> showing 50 of 218,985 rows — these rows as CSV