PREVIEW / stock_5min / 2008-07-28
file: by_date/stock_5min/2008/2008-07-28.parquet size: 4.4 MB rows: 312,272 symbols: 3,296
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-28 07:10:00 | AAPL | Stock | 5.8036 | 5.8036 | 5.8036 | 5.8036 | 2800.0 |
| 2008-07-28 07:30:00 | AAPL | Stock | 5.7982 | 5.8214 | 5.7982 | 5.8132 | 84000.0 |
| 2008-07-28 07:35:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8196 | 5.8196 | 73360.0 |
| 2008-07-28 07:40:00 | AAPL | Stock | 5.8196 | 5.8393 | 5.8196 | 5.8214 | 30800.0 |
| 2008-07-28 07:45:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8232 | 5.8232 | 5600.0 |
| 2008-07-28 07:50:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8232 | 5.8232 | 5600.0 |
| 2008-07-28 07:55:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8232 | 5.8232 | 8120.0 |
| 2008-07-28 08:00:00 | AAPL | Stock | 5.8232 | 5.8304 | 5.8146 | 5.8214 | 199416.0 |
| 2008-07-28 08:05:00 | AAPL | Stock | 5.8175 | 5.8214 | 5.8171 | 5.8179 | 113540.0 |
| 2008-07-28 08:10:00 | AAPL | Stock | 5.8129 | 5.8129 | 5.8021 | 5.8071 | 111048.0 |
| 2008-07-28 08:15:00 | AAPL | Stock | 5.8046 | 5.8071 | 5.8032 | 5.8071 | 62272.0 |
| 2008-07-28 08:20:00 | AAPL | Stock | 5.8068 | 5.8168 | 5.8068 | 5.8154 | 157136.0 |
| 2008-07-28 08:25:00 | AAPL | Stock | 5.8186 | 5.8282 | 5.8186 | 5.8232 | 345184.0 |
| 2008-07-28 08:30:00 | AAPL | Stock | 5.8214 | 5.8232 | 5.8171 | 5.8232 | 122584.0 |
| 2008-07-28 08:35:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8164 | 5.8164 | 229600.0 |
| 2008-07-28 08:40:00 | AAPL | Stock | 5.815 | 5.8232 | 5.8143 | 5.8211 | 269136.0 |
| 2008-07-28 08:45:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8143 | 5.8179 | 353920.0 |
| 2008-07-28 08:50:00 | AAPL | Stock | 5.8186 | 5.8193 | 5.8143 | 5.8143 | 107940.0 |
| 2008-07-28 08:55:00 | AAPL | Stock | 5.8161 | 5.8179 | 5.8161 | 5.8171 | 83020.0 |
| 2008-07-28 09:00:00 | AAPL | Stock | 5.8179 | 5.8179 | 5.8107 | 5.8136 | 82768.0 |
| 2008-07-28 09:05:00 | AAPL | Stock | 5.8136 | 5.8154 | 5.8136 | 5.8143 | 22400.0 |
| 2008-07-28 09:10:00 | AAPL | Stock | 5.8164 | 5.8171 | 5.815 | 5.8171 | 107520.0 |
| 2008-07-28 09:15:00 | AAPL | Stock | 5.8171 | 5.8171 | 5.8143 | 5.8164 | 39200.0 |
| 2008-07-28 09:20:00 | AAPL | Stock | 5.8154 | 5.8164 | 5.8 | 5.8 | 232372.0 |
| 2008-07-28 09:25:00 | AAPL | Stock | 5.8004 | 5.8057 | 5.7857 | 5.8 | 331520.0 |
| 2008-07-28 09:30:00 | AAPL | Stock | 5.7979 | 5.8025 | 5.7257 | 5.7546 | 16290820.0 |
| 2008-07-28 09:35:00 | AAPL | Stock | 5.7554 | 5.7918 | 5.755 | 5.7796 | 17379964.0 |
| 2008-07-28 09:40:00 | AAPL | Stock | 5.7796 | 5.7818 | 5.7593 | 5.7686 | 8919204.0 |
| 2008-07-28 09:45:00 | AAPL | Stock | 5.7686 | 5.7696 | 5.7543 | 5.7664 | 8990772.0 |
| 2008-07-28 09:50:00 | AAPL | Stock | 5.7668 | 5.767 | 5.7411 | 5.7461 | 9211272.0 |
| 2008-07-28 09:55:00 | AAPL | Stock | 5.7443 | 5.7532 | 5.7318 | 5.7411 | 11057844.0 |
| 2008-07-28 10:00:00 | AAPL | Stock | 5.7414 | 5.7496 | 5.7393 | 5.7436 | 6602708.0 |
| 2008-07-28 10:05:00 | AAPL | Stock | 5.7425 | 5.7464 | 5.7264 | 5.7379 | 10498348.0 |
| 2008-07-28 10:10:00 | AAPL | Stock | 5.7386 | 5.7389 | 5.7036 | 5.7036 | 15116164.0 |
| 2008-07-28 10:15:00 | AAPL | Stock | 5.7036 | 5.7082 | 5.6886 | 5.7057 | 13952680.0 |
| 2008-07-28 10:20:00 | AAPL | Stock | 5.7057 | 5.7239 | 5.6961 | 5.7193 | 9579248.0 |
| 2008-07-28 10:25:00 | AAPL | Stock | 5.7187 | 5.7282 | 5.7071 | 5.7257 | 8661632.0 |
| 2008-07-28 10:30:00 | AAPL | Stock | 5.725 | 5.7286 | 5.7107 | 5.716 | 7145740.0 |
| 2008-07-28 10:35:00 | AAPL | Stock | 5.7143 | 5.7243 | 5.7118 | 5.7218 | 5158412.0 |
| 2008-07-28 10:40:00 | AAPL | Stock | 5.7212 | 5.7239 | 5.7036 | 5.7089 | 5930736.0 |
| 2008-07-28 10:45:00 | AAPL | Stock | 5.7075 | 5.7096 | 5.6814 | 5.6871 | 10614352.0 |
| 2008-07-28 10:50:00 | AAPL | Stock | 5.6864 | 5.6961 | 5.6825 | 5.6889 | 6719776.0 |
| 2008-07-28 10:55:00 | AAPL | Stock | 5.6889 | 5.6951 | 5.6825 | 5.6939 | 14466172.0 |
| 2008-07-28 11:00:00 | AAPL | Stock | 5.6932 | 5.7014 | 5.6893 | 5.6957 | 9979088.0 |
| 2008-07-28 11:05:00 | AAPL | Stock | 5.6954 | 5.6964 | 5.6832 | 5.6879 | 13434456.0 |
| 2008-07-28 11:10:00 | AAPL | Stock | 5.69 | 5.6925 | 5.6696 | 5.6779 | 9722020.0 |
| 2008-07-28 11:15:00 | AAPL | Stock | 5.6771 | 5.6782 | 5.6621 | 5.6671 | 8743056.0 |
| 2008-07-28 11:20:00 | AAPL | Stock | 5.6671 | 5.6729 | 5.6632 | 5.665 | 5790624.0 |
| 2008-07-28 11:25:00 | AAPL | Stock | 5.665 | 5.6689 | 5.6489 | 5.6525 | 10925572.0 |
| 2008-07-28 11:30:00 | AAPL | Stock | 5.6539 | 5.6543 | 5.6329 | 5.6339 | 13148492.0 |
> showing 50 of 312,272 rows — these rows as CSV