PREVIEW / stock_5min / 2004-05-14
file: by_date/stock_5min/2004/2004-05-14.parquet size: 2.4 MB rows: 175,777 symbols: 1,766
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-05-14 09:00:00 | AAPL | Stock | 0.4855 | 0.4855 | 0.4855 | 0.4855 | 9688.0 |
| 2004-05-14 09:10:00 | AAPL | Stock | 0.4813 | 0.4839 | 0.4813 | 0.4839 | 72800.0 |
| 2004-05-14 09:15:00 | AAPL | Stock | 0.4839 | 0.4839 | 0.4839 | 0.4839 | 5600.0 |
| 2004-05-14 09:20:00 | AAPL | Stock | 0.4855 | 0.4855 | 0.4855 | 0.4855 | 16800.0 |
| 2004-05-14 09:25:00 | AAPL | Stock | 0.4855 | 0.4863 | 0.4838 | 0.4855 | 369208.0 |
| 2004-05-14 09:30:00 | AAPL | Stock | 0.4841 | 0.4879 | 0.4818 | 0.4868 | 7327768.0 |
| 2004-05-14 09:35:00 | AAPL | Stock | 0.4868 | 0.4871 | 0.4821 | 0.4821 | 3095792.0 |
| 2004-05-14 09:40:00 | AAPL | Stock | 0.4821 | 0.4857 | 0.4821 | 0.4838 | 3876320.0 |
| 2004-05-14 09:45:00 | AAPL | Stock | 0.4838 | 0.4839 | 0.4795 | 0.4813 | 4162984.0 |
| 2004-05-14 09:50:00 | AAPL | Stock | 0.4813 | 0.4838 | 0.4809 | 0.4809 | 6226416.0 |
| 2004-05-14 09:55:00 | AAPL | Stock | 0.4809 | 0.4816 | 0.4768 | 0.4782 | 5468960.0 |
| 2004-05-14 10:00:00 | AAPL | Stock | 0.4779 | 0.4784 | 0.4738 | 0.4745 | 9160200.0 |
| 2004-05-14 10:05:00 | AAPL | Stock | 0.4745 | 0.4766 | 0.4741 | 0.4754 | 10500560.0 |
| 2004-05-14 10:10:00 | AAPL | Stock | 0.4755 | 0.4755 | 0.4743 | 0.475 | 2015328.0 |
| 2004-05-14 10:15:00 | AAPL | Stock | 0.4748 | 0.4755 | 0.4732 | 0.4734 | 2612120.0 |
| 2004-05-14 10:20:00 | AAPL | Stock | 0.4732 | 0.4768 | 0.4725 | 0.4763 | 3103464.0 |
| 2004-05-14 10:25:00 | AAPL | Stock | 0.4759 | 0.4764 | 0.4745 | 0.4748 | 2466464.0 |
| 2004-05-14 10:30:00 | AAPL | Stock | 0.4746 | 0.4784 | 0.4741 | 0.478 | 3244808.0 |
| 2004-05-14 10:35:00 | AAPL | Stock | 0.4779 | 0.4779 | 0.4757 | 0.4761 | 2568216.0 |
| 2004-05-14 10:40:00 | AAPL | Stock | 0.4763 | 0.4773 | 0.4763 | 0.4768 | 2860984.0 |
| 2004-05-14 10:45:00 | AAPL | Stock | 0.4766 | 0.477 | 0.4759 | 0.4768 | 2010736.0 |
| 2004-05-14 10:50:00 | AAPL | Stock | 0.4764 | 0.4782 | 0.4764 | 0.4779 | 2087120.0 |
| 2004-05-14 10:55:00 | AAPL | Stock | 0.4782 | 0.4811 | 0.4782 | 0.48 | 3441144.0 |
| 2004-05-14 11:00:00 | AAPL | Stock | 0.4802 | 0.482 | 0.48 | 0.4809 | 1755264.0 |
| 2004-05-14 11:05:00 | AAPL | Stock | 0.4809 | 0.4809 | 0.4788 | 0.4789 | 1571192.0 |
| 2004-05-14 11:10:00 | AAPL | Stock | 0.4793 | 0.4798 | 0.4789 | 0.4789 | 1139936.0 |
| 2004-05-14 11:15:00 | AAPL | Stock | 0.4788 | 0.4793 | 0.4786 | 0.4786 | 834400.0 |
| 2004-05-14 11:20:00 | AAPL | Stock | 0.4786 | 0.4788 | 0.4777 | 0.4779 | 1130976.0 |
| 2004-05-14 11:25:00 | AAPL | Stock | 0.4777 | 0.4786 | 0.4773 | 0.4773 | 1299200.0 |
| 2004-05-14 11:30:00 | AAPL | Stock | 0.4773 | 0.4773 | 0.4761 | 0.4766 | 1505728.0 |
| 2004-05-14 11:35:00 | AAPL | Stock | 0.477 | 0.477 | 0.4741 | 0.4743 | 2942464.0 |
| 2004-05-14 11:40:00 | AAPL | Stock | 0.4741 | 0.4757 | 0.4741 | 0.4754 | 1327760.0 |
| 2004-05-14 11:45:00 | AAPL | Stock | 0.4752 | 0.4754 | 0.4746 | 0.4748 | 1622544.0 |
| 2004-05-14 11:50:00 | AAPL | Stock | 0.4748 | 0.4755 | 0.4745 | 0.4755 | 1304128.0 |
| 2004-05-14 11:55:00 | AAPL | Stock | 0.4757 | 0.4771 | 0.4755 | 0.4768 | 2796080.0 |
| 2004-05-14 12:00:00 | AAPL | Stock | 0.4768 | 0.4768 | 0.4754 | 0.4757 | 1303400.0 |
| 2004-05-14 12:05:00 | AAPL | Stock | 0.4761 | 0.4764 | 0.4746 | 0.475 | 2426704.0 |
| 2004-05-14 12:10:00 | AAPL | Stock | 0.4746 | 0.475 | 0.4745 | 0.475 | 698936.0 |
| 2004-05-14 12:15:00 | AAPL | Stock | 0.4748 | 0.4748 | 0.4741 | 0.4745 | 1585696.0 |
| 2004-05-14 12:20:00 | AAPL | Stock | 0.4745 | 0.475 | 0.4739 | 0.4741 | 1675464.0 |
| 2004-05-14 12:25:00 | AAPL | Stock | 0.4738 | 0.4741 | 0.4734 | 0.4738 | 1866312.0 |
| 2004-05-14 12:30:00 | AAPL | Stock | 0.4739 | 0.4745 | 0.4732 | 0.4734 | 2840488.0 |
| 2004-05-14 12:35:00 | AAPL | Stock | 0.4736 | 0.4741 | 0.4723 | 0.4723 | 4525304.0 |
| 2004-05-14 12:40:00 | AAPL | Stock | 0.4726 | 0.4739 | 0.4726 | 0.4739 | 1172696.0 |
| 2004-05-14 12:45:00 | AAPL | Stock | 0.4738 | 0.475 | 0.473 | 0.4746 | 2676240.0 |
| 2004-05-14 12:50:00 | AAPL | Stock | 0.4745 | 0.4745 | 0.4741 | 0.4741 | 1211784.0 |
| 2004-05-14 12:55:00 | AAPL | Stock | 0.4741 | 0.4754 | 0.4741 | 0.4745 | 2329432.0 |
| 2004-05-14 13:00:00 | AAPL | Stock | 0.4745 | 0.4775 | 0.4745 | 0.4763 | 3351376.0 |
| 2004-05-14 13:05:00 | AAPL | Stock | 0.4764 | 0.4773 | 0.4761 | 0.477 | 1706488.0 |
| 2004-05-14 13:10:00 | AAPL | Stock | 0.477 | 0.4786 | 0.4766 | 0.4779 | 2511208.0 |
> showing 50 of 175,777 rows — these rows as CSV