PREVIEW / stock_1min / 2004-04-28
file: by_date/stock_1min/2004/2004-04-28.parquet size: 6.2 MB rows: 507,774 symbols: 1,444
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:29:00 | AAPL | Stock | 0.4805 | 0.4805 | 0.4798 | 0.4804 | 28000.0 |
| 2004-04-28 09:30:00 | AAPL | Stock | 0.4791 | 0.4805 | 0.4786 | 0.4791 | 1771560.0 |
| 2004-04-28 09:31:00 | AAPL | Stock | 0.4791 | 0.4821 | 0.4791 | 0.4821 | 768992.0 |
| 2004-04-28 09:32:00 | AAPL | Stock | 0.4821 | 0.4821 | 0.4805 | 0.4816 | 455448.0 |
| 2004-04-28 09:33:00 | AAPL | Stock | 0.4814 | 0.4814 | 0.4809 | 0.4813 | 117600.0 |
| 2004-04-28 09:34:00 | AAPL | Stock | 0.4813 | 0.4813 | 0.4811 | 0.4813 | 272384.0 |
| 2004-04-28 09:35:00 | AAPL | Stock | 0.4813 | 0.4816 | 0.4804 | 0.4804 | 883008.0 |
| 2004-04-28 09:36:00 | AAPL | Stock | 0.4804 | 0.4807 | 0.4795 | 0.4807 | 890344.0 |
| 2004-04-28 09:37:00 | AAPL | Stock | 0.4802 | 0.4811 | 0.4798 | 0.4802 | 322168.0 |
| 2004-04-28 09:38:00 | AAPL | Stock | 0.4802 | 0.4802 | 0.4795 | 0.48 | 73920.0 |
| 2004-04-28 09:39:00 | AAPL | Stock | 0.48 | 0.4821 | 0.48 | 0.4813 | 785064.0 |
| 2004-04-28 09:40:00 | AAPL | Stock | 0.4813 | 0.4821 | 0.4813 | 0.4816 | 725704.0 |
| 2004-04-28 09:41:00 | AAPL | Stock | 0.4816 | 0.4821 | 0.4814 | 0.4821 | 3151512.0 |
| 2004-04-28 09:42:00 | AAPL | Stock | 0.4821 | 0.4823 | 0.4816 | 0.4823 | 1016232.0 |
| 2004-04-28 09:43:00 | AAPL | Stock | 0.482 | 0.4823 | 0.4813 | 0.4814 | 922040.0 |
| 2004-04-28 09:44:00 | AAPL | Stock | 0.4813 | 0.4818 | 0.4813 | 0.4816 | 1117424.0 |
| 2004-04-28 09:45:00 | AAPL | Stock | 0.482 | 0.4821 | 0.4813 | 0.4813 | 1037960.0 |
| 2004-04-28 09:46:00 | AAPL | Stock | 0.4813 | 0.4816 | 0.4807 | 0.4809 | 553672.0 |
| 2004-04-28 09:47:00 | AAPL | Stock | 0.4807 | 0.4809 | 0.4791 | 0.48 | 699720.0 |
| 2004-04-28 09:48:00 | AAPL | Stock | 0.48 | 0.4804 | 0.4795 | 0.48 | 495432.0 |
| 2004-04-28 09:49:00 | AAPL | Stock | 0.4807 | 0.4807 | 0.4798 | 0.4798 | 157976.0 |
| 2004-04-28 09:50:00 | AAPL | Stock | 0.4802 | 0.4805 | 0.4796 | 0.4796 | 364336.0 |
| 2004-04-28 09:51:00 | AAPL | Stock | 0.4795 | 0.4802 | 0.4795 | 0.4802 | 540008.0 |
| 2004-04-28 09:52:00 | AAPL | Stock | 0.4798 | 0.4807 | 0.4795 | 0.48 | 490952.0 |
| 2004-04-28 09:53:00 | AAPL | Stock | 0.48 | 0.48 | 0.4786 | 0.4786 | 794528.0 |
| 2004-04-28 09:54:00 | AAPL | Stock | 0.4786 | 0.4786 | 0.475 | 0.4768 | 1968064.0 |
| 2004-04-28 09:55:00 | AAPL | Stock | 0.4768 | 0.4773 | 0.4755 | 0.4773 | 1402800.0 |
| 2004-04-28 09:56:00 | AAPL | Stock | 0.4775 | 0.4782 | 0.4773 | 0.4779 | 525224.0 |
| 2004-04-28 09:57:00 | AAPL | Stock | 0.4779 | 0.4784 | 0.4773 | 0.478 | 495992.0 |
| 2004-04-28 09:58:00 | AAPL | Stock | 0.478 | 0.4788 | 0.478 | 0.4782 | 1556800.0 |
| 2004-04-28 09:59:00 | AAPL | Stock | 0.4786 | 0.4796 | 0.4786 | 0.4795 | 4206608.0 |
| 2004-04-28 10:00:00 | AAPL | Stock | 0.4796 | 0.48 | 0.4789 | 0.48 | 529032.0 |
| 2004-04-28 10:01:00 | AAPL | Stock | 0.48 | 0.48 | 0.4788 | 0.4788 | 351344.0 |
| 2004-04-28 10:02:00 | AAPL | Stock | 0.4786 | 0.4796 | 0.4786 | 0.4795 | 255640.0 |
| 2004-04-28 10:03:00 | AAPL | Stock | 0.4798 | 0.4798 | 0.4795 | 0.4795 | 202608.0 |
| 2004-04-28 10:04:00 | AAPL | Stock | 0.4796 | 0.4813 | 0.4795 | 0.4809 | 801920.0 |
| 2004-04-28 10:05:00 | AAPL | Stock | 0.4809 | 0.4809 | 0.4802 | 0.4802 | 235200.0 |
| 2004-04-28 10:06:00 | AAPL | Stock | 0.4802 | 0.4802 | 0.4788 | 0.4788 | 325416.0 |
| 2004-04-28 10:07:00 | AAPL | Stock | 0.4786 | 0.4788 | 0.4741 | 0.4741 | 1435504.0 |
| 2004-04-28 10:08:00 | AAPL | Stock | 0.4745 | 0.4764 | 0.4743 | 0.4761 | 1036784.0 |
| 2004-04-28 10:09:00 | AAPL | Stock | 0.4761 | 0.4761 | 0.4757 | 0.4759 | 91784.0 |
| 2004-04-28 10:10:00 | AAPL | Stock | 0.4759 | 0.4759 | 0.4757 | 0.4759 | 120288.0 |
| 2004-04-28 10:11:00 | AAPL | Stock | 0.4763 | 0.4768 | 0.4759 | 0.4759 | 285320.0 |
| 2004-04-28 10:12:00 | AAPL | Stock | 0.4761 | 0.4763 | 0.4761 | 0.4763 | 147728.0 |
| 2004-04-28 10:13:00 | AAPL | Stock | 0.4763 | 0.4764 | 0.4763 | 0.4764 | 144648.0 |
| 2004-04-28 10:14:00 | AAPL | Stock | 0.4763 | 0.4766 | 0.4761 | 0.4766 | 205688.0 |
| 2004-04-28 10:15:00 | AAPL | Stock | 0.4768 | 0.4771 | 0.4764 | 0.4771 | 985992.0 |
| 2004-04-28 10:16:00 | AAPL | Stock | 0.4771 | 0.4773 | 0.4771 | 0.4771 | 240184.0 |
| 2004-04-28 10:17:00 | AAPL | Stock | 0.477 | 0.4771 | 0.477 | 0.477 | 22400.0 |
| 2004-04-28 10:18:00 | AAPL | Stock | 0.4768 | 0.4771 | 0.4768 | 0.477 | 159264.0 |
> showing 50 of 507,774 rows — these rows as CSV