PREVIEW / stock_5min / 2005-10-27
file: by_date/stock_5min/2005/2005-10-27.parquet size: 2.8 MB rows: 202,043 symbols: 2,106
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-27 08:00:00 | AAPL | Stock | 2.0339 | 2.0357 | 2.0214 | 2.0268 | 204400.0 |
| 2005-10-27 08:05:00 | AAPL | Stock | 2.0286 | 2.0286 | 2.0268 | 2.0268 | 33600.0 |
| 2005-10-27 08:10:00 | AAPL | Stock | 2.0268 | 2.0268 | 2.0264 | 2.0268 | 44800.0 |
| 2005-10-27 08:15:00 | AAPL | Stock | 2.0286 | 2.0286 | 2.0232 | 2.0286 | 26320.0 |
| 2005-10-27 08:30:00 | AAPL | Stock | 2.0289 | 2.0289 | 2.0289 | 2.0289 | 11200.0 |
| 2005-10-27 08:35:00 | AAPL | Stock | 2.0314 | 2.0314 | 2.0314 | 2.0314 | 16800.0 |
| 2005-10-27 08:40:00 | AAPL | Stock | 2.0289 | 2.0289 | 2.0289 | 2.0289 | 22400.0 |
| 2005-10-27 08:45:00 | AAPL | Stock | 2.0296 | 2.0296 | 2.0296 | 2.0296 | 11200.0 |
| 2005-10-27 08:50:00 | AAPL | Stock | 2.0282 | 2.0282 | 2.0268 | 2.0268 | 5600.0 |
| 2005-10-27 08:55:00 | AAPL | Stock | 2.0293 | 2.0293 | 2.0293 | 2.0293 | 28000.0 |
| 2005-10-27 09:00:00 | AAPL | Stock | 2.0293 | 2.0336 | 2.0293 | 2.0336 | 64400.0 |
| 2005-10-27 09:05:00 | AAPL | Stock | 2.0304 | 2.0321 | 2.0304 | 2.0321 | 56000.0 |
| 2005-10-27 09:10:00 | AAPL | Stock | 2.0318 | 2.0318 | 2.0318 | 2.0318 | 36260.0 |
| 2005-10-27 09:15:00 | AAPL | Stock | 2.0321 | 2.0336 | 2.0321 | 2.0336 | 16800.0 |
| 2005-10-27 09:20:00 | AAPL | Stock | 2.0336 | 2.0336 | 2.0336 | 2.0336 | 34860.0 |
| 2005-10-27 09:25:00 | AAPL | Stock | 2.0336 | 2.0357 | 2.0271 | 2.0271 | 901572.0 |
| 2005-10-27 09:30:00 | AAPL | Stock | 2.0354 | 2.0361 | 2.0261 | 2.0336 | 14271740.0 |
| 2005-10-27 09:35:00 | AAPL | Stock | 2.0336 | 2.0361 | 2.0246 | 2.0246 | 9094316.0 |
| 2005-10-27 09:40:00 | AAPL | Stock | 2.0246 | 2.025 | 2.0161 | 2.0218 | 9891532.0 |
| 2005-10-27 09:45:00 | AAPL | Stock | 2.0214 | 2.025 | 2.0175 | 2.0218 | 6571572.0 |
| 2005-10-27 09:50:00 | AAPL | Stock | 2.0214 | 2.0257 | 2.0175 | 2.0193 | 5496988.0 |
| 2005-10-27 09:55:00 | AAPL | Stock | 2.0193 | 2.0196 | 2.0075 | 2.0139 | 14805896.0 |
| 2005-10-27 10:00:00 | AAPL | Stock | 2.0139 | 2.0214 | 2.0089 | 2.0129 | 8846012.0 |
| 2005-10-27 10:05:00 | AAPL | Stock | 2.0132 | 2.0175 | 2.0132 | 2.0139 | 3568012.0 |
| 2005-10-27 10:10:00 | AAPL | Stock | 2.0139 | 2.015 | 2.0082 | 2.0089 | 3644788.0 |
| 2005-10-27 10:15:00 | AAPL | Stock | 2.0093 | 2.0129 | 2.0082 | 2.0096 | 5475848.0 |
| 2005-10-27 10:20:00 | AAPL | Stock | 2.01 | 2.0125 | 2.0032 | 2.0036 | 9923228.0 |
| 2005-10-27 10:25:00 | AAPL | Stock | 2.0036 | 2.0054 | 2.0 | 2.0036 | 10212244.0 |
| 2005-10-27 10:30:00 | AAPL | Stock | 2.0032 | 2.0089 | 2.0025 | 2.0043 | 7370692.0 |
| 2005-10-27 10:35:00 | AAPL | Stock | 2.0043 | 2.0071 | 1.9929 | 1.9961 | 11627896.0 |
| 2005-10-27 10:40:00 | AAPL | Stock | 1.9957 | 2.0036 | 1.9921 | 2.0007 | 8582868.0 |
| 2005-10-27 10:45:00 | AAPL | Stock | 2.0004 | 2.0032 | 1.9989 | 1.9993 | 5088076.0 |
| 2005-10-27 10:50:00 | AAPL | Stock | 1.9993 | 2.0029 | 1.9989 | 2.0029 | 4886756.0 |
| 2005-10-27 10:55:00 | AAPL | Stock | 2.0029 | 2.0064 | 2.0 | 2.0054 | 5446560.0 |
| 2005-10-27 11:00:00 | AAPL | Stock | 2.0046 | 2.01 | 2.0036 | 2.0086 | 5513732.0 |
| 2005-10-27 11:05:00 | AAPL | Stock | 2.0086 | 2.0121 | 2.0075 | 2.0086 | 7272832.0 |
| 2005-10-27 11:10:00 | AAPL | Stock | 2.0089 | 2.0093 | 2.0025 | 2.0057 | 3745476.0 |
| 2005-10-27 11:15:00 | AAPL | Stock | 2.0054 | 2.0132 | 2.0054 | 2.0071 | 3397352.0 |
| 2005-10-27 11:20:00 | AAPL | Stock | 2.0068 | 2.0129 | 2.0061 | 2.0125 | 4061344.0 |
| 2005-10-27 11:25:00 | AAPL | Stock | 2.0129 | 2.0139 | 2.0089 | 2.0125 | 4154248.0 |
| 2005-10-27 11:30:00 | AAPL | Stock | 2.0121 | 2.0136 | 2.0046 | 2.005 | 4689552.0 |
| 2005-10-27 11:35:00 | AAPL | Stock | 2.0046 | 2.0111 | 2.0007 | 2.0011 | 6599572.0 |
| 2005-10-27 11:40:00 | AAPL | Stock | 2.0014 | 2.0043 | 2.0004 | 2.0036 | 2392208.0 |
| 2005-10-27 11:45:00 | AAPL | Stock | 2.0036 | 2.0054 | 2.0014 | 2.0018 | 2293732.0 |
| 2005-10-27 11:50:00 | AAPL | Stock | 2.0014 | 2.0071 | 1.9986 | 2.0 | 5398820.0 |
| 2005-10-27 11:55:00 | AAPL | Stock | 2.0 | 2.0054 | 1.9996 | 2.0021 | 2709364.0 |
| 2005-10-27 12:00:00 | AAPL | Stock | 2.0014 | 2.0079 | 2.0011 | 2.0057 | 2794848.0 |
| 2005-10-27 12:05:00 | AAPL | Stock | 2.0057 | 2.0104 | 2.0043 | 2.0046 | 3468276.0 |
| 2005-10-27 12:10:00 | AAPL | Stock | 2.0043 | 2.0057 | 2.0021 | 2.0057 | 1985172.0 |
| 2005-10-27 12:15:00 | AAPL | Stock | 2.0057 | 2.0086 | 2.0036 | 2.0079 | 2714460.0 |
> showing 50 of 202,043 rows — these rows as CSV