PREVIEW / stock_5min / 2004-08-31
file: by_date/stock_5min/2004/2004-08-31.parquet size: 2.3 MB rows: 172,571 symbols: 1,817
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-08-31 08:00:00 | AAPL | Stock | 0.6121 | 0.6121 | 0.6121 | 0.6121 | 5600.0 |
| 2004-08-31 08:15:00 | AAPL | Stock | 0.612 | 0.612 | 0.6021 | 0.6029 | 128800.0 |
| 2004-08-31 08:20:00 | AAPL | Stock | 0.6039 | 0.608 | 0.6036 | 0.607 | 67200.0 |
| 2004-08-31 08:25:00 | AAPL | Stock | 0.6089 | 0.6089 | 0.6089 | 0.6089 | 33600.0 |
| 2004-08-31 08:30:00 | AAPL | Stock | 0.6091 | 0.6093 | 0.6091 | 0.6093 | 44800.0 |
| 2004-08-31 08:35:00 | AAPL | Stock | 0.6093 | 0.6096 | 0.6088 | 0.6096 | 72800.0 |
| 2004-08-31 08:40:00 | AAPL | Stock | 0.6096 | 0.6096 | 0.6093 | 0.6093 | 67200.0 |
| 2004-08-31 08:45:00 | AAPL | Stock | 0.6096 | 0.6096 | 0.6096 | 0.6096 | 44800.0 |
| 2004-08-31 08:55:00 | AAPL | Stock | 0.6102 | 0.612 | 0.6095 | 0.6118 | 388640.0 |
| 2004-08-31 09:00:00 | AAPL | Stock | 0.612 | 0.6161 | 0.6118 | 0.6136 | 78400.0 |
| 2004-08-31 09:05:00 | AAPL | Stock | 0.6141 | 0.6141 | 0.613 | 0.613 | 61600.0 |
| 2004-08-31 09:20:00 | AAPL | Stock | 0.6123 | 0.6123 | 0.6123 | 0.6123 | 110880.0 |
| 2004-08-31 09:25:00 | AAPL | Stock | 0.6125 | 0.6125 | 0.6086 | 0.6086 | 943040.0 |
| 2004-08-31 09:30:00 | AAPL | Stock | 0.6084 | 0.6143 | 0.6077 | 0.6141 | 11988144.0 |
| 2004-08-31 09:35:00 | AAPL | Stock | 0.6143 | 0.618 | 0.6139 | 0.6166 | 18161360.0 |
| 2004-08-31 09:40:00 | AAPL | Stock | 0.6166 | 0.6195 | 0.6161 | 0.6195 | 9304232.0 |
| 2004-08-31 09:45:00 | AAPL | Stock | 0.6195 | 0.623 | 0.6177 | 0.6213 | 13450136.0 |
| 2004-08-31 09:50:00 | AAPL | Stock | 0.6214 | 0.6232 | 0.6204 | 0.623 | 11497472.0 |
| 2004-08-31 09:55:00 | AAPL | Stock | 0.6232 | 0.6241 | 0.6218 | 0.6232 | 12851216.0 |
| 2004-08-31 10:00:00 | AAPL | Stock | 0.6227 | 0.6232 | 0.6202 | 0.6211 | 9208976.0 |
| 2004-08-31 10:05:00 | AAPL | Stock | 0.6211 | 0.6223 | 0.6205 | 0.6205 | 6548696.0 |
| 2004-08-31 10:10:00 | AAPL | Stock | 0.6205 | 0.622 | 0.6195 | 0.6196 | 5476184.0 |
| 2004-08-31 10:15:00 | AAPL | Stock | 0.6196 | 0.6205 | 0.6179 | 0.6182 | 8188544.0 |
| 2004-08-31 10:20:00 | AAPL | Stock | 0.618 | 0.6195 | 0.6171 | 0.6175 | 5006344.0 |
| 2004-08-31 10:25:00 | AAPL | Stock | 0.6175 | 0.618 | 0.6164 | 0.6179 | 4250232.0 |
| 2004-08-31 10:30:00 | AAPL | Stock | 0.6179 | 0.6196 | 0.6179 | 0.6195 | 4208456.0 |
| 2004-08-31 10:35:00 | AAPL | Stock | 0.6196 | 0.6196 | 0.6184 | 0.6191 | 4561592.0 |
| 2004-08-31 10:40:00 | AAPL | Stock | 0.6191 | 0.6193 | 0.6154 | 0.6161 | 6325312.0 |
| 2004-08-31 10:45:00 | AAPL | Stock | 0.6161 | 0.6168 | 0.615 | 0.6152 | 3000760.0 |
| 2004-08-31 10:50:00 | AAPL | Stock | 0.6152 | 0.6152 | 0.6129 | 0.6132 | 4657296.0 |
| 2004-08-31 10:55:00 | AAPL | Stock | 0.6129 | 0.6139 | 0.6129 | 0.6138 | 2819040.0 |
| 2004-08-31 11:00:00 | AAPL | Stock | 0.6136 | 0.6136 | 0.6105 | 0.6107 | 7230048.0 |
| 2004-08-31 11:05:00 | AAPL | Stock | 0.61 | 0.6111 | 0.6096 | 0.6098 | 3873352.0 |
| 2004-08-31 11:10:00 | AAPL | Stock | 0.61 | 0.6102 | 0.608 | 0.6084 | 4945136.0 |
| 2004-08-31 11:15:00 | AAPL | Stock | 0.6084 | 0.6095 | 0.6082 | 0.6089 | 5962432.0 |
| 2004-08-31 11:20:00 | AAPL | Stock | 0.6089 | 0.6089 | 0.6071 | 0.6079 | 9380784.0 |
| 2004-08-31 11:25:00 | AAPL | Stock | 0.6075 | 0.6102 | 0.6075 | 0.6095 | 6989920.0 |
| 2004-08-31 11:30:00 | AAPL | Stock | 0.6096 | 0.6098 | 0.6082 | 0.6093 | 4105192.0 |
| 2004-08-31 11:35:00 | AAPL | Stock | 0.6093 | 0.6098 | 0.6089 | 0.6091 | 2194920.0 |
| 2004-08-31 11:40:00 | AAPL | Stock | 0.6089 | 0.6093 | 0.6086 | 0.6086 | 2635976.0 |
| 2004-08-31 11:45:00 | AAPL | Stock | 0.6088 | 0.6089 | 0.6077 | 0.6079 | 3176600.0 |
| 2004-08-31 11:50:00 | AAPL | Stock | 0.6082 | 0.6089 | 0.6079 | 0.6089 | 1138368.0 |
| 2004-08-31 11:55:00 | AAPL | Stock | 0.6089 | 0.6092 | 0.6084 | 0.6084 | 2119040.0 |
| 2004-08-31 12:00:00 | AAPL | Stock | 0.6084 | 0.6088 | 0.6079 | 0.6082 | 1376648.0 |
| 2004-08-31 12:05:00 | AAPL | Stock | 0.6081 | 0.6104 | 0.6081 | 0.6094 | 2001832.0 |
| 2004-08-31 12:10:00 | AAPL | Stock | 0.6091 | 0.6093 | 0.6091 | 0.6091 | 570360.0 |
| 2004-08-31 12:15:00 | AAPL | Stock | 0.6093 | 0.6118 | 0.6093 | 0.6116 | 3061184.0 |
| 2004-08-31 12:20:00 | AAPL | Stock | 0.6116 | 0.6118 | 0.6107 | 0.6109 | 2459800.0 |
| 2004-08-31 12:25:00 | AAPL | Stock | 0.6109 | 0.6116 | 0.6106 | 0.6111 | 2475480.0 |
| 2004-08-31 12:30:00 | AAPL | Stock | 0.6111 | 0.6116 | 0.6111 | 0.6111 | 809872.0 |
> showing 50 of 172,571 rows — these rows as CSV