PREVIEW / stock_5min / 2004-11-09
file: by_date/stock_5min/2004/2004-11-09.parquet size: 2.5 MB rows: 183,372 symbols: 1,866
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-11-09 08:00:00 | AAPL | Stock | 0.9739 | 0.9741 | 0.9711 | 0.9732 | 190400.0 |
| 2004-11-09 08:05:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 64400.0 |
| 2004-11-09 08:10:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9718 | 0.9718 | 81200.0 |
| 2004-11-09 08:15:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 28000.0 |
| 2004-11-09 08:20:00 | AAPL | Stock | 0.9711 | 0.9711 | 0.9711 | 0.9711 | 669536.0 |
| 2004-11-09 08:25:00 | AAPL | Stock | 0.9711 | 0.9711 | 0.9711 | 0.9711 | 669536.0 |
| 2004-11-09 08:30:00 | AAPL | Stock | 0.9723 | 0.9723 | 0.9723 | 0.9723 | 56000.0 |
| 2004-11-09 08:35:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9718 | 0.9721 | 106400.0 |
| 2004-11-09 08:45:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 16800.0 |
| 2004-11-09 08:50:00 | AAPL | Stock | 0.9723 | 0.9723 | 0.9723 | 0.9723 | 16800.0 |
| 2004-11-09 09:10:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 28000.0 |
| 2004-11-09 09:15:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 16800.0 |
| 2004-11-09 09:20:00 | AAPL | Stock | 0.9718 | 0.9718 | 0.9704 | 0.9705 | 171920.0 |
| 2004-11-09 09:25:00 | AAPL | Stock | 0.9714 | 0.9721 | 0.9679 | 0.9695 | 723240.0 |
| 2004-11-09 09:30:00 | AAPL | Stock | 0.9679 | 0.9705 | 0.9643 | 0.9661 | 19047560.0 |
| 2004-11-09 09:35:00 | AAPL | Stock | 0.9661 | 0.9727 | 0.9659 | 0.9713 | 15841056.0 |
| 2004-11-09 09:40:00 | AAPL | Stock | 0.9713 | 0.972 | 0.9671 | 0.9684 | 13411496.0 |
| 2004-11-09 09:45:00 | AAPL | Stock | 0.9684 | 0.9709 | 0.9671 | 0.9691 | 13522376.0 |
| 2004-11-09 09:50:00 | AAPL | Stock | 0.9693 | 0.9698 | 0.967 | 0.9688 | 6027392.0 |
| 2004-11-09 09:55:00 | AAPL | Stock | 0.9684 | 0.9691 | 0.9621 | 0.9634 | 10221512.0 |
| 2004-11-09 10:00:00 | AAPL | Stock | 0.9634 | 0.9646 | 0.9584 | 0.9607 | 20435520.0 |
| 2004-11-09 10:05:00 | AAPL | Stock | 0.9607 | 0.9632 | 0.9607 | 0.9616 | 6281408.0 |
| 2004-11-09 10:10:00 | AAPL | Stock | 0.9614 | 0.962 | 0.9561 | 0.957 | 15003632.0 |
| 2004-11-09 10:15:00 | AAPL | Stock | 0.957 | 0.9596 | 0.9563 | 0.9588 | 9971136.0 |
| 2004-11-09 10:20:00 | AAPL | Stock | 0.9589 | 0.9625 | 0.958 | 0.9616 | 7066864.0 |
| 2004-11-09 10:25:00 | AAPL | Stock | 0.9616 | 0.9618 | 0.9598 | 0.9613 | 5319440.0 |
| 2004-11-09 10:30:00 | AAPL | Stock | 0.9611 | 0.962 | 0.9602 | 0.9607 | 7699888.0 |
| 2004-11-09 10:35:00 | AAPL | Stock | 0.9602 | 0.9614 | 0.9588 | 0.9595 | 6156528.0 |
| 2004-11-09 10:40:00 | AAPL | Stock | 0.9595 | 0.96 | 0.9575 | 0.9582 | 5331592.0 |
| 2004-11-09 10:45:00 | AAPL | Stock | 0.9582 | 0.9584 | 0.9564 | 0.9564 | 5753664.0 |
| 2004-11-09 10:50:00 | AAPL | Stock | 0.9563 | 0.957 | 0.9532 | 0.9566 | 14182616.0 |
| 2004-11-09 10:55:00 | AAPL | Stock | 0.9566 | 0.9591 | 0.9557 | 0.9586 | 6999440.0 |
| 2004-11-09 11:00:00 | AAPL | Stock | 0.9584 | 0.9598 | 0.958 | 0.9584 | 5240648.0 |
| 2004-11-09 11:05:00 | AAPL | Stock | 0.9584 | 0.9602 | 0.9571 | 0.9602 | 7046984.0 |
| 2004-11-09 11:10:00 | AAPL | Stock | 0.9602 | 0.9616 | 0.96 | 0.9607 | 4601296.0 |
| 2004-11-09 11:15:00 | AAPL | Stock | 0.9609 | 0.9613 | 0.96 | 0.9602 | 2430232.0 |
| 2004-11-09 11:20:00 | AAPL | Stock | 0.9604 | 0.9636 | 0.9604 | 0.962 | 6292160.0 |
| 2004-11-09 11:25:00 | AAPL | Stock | 0.9618 | 0.9618 | 0.9602 | 0.9609 | 3629360.0 |
| 2004-11-09 11:30:00 | AAPL | Stock | 0.9607 | 0.9618 | 0.9607 | 0.9616 | 3520944.0 |
| 2004-11-09 11:35:00 | AAPL | Stock | 0.9616 | 0.9625 | 0.9609 | 0.9609 | 3178896.0 |
| 2004-11-09 11:40:00 | AAPL | Stock | 0.9613 | 0.9614 | 0.9591 | 0.9613 | 3074288.0 |
| 2004-11-09 11:45:00 | AAPL | Stock | 0.9611 | 0.9611 | 0.9602 | 0.9607 | 885248.0 |
| 2004-11-09 11:50:00 | AAPL | Stock | 0.9607 | 0.9614 | 0.9602 | 0.9607 | 2617496.0 |
| 2004-11-09 11:55:00 | AAPL | Stock | 0.9605 | 0.9607 | 0.9591 | 0.9605 | 3205440.0 |
| 2004-11-09 12:00:00 | AAPL | Stock | 0.9607 | 0.9625 | 0.9605 | 0.9618 | 2859304.0 |
| 2004-11-09 12:05:00 | AAPL | Stock | 0.9618 | 0.9638 | 0.9618 | 0.9634 | 4719736.0 |
| 2004-11-09 12:10:00 | AAPL | Stock | 0.9634 | 0.9657 | 0.9632 | 0.965 | 4115216.0 |
| 2004-11-09 12:15:00 | AAPL | Stock | 0.965 | 0.965 | 0.9641 | 0.9641 | 2746296.0 |
| 2004-11-09 12:20:00 | AAPL | Stock | 0.9639 | 0.9664 | 0.9636 | 0.9659 | 4404792.0 |
| 2004-11-09 12:25:00 | AAPL | Stock | 0.9655 | 0.9657 | 0.9643 | 0.9645 | 3475696.0 |
> showing 50 of 183,372 rows — these rows as CSV