PREVIEW / stock_5min / 2004-09-22
file: by_date/stock_5min/2004/2004-09-22.parquet size: 2.4 MB rows: 177,859 symbols: 1,827
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-22 08:10:00 | AAPL | Stock | 0.6773 | 0.6816 | 0.6711 | 0.6711 | 50400.0 |
| 2004-09-22 08:35:00 | AAPL | Stock | 0.6796 | 0.6796 | 0.6786 | 0.6786 | 56000.0 |
| 2004-09-22 08:40:00 | AAPL | Stock | 0.6839 | 0.6839 | 0.6834 | 0.6834 | 56000.0 |
| 2004-09-22 09:05:00 | AAPL | Stock | 0.6777 | 0.6777 | 0.6777 | 0.6777 | 11200.0 |
| 2004-09-22 09:10:00 | AAPL | Stock | 0.6779 | 0.6786 | 0.6777 | 0.6786 | 145600.0 |
| 2004-09-22 09:15:00 | AAPL | Stock | 0.6795 | 0.6795 | 0.6795 | 0.6795 | 95200.0 |
| 2004-09-22 09:20:00 | AAPL | Stock | 0.6816 | 0.6818 | 0.6816 | 0.6818 | 50400.0 |
| 2004-09-22 09:25:00 | AAPL | Stock | 0.6838 | 0.6838 | 0.6805 | 0.6805 | 371392.0 |
| 2004-09-22 09:30:00 | AAPL | Stock | 0.6804 | 0.6805 | 0.6771 | 0.6786 | 12634272.0 |
| 2004-09-22 09:35:00 | AAPL | Stock | 0.6786 | 0.6811 | 0.6782 | 0.6786 | 8835232.0 |
| 2004-09-22 09:40:00 | AAPL | Stock | 0.6788 | 0.6793 | 0.6763 | 0.6764 | 9849672.0 |
| 2004-09-22 09:45:00 | AAPL | Stock | 0.6764 | 0.677 | 0.6729 | 0.6763 | 6509496.0 |
| 2004-09-22 09:50:00 | AAPL | Stock | 0.6764 | 0.6766 | 0.6748 | 0.6748 | 5294576.0 |
| 2004-09-22 09:55:00 | AAPL | Stock | 0.6752 | 0.6759 | 0.6741 | 0.6741 | 4045272.0 |
| 2004-09-22 10:00:00 | AAPL | Stock | 0.6741 | 0.6752 | 0.6714 | 0.6716 | 7745696.0 |
| 2004-09-22 10:05:00 | AAPL | Stock | 0.6716 | 0.6734 | 0.67 | 0.6721 | 9488080.0 |
| 2004-09-22 10:10:00 | AAPL | Stock | 0.672 | 0.6725 | 0.6705 | 0.6713 | 6541024.0 |
| 2004-09-22 10:15:00 | AAPL | Stock | 0.6714 | 0.6725 | 0.667 | 0.6684 | 11208064.0 |
| 2004-09-22 10:20:00 | AAPL | Stock | 0.6684 | 0.6702 | 0.6673 | 0.6688 | 6633032.0 |
| 2004-09-22 10:25:00 | AAPL | Stock | 0.6691 | 0.6705 | 0.6689 | 0.6695 | 4316256.0 |
| 2004-09-22 10:30:00 | AAPL | Stock | 0.6695 | 0.6698 | 0.6657 | 0.6659 | 6869072.0 |
| 2004-09-22 10:35:00 | AAPL | Stock | 0.6657 | 0.6689 | 0.6648 | 0.6673 | 8202376.0 |
| 2004-09-22 10:40:00 | AAPL | Stock | 0.6673 | 0.6673 | 0.6648 | 0.6657 | 3830232.0 |
| 2004-09-22 10:45:00 | AAPL | Stock | 0.6654 | 0.6657 | 0.6609 | 0.6614 | 7984816.0 |
| 2004-09-22 10:50:00 | AAPL | Stock | 0.6614 | 0.6638 | 0.66 | 0.6636 | 11382280.0 |
| 2004-09-22 10:55:00 | AAPL | Stock | 0.6636 | 0.6641 | 0.6629 | 0.6639 | 4217080.0 |
| 2004-09-22 11:00:00 | AAPL | Stock | 0.6639 | 0.6645 | 0.6629 | 0.6643 | 3320856.0 |
| 2004-09-22 11:05:00 | AAPL | Stock | 0.6643 | 0.6652 | 0.6621 | 0.6625 | 5038936.0 |
| 2004-09-22 11:10:00 | AAPL | Stock | 0.6621 | 0.6643 | 0.6614 | 0.6639 | 5434968.0 |
| 2004-09-22 11:15:00 | AAPL | Stock | 0.6639 | 0.6643 | 0.6632 | 0.6638 | 5843096.0 |
| 2004-09-22 11:20:00 | AAPL | Stock | 0.6639 | 0.6668 | 0.6638 | 0.6666 | 5585272.0 |
| 2004-09-22 11:25:00 | AAPL | Stock | 0.6666 | 0.6666 | 0.6659 | 0.6663 | 2603384.0 |
| 2004-09-22 11:30:00 | AAPL | Stock | 0.6661 | 0.6663 | 0.6643 | 0.6652 | 3459120.0 |
| 2004-09-22 11:35:00 | AAPL | Stock | 0.665 | 0.6652 | 0.6636 | 0.6638 | 1366792.0 |
| 2004-09-22 11:40:00 | AAPL | Stock | 0.6638 | 0.6639 | 0.6627 | 0.663 | 2798432.0 |
| 2004-09-22 11:45:00 | AAPL | Stock | 0.6632 | 0.6638 | 0.6607 | 0.6613 | 4961600.0 |
| 2004-09-22 11:50:00 | AAPL | Stock | 0.6614 | 0.6623 | 0.6613 | 0.6621 | 2327584.0 |
| 2004-09-22 11:55:00 | AAPL | Stock | 0.6621 | 0.6621 | 0.6598 | 0.66 | 7358736.0 |
| 2004-09-22 12:00:00 | AAPL | Stock | 0.66 | 0.6602 | 0.6573 | 0.6577 | 9467808.0 |
| 2004-09-22 12:05:00 | AAPL | Stock | 0.6577 | 0.6602 | 0.6575 | 0.6602 | 3110576.0 |
| 2004-09-22 12:10:00 | AAPL | Stock | 0.6604 | 0.6627 | 0.66 | 0.6625 | 3599960.0 |
| 2004-09-22 12:15:00 | AAPL | Stock | 0.6625 | 0.6636 | 0.6613 | 0.6625 | 34080032.0 |
| 2004-09-22 12:20:00 | AAPL | Stock | 0.6625 | 0.6636 | 0.6623 | 0.6636 | 2146368.0 |
| 2004-09-22 12:25:00 | AAPL | Stock | 0.6634 | 0.6655 | 0.6634 | 0.6652 | 3403512.0 |
| 2004-09-22 12:30:00 | AAPL | Stock | 0.665 | 0.6655 | 0.6632 | 0.6639 | 3182816.0 |
| 2004-09-22 12:35:00 | AAPL | Stock | 0.6636 | 0.665 | 0.6634 | 0.6648 | 2812880.0 |
| 2004-09-22 12:40:00 | AAPL | Stock | 0.6648 | 0.6655 | 0.6646 | 0.6648 | 915768.0 |
| 2004-09-22 12:45:00 | AAPL | Stock | 0.6646 | 0.6671 | 0.6646 | 0.6668 | 2908080.0 |
| 2004-09-22 12:50:00 | AAPL | Stock | 0.667 | 0.6673 | 0.6661 | 0.6661 | 5340496.0 |
| 2004-09-22 12:55:00 | AAPL | Stock | 0.6659 | 0.6659 | 0.6634 | 0.6634 | 1794072.0 |
> showing 50 of 177,859 rows — these rows as CSV