PREVIEW / stock_5min / 2008-09-23
file: by_date/stock_5min/2008/2008-09-23.parquet size: 4.5 MB rows: 317,844 symbols: 3,346
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-09-23 06:45:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 5600.0 |
| 2008-09-23 07:45:00 | AAPL | Stock | 4.6857 | 4.6857 | 4.6857 | 4.6857 | 2800.0 |
| 2008-09-23 08:00:00 | AAPL | Stock | 4.6821 | 4.7032 | 4.6768 | 4.6964 | 123060.0 |
| 2008-09-23 08:05:00 | AAPL | Stock | 4.6964 | 4.7021 | 4.6743 | 4.6743 | 298088.0 |
| 2008-09-23 08:10:00 | AAPL | Stock | 4.6754 | 4.6914 | 4.6682 | 4.6754 | 347956.0 |
| 2008-09-23 08:15:00 | AAPL | Stock | 4.6814 | 4.6886 | 4.6814 | 4.6886 | 51100.0 |
| 2008-09-23 08:20:00 | AAPL | Stock | 4.6886 | 4.6893 | 4.6796 | 4.6796 | 99120.0 |
| 2008-09-23 08:25:00 | AAPL | Stock | 4.6793 | 4.6843 | 4.6714 | 4.6729 | 187908.0 |
| 2008-09-23 08:30:00 | AAPL | Stock | 4.6739 | 4.6854 | 4.6625 | 4.6782 | 125888.0 |
| 2008-09-23 08:35:00 | AAPL | Stock | 4.6786 | 4.6961 | 4.6786 | 4.6961 | 183148.0 |
| 2008-09-23 08:40:00 | AAPL | Stock | 4.6961 | 4.7061 | 4.6886 | 4.7061 | 262024.0 |
| 2008-09-23 08:45:00 | AAPL | Stock | 4.7036 | 4.7036 | 4.6968 | 4.6993 | 92400.0 |
| 2008-09-23 08:50:00 | AAPL | Stock | 4.7011 | 4.7032 | 4.6836 | 4.6961 | 293944.0 |
| 2008-09-23 08:55:00 | AAPL | Stock | 4.6961 | 4.7054 | 4.6957 | 4.7054 | 142212.0 |
| 2008-09-23 09:00:00 | AAPL | Stock | 4.7071 | 4.7143 | 4.7 | 4.7068 | 269976.0 |
| 2008-09-23 09:05:00 | AAPL | Stock | 4.7068 | 4.7246 | 4.7007 | 4.7246 | 306712.0 |
| 2008-09-23 09:10:00 | AAPL | Stock | 4.7243 | 4.7386 | 4.7207 | 4.7271 | 358428.0 |
| 2008-09-23 09:15:00 | AAPL | Stock | 4.7218 | 4.7218 | 4.7082 | 4.7214 | 142660.0 |
| 2008-09-23 09:20:00 | AAPL | Stock | 4.7218 | 4.7282 | 4.7175 | 4.7282 | 102200.0 |
| 2008-09-23 09:25:00 | AAPL | Stock | 4.725 | 4.725 | 4.6968 | 4.7082 | 899948.0 |
| 2008-09-23 09:30:00 | AAPL | Stock | 4.7068 | 4.7389 | 4.6711 | 4.7196 | 34166804.0 |
| 2008-09-23 09:35:00 | AAPL | Stock | 4.72 | 4.7575 | 4.7086 | 4.7325 | 25985176.0 |
| 2008-09-23 09:40:00 | AAPL | Stock | 4.7336 | 4.7407 | 4.7029 | 4.7229 | 29745912.0 |
| 2008-09-23 09:45:00 | AAPL | Stock | 4.7225 | 4.7525 | 4.7129 | 4.7461 | 18200028.0 |
| 2008-09-23 09:50:00 | AAPL | Stock | 4.7461 | 4.7797 | 4.7371 | 4.7714 | 20087228.0 |
| 2008-09-23 09:55:00 | AAPL | Stock | 4.7714 | 4.7946 | 4.7686 | 4.7739 | 17935260.0 |
| 2008-09-23 10:00:00 | AAPL | Stock | 4.7733 | 4.8036 | 4.7732 | 4.795 | 16710484.0 |
| 2008-09-23 10:05:00 | AAPL | Stock | 4.7964 | 4.8054 | 4.7554 | 4.7589 | 17098060.0 |
| 2008-09-23 10:10:00 | AAPL | Stock | 4.7593 | 4.8 | 4.7546 | 4.7921 | 16899484.0 |
| 2008-09-23 10:15:00 | AAPL | Stock | 4.7921 | 4.7996 | 4.7757 | 4.798 | 13986728.0 |
| 2008-09-23 10:20:00 | AAPL | Stock | 4.7975 | 4.8332 | 4.7975 | 4.8204 | 20227564.0 |
| 2008-09-23 10:25:00 | AAPL | Stock | 4.8214 | 4.8461 | 4.8171 | 4.8214 | 23264612.0 |
| 2008-09-23 10:30:00 | AAPL | Stock | 4.8214 | 4.85 | 4.8182 | 4.8329 | 12864460.0 |
| 2008-09-23 10:35:00 | AAPL | Stock | 4.8304 | 4.8386 | 4.8136 | 4.8229 | 13624100.0 |
| 2008-09-23 10:40:00 | AAPL | Stock | 4.8221 | 4.8264 | 4.8014 | 4.8014 | 11202492.0 |
| 2008-09-23 10:45:00 | AAPL | Stock | 4.8014 | 4.8121 | 4.7857 | 4.79 | 16770404.0 |
| 2008-09-23 10:50:00 | AAPL | Stock | 4.79 | 4.7904 | 4.7521 | 4.7625 | 23553432.0 |
| 2008-09-23 10:55:00 | AAPL | Stock | 4.7625 | 4.7829 | 4.7579 | 4.7639 | 12790148.0 |
| 2008-09-23 11:00:00 | AAPL | Stock | 4.7646 | 4.7729 | 4.7414 | 4.7646 | 14247436.0 |
| 2008-09-23 11:05:00 | AAPL | Stock | 4.765 | 4.7679 | 4.7443 | 4.765 | 12270216.0 |
| 2008-09-23 11:10:00 | AAPL | Stock | 4.7646 | 4.81 | 4.75 | 4.7964 | 14102648.0 |
| 2008-09-23 11:15:00 | AAPL | Stock | 4.7964 | 4.8136 | 4.7911 | 4.8093 | 8569624.0 |
| 2008-09-23 11:20:00 | AAPL | Stock | 4.8096 | 4.8304 | 4.8071 | 4.8082 | 13094480.0 |
| 2008-09-23 11:25:00 | AAPL | Stock | 4.8075 | 4.8168 | 4.7896 | 4.7907 | 9682764.0 |
| 2008-09-23 11:30:00 | AAPL | Stock | 4.79 | 4.8079 | 4.7857 | 4.7989 | 7475132.0 |
| 2008-09-23 11:35:00 | AAPL | Stock | 4.7979 | 4.7982 | 4.7679 | 4.7689 | 7597800.0 |
| 2008-09-23 11:40:00 | AAPL | Stock | 4.7686 | 4.7746 | 4.7546 | 4.7571 | 8472100.0 |
| 2008-09-23 11:45:00 | AAPL | Stock | 4.7557 | 4.7739 | 4.7482 | 4.77 | 8918392.0 |
| 2008-09-23 11:50:00 | AAPL | Stock | 4.77 | 4.7804 | 4.7607 | 4.7714 | 6538588.0 |
| 2008-09-23 11:55:00 | AAPL | Stock | 4.7714 | 4.7764 | 4.7486 | 4.7543 | 6878088.0 |
> showing 50 of 317,844 rows — these rows as CSV