PREVIEW / stock_5min / 2004-06-28
file: by_date/stock_5min/2004/2004-06-28.parquet size: 2.5 MB rows: 185,967 symbols: 1,783
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-06-28 08:00:00 | AAPL | Stock | 0.6071 | 0.6116 | 0.6071 | 0.6116 | 159600.0 |
| 2004-06-28 08:05:00 | AAPL | Stock | 0.6121 | 0.6121 | 0.6107 | 0.6116 | 296800.0 |
| 2004-06-28 08:10:00 | AAPL | Stock | 0.608 | 0.608 | 0.608 | 0.608 | 5600.0 |
| 2004-06-28 08:15:00 | AAPL | Stock | 0.6107 | 0.6107 | 0.6107 | 0.6107 | 123200.0 |
| 2004-06-28 08:20:00 | AAPL | Stock | 0.6121 | 0.6127 | 0.608 | 0.6082 | 611520.0 |
| 2004-06-28 08:25:00 | AAPL | Stock | 0.608 | 0.6107 | 0.6071 | 0.6107 | 443520.0 |
| 2004-06-28 08:30:00 | AAPL | Stock | 0.6114 | 0.6114 | 0.6107 | 0.6107 | 140000.0 |
| 2004-06-28 08:35:00 | AAPL | Stock | 0.6107 | 0.6107 | 0.6107 | 0.6107 | 5600.0 |
| 2004-06-28 08:40:00 | AAPL | Stock | 0.6089 | 0.6089 | 0.6089 | 0.6089 | 16800.0 |
| 2004-06-28 08:45:00 | AAPL | Stock | 0.6089 | 0.6089 | 0.6089 | 0.6089 | 28000.0 |
| 2004-06-28 08:50:00 | AAPL | Stock | 0.6077 | 0.6089 | 0.6071 | 0.6089 | 665280.0 |
| 2004-06-28 08:55:00 | AAPL | Stock | 0.6089 | 0.6089 | 0.608 | 0.608 | 16800.0 |
| 2004-06-28 09:00:00 | AAPL | Stock | 0.608 | 0.6098 | 0.608 | 0.6098 | 212800.0 |
| 2004-06-28 09:05:00 | AAPL | Stock | 0.6093 | 0.6093 | 0.6071 | 0.6071 | 481600.0 |
| 2004-06-28 09:10:00 | AAPL | Stock | 0.6075 | 0.6075 | 0.6075 | 0.6075 | 11200.0 |
| 2004-06-28 09:15:00 | AAPL | Stock | 0.6075 | 0.6075 | 0.6071 | 0.6071 | 111944.0 |
| 2004-06-28 09:20:00 | AAPL | Stock | 0.6071 | 0.6077 | 0.6055 | 0.6071 | 588000.0 |
| 2004-06-28 09:25:00 | AAPL | Stock | 0.6071 | 0.608 | 0.5989 | 0.607 | 2715216.0 |
| 2004-06-28 09:30:00 | AAPL | Stock | 0.6054 | 0.6105 | 0.6016 | 0.6046 | 17991792.0 |
| 2004-06-28 09:35:00 | AAPL | Stock | 0.6052 | 0.6054 | 0.5954 | 0.5966 | 15233736.0 |
| 2004-06-28 09:40:00 | AAPL | Stock | 0.5963 | 0.5998 | 0.5955 | 0.5963 | 7540176.0 |
| 2004-06-28 09:45:00 | AAPL | Stock | 0.5963 | 0.5973 | 0.5934 | 0.5963 | 11491312.0 |
| 2004-06-28 09:50:00 | AAPL | Stock | 0.5963 | 0.597 | 0.5911 | 0.5918 | 7804440.0 |
| 2004-06-28 09:55:00 | AAPL | Stock | 0.5916 | 0.5934 | 0.5902 | 0.5925 | 8216432.0 |
| 2004-06-28 10:00:00 | AAPL | Stock | 0.5923 | 0.5945 | 0.592 | 0.5941 | 4549328.0 |
| 2004-06-28 10:05:00 | AAPL | Stock | 0.5941 | 0.5966 | 0.5939 | 0.5961 | 8285480.0 |
| 2004-06-28 10:10:00 | AAPL | Stock | 0.5961 | 0.5979 | 0.5961 | 0.5961 | 4477144.0 |
| 2004-06-28 10:15:00 | AAPL | Stock | 0.5961 | 0.5977 | 0.5954 | 0.5954 | 5069568.0 |
| 2004-06-28 10:20:00 | AAPL | Stock | 0.5954 | 0.5961 | 0.5941 | 0.5941 | 3933216.0 |
| 2004-06-28 10:25:00 | AAPL | Stock | 0.5941 | 0.5948 | 0.5925 | 0.5941 | 3924648.0 |
| 2004-06-28 10:30:00 | AAPL | Stock | 0.5943 | 0.5954 | 0.5934 | 0.5952 | 4745608.0 |
| 2004-06-28 10:35:00 | AAPL | Stock | 0.5952 | 0.5954 | 0.5927 | 0.5945 | 6830376.0 |
| 2004-06-28 10:40:00 | AAPL | Stock | 0.5946 | 0.5946 | 0.5915 | 0.5921 | 5073096.0 |
| 2004-06-28 10:45:00 | AAPL | Stock | 0.592 | 0.5936 | 0.5918 | 0.5925 | 7100800.0 |
| 2004-06-28 10:50:00 | AAPL | Stock | 0.5923 | 0.5927 | 0.5905 | 0.5907 | 9439192.0 |
| 2004-06-28 10:55:00 | AAPL | Stock | 0.5907 | 0.5907 | 0.5871 | 0.5879 | 14249200.0 |
| 2004-06-28 11:00:00 | AAPL | Stock | 0.5879 | 0.588 | 0.5848 | 0.587 | 13674584.0 |
| 2004-06-28 11:05:00 | AAPL | Stock | 0.5871 | 0.5873 | 0.5836 | 0.5861 | 17413704.0 |
| 2004-06-28 11:10:00 | AAPL | Stock | 0.5857 | 0.5866 | 0.5836 | 0.5854 | 12035408.0 |
| 2004-06-28 11:15:00 | AAPL | Stock | 0.5854 | 0.5863 | 0.5852 | 0.5857 | 6517504.0 |
| 2004-06-28 11:20:00 | AAPL | Stock | 0.5857 | 0.5859 | 0.5846 | 0.5854 | 4648168.0 |
| 2004-06-28 11:25:00 | AAPL | Stock | 0.5852 | 0.5871 | 0.5852 | 0.5866 | 4880848.0 |
| 2004-06-28 11:30:00 | AAPL | Stock | 0.5866 | 0.587 | 0.5863 | 0.5864 | 5335232.0 |
| 2004-06-28 11:35:00 | AAPL | Stock | 0.5864 | 0.5864 | 0.5845 | 0.5848 | 5936280.0 |
| 2004-06-28 11:40:00 | AAPL | Stock | 0.5846 | 0.5848 | 0.5841 | 0.5843 | 7152264.0 |
| 2004-06-28 11:45:00 | AAPL | Stock | 0.5845 | 0.5857 | 0.5843 | 0.5857 | 6129648.0 |
| 2004-06-28 11:50:00 | AAPL | Stock | 0.5857 | 0.5875 | 0.5854 | 0.5864 | 3870328.0 |
| 2004-06-28 11:55:00 | AAPL | Stock | 0.5863 | 0.5884 | 0.5859 | 0.5863 | 3384024.0 |
| 2004-06-28 12:00:00 | AAPL | Stock | 0.5863 | 0.5882 | 0.5863 | 0.5875 | 2385936.0 |
| 2004-06-28 12:05:00 | AAPL | Stock | 0.5875 | 0.5884 | 0.587 | 0.5877 | 5204192.0 |
> showing 50 of 185,967 rows — these rows as CSV