PREVIEW / stock_5min / 2007-02-06
file: by_date/stock_5min/2007/2007-02-06.parquet size: 3.4 MB rows: 246,383 symbols: 2,502
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-06 06:45:00 | AAPL | Stock | 3.0089 | 3.0114 | 3.0089 | 3.0114 | 8400.0 |
| 2007-02-06 07:15:00 | AAPL | Stock | 3.0125 | 3.0125 | 3.0114 | 3.0114 | 7560.0 |
| 2007-02-06 07:35:00 | AAPL | Stock | 3.0114 | 3.0114 | 3.0114 | 3.0114 | 5600.0 |
| 2007-02-06 07:50:00 | AAPL | Stock | 3.0121 | 3.0121 | 3.0096 | 3.0096 | 5600.0 |
| 2007-02-06 08:00:00 | AAPL | Stock | 3.0107 | 3.0171 | 3.0036 | 3.0104 | 156016.0 |
| 2007-02-06 08:05:00 | AAPL | Stock | 3.0104 | 3.0104 | 3.0089 | 3.0104 | 93464.0 |
| 2007-02-06 08:10:00 | AAPL | Stock | 3.0104 | 3.0107 | 3.0057 | 3.0079 | 162260.0 |
| 2007-02-06 08:15:00 | AAPL | Stock | 3.0079 | 3.0089 | 3.0079 | 3.0089 | 46900.0 |
| 2007-02-06 08:20:00 | AAPL | Stock | 3.0089 | 3.0107 | 3.0089 | 3.0089 | 53844.0 |
| 2007-02-06 08:25:00 | AAPL | Stock | 3.0104 | 3.0104 | 3.0104 | 3.0104 | 34468.0 |
| 2007-02-06 08:30:00 | AAPL | Stock | 3.0104 | 3.0107 | 3.0104 | 3.0107 | 30408.0 |
| 2007-02-06 08:35:00 | AAPL | Stock | 3.0089 | 3.0132 | 3.0089 | 3.0132 | 217840.0 |
| 2007-02-06 08:40:00 | AAPL | Stock | 3.0125 | 3.0125 | 3.0104 | 3.0104 | 156800.0 |
| 2007-02-06 08:45:00 | AAPL | Stock | 3.0089 | 3.0089 | 3.0043 | 3.0057 | 428400.0 |
| 2007-02-06 08:50:00 | AAPL | Stock | 3.0057 | 3.0082 | 3.0043 | 3.0054 | 184800.0 |
| 2007-02-06 08:55:00 | AAPL | Stock | 3.0054 | 3.0054 | 3.0018 | 3.0036 | 259952.0 |
| 2007-02-06 09:00:00 | AAPL | Stock | 3.0036 | 3.0036 | 3.0018 | 3.0036 | 190764.0 |
| 2007-02-06 09:05:00 | AAPL | Stock | 3.0054 | 3.0071 | 3.0036 | 3.0036 | 136500.0 |
| 2007-02-06 09:10:00 | AAPL | Stock | 3.0036 | 3.0057 | 3.0036 | 3.0054 | 1073100.0 |
| 2007-02-06 09:15:00 | AAPL | Stock | 3.0054 | 3.0089 | 3.0054 | 3.0089 | 84420.0 |
| 2007-02-06 09:20:00 | AAPL | Stock | 3.0079 | 3.0104 | 3.0061 | 3.0104 | 212548.0 |
| 2007-02-06 09:25:00 | AAPL | Stock | 3.0068 | 3.0161 | 3.0068 | 3.0161 | 1553552.0 |
| 2007-02-06 09:30:00 | AAPL | Stock | 3.0161 | 3.0168 | 3.0014 | 3.0014 | 19335204.0 |
| 2007-02-06 09:35:00 | AAPL | Stock | 3.0011 | 3.0071 | 2.9979 | 3.0039 | 12826296.0 |
| 2007-02-06 09:40:00 | AAPL | Stock | 3.0036 | 3.015 | 3.0036 | 3.0057 | 13323016.0 |
| 2007-02-06 09:45:00 | AAPL | Stock | 3.005 | 3.0089 | 3.0021 | 3.0043 | 8294608.0 |
| 2007-02-06 09:50:00 | AAPL | Stock | 3.0043 | 3.0096 | 3.0036 | 3.0046 | 7330820.0 |
| 2007-02-06 09:55:00 | AAPL | Stock | 3.0043 | 3.0054 | 2.9929 | 2.9975 | 18895436.0 |
| 2007-02-06 10:00:00 | AAPL | Stock | 2.9971 | 3.0043 | 2.9929 | 3.0029 | 13341832.0 |
| 2007-02-06 10:05:00 | AAPL | Stock | 3.0029 | 3.0161 | 3.0 | 3.0025 | 11115636.0 |
| 2007-02-06 10:10:00 | AAPL | Stock | 3.0032 | 3.005 | 2.9957 | 3.0021 | 10662960.0 |
| 2007-02-06 10:15:00 | AAPL | Stock | 3.0021 | 3.0021 | 2.9961 | 2.9968 | 11054848.0 |
| 2007-02-06 10:20:00 | AAPL | Stock | 2.9971 | 3.016 | 2.9968 | 3.0018 | 10135552.0 |
| 2007-02-06 10:25:00 | AAPL | Stock | 3.002 | 3.0057 | 2.9982 | 3.0054 | 8600676.0 |
| 2007-02-06 10:30:00 | AAPL | Stock | 3.005 | 3.0057 | 3.0018 | 3.0054 | 6472256.0 |
| 2007-02-06 10:35:00 | AAPL | Stock | 3.0054 | 3.0057 | 2.9993 | 3.0011 | 8114064.0 |
| 2007-02-06 10:40:00 | AAPL | Stock | 3.0007 | 3.0057 | 2.9982 | 2.9989 | 9155076.0 |
| 2007-02-06 10:45:00 | AAPL | Stock | 2.9993 | 2.9996 | 2.9932 | 2.9964 | 11281536.0 |
| 2007-02-06 10:50:00 | AAPL | Stock | 2.9965 | 2.9989 | 2.9811 | 2.9836 | 22330784.0 |
| 2007-02-06 10:55:00 | AAPL | Stock | 2.9836 | 2.9871 | 2.9804 | 2.9814 | 15785924.0 |
| 2007-02-06 11:00:00 | AAPL | Stock | 2.9818 | 2.9886 | 2.9771 | 2.9861 | 16621052.0 |
| 2007-02-06 11:05:00 | AAPL | Stock | 2.9861 | 2.9871 | 2.9825 | 2.984 | 6129648.0 |
| 2007-02-06 11:10:00 | AAPL | Stock | 2.9839 | 2.985 | 2.9793 | 2.9836 | 6659464.0 |
| 2007-02-06 11:15:00 | AAPL | Stock | 2.9832 | 2.9836 | 2.975 | 2.9757 | 9448404.0 |
| 2007-02-06 11:20:00 | AAPL | Stock | 2.9757 | 2.9793 | 2.975 | 2.9761 | 7279020.0 |
| 2007-02-06 11:25:00 | AAPL | Stock | 2.9761 | 2.9789 | 2.9707 | 2.9775 | 17157084.0 |
| 2007-02-06 11:30:00 | AAPL | Stock | 2.9781 | 2.9796 | 2.9743 | 2.9771 | 8711080.0 |
| 2007-02-06 11:35:00 | AAPL | Stock | 2.9771 | 2.9839 | 2.9764 | 2.9821 | 7040460.0 |
| 2007-02-06 11:40:00 | AAPL | Stock | 2.9821 | 3.0039 | 2.9754 | 2.9764 | 7944384.0 |
| 2007-02-06 11:45:00 | AAPL | Stock | 2.9761 | 2.9914 | 2.9682 | 2.9686 | 12040896.0 |
> showing 50 of 246,383 rows — these rows as CSV