PREVIEW / stock_5min / 2005-09-30
file: by_date/stock_5min/2005/2005-09-30.parquet size: 2.8 MB rows: 202,894 symbols: 2,089
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-09-30 08:00:00 | AAPL | Stock | 1.8696 | 1.8696 | 1.8696 | 1.8696 | 5600.0 |
| 2005-09-30 08:05:00 | AAPL | Stock | 1.8696 | 1.8696 | 1.8696 | 1.8696 | 61600.0 |
| 2005-09-30 08:10:00 | AAPL | Stock | 1.8696 | 1.8696 | 1.8696 | 1.8696 | 28000.0 |
| 2005-09-30 08:15:00 | AAPL | Stock | 1.8711 | 1.8711 | 1.8711 | 1.8711 | 10640.0 |
| 2005-09-30 08:35:00 | AAPL | Stock | 1.8679 | 1.8679 | 1.8646 | 1.8661 | 50400.0 |
| 2005-09-30 08:40:00 | AAPL | Stock | 1.8675 | 1.8675 | 1.8639 | 1.8639 | 24360.0 |
| 2005-09-30 08:45:00 | AAPL | Stock | 1.8693 | 1.8693 | 1.8693 | 1.8693 | 8400.0 |
| 2005-09-30 08:55:00 | AAPL | Stock | 1.8693 | 1.8693 | 1.8693 | 1.8693 | 18284.0 |
| 2005-09-30 09:05:00 | AAPL | Stock | 1.8686 | 1.8686 | 1.8686 | 1.8686 | 42000.0 |
| 2005-09-30 09:10:00 | AAPL | Stock | 1.8679 | 1.8693 | 1.8675 | 1.8693 | 33600.0 |
| 2005-09-30 09:15:00 | AAPL | Stock | 1.8675 | 1.8675 | 1.8675 | 1.8675 | 11060.0 |
| 2005-09-30 09:20:00 | AAPL | Stock | 1.8675 | 1.8675 | 1.8675 | 1.8675 | 5740.0 |
| 2005-09-30 09:25:00 | AAPL | Stock | 1.8671 | 1.87 | 1.8668 | 1.8671 | 145040.0 |
| 2005-09-30 09:30:00 | AAPL | Stock | 1.8689 | 1.8736 | 1.8682 | 1.8689 | 8610000.0 |
| 2005-09-30 09:35:00 | AAPL | Stock | 1.8693 | 1.875 | 1.8693 | 1.87 | 9050636.0 |
| 2005-09-30 09:40:00 | AAPL | Stock | 1.87 | 1.87 | 1.8607 | 1.8621 | 10828244.0 |
| 2005-09-30 09:45:00 | AAPL | Stock | 1.8621 | 1.8629 | 1.8529 | 1.8568 | 12398456.0 |
| 2005-09-30 09:50:00 | AAPL | Stock | 1.8564 | 1.8604 | 1.8536 | 1.8582 | 11364864.0 |
| 2005-09-30 09:55:00 | AAPL | Stock | 1.8579 | 1.8671 | 1.857 | 1.8671 | 10159240.0 |
| 2005-09-30 10:00:00 | AAPL | Stock | 1.8671 | 1.8729 | 1.8639 | 1.8721 | 12269740.0 |
| 2005-09-30 10:05:00 | AAPL | Stock | 1.8718 | 1.8889 | 1.8718 | 1.8825 | 17256596.0 |
| 2005-09-30 10:10:00 | AAPL | Stock | 1.8832 | 1.8918 | 1.8811 | 1.8907 | 11753308.0 |
| 2005-09-30 10:15:00 | AAPL | Stock | 1.8904 | 1.8921 | 1.8857 | 1.8893 | 10352104.0 |
| 2005-09-30 10:20:00 | AAPL | Stock | 1.8889 | 1.8979 | 1.8875 | 1.8957 | 11048324.0 |
| 2005-09-30 10:25:00 | AAPL | Stock | 1.8954 | 1.8975 | 1.8893 | 1.8939 | 7905184.0 |
| 2005-09-30 10:30:00 | AAPL | Stock | 1.8939 | 1.8971 | 1.8921 | 1.8921 | 8848028.0 |
| 2005-09-30 10:35:00 | AAPL | Stock | 1.8921 | 1.8961 | 1.8893 | 1.8939 | 6870780.0 |
| 2005-09-30 10:40:00 | AAPL | Stock | 1.8939 | 1.8961 | 1.8907 | 1.8957 | 7046928.0 |
| 2005-09-30 10:45:00 | AAPL | Stock | 1.8957 | 1.8996 | 1.8929 | 1.895 | 7123116.0 |
| 2005-09-30 10:50:00 | AAPL | Stock | 1.895 | 1.9018 | 1.8943 | 1.9014 | 7727888.0 |
| 2005-09-30 10:55:00 | AAPL | Stock | 1.9011 | 1.9025 | 1.8982 | 1.9 | 7239288.0 |
| 2005-09-30 11:00:00 | AAPL | Stock | 1.9004 | 1.9054 | 1.8979 | 1.9039 | 8409296.0 |
| 2005-09-30 11:05:00 | AAPL | Stock | 1.9039 | 1.9064 | 1.9018 | 1.9061 | 7025788.0 |
| 2005-09-30 11:10:00 | AAPL | Stock | 1.9064 | 1.9071 | 1.9036 | 1.9039 | 5585776.0 |
| 2005-09-30 11:15:00 | AAPL | Stock | 1.9036 | 1.9061 | 1.9018 | 1.9054 | 3905412.0 |
| 2005-09-30 11:20:00 | AAPL | Stock | 1.9054 | 1.9054 | 1.8957 | 1.8957 | 6556620.0 |
| 2005-09-30 11:25:00 | AAPL | Stock | 1.8954 | 1.9 | 1.8925 | 1.8942 | 7778064.0 |
| 2005-09-30 11:30:00 | AAPL | Stock | 1.8945 | 1.8989 | 1.8943 | 1.8968 | 5932304.0 |
| 2005-09-30 11:35:00 | AAPL | Stock | 1.8968 | 1.8979 | 1.8939 | 1.8946 | 2916004.0 |
| 2005-09-30 11:40:00 | AAPL | Stock | 1.8946 | 1.8975 | 1.8936 | 1.8971 | 3189508.0 |
| 2005-09-30 11:45:00 | AAPL | Stock | 1.8968 | 1.8968 | 1.8932 | 1.8943 | 5123888.0 |
| 2005-09-30 11:50:00 | AAPL | Stock | 1.8939 | 1.8939 | 1.8882 | 1.8914 | 7362292.0 |
| 2005-09-30 11:55:00 | AAPL | Stock | 1.8914 | 1.8946 | 1.8907 | 1.8943 | 3875984.0 |
| 2005-09-30 12:00:00 | AAPL | Stock | 1.8943 | 1.8982 | 1.8932 | 1.8979 | 4766384.0 |
| 2005-09-30 12:05:00 | AAPL | Stock | 1.8979 | 1.9043 | 1.8968 | 1.9039 | 8171856.0 |
| 2005-09-30 12:10:00 | AAPL | Stock | 1.9039 | 1.9046 | 1.9011 | 1.9036 | 8699880.0 |
| 2005-09-30 12:15:00 | AAPL | Stock | 1.9032 | 1.9079 | 1.9032 | 1.9064 | 5308100.0 |
| 2005-09-30 12:20:00 | AAPL | Stock | 1.9061 | 1.9061 | 1.9011 | 1.9032 | 2835280.0 |
| 2005-09-30 12:25:00 | AAPL | Stock | 1.9035 | 1.905 | 1.9032 | 1.9039 | 1453592.0 |
| 2005-09-30 12:30:00 | AAPL | Stock | 1.9043 | 1.9046 | 1.9036 | 1.9043 | 4467008.0 |
> showing 50 of 202,894 rows — these rows as CSV