PREVIEW / stock_5min / 2009-05-05
file: by_date/stock_5min/2009/2009-05-05.parquet size: 4.7 MB rows: 324,884 symbols: 3,358
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-05 07:25:00 | AAPL | Stock | 4.69 | 4.69 | 4.6786 | 4.6857 | 104636.0 |
| 2009-05-05 07:35:00 | AAPL | Stock | 4.6868 | 4.6868 | 4.6864 | 4.6864 | 16800.0 |
| 2009-05-05 07:45:00 | AAPL | Stock | 4.6893 | 4.6893 | 4.6893 | 4.6893 | 5600.0 |
| 2009-05-05 07:50:00 | AAPL | Stock | 4.6857 | 4.6857 | 4.6857 | 4.6857 | 5600.0 |
| 2009-05-05 08:00:00 | AAPL | Stock | 4.7 | 4.7132 | 4.6964 | 4.7071 | 45416.0 |
| 2009-05-05 08:05:00 | AAPL | Stock | 4.7071 | 4.7071 | 4.6971 | 4.6971 | 39536.0 |
| 2009-05-05 08:10:00 | AAPL | Stock | 4.6996 | 4.7036 | 4.6964 | 4.7036 | 37044.0 |
| 2009-05-05 08:15:00 | AAPL | Stock | 4.7036 | 4.7075 | 4.7036 | 4.7039 | 25424.0 |
| 2009-05-05 08:20:00 | AAPL | Stock | 4.7075 | 4.7075 | 4.7036 | 4.7036 | 83356.0 |
| 2009-05-05 08:30:00 | AAPL | Stock | 4.7036 | 4.7068 | 4.7036 | 4.7068 | 29064.0 |
| 2009-05-05 08:35:00 | AAPL | Stock | 4.7014 | 4.7036 | 4.7014 | 4.7036 | 5600.0 |
| 2009-05-05 08:40:00 | AAPL | Stock | 4.7004 | 4.7032 | 4.6786 | 4.6964 | 613312.0 |
| 2009-05-05 08:45:00 | AAPL | Stock | 4.6929 | 4.7036 | 4.6914 | 4.6964 | 69916.0 |
| 2009-05-05 08:50:00 | AAPL | Stock | 4.6964 | 4.7139 | 4.6957 | 4.7054 | 220164.0 |
| 2009-05-05 08:55:00 | AAPL | Stock | 4.6968 | 4.7068 | 4.6968 | 4.7068 | 11200.0 |
| 2009-05-05 09:00:00 | AAPL | Stock | 4.7018 | 4.7036 | 4.7018 | 4.7036 | 43680.0 |
| 2009-05-05 09:05:00 | AAPL | Stock | 4.7061 | 4.7071 | 4.6957 | 4.6957 | 186564.0 |
| 2009-05-05 09:10:00 | AAPL | Stock | 4.6954 | 4.6982 | 4.6954 | 4.6982 | 11200.0 |
| 2009-05-05 09:15:00 | AAPL | Stock | 4.7036 | 4.7036 | 4.6989 | 4.6989 | 13720.0 |
| 2009-05-05 09:20:00 | AAPL | Stock | 4.7 | 4.7 | 4.6989 | 4.6993 | 27496.0 |
| 2009-05-05 09:25:00 | AAPL | Stock | 4.7032 | 4.7107 | 4.6961 | 4.7071 | 204708.0 |
| 2009-05-05 09:30:00 | AAPL | Stock | 4.7089 | 4.7414 | 4.7036 | 4.7371 | 15395240.0 |
| 2009-05-05 09:35:00 | AAPL | Stock | 4.7375 | 4.7389 | 4.7039 | 4.7125 | 12228832.0 |
| 2009-05-05 09:40:00 | AAPL | Stock | 4.7129 | 4.7157 | 4.6932 | 4.7018 | 11827368.0 |
| 2009-05-05 09:45:00 | AAPL | Stock | 4.7018 | 4.7018 | 4.6843 | 4.6959 | 11077304.0 |
| 2009-05-05 09:50:00 | AAPL | Stock | 4.6957 | 4.71 | 4.6829 | 4.7086 | 6915524.0 |
| 2009-05-05 09:55:00 | AAPL | Stock | 4.7068 | 4.7179 | 4.7004 | 4.7161 | 7464884.0 |
| 2009-05-05 10:00:00 | AAPL | Stock | 4.7164 | 4.7289 | 4.7036 | 4.7225 | 10440220.0 |
| 2009-05-05 10:05:00 | AAPL | Stock | 4.7218 | 4.7339 | 4.7114 | 4.7132 | 8852984.0 |
| 2009-05-05 10:10:00 | AAPL | Stock | 4.7125 | 4.7264 | 4.7079 | 4.7214 | 6318284.0 |
| 2009-05-05 10:15:00 | AAPL | Stock | 4.7211 | 4.725 | 4.7118 | 4.7168 | 3621240.0 |
| 2009-05-05 10:20:00 | AAPL | Stock | 4.7168 | 4.7186 | 4.7046 | 4.7075 | 5818400.0 |
| 2009-05-05 10:25:00 | AAPL | Stock | 4.7075 | 4.7175 | 4.7054 | 4.7161 | 3611944.0 |
| 2009-05-05 10:30:00 | AAPL | Stock | 4.7157 | 4.7225 | 4.7075 | 4.7221 | 5944288.0 |
| 2009-05-05 10:35:00 | AAPL | Stock | 4.7225 | 4.7275 | 4.7204 | 4.7221 | 4679836.0 |
| 2009-05-05 10:40:00 | AAPL | Stock | 4.7221 | 4.7221 | 4.7129 | 4.7204 | 5115040.0 |
| 2009-05-05 10:45:00 | AAPL | Stock | 4.7193 | 4.7207 | 4.7089 | 4.7114 | 4779600.0 |
| 2009-05-05 10:50:00 | AAPL | Stock | 4.7107 | 4.7218 | 4.7107 | 4.715 | 3513300.0 |
| 2009-05-05 10:55:00 | AAPL | Stock | 4.7143 | 4.7154 | 4.6989 | 4.7004 | 5500992.0 |
| 2009-05-05 11:00:00 | AAPL | Stock | 4.6989 | 4.7079 | 4.6946 | 4.7071 | 3101420.0 |
| 2009-05-05 11:05:00 | AAPL | Stock | 4.7068 | 4.7104 | 4.6986 | 4.7071 | 3718400.0 |
| 2009-05-05 11:10:00 | AAPL | Stock | 4.7067 | 4.7189 | 4.7054 | 4.71 | 4026708.0 |
| 2009-05-05 11:15:00 | AAPL | Stock | 4.7107 | 4.7196 | 4.7107 | 4.7146 | 3233356.0 |
| 2009-05-05 11:20:00 | AAPL | Stock | 4.7145 | 4.7161 | 4.7079 | 4.7136 | 2891056.0 |
| 2009-05-05 11:25:00 | AAPL | Stock | 4.7129 | 4.7182 | 4.7111 | 4.7157 | 2527812.0 |
| 2009-05-05 11:30:00 | AAPL | Stock | 4.715 | 4.7221 | 4.7146 | 4.7207 | 3219832.0 |
| 2009-05-05 11:35:00 | AAPL | Stock | 4.7207 | 4.725 | 4.7154 | 4.7154 | 2810892.0 |
| 2009-05-05 11:40:00 | AAPL | Stock | 4.7154 | 4.7204 | 4.7143 | 4.72 | 2775696.0 |
| 2009-05-05 11:45:00 | AAPL | Stock | 4.7196 | 4.7264 | 4.7146 | 4.7229 | 2468928.0 |
| 2009-05-05 11:50:00 | AAPL | Stock | 4.7229 | 4.7243 | 4.7161 | 4.7182 | 3626112.0 |
> showing 50 of 324,884 rows — these rows as CSV