PREVIEW / stock_5min / 2006-06-15
file: by_date/stock_5min/2006/2006-06-15.parquet size: 3.2 MB rows: 231,365 symbols: 2,289
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-06-15 05:35:00 | AAPL | Stock | 2.0571 | 2.0571 | 2.0571 | 2.0571 | 14000.0 |
| 2006-06-15 05:40:00 | AAPL | Stock | 2.0571 | 2.0571 | 2.0571 | 2.0571 | 84000.0 |
| 2006-06-15 06:05:00 | AAPL | Stock | 2.0589 | 2.0589 | 2.0589 | 2.0589 | 14000.0 |
| 2006-06-15 06:10:00 | AAPL | Stock | 2.0589 | 2.0589 | 2.0589 | 2.0589 | 8288.0 |
| 2006-06-15 06:25:00 | AAPL | Stock | 2.0571 | 2.0571 | 2.0571 | 2.0571 | 5600.0 |
| 2006-06-15 06:45:00 | AAPL | Stock | 2.0571 | 2.0571 | 2.0571 | 2.0571 | 12600.0 |
| 2006-06-15 06:50:00 | AAPL | Stock | 2.0625 | 2.0643 | 2.0625 | 2.0643 | 19600.0 |
| 2006-06-15 06:55:00 | AAPL | Stock | 2.0643 | 2.0643 | 2.0643 | 2.0643 | 14000.0 |
| 2006-06-15 07:10:00 | AAPL | Stock | 2.0643 | 2.0643 | 2.0643 | 2.0643 | 19600.0 |
| 2006-06-15 07:15:00 | AAPL | Stock | 2.0571 | 2.0571 | 2.0571 | 2.0571 | 28000.0 |
| 2006-06-15 07:40:00 | AAPL | Stock | 2.0636 | 2.0661 | 2.0636 | 2.0661 | 165200.0 |
| 2006-06-15 07:50:00 | AAPL | Stock | 2.0589 | 2.0589 | 2.0518 | 2.0518 | 19600.0 |
| 2006-06-15 08:00:00 | AAPL | Stock | 2.0571 | 2.0657 | 2.0471 | 2.0625 | 645120.0 |
| 2006-06-15 08:05:00 | AAPL | Stock | 2.0654 | 2.0768 | 2.0654 | 2.0714 | 669592.0 |
| 2006-06-15 08:10:00 | AAPL | Stock | 2.0714 | 2.0746 | 2.0696 | 2.0732 | 414120.0 |
| 2006-06-15 08:15:00 | AAPL | Stock | 2.0743 | 2.075 | 2.0714 | 2.0743 | 459536.0 |
| 2006-06-15 08:20:00 | AAPL | Stock | 2.0739 | 2.0746 | 2.0707 | 2.0714 | 768404.0 |
| 2006-06-15 08:25:00 | AAPL | Stock | 2.0696 | 2.0732 | 2.0693 | 2.0732 | 173040.0 |
| 2006-06-15 08:30:00 | AAPL | Stock | 2.0714 | 2.0732 | 2.0707 | 2.0714 | 277592.0 |
| 2006-06-15 08:35:00 | AAPL | Stock | 2.0725 | 2.0725 | 2.0682 | 2.0696 | 161280.0 |
| 2006-06-15 08:40:00 | AAPL | Stock | 2.0689 | 2.0721 | 2.0689 | 2.0721 | 165200.0 |
| 2006-06-15 08:45:00 | AAPL | Stock | 2.0714 | 2.0718 | 2.0707 | 2.0711 | 134064.0 |
| 2006-06-15 08:50:00 | AAPL | Stock | 2.0711 | 2.0714 | 2.0689 | 2.0689 | 346752.0 |
| 2006-06-15 08:55:00 | AAPL | Stock | 2.0686 | 2.07 | 2.0632 | 2.0646 | 688884.0 |
| 2006-06-15 09:00:00 | AAPL | Stock | 2.0632 | 2.0661 | 2.0618 | 2.0621 | 540652.0 |
| 2006-06-15 09:05:00 | AAPL | Stock | 2.0621 | 2.0625 | 2.0479 | 2.0504 | 1533868.0 |
| 2006-06-15 09:10:00 | AAPL | Stock | 2.0507 | 2.0571 | 2.05 | 2.0554 | 794696.0 |
| 2006-06-15 09:15:00 | AAPL | Stock | 2.0536 | 2.0536 | 2.0446 | 2.05 | 442372.0 |
| 2006-06-15 09:20:00 | AAPL | Stock | 2.05 | 2.0529 | 2.0482 | 2.0521 | 384300.0 |
| 2006-06-15 09:25:00 | AAPL | Stock | 2.0525 | 2.0554 | 2.0471 | 2.0471 | 1746304.0 |
| 2006-06-15 09:30:00 | AAPL | Stock | 2.0464 | 2.0529 | 2.0346 | 2.0361 | 33948740.0 |
| 2006-06-15 09:35:00 | AAPL | Stock | 2.0357 | 2.0414 | 2.0296 | 2.0371 | 30212812.0 |
| 2006-06-15 09:40:00 | AAPL | Stock | 2.0371 | 2.0393 | 2.0268 | 2.0311 | 28448308.0 |
| 2006-06-15 09:45:00 | AAPL | Stock | 2.0311 | 2.0404 | 2.03 | 2.0393 | 28184856.0 |
| 2006-06-15 09:50:00 | AAPL | Stock | 2.0389 | 2.0436 | 2.0314 | 2.0364 | 22108240.0 |
| 2006-06-15 09:55:00 | AAPL | Stock | 2.0367 | 2.04 | 2.0321 | 2.0361 | 15538124.0 |
| 2006-06-15 10:00:00 | AAPL | Stock | 2.0357 | 2.05 | 2.035 | 2.0443 | 25849264.0 |
| 2006-06-15 10:05:00 | AAPL | Stock | 2.0443 | 2.0632 | 2.0414 | 2.0621 | 27199368.0 |
| 2006-06-15 10:10:00 | AAPL | Stock | 2.0625 | 2.0679 | 2.0568 | 2.0621 | 30390640.0 |
| 2006-06-15 10:15:00 | AAPL | Stock | 2.0621 | 2.0725 | 2.0618 | 2.0725 | 25777472.0 |
| 2006-06-15 10:20:00 | AAPL | Stock | 2.0725 | 2.0821 | 2.0661 | 2.0675 | 21586404.0 |
| 2006-06-15 10:25:00 | AAPL | Stock | 2.0671 | 2.0704 | 2.0496 | 2.0625 | 17420256.0 |
| 2006-06-15 10:30:00 | AAPL | Stock | 2.0625 | 2.0714 | 2.0593 | 2.0711 | 19780348.0 |
| 2006-06-15 10:35:00 | AAPL | Stock | 2.0711 | 2.0714 | 2.0589 | 2.0593 | 16140656.0 |
| 2006-06-15 10:40:00 | AAPL | Stock | 2.0593 | 2.0664 | 2.0579 | 2.0629 | 17022600.0 |
| 2006-06-15 10:45:00 | AAPL | Stock | 2.0629 | 2.0668 | 2.0546 | 2.0554 | 20211380.0 |
| 2006-06-15 10:50:00 | AAPL | Stock | 2.0554 | 2.0586 | 2.0532 | 2.0571 | 13883940.0 |
| 2006-06-15 10:55:00 | AAPL | Stock | 2.0571 | 2.0618 | 2.0568 | 2.0604 | 8758092.0 |
| 2006-06-15 11:00:00 | AAPL | Stock | 2.0604 | 2.0639 | 2.06 | 2.0604 | 10937444.0 |
| 2006-06-15 11:05:00 | AAPL | Stock | 2.0607 | 2.0679 | 2.0586 | 2.0621 | 7353668.0 |
> showing 50 of 231,365 rows — these rows as CSV