PREVIEW / stock_5min / 2007-08-28
file: by_date/stock_5min/2007/2007-08-28.parquet size: 4.0 MB rows: 295,015 symbols: 3,099
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-08-28 09:30:00 | AAPL | Stock | 4.6757 | 4.6879 | 4.6514 | 4.6793 | 29937824.0 |
| 2007-08-28 09:35:00 | AAPL | Stock | 4.6793 | 4.6943 | 4.6736 | 4.6865 | 19894392.0 |
| 2007-08-28 09:40:00 | AAPL | Stock | 4.6861 | 4.6964 | 4.6704 | 4.6889 | 16634632.0 |
| 2007-08-28 09:45:00 | AAPL | Stock | 4.6889 | 4.705 | 4.6839 | 4.6982 | 14062440.0 |
| 2007-08-28 09:50:00 | AAPL | Stock | 4.6982 | 4.7086 | 4.69 | 4.7054 | 14632184.0 |
| 2007-08-28 09:55:00 | AAPL | Stock | 4.705 | 4.7054 | 4.6882 | 4.6979 | 10464468.0 |
| 2007-08-28 10:00:00 | AAPL | Stock | 4.6957 | 4.7257 | 4.6957 | 4.7168 | 26673388.0 |
| 2007-08-28 10:05:00 | AAPL | Stock | 4.7164 | 4.7289 | 4.7054 | 4.72 | 18747792.0 |
| 2007-08-28 10:10:00 | AAPL | Stock | 4.72 | 4.7268 | 4.7121 | 4.7157 | 16122792.0 |
| 2007-08-28 10:15:00 | AAPL | Stock | 4.7149 | 4.7175 | 4.6982 | 4.7057 | 13340628.0 |
| 2007-08-28 10:20:00 | AAPL | Stock | 4.7046 | 4.7075 | 4.6946 | 4.6964 | 11297076.0 |
| 2007-08-28 10:25:00 | AAPL | Stock | 4.7004 | 4.7004 | 4.6875 | 4.6961 | 8581720.0 |
| 2007-08-28 10:30:00 | AAPL | Stock | 4.6961 | 4.6996 | 4.6882 | 4.6936 | 7448560.0 |
| 2007-08-28 10:35:00 | AAPL | Stock | 4.6936 | 4.6979 | 4.6825 | 4.6879 | 10033408.0 |
| 2007-08-28 10:40:00 | AAPL | Stock | 4.6882 | 4.6957 | 4.6871 | 4.69 | 7377944.0 |
| 2007-08-28 10:45:00 | AAPL | Stock | 4.6896 | 4.6929 | 4.6771 | 4.6811 | 15829968.0 |
| 2007-08-28 10:50:00 | AAPL | Stock | 4.6807 | 4.6811 | 4.6627 | 4.6657 | 13823824.0 |
| 2007-08-28 10:55:00 | AAPL | Stock | 4.6661 | 4.6775 | 4.6632 | 4.6725 | 7226128.0 |
| 2007-08-28 11:00:00 | AAPL | Stock | 4.6718 | 4.6725 | 4.6461 | 4.6464 | 18244968.0 |
| 2007-08-28 11:05:00 | AAPL | Stock | 4.6461 | 4.6568 | 4.6446 | 4.6518 | 14346220.0 |
| 2007-08-28 11:10:00 | AAPL | Stock | 4.6522 | 4.6522 | 4.6071 | 4.6114 | 34093164.0 |
| 2007-08-28 11:15:00 | AAPL | Stock | 4.6114 | 4.6275 | 4.6096 | 4.6211 | 19932612.0 |
| 2007-08-28 11:20:00 | AAPL | Stock | 4.6211 | 4.6246 | 4.6129 | 4.6225 | 14708596.0 |
| 2007-08-28 11:25:00 | AAPL | Stock | 4.6223 | 4.6296 | 4.6132 | 4.62 | 13860392.0 |
| 2007-08-28 11:30:00 | AAPL | Stock | 4.6196 | 4.6307 | 4.6175 | 4.6296 | 10817100.0 |
| 2007-08-28 11:35:00 | AAPL | Stock | 4.6296 | 4.6321 | 4.6146 | 4.617 | 9503816.0 |
| 2007-08-28 11:40:00 | AAPL | Stock | 4.6164 | 4.6171 | 4.54 | 4.5496 | 49618296.0 |
| 2007-08-28 11:45:00 | AAPL | Stock | 4.5496 | 4.5768 | 4.5462 | 4.5721 | 31295824.0 |
| 2007-08-28 11:50:00 | AAPL | Stock | 4.5721 | 4.5829 | 4.5657 | 4.5714 | 16238908.0 |
| 2007-08-28 11:55:00 | AAPL | Stock | 4.5707 | 4.5743 | 4.5646 | 4.5714 | 13719440.0 |
| 2007-08-28 12:00:00 | AAPL | Stock | 4.5714 | 4.5786 | 4.5589 | 4.5771 | 13067488.0 |
| 2007-08-28 12:05:00 | AAPL | Stock | 4.5775 | 4.585 | 4.5732 | 4.5814 | 12430320.0 |
| 2007-08-28 12:10:00 | AAPL | Stock | 4.5814 | 4.5836 | 4.5693 | 4.5739 | 9995272.0 |
| 2007-08-28 12:15:00 | AAPL | Stock | 4.5739 | 4.5839 | 4.5704 | 4.5739 | 12443060.0 |
| 2007-08-28 12:20:00 | AAPL | Stock | 4.5739 | 4.5795 | 4.5671 | 4.5729 | 9822176.0 |
| 2007-08-28 12:25:00 | AAPL | Stock | 4.5729 | 4.5775 | 4.5696 | 4.5756 | 6420568.0 |
| 2007-08-28 12:30:00 | AAPL | Stock | 4.5761 | 4.5861 | 4.5761 | 4.5854 | 8538796.0 |
| 2007-08-28 12:35:00 | AAPL | Stock | 4.5854 | 4.5946 | 4.5825 | 4.5832 | 10579436.0 |
| 2007-08-28 12:40:00 | AAPL | Stock | 4.5829 | 4.5875 | 4.5786 | 4.5861 | 5594904.0 |
| 2007-08-28 12:45:00 | AAPL | Stock | 4.5871 | 4.5886 | 4.5814 | 4.5825 | 4860296.0 |
| 2007-08-28 12:50:00 | AAPL | Stock | 4.5814 | 4.5954 | 4.5807 | 4.5939 | 8726172.0 |
| 2007-08-28 12:55:00 | AAPL | Stock | 4.5939 | 4.5986 | 4.5868 | 4.5921 | 10106040.0 |
| 2007-08-28 13:00:00 | AAPL | Stock | 4.5925 | 4.5957 | 4.5868 | 4.5907 | 4974788.0 |
| 2007-08-28 13:05:00 | AAPL | Stock | 4.5896 | 4.5954 | 4.5854 | 4.5886 | 5959268.0 |
| 2007-08-28 13:10:00 | AAPL | Stock | 4.5886 | 4.5921 | 4.5839 | 4.5868 | 4948916.0 |
| 2007-08-28 13:15:00 | AAPL | Stock | 4.5871 | 4.5886 | 4.5807 | 4.5864 | 7364252.0 |
| 2007-08-28 13:20:00 | AAPL | Stock | 4.5854 | 4.5964 | 4.5843 | 4.5918 | 7410676.0 |
| 2007-08-28 13:25:00 | AAPL | Stock | 4.5918 | 4.6011 | 4.5882 | 4.5961 | 6178844.0 |
| 2007-08-28 13:30:00 | AAPL | Stock | 4.5961 | 4.6018 | 4.5932 | 4.5946 | 5643316.0 |
| 2007-08-28 13:35:00 | AAPL | Stock | 4.5957 | 4.6061 | 4.5929 | 4.6032 | 6438572.0 |
> showing 50 of 295,015 rows — these rows as CSV