PREVIEW / stock_5min / 2004-04-28
file: by_date/stock_5min/2004/2004-04-28.parquet size: 2.5 MB rows: 180,267 symbols: 1,759
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-04-28 09:25:00 | AAPL | Stock | 0.4805 | 0.4805 | 0.4798 | 0.4804 | 28000.0 |
| 2004-04-28 09:30:00 | AAPL | Stock | 0.4791 | 0.4821 | 0.4786 | 0.4813 | 3385984.0 |
| 2004-04-28 09:35:00 | AAPL | Stock | 0.4813 | 0.4821 | 0.4795 | 0.4813 | 2954504.0 |
| 2004-04-28 09:40:00 | AAPL | Stock | 0.4813 | 0.4823 | 0.4813 | 0.4816 | 6932912.0 |
| 2004-04-28 09:45:00 | AAPL | Stock | 0.482 | 0.4821 | 0.4791 | 0.4798 | 2944760.0 |
| 2004-04-28 09:50:00 | AAPL | Stock | 0.4802 | 0.4807 | 0.475 | 0.4768 | 4157888.0 |
| 2004-04-28 09:55:00 | AAPL | Stock | 0.4768 | 0.4796 | 0.4755 | 0.4795 | 8187424.0 |
| 2004-04-28 10:00:00 | AAPL | Stock | 0.4796 | 0.4813 | 0.4786 | 0.4809 | 2140544.0 |
| 2004-04-28 10:05:00 | AAPL | Stock | 0.4809 | 0.4809 | 0.4741 | 0.4759 | 3124688.0 |
| 2004-04-28 10:10:00 | AAPL | Stock | 0.4759 | 0.4768 | 0.4757 | 0.4766 | 903672.0 |
| 2004-04-28 10:15:00 | AAPL | Stock | 0.4768 | 0.4773 | 0.4764 | 0.4772 | 1572368.0 |
| 2004-04-28 10:20:00 | AAPL | Stock | 0.4773 | 0.4786 | 0.4771 | 0.4777 | 1582168.0 |
| 2004-04-28 10:25:00 | AAPL | Stock | 0.4779 | 0.4784 | 0.477 | 0.4779 | 2030560.0 |
| 2004-04-28 10:30:00 | AAPL | Stock | 0.4779 | 0.4779 | 0.4763 | 0.4773 | 1401736.0 |
| 2004-04-28 10:35:00 | AAPL | Stock | 0.4775 | 0.478 | 0.4768 | 0.4779 | 1367744.0 |
| 2004-04-28 10:40:00 | AAPL | Stock | 0.4778 | 0.4782 | 0.4773 | 0.4775 | 634872.0 |
| 2004-04-28 10:45:00 | AAPL | Stock | 0.4775 | 0.4777 | 0.4771 | 0.4771 | 805392.0 |
| 2004-04-28 10:50:00 | AAPL | Stock | 0.477 | 0.4771 | 0.4766 | 0.4768 | 1265432.0 |
| 2004-04-28 10:55:00 | AAPL | Stock | 0.4766 | 0.4766 | 0.4759 | 0.4763 | 1901368.0 |
| 2004-04-28 11:00:00 | AAPL | Stock | 0.4761 | 0.4766 | 0.4759 | 0.4764 | 2520840.0 |
| 2004-04-28 11:05:00 | AAPL | Stock | 0.4764 | 0.4771 | 0.4755 | 0.4755 | 4815272.0 |
| 2004-04-28 11:10:00 | AAPL | Stock | 0.4755 | 0.4773 | 0.4755 | 0.4763 | 1248072.0 |
| 2004-04-28 11:15:00 | AAPL | Stock | 0.4763 | 0.4764 | 0.4757 | 0.4761 | 601048.0 |
| 2004-04-28 11:20:00 | AAPL | Stock | 0.4761 | 0.4761 | 0.4732 | 0.4741 | 3344824.0 |
| 2004-04-28 11:25:00 | AAPL | Stock | 0.4743 | 0.4745 | 0.4734 | 0.4734 | 1767640.0 |
| 2004-04-28 11:30:00 | AAPL | Stock | 0.4734 | 0.4738 | 0.4732 | 0.4736 | 2553096.0 |
| 2004-04-28 11:35:00 | AAPL | Stock | 0.4738 | 0.4752 | 0.4738 | 0.4752 | 1086232.0 |
| 2004-04-28 11:40:00 | AAPL | Stock | 0.475 | 0.4752 | 0.4745 | 0.4746 | 999768.0 |
| 2004-04-28 11:45:00 | AAPL | Stock | 0.4746 | 0.4748 | 0.4741 | 0.4746 | 1524320.0 |
| 2004-04-28 11:50:00 | AAPL | Stock | 0.4745 | 0.4755 | 0.4745 | 0.4755 | 542360.0 |
| 2004-04-28 11:55:00 | AAPL | Stock | 0.4757 | 0.4779 | 0.4757 | 0.477 | 1879584.0 |
| 2004-04-28 12:00:00 | AAPL | Stock | 0.477 | 0.477 | 0.4757 | 0.4759 | 869736.0 |
| 2004-04-28 12:05:00 | AAPL | Stock | 0.4761 | 0.4761 | 0.4748 | 0.4752 | 790048.0 |
| 2004-04-28 12:10:00 | AAPL | Stock | 0.4755 | 0.4764 | 0.4754 | 0.4757 | 999152.0 |
| 2004-04-28 12:15:00 | AAPL | Stock | 0.4757 | 0.4771 | 0.4757 | 0.4768 | 1753584.0 |
| 2004-04-28 12:20:00 | AAPL | Stock | 0.4766 | 0.478 | 0.4763 | 0.4771 | 1779512.0 |
| 2004-04-28 12:25:00 | AAPL | Stock | 0.477 | 0.4784 | 0.477 | 0.4784 | 1395016.0 |
| 2004-04-28 12:30:00 | AAPL | Stock | 0.478 | 0.478 | 0.4777 | 0.478 | 1004696.0 |
| 2004-04-28 12:35:00 | AAPL | Stock | 0.478 | 0.4782 | 0.478 | 0.4782 | 141288.0 |
| 2004-04-28 12:40:00 | AAPL | Stock | 0.478 | 0.4788 | 0.478 | 0.4786 | 3187240.0 |
| 2004-04-28 12:45:00 | AAPL | Stock | 0.4786 | 0.4789 | 0.4786 | 0.4789 | 954408.0 |
| 2004-04-28 12:50:00 | AAPL | Stock | 0.4789 | 0.4789 | 0.4786 | 0.4786 | 892528.0 |
| 2004-04-28 12:55:00 | AAPL | Stock | 0.4786 | 0.4789 | 0.4786 | 0.4788 | 731640.0 |
| 2004-04-28 13:00:00 | AAPL | Stock | 0.4786 | 0.4788 | 0.4784 | 0.4784 | 1418256.0 |
| 2004-04-28 13:05:00 | AAPL | Stock | 0.4782 | 0.4784 | 0.4777 | 0.478 | 459200.0 |
| 2004-04-28 13:10:00 | AAPL | Stock | 0.4784 | 0.4786 | 0.4779 | 0.4782 | 699272.0 |
| 2004-04-28 13:15:00 | AAPL | Stock | 0.4782 | 0.4784 | 0.4777 | 0.4782 | 475888.0 |
| 2004-04-28 13:20:00 | AAPL | Stock | 0.4782 | 0.4782 | 0.4779 | 0.4779 | 252560.0 |
| 2004-04-28 13:25:00 | AAPL | Stock | 0.4779 | 0.4779 | 0.4777 | 0.4777 | 291704.0 |
| 2004-04-28 13:30:00 | AAPL | Stock | 0.4777 | 0.4782 | 0.4777 | 0.478 | 399616.0 |
> showing 50 of 180,267 rows — these rows as CSV