PREVIEW / stock_5min / 2004-07-13
file: by_date/stock_5min/2004/2004-07-13.parquet size: 2.3 MB rows: 170,614 symbols: 1,801
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-07-13 08:05:00 | AAPL | Stock | 0.5232 | 0.5232 | 0.5232 | 0.5232 | 5600.0 |
| 2004-07-13 08:10:00 | AAPL | Stock | 0.5225 | 0.5225 | 0.5225 | 0.5225 | 5600.0 |
| 2004-07-13 08:35:00 | AAPL | Stock | 0.5221 | 0.5221 | 0.5221 | 0.5221 | 56000.0 |
| 2004-07-13 08:55:00 | AAPL | Stock | 0.5218 | 0.5223 | 0.5218 | 0.5223 | 224000.0 |
| 2004-07-13 09:10:00 | AAPL | Stock | 0.5223 | 0.5239 | 0.5223 | 0.5239 | 84000.0 |
| 2004-07-13 09:15:00 | AAPL | Stock | 0.5239 | 0.5239 | 0.5239 | 0.5239 | 5600.0 |
| 2004-07-13 09:25:00 | AAPL | Stock | 0.5232 | 0.5232 | 0.5205 | 0.5223 | 1778280.0 |
| 2004-07-13 09:30:00 | AAPL | Stock | 0.5223 | 0.5264 | 0.5209 | 0.5264 | 15237768.0 |
| 2004-07-13 09:35:00 | AAPL | Stock | 0.5263 | 0.5279 | 0.5261 | 0.5277 | 1282400.0 |
| 2004-07-13 09:40:00 | AAPL | Stock | 0.5271 | 0.5271 | 0.5259 | 0.5259 | 638400.0 |
| 2004-07-13 09:45:00 | AAPL | Stock | 0.5259 | 0.527 | 0.5252 | 0.5259 | 5507320.0 |
| 2004-07-13 09:50:00 | AAPL | Stock | 0.5259 | 0.5268 | 0.5252 | 0.5264 | 8021608.0 |
| 2004-07-13 09:55:00 | AAPL | Stock | 0.5263 | 0.5263 | 0.5241 | 0.5257 | 6853952.0 |
| 2004-07-13 10:00:00 | AAPL | Stock | 0.5257 | 0.5259 | 0.5241 | 0.5241 | 1080856.0 |
| 2004-07-13 10:05:00 | AAPL | Stock | 0.5243 | 0.5243 | 0.5213 | 0.5229 | 8654520.0 |
| 2004-07-13 10:10:00 | AAPL | Stock | 0.523 | 0.5252 | 0.5229 | 0.525 | 6096664.0 |
| 2004-07-13 10:15:00 | AAPL | Stock | 0.525 | 0.5254 | 0.5236 | 0.5248 | 4256840.0 |
| 2004-07-13 10:20:00 | AAPL | Stock | 0.5248 | 0.5248 | 0.5238 | 0.5243 | 1521688.0 |
| 2004-07-13 10:25:00 | AAPL | Stock | 0.5243 | 0.5257 | 0.5239 | 0.5257 | 1516088.0 |
| 2004-07-13 10:30:00 | AAPL | Stock | 0.5254 | 0.5264 | 0.5246 | 0.5248 | 2897048.0 |
| 2004-07-13 10:35:00 | AAPL | Stock | 0.5248 | 0.5268 | 0.5241 | 0.5259 | 5396720.0 |
| 2004-07-13 10:40:00 | AAPL | Stock | 0.5257 | 0.5263 | 0.5245 | 0.5259 | 3007256.0 |
| 2004-07-13 10:45:00 | AAPL | Stock | 0.5261 | 0.5263 | 0.5259 | 0.526 | 1214360.0 |
| 2004-07-13 10:50:00 | AAPL | Stock | 0.5259 | 0.5259 | 0.5246 | 0.525 | 2411024.0 |
| 2004-07-13 10:55:00 | AAPL | Stock | 0.5246 | 0.5254 | 0.5243 | 0.5248 | 1488200.0 |
| 2004-07-13 11:00:00 | AAPL | Stock | 0.5248 | 0.5248 | 0.5239 | 0.5239 | 1895040.0 |
| 2004-07-13 11:05:00 | AAPL | Stock | 0.5239 | 0.5246 | 0.5238 | 0.5243 | 1492624.0 |
| 2004-07-13 11:10:00 | AAPL | Stock | 0.5243 | 0.525 | 0.5232 | 0.5246 | 2882656.0 |
| 2004-07-13 11:15:00 | AAPL | Stock | 0.5246 | 0.5252 | 0.5245 | 0.5246 | 1045520.0 |
| 2004-07-13 11:20:00 | AAPL | Stock | 0.5246 | 0.5252 | 0.5245 | 0.525 | 1310512.0 |
| 2004-07-13 11:25:00 | AAPL | Stock | 0.525 | 0.5252 | 0.5243 | 0.5252 | 2950640.0 |
| 2004-07-13 11:30:00 | AAPL | Stock | 0.5252 | 0.5252 | 0.5245 | 0.5252 | 1464400.0 |
| 2004-07-13 11:35:00 | AAPL | Stock | 0.5252 | 0.5255 | 0.5236 | 0.5238 | 1754872.0 |
| 2004-07-13 11:40:00 | AAPL | Stock | 0.5238 | 0.5246 | 0.5236 | 0.5236 | 1338344.0 |
| 2004-07-13 11:45:00 | AAPL | Stock | 0.5236 | 0.5238 | 0.5227 | 0.523 | 2087624.0 |
| 2004-07-13 11:50:00 | AAPL | Stock | 0.523 | 0.5252 | 0.522 | 0.5241 | 2803920.0 |
| 2004-07-13 11:55:00 | AAPL | Stock | 0.5243 | 0.5245 | 0.5238 | 0.5241 | 1445696.0 |
| 2004-07-13 12:00:00 | AAPL | Stock | 0.5241 | 0.525 | 0.5241 | 0.5243 | 2917096.0 |
| 2004-07-13 12:05:00 | AAPL | Stock | 0.5245 | 0.525 | 0.5243 | 0.5247 | 1064728.0 |
| 2004-07-13 12:10:00 | AAPL | Stock | 0.5248 | 0.525 | 0.5245 | 0.525 | 1093680.0 |
| 2004-07-13 12:15:00 | AAPL | Stock | 0.525 | 0.5252 | 0.5248 | 0.525 | 638512.0 |
| 2004-07-13 12:20:00 | AAPL | Stock | 0.525 | 0.5259 | 0.5246 | 0.5246 | 3398192.0 |
| 2004-07-13 12:25:00 | AAPL | Stock | 0.5248 | 0.5255 | 0.5236 | 0.5239 | 1754032.0 |
| 2004-07-13 12:30:00 | AAPL | Stock | 0.5236 | 0.5252 | 0.5236 | 0.5252 | 2702728.0 |
| 2004-07-13 12:35:00 | AAPL | Stock | 0.5252 | 0.5254 | 0.5246 | 0.5252 | 2997848.0 |
| 2004-07-13 12:40:00 | AAPL | Stock | 0.5252 | 0.5252 | 0.5241 | 0.5243 | 1321824.0 |
| 2004-07-13 12:45:00 | AAPL | Stock | 0.5246 | 0.5259 | 0.5243 | 0.5246 | 3008992.0 |
| 2004-07-13 12:50:00 | AAPL | Stock | 0.5246 | 0.5259 | 0.5241 | 0.5245 | 4016152.0 |
| 2004-07-13 12:55:00 | AAPL | Stock | 0.5245 | 0.5252 | 0.5243 | 0.5248 | 1661016.0 |
| 2004-07-13 13:00:00 | AAPL | Stock | 0.5246 | 0.525 | 0.5243 | 0.5246 | 911680.0 |
> showing 50 of 170,614 rows — these rows as CSV