PREVIEW / stock_5min / 2004-09-13
file: by_date/stock_5min/2004/2004-09-13.parquet size: 2.4 MB rows: 178,826 symbols: 1,835
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-09-13 08:05:00 | AAPL | Stock | 0.6405 | 0.6405 | 0.6405 | 0.6405 | 10304.0 |
| 2004-09-13 08:25:00 | AAPL | Stock | 0.6405 | 0.6405 | 0.6405 | 0.6405 | 11200.0 |
| 2004-09-13 08:50:00 | AAPL | Stock | 0.6405 | 0.6405 | 0.6405 | 0.6405 | 11200.0 |
| 2004-09-13 09:25:00 | AAPL | Stock | 0.6405 | 0.6411 | 0.6405 | 0.6407 | 135296.0 |
| 2004-09-13 09:30:00 | AAPL | Stock | 0.6404 | 0.6413 | 0.637 | 0.6384 | 7303408.0 |
| 2004-09-13 09:35:00 | AAPL | Stock | 0.6384 | 0.6411 | 0.6382 | 0.6411 | 4107768.0 |
| 2004-09-13 09:40:00 | AAPL | Stock | 0.6411 | 0.6425 | 0.6402 | 0.6425 | 6183800.0 |
| 2004-09-13 09:45:00 | AAPL | Stock | 0.6425 | 0.6427 | 0.6416 | 0.642 | 4294640.0 |
| 2004-09-13 09:50:00 | AAPL | Stock | 0.642 | 0.6438 | 0.6413 | 0.6432 | 6067880.0 |
| 2004-09-13 09:55:00 | AAPL | Stock | 0.643 | 0.6438 | 0.6414 | 0.6432 | 3323432.0 |
| 2004-09-13 10:00:00 | AAPL | Stock | 0.643 | 0.6432 | 0.6405 | 0.6421 | 2355416.0 |
| 2004-09-13 10:05:00 | AAPL | Stock | 0.6429 | 0.6432 | 0.6398 | 0.6402 | 5424552.0 |
| 2004-09-13 10:10:00 | AAPL | Stock | 0.6402 | 0.6421 | 0.6402 | 0.6418 | 1284248.0 |
| 2004-09-13 10:15:00 | AAPL | Stock | 0.6416 | 0.643 | 0.6407 | 0.6407 | 11253648.0 |
| 2004-09-13 10:20:00 | AAPL | Stock | 0.6409 | 0.6418 | 0.6404 | 0.6411 | 3090752.0 |
| 2004-09-13 10:25:00 | AAPL | Stock | 0.6411 | 0.6414 | 0.6404 | 0.6413 | 3405248.0 |
| 2004-09-13 10:30:00 | AAPL | Stock | 0.6414 | 0.6414 | 0.6396 | 0.6398 | 1782872.0 |
| 2004-09-13 10:35:00 | AAPL | Stock | 0.6398 | 0.6402 | 0.6384 | 0.6386 | 3077872.0 |
| 2004-09-13 10:40:00 | AAPL | Stock | 0.6388 | 0.64 | 0.6386 | 0.64 | 3758776.0 |
| 2004-09-13 10:45:00 | AAPL | Stock | 0.6396 | 0.6404 | 0.6395 | 0.6404 | 2077320.0 |
| 2004-09-13 10:50:00 | AAPL | Stock | 0.6402 | 0.6407 | 0.6402 | 0.6405 | 1491560.0 |
| 2004-09-13 10:55:00 | AAPL | Stock | 0.6405 | 0.6423 | 0.6396 | 0.642 | 2920848.0 |
| 2004-09-13 11:00:00 | AAPL | Stock | 0.642 | 0.642 | 0.6409 | 0.6411 | 3368904.0 |
| 2004-09-13 11:05:00 | AAPL | Stock | 0.6409 | 0.6411 | 0.6409 | 0.6409 | 772520.0 |
| 2004-09-13 11:10:00 | AAPL | Stock | 0.6411 | 0.6413 | 0.6409 | 0.6413 | 2227232.0 |
| 2004-09-13 11:15:00 | AAPL | Stock | 0.6413 | 0.6432 | 0.6411 | 0.6432 | 10004232.0 |
| 2004-09-13 11:20:00 | AAPL | Stock | 0.6432 | 0.6436 | 0.6427 | 0.6427 | 1823808.0 |
| 2004-09-13 11:25:00 | AAPL | Stock | 0.6429 | 0.6432 | 0.6427 | 0.643 | 1388632.0 |
| 2004-09-13 11:30:00 | AAPL | Stock | 0.6432 | 0.6438 | 0.6429 | 0.643 | 2267328.0 |
| 2004-09-13 11:35:00 | AAPL | Stock | 0.643 | 0.6436 | 0.6427 | 0.6436 | 3745224.0 |
| 2004-09-13 11:40:00 | AAPL | Stock | 0.6436 | 0.6438 | 0.6434 | 0.6436 | 4160128.0 |
| 2004-09-13 11:45:00 | AAPL | Stock | 0.6436 | 0.6441 | 0.6429 | 0.6432 | 10689224.0 |
| 2004-09-13 11:50:00 | AAPL | Stock | 0.6432 | 0.6434 | 0.6421 | 0.6429 | 3295992.0 |
| 2004-09-13 11:55:00 | AAPL | Stock | 0.643 | 0.643 | 0.6416 | 0.642 | 1781752.0 |
| 2004-09-13 12:00:00 | AAPL | Stock | 0.642 | 0.6427 | 0.642 | 0.6421 | 1192968.0 |
| 2004-09-13 12:05:00 | AAPL | Stock | 0.6421 | 0.6425 | 0.6418 | 0.642 | 902944.0 |
| 2004-09-13 12:10:00 | AAPL | Stock | 0.6416 | 0.6419 | 0.6413 | 0.6414 | 1039584.0 |
| 2004-09-13 12:15:00 | AAPL | Stock | 0.6416 | 0.6425 | 0.6416 | 0.6423 | 936656.0 |
| 2004-09-13 12:20:00 | AAPL | Stock | 0.6425 | 0.6427 | 0.6423 | 0.6423 | 457912.0 |
| 2004-09-13 12:25:00 | AAPL | Stock | 0.6425 | 0.6427 | 0.642 | 0.6423 | 1032864.0 |
| 2004-09-13 12:30:00 | AAPL | Stock | 0.6423 | 0.6423 | 0.6414 | 0.6421 | 576800.0 |
| 2004-09-13 12:35:00 | AAPL | Stock | 0.6423 | 0.6425 | 0.6416 | 0.6425 | 895496.0 |
| 2004-09-13 12:40:00 | AAPL | Stock | 0.6423 | 0.6425 | 0.6413 | 0.6414 | 1102080.0 |
| 2004-09-13 12:45:00 | AAPL | Stock | 0.6416 | 0.6423 | 0.6414 | 0.642 | 785344.0 |
| 2004-09-13 12:50:00 | AAPL | Stock | 0.642 | 0.6425 | 0.6413 | 0.6413 | 818664.0 |
| 2004-09-13 12:55:00 | AAPL | Stock | 0.6413 | 0.6416 | 0.6413 | 0.6414 | 281960.0 |
| 2004-09-13 13:00:00 | AAPL | Stock | 0.6414 | 0.6423 | 0.6413 | 0.6422 | 731192.0 |
| 2004-09-13 13:05:00 | AAPL | Stock | 0.6423 | 0.6425 | 0.6409 | 0.6413 | 1804992.0 |
| 2004-09-13 13:10:00 | AAPL | Stock | 0.6413 | 0.6414 | 0.6411 | 0.6411 | 1445136.0 |
| 2004-09-13 13:15:00 | AAPL | Stock | 0.6413 | 0.6414 | 0.6411 | 0.6413 | 1149344.0 |
> showing 50 of 178,826 rows — these rows as CSV