PREVIEW / stock_5min / 2006-07-06
file: by_date/stock_5min/2006/2006-07-06.parquet size: 3.1 MB rows: 227,427 symbols: 2,298
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-06 05:45:00 | AAPL | Stock | 2.0286 | 2.0286 | 2.0286 | 2.0286 | 22400.0 |
| 2006-07-06 06:15:00 | AAPL | Stock | 2.0357 | 2.0357 | 2.0357 | 2.0357 | 19600.0 |
| 2006-07-06 07:35:00 | AAPL | Stock | 2.0286 | 2.0286 | 2.0286 | 2.0286 | 5600.0 |
| 2006-07-06 08:00:00 | AAPL | Stock | 2.0357 | 2.0393 | 2.0268 | 2.0321 | 67760.0 |
| 2006-07-06 08:05:00 | AAPL | Stock | 2.0286 | 2.0286 | 2.0282 | 2.0286 | 55216.0 |
| 2006-07-06 08:10:00 | AAPL | Stock | 2.0296 | 2.0296 | 2.0296 | 2.0296 | 14000.0 |
| 2006-07-06 08:15:00 | AAPL | Stock | 2.0296 | 2.0296 | 2.0293 | 2.0293 | 82600.0 |
| 2006-07-06 08:25:00 | AAPL | Stock | 2.0304 | 2.0321 | 2.0304 | 2.0321 | 8400.0 |
| 2006-07-06 08:30:00 | AAPL | Stock | 2.0321 | 2.0393 | 2.0261 | 2.0361 | 107576.0 |
| 2006-07-06 08:35:00 | AAPL | Stock | 2.0357 | 2.0371 | 2.0289 | 2.0293 | 179984.0 |
| 2006-07-06 08:40:00 | AAPL | Stock | 2.0339 | 2.0357 | 2.0321 | 2.0321 | 68600.0 |
| 2006-07-06 08:45:00 | AAPL | Stock | 2.035 | 2.0357 | 2.0339 | 2.0339 | 32228.0 |
| 2006-07-06 08:50:00 | AAPL | Stock | 2.0339 | 2.035 | 2.0332 | 2.035 | 100604.0 |
| 2006-07-06 08:55:00 | AAPL | Stock | 2.035 | 2.0354 | 2.035 | 2.035 | 19600.0 |
| 2006-07-06 09:00:00 | AAPL | Stock | 2.0346 | 2.0346 | 2.0346 | 2.0346 | 7196.0 |
| 2006-07-06 09:05:00 | AAPL | Stock | 2.0329 | 2.0329 | 2.0307 | 2.0307 | 42000.0 |
| 2006-07-06 09:10:00 | AAPL | Stock | 2.0321 | 2.0339 | 2.0321 | 2.0339 | 53872.0 |
| 2006-07-06 09:15:00 | AAPL | Stock | 2.0339 | 2.0339 | 2.0321 | 2.0339 | 45612.0 |
| 2006-07-06 09:20:00 | AAPL | Stock | 2.0339 | 2.0339 | 2.0339 | 2.0339 | 62300.0 |
| 2006-07-06 09:25:00 | AAPL | Stock | 2.0321 | 2.045 | 2.0321 | 2.0418 | 400708.0 |
| 2006-07-06 09:30:00 | AAPL | Stock | 2.0389 | 2.0482 | 2.0332 | 2.0411 | 15977248.0 |
| 2006-07-06 09:35:00 | AAPL | Stock | 2.0411 | 2.0446 | 2.0371 | 2.0443 | 6776812.0 |
| 2006-07-06 09:40:00 | AAPL | Stock | 2.0439 | 2.0489 | 2.0364 | 2.0382 | 10112928.0 |
| 2006-07-06 09:45:00 | AAPL | Stock | 2.0382 | 2.0386 | 2.0336 | 2.0339 | 10729152.0 |
| 2006-07-06 09:50:00 | AAPL | Stock | 2.0339 | 2.0343 | 2.0236 | 2.0243 | 17215156.0 |
| 2006-07-06 09:55:00 | AAPL | Stock | 2.0243 | 2.0446 | 2.0211 | 2.0218 | 13343652.0 |
| 2006-07-06 10:00:00 | AAPL | Stock | 2.0214 | 2.0293 | 2.0186 | 2.0264 | 15317876.0 |
| 2006-07-06 10:05:00 | AAPL | Stock | 2.0264 | 2.0329 | 2.0229 | 2.03 | 10533348.0 |
| 2006-07-06 10:10:00 | AAPL | Stock | 2.03 | 2.03 | 2.0214 | 2.0243 | 7559860.0 |
| 2006-07-06 10:15:00 | AAPL | Stock | 2.0239 | 2.05 | 2.0179 | 2.0182 | 9327388.0 |
| 2006-07-06 10:20:00 | AAPL | Stock | 2.0182 | 2.0289 | 2.0179 | 2.0264 | 19315940.0 |
| 2006-07-06 10:25:00 | AAPL | Stock | 2.0261 | 2.0357 | 2.0221 | 2.0321 | 14796796.0 |
| 2006-07-06 10:30:00 | AAPL | Stock | 2.0321 | 2.0343 | 2.0268 | 2.0286 | 9379664.0 |
| 2006-07-06 10:35:00 | AAPL | Stock | 2.0282 | 2.0282 | 2.0211 | 2.0239 | 11331964.0 |
| 2006-07-06 10:40:00 | AAPL | Stock | 2.0239 | 2.0243 | 2.0196 | 2.0204 | 8269884.0 |
| 2006-07-06 10:45:00 | AAPL | Stock | 2.0207 | 2.0229 | 2.0136 | 2.0139 | 13206200.0 |
| 2006-07-06 10:50:00 | AAPL | Stock | 2.0136 | 2.0154 | 2.0071 | 2.01 | 17424148.0 |
| 2006-07-06 10:55:00 | AAPL | Stock | 2.0099 | 2.0136 | 2.0064 | 2.0111 | 13174728.0 |
| 2006-07-06 11:00:00 | AAPL | Stock | 2.0111 | 2.0143 | 2.0089 | 2.01 | 7516516.0 |
| 2006-07-06 11:05:00 | AAPL | Stock | 2.0096 | 2.0107 | 2.0032 | 2.0043 | 12959912.0 |
| 2006-07-06 11:10:00 | AAPL | Stock | 2.0039 | 2.0404 | 2.0039 | 2.0086 | 10368260.0 |
| 2006-07-06 11:15:00 | AAPL | Stock | 2.0082 | 2.0143 | 2.0082 | 2.0107 | 7062944.0 |
| 2006-07-06 11:20:00 | AAPL | Stock | 2.0107 | 2.0143 | 2.0089 | 2.0093 | 5818512.0 |
| 2006-07-06 11:25:00 | AAPL | Stock | 2.0089 | 2.0143 | 2.0079 | 2.0139 | 5402432.0 |
| 2006-07-06 11:30:00 | AAPL | Stock | 2.0136 | 2.0143 | 2.0111 | 2.0118 | 5136628.0 |
| 2006-07-06 11:35:00 | AAPL | Stock | 2.0114 | 2.0118 | 2.0089 | 2.0093 | 3082016.0 |
| 2006-07-06 11:40:00 | AAPL | Stock | 2.0092 | 2.01 | 2.0061 | 2.0096 | 6891668.0 |
| 2006-07-06 11:45:00 | AAPL | Stock | 2.01 | 2.0107 | 2.0021 | 2.0032 | 6593356.0 |
| 2006-07-06 11:50:00 | AAPL | Stock | 2.0029 | 2.0032 | 1.9989 | 2.0007 | 13008156.0 |
| 2006-07-06 11:55:00 | AAPL | Stock | 2.0007 | 2.0007 | 1.9971 | 1.9996 | 7262080.0 |
> showing 50 of 227,427 rows — these rows as CSV