PREVIEW / stock_5min / 2004-10-28
file: by_date/stock_5min/2004/2004-10-28.parquet size: 2.5 MB rows: 179,735 symbols: 1,853
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-28 08:00:00 | AAPL | Stock | 0.8955 | 0.8955 | 0.8955 | 0.8955 | 50344.0 |
| 2004-10-28 08:15:00 | AAPL | Stock | 0.8955 | 0.8955 | 0.8936 | 0.8936 | 33600.0 |
| 2004-10-28 08:20:00 | AAPL | Stock | 0.8939 | 0.8939 | 0.8939 | 0.8939 | 44800.0 |
| 2004-10-28 08:25:00 | AAPL | Stock | 0.8938 | 0.8946 | 0.8938 | 0.8946 | 22344.0 |
| 2004-10-28 08:35:00 | AAPL | Stock | 0.8945 | 0.8957 | 0.8945 | 0.8957 | 100800.0 |
| 2004-10-28 08:40:00 | AAPL | Stock | 0.8941 | 0.8941 | 0.8938 | 0.8938 | 11200.0 |
| 2004-10-28 08:45:00 | AAPL | Stock | 0.8957 | 0.8957 | 0.8938 | 0.8938 | 44800.0 |
| 2004-10-28 08:50:00 | AAPL | Stock | 0.8939 | 0.8946 | 0.8939 | 0.8946 | 78400.0 |
| 2004-10-28 08:55:00 | AAPL | Stock | 0.8946 | 0.8955 | 0.8946 | 0.895 | 22400.0 |
| 2004-10-28 09:00:00 | AAPL | Stock | 0.8961 | 0.8961 | 0.8961 | 0.8961 | 5600.0 |
| 2004-10-28 09:05:00 | AAPL | Stock | 0.8961 | 0.8961 | 0.8961 | 0.8961 | 39200.0 |
| 2004-10-28 09:10:00 | AAPL | Stock | 0.8946 | 0.8961 | 0.8946 | 0.8961 | 50400.0 |
| 2004-10-28 09:20:00 | AAPL | Stock | 0.8946 | 0.8946 | 0.8946 | 0.8946 | 28000.0 |
| 2004-10-28 09:25:00 | AAPL | Stock | 0.8977 | 0.898 | 0.8905 | 0.8916 | 2438128.0 |
| 2004-10-28 09:30:00 | AAPL | Stock | 0.8925 | 0.8929 | 0.8839 | 0.8923 | 21877352.0 |
| 2004-10-28 09:35:00 | AAPL | Stock | 0.8923 | 0.8925 | 0.8884 | 0.8888 | 13876800.0 |
| 2004-10-28 09:40:00 | AAPL | Stock | 0.8888 | 0.89 | 0.8866 | 0.8898 | 12064976.0 |
| 2004-10-28 09:45:00 | AAPL | Stock | 0.89 | 0.8921 | 0.8891 | 0.8916 | 10927392.0 |
| 2004-10-28 09:50:00 | AAPL | Stock | 0.8914 | 0.8961 | 0.8911 | 0.8955 | 18979016.0 |
| 2004-10-28 09:55:00 | AAPL | Stock | 0.895 | 0.9 | 0.8948 | 0.8996 | 19102328.0 |
| 2004-10-28 10:00:00 | AAPL | Stock | 0.8996 | 0.9029 | 0.8982 | 0.9023 | 18445448.0 |
| 2004-10-28 10:05:00 | AAPL | Stock | 0.9023 | 0.9041 | 0.8973 | 0.8977 | 12617304.0 |
| 2004-10-28 10:10:00 | AAPL | Stock | 0.8977 | 0.898 | 0.8952 | 0.8975 | 9864064.0 |
| 2004-10-28 10:15:00 | AAPL | Stock | 0.8977 | 0.8995 | 0.8957 | 0.8963 | 8392328.0 |
| 2004-10-28 10:20:00 | AAPL | Stock | 0.8963 | 0.8993 | 0.8963 | 0.8982 | 10899616.0 |
| 2004-10-28 10:25:00 | AAPL | Stock | 0.8984 | 0.9011 | 0.8979 | 0.8993 | 7743960.0 |
| 2004-10-28 10:30:00 | AAPL | Stock | 0.8993 | 0.8996 | 0.8971 | 0.898 | 8916096.0 |
| 2004-10-28 10:35:00 | AAPL | Stock | 0.898 | 0.898 | 0.8927 | 0.8943 | 9264248.0 |
| 2004-10-28 10:40:00 | AAPL | Stock | 0.8941 | 0.8963 | 0.8939 | 0.8963 | 6071576.0 |
| 2004-10-28 10:45:00 | AAPL | Stock | 0.8963 | 0.8982 | 0.8963 | 0.8982 | 5957112.0 |
| 2004-10-28 10:50:00 | AAPL | Stock | 0.8982 | 0.8982 | 0.8966 | 0.8968 | 9487296.0 |
| 2004-10-28 10:55:00 | AAPL | Stock | 0.8964 | 0.8974 | 0.8954 | 0.8971 | 8758288.0 |
| 2004-10-28 11:00:00 | AAPL | Stock | 0.8971 | 0.8993 | 0.8968 | 0.898 | 6611752.0 |
| 2004-10-28 11:05:00 | AAPL | Stock | 0.898 | 0.8986 | 0.897 | 0.8973 | 5750976.0 |
| 2004-10-28 11:10:00 | AAPL | Stock | 0.8971 | 0.9 | 0.8966 | 0.8996 | 6917456.0 |
| 2004-10-28 11:15:00 | AAPL | Stock | 0.8995 | 0.9 | 0.898 | 0.8993 | 9014320.0 |
| 2004-10-28 11:20:00 | AAPL | Stock | 0.8993 | 0.8998 | 0.898 | 0.8993 | 6434848.0 |
| 2004-10-28 11:25:00 | AAPL | Stock | 0.8995 | 0.9018 | 0.8989 | 0.9018 | 5529720.0 |
| 2004-10-28 11:30:00 | AAPL | Stock | 0.9013 | 0.902 | 0.9007 | 0.9016 | 6657728.0 |
| 2004-10-28 11:35:00 | AAPL | Stock | 0.902 | 0.9027 | 0.8989 | 0.9018 | 8477560.0 |
| 2004-10-28 11:40:00 | AAPL | Stock | 0.9018 | 0.9032 | 0.9016 | 0.902 | 5534368.0 |
| 2004-10-28 11:45:00 | AAPL | Stock | 0.9018 | 0.907 | 0.9016 | 0.9059 | 13453216.0 |
| 2004-10-28 11:50:00 | AAPL | Stock | 0.9059 | 0.9068 | 0.9025 | 0.9043 | 17442824.0 |
| 2004-10-28 11:55:00 | AAPL | Stock | 0.9046 | 0.9054 | 0.9036 | 0.9048 | 8876000.0 |
| 2004-10-28 12:00:00 | AAPL | Stock | 0.905 | 0.9054 | 0.9036 | 0.9043 | 6256824.0 |
| 2004-10-28 12:05:00 | AAPL | Stock | 0.9046 | 0.9063 | 0.9043 | 0.9043 | 8834896.0 |
| 2004-10-28 12:10:00 | AAPL | Stock | 0.9045 | 0.9075 | 0.903 | 0.9066 | 11153632.0 |
| 2004-10-28 12:15:00 | AAPL | Stock | 0.9066 | 0.907 | 0.9054 | 0.9054 | 7302568.0 |
| 2004-10-28 12:20:00 | AAPL | Stock | 0.9052 | 0.9055 | 0.9046 | 0.905 | 5693744.0 |
| 2004-10-28 12:25:00 | AAPL | Stock | 0.9048 | 0.9054 | 0.9036 | 0.9043 | 6468784.0 |
> showing 50 of 179,735 rows — these rows as CSV